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 -
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

> 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


View raw message