sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Abhijeet Gaikwad (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SQOOP-521) Import fails on tables with names containing hyphens ( - )
Date Tue, 24 Jul 2012 18:07:34 GMT

    [ https://issues.apache.org/jira/browse/SQOOP-521?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13421596#comment-13421596
] 

Abhijeet Gaikwad commented on SQOOP-521:
----------------------------------------

Table names can contain hyphen in SQL Server, but when using them they should be escaped with
double quotes or square brackets. See -
http://msdn.microsoft.com/en-us/library/ms175874%28v=sql.100%29.aspx
Current SQL Server Manager in SQOOP does not escape identifier names.
I will work on adding this support for SQL Server.

Till then, as a work around you can try escaping them when you specify the table name on SQOOP
command-line.


                
> Import fails on tables with names containing hyphens ( - )
> ----------------------------------------------------------
>
>                 Key: SQOOP-521
>                 URL: https://issues.apache.org/jira/browse/SQOOP-521
>             Project: Sqoop
>          Issue Type: Bug
>          Components: codegen
>    Affects Versions: 1.3.0
>            Reporter: Glyton Camilleri
>
> Table import fails when the table name contains hyphens. This issue was noticed when
importing through SQLServer 2008, which allows hyphens in table names. 

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message