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)
