Sqoop synchronizing MySQL data into hive

One, sqoop in synchronizing MySQL table structure to hive

Sqoop create-hive-table--connect jdbc:mysql://ip:3306/sampledata--table t1--username Dev--password 1234--hive-table T1;

Execution to this step exits, but in Hadoop's HDFs/hive/warehouse/directory is not found T1 table directory,

But the normal execution is done as follows:

The error is that Hive's jar package is missing.

All of the jar packages should be like this:

This is all the hadoop-2.2.0 and hbase-0.96.2 and hive-0.13.1 integrated jar packages

There is also Sqoop-1.4.4.jar and MySQL driver pack also to put in, these two bags best also put in hadoop/etc/share/common/

Hive Boot Log Check
Hive-hiveconf Hive.root.logger=debug,console

Console view

or tune the boot log priority of hive and Hadoop to DEBUG,

Output to a file to view

If there is no exception information, it means that sqoop execution is not a problem, to solve the problem!

Sqoop synchronizing MySQL data into hive