Bala,
I think they need an array substitution instead of string as hiveconf
variable substitution
On Sun, Aug 24, 2014 at 11:55 PM, Bala Krishna Gangisetty <
b...@altiscale.com> wrote:
> Here is my understanding on your requirements. Let me know if I am missing
> something. You,
>
> a) would like to run a query daily to find top 10 products in the past 15
> days
> b) would like to pass dates dynamically as arguments to HIVE query
>
> Given the requirement a), passing just two variables(startdate and
> enddate) to HIVE query will suffice to achieve the requirement b).
>
> Assuming startdate and enddate variables are passed to HIVE query, the
> query will look like below.
>
> SELECT * FROM *table_name* WHERE *date_column* BETWEEN
> *${hiveconf:startdate}* AND *${hiveconf:enddate}*
>
> Note, values for startdate and enddate must be enclosed in ' '.
>
> Hope this helps.
>
> --Bala G.
>
>
> On Sun, Aug 24, 2014 at 12:57 AM, Nitin Pawar <nitinpawar...@gmail.com>
> wrote:
>
>> 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 <
>> karthiksrivasth...@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 <
>>> tejakunapare...@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 <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
>>>>>
>>>>
>>>>
>>>
>>
>>
>> --
>> Nitin Pawar
>>
>
>
--
Nitin Pawar
