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中的空格，问题解决

 

 

 

转载于:https://my.oschina.net/rossiter/blog/756990