Could you upload DDLs for those tables? Thanks.
2013/8/8 Jérôme Verdier :
> Hi,
>
> I encountered a problem with Right Outer Join in Hive.
>
> Here is where is the problem :
>
> FROM default.ca ca
> JOIN default.kpi_magasin mtransf
> ON mtransf.co_societe = (CASE WHEN
Yes, when you set a property via the 'set' command on the Hive CLI, they
live for the life of that particular client session.
There is not 'golden rule' that increases your performance; it all depends
on your installation, data and query pattern. Based on these you can
consider leveraging some joi
[mailto:vikas.srivast...@one97.net]
Sent: Tuesday, October 11, 2011 8:57 PM
To: user@hive.apache.org
Subject: RE: problem in hive
Yup!!!
With Regards
Vikas Srivastava
DWH & Analytics Team
M: +91 9560885900
P: + 91 120 4770102
Email: vikas.srivast...@one97.net
W: www.one97world.com
O
To: user@hive.apache.org
Subject: Re: problem in hive
Is it hive database created in MySQL ??
On Tue, Oct 11, 2011 at 5:55 PM, Vikas Srivastava
wrote:
that also i have dine.. i put msql connector in that lib
On Tue, Oct 11, 2011 at 5:39 PM, Ankit Jain wrote:
Hello Vikas,
I think yo
Is it hive database created in MySQL ??
On Tue, Oct 11, 2011 at 5:55 PM, Vikas Srivastava <
vikas.srivast...@one97.net> wrote:
> that also i have dine.. i put msql connector in that lib
>
> On Tue, Oct 11, 2011 at 5:39 PM, Ankit Jain wrote:
>
>> Hello Vikas,
>>
>> I think you have to put the mysq
that also i have dine.. i put msql connector in that lib
On Tue, Oct 11, 2011 at 5:39 PM, Ankit Jain wrote:
> Hello Vikas,
>
> I think you have to put the mysql Driver in lib dir of hive.
>
> Thanks,
> Ankit
>
> On Tue, Oct 11, 2011 at 5:18 PM, Vikas Srivastava <
> vikas.srivast...@one97.net> wr
Hello Vikas,
I think you have to put the mysql Driver in lib dir of hive.
Thanks,
Ankit
On Tue, Oct 11, 2011 at 5:18 PM, Vikas Srivastava <
vikas.srivast...@one97.net> wrote:
> hey thanks for replay but already have at that place..
>
> 2011/10/11 Harold(陳春宏)
>
>>
>>
>> You have to add jar file
hey thanks for replay but already have at that place..
2011/10/11 Harold(陳春宏)
>
>
> You have to add jar file like this
> add jar ../hive-0.6.0/lib/hive_contrib.jar;
>
>
>
> Best Regard
> Mail: harold.c...@sunplus-technology.com
> MSN: chen0...@hotmail.com
> SKYPE: chen0727
> Mobil: 886-9375
You have to add jar file like this
add jar ../hive-0.6.0/lib/hive_contrib.jar;
Best Regard
Mail: harold.c...@sunplus-technology.com
MSN: chen0...@hotmail.com
SKYPE: chen0727
Mobil: 886-937545215
Tel: 886-2-8798-2988 #222
Fax:886-2-8751-5499
-Original Message-
From: vikas srivasta
Hey Ashu!!1
i have given full permission to hadoop user on new server(A) with user name
and password.
it can only read those tables made by this server(A) and desc them,
and from other server(B) we cant be able to read tables created by this
server(A).
regards
Vikas Srivastava
On Thu, Aug 25,
hey ashutosh,
thanks for reply..
the output of that is
*Failed with exception null
FAILED: Execution Error, return code 1 from org.apache.hado**op.hive.ql.exec
**.DDLTask*
regards
Vikas Srivastava
On Thu, Aug 25, 2011 at 4:52 AM, Ashutosh Chauhan wrote:
> Vikas,
> Looks like your metadata i
Vikas,
Looks like your metadata is corrupted. Can you paste the output of
following:
hive> describe formatted aircel_obd;
Ashutosh
On Wed, Aug 24, 2011 at 03:46, Vikas Srivastava
wrote:
> hey thanks for reply,
>
> i m using hadoop 0.20.2,
> and hive: 0.7.0
>
> i have install hive on new server a
hey thanks for reply,
i m using hadoop 0.20.2,
and hive: 0.7.0
i have install hive on new server and making that use readonly ,
On Wed, Aug 24, 2011 at 4:05 PM, Chinna wrote:
> Hi,
>
> ** **
>
>Can u post some more details like which version u r using and what
> sequence of queries u
Hi,
Can u post some more details like which version u r using and what
sequence of queries u have executed.
When I checked the trunk code this exception will come when getCols()
returns null. Check u r metadata is in good state or not.
Thanks
Chinna Rao Lalam
-- Forwarded message
14 matches
Mail list logo
