You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "Vidhya Parvathy R (JIRA)" <ji...@apache.org> on 2012/10/21 09:16:13 UTC
[jira] [Created] (SQOOP-637) Error while sqoop-ing from Oracle
tables that contain "$" in their tablenames
Vidhya Parvathy R created SQOOP-637:
----------------------------------------
Summary: Error while sqoop-ing from Oracle tables that contain "$" in their tablenames
Key: SQOOP-637
URL: https://issues.apache.org/jira/browse/SQOOP-637
Project: Sqoop
Issue Type: Bug
Components: tools
Affects Versions: 2.0.0
Reporter: Vidhya Parvathy R
Fix For: 2.0.0
When a table name contains the symbol "$" , sqoop does not identify the part of the name written after the $ sign . This happens for MYSQL and Oracle tables. Not sure whether this is an issue with other databases. What are the alternatives other than renaming the structured db's table name.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (SQOOP-637) Error while sqooping Oracle and Mysql
tables that contains $ sign in their names
Posted by "Jarek Jarcec Cecho (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-637?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jarek Jarcec Cecho updated SQOOP-637:
-------------------------------------
Affects Version/s: (was: 2.0.0)
> Error while sqooping Oracle and Mysql tables that contains $ sign in their names
> --------------------------------------------------------------------------------
>
> Key: SQOOP-637
> URL: https://issues.apache.org/jira/browse/SQOOP-637
> Project: Sqoop
> Issue Type: Bug
> Components: tools
> Reporter: Vidhya Parvathy R
>
> When a table name contains the symbol $ , sqoop does not identify the part of the name written after the $ sign . This happens for MYSQL and Oracle tables. Not sure whether this is an issue with other databases. What are the alternatives other than renaming the structured db's table name.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Resolved] (SQOOP-637) Error while sqooping Oracle and Mysql
tables that contains $ sign in their names
Posted by "Jarek Jarcec Cecho (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-637?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jarek Jarcec Cecho resolved SQOOP-637.
--------------------------------------
Resolution: Not A Problem
> Error while sqooping Oracle and Mysql tables that contains $ sign in their names
> --------------------------------------------------------------------------------
>
> Key: SQOOP-637
> URL: https://issues.apache.org/jira/browse/SQOOP-637
> Project: Sqoop
> Issue Type: Bug
> Components: tools
> Reporter: Vidhya Parvathy R
>
> When a table name contains the symbol $ , sqoop does not identify the part of the name written after the $ sign . This happens for MYSQL and Oracle tables. Not sure whether this is an issue with other databases. What are the alternatives other than renaming the structured db's table name.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (SQOOP-637) Error while sqooping Oracle and
Mysql tables that contains $ sign in their names
Posted by "Jarek Jarcec Cecho (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-637?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13480977#comment-13480977 ]
Jarek Jarcec Cecho commented on SQOOP-637:
------------------------------------------
Hi Vidhya,
would you mind sharing with us entire Sqoop command line? Based on your last comment, I'm not entirely sure that this is a sqoop error. It seems to me as a usual shell variable resolution that needs to be escaped if you want to pass the dolar sign to the application itself.
Jarcec
> Error while sqooping Oracle and Mysql tables that contains $ sign in their names
> --------------------------------------------------------------------------------
>
> Key: SQOOP-637
> URL: https://issues.apache.org/jira/browse/SQOOP-637
> Project: Sqoop
> Issue Type: Bug
> Components: tools
> Reporter: Vidhya Parvathy R
>
> When a table name contains the symbol $ , sqoop does not identify the part of the name written after the $ sign . This happens for MYSQL and Oracle tables. Not sure whether this is an issue with other databases. What are the alternatives other than renaming the structured db's table name.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Resolved] (SQOOP-637) Error while sqooping Oracle and Mysql
tables that contains $ sign in their names
Posted by "Vidhya Parvathy R (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-637?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vidhya Parvathy R resolved SQOOP-637.
--------------------------------------
Resolution: Fixed
Tired some trial and error methods. Seems like all you need to do is add a double quotes or a \ in front of the $ sign and sqoop will identify the symbol and the rest of the table name.
> Error while sqooping Oracle and Mysql tables that contains $ sign in their names
> --------------------------------------------------------------------------------
>
> Key: SQOOP-637
> URL: https://issues.apache.org/jira/browse/SQOOP-637
> Project: Sqoop
> Issue Type: Bug
> Components: tools
> Affects Versions: 2.0.0
> Reporter: Vidhya Parvathy R
> Fix For: 2.0.0
>
>
> When a table name contains the symbol $ , sqoop does not identify the part of the name written after the $ sign . This happens for MYSQL and Oracle tables. Not sure whether this is an issue with other databases. What are the alternatives other than renaming the structured db's table name.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Reopened] (SQOOP-637) Error while sqooping Oracle and Mysql
tables that contains $ sign in their names
Posted by "Jarek Jarcec Cecho (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-637?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jarek Jarcec Cecho reopened SQOOP-637:
--------------------------------------
> Error while sqooping Oracle and Mysql tables that contains $ sign in their names
> --------------------------------------------------------------------------------
>
> Key: SQOOP-637
> URL: https://issues.apache.org/jira/browse/SQOOP-637
> Project: Sqoop
> Issue Type: Bug
> Components: tools
> Reporter: Vidhya Parvathy R
>
> When a table name contains the symbol $ , sqoop does not identify the part of the name written after the $ sign . This happens for MYSQL and Oracle tables. Not sure whether this is an issue with other databases. What are the alternatives other than renaming the structured db's table name.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (SQOOP-637) Error while sqooping Oracle and Mysql
tables that contains $ sign in their names
Posted by "Vidhya Parvathy R (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-637?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vidhya Parvathy R updated SQOOP-637:
-------------------------------------
Summary: Error while sqooping Oracle and Mysql tables that contains $ sign in their names (was: Error while sqoop-ing from Oracle tables that contain "$" in their tablenames)
> Error while sqooping Oracle and Mysql tables that contains $ sign in their names
> --------------------------------------------------------------------------------
>
> Key: SQOOP-637
> URL: https://issues.apache.org/jira/browse/SQOOP-637
> Project: Sqoop
> Issue Type: Bug
> Components: tools
> Affects Versions: 2.0.0
> Reporter: Vidhya Parvathy R
> Fix For: 2.0.0
>
>
> When a table name contains the symbol $ , sqoop does not identify the part of the name written after the $ sign . This happens for MYSQL and Oracle tables. Not sure whether this is an issue with other databases. What are the alternatives other than renaming the structured db's table name.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (SQOOP-637) Error while sqooping Oracle and Mysql
tables that contains $ sign in their names
Posted by "Jarek Jarcec Cecho (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-637?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jarek Jarcec Cecho updated SQOOP-637:
-------------------------------------
Fix Version/s: (was: 2.0.0)
> Error while sqooping Oracle and Mysql tables that contains $ sign in their names
> --------------------------------------------------------------------------------
>
> Key: SQOOP-637
> URL: https://issues.apache.org/jira/browse/SQOOP-637
> Project: Sqoop
> Issue Type: Bug
> Components: tools
> Reporter: Vidhya Parvathy R
>
> When a table name contains the symbol $ , sqoop does not identify the part of the name written after the $ sign . This happens for MYSQL and Oracle tables. Not sure whether this is an issue with other databases. What are the alternatives other than renaming the structured db's table name.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (SQOOP-637) Error while sqoop-ing from Oracle
tables that contain "$" in their tablenames
Posted by "Vidhya Parvathy R (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/SQOOP-637?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vidhya Parvathy R updated SQOOP-637:
-------------------------------------
Description: When a table name contains the symbol $ , sqoop does not identify the part of the name written after the $ sign . This happens for MYSQL and Oracle tables. Not sure whether this is an issue with other databases. What are the alternatives other than renaming the structured db's table name. (was: When a table name contains the symbol "$" , sqoop does not identify the part of the name written after the $ sign . This happens for MYSQL and Oracle tables. Not sure whether this is an issue with other databases. What are the alternatives other than renaming the structured db's table name.)
> Error while sqoop-ing from Oracle tables that contain "$" in their tablenames
> -----------------------------------------------------------------------------
>
> Key: SQOOP-637
> URL: https://issues.apache.org/jira/browse/SQOOP-637
> Project: Sqoop
> Issue Type: Bug
> Components: tools
> Affects Versions: 2.0.0
> Reporter: Vidhya Parvathy R
> Fix For: 2.0.0
>
>
> When a table name contains the symbol $ , sqoop does not identify the part of the name written after the $ sign . This happens for MYSQL and Oracle tables. Not sure whether this is an issue with other databases. What are the alternatives other than renaming the structured db's table name.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira