sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marcia Hon <marcia.hon...@gmail.com>
Subject Re: Cannot import table
Date Wed, 15 Mar 2017 21:04:35 GMT
Nope

On Mar 15, 2017 4:33 PM, "Douglas Spadotto" <dougspadotto@gmail.com> wrote:

> And did it work?
>
> Em 15 de mar de 2017 11:58 AM, "Marcia Hon" <marcia.hon.29@gmail.com>
> escreveu:
>
>> Yes, indeed I did
>>
>> On Wed, Mar 15, 2017 at 10:42 AM, Douglas Spadotto <
>> dougspadotto@gmail.com> wrote:
>>
>>> 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