Try putting conditions before the limit clause Birch On Jul 2, 2014 12:37 AM, "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) >
