hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Divya Gehlot <divya.htco...@gmail.com>
Subject Re: Apache sqoop and hive
Date Fri, 19 Feb 2016 09:05:47 GMT
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 <archanap@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.htconex@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 <archanap@vavni.com<mailto:
> archanap@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)
>
>

Mime
View raw message