Could you run the command with --verbose and provide the output? Also, what version of Sqoop are you using?

On Fri, May 8, 2015 at 12:28 AM, Hadoop User <kjayapal17@gmail.com> wrote:
 sqoop import --connect "jdbc:oracle:thin:@mysql.1521/PR" --username "edhdtaesvc" --P  --table "SAP.BUT000" --split-by "SAP.BUT000.PARTNER" --target-dir "/data/crmdq/CS2_PR/BUT000_MAP50" --as-avrodatafile --compression-codec org.apache.hadoop.io.compress.SnappyCodec -m 50



On May 8, 2015, at 12:22 AM, Abraham Elmahrek <abe@cloudera.com> wrote:

Hey there,

Can you send your sqoop command?

-Abe

On Thu, May 7, 2015 at 11:17 PM, Hadoop User <kjayapal17@gmail.com> wrote:


Sent from my iPhone

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

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





Rich Haase| Sr. Software Engineer | Pandora