Hive创建TABLE_PARAMS表失败

最新推荐文章于 2022-01-10 08:19:23 发布

yangfeiblog

最新推荐文章于 2022-01-10 08:19:23 发布

阅读量2.8k

点赞数

分类专栏： Hadoop Hadoop私房菜

本文链接：https://blog.csdn.net/yangfei001/article/details/26369459

版权

今天，通过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