sqoop-- hive导出到非关系型数据库失败

0 0

sqoop-- hive导出到非关系型数据库失败0

下面是运行sqoop命令的控制台信息，所用非关系型数据库为vertica，求大神指导
sqoop命令为：
sqoop export -D mapred.job.queue.name=rtbqueue --connect jdbc:vertica://192.168.1.3:5433/test --driver com.vertica.jdbc.Driver --username test --password teset --table tes.hive_test2 --export-dir /apps/hive/warehouse/help_keyword --fields-terminated-by '\t' --lines-terminated-by '\n';

14/12/25 20:37:21 INFO sqoop.Sqoop: Running Sqoop version: 1.4.5
14/12/25 20:37:21 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
14/12/25 20:37:21 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.
14/12/25 20:37:21 INFO manager.SqlManager: Using default fetchSize of 1000
14/12/25 20:37:21 INFO tool.CodeGenTool: Beginning code generation
14/12/25 20:37:21 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM dim.hive_test2 AS t WHERE 1=0
14/12/25 20:37:21 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM dim.hive_test2 AS t WHERE 1=0
14/12/25 20:37:21 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is /usr/hdp_client/hadoop-2.2.0.2.0.6.0-76
注意：/tmp/sqoop-hzadmin/compile/94c3eb9ffbca97ae71334e9cd46ae86a/dim_hive_test2.java 使用或覆盖了已过时的 API。
注意：要了解详细信息，请使用 -Xlint:deprecation 重新编译。
14/12/25 20:37:23 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-hzadmin/compile/94c3eb9ffbca97ae71334e9cd46ae86a/dim.hive_test2.jar
14/12/25 20:37:23 INFO mapreduce.ExportJobBase: Beginning export of dim.hive_test2
14/12/25 20:37:23 INFO Configuration.deprecation: mapred.jar is deprecated. Instead, use mapreduce.job.jar
14/12/25 20:37:23 WARN mapreduce.ExportJobBase: Input path hdfs://TelecomHDP/apps/hive/warehouse/help_keyword contains no files
14/12/25 20:37:23 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM dim.hive_test2 AS t WHERE 1=0
14/12/25 20:37:24 INFO Configuration.deprecation: mapred.reduce.tasks.speculative.execution is deprecated. Instead, use mapreduce.reduce.speculative
14/12/25 20:37:24 INFO Configuration.deprecation: mapred.map.tasks.speculative.execution is deprecated. Instead, use mapreduce.map.speculative
14/12/25 20:37:24 INFO Configuration.deprecation: mapred.map.tasks is deprecated. Instead, use mapreduce.job.maps
14/12/25 20:37:24 INFO client.RMProxy: Connecting to ResourceManager at RTB-HDP-NN-01/192.168.13.15:8050
14/12/25 20:37:26 INFO input.FileInputFormat: Total input paths to process : 0
14/12/25 20:37:26 INFO Configuration.deprecation: mapred.max.split.size is deprecated. Instead, use mapreduce.input.fileinputformat.split.maxsize
14/12/25 20:37:26 INFO input.FileInputFormat: Total input paths to process : 0
14/12/25 20:37:26 INFO mapreduce.JobSubmitter: number of splits:0
14/12/25 20:37:26 INFO Configuration.deprecation: mapred.job.classpath.files is deprecated. Instead, use mapreduce.job.classpath.files
14/12/25 20:37:26 INFO Configuration.deprecation: user.name is deprecated. Instead, use mapreduce.job.user.name
14/12/25 20:37:26 INFO Configuration.deprecation: mapred.cache.files.filesizes is deprecated. Instead, use mapreduce.job.cache.files.filesizes
14/12/25 20:37:26 INFO Configuration.deprecation: mapred.cache.files is deprecated. Instead, use mapreduce.job.cache.files
14/12/25 20:37:26 INFO Configuration.deprecation: mapred.map.tasks.speculative.execution is deprecated. Instead, use mapreduce.map.speculative
14/12/25 20:37:26 INFO Configuration.deprecation: mapred.reduce.tasks is deprecated. Instead, use mapreduce.job.reduces
14/12/25 20:37:26 INFO Configuration.deprecation: mapred.mapoutput.value.class is deprecated. Instead, use mapreduce.map.output.value.class
14/12/25 20:37:26 INFO Configuration.deprecation: mapreduce.map.class is deprecated. Instead, use mapreduce.job.map.class
14/12/25 20:37:26 INFO Configuration.deprecation: mapred.job.name is deprecated. Instead, use mapreduce.job.name
14/12/25 20:37:26 INFO Configuration.deprecation: mapreduce.inputformat.class is deprecated. Instead, use mapreduce.job.inputformat.class
14/12/25 20:37:26 INFO Configuration.deprecation: mapred.input.dir is deprecated. Instead, use mapreduce.input.fileinputformat.inputdir
14/12/25 20:37:26 INFO Configuration.deprecation: mapreduce.outputformat.class is deprecated. Instead, use mapreduce.job.outputformat.class
14/12/25 20:37:26 INFO Configuration.deprecation: mapred.job.queue.name is deprecated. Instead, use mapreduce.job.queuename
14/12/25 20:37:26 INFO Configuration.deprecation: mapred.cache.files.timestamps is deprecated. Instead, use mapreduce.job.cache.files.timestamps
14/12/25 20:37:26 INFO Configuration.deprecation: mapred.mapoutput.key.class is deprecated. Instead, use mapreduce.map.output.key.class
14/12/25 20:37:26 INFO Configuration.deprecation: mapred.working.dir is deprecated. Instead, use mapreduce.job.working.dir
14/12/25 20:37:26 INFO mapreduce.JobSubmitter: Submitting tokens for job: job_1411732575730_9936
14/12/25 20:37:27 INFO impl.YarnClientImpl: Submitted application application_1411732575730_9936 to ResourceManager at RTB-HDP-NN-01/192.168.13.15:8050
14/12/25 20:37:27 INFO mapreduce.Job: The url to track the job: http://RTB-HDP-NN-01:8088/proxy/application_1411732575730_9936/
14/12/25 20:37:27 INFO mapreduce.Job: Running job: job_1411732575730_9936
14/12/25 20:37:35 INFO mapreduce.Job: Job job_1411732575730_9936 running in uber mode : false
14/12/25 20:37:35 INFO mapreduce.Job:  map 0% reduce 0%
14/12/25 20:37:37 INFO mapreduce.Job: Job job_1411732575730_9936 completed successfully
14/12/25 20:37:38 INFO mapreduce.Job: Counters: 2
        Job Counters 
                Total time spent by all maps in occupied slots (ms)=0
                Total time spent by all reduces in occupied slots (ms)=0
14/12/25 20:37:38 WARN mapreduce.Counters: Group FileSystemCounters is deprecated. Use org.apache.hadoop.mapreduce.FileSystemCounter instead
14/12/25 20:37:38 INFO mapreduce.ExportJobBase: Transferred 0 bytes in 14.045 seconds (0 bytes/sec)
14/12/25 20:37:38 WARN mapreduce.Counters: Group org.apache.hadoop.mapred.Task$Counter is deprecated. Use org.apache.hadoop.mapreduce.TaskCounter instead
14/12/25 20:37:38 INFO mapreduce.ExportJobBase: Exported 0 records.