Hey there, It seems your split by column has a single quote character that is messing up the SQL query. I would split by another column or provide a smarter " --boundary-query " to rectify this.
-Abe On Fri, May 8, 2015 at 6:05 AM, Kumar Jayapal <[email protected]> wrote: > Hi , > > here is the verbose ourput > > > > > > > > > > > > Thanks > Jay > > On Fri, May 8, 2015 at 12:45 AM, Abraham Elmahrek <[email protected]> > wrote: > >> 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 <[email protected]> >> 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 <[email protected]> wrote: >>> >>> Hey there, >>> >>> Can you send your sqoop command? >>> >>> -Abe >>> >>> On Thu, May 7, 2015 at 11:17 PM, Hadoop User <[email protected]> >>> wrote: >>> >>>> >>>> >>>> Sent from my iPhone >>>> >>>> On May 7, 2015, at 10:51 PM, Rich Haase <[email protected]> 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: [email protected]. >>>> >>>> On May 7, 2015, at 11:45 PM, Rich Haase <[email protected]> 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 <[email protected]> >>>> wrote: >>>> >>>> ORA-00907 >>>> >>>> >>>> *Rich Haase*| Sr. Software Engineer | Pandora >>>> m (303) 887-1146 | [email protected] >>>> >>>> >>>> >>>> >>>> >>>> *Rich Haase*| Sr. Software Engineer | Pandora >>>> m (303) 887-1146 | [email protected] >>>> >>>> >>>> >>>> >>>> >>> >> >
