hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From karthik Srivasthava <karthiksrivasth...@gmail.com>
Subject Re: List of dates as arguments
Date Sun, 24 Aug 2014 07:09:15 GMT
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
>>
>
>

Mime
View raw message