sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abraham Elmahrek <...@cloudera.com>
Subject Re: Sqoop command
Date Fri, 08 May 2015 17:01:03 GMT
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 <kjayapal17@gmail.com> wrote:

> Hi ,
>
> here is the verbose ourput
>
>
>
>
>
>
>
>
>
>
>
> Thanks
> Jay
>
> On Fri, May 8, 2015 at 12:45 AM, Abraham Elmahrek <abe@cloudera.com>
> 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 <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
>>>> m (303) 887-1146 | rhaase@pandora.com
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>   *Rich Haase*| Sr. Software Engineer | Pandora
>>>> m (303) 887-1146 | rhaase@pandora.com
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>
>

Mime
View raw message