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
Nitin Pawar 2013-07-19, 08:16
You may have to write a udf to do the actions performed by the script as a
function side query
or use your query in transformed by clause and you will have to manipulate
data with subqueries
On Fri, Jul 19, 2013 at 1:28 PM, Jérôme Verdier
<[EMAIL PROTECTED]>wrote:

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