This cant be done since insert update delete are not supported in hive. Mysql Applier for Hadoop package servers the same purpose of the prototype tool which i intended to develop.
link for "Mysql Applier for Hadoop" http://dev.mysql.com/tech-resources/articles/mysql-hadoop-applier.html *Regards Muthupandi.K* [image: Picture (Device Independent Bitmap)] On Wed, Sep 3, 2014 at 10:35 AM, Muthu Pandi <muthu1...@gmail.com> wrote: > Yeah but we cant make it to work as near real time. Also my table doesnt > have like 'ID' to use for --check-column that's why opted out of sqoop. > > > > *Regards Muthupandi.K* > > [image: Picture (Device Independent Bitmap)] > > > > On Wed, Sep 3, 2014 at 10:28 AM, Nitin Pawar <nitinpawar...@gmail.com> > wrote: > >> have you looked at sqoop? >> >> >> On Wed, Sep 3, 2014 at 10:15 AM, Muthu Pandi <muthu1...@gmail.com> wrote: >> >>> Dear All >>> >>> Am developing a prototype of syncing tables from mysql to Hive >>> using python and JDBC. Is it a good idea using the JDBC for this purpose. >>> >>> My usecase will be generating the sales report using the hive, data >>> pulled from mysql using the prototype tool.My data will be around 2GB/day. >>> >>> >>> >>> *Regards Muthupandi.K* >>> >>> [image: Picture (Device Independent Bitmap)] >>> >>> >> >> >> -- >> Nitin Pawar >> > >
