My bad here. I was using the oracle DB and using LIMIT which oracle does not support. Used Rownum instead.
This worked. sqoop import --connect <connect-string> --username <user> --password <pwd> --target-dir <dir> --query "select * from <table name> WHERE rownum <=5 AND \$CONDITIONS" --split-by CREATE_D On Wed, Jul 2, 2014 at 8:26 AM, Gwen Shapira <[email protected]> wrote: > Try: > > sqoop import --connect <connect-string> --username <user> --password <pwd> > --target-dir <dir> --query "select * from <table name> WHERE > \\$CONDITIONS LIMIT 5 " --split-by CREATE_D > > > > On Wed, Jul 2, 2014 at 8:22 AM, Binal Jhaveri <[email protected]> wrote: > >> sqoop import --connect <connect-string> --username <user> --password >> <pwd> --target-dir <dir> --query "select * from <table name> LIMIT 5 AND >> \\$CONDITIONS" --split-by CREATE_D does not work. >> >> >> On Tue, Jul 1, 2014 at 9:37 PM, Vikash Talanki -X (vtalanki - INFOSYS >> LIMITED at Cisco) <[email protected]> wrote: >> >>> Hi Binal, >>> >>> >>> >>> Can you please try this >>> >>> >>> >>> sqoop import --connect <connect-string> --username <user> --password >>> <pwd> --target-dir <dir> --query "select * from <table name> LIMIT 5 AND >>> \\$CONDITIONS" --split-by CREATE_D >>> >>> >>> >>> Thanks, >>> >>> Vikash Talanki >>> >>> +1 (408)838-4078 >>> >>> >>> >>> *From:* Binal Jhaveri [mailto:[email protected]] >>> *Sent:* Tuesday, July 01, 2014 9:01 PM >>> *To:* [email protected] >>> *Subject:* sqoop import with LIMIT clause in query >>> >>> >>> >>> 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) >>> >> >> >
