populate tweets_partition?


2 Answer(s)


does this get populated with Oozie workflow?  I could not setup Oozie workflow as per project directions.  Can someone respond?


Hi Sohail,

To populate do the following:

 
Using Alter table commands similar to below one add partition to the table.

alter table tweets_partioned add partition (year=2014, month=05, dt=24, dthour=05);

alter table tweets_partioned add partition (year=2014, month=05, dt=24, dthour=08);
 

Check whether has been successfully added and it queryable or not.

hive> select * from tweets_partioned where year=2014 and month=05 and dt=24 and dthour=05 limit 10;
 
Hope this helps.