Hi Techy
Are you getting the results for the same query directly from CLI, I mean does
the below query return correct results
select * from lip_data_quality where dt = '20120709';
If the above query returns results, can you check the hive logs and see what is
the actual query being executed?
Regards,
Bejoy KS
________________________________
From: Techy Teck <comptechge...@gmail.com>
To: user@hive.apache.org
Cc: Vijay Dirisala <tec...@gmail.com>
Sent: Saturday, August 4, 2012 12:11 PM
Subject: Re: Passing date as command line arguments
Thanks Vijay for the suggestion. I also tried that and it still didn't worked
for me.
Any thoughts why it is not working?
On Fri, Aug 3, 2012 at 11:32 PM, Vijay <tec...@gmail.com> wrote:
There can't be a space in the variable name. Try this: ${hiveconf:start_date}
>
>
>On Fri, Aug 3, 2012 at 11:06 PM, Techy Teck <comptechge...@gmail.com> wrote:
>> Can anyone help me out on this?
>>
>> I am stuck on this and I have no clue what wrong I am doing?
>>
>>
>>
>>
>> On Fri, Aug 3, 2012 at 3:48 PM, Techy Teck <comptechge...@gmail.com> wrote:
>>>
>>> I have my below query in test1.hql file. I am trying to pass the date (dt)
>>> as the command line argument.
>>>
>>>
>>> select * from lip_data_quality where dt = '${hiveconf: start_date}';
>>>
>>>
>>> So whenever I try to run the above test1.hql file like this-
>>>
>>> hive -f hivetest1.hql -hiveconf start_date=20120709
>>>
>>> I get zero records back. But the data is there in that table for that
>>> date. Why is it so? Something wrong I am doing?
>>>
>>> Can anyone help me out here? I was following Bejoy's Article here
>>> http://kickstarthadoop.blogspot.com/2011/10/include-values-during-execution-time-in.html
>>>
>>>
>>
>
