I tried the same query on my end, It is working fine for me without any issues.
By de way the data type for 'dt' is String itself right?
Regards
Bejoy KS
Sent from handheld, please excuse typos.
-----Original Message-----
From: Techy Teck <comptechge...@gmail.com>
Date: Sat, 4 Aug 2012 00:21:37
To: <user@hive.apache.org>; <bejoy...@yahoo.com>
Reply-To: user@hive.apache.org
Subject: Re: Passing date as command line arguments
I was not able to understand. So what changes I need to make? This is my
below *hivetest1.hql-*
*
*
*select * from lip_data_quality where dt = '${hiveconf:start_date}';*
*
*
And by this I am executing the above hql file-
*hive -f hivetest1.hql -hiveconf start_date=20120709*
*
*
*
*
Any thoughts what changes I need to make?
On Sat, Aug 4, 2012 at 12:16 AM, Bejoy KS <bejoy...@yahoo.com> wrote:
> **
> Yes.
>
> From the logs the query being executed is
> select * from lip_data_quality where dt=20120709
>
> But here the dt is not in quotes. It should be like
> select * from lip_data_quality where dt='20120709';
> Regards
> Bejoy KS
>
> Sent from handheld, please excuse typos.
> ------------------------------
> *From: * Techy Teck <comptechge...@gmail.com>
> *Date: *Sat, 4 Aug 2012 00:07:07 -0700
> *To: *<user@hive.apache.org>; Bejoy Ks<bejoy...@yahoo.com>
> *ReplyTo: * user@hive.apache.org
> *Subject: *Re: Passing date as command line arguments
>
> I found this thing from the Hive log. This is what you are looking for?-
>
> *SessionStart SESSION_ID="rjamal_201208041359" TIME="1344063565655"*
> *QueryStart QUERY_STRING="select * from lip_data_quality where
> dt=20120709"
> QUERY_ID="rjamal_20120804135959_58e245e8-086a-47c2-9ed3-6b952e4a5486"
> TIME="1344063597488"*
> *Counters
> plan="{"queryId":"rjamal_20120804135959_58e245e8-086a-47c2-9ed3-6b952e4a5486","queryType":null,"queryAttributes":{"queryString":"select
> * from lip_data_quality where dt=20120709"},"queryCo*
> *unters":"null","stageGraph":{"nodeType":"1","roots":"null","adjacencyList":"]"},"stageList":"]","done":"false","started":"true"}"
> TIME="1344063597501"*
> *QueryEnd QUERY_STRING="select * from lip_data_quality where dt=20120709"
> QUERY_ID="rjamal_20120804135959_58e245e8-086a-47c2-9ed3-6b952e4a5486"
> QUERY_RET_CODE="0" QUERY_NUM_TASKS="0" TIME="134406359*
> *7503"*
> *Counters
> plan="{"queryId":"rjamal_20120804135959_58e245e8-086a-47c2-9ed3-6b952e4a5486","queryType":null,"queryAttributes":{"queryString":"select
> * from lip_data_quality where dt=20120709"},"queryCo*
> *unters":"null","stageGraph":{"nodeType":"1","roots":"null","adjacencyList":"]"},"stageList":"]","done":"true","started":"true"}"
> TIME="1344063597504"*
> *
> *
> *
> *
>
>
>
> On Fri, Aug 3, 2012 at 11:58 PM, Techy Teck <comptechge...@gmail.com>wrote:
>
>> Yes that query gives me the result back correctly.
>>
>> How can I see the hive log Bejoy? Basically I am not sure which hive log
>> and what is the path where I can see that thing?
>>
>>
>>
>>
>>
>>
>> On Fri, Aug 3, 2012 at 11:52 PM, Bejoy Ks <bejoy...@yahoo.com> wrote:
>>
>>> 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
>>> >>
>>> >>
>>> >
>>>
>>>
>>>
>>>
>>>
>>
>
