Eric Lin created SQOOP-3061:
-------------------------------
Summary: Sqoop --options-file failed with error "Malformed option
in options file" even though the query is correct
Key: SQOOP-3061
URL: https://issues.apache.org/jira/browse/SQOOP-3061
Project: Sqoop
Issue Type: Bug
Affects Versions: 1.4.6
Reporter: Eric Lin
Priority: Minor
if you have the following in the options file:
--query
SELECT * FROM test WHERE a = 'b'
it will fail with the following error:
{code}
16/11/22 16:08:59 ERROR sqoop.Sqoop: Error while expanding arguments
java.lang.Exception: Malformed option in options
file(/tmp/sqoop_runner_from_stdin_1112_12354__sqoop_options_file): SELECT *
FROM test WHERE a = 'b'
at
org.apache.sqoop.util.OptionsFileUtil.removeQuoteCharactersIfNecessary(OptionsFileUtil.java:170)
at
org.apache.sqoop.util.OptionsFileUtil.removeQuotesEncolosingOption(OptionsFileUtil.java:136)
at
org.apache.sqoop.util.OptionsFileUtil.expandArguments(OptionsFileUtil.java:90)
at
com.cloudera.sqoop.util.OptionsFileUtil.expandArguments(OptionsFileUtil.java:33)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:199)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)
at org.apache.sqoop.Sqoop.main(Sqoop.java:236)
Malformed option in options
file(/tmp/sqoop_runner_from_stdin_1112_12354__sqoop_options_file): SELECT *
FROM test WHERE a = 'b'
{code}
This is caused by function
org.apache.sqoop.util.OptionsFileUtil.removeQuoteCharactersIfNecessary only
checks for starting and ending quotes and will fail if the query does not start
with a quote but ends with a quote, like the example query above.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
