Uploaded image for project: 'Sqoop (READ-ONLY)'
  1. Sqoop (READ-ONLY)
  2. SQOOP-167

SQLServer 2008 DateTimeOffset (SQL type -155) not supported for import

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: import
    • Labels:
      None
    • Environment:
      CentOS 5.2, CDH3B4

      Description

      I have a simple table in sqlserver with a couple of columns:

      timestamp : DateTimeOffset
      value : varchar(255)

      11/03/15 10:18:30 INFO tool.CodeGenTool: Beginning code generation
      11/03/15 10:18:31 INFO manager.SqlManager: Executing SQL statement: select a.* f rom TABLEX a where a.timestamp >= '20110228 00:00 :00 +00:00') AND (1 = 0)
      11/03/15 10:18:32 INFO manager.SqlManager: Executing SQL statement: select a.* f rom TABLEX a where a.timestamp >= '20110228 00:00 :00 +00:00') AND (1 = 0)
      11/03/15 10:18:32 ERROR orm.ClassWriter: Cannot resolve SQL type -155
      11/03/15 10:18:32 ERROR orm.ClassWriter: No Java type for SQL type -155
      11/03/15 10:18:32 ERROR orm.ClassWriter: No Java type for SQL type -155
      11/03/15 10:18:32 ERROR orm.ClassWriter: No Java type for SQL type -155
      11/03/15 10:18:32 ERROR orm.ClassWriter: No Java type for SQL type -155
      11/03/15 10:18:32 ERROR orm.ClassWriter: No Java type for SQL type -155
      11/03/15 10:18:32 ERROR orm.ClassWriter: No Java type for SQL type -155
      11/03/15 10:18:32 ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.Null PointerException
      java.lang.NullPointerException
      at com.cloudera.sqoop.orm.ClassWriter.parseNullVal(ClassWriter.java:745)
      at com.cloudera.sqoop.orm.ClassWriter.parseColumn(ClassWriter.java:770)
      at com.cloudera.sqoop.orm.ClassWriter.generateParser(ClassWriter.java:84 4)
      at com.cloudera.sqoop.orm.ClassWriter.generateClassForColumns(ClassWrite r.java:1125)
      at com.cloudera.sqoop.orm.ClassWriter.generate(ClassWriter.java:990)
      at com.cloudera.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
      at com.cloudera.sqoop.tool.ImportTool.importTable(ImportTool.java:337)
      at com.cloudera.sqoop.tool.ImportTool.run(ImportTool.java:423)
      at com.cloudera.sqoop.Sqoop.run(Sqoop.java:144)
      at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
      at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:79)
      at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:180)
      at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:218)
      at com.cloudera.sqoop.Sqoop.main(Sqoop.java:228)

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              stunney Stephen Tunney
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: