sqoop import-all-tables \ --connect "jdbc:mysql://host_name:3306/db_name" \ --username=username \ --password=password \ --warehouse-dir=/user/hive/warehouse/hive_db.db
Have you tried this On 19 February 2016 at 12:17, Archana Patel <archa...@vavni.com> wrote: > > hi , Divya > > Actually i am able to import single table but want to import whole > database into hive. > I did this. > > sqoop import --connect jdbc:mysql://localhost:3306/sample --username > root -P --table demo --hive-import --hive-table default.demo -m 1 > --driver com.mysql.jdbc.Driver > > > ________________________________________ > From: Divya Gehlot [divya.htco...@gmail.com] > Sent: Friday, February 19, 2016 8:37 AM > To: user@hive.apache.org > Subject: Re: Apache sqoop and hive > > Can you please post the steps how are you doing it ? > > > > On 18 February 2016 at 19:19, Archana Patel <archa...@vavni.com<mailto: > archa...@vavni.com>> wrote: > hi, > > I am trying to import all tables from mysql to hive by using apache sqoop > but its having problem. And i have added mysql-connector-java-5.0.8-bin.jar > also still having problem. Can anybody help on this who has tried this > already or any idea. > > Thanks , > Archana Patel > skype(live:archana961) > >
