[jira] [Created] (SQOOP-2706) Wrong FROM clause generated when table includes dots on SQL Server 10.50.4000

["webDEVILopers (JIRA)" <ji...@apache.org>]

webDEVILopers created SQOOP-2706:
------------------------------------

             Summary: Wrong FROM clause generated when table includes dots on SQL Server 10.50.4000
                 Key: SQOOP-2706
                 URL: https://issues.apache.org/jira/browse/SQOOP-2706
             Project: Sqoop
          Issue Type: Bug
          Components: connectors/sqlserver
         Environment: Hortonworks Hadoop Sandbox, SQL Server 10.50.4000, Sqoop 1.4.6
            Reporter: webDEVILopers


I doing my first Sqoop import actually.

Looking at my SQL Server the correct working query for the user `john` would look like this:
{code}
SELECT TOP 1000 [ksttyp_id]
      ,[orgunit_nr]
      ,[ksttyp_nr]
      ,[bezeichnung]
  FROM [egec01_t].[integris].[kst_typ]
{code}

I run this import command:
{code}
sqoop import --connect "jdbc:sqlserver://example.com;username=john;password=1234;database=egec01_t" --table "integris.kst_typ" --target-dir /home/sqoop/ -as-textfile
{code}

The expected FROM clause is:
{code}
FROM [egec01_t].[integris].[kst_typ]
{code}

Instead I get:
{code}
Executing SQL statement: SELECT t.* FROM [integris.kst_typ] AS t WHERE 1=0
{code}

Is this relatedto Sqoop or to the SqlManager or CodeGenTool?

Possibly related issue:
https://issues.apache.org/jira/browse/SQOOP-476



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