java - Hive throws an error while creating table "Cannot validate serde: com.cloudera.hive.serde.JSONSerDe" -
working on apache-hive-0.13.1. while creating table hive throw error below
failed: execution error, return code 1 org.apache.hadoop.hive.ql.exec.ddltask. cannot validate serde: com.cloudera.hive.serde.jsonserde
table structure
create external table tweets(id bigint, created_at string, scource string, favorited boolean, retweet_count int, retweeted_status struct < text:string,user:struct< screen_name:string, name:string>>, entities struct< urls:array<struct< expanded_url:string>>, user_mentions:array<struct< screen_name:string, name:string>>, hashtags:array<struct<text:string>>>, text string, user struct< screen_name:string, name:string, friends_count:int, followers_count:int, statuses_count:int, verified:boolean, utc_offset:int, time_zone:string> , in_reply_to_screen_name string) partitioned (datehour int) row format serde 'com.cloudera.hive.serde.jsonserde' location '/home/edureka/saching'
added json-serde-1.3.6-snapshot-jar-with-dependencies.jar
in class resolved issue no success
finally , got solution this. issue json-serde-1.3.6-snapshot-jar-with-dependencies.jar
different distribution (cloudera, azure, etc ) needed different json-serde jar file. means, serde jar should compatible there distribution.
i changed jar , worked me.
Comments
Post a Comment