Calling Hive script in another Hive script

[Jérôme Verdier]

Hi,

I'm working on another PL/SQL script, and i have to translate it in HiveQL.

This PL/SQL script is calling another script, like this :

SELECT
                cal.dt_jour_deb
                FROM default.calendrier_hebdo cal -- Importer
ods.calendrier_hebdo
              WHERE cal.co_societe = '${hiveconf:in_co_societe}'
              AND cal.co_an_semaine = ods.package_date.get_semaine( --
Appel package !!!
                ods.package_date.fcalc_idjour( -- Appel package !!!