Variable support was not added until hive 0.7.0
On Sat, Aug 4, 2012 at 3:58 AM, Lefty Leverenz wrote:
> Does Hive 0.6 support underscores in variable names?
>
> Just a thought. The examples I've seen contain letters and dots (".") but
> no other characters.
>
> – Lefty
>
>
>
>
> On Sat, Aug 4,
Does Hive 0.6 support underscores in variable names?
Just a thought. The examples I've seen contain letters and dots (".") but
no other characters.
– Lefty
On Sat, Aug 4, 2012 at 12:39 AM, Bejoy KS wrote:
> **
> Yes that is the right issue. Variable substitution is not happening. I
> can't
Yes that is the right issue. Variable substitution is not happening. I can't
say much here as I haven't tried out this on 0.6 . The code on my blog post is
based on 0.7 or higher version I guess.
Regards
Bejoy KS
Sent from handheld, please excuse typos.
-Original Message-
From: Techy
Yup, I will try that out. I send out the latest email. Can you check why is
it happening like this?
On Sat, Aug 4, 2012 at 12:35 AM, Bejoy KS wrote:
> **
> You can try it out on a local installation and test it against the later
> versions.
>
> As I pointed out, I just tested on hive 0.9 and
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 it like so?
*SessionStart SESSION_ID="rjamal_201208041433" TIME="1344065620956"*
*QueryStart QUERY_STRING=" select * from lip_data_quality where dt =
You can try it out on a local installation and test it against the later
versions.
As I pointed out, I just tested on hive 0.9 and it was working good for me.
I guess you should recommend an upgrade of hive in your cluster as well. Hive
has gone far too ahead after 0.6 . :)
Regards
Bejoy KS
Se
I cannot try that on Higher version of Hive as I am working in a company
where they have installed only Hive 0.6 on the Ares cluster.
:(
On Sat, Aug 4, 2012 at 12:29 AM, Bejoy KS wrote:
> **
>
> Try it on a higher version of hive and let me know if that doesn't work
> still. 0.9 should be go
I am on Hive 0.6.
And when I tried executing using like this (*hive -f hivetest1.hql
-hiveconf start_date=20120709*). And after that when I tried viewing the
log file. I found only the below thing that's all. Why? Any idea?
*SessionStart SESSION_ID="rjamal_201208041409" TIME="1344064163296"*
On
Try it on a higher version of hive and let me know if that doesn't work still.
0.9 should be good.
Regards
Bejoy KS
Sent from handheld, please excuse typos.
-Original Message-
From: Techy Teck
Date: Sat, 4 Aug 2012 00:26:44
To: ;
Reply-To: user@hive.apache.org
Subject: Re: Passing
Hi Techy
Which version of hive are you on?
I'm on hive 0.9 and I'm sure I have executed similar scripts in hive 0.7 as
well.
Regards
Bejoy KS
Sent from handheld, please excuse typos.
-Original Message-
From: "Bejoy KS"
Date: Sat, 4 Aug 2012 07:24:37
To:
Reply-To: user@hive.apache.o
Yes it is String for me here.
This is the table structure by the way-
*create table lip_data_quality*
*( buyer_id bigint,*
* total_chkout bigint,*
* total_errpds bigint*
* )*
* partitioned by (dt string)*
*row format delimited fields terminated by '\t'*
*stored as sequencefile*
*location '/apps
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
Date: Sat, 4 Aug 2012 00:21:37
To: ;
Reply-To: user@
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 wh
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.
-Original Message-
From: T
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="1344
15 matches
Mail list logo
