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 >