Balu Vellanki created SQOOP-2702:
------------------------------------
Summary: TestIncrementalImport fails with java.sql.SQLException:
Column not found
Key: SQOOP-2702
URL: https://issues.apache.org/jira/browse/SQOOP-2702
Project: Sqoop
Issue Type: Bug
Components: test
Reporter: Balu Vellanki
Error occurs when building apache sqoop with command "ant clean test
hadoopversion=200". Stdout is
{code}
[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)$
{code}
The error in test-logs is as follows.
{code}
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)
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
