分享

CDH hue sqoop 创建hive表报错

kingba 发表于 2018-3-29 17:12:54 [显示全部楼层] 回帖奖励 阅读模式 关闭右栏 2 7552
>> Invoking Sqoop command line now >>>

2018-03-29 17:05:43,735 [main] WARN  org.apache.sqoop.tool.SqoopTool  - $SQOOP_CONF_DIR has not been set in the environment. Cannot check for additional configuration.
2018-03-29 17:05:43,816 [main] INFO  org.apache.sqoop.Sqoop  - Running Sqoop version: 1.4.6-cdh5.13.1
2018-03-29 17:05:43,836 [main] INFO  org.apache.sqoop.tool.BaseSqoopTool  - Using Hive-specific delimiters for output. You can override
2018-03-29 17:05:43,837 [main] INFO  org.apache.sqoop.tool.BaseSqoopTool  - delimiters with --fields-terminated-by, etc.
2018-03-29 17:05:43,853 [main] WARN  org.apache.sqoop.ConnFactory  - $SQOOP_CONF_DIR has not been set in the environment. Cannot check for additional configuration.
2018-03-29 17:05:43,981 [main] INFO  org.apache.sqoop.manager.MySQLManager  - Preparing to use a MySQL streaming resultset.
2018-03-29 17:05:44,577 [main] INFO  org.apache.sqoop.manager.SqlManager  - Executing SQL statement: SELECT t.* FROM `city` AS t LIMIT 1
2018-03-29 17:05:44,595 [main] INFO  org.apache.sqoop.manager.SqlManager  - Executing SQL statement: SELECT t.* FROM `city` AS t LIMIT 1
2018-03-29 17:05:44,675 [main] INFO  org.apache.sqoop.hive.HiveImport  - Loading uploaded data into Hive

<<< Invocation of Sqoop command completed <<<

No child hadoop job is executed.
Intercepting System.exit(1)

<<< Invocation of Main class completed <<<

Failing Oozie Launcher, Main class [org.apache.oozie.action.hadoop.SqoopMain], exit code [1]

Oozie Launcher failed, finishing Hadoop job gracefully

Oozie Launcher, uploading action data to HDFS sequence file: hdfs://nameservice1/user/hue/oozie-oozi/0000076-180321111957595-oozie-oozi-W/sqoop-f04f--sqoop/action-data.seq
Successfully reset security manager from org.apache.oozie.action.hadoop.LauncherSecurityManager@1b5a1d85 to null

Oozie Launcher ends
sqoop:
create-hive-table --connect "jdbc:mysql://10.99.101.132:3306/hadooptest?usessl=false&user=crm&password=crmcrm" --table city --hive-table city  
无法创建hive表

已有(2)人评论

跳转到指定楼层
sstutu 发表于 2018-3-29 18:13:08

回帖奖励 +1 云币

上面应该是没有执行,参考
执行sqoop 时,报错
http://www.aboutyun.com/forum.php?mod=viewthread&tid=22024


回复

使用道具 举报

sstutu 发表于 2018-3-29 18:15:06
把引号转义下或则删除,可能是因为特殊符号造成的
"jdbc:mysql://10.99.101.132:3306/hadooptest?usessl=false&user=crm&password=crmcrm"
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

关闭

推荐上一条 /2 下一条