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

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: connectors/sqlserver

Environment

Hortonworks Hadoop Sandbox, SQL Server 10.50.4000, Sqoop 1.4.6

• Assignee: Unassigned
• Reporter: webDEVILopers
• Created: 20/Nov/15 15:10
• Updated: 02/Dec/15 17:04

Description

I doing my first Sqoop import actually.

Looking at my SQL Server the correct working query for the user `john` would look like this:

SELECT TOP 1000 [ksttyp_id]
      ,[orgunit_nr]
      ,[ksttyp_nr]
      ,[bezeichnung]
  FROM [egec01_t].[integris].[kst_typ]

I run this import command:

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

The expected FROM clause is:

FROM [egec01_t].[integris].[kst_typ]

Instead I get:

Executing SQL statement: SELECT t.* FROM [integris.kst_typ] AS t WHERE 1=0

Is this relatedto Sqoop or to the SqlManager or CodeGenTool?

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