Support Questions

Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

Why i am getting error: return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org/apache/hadoop

New Contributor

 

add jar /home/shashank/apache-hive-2.3.2-bin/lib/json-serde-1.3.7.3.jar;

create external table if not exists tweets ( text string,
entities STRUCT <
hashtags:ARRAY<STRUCT<text:STRING>>>,
`user` STRUCT<
screen_name:STRING,
friends_count:INT,
followers_count:INT,
statuses_count:INT,
verified:BOOLEAN,
utc_offset:INT,
time_zone:STRING>
)
row format SERDE 'org.openx.data.jsonserde.JsonSerDe'
location '/user/hive/warehouse/twitter.db/tweets.json';

I am working on hive-2.3.2 and jar file path is added as i get the mssg from terminal,i tried different json-serde jar file but nothing work for me. Thanks in advance.

1 REPLY 1

Guru
Hi Shanky,

Can you please paste full error reported on client and server side to the thread?

Also, are you running Hive CLI, or beeline?
Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.