Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Hive performance exception


Copy link to this message
-
Hive performance exception


 

Hello, every one:

       I am a newbie to hive. And I have a bash shell script which will run
multi hive scripts(more than 16*31) simultaneously to export data to text
files. When I run this shell, the following exception occurred, and if I run
the hive scripts one by one, all are OK.

       In the hive scripts, I must create a temp table for some reason.

 

FAILED: Error in metadata: javax.jdo.JDODataStoreException: Exception thrown
obtaining schema column information from data store

NestedThrowables:

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
'hivedb1.DELETEME1356611646373' doesn't exist

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

 

 

ENV:

       HIVE:0.90

       MetaDataStore: Mysql5.5.30

 

I have googled the internet and found the following setting may fix the
exception, but I don’t know whether I can create and drop tables in hive
scripts.

<property>
  <name>datanucleus.autoCreateSchema</name>
  <value>false</value>
</property>
<property>
  <name>datanucleus.fixedDatastore</name>
  <value>true</value>
</property>

 

 

 

The attachments are hive configuration and the shell script.

 

 

Thanks a lot.