Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Calling Hive script in another Hive script


Copy link to this message
-
Re: Calling Hive script in another Hive script
Wrong manipulation, mail was sent but not finished...

so, the script who call another script is here :

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( --
script call
                ods.package_date.fcalc_idjour( -- Script call

What is the best way to do this in Hive ?
2013/7/19 Jérôme Verdier <[EMAIL PROTECTED]>

> 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 !!!
>
>