Error while creating tables on Hive

Question

I created this table in Hive:

hive> CREATE TABLE twitter_data(datePosted TIMESTAMP
  , userId BIGINT
  , userName STRING
  , tweets STRING)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t';

But it displays this error message:

FAILED: Error in metadata: javax.jdo.JDOFatalInternalException: Error creating transactional connection factory NestedThrowables: java.lang.reflect.InvocationTargetException

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask

Does anyone know what this error message means?

A similar issue is discussed here: stackoverflow.com/questions/6853445/hive-doesnt-work-on-install — Lorand Bendig

AvkashChauhan AvkashChauhan · Accepted Answer · 2013-06-03T18:47:59

I recently met with this problem and the issue was related to the Hive JDBC driver which was not available to the client while making the request to Hive. This is what I did to solve my problem:

I did verify that I do have the Hive JDBC connector installed in my cluster
I modified the following settings in hive-site.xml correctly depending on my local settings:

<property>
  <name>javax.jdo.option.ConnectionURL</name>
  <value>jdbc:mysql://myhost/metastore</value>
  <description>the URL of the MySQL database</description>
</property>
<property>
  <name>javax.jdo.option.ConnectionDriverName</name>
  <value>com.mysql.jdbc.Driver</value>
</property>
<property>
  <name>javax.jdo.option.ConnectionUserName</name>
  <value>hive</value>
</property>
<property>
  <name>javax.jdo.option.ConnectionPassword</name>
  <value>mypassword</value>
</property>

Error while creating tables on Hive

1 Answers