Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Hive Query error

avatar
Explorer

create table IF NOT EXISTS tweets_sentiment stored as orc as select tweet_id,

case when sum( polarity ) > 0 then 'positive' when sum( polarity ) < 0 then 'negative' else 'neutral' end as sentiment from l3 group by tweet_id;

Tihs query gives following error :-

9796-screenshot-3.png

1 ACCEPTED SOLUTION

avatar
Super Collaborator
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login
13 REPLIES 13

avatar
Super Collaborator

Navigate to Resource Manager UI on 127.0.0.1:8088. Click on Running applications and then kill them. You will see a button to Kill the application. After this, run the same query again.

avatar
Explorer

still showing the same error.

avatar
Explorer

problem is when i reload the page i have to run @Mushtaq Rizvi

ADDJAR/usr/hdp/2.5.0.0-1245/hive2/lib/json-serde-1.3.8-SNAPSHOT-jar-with-dependencies.jar;
or i gets that same error

avatar
Explorer

Well Thank you very much Sir for Your Kind Assistance. @Mushtaq Rizvi