sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Binal Jhaveri <binal...@gmail.com>
Subject sqoop import with LIMIT clause in query
Date Wed, 02 Jul 2014 04:01:16 GMT
I am trying to run a query to get only 5 rows. I am using it for debugging
purposes.

sqoop import --connect <connect-string> --username <user> --password <pwd>
--target-dir <dir> --query "select * from <table name> LIMIT 5" --split-by
CREATE_DATE

by running the above query, I get the below error:

Encountered IOException running import job: java.io.IOException: Query
[select * from MSP.SPORT_ACTIVITY LIMIT 5] must contain '$CONDITIONS' in
WHERE clause.

sqoop import --connect <connect-string> --username <user> --password <pwd>
--target-dir <dir> --query "select * from <table name> LIMIT 5 AND
\$CONDITIONS" --split-by CREATE_DATE

java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended


at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)

 at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)

Mime
View raw message