今天,通过HiveMetaStoreClient查询Hive的表信息,结果在查询的时候,出现主键超长错误,错误日志如下:
2014-05-19 20:34:20,039 INFO DataNucleus.Datastore:The class "org.apache.hadoop.hive.metastore.model.MFieldSchema" is tagged as "embedded-only" so does not have its own datastore table.
2014-05-19 20:34:20,058 INFO DataNucleus.Datastore:The class "org.apache.hadoop.hive.metastore.model.MOrder" is tagged as "embedded-only" so does not have its own datastore table.
2014-05-19 20:34:21,123 ERROR DataNucleus.Datastore:Error thrown executing CREATE TABLE `TABLE_PARAMS`
(
`TBL_ID` BIGINT NOT NULL,
`PARAM_KEY` VARCHAR(256) BINARY NOT NULL,
`PARAM_VALUE` VARCHAR(4000) BINARY NULL,
CONSTRAINT `TABLE_PARAMS_PK` PRIMARY KEY (`TBL_ID`,`PARAM_KEY`)
) ENGINE=INNODB : Specified key was too long; max key length is 767 bytes
com.mysql.jdbc.exception