punit gupta created SQOOP-3466:
----------------------------------
Summary: sqoop import table from sqlite3
Key: SQOOP-3466
URL: https://issues.apache.org/jira/browse/SQOOP-3466
Project: Sqoop
Issue Type: Bug
Environment: *sqoop version*
Warning: /usr/hdp/2.5.0.0-1245/accumulo does not exist! Accumulo imports will
fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
20/02/16 10:03:45 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6.2.5.0.0-1245
Sqoop 1.4.6.2.5.0.0-1245
Reporter: punit gupta
sqoop import -fs local --connect jdbc:sqlite:movies.db --table moveislite3
--target-dir /~ --driver org.sqlite.JDBC --relaxed-isolation
*Error :*
20/02/16 10:01:59 ERROR manager.SqlManager: Error executing statement:
java.sql.SQLException: SQLite supports only TRANSACTION_SERIALIZABLE and
TRANSACTION_READ_UNCOMMITTED.
java.sql.SQLException: SQLite supports only TRANSACTION_SERIALIZABLE and
TRANSACTION_READ_UNCOMMITTED.
at
org.sqlite.jdbc3.JDBC3Connection.setTransactionIsolation(JDBC3Connection.java:81)
at org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:910)
at
org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52)
at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:763)
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:328)
at org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1853)
at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1653)
at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:107)
at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:488)
at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:615)
at org.apache.sqoop.Sqoop.run(Sqoop.java:147)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:225)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234)
at org.apache.sqoop.Sqoop.main(Sqoop.java:243)
20/02/16 10:01:59 ERROR tool.ImportTool: Encountered IOException running import
job: java.io.IOException: No columns to generate for ClassWriter
at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1659)
at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:107)
at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:488)
at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:615)
at org.apache.sqoop.Sqoop.run(Sqoop.java:147)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:225)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234)
at org.apache.sqoop.Sqoop.main(Sqoop.java:243)
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
