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 :-
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.