sqoop 从oracle到hive 命令报错

0 0

sqoop 从oracle到hive 命令报错5

这是复制表结构的命令，报错如下：
[hadoop@hadoop-t04 ~]$ sqoop create-hive-table --connect jdbc:oracle:thin:@172.17.1.188:1521:lhorcl --username sq --password sq --table buyy --hive-table buyy
12/01/31 10:37:06 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
12/01/31 10:37:06 INFO tool.BaseSqoopTool: Using Hive-specific delimiters for output. You can override
12/01/31 10:37:06 INFO tool.BaseSqoopTool: delimiters with --fields-terminated-by, etc.
12/01/31 10:37:07 INFO manager.SqlManager: Using default fetchSize of 1000
12/01/31 10:37:07 INFO hive.HiveImport: Loading uploaded data into Hive
12/01/31 10:37:07 INFO manager.OracleManager: Time zone has been set to GMT
12/01/31 10:37:07 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM buyy t WHERE 1=0
12/01/31 10:37:09 INFO hive.HiveImport: Hive history file=/tmp/hadoop/hive_job_log_hadoop_201201311037_2039989600.txt
12/01/31 10:37:09 INFO hive.HiveImport: FAILED: Parse Error: line 1:36 mismatched input ')' expecting Identifier near '(' in column specification
12/01/31 10:37:09 INFO hive.HiveImport:
12/01/31 10:37:09 ERROR tool.CreateHiveTableTool: Encountered IOException running create table job: java.io.IOException: Hive exited with status 11
        at com.cloudera.sqoop.hive.HiveImport.executeExternalHiveScript(HiveImport.java:349)
        at com.cloudera.sqoop.hive.HiveImport.executeScript(HiveImport.java:299)
        at com.cloudera.sqoop.hive.HiveImport.importTable(HiveImport.java:241)
        at com.cloudera.sqoop.tool.CreateHiveTableTool.run(CreateHiveTableTool.java:60)
        at com.cloudera.sqoop.Sqoop.run(Sqoop.java:146)
        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
        at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:182)
        at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:221)
        at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:230)
        at com.cloudera.sqoop.Sqoop.main(Sqoop.java:239)

使用import命令，报错如下：
[hadoop@hadoop-t04 ~]$ sqoop import --connect jdbc:oracle:thin:@172.17.1.188:1521:lhorcl --username sq --password sq --table buyy --hive-import
12/01/31 10:34:58 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
12/01/31 10:34:58 INFO tool.BaseSqoopTool: Using Hive-specific delimiters for output. You can override
12/01/31 10:34:58 INFO tool.BaseSqoopTool: delimiters with --fields-terminated-by, etc.
12/01/31 10:34:58 INFO manager.SqlManager: Using default fetchSize of 1000
12/01/31 10:34:58 INFO tool.CodeGenTool: Beginning code generation
12/01/31 10:34:59 INFO manager.OracleManager: Time zone has been set to GMT
12/01/31 10:34:59 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM buyy t WHERE 1=0
12/01/31 10:34:59 ERROR tool.ImportTool: Imported Failed: Attempted to generate class with no columns!
希望大牛帮解决。