Skip to main content

Posts

Showing posts from August, 2013

Hive exception when executing a query: java.lang.Integer cant be mapped for this datastore

When executing query in the hive shell following error is shown.
hive> show tables; FAILED: Error in metadata: MetaException(message:Got exception: org.apache.hadoop.hive.metastore.api.MetaException javax.jdo.JDOFatalInternalException: JDBC type integer declared for field "org.apache.hadoop.hive.metastore.model.MTable.createTime" of java type java.lang.Integer cant be mapped for this datastore.
NestedThrowables: org.datanucleus.exceptions.NucleusException: JDBC type integer declared for field "org.apache.hadoop.hive.metastore.model.MTable.createTime" of java type java.lang.Integer cant be mapped for this datastore.) FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
That is because of your language settings. To solve the problem export lang variable before launching hive. # export LANG=C