Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Cannot validate serde: org.apache.hive.hcatalog.data.JsonSerDe
原因是无法解析json,
json格式数据表需要通过serde机制处理
1 在hive-site.xml中设置三方jar包
<property>
<name>hive.aux.jars.path</name>
<value>/home/framework/hive-2.1.1/lib/</value>
</property>
2 在hive.aux.jars.path
设置的路径中增加hive-hcatalog-core-2.1.1.jar
拷贝路径为$HIVE_HOME/hcatalog/share/hcatalog/hive-hcatalog-core-2.1.1.jar
到/home/framework/hive-2.1.1/lib/
中
cp $HIVE_HOME/hcatalog/share/hcatalog/hive-hcatalog-core-2.1.1.jar /home/framework/hive-2.1.1/lib/
之后需要重启hive,然后再次建表就可以了