[jira] [Commented] (SQOOP-1654) Sqoop cannot export data to SQLServer except user's default schema

[q79969786 (JIRA)]

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

q79969786 commented on SQOOP-1654:
----------------------------------


I  modify the org.apache.sqoop.manager.SQLServerManager  class with  two method 
like this:

  @Override
  protected String getListColumnsQuery(String tableName) {
    return "Select name from syscolumns Where ID=OBJECT_ID('" + tableName + 
"')";
  }


  public String escapeObjectName(String objectName) {
    if (null == objectName) {
      return null;
  }
    return  objectName;
  }

> Sqoop cannot export data to SQLServer  except user's default schema
> -------------------------------------------------------------------
>
>                 Key: SQOOP-1654
>                 URL: https://issues.apache.org/jira/browse/SQOOP-1654
>             Project: Sqoop
>          Issue Type: Improvement
>    Affects Versions: 1.4.4
>         Environment: hadoop-1.2.1 + hive-0.12 + sqoop-1.4.4 + SQLServer 2008
>            Reporter: q79969786
>
> if my default schame is dbo, I can export to table belongs dbo without 
> specify schame name, but if I  want to export to other schema, like 
> [guest].[test], sqoop use ' SELECT t.* FROM [[guest].[test]] AS t WHERE 1=0' 
> to get column types. It will throw Exception.
> I try to fix it by modify org.apache.sqoop.manager.SQLServerManager ant it 
> worked



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)