Hive - Project

4 / 14
   

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.

Steps-

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

Question-

How many rows are there in _dictionary_ table?