You are viewing a plain text version of this content. The canonical link for it is here.
Posted to mapreduce-user@hadoop.apache.org by Rich Haase <rh...@pandora.com> on 2015/05/08 07:46:04 UTC
Re:
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 <kj...@gmail.com>> wrote:
ORA-00907
Rich Haase| Sr. Software Engineer | Pandora
m (303) 887-1146 | rhaase@pandora.com<ma...@pandora.com>
Re: Sqoop command
Posted by Abraham Elmahrek <ab...@cloudera.com>.
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 <kj...@gmail.com> wrote:
> Hi ,
>
> here is the verbose ourput
>
>
>
>
>
>
>
>
>
>
>
> Thanks
> Jay
>
> On Fri, May 8, 2015 at 12:45 AM, Abraham Elmahrek <ab...@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 <kj...@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 <ab...@cloudera.com> wrote:
>>>
>>> Hey there,
>>>
>>> Can you send your sqoop command?
>>>
>>> -Abe
>>>
>>> On Thu, May 7, 2015 at 11:17 PM, Hadoop User <kj...@gmail.com>
>>> wrote:
>>>
>>>>
>>>>
>>>> Sent from my iPhone
>>>>
>>>> On May 7, 2015, at 10:51 PM, Rich Haase <rh...@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 <rh...@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 <kj...@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
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>
>
Re: Sqoop command
Posted by Kumar Jayapal <kj...@gmail.com>.
Hi ,
here is the verbose ourput
Thanks
Jay
On Fri, May 8, 2015 at 12:45 AM, Abraham Elmahrek <ab...@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 <kj...@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 <ab...@cloudera.com> wrote:
>>
>> Hey there,
>>
>> Can you send your sqoop command?
>>
>> -Abe
>>
>> On Thu, May 7, 2015 at 11:17 PM, Hadoop User <kj...@gmail.com>
>> wrote:
>>
>>>
>>>
>>> Sent from my iPhone
>>>
>>> On May 7, 2015, at 10:51 PM, Rich Haase <rh...@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 <rh...@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 <kj...@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
>>>
>>>
>>>
>>>
>>>
>>
>
Re: Sqoop command
Posted by Abraham Elmahrek <ab...@cloudera.com>.
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 <kj...@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 <ab...@cloudera.com> wrote:
>
> Hey there,
>
> Can you send your sqoop command?
>
> -Abe
>
> On Thu, May 7, 2015 at 11:17 PM, Hadoop User <kj...@gmail.com> wrote:
>
>>
>>
>> Sent from my iPhone
>>
>> On May 7, 2015, at 10:51 PM, Rich Haase <rh...@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 <rh...@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 <kj...@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
>>
>>
>>
>>
>>
>
Sqoop command
Posted by Hadoop User <kj...@gmail.com>.
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 <ab...@cloudera.com> wrote:
>
> Hey there,
>
> Can you send your sqoop command?
>
> -Abe
>
>> On Thu, May 7, 2015 at 11:17 PM, Hadoop User <kj...@gmail.com> wrote:
>>
>>
>> Sent from my iPhone
>>
>>> On May 7, 2015, at 10:51 PM, Rich Haase <rh...@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 <rh...@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 <kj...@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
>
Re:
Posted by Abraham Elmahrek <ab...@cloudera.com>.
Hey there,
Can you send your sqoop command?
-Abe
On Thu, May 7, 2015 at 11:17 PM, Hadoop User <kj...@gmail.com> wrote:
>
>
> Sent from my iPhone
>
> On May 7, 2015, at 10:51 PM, Rich Haase <rh...@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 <rh...@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 <kj...@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
>
>
>
>
>
Re:
Posted by Hadoop User <kj...@gmail.com>.
Sent from my iPhone
> On May 7, 2015, at 10:51 PM, Rich Haase <rh...@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 <rh...@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 <kj...@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
>
>
>
>
Re:
Posted by Hadoop User <kj...@gmail.com>.
Sent from my iPhone
> On May 7, 2015, at 10:51 PM, Rich Haase <rh...@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 <rh...@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 <kj...@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
>
>
>
>
Re:
Posted by Hadoop User <kj...@gmail.com>.
Sent from my iPhone
> On May 7, 2015, at 10:51 PM, Rich Haase <rh...@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 <rh...@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 <kj...@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
>
>
>
>
Re:
Posted by Hadoop User <kj...@gmail.com>.
Sent from my iPhone
> On May 7, 2015, at 10:51 PM, Rich Haase <rh...@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 <rh...@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 <kj...@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
>
>
>
>
Re:
Posted by Hadoop User <kj...@gmail.com>.
Sent from my iPhone
> On May 7, 2015, at 10:51 PM, Rich Haase <rh...@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 <rh...@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 <kj...@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
>
>
>
>
Re:
Posted by Rich Haase <rh...@pandora.com>.
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<ma...@sqoop.apache.org>.
On May 7, 2015, at 11:45 PM, Rich Haase <rh...@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 <kj...@gmail.com>> wrote:
ORA-00907
Rich Haase| Sr. Software Engineer | Pandora
m (303) 887-1146 | rhaase@pandora.com<ma...@pandora.com>
Rich Haase| Sr. Software Engineer | Pandora
m (303) 887-1146 | rhaase@pandora.com<ma...@pandora.com>
Re:
Posted by Rich Haase <rh...@pandora.com>.
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<ma...@sqoop.apache.org>.
On May 7, 2015, at 11:45 PM, Rich Haase <rh...@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 <kj...@gmail.com>> wrote:
ORA-00907
Rich Haase| Sr. Software Engineer | Pandora
m (303) 887-1146 | rhaase@pandora.com<ma...@pandora.com>
Rich Haase| Sr. Software Engineer | Pandora
m (303) 887-1146 | rhaase@pandora.com<ma...@pandora.com>
Re:
Posted by Rich Haase <rh...@pandora.com>.
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<ma...@sqoop.apache.org>.
On May 7, 2015, at 11:45 PM, Rich Haase <rh...@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 <kj...@gmail.com>> wrote:
ORA-00907
Rich Haase| Sr. Software Engineer | Pandora
m (303) 887-1146 | rhaase@pandora.com<ma...@pandora.com>
Rich Haase| Sr. Software Engineer | Pandora
m (303) 887-1146 | rhaase@pandora.com<ma...@pandora.com>
Re:
Posted by Rich Haase <rh...@pandora.com>.
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<ma...@sqoop.apache.org>.
On May 7, 2015, at 11:45 PM, Rich Haase <rh...@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 <kj...@gmail.com>> wrote:
ORA-00907
Rich Haase| Sr. Software Engineer | Pandora
m (303) 887-1146 | rhaase@pandora.com<ma...@pandora.com>
Rich Haase| Sr. Software Engineer | Pandora
m (303) 887-1146 | rhaase@pandora.com<ma...@pandora.com>