I'm trying to read json file via hive external table. I'm missing SerDe, I couldn't fine the instruction to add it. The full error is: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Cannot validate serde: org.apache.hive.hcatalog.data.JsonSerDe 17/03/21 06:07:52 [HiveServer2-Background-Pool: Thread-89]: ERROR ql.Driver: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Cannot validate serde: org.apache.hive.hcatalog.data.JsonSerDe In the hive: CREATE EXTERNAL TABLE IF NOT EXISTS ViewClicks ( location_text string, match_level tinyint) ROW FORMAT SERDE 'org.apache.hive.hcatalog.data.JsonSerDe' STORED AS TEXTFILE LOCATION '/user/root/DBA/ClickStream'; , Hi Trying to read json file usign hive failes with error: ERROR ql.Driver: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Cannot validate serde: org.apache.hive.hcatalog.data.JsonSerDe Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Cannot validate serde: org.apache.hive.hcatalog.data.JsonSerDe (state=08S01,code=1) Here is the code for the table creation. CREATE EXTERNAL TABLE IF NOT EXISTS t1 ( location_text string, match_level tinyint ) ROW FORMAT SERDE 'org.apache.hive.hcatalog.data.JsonSerDe' STORED AS TEXTFILE LOCATION '/user/root/DBA/ClickStream'; How to I install the SerDe on hive? ... View more