Hive error while creating the table

[Ravisankar NA]

Hi,

I am getting the following error while creating table in Hive.

hive> CREATE TABLE pokes (foo INT, bar STRING);
FAILED: Error in metadata: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask

Any ideas please?

Thanks

[Senthil Kumar]

Hive, By default, internally uses derby DB for metastore

If you have started two Hive CLI instances , it may give this error due to tat.

So use jps in terminal and kill all the RunJar processes.

Restart CLI again.

-Senthil

[Venkat Ankam]

Using CDH? 

Try this...

Need to start the Hive metastore service on the node where hive mysql database is running.  

$ service hive-metastore start

Regards,

Venkat Ankam

--
You received this message because you are subscribed to the Google Groups "Hadoop Users Group (HUG) Chennai" group.
To unsubscribe from this group and stop receiving emails from it, send an email to chennaihug+...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Ashwanth Kumar]

Share your hive configuration

On Tue, Aug 6, 2013 at 9:13 PM, Ravisankar NA <ravisa...@gmail.com> wrote:

--

You received this message because you are subscribed to the Google Groups "Hadoop Users Group (HUG) Chennai" group.
To unsubscribe from this group and stop receiving emails from it, send an email to chennaihug+...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

--

Ashwanth Kumar / ashwanthkumar.in

[Ravisankar NA]

Thanks a lot for your responses. I got the issue fixed. The issue was due to incorrect configuration. After updating it, I am able to create table and load data.

Thanks a lot for your help.