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 <nitinpawar...@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 <
> karthiksrivasth...@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
>
