Re: Hive 0.12.0 mysql metastore exception

2014-01-22 Thread Jov
2014/1/23 Jander g jande...@gmail.com

 Caused by: java.sql.BatchUpdateException: Duplicate entry 'default' for
 key 2


what is the HQL you run? it look like hive try to insert 'default' to a
meta table which violate the unique key.


Jov
blog: http:amutu.com/blog http://amutu.com/blog


Re: Hive 0.12.0 mysql metastore exception

2014-01-22 Thread Jander g
Hi, jov

Thanks for your attention.

we use hive like this:
hive -e use abc; insert overwrite .
Here, abc is a hive schema which already exists in hive metastore. But,
from the log we can see, hive ddl switch database is failed.
That is to say, it doesn't read the exist schema?

2014-01-23 06:35:49,467 ERROR exec.DDLTask (DDLTask.java:execute(435)) -
org.apache.hadoop.hive.ql.
metadata.HiveException: java.lang.RuntimeException: Unable to instantiate
org.apache.hadoop.hive.metastore.HiveMetaStoreClient
at
org.apache.hadoop.hive.ql.metadata.Hive.getDatabase(Hive.java:1143)
at
org.apache.hadoop.hive.ql.metadata.Hive.databaseExists(Hive.java:1128)
at org.apache.hadoop.hive.ql.exec.DDLTask.switchDatabase
(DDLTask.java:3479)



Best Regards,

On Thu, Jan 23, 2014 at 1:27 PM, Jov am...@amutu.com wrote:


 2014/1/23 Jander g jande...@gmail.com

 Caused by: java.sql.BatchUpdateException: Duplicate entry 'default' for
 key 2


 what is the HQL you run? it look like hive try to insert 'default' to a
 meta table which violate the unique key.


 Jov
 blog: http:amutu.com/blog http://amutu.com/blog




-- 
Thanks,
Jander