sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Muhunthan Manoharalingam (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (SQOOP-3294) com.microsoft.sqlserver.jdbc.SQLServerException: The "variant" data type is not supported.
Date Thu, 15 Mar 2018 10:34:00 GMT

     [ https://issues.apache.org/jira/browse/SQOOP-3294?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Muhunthan Manoharalingam updated SQOOP-3294:
--------------------------------------------
    Docs Text: 



  was:
When I do import-all-tables 

./sqoop import-all-tables \
--connect "jdbc:sqlserver://172.15.100.12;database=MyDB" \
--password "xxxxxxx" \
--username ssss \
--warehouse-dir "/sqoop/mssql/temp" -m 1
 
I exported few Tables but after few minutes I got following  following error

18/03/15 15:14:47 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM [EHR_DynamicFlowSheet]
AS t WHERE 1=0
18/03/15 15:14:47 ERROR manager.SqlManager: Error executing statement: com.microsoft.sqlserver.jdbc.SQLServerException:
The "variant" data type is not supported.
com.microsoft.sqlserver.jdbc.SQLServerException: The "variant" data type is not supported.
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:170)
	at com.microsoft.sqlserver.jdbc.TypeInfo.setFromTDS(dtv.java:1670)
	at com.microsoft.sqlserver.jdbc.StreamColumns.setFromTDS(StreamColumns.java:47)
	at com.microsoft.sqlserver.jdbc.SQLServerResultSet$1CursorInitializer.onColMetaData(SQLServerResultSet.java:196)
	at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:77)
	at com.microsoft.sqlserver.jdbc.SQLServerResultSet.<init>(SQLServerResultSet.java:295)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1465)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338)
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:281)
	at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:777)
	at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:786)
	at org.apache.sqoop.manager.SqlManager.getColumnInfoForRawQuery(SqlManager.java:289)
	at org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:260)
	at org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:246)
	at org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:327)
	at org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1872)
	at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1671)
	at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:106)
	at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:501)
	at org.apache.sqoop.tool.ImportAllTablesTool.run(ImportAllTablesTool.java:110)
	at org.apache.sqoop.Sqoop.run(Sqoop.java:147)
	at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
	at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183)
	at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234)
	at org.apache.sqoop.Sqoop.runTool(Sqoop.java:243)
	at org.apache.sqoop.Sqoop.main(Sqoop.java:252)
Mar 15, 2018 3:14:47 PM com.microsoft.sqlserver.jdbc.TDSParser throwUnexpectedTokenException
SEVERE: ConnectionID:442: getNextResult: Encountered unexpected unknown token (0x49)
Mar 15, 2018 3:14:47 PM com.microsoft.sqlserver.jdbc.TDSReader throwInvalidTDS
SEVERE: ConnectionID:442 got unexpected value in TDS response at offset:206



> com.microsoft.sqlserver.jdbc.SQLServerException: The "variant" data type is not supported.
> ------------------------------------------------------------------------------------------
>
>                 Key: SQOOP-3294
>                 URL: https://issues.apache.org/jira/browse/SQOOP-3294
>             Project: Sqoop
>          Issue Type: Bug
>          Components: connectors/sqlserver
>    Affects Versions: 1.4.7
>            Reporter: Muhunthan Manoharalingam
>            Priority: Major
>              Labels: mssql
>
> When I do import-all-tables 
> ./sqoop import-all-tables \ 
> --connect "jdbc:[sqlserver://172.15.100.12;database=MyDB]" \ 
> --password "xxxxxxx" \ 
> --username ssss \ 
> --warehouse-dir "/sqoop/mssql/temp" -m 1 
>   
> I exported few Tables but after few minutes I got following error 
>  
> {code:java}
> 18/03/15 15:14:47 ERROR manager.SqlManager: Error executing statement: com.microsoft.sqlserver.jdbc.SQLServerException:
The "variant" data type is not supported.
> com.microsoft.sqlserver.jdbc.SQLServerException: The "variant" data type is not supported.
> at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:170)
> at com.microsoft.sqlserver.jdbc.TypeInfo.setFromTDS(dtv.java:1670)
> at com.microsoft.sqlserver.jdbc.StreamColumns.setFromTDS(StreamColumns.java:47)
> at com.microsoft.sqlserver.jdbc.SQLServerResultSet$1CursorInitializer.onColMetaData(SQLServerResultSet.java:196)
> at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:77)
> at com.microsoft.sqlserver.jdbc.SQLServerResultSet.<init>(SQLServerResultSet.java:295)
> at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1465)
> at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)
> at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338)
> at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)
> at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)
> at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)
> at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)
> at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:281)
> at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:777)
> at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:786)
> at org.apache.sqoop.manager.SqlManager.getColumnInfoForRawQuery(SqlManager.java:289)
> at org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:260)
> at org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:246)
> at org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:327)
> at org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1872)
> at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1671)
> at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:106)
> at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:501)
> at org.apache.sqoop.tool.ImportAllTablesTool.run(ImportAllTablesTool.java:110)
> at org.apache.sqoop.Sqoop.run(Sqoop.java:147)
> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
> at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183)
> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234)
> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:243)
> at org.apache.sqoop.Sqoop.main(Sqoop.java:252)
> Mar 15, 2018 3:14:47 PM com.microsoft.sqlserver.jdbc.TDSParser throwUnexpectedTokenException
> SEVERE: ConnectionID:442: getNextResult: Encountered unexpected unknown token (0x49)
> Mar 15, 2018 3:14:47 PM com.microsoft.sqlserver.jdbc.TDSReader throwInvalidTDS
> SEVERE: ConnectionID:442 got unexpected value in TDS response at offset:206
> 18/03/15 15:14:47 ERROR tool.ImportAllTablesTool: Encountered IOException running import
job: java.io.IOException: No columns to generate for ClassWriter
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message