Oozie workflow sqoop配置query sql问题

workflow调度使用sqoop组件,query中sql之间必须用tab键分割,workflow在解析配置文件时,无法识别空格,只能使用tab键, 否则会报错,例如 --query "SELECT DROP_PARTITION('table_name','${dt}')"

报错信息如下:

2562 [main] ERROR org.apache.sqoop.tool.BaseSqoopTool - Error parsing arguments for eval: 2016-10-11 16:27:21,730 ERROR [main] tool.BaseSqoopTool (BaseSqoopTool.java:hasUnrecognizedArgs(304)) - Error parsing arguments for eval: 2562 [main] ERROR org.apache.sqoop.tool.BaseSqoopTool - Unrecognized argument: DROP_PARTITION('table_name','20160930')" 2016-10-11 16:27:21,730 ERROR [main] tool.BaseSqoopTool (BaseSqoopTool.java:hasUnrecognizedArgs(307)) - Unrecognized argument: DROP_PARTITION('table_name','20160930')"

用tab替换sql中的空格,问题解决

评论

暂无评论