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