or higher version I guess.
>> Regards
>> Bejoy KS
>>
>> Sent from handheld, please excuse typos.
>>
>> From: Techy Teck
>> Date: Sat, 4 Aug 2012 00:35:20 -0700
>> To: ;
>> ReplyTo: user@hive.apache.org
>>
hy Teck
> *Date: *Sat, 4 Aug 2012 00:35:20 -0700
> *To: *;
> *ReplyTo: * user@hive.apache.org
> *Subject: *Re: Passing date as command line arguments
>
> Hi Bejoy,
>
> I found something very strange. When I actually viewed the Hive log file,
> I found something like
-
From: Techy Teck
Date: Sat, 4 Aug 2012 00:35:20
To: ;
Reply-To: user@hive.apache.org
Subject: Re: Passing date as command line arguments
Hi Bejoy,
I found something very strange. When I actually viewed the Hive log file, I
found something like this- See the thing in red color. Why is
m: * Techy Teck
> *Date: *Sat, 4 Aug 2012 00:30:41 -0700
> *To: *;
> *ReplyTo: * user@hive.apache.org
> *Subject: *Re: Passing date as command line arguments
>
> I cannot try that on Higher version of Hive as I am working in a company
> where they have installed only Hive 0.6
quot;adjacencyList":"]"},"stageList":"]","done":"true","started":"true"}"
TIME="1344065629745"*
On Sat, Aug 4, 2012 at 12:30 AM, Techy Teck wrote:
> I cannot try that on Higher version of Hive as I am work
Sent from handheld, please excuse typos.
-Original Message-
From: Techy Teck
Date: Sat, 4 Aug 2012 00:30:41
To: ;
Reply-To: user@hive.apache.org
Subject: Re: Passing date as command line arguments
I cannot try that on Higher version of Hive as I am working in a company
where they have
ll. 0.9 should be good.
>
>
> Regards
> Bejoy KS
>
> Sent from handheld, please excuse typos.
> --
> *From: * Techy Teck
> *Date: *Sat, 4 Aug 2012 00:26:44 -0700
> *To: *;
> *ReplyTo: * user@hive.apache.org
> *Subject: *Re: Passing da
handheld, please excuse typos.
> --
> *From: * "Bejoy KS"
> *Date: *Sat, 4 Aug 2012 07:24:37 +
> *To: *
> *ReplyTo: * user@hive.apache.org
> *Subject: *Re: Passing date as command line arguments
>
> I tried the same query on my e
120709';
>> Regards
>> Bejoy KS
>>
>> Sent from handheld, please excuse typos.
>> --
>> *From: * Techy Teck
>> *Date: *Sat, 4 Aug 2012 00:07:07 -0700
>> *To: *; Bejoy Ks
>> *ReplyTo: * user@hive.apache.org
>&
To:
Reply-To: user@hive.apache.org
Subject: Re: Passing date as command line arguments
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
ssues.
>
> By de way the data type for 'dt' is String itself right?
> Regards
> Bejoy KS
>
> Sent from handheld, please excuse typos.
> --
> *From: * Techy Teck
> *Date: *Sat, 4 Aug 2012 00:21:37 -0700
> *To: *;
> *ReplyTo: * user
y-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
t * from lip_data_quality where dt='20120709';
> Regards
> Bejoy KS
>
> Sent from handheld, please excuse typos.
> --
> *From: * Techy Teck
> *Date: *Sat, 4 Aug 2012 00:07:07 -0700
> *To: *; Bejoy Ks
> *ReplyTo: * user@hive.apache.org
> *S
-
From: Techy Teck
Date: Sat, 4 Aug 2012 00:07:07
To: ; Bejoy Ks
Reply-To: 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="13
n Fri, Aug 3, 2012 at 11:58 PM, Techy Teck 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
executed?
>
> Regards,
> Bejoy KS
>
> --
> *From:* Techy Teck
> *To:* user@hive.apache.org
> *Cc:* Vijay Dirisala
> *Sent:* Saturday, August 4, 2012 12:11 PM
> *Subject:* Re: Passing date as command line arguments
>
> Thanks Vijay for the suggestion. I also trie
g executed?
Regards,
Bejoy KS
From: Techy Teck
To: user@hive.apache.org
Cc: Vijay Dirisala
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
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 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
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 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 wrote:
>>
>> I
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 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_quali
I tried that. But it's not working for me. I didn't got any result.
Any other suggestion?
On Fri, Aug 3, 2012 at 7:41 PM, Matt Tucker wrote:
> Yes, that should do the trick for you.
>
>
>
> On Aug 3, 2012, at 10:17 PM, Techy Teck wrote:
>
> So you are saying, I should invoke like this below?
Hi,
In the command line, you want to wrap 20120709 in double-quotes, as they get
stripped when being passed into the hiveconf variable.
Matt
On Aug 3, 2012, at 6:48 PM, Techy Teck wrote:
> I have my below query in test1.hql file. I am trying to pass the date (dt) as
> the command line argu
22 matches
Mail list logo