Hive 建表报错,初步怀疑是Mysql元数据库字符集问题,但一直没解决。
0
问题描述:Hive 建表报错,报错信息如下:
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Add request failed : INSERT INTO `COLUMNS_V2` (`CD_ID`,`COMMENT`,`COLUMN_NAME`,`TYPE_NAME`,`INTEGER_IDX`) VALUES (?,?,?,?,?) )
建表脚本:
CREATE TABLE DET_SPM_PARTS_PROVIDE_DAY_DETAIL(
JULIAN_DAY_KEY INT ,
STATION_ID VARCHAR(12) ,
SOURCE_CITY VARCHAR(200) ,
PROD_LINE VARCHAR(50) ,
ORDER_TYPE VARCHAR(32) ,
TA TIMESTAMP,
TB TIMESTAMP,
ORDERS INT ,
WORK_DAY TIMESTAMP,
THINK INT ,
UP_SP_BAR VARCHAR(200) ,
UP_SP_CODE VARCHAR(200) ,
PROD_LINE_PSCM VARCHAR(200) ,
MATERIAL_BIGCLASS_NAME VARCHAR(100) ,
STATION_SUB_ID VARCHAR(200) ,
SEND_TIME VARCHAR(32) ,
AREA varchar(100) ,
FIGHTAREA varchar(100) ,
`管理站名称` varchar(100) ,
STATION_SUBID VARCHAR(8) ,
`省` varchar(100) ,
IS_NEWSTATION INT ,
SEND_DAY INT ,
`市` varchar(100) ,
LOGI_TA TIMESTAMP,
TADATE TIMESTAMP,
THINK_TA TIMESTAMP,
TA_LT TIMESTAMP,
D10 TIMESTAMP,
`县` varchar(100) );
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Add request failed : INSERT INTO `COLUMNS_V2` (`CD_ID`,`COMMENT`,`COLUMN_NAME`,`TYPE_NAME`,`INTEGER_IDX`) VALUES (?,?,?,?,?) )
建表脚本:
CREATE TABLE DET_SPM_PARTS_PROVIDE_DAY_DETAIL(
JULIAN_DAY_KEY INT ,
STATION_ID VARCHAR(12) ,
SOURCE_CITY VARCHAR(200) ,
PROD_LINE VARCHAR(50) ,
ORDER_TYPE VARCHAR(32) ,
TA TIMESTAMP,
TB TIMESTAMP,
ORDERS INT ,
WORK_DAY TIMESTAMP,
THINK INT ,
UP_SP_BAR VARCHAR(200) ,
UP_SP_CODE VARCHAR(200) ,
PROD_LINE_PSCM VARCHAR(200) ,
MATERIAL_BIGCLASS_NAME VARCHAR(100) ,
STATION_SUB_ID VARCHAR(200) ,
SEND_TIME VARCHAR(32) ,
AREA varchar(100) ,
FIGHTAREA varchar(100) ,
`管理站名称` varchar(100) ,
STATION_SUBID VARCHAR(8) ,
`省` varchar(100) ,
IS_NEWSTATION INT ,
SEND_DAY INT ,
`市` varchar(100) ,
LOGI_TA TIMESTAMP,
TADATE TIMESTAMP,
THINK_TA TIMESTAMP,
TA_LT TIMESTAMP,
D10 TIMESTAMP,
`县` varchar(100) );
没有找到相关结果
重要提示:提问者不能发表回复,可以通过评论与回答者沟通,沟通后可以通过编辑功能完善问题描述,以便后续其他人能够更容易理解问题.
1 个回复
MarsJ - 大数据玩家~DS 2017-11-10 回答
赞同来自: