I suggest you to go for sqoop - They imports data from RDBMS.
On Thu, May 1, 2014 at 7:13 PM, Shushant Arora <shushantaror...@gmail.com>wrote: > Hi > > I have a requirement to transfer data from RDBMS mysql to partitioned hive > table > Partitioned on Year and month. > Each record in mysql data contains timestamp of user activity. > > What is the best tool for that. > > 1.Shall I go with sqoop? > > 2.How to compute dynamic partition from RDBMS data . > > Shall I bucketised my fetched data on User Key. > Shall I use day also in partition? > My requirement is to analyse user activity per day basis. > > Thanks > Shushant > > > > -- *Thanks & Regards * *Unmesha Sreeveni U.B* *Hadoop, Bigdata Developer* *Center for Cyber Security | Amrita Vishwa Vidyapeetham* http://www.unmeshasreeveni.blogspot.in/
