[SQOOP-2702] TestIncrementalImport fails with java.sql.SQLException: Column not found

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: test
• Assignee: Unassigned
• Reporter: Balu Vellanki
• Created: 19/Nov/15 23:31
• Updated: 19/Nov/15 23:31

Description

Error occurs when building apache sqoop with command "ant clean test hadoopversion=200". Stdout is

[junit] Running com.cloudera.sqoop.TestIncrementalImport
    [junit] Tests run: 21, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 50.233 sec
    [junit] Test com.cloudera.sqoop.TestIncrementalImport FAILED

....
checkfailure: [touch] Creating /Users/bvellanki/SourceCode/Apache/sqoop/build/testsfailed

		BUILD FAILED
		/Users/testUser/SourceCode/Apache/sqoop/build.xml:856: The following error occurred while executing this line:
		/Users/testUser/SourceCode/Apache/sqoop/build.xml:1247: Unit tests failed!

		Total time: 8 minutes 20 seconds
		testUser@HW11014:~/SourceCode/Apache/sqoop (trunk)$

The error in test-logs is as follows.

Testcase: testIncrementalHiveAppendEmptyThenFull took 0.202 sec
        Caused an ERROR
java.lang.RuntimeException: java.lang.RuntimeException: java.io.IOException: java.sql.SQLException: Column not found: id in statement [SELECT MAX("id") FROM "incrementalHiveAppendEmptyThenFull"]
java.lang.RuntimeException: java.lang.RuntimeException: java.lang.RuntimeException: java.io.IOException: java.sql.SQLException: Column not found: id in statement [SELECT MAX("id") FROM "incrementalHiveAppendEmptyThenFull"]
        at com.cloudera.sqoop.TestIncrementalImport.runJob(TestIncrementalImport.java:637)
        at com.cloudera.sqoop.TestIncrementalImport.runJob(TestIncrementalImport.java:616)
        at com.cloudera.sqoop.TestIncrementalImport.testIncrementalHiveAppendEmptyThenFull(TestIncrementalImport.java:1252)
Caused by: java.lang.RuntimeException: java.lang.RuntimeException: java.io.IOException: java.sql.SQLException: Column not found: id in statement [SELECT MAX("id") FROM "incrementalHiveAppendEmptyThenFull"]
        at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:184)
        at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:45)
        at com.cloudera.sqoop.TestIncrementalImport.runJob(TestIncrementalImport.java:632)
Caused by: java.lang.RuntimeException: java.io.IOException: java.sql.SQLException: Column not found: id in statement [SELECT MAX("id") FROM "incrementalHiveAppendEmptyThenFull"]
        at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:616)
        at org.apache.sqoop.tool.JobTool.execJob(JobTool.java:228)
        at org.apache.sqoop.tool.JobTool.run(JobTool.java:283)
        at org.apache.sqoop.Sqoop.run(Sqoop.java:143)
        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
        at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
Caused by: java.io.IOException: java.sql.SQLException: Column not found: id in statement [SELECT MAX("id") FROM "incrementalHiveAppendEmptyThenFull"]
        at org.apache.sqoop.tool.ImportTool.initIncrementalConstraints(ImportTool.java:316)
        at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:488)
        at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:605)
Caused by: java.sql.SQLException: Column not found: id in statement [SELECT MAX("id") FROM "incrementalHiveAppendEmptyThenFull"]
        at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
        at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
        at org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source)
        at org.apache.sqoop.tool.ImportTool.getMaxColumnId(ImportTool.java:231)
        at org.apache.sqoop.tool.ImportTool.initIncrementalConstraints(ImportTool.java:303)