Created on 11-26-2016 09:46 PM - edited 08-19-2019 03:18 AM
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 :-
Created 11-27-2016 12:13 AM
Want to get a detailed solution you have to login/registered on the community
Register/LoginCreated 11-27-2016 01:08 AM
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.
Created 11-27-2016 01:20 AM
still showing the same error.
Created 11-27-2016 01:23 AM
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
Created 11-27-2016 01:42 AM
Well Thank you very much Sir for Your Kind Assistance. @Mushtaq Rizvi