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] >
