jsonhadoophivehive-serdehiveddl

Load json file in hive using json serde

I am trying to upload json file on hadoop using json serde. I have uploaded jar lib to hadoop but getting error while running hive command

I have uploaded json serde jar file to /apps/hive/warehouse/lib path.Now, when i am tring to run this command 

ADD JAR /apps/hive/warehouse/lib/json-serde-1.3-jar-with-dependencies.jar;

I got this error

H110 Unable to submit statement. Error while processing statement: /apps/hive/warehouse/lib/json-serde-1.3.7-SNAPSHOT-jar-with-dependencies.jar does not exist [ERROR_STATUS]

Solution

  • Looks like your jar is in HDFS location. Use:

    add jar hdfs:///apps/hive/warehouse/lib/json-serde-1.3-jar-with-dependencies.jar;