Apache Hive is not loading tweets from flume's directory

[AritzBi]

Hi!

I have been following the tutorial and I am stuck. Flume is gathering tweets correctly and saving them in /user/flume/tweets.

Then, I have execute:

ADD JAR ;

CREATE EXTERNAL TABLE tweets (.....

But when for example I execute SELECT COUNT(*) from tweets; , the table is empty, the result is 0. Do I have to execute some other command in order to load the tweets?

Thanks!

[taras-yaroshchuk]

Same problem.

[hanzallah-ashaar]

If you are using Oozie, your Hive table should be updated with data. Kindly upload your oozie-workflows directory here so I can review the configuration files.
But you can still add data using
LOAD DATA INPATH '/user/flume/tweets'
INTO TABLE `default.tweets`
PARTITION (datehour = 'date hour value that you set in job.properties file')