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

Popular posts from this blog

Ansible - ERROR! the field 'hosts' is required but was not set -

customize file_field button ruby on rails -

SoapUI on windows 10 - high DPI/4K scaling issue -