Reply
New Contributor
Posts: 1
Registered: ‎04-03-2016

create table in hive is stuck using cloudera quickstart vm

 

I am using sqoop to create a table in hive using --hive-import which is getting stuck. So tried normal create table in hive using hive CLI to check but this is also getting stuck. 


I am using cloudera quickstart vm. The command is stuck and even after a long time does not happen anything. Am i missing anything. Appreciate if anyone can help on this please. The below is the terminal log. Appreciate any quick help on this please.

 

[cloudera@quickstart ~]$ hive

Logging initialized using configuration in jar:file:/usr/jars/hive-common-1.1.0-cdh5.5.0.jar!/hive-log4j.properties WARNING: Hive CLI is deprecated and migration to Beeline is recommended. hive> create table test_dept(department_id int,department_name string); Interrupting... Be patient, this might take some time. Press Ctrl+C again to kill JVM Exiting the JVM [cloudera@quickstart ~]$

krv
New Contributor
Posts: 2
Registered: ‎08-14-2016

Re: create table in hive is stuck using cloudera quickstart vm

I am having the same problem. Is there any configuration missing here?

 

Posts: 1,894
Kudos: 433
Solutions: 303
Registered: ‎07-31-2013

Re: create table in hive is stuck using cloudera quickstart vm

One probable reason is that your Hive MetaStore Service may have gone down for some reason. Could you pastebin over the logs of that service from /var/log/hive/ directory?

The default timeout for HMS connections is ~5 minutes, so it may give the illusion of a long hang in the worst of cases.
krv
New Contributor
Posts: 2
Registered: ‎08-14-2016

Re: create table in hive is stuck using cloudera quickstart vm

After restarting Hive Service, I tried creating table using Hue worked.. After that create tables in hive started working.. Not sure about the magic behind.. I am yet to check the logs /var/log/hive directory
Announcements
New solutions