Cannot validate serde : org.openx.data.jsonserde.jsonserde

I too encountered this problem. In my case, I managed to fix this issue by adding json-serde-1.3.7-SNAPSHOT-jar-with-dependencies.jar at hive command prompt as shown below:

hive> ADD JAR /usr/local/Hive-JSON-Serde/json-serde/target/json-serde-1.3.7-SNAPSHOT-jar-with-dependencies.jar;

Below are the steps I have followed on Ubuntu 14.04:

1. Fire up Linux terminal and cd /usr/local2. sudo git clone https://github.com/rcongiu/Hive-JSON-Serde.git3. sudo mvn -Pcdh5 clean package4. The serde file will be in    /usr/local/Hive-JSON-Serde/json-serde/target/json-serde-1.3.7-SNAPSHOT-jar-with-dependencies.jar5. Go to hive prompt and ADD JAR file as shown in Step 6.6. hive> ADD JAR /usr/local/Hive-JSON-Serde/json-serde/target/json-serde-1.3.7- SNAPSHOT-jar-with-dependencies.jar;7. Now create hive table from hive> prompt. At this stage, Hive table should be created successfully without any error.

Hive Version: 1.2.1

Hadoop Version: 2.7.1

Reference: Hive-JSON-Serde

You have to build the project cloned using the maven !

mvn install in the directory /path/directory/Hive-JSON-Serd here we are in /usr/local