Twitter project


3 Answer(s)


hi Kunal,

You can use the "LOAD" command to load the files into Hive.

Thanks

Hi,

Thanks for your response. I can use the LOAD command when I am working with raw data but in this scenario the data is loaded by FLUME into the directory 'user/cloudera/tweets'.
I am assuming that when I create the EXTERNAL TABLE and load the data into the same location and fire the select query the data will automatically be mapped from the JSON file to the table . This will be taken care by the SERDE I am using. Please correct me if I am wrong.

Thanks,
Kunal

I was able to load the Data through this command but I ran into a different issue whic I have posted in a separate thread.

LOAD DATA INPATH '/user/cloudera/tweets/FlumeData.1417993820185' INTO TABLE tweets_partioned PARTITION (year=2014, month=12, dt=07, dthour=15);