hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nitin Pawar <nitinpawar...@gmail.com>
Subject Re: List of dates as arguments
Date Sun, 24 Aug 2014 07:57:56 GMT
I am not sure if you can transform array from shell to java, you may want
to write your own custom UDF for that

if these are continuous dates, then you can have less than greater than
comparison


On Sun, Aug 24, 2014 at 12:39 PM, karthik Srivasthava <
karthiksrivasthava@gmail.com> wrote:

> Nitin,
> Teja
>
> Thank you.. I exactly need what Teja suggested... i need list of dates
> between start date and end date....
>
>
> On Sun, Aug 24, 2014 at 2:05 AM, Teja Kunapareddy <
> tejakunapareddy@gmail.com> wrote:
>
>> Thanks Nithin For your reply.. I can get start date and end date,. But
>> can i get all the dates with in START DATE AND END DATE.??? . so that my
>> query looks something like this
>>
>> "Select  a, b, c from table_x where date in  (${hiveconf:LIST_OF DATES})"
>>
>>
>>
>> On 24 August 2014 01:18, Nitin Pawar <nitinpawar432@gmail.com> wrote:
>>
>>> with your shell script calculate your start date and end date
>>> hive $HIVEPARAMS -hiveconf startdate="$var1"  -hiveconf enddate="$var2"
>>>
>>> also set in ..hiverc
>>> set hive.variable.substitute=true;
>>>
>>>
>>> On Sun, Aug 24, 2014 at 10:19 AM, karthik Srivasthava <
>>> karthiksrivasthava@gmail.com> wrote:
>>>
>>>> As my raw-data table is partitioned by date.. i want to get data to run
>>>> a query every days to find top 10 products in last 15 days .
>>>>
>>>> How to pass list of dates dynamically as arguments in hive query using
>>>> hiveconf?
>>>>
>>>>
>>>>
>>>
>>>
>>> --
>>> Nitin Pawar
>>>
>>
>>
>


-- 
Nitin Pawar

Mime
View raw message