I have tried to execute the following DDL
CREATE TABLE employee_exp_json
( id INT,
ROW FORMAT SERDE 'org.apache.hive.hcatalog.data.JsonSerDe'
STORED AS TEXTFILE;
But got an error
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Cannot validate serde: org.apache.hive.hcatalog.data.JsonSerDe
I do see some of the posts said that need to add jar hive-hcataglog-core.jar but I am unable to locate that jar in CDH quickstart VM 184.108.40.206.
So it would be great if you could suggest how to fix this.
There is no problem with your query but it will work based on the hive version that you are using because hive started supporting JsonSerDe from the later versions (not exactly know starting which version)
If you can install (or) manage to login to any recent version of hive, then try the same query, it will work