FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Cannot validate serde: org.apache.hive.hcatalog.data.JsonSerDe
用下列sql语句在hive 中创建表,
create table user_action( actionTime STRING comment "user actions time", readTime STRING comment "user reading time", channelId INT comment "article channel id", param map<string, string> comment "action parameter") COMMENT "user primitive action" PARTITIONED BY(dt STRING) ROW FORMAT SERDE 'org.apache.hive.hcatalog.data.JsonSerDe' LOCATION '/user/hive/warehouse/profile.db/user_action';
指定了字段的分隔符为json
结果报错
> LOCATION '/user/hive/warehouse/profile.db/user_action'; FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Cannot validate serde: org.apache.hive.hcatalog.data.JsonSerDe
原因不知道~~~~~~~~
解决如下:
将 hive-hcatalog-core-2.3.4.jar 包放在 hive/lib下
hive-hcatalog-core-2.3.4.jar 下载
链接:https://pan.baidu.com/s/10JmN_gHX1mpjevhRuKyZZQ
提取码:tukv