[
https://issues.apache.org/jira/browse/SQOOP-2706?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15036138#comment-15036138
]
webDEVILopers commented on SQOOP-2706:
--------------------------------------
I also tried a general "list-databases" command which ended with an "ERROR
invalid object name" for the dotted table names too.
ERROR manager.CatalogQueryManager: Failed to list databases
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'SYS.DAT...
I also opened a question on Stackoverflow:
http://stackoverflow.com/questions/34048416/sqoop-invalid-object-name-error-caused-by-wrong-from-clause-generated-when-table
> 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)
