HOW to Load twitter data into HIVE table?

4 Answer(s)


Working for me.
You have to do two things.
1. Don't use partition during create table
2. load the table
LOAD DATA INPATH '/user/cloudera/tweets' INTO TABLE tweets;

select should work now. try:
select user.screen_name, text from tweets;



it may work with partition but load command would be different it seems. I tried to keep it simple. Will try later with partition.

Also make sure to add jar file before working on table.

hive> ADD JAR /home/cloudera/flume/hive-serdes-1.0-SNAPSHOT.jar;


hi Biswadip,

You need to load the files into Hive to see them . use LOAD DATA INPATH "/hdfspath" into