Applications Closing for Certification Course on Artificial Intelligence and Deep Learning by IIT Roorkee | Closing in

  Apply Now

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.

Question-

How many rows are there in the dictionary table?

INSTRUCTIONS
  1. Launch hive console by typing the hive command in the web console.

    hive
    
  2. Create an external table dictionary. Run below command on the web console. ${env:USER} gets replaced by your username automatically. 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/${env:USER}/SentimentFiles/SentimentFiles/upload/data/dictionary';
    

    Sample rows of dictionary table are


Note - Having trouble with the assessment engine? Follow the steps listed here


No hints are availble for this assesment

Answer is not availble for this assesment

Loading comments...