hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Amrit Jangid <amrit.jan...@goibibo.com>
Subject Fwd: hive.HiveImport: FAILED:
Date Sun, 25 Oct 2015 09:06:14 GMT
Hi All,


I'm running a sqoop job for a table to import into Hive from mysql,
sometimes its works fine.but some time throw this Error:

* INFO hive.HiveImport: FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask.
MetaException(message:javax.jdo.JDODataStoreException: No operations
allowed after connection closed.*




Full Error message :


15/10/25 13:58:50 INFO hive.HiveImport: Loading uploaded data into Hive
15/10/25 13:58:53 INFO hive.HiveImport: 15/10/25 13:58:53 WARN
conf.HiveConf: DEPRECATED: Configuration property hive.metastore.local no
longer has any effect. Make sure to provide a valid value for
hive.metastore.uris if you are connecting to a remote metastore.
15/10/25 13:58:53 INFO hive.HiveImport:
15/10/25 13:58:53 INFO hive.HiveImport: Logging initialized using
configuration in
jar:file:/opt/cloudera/parcels/CDH-5.1.3-1.cdh5.1.3.p0.12/lib/hive/lib/hive-common-0.12.0-cdh5.1.3.jar!/hive-log4j.properties
*15/10/25 13:58:57 INFO hive.HiveImport: FAILED: Execution Error, return
code 1 from org.apache.hadoop.hive.ql.exec.DDLTask.
MetaException(message:javax.jdo.JDODataStoreException: No operations
allowed after connection closed.*
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:451)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.api.jdo.JDOPersistenceManager.jdoMakePersistent(JDOPersistenceManager.java:732)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.api.jdo.JDOPersistenceManager.makePersistent(JDOPersistenceManager.java:752)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.apache.hadoop.hive.metastore.ObjectStore.createTable(ObjectStore.java:684)
15/10/25 13:58:57 INFO hive.HiveImport: at
sun.reflect.GeneratedMethodAccessor69.invoke(Unknown Source)
15/10/25 13:58:57 INFO hive.HiveImport: at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
15/10/25 13:58:57 INFO hive.HiveImport: at
java.lang.reflect.Method.invoke(Method.java:601)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.apache.hadoop.hive.metastore.RawStoreProxy.invoke(RawStoreProxy.java:108)
15/10/25 13:58:57 INFO hive.HiveImport: at $Proxy0.createTable(Unknown
Source)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_table_core(HiveMetaStore.java:1078)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_table_with_environment_context(HiveMetaStore.java:1111)
15/10/25 13:58:57 INFO hive.HiveImport: at
sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source)
15/10/25 13:58:57 INFO hive.HiveImport: at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
15/10/25 13:58:57 INFO hive.HiveImport: at
java.lang.reflect.Method.invoke(Method.java:601)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:105)
15/10/25 13:58:57 INFO hive.HiveImport: at
$Proxy1.create_table_with_environment_context(Unknown Source)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$create_table_with_environment_context.getResult(ThriftHiveMetastore.java:6483)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$create_table_with_environment_context.getResult(ThriftHiveMetastore.java:6467)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:110)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:107)
15/10/25 13:58:57 INFO hive.HiveImport: at
java.security.AccessController.doPrivileged(Native Method)
15/10/25 13:58:57 INFO hive.HiveImport: at
javax.security.auth.Subject.doAs(Subject.java:415)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1554)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.apache.hadoop.hive.shims.HadoopShimsSecure.doAs(HadoopShimsSecure.java:556)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.apache.hadoop.hive.metastore.TUGIBasedProcessor.process(TUGIBasedProcessor.java:118)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:244)
15/10/25 13:58:57 INFO hive.HiveImport: at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
15/10/25 13:58:57 INFO hive.HiveImport: at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
15/10/25 13:58:57 INFO hive.HiveImport: at
java.lang.Thread.run(Thread.java:722)
15/10/25 13:58:57 INFO hive.HiveImport: NestedThrowablesStackTrace:
15/10/25 13:58:57 INFO hive.HiveImport:
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No
operations allowed after connection closed.
15/10/25 13:58:57 INFO hive.HiveImport: at
sun.reflect.GeneratedConstructorAccessor62.newInstance(Unknown Source)
15/10/25 13:58:57 INFO hive.HiveImport: at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
15/10/25 13:58:57 INFO hive.HiveImport: at
java.lang.reflect.Constructor.newInstance(Constructor.java:525)
15/10/25 13:58:57 INFO hive.HiveImport: at
com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
15/10/25 13:58:57 INFO hive.HiveImport: at
com.mysql.jdbc.Util.getInstance(Util.java:387)
15/10/25 13:58:57 INFO hive.HiveImport: at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
15/10/25 13:58:57 INFO hive.HiveImport: at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
15/10/25 13:58:57 INFO hive.HiveImport: at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
15/10/25 13:58:57 INFO hive.HiveImport: at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:862)
15/10/25 13:58:57 INFO hive.HiveImport: at
com.mysql.jdbc.ConnectionImpl.throwConnectionClosedException(ConnectionImpl.java:1237)
15/10/25 13:58:57 INFO hive.HiveImport: at
com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1232)
15/10/25 13:58:57 INFO hive.HiveImport: at
com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:4832)
15/10/25 13:58:57 INFO hive.HiveImport: at
com.jolbox.bonecp.ConnectionHandle.setAutoCommit(ConnectionHandle.java:1063)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getConnection(ConnectionFactoryImpl.java:418)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.store.rdbms.valuegenerator.TableGenerator.createRepository(TableGenerator.java:270)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.store.rdbms.valuegenerator.AbstractRDBMSGenerator.obtainGenerationBlock(AbstractRDBMSGenerator.java:162)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.store.valuegenerator.AbstractGenerator.obtainGenerationBlock(AbstractGenerator.java:197)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.store.valuegenerator.AbstractGenerator.next(AbstractGenerator.java:105)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.store.rdbms.RDBMSStoreManager.getStrategyValueForGenerator(RDBMSStoreManager.java:2019)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.store.AbstractStoreManager.getStrategyValue(AbstractStoreManager.java:1385)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.ExecutionContextImpl.newObjectId(ExecutionContextImpl.java:3727)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.state.JDOStateManager.setIdentity(JDOStateManager.java:2574)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.state.JDOStateManager.initialiseForPersistentNew(JDOStateManager.java:526)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.state.ObjectProviderFactoryImpl.newForPersistentNew(ObjectProviderFactoryImpl.java:202)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.ExecutionContextImpl.newObjectProviderForPersistentNew(ExecutionContextImpl.java:1326)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.ExecutionContextImpl.persistObjectInternal(ExecutionContextImpl.java:2123)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.ExecutionContextImpl.persistObjectInternal(ExecutionContextImpl.java:2212)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.store.rdbms.mapping.java.PersistableMapping.setObjectAsValue(PersistableMapping.java:567)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.store.rdbms.mapping.java.PersistableMapping.setObject(PersistableMapping.java:326)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.store.rdbms.fieldmanager.ParameterSetter.storeObjectField(ParameterSetter.java:193)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.state.JDOStateManager.providedObjectField(JDOStateManager.java:1272)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.apache.hadoop.hive.metastore.model.MStorageDescriptor.jdoProvideField(MStorageDescriptor.java)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.apache.hadoop.hive.metastore.model.MStorageDescriptor.jdoProvideFields(MStorageDescriptor.java)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.state.JDOStateManager.provideFields(JDOStateManager.java:1349)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.store.rdbms.request.InsertRequest.execute(InsertRequest.java:289)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.store.rdbms.RDBMSPersistenceHandler.insertTable(RDBMSPersistenceHandler.java:167)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.store.rdbms.RDBMSPersistenceHandler.insertObject(RDBMSPersistenceHandler.java:143)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.state.JDOStateManager.internalMakePersistent(JDOStateManager.java:3777)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.state.JDOStateManager.makePersistent(JDOStateManager.java:3753)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.ExecutionContextImpl.persistObjectInternal(ExecutionContextImpl.java:2124)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.ExecutionContextImpl.persistObjectInternal(ExecutionContextImpl.java:2212)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.store.rdbms.mapping.java.PersistableMapping.setObjectAsValue(PersistableMapping.java:567)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.store.rdbms.mapping.java.PersistableMapping.setObject(PersistableMapping.java:326)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.store.rdbms.fieldmanager.ParameterSetter.storeObjectField(ParameterSetter.java:193)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.state.JDOStateManager.providedObjectField(JDOStateManager.java:1272)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.apache.hadoop.hive.metastore.model.MTable.jdoProvideField(MTable.java)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.apache.hadoop.hive.metastore.model.MTable.jdoProvideFields(MTable.java)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.state.JDOStateManager.provideFields(JDOStateManager.java:1349)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.store.rdbms.request.InsertRequest.execute(InsertRequest.java:289)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.store.rdbms.RDBMSPersistenceHandler.insertTable(RDBMSPersistenceHandler.java:167)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.store.rdbms.RDBMSPersistenceHandler.insertObject(RDBMSPersistenceHandler.java:143)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.state.JDOStateManager.internalMakePersistent(JDOStateManager.java:3777)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.state.JDOStateManager.makePersistent(JDOStateManager.java:3753)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.ExecutionContextImpl.persistObjectInternal(ExecutionContextImpl.java:2124)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.ExecutionContextImpl.persistObjectWork(ExecutionContextImpl.java:1972)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.ExecutionContextImpl.persistObject(ExecutionContextImpl.java:1820)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.ExecutionContextThreadedImpl.persistObject(ExecutionContextThreadedImpl.java:217)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.api.jdo.JDOPersistenceManager.jdoMakePersistent(JDOPersistenceManager.java:727)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.api.jdo.JDOPersistenceManager.makePersistent(JDOPersistenceManager.java:752)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.apache.hadoop.hive.metastore.ObjectStore.createTable(ObjectStore.java:684)
15/10/25 13:58:57 INFO hive.HiveImport: at
sun.reflect.GeneratedMethodAccessor69.invoke(Unknown Source)
15/10/25 13:58:57 INFO hive.HiveImport: at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
15/10/25 13:58:57 INFO hive.HiveImport: at
java.lang.reflect.Method.invoke(Method.java:601)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.apache.hadoop.hive.metastore.RawStoreProxy.invoke(RawStoreProxy.java:108)
15/10/25 13:58:57 INFO hive.HiveImport: at $Proxy0.createTable(Unknown
Source)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_table_core(HiveMetaStore.java:1078)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_table_with_environment_context(HiveMetaStore.java:1111)
15/10/25 13:58:57 INFO hive.HiveImport: at
sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source)
15/10/25 13:58:57 INFO hive.HiveImport: at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
15/10/25 13:58:57 INFO hive.HiveImport: at
java.lang.reflect.Method.invoke(Method.java:601)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:105)
15/10/25 13:58:57 INFO hive.HiveImport: at
$Proxy1.create_table_with_environment_context(Unknown Source)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$create_table_with_environment_context.getResult(ThriftHiveMetastore.java:6483)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$create_table_with_environment_context.getResult(ThriftHiveMetastore.java:6467)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:110)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:107)
15/10/25 13:58:57 INFO hive.HiveImport: at
java.security.AccessController.doPrivileged(Native Method)
15/10/25 13:58:57 INFO hive.HiveImport: at
javax.security.auth.Subject.doAs(Subject.java:415)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1554)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.apache.hadoop.hive.shims.HadoopShimsSecure.doAs(HadoopShimsSecure.java:556)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.apache.hadoop.hive.metastore.TUGIBasedProcessor.process(TUGIBasedProcessor.java:118)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:244)
15/10/25 13:58:57 INFO hive.HiveImport: at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
15/10/25 13:58:57 INFO hive.HiveImport: at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
15/10/25 13:58:57 INFO hive.HiveImport: at
java.lang.Thread.run(Thread.java:722)
15/10/25 13:58:57 INFO hive.HiveImport: Caused by:
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications
link failure
15/10/25 13:58:57 INFO hive.HiveImport:
15/10/25 13:58:57 INFO hive.HiveImport: The last packet successfully
received from the server was 598,352 milliseconds ago.  The last packet
sent successfully to the server was 1 milliseconds ago.
15/10/25 13:58:57 INFO hive.HiveImport: at
sun.reflect.GeneratedConstructorAccessor61.newInstance(Unknown Source)
15/10/25 13:58:57 INFO hive.HiveImport: at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
15/10/25 13:58:57 INFO hive.HiveImport: at
java.lang.reflect.Constructor.newInstance(Constructor.java:525)
15/10/25 13:58:57 INFO hive.HiveImport: at
com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
15/10/25 13:58:57 INFO hive.HiveImport: at
com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:983)
15/10/25 13:58:57 INFO hive.HiveImport: at
com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3457)
15/10/25 13:58:57 INFO hive.HiveImport: at
com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3357)
15/10/25 13:58:57 INFO hive.HiveImport: at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3797)
15/10/25 13:58:57 INFO hive.HiveImport: at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2470)
15/10/25 13:58:57 INFO hive.HiveImport: at
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2617)
15/10/25 13:58:57 INFO hive.HiveImport: at
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2546)
15/10/25 13:58:57 INFO hive.HiveImport: at
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2504)
15/10/25 13:58:57 INFO hive.HiveImport: at
com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1370)
15/10/25 13:58:57 INFO hive.HiveImport: at
com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3622)
15/10/25 13:58:57 INFO hive.HiveImport: at
com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3597)
15/10/25 13:58:57 INFO hive.HiveImport: at
com.jolbox.bonecp.ConnectionHandle.isReadOnly(ConnectionHandle.java:675)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getConnection(ConnectionFactoryImpl.java:400)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.store.rdbms.valuegenerator.TableGenerator.createRepository(TableGenerator.java:270)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.store.rdbms.valuegenerator.AbstractRDBMSGenerator.obtainGenerationBlock(AbstractRDBMSGenerator.java:162)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.store.valuegenerator.AbstractGenerator.obtainGenerationBlock(AbstractGenerator.java:197)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.store.valuegenerator.AbstractGenerator.next(AbstractGenerator.java:105)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.store.rdbms.RDBMSStoreManager.getStrategyValueForGenerator(RDBMSStoreManager.java:2019)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.store.AbstractStoreManager.getStrategyValue(AbstractStoreManager.java:1385)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.ExecutionContextImpl.newObjectId(ExecutionContextImpl.java:3727)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.state.JDOStateManager.setIdentity(JDOStateManager.java:2574)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.state.JDOStateManager.initialiseForPersistentNew(JDOStateManager.java:526)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.state.ObjectProviderFactoryImpl.newForPersistentNew(ObjectProviderFactoryImpl.java:202)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.ExecutionContextImpl.newObjectProviderForPersistentNew(ExecutionContextImpl.java:1326)
15/10/25 13:58:57 INFO hive.HiveImport: at
org.datanucleus.ExecutionContextImpl.persistObjectInternal(ExecutionContextImpl.java:2123)
15/10/25 13:58:57 INFO hive.HiveImport: ... 46 more
15/10/25 13:58:57 INFO hive.HiveImport: Caused by: java.io.EOFException:
Can not read response from server. Expected to read 4 bytes, read 0 bytes
before connection was unexpectedly lost.
15/10/25 13:58:57 INFO hive.HiveImport: at
com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2949)
15/10/25 13:58:57 INFO hive.HiveImport: at
com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3367)
15/10/25 13:58:57 INFO hive.HiveImport: ... 69 more
15/10/25 13:58:57 INFO hive.HiveImport: )
15/10/25 13:58:57 ERROR tool.ImportTool: Encountered IOException running
import job: java.io.IOException: Hive exited with status 1
at
org.apache.sqoop.hive.HiveImport.executeExternalHiveScript(HiveImport.java:385)
at org.apache.sqoop.hive.HiveImport.executeScript(HiveImport.java:335)
at org.apache.sqoop.hive.HiveImport.importTable(HiveImport.java:239)
at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:425)
at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:506)
at org.apache.sqoop.Sqoop.run(Sqoop.java:147)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:222)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:231)
at org.apache.sqoop.Sqoop.main(Sqoop.java:240)


-- 

Regards,
Amrit

-- 


Mime
View raw message