Uploaded image for project: 'Sqoop'
  1. Sqoop
  2. SQOOP-3294

com.microsoft.sqlserver.jdbc.SQLServerException: The "variant" data type is not supported.

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.4.7
    • Fix Version/s: None
    • Component/s: connectors/sqlserver
    • Labels:

      Description

      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 

       

      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
      
      

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              muhunthan Muhunthan Manoharalingam
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: