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 wrote:
> Hi Techy
>
> Are you getting the results for the same query direc
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?
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?
Is it possible to use the HBaseStorage Handler with the AvroSerDe in Hive?
I would think it would end up with an Avro record for the key via AvroKey
and a record via AvroValue for each Column Family.
Hi,
Try the following statement instead:
Select *
from orderdetails
left semi join (
select orderid
from orders
left semi join sites on
orders.siteid = sites.siteid
) orders on
orderdetails.orderid = orders.orderid;
Matt
On Aug 3, 2012
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
I need to enable Sequence File with Block Compression data. Below is the
table which will be stored as SequenceFile.
*create table lip_data_quality*
*( buyer_id bigint,*
* total_chkout bigint,*
* total_errpds bigint*
* )*
* partitioned by (dt string)*
*row format deli
Hi Hive users,
According to the grammar for Joins at
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Joins,
Hive should be able to parse joins where the table reference on the
right-hand side is itself a join. For instance, one should be able to
specify (a join (b join c)) as:
Thanks Bejoy. That worked.
On Fri, Aug 3, 2012 at 12:05 AM, Bejoy Ks wrote:
> Hi Techy
>
> Try using hadoop fs -text
>
> That should give the output in some readable format.
>
> Regards,
> Bejoy KS
>
> --
> *From:* Techy Teck
> *To:* user@hive.apache.org
> *Sent:*
Hi Techy
Try using hadoop fs -text
That should give the output in some readable format.
Regards,
Bejoy KS
From: Techy Teck
To: user@hive.apache.org
Sent: Friday, August 3, 2012 7:25 AM
Subject: decompress the file that has been compressed in LzoCodec forma
13 matches
Mail list logo