The objective of this step is to create an external table _dictionary_. This table contains English words and their polarity. Polarity means if the word has positive, negative, or neutral sentiment. Since a tweet consists of words, this table will help us in calculating the sentiment of the entire tweet.
Create an external table _dictionary_. Run below command in Hive query editor in Hue. Replace YOUR_USER_NAME with your CloudxLab username. _dictionary_ table contains words and their polarity.
CREATE EXTERNAL TABLE dictionary ( type string, length int, word string, pos string, stemmed string, polarity string ) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE LOCATION '/user/YOUR_USER_NAME/SentimentFiles/SentimentFiles/upload/data/dictionary';
Sample rows of _dictionary_ table are
How many rows are there in _dictionary_ table?
Taking you to the next exercise in seconds...