Warning: /usr/hdp/2.4.0.0-169/accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
17/07/30 04:25:00 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6.2.4.0.0-169
17/07/30 04:25:00 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.
17/07/30 04:25:00 INFO manager.SqlManager: Using default fetchSize of 1000
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/usr/hdp/2.4.0.0-169/hadoop/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/usr/hdp/2.4.0.0-169/zookeeper/lib/slf4j-log4j12-1.6.1.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]
17/07/30 04:25:01 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM lr_hive AS t WHERE 1=0
17/07/30 04:25:01 INFO tool.CodeGenTool: Beginning code generation
17/07/30 04:25:01 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM lr_hive AS t WHERE 1=0
17/07/30 04:25:01 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM lr_hive AS t WHERE 1=0
17/07/30 04:25:01 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is /usr/hdp/2.4.0.0-169/hadoop-mapreduce
Note: /tmp/sqoop-root/compile/6d1824fb82ceb1404c23385b4d562925/lr_hive.java uses or overrides a deprecated API.
Note: Recompile with -Xlint:deprecation for details.
17/07/30 04:25:03 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-root/compile/6d1824fb82ceb1404c23385b4d562925/lr_hive.jar
17/07/30 04:25:03 ERROR tool.ExportTool: Error during export: Mixed update/insert is not supported against the target database yet
[root@sandbox sqoop_test]# sqoop export  --options-file /root/sqoop_test/sqoop_options.txt --table lr_hive --export-dir /user/root/lr/lr_export -m 2 --update-key revw_id --update-mode allowinsert --batch --outdir javafiles --driver com.mysql.jdbc.Driver --input-null-string 'ddfddf';
Warning: /usr/hdp/2.4.0.0-169/accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
17/07/30 04:25:46 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6.2.4.0.0-169
17/07/30 04:25:46 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.
17/07/30 04:25:46 INFO manager.SqlManager: Using default fetchSize of 1000
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/usr/hdp/2.4.0.0-169/hadoop/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/usr/hdp/2.4.0.0-169/zookeeper/lib/slf4j-log4j12-1.6.1.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]
17/07/30 04:25:47 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM lr_hive AS t WHERE 1=0
17/07/30 04:25:47 INFO tool.CodeGenTool: Beginning code generation
17/07/30 04:25:47 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM lr_hive AS t WHERE 1=0
17/07/30 04:25:47 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM lr_hive AS t WHERE 1=0
17/07/30 04:25:47 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is /usr/hdp/2.4.0.0-169/hadoop-mapreduce
Note: /tmp/sqoop-root/compile/9305c80a2a809d872adfae5c2117422f/lr_hive.java uses or overrides a deprecated API.
Note: Recompile with -Xlint:deprecation for details.
17/07/30 04:25:49 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-root/compile/9305c80a2a809d872adfae5c2117422f/lr_hive.jar
17/07/30 04:25:49 ERROR tool.ExportTool: Error during export: Mixed update/insert is not supported against the target database yet
[root@sandbox sqoop_test]# ^C