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

 

posted on 2022-02-25 16:10  paike123  阅读(369)  评论(0编辑  收藏  举报

导航