Hi,

How to parse this query properly with the command line.

oozie sqoop -oozie http://localhost:11000/oozie -command import --connect
jdbc:mysql://localhost:3306/db --username root --password "" --query
"SELECT * FROM table WHERE (year=2015 AND month=01) AND \$CONDITIONS"
--target-dir '/output' -m 1 -config job.properties

The query breaks at place where it sees first = after YEAR.

The generated workflow is

      <arg>--query</arg>
      <arg>SELECT * FROM table WHERE (year</arg>
      <arg>2015 AND month</arg>
      <arg>01) AND $CONDITIONS</arg>

Thanks,

Jagat Singh

Reply via email to