sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Douglas Spadotto <dougspado...@gmail.com>
Subject Re: Cannot import table
Date Wed, 15 Mar 2017 14:42:39 GMT
Hi Marcia,

Did you try to specify the port number in the JDBC URL?

jdbc:db2://<server name>: <portnumber>/<database name>

Regards,

Douglas

On Wed, Mar 15, 2017 at 10:16 AM, Marcia Hon <marcia.hon.29@gmail.com>
wrote:

> I try the following:
>
>    - sqoop import --driver com.ibm.db2.jcc.DB2Driver --connect
>    jdbc:db2://localhost/database?zeroDateTimeBehavior=convertToNull
>    --username username --password password --table schema.tablename
>    -hive-import -hive-table hive_sqoop1 --m 1
>
> And the following is the error message:
>
> 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. find: failed to restore initial working directory: Permission
> denied 17/03/14 21:09:00 INFO sqoop.Sqoop: Running Sqoop version:
> 1.4.6.2.5.0.0-1245 17/03/14 21:09:00 WARN tool.BaseSqoopTool: Setting your
> password on the command-line is insecure. Consider using -P instead.
> 17/03/14 21:09:00 INFO tool.BaseSqoopTool: Using Hive-specific delimiters
> for output. You can override 17/03/14 21:09:00 INFO tool.BaseSqoopTool:
> delimiters with --fields-terminated-by, etc. 17/03/14 21:09:00 WARN
> sqoop.ConnFactory: Parameter --driver is set to an explicit driver however
> appropriate connection manager is not being set (via --connection-manager).
> Sqoop is going to fall back to org.apache.sqoop.manager.GenericJdbcManager.
> Please specify explicitly which connection manager should be used next
> time. 17/03/14 21:09:00 INFO manager.SqlManager: Using default fetchSize of
> 1000 17/03/14 21:09:00 INFO tool.CodeGenTool: Beginning code generation
> 17/03/14 21:09:01 ERROR manager.SqlManager: Error executing statement:
> com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException:
> [jcc][t4][2057][11264][4.11.77] The application server rejected
> establishment of the connection. An attempt was made to access a database,
> CAMH1?zeroDateTimeBehavior=convertToNull, which was either not found or
> does not support transactions. ERRORCODE=-4499, SQLSTATE=08004
> com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException:
> [jcc][t4][2057][11264][4.11.77] The application server rejected
> establishment of the connection. An attempt was made to access a database,
> CAMH1?zeroDateTimeBehavior=convertToNull, which was either not found or
> does not support transactions. ERRORCODE=-4499, SQLSTATE=08004 at
> com.ibm.db2.jcc.am.gd.a(gd.java:319) at com.ibm.db2.jcc.am.gd.a(gd.java:365)
> at com.ibm.db2.jcc.t4.ab.u(ab.java:1674) at com.ibm.db2.jcc.t4.ab.n(ab.java:536)
> at com.ibm.db2.jcc.t4.ab.a(ab.java:343) at com.ibm.db2.jcc.t4.ab.a(ab.java:115)
> at com.ibm.db2.jcc.t4.b.m(b.java:1242) at com.ibm.db2.jcc.t4.b.b(b.java:1113)
> at com.ibm.db2.jcc.t4.b.d(b.java:696) at com.ibm.db2.jcc.t4.b.c(b.java:682)
> at com.ibm.db2.jcc.t4.b.a(b.java:367) at com.ibm.db2.jcc.t4.b.<init>(b.java:307)
> at com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:214)
> at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:460) at
> java.sql.DriverManager.getConnection(DriverManager.java:664) at
> java.sql.DriverManager.getConnection(DriverManager.java:247) at
> org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:904)
> 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) 17/03/14 21:09:01 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)
>



-- 
Visite: http://canseidesercowboy.wordpress.com/
Siga: @dougspadotto ou @excowboys
-----
Frodo: "I wish none of this had happened."
Gandalf: "So do all who live to see such times, but that is not for them to
decide. All we have to decide is what to do with the time that is given to
us."
-- Lord of the Rings: The Fellowship of the Ring (2001)

Mime
View raw message