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


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

FAILED: Execution Error, return code 1 from





       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





The attachments are hive configuration and the shell script.



Thanks a lot.