sqoop同步时间戳到mysql_Sqoop将MySQL的表数据同步到Hive

[root@centos02 opt]#sqoop import --connect jdbc:mysql://centos02:3306/OfficialCashMid --driver com.mysql.cj.jdbc.Driver --username root --password sa123_ADMIN. --table tadminoperationlog --m 3 --fields-terminated-by '\t' --lines-terminated-by '\n' --delete-target-dir --hive-import --hive-database testdb --hive-table hive_tadminlog

Warning: /opt/bigdata/sqoop/sqoop-1.4.7/../hbase does not exist!HBase imports will fail.

Please set$HBASE_HOMEto the root of your HBase installation.

Warning:/opt/bigdata/sqoop/sqoop-1.4.7/../hcatalog does not exist!HCatalog jobs will fail.

Please set$HCAT_HOMEto the root of your HCatalog installation.

Warning:/opt/bigdata/sqoop/sqoop-1.4.7/../accumulo does not exist!Accumulo imports will fail.

Please set$ACCUMULO_HOMEto the root of your Accumulo installation.

Warning:/opt/bigdata/sqoop/sqoop-1.4.7/../zookeeper does not exist!Accumulo imports will fail.

Please set$ZOOKEEPER_HOMEto the root of your Zookeeper installation.19/09/06 02:11:44 INFO sqoop.Sqoop: Running Sqoop version: 1.4.7SLF4J: Class path contains multiple SLF4J bindings.

SLF4J: Found bindingin [jar:file:/opt/bigdata/hadoop/hadoop-2.8.5/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]

SLF4J: Found bindingin [jar:file:/opt/bigdata/hive/hive-2.3.4/lib/log4j-slf4j-impl-2.6.2.jar!/org/slf4j/impl/StaticLoggerBinder.class]

SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.

SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]19/09/06 02:11:44 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.19/09/06 02:11:44 WARN sqoop.ConnFactory: Parameter --driver is set to an explicit driver however appropriate connection manager is not being set (via --connection-manager). Sqoop is going to fall back to org.apache.sqoop.manager.GenericJdbcManager. Please specify explicitly which connection manager should be used next time.19/09/06 02:11:44 INFO manager.SqlManager: Using default fetchSize of 1000

19/09/06 02:11:44INFO tool.CodeGenTool: Beginning code generation19/09/06 02:11:45 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM tadminoperationlog AS t WHERE 1=0

19/09/06 02:11:45 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM tadminoperationlog AS t WHERE 1=0

19/09/06 02:11:45 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is /opt/bigdata/hadoop/hadoop-2.8.5注:/tmp/sqoop-root/compile/125b66dccf842228eeff1669995d34a6/tadminoperationlog.java使用或覆盖了已过时的 API。

注: 有关详细信息, 请使用-Xlint:deprecation 重新编译。19/09/06 02:11:52 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-root/compile/125b66dccf842228eeff1669995d34a6/tadminoperationlog.jar19/09/06 02:11:53INFO tool.ImportTool: Destination directory tadminoperationlog is not present, hence not deleting.19/09/06 02:11:53INFO mapreduce.ImportJobBase: Beginning import of tadminoperationlog19/09/06 02:11:54INFO Configuration.deprecation: mapred.jar is deprecated. Instead, use mapreduce.job.jar19/09/06 02:11:54 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM tadminoperationlog AS t WHERE 1=0

19/09/06 02:11:54INFO Configuration.deprecation: mapred.map.tasks is deprecated. Instead, use mapreduce.job.maps19/09/06 02:11:54 INFO client.RMProxy: Connecting to ResourceManager at centos02/192.168.122.1:8032

19/09/06 02:12:00INFO db.DBInputFormat: Using read commited transaction isolation19/09/06 02:12:00INFO db.DataDrivenDBInputFormat: BoundingValsQuery: SELECT MIN(FID), MAX(FID) FROM tadminoperationlog19/09/06 02:12:00 INFO db.IntegerSplitter: Split size