Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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 !!!
>
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB