JSON SerDe JAR not getting detected while creating a Table in Hive

Viewed 325

Can anyone please tell a proper solution for the below error scenario.

Below mentioned details are my Hadoop and its ecosystem versions

Hadoop Version: 2.7.1
Hive Version: 1.2.2

I was trying to install and configure JSON SerDe into my hive's library path. And, the steps which I followed were mentioned below

Step 1: Installed & Moved SerDe into Hive's Library path
Step 2: Added the Jar through hive Shell, modified the hive-site.xml's 
        property name hive.aux.jars.path. 
Step 3: Verified it by executing the list jars command in hive also. But 
        while invoking the json serde, error is being thrown. 

enter image description here

enter image description here

enter image description here

Important Note: I added an entry in maven too, gave 777 permission for the jar file in linux. Additionally, I added the jar both in hdfs and local filesystem. But, still the error is being thrown

Name of the JSON SerDe jar which I used was: json-serde-1.3.7.3.jar

Row format SerDe: org.openx.data.jsonserde.JsonSerDe

0 Answers
Related