If Sqoop is generating the SQL for your import then you may have hit a bug in the way the SQL for Oracle is being generated.  I’d recommend emailing the Sqoop user mailing list: user@sqoop.apache.org

On May 7, 2015, at 11:45 PM, Rich Haase <rhaase@pandora.com> wrote:

I’m not a Sqoop user, but it looks like you have an error in your SQL.  -> Caused by: java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis

On May 7, 2015, at 11:34 PM, Kumar Jayapal <kjayapal17@gmail.com> wrote:

ORA-00907

Rich Haase| Sr. Software Engineer | Pandora
m (303) 887-1146 | rhaase@pandora.com





Rich Haase| Sr. Software Engineer | Pandora
m (303) 887-1146 | rhaase@pandora.com