You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by vikas srivastava <vi...@one97.net> on 2011/10/11 09:29:02 UTC
problem in hive
Hi All,
I facing a problem like I have installed hive on a new server and provide
the connectivity with the namenode,
Create a user in mysql and give the proper privileges to that user,
Put that user in hive-site.xml and now when I fired a query like
Show tables;
Not showing any table
when I fired
Desc table or select table is throwing an error
hive> desc aircel_obd;
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask
The hive.log are :-
2011-10-11 12:25:30,131 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.resources" but it cannot be resolved.
2011-10-11 12:25:30,131 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.resources" but it cannot be resolved.
2011-10-11 12:25:30,134 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.runtime" but it cannot be resolved.
2011-10-11 12:25:30,134 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.runtime" but it cannot be resolved.
2011-10-11 12:25:30,135 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.text" but it cannot be resolved.
2011-10-11 12:25:30,135 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.text" but it cannot be resolved.
2011-10-11 12:25:35,031 ERROR ql.Driver (SessionState.java:printError(365))
- FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask
2011-10-11 12:45:14,146 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.resources" but it cannot be resolved.
2011-10-11 12:45:14,146 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.resources" but it cannot be resolved.
2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.runtime" but it cannot be resolved.
2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.runtime" but it cannot be resolved.
2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.text" but it cannot be resolved.
2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.text" but it cannot be resolved.
2011-10-11 12:45:21,053 ERROR ql.Driver (SessionState.java:printError(365))
- FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask
Please help I m stuck here....
With Regards
Vikas Srivastava
DWH & Analytics Team
M: +91 9560885900
P: + 91 120 4770102
Email: vikas.srivastava@one97.net
W: www.one97world.com
One97 | Let's get talking !
RE: problem in hive
Posted by "Harold (陳春宏)" <ha...@sunplus-technology.com>.
You have to add jar file like this
add jar ../hive-0.6.0/lib/hive_contrib.jar;
Best Regard
Mail: Harold.Chen@sunplus-technology.com
MSN: chen0727@hotmail.com
SKYPE: chen0727
Mobil: 886-937545215
Tel: 886-2-8798-2988 #222
Fax:886-2-8751-5499
-----Original Message-----
From: vikas srivastava [mailto:vikas.srivastava@one97.net]
Sent: Tuesday, October 11, 2011 3:29 PM
To: user@hive.apache.org
Subject: problem in hive
Hi All,
I facing a problem like I have installed hive on a new server and provide
the connectivity with the namenode,
Create a user in mysql and give the proper privileges to that user,
Put that user in hive-site.xml and now when I fired a query like
Show tables;
Not showing any table
when I fired
Desc table or select table is throwing an error
hive> desc aircel_obd;
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask
The hive.log are :-
2011-10-11 12:25:30,131 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.resources" but it cannot be resolved.
2011-10-11 12:25:30,131 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.resources" but it cannot be resolved.
2011-10-11 12:25:30,134 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.runtime" but it cannot be resolved.
2011-10-11 12:25:30,134 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.runtime" but it cannot be resolved.
2011-10-11 12:25:30,135 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.text" but it cannot be resolved.
2011-10-11 12:25:30,135 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.text" but it cannot be resolved.
2011-10-11 12:25:35,031 ERROR ql.Driver (SessionState.java:printError(365))
- FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask
2011-10-11 12:45:14,146 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.resources" but it cannot be resolved.
2011-10-11 12:45:14,146 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.resources" but it cannot be resolved.
2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.runtime" but it cannot be resolved.
2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.runtime" but it cannot be resolved.
2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.text" but it cannot be resolved.
2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.text" but it cannot be resolved.
2011-10-11 12:45:21,053 ERROR ql.Driver (SessionState.java:printError(365))
- FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask
Please help I m stuck here....
With Regards
Vikas Srivastava
DWH & Analytics Team
M: +91 9560885900
P: + 91 120 4770102
Email: vikas.srivastava@one97.net
W: www.one97world.com
One97 | Let's get talking !
RE: problem in hive
Posted by "Harold (陳春宏)" <ha...@sunplus-technology.com>.
Maybe you have check config file again
Or put your hive config file on mail
Best Regard
Mail: Harold.Chen@sunplus-technology.com
MSN: chen0727@hotmail.com
SKYPE: chen0727
Mobil: 886-937545215
Tel: 886-2-8798-2988 #222
Fax:886-2-8751-5499
From: vikas srivastava [mailto:vikas.srivastava@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.srivastava@one97.net
W: www.one97world.com
One97 | Let's get talking !
From: Ankit Jain [mailto:ankitjaincs06@gmail.com]
Sent: Tuesday, October 11, 2011 6:22 PM
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 <vi...@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 <an...@gmail.com> 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 <vi...@one97.net> wrote:
hey thanks for replay but already have at that place..
2011/10/11 Harold(陳春宏) <ha...@sunplus-technology.com>
You have to add jar file like this
add jar ../hive-0.6.0/lib/hive_contrib.jar;
Best Regard
Mail: Harold.Chen@sunplus-technology.com
MSN: chen0727@hotmail.com
SKYPE: chen0727
Mobil: 886-937545215
Tel: 886-2-8798-2988 #222
Fax:886-2-8751-5499
-----Original Message-----
From: vikas srivastava [mailto:vikas.srivastava@one97.net]
Sent: Tuesday, October 11, 2011 3:29 PM
To: user@hive.apache.org
Subject: problem in hive
Hi All,
I facing a problem like I have installed hive on a new server and provide
the connectivity with the namenode,
Create a user in mysql and give the proper privileges to that user,
Put that user in hive-site.xml and now when I fired a query like
Show tables;
Not showing any table
when I fired
Desc table or select table is throwing an error
hive> desc aircel_obd;
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask
The hive.log are :-
2011-10-11 12:25:30,131 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.resources" but it cannot be resolved.
2011-10-11 12:25:30,131 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.resources" but it cannot be resolved.
2011-10-11 12:25:30,134 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.runtime" but it cannot be resolved.
2011-10-11 12:25:30,134 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.runtime" but it cannot be resolved.
2011-10-11 12:25:30,135 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.text" but it cannot be resolved.
2011-10-11 12:25:30,135 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.text" but it cannot be resolved.
2011-10-11 12:25:35,031 ERROR ql.Driver (SessionState.java:printError(365))
- FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask
2011-10-11 12:45:14,146 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.resources" but it cannot be resolved.
2011-10-11 12:45:14,146 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.resources" but it cannot be resolved.
2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.runtime" but it cannot be resolved.
2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.runtime" but it cannot be resolved.
2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.text" but it cannot be resolved.
2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.text" but it cannot be resolved.
2011-10-11 12:45:21,053 ERROR ql.Driver (SessionState.java:printError(365))
- FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask
Please help I m stuck here....
With Regards
Vikas Srivastava
DWH & Analytics Team
M: +91 9560885900
P: + 91 120 4770102
Email: vikas.srivastava@one97.net
W: www.one97world.com
One97 | Let's get talking !
--
With Regards
Vikas Srivastava
DWH & Analytics Team
Mob:+91 9560885900
One97 | Let's get talking !
--
With Regards
Vikas Srivastava
DWH & Analytics Team
Mob:+91 9560885900
One97 | Let's get talking !
RE: problem in hive
Posted by vikas srivastava <vi...@one97.net>.
Yup!!!!!!!
With Regards
Vikas Srivastava
DWH & Analytics Team
M: +91 9560885900
P: + 91 120 4770102
Email: vikas.srivastava@one97.net
W: www.one97world.com
One97 | Let's get talking !
From: Ankit Jain [mailto:ankitjaincs06@gmail.com]
Sent: Tuesday, October 11, 2011 6:22 PM
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 <vi...@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 <an...@gmail.com> 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 <vi...@one97.net> wrote:
hey thanks for replay but already have at that place..
2011/10/11 Harold(陳春宏) <ha...@sunplus-technology.com>
You have to add jar file like this
add jar ../hive-0.6.0/lib/hive_contrib.jar;
Best Regard
Mail: Harold.Chen@sunplus-technology.com
MSN: chen0727@hotmail.com
SKYPE: chen0727
Mobil: 886-937545215
Tel: 886-2-8798-2988 #222
Fax:886-2-8751-5499
-----Original Message-----
From: vikas srivastava [mailto:vikas.srivastava@one97.net]
Sent: Tuesday, October 11, 2011 3:29 PM
To: user@hive.apache.org
Subject: problem in hive
Hi All,
I facing a problem like I have installed hive on a new server and provide
the connectivity with the namenode,
Create a user in mysql and give the proper privileges to that user,
Put that user in hive-site.xml and now when I fired a query like
Show tables;
Not showing any table
when I fired
Desc table or select table is throwing an error
hive> desc aircel_obd;
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask
The hive.log are :-
2011-10-11 12:25:30,131 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.resources" but it cannot be resolved.
2011-10-11 12:25:30,131 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.resources" but it cannot be resolved.
2011-10-11 12:25:30,134 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.runtime" but it cannot be resolved.
2011-10-11 12:25:30,134 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.runtime" but it cannot be resolved.
2011-10-11 12:25:30,135 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.text" but it cannot be resolved.
2011-10-11 12:25:30,135 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.text" but it cannot be resolved.
2011-10-11 12:25:35,031 ERROR ql.Driver (SessionState.java:printError(365))
- FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask
2011-10-11 12:45:14,146 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.resources" but it cannot be resolved.
2011-10-11 12:45:14,146 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.resources" but it cannot be resolved.
2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.runtime" but it cannot be resolved.
2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.runtime" but it cannot be resolved.
2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.text" but it cannot be resolved.
2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.text" but it cannot be resolved.
2011-10-11 12:45:21,053 ERROR ql.Driver (SessionState.java:printError(365))
- FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask
Please help I m stuck here....
With Regards
Vikas Srivastava
DWH & Analytics Team
M: +91 9560885900
P: + 91 120 4770102
Email: vikas.srivastava@one97.net
W: www.one97world.com
One97 | Let's get talking !
--
With Regards
Vikas Srivastava
DWH & Analytics Team
Mob:+91 9560885900
One97 | Let's get talking !
--
With Regards
Vikas Srivastava
DWH & Analytics Team
Mob:+91 9560885900
One97 | Let's get talking !
Re: problem in hive
Posted by Ankit Jain <an...@gmail.com>.
Is it hive database created in MySQL ??
On Tue, Oct 11, 2011 at 5:55 PM, Vikas Srivastava <
vikas.srivastava@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 <an...@gmail.com>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.srivastava@one97.net> wrote:
>>
>>> hey thanks for replay but already have at that place..
>>>
>>> 2011/10/11 Harold(陳春宏) <ha...@sunplus-technology.com>
>>>
>>>>
>>>>
>>>> You have to add jar file like this
>>>> add jar ../hive-0.6.0/lib/hive_contrib.jar;
>>>>
>>>>
>>>>
>>>> Best Regard
>>>> Mail: Harold.Chen@sunplus-technology.com
>>>> MSN: chen0727@hotmail.com
>>>> SKYPE: chen0727
>>>> Mobil: 886-937545215
>>>> Tel: 886-2-8798-2988 #222
>>>> Fax:886-2-8751-5499
>>>>
>>>> -----Original Message-----
>>>> From: vikas srivastava [mailto:vikas.srivastava@one97.net]
>>>> Sent: Tuesday, October 11, 2011 3:29 PM
>>>> To: user@hive.apache.org
>>>> Subject: problem in hive
>>>>
>>>> Hi All,
>>>>
>>>> I facing a problem like I have installed hive on a new server and
>>>> provide
>>>> the connectivity with the namenode,
>>>>
>>>> Create a user in mysql and give the proper privileges to that user,
>>>>
>>>> Put that user in hive-site.xml and now when I fired a query like
>>>>
>>>> Show tables;
>>>> Not showing any table
>>>>
>>>> when I fired
>>>> Desc table or select table is throwing an error
>>>>
>>>> hive> desc aircel_obd;
>>>> FAILED: Execution Error, return code 1 from
>>>> org.apache.hadoop.hive.ql.exec.DDLTask
>>>>
>>>>
>>>> The hive.log are :-
>>>>
>>>> 2011-10-11 12:25:30,131 ERROR DataNucleus.Plugin
>>>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
>>>> "org.eclipse.core.resources" but it cannot be resolved.
>>>> 2011-10-11 12:25:30,131 ERROR DataNucleus.Plugin
>>>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
>>>> "org.eclipse.core.resources" but it cannot be resolved.
>>>> 2011-10-11 12:25:30,134 ERROR DataNucleus.Plugin
>>>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
>>>> "org.eclipse.core.runtime" but it cannot be resolved.
>>>> 2011-10-11 12:25:30,134 ERROR DataNucleus.Plugin
>>>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
>>>> "org.eclipse.core.runtime" but it cannot be resolved.
>>>> 2011-10-11 12:25:30,135 ERROR DataNucleus.Plugin
>>>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
>>>> "org.eclipse.text" but it cannot be resolved.
>>>> 2011-10-11 12:25:30,135 ERROR DataNucleus.Plugin
>>>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
>>>> "org.eclipse.text" but it cannot be resolved.
>>>> 2011-10-11 12:25:35,031 ERROR ql.Driver
>>>> (SessionState.java:printError(365))
>>>> - FAILED: Execution Error, return code 1 from
>>>> org.apache.hadoop.hive.ql.exec.DDLTask
>>>> 2011-10-11 12:45:14,146 ERROR DataNucleus.Plugin
>>>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
>>>> "org.eclipse.core.resources" but it cannot be resolved.
>>>> 2011-10-11 12:45:14,146 ERROR DataNucleus.Plugin
>>>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
>>>> "org.eclipse.core.resources" but it cannot be resolved.
>>>> 2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin
>>>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
>>>> "org.eclipse.core.runtime" but it cannot be resolved.
>>>> 2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin
>>>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
>>>> "org.eclipse.core.runtime" but it cannot be resolved.
>>>> 2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin
>>>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
>>>> "org.eclipse.text" but it cannot be resolved.
>>>> 2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin
>>>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
>>>> "org.eclipse.text" but it cannot be resolved.
>>>> 2011-10-11 12:45:21,053 ERROR ql.Driver
>>>> (SessionState.java:printError(365))
>>>> - FAILED: Execution Error, return code 1 from
>>>> org.apache.hadoop.hive.ql.exec.DDLTask
>>>>
>>>> Please help I m stuck here....
>>>>
>>>>
>>>> With Regards
>>>> Vikas Srivastava
>>>>
>>>> DWH & Analytics Team
>>>> M: +91 9560885900
>>>> P: + 91 120 4770102
>>>> Email: vikas.srivastava@one97.net
>>>> W: www.one97world.com
>>>>
>>>> One97 | Let's get talking !
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>> --
>>> With Regards
>>> Vikas Srivastava
>>>
>>> DWH & Analytics Team
>>> Mob:+91 9560885900
>>>
>>> One97 | Let's get talking !
>>>
>>>
>>
>
>
> --
> With Regards
> Vikas Srivastava
>
> DWH & Analytics Team
> Mob:+91 9560885900
> One97 | Let's get talking !
>
>
Re: problem in hive
Posted by Vikas Srivastava <vi...@one97.net>.
that also i have dine.. i put msql connector in that lib
On Tue, Oct 11, 2011 at 5:39 PM, Ankit Jain <an...@gmail.com> 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.srivastava@one97.net> wrote:
>
>> hey thanks for replay but already have at that place..
>>
>> 2011/10/11 Harold(陳春宏) <ha...@sunplus-technology.com>
>>
>>>
>>>
>>> You have to add jar file like this
>>> add jar ../hive-0.6.0/lib/hive_contrib.jar;
>>>
>>>
>>>
>>> Best Regard
>>> Mail: Harold.Chen@sunplus-technology.com
>>> MSN: chen0727@hotmail.com
>>> SKYPE: chen0727
>>> Mobil: 886-937545215
>>> Tel: 886-2-8798-2988 #222
>>> Fax:886-2-8751-5499
>>>
>>> -----Original Message-----
>>> From: vikas srivastava [mailto:vikas.srivastava@one97.net]
>>> Sent: Tuesday, October 11, 2011 3:29 PM
>>> To: user@hive.apache.org
>>> Subject: problem in hive
>>>
>>> Hi All,
>>>
>>> I facing a problem like I have installed hive on a new server and provide
>>> the connectivity with the namenode,
>>>
>>> Create a user in mysql and give the proper privileges to that user,
>>>
>>> Put that user in hive-site.xml and now when I fired a query like
>>>
>>> Show tables;
>>> Not showing any table
>>>
>>> when I fired
>>> Desc table or select table is throwing an error
>>>
>>> hive> desc aircel_obd;
>>> FAILED: Execution Error, return code 1 from
>>> org.apache.hadoop.hive.ql.exec.DDLTask
>>>
>>>
>>> The hive.log are :-
>>>
>>> 2011-10-11 12:25:30,131 ERROR DataNucleus.Plugin
>>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
>>> "org.eclipse.core.resources" but it cannot be resolved.
>>> 2011-10-11 12:25:30,131 ERROR DataNucleus.Plugin
>>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
>>> "org.eclipse.core.resources" but it cannot be resolved.
>>> 2011-10-11 12:25:30,134 ERROR DataNucleus.Plugin
>>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
>>> "org.eclipse.core.runtime" but it cannot be resolved.
>>> 2011-10-11 12:25:30,134 ERROR DataNucleus.Plugin
>>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
>>> "org.eclipse.core.runtime" but it cannot be resolved.
>>> 2011-10-11 12:25:30,135 ERROR DataNucleus.Plugin
>>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
>>> "org.eclipse.text" but it cannot be resolved.
>>> 2011-10-11 12:25:30,135 ERROR DataNucleus.Plugin
>>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
>>> "org.eclipse.text" but it cannot be resolved.
>>> 2011-10-11 12:25:35,031 ERROR ql.Driver
>>> (SessionState.java:printError(365))
>>> - FAILED: Execution Error, return code 1 from
>>> org.apache.hadoop.hive.ql.exec.DDLTask
>>> 2011-10-11 12:45:14,146 ERROR DataNucleus.Plugin
>>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
>>> "org.eclipse.core.resources" but it cannot be resolved.
>>> 2011-10-11 12:45:14,146 ERROR DataNucleus.Plugin
>>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
>>> "org.eclipse.core.resources" but it cannot be resolved.
>>> 2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin
>>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
>>> "org.eclipse.core.runtime" but it cannot be resolved.
>>> 2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin
>>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
>>> "org.eclipse.core.runtime" but it cannot be resolved.
>>> 2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin
>>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
>>> "org.eclipse.text" but it cannot be resolved.
>>> 2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin
>>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
>>> "org.eclipse.text" but it cannot be resolved.
>>> 2011-10-11 12:45:21,053 ERROR ql.Driver
>>> (SessionState.java:printError(365))
>>> - FAILED: Execution Error, return code 1 from
>>> org.apache.hadoop.hive.ql.exec.DDLTask
>>>
>>> Please help I m stuck here....
>>>
>>>
>>> With Regards
>>> Vikas Srivastava
>>>
>>> DWH & Analytics Team
>>> M: +91 9560885900
>>> P: + 91 120 4770102
>>> Email: vikas.srivastava@one97.net
>>> W: www.one97world.com
>>>
>>> One97 | Let's get talking !
>>>
>>>
>>>
>>>
>>
>>
>> --
>> With Regards
>> Vikas Srivastava
>>
>> DWH & Analytics Team
>> Mob:+91 9560885900
>>
>> One97 | Let's get talking !
>>
>>
>
--
With Regards
Vikas Srivastava
DWH & Analytics Team
Mob:+91 9560885900
One97 | Let's get talking !
Re: problem in hive
Posted by Ankit Jain <an...@gmail.com>.
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.srivastava@one97.net> wrote:
> hey thanks for replay but already have at that place..
>
> 2011/10/11 Harold(陳春宏) <ha...@sunplus-technology.com>
>
>>
>>
>> You have to add jar file like this
>> add jar ../hive-0.6.0/lib/hive_contrib.jar;
>>
>>
>>
>> Best Regard
>> Mail: Harold.Chen@sunplus-technology.com
>> MSN: chen0727@hotmail.com
>> SKYPE: chen0727
>> Mobil: 886-937545215
>> Tel: 886-2-8798-2988 #222
>> Fax:886-2-8751-5499
>>
>> -----Original Message-----
>> From: vikas srivastava [mailto:vikas.srivastava@one97.net]
>> Sent: Tuesday, October 11, 2011 3:29 PM
>> To: user@hive.apache.org
>> Subject: problem in hive
>>
>> Hi All,
>>
>> I facing a problem like I have installed hive on a new server and provide
>> the connectivity with the namenode,
>>
>> Create a user in mysql and give the proper privileges to that user,
>>
>> Put that user in hive-site.xml and now when I fired a query like
>>
>> Show tables;
>> Not showing any table
>>
>> when I fired
>> Desc table or select table is throwing an error
>>
>> hive> desc aircel_obd;
>> FAILED: Execution Error, return code 1 from
>> org.apache.hadoop.hive.ql.exec.DDLTask
>>
>>
>> The hive.log are :-
>>
>> 2011-10-11 12:25:30,131 ERROR DataNucleus.Plugin
>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
>> "org.eclipse.core.resources" but it cannot be resolved.
>> 2011-10-11 12:25:30,131 ERROR DataNucleus.Plugin
>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
>> "org.eclipse.core.resources" but it cannot be resolved.
>> 2011-10-11 12:25:30,134 ERROR DataNucleus.Plugin
>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
>> "org.eclipse.core.runtime" but it cannot be resolved.
>> 2011-10-11 12:25:30,134 ERROR DataNucleus.Plugin
>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
>> "org.eclipse.core.runtime" but it cannot be resolved.
>> 2011-10-11 12:25:30,135 ERROR DataNucleus.Plugin
>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
>> "org.eclipse.text" but it cannot be resolved.
>> 2011-10-11 12:25:30,135 ERROR DataNucleus.Plugin
>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
>> "org.eclipse.text" but it cannot be resolved.
>> 2011-10-11 12:25:35,031 ERROR ql.Driver
>> (SessionState.java:printError(365))
>> - FAILED: Execution Error, return code 1 from
>> org.apache.hadoop.hive.ql.exec.DDLTask
>> 2011-10-11 12:45:14,146 ERROR DataNucleus.Plugin
>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
>> "org.eclipse.core.resources" but it cannot be resolved.
>> 2011-10-11 12:45:14,146 ERROR DataNucleus.Plugin
>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
>> "org.eclipse.core.resources" but it cannot be resolved.
>> 2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin
>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
>> "org.eclipse.core.runtime" but it cannot be resolved.
>> 2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin
>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
>> "org.eclipse.core.runtime" but it cannot be resolved.
>> 2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin
>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
>> "org.eclipse.text" but it cannot be resolved.
>> 2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin
>> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
>> "org.eclipse.text" but it cannot be resolved.
>> 2011-10-11 12:45:21,053 ERROR ql.Driver
>> (SessionState.java:printError(365))
>> - FAILED: Execution Error, return code 1 from
>> org.apache.hadoop.hive.ql.exec.DDLTask
>>
>> Please help I m stuck here....
>>
>>
>> With Regards
>> Vikas Srivastava
>>
>> DWH & Analytics Team
>> M: +91 9560885900
>> P: + 91 120 4770102
>> Email: vikas.srivastava@one97.net
>> W: www.one97world.com
>>
>> One97 | Let's get talking !
>>
>>
>>
>>
>
>
> --
> With Regards
> Vikas Srivastava
>
> DWH & Analytics Team
> Mob:+91 9560885900
>
> One97 | Let's get talking !
>
>
Re: problem in hive
Posted by Vikas Srivastava <vi...@one97.net>.
hey thanks for replay but already have at that place..
2011/10/11 Harold(陳春宏) <ha...@sunplus-technology.com>
>
>
> You have to add jar file like this
> add jar ../hive-0.6.0/lib/hive_contrib.jar;
>
>
>
> Best Regard
> Mail: Harold.Chen@sunplus-technology.com
> MSN: chen0727@hotmail.com
> SKYPE: chen0727
> Mobil: 886-937545215
> Tel: 886-2-8798-2988 #222
> Fax:886-2-8751-5499
>
> -----Original Message-----
> From: vikas srivastava [mailto:vikas.srivastava@one97.net]
> Sent: Tuesday, October 11, 2011 3:29 PM
> To: user@hive.apache.org
> Subject: problem in hive
>
> Hi All,
>
> I facing a problem like I have installed hive on a new server and provide
> the connectivity with the namenode,
>
> Create a user in mysql and give the proper privileges to that user,
>
> Put that user in hive-site.xml and now when I fired a query like
>
> Show tables;
> Not showing any table
>
> when I fired
> Desc table or select table is throwing an error
>
> hive> desc aircel_obd;
> FAILED: Execution Error, return code 1 from
> org.apache.hadoop.hive.ql.exec.DDLTask
>
>
> The hive.log are :-
>
> 2011-10-11 12:25:30,131 ERROR DataNucleus.Plugin
> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
> "org.eclipse.core.resources" but it cannot be resolved.
> 2011-10-11 12:25:30,131 ERROR DataNucleus.Plugin
> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
> "org.eclipse.core.resources" but it cannot be resolved.
> 2011-10-11 12:25:30,134 ERROR DataNucleus.Plugin
> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
> "org.eclipse.core.runtime" but it cannot be resolved.
> 2011-10-11 12:25:30,134 ERROR DataNucleus.Plugin
> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
> "org.eclipse.core.runtime" but it cannot be resolved.
> 2011-10-11 12:25:30,135 ERROR DataNucleus.Plugin
> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
> "org.eclipse.text" but it cannot be resolved.
> 2011-10-11 12:25:30,135 ERROR DataNucleus.Plugin
> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
> "org.eclipse.text" but it cannot be resolved.
> 2011-10-11 12:25:35,031 ERROR ql.Driver (SessionState.java:printError(365))
> - FAILED: Execution Error, return code 1 from
> org.apache.hadoop.hive.ql.exec.DDLTask
> 2011-10-11 12:45:14,146 ERROR DataNucleus.Plugin
> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
> "org.eclipse.core.resources" but it cannot be resolved.
> 2011-10-11 12:45:14,146 ERROR DataNucleus.Plugin
> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
> "org.eclipse.core.resources" but it cannot be resolved.
> 2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin
> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
> "org.eclipse.core.runtime" but it cannot be resolved.
> 2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin
> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
> "org.eclipse.core.runtime" but it cannot be resolved.
> 2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin
> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
> "org.eclipse.text" but it cannot be resolved.
> 2011-10-11 12:45:14,150 ERROR DataNucleus.Plugin
> (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
> "org.eclipse.text" but it cannot be resolved.
> 2011-10-11 12:45:21,053 ERROR ql.Driver (SessionState.java:printError(365))
> - FAILED: Execution Error, return code 1 from
> org.apache.hadoop.hive.ql.exec.DDLTask
>
> Please help I m stuck here....
>
>
> With Regards
> Vikas Srivastava
>
> DWH & Analytics Team
> M: +91 9560885900
> P: + 91 120 4770102
> Email: vikas.srivastava@one97.net
> W: www.one97world.com
>
> One97 | Let's get talking !
>
>
>
>
--
With Regards
Vikas Srivastava
DWH & Analytics Team
Mob:+91 9560885900
One97 | Let's get talking !