[ 
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

        

Reply via email to