sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mohammad Tariq <donta...@gmail.com>
Subject Settings required to execute create-hive-table
Date Mon, 21 Apr 2014 21:17:17 GMT
Hello group,

I have a table in MySQL and I wish to create the corresponding Hive table
using Sqoop's create-hive-table option. The query gets executed without any
error, but the target table doesn't get created. I feel I'm missing
something because of which Sqoop is not able to talk to the metastore. Do I
need to set some properties in Sqoop so that it can talk to Hive metastore
in order to create Hive tables?

I am using MySQL as metastore on my Mac. Hive and Sqoop versions are 0.11.0
and 1.4.4 respectively.

This is what happens when I execute the Sqoop command :

 SQOOP_HOME  bin/sqoop create-hive-table --connect
jdbc:mysql://localhost/demo -username root --table t2
--fields-terminated-by  ',' --hive-table t2 find: sqoop-test-1.4.4.jar:
unknown primary or operator

14/04/22 02:30:45 INFO manager.MySQLManager: Preparing to use a MySQL
streaming resultset.

14/04/22 02:30:45 INFO manager.SqlManager: Executing SQL statement: SELECT
t.* FROM `t2` AS t LIMIT 1

14/04/22 02:30:45 INFO manager.SqlManager: Executing SQL statement: SELECT
t.* FROM `t2` AS t LIMIT 1

14/04/22 02:30:45 INFO hive.HiveImport: Loading uploaded data into Hive

Logging initialized using configuration in
jar:file:/Users/miqbal1/hadoop-eco/hive-0.11.0/lib/hive-common-0.11.0.jar!/hive-log4j.properties

Hive history
file=/tmp/miqbal1/hive_job_log_miqbal1_4974@BANL119158415.local_201404220230_115424146.txt
Thanks a lot for your precious time.

Warm Regards,
Tariq
cloudfront.blogspot.com

Mime
View raw message