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 --