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
<verdier.jerom...@gmail.com>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 <verdier.jerom...@gmail.com>
>
>> 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
