在hue 使用oozie sqoop 从mysql 导入hive 失败
21:01:52.903 [2e864abd-c4a5-4eae-ad63-1715512e5bd1 main] INFO org.apache.hadoop.hive.metastore.HiveMetaStore - 0: Opening raw store with implementation class:org.apache.hadoop.hive.metastore.ObjectStore 21:01:52.904 [2e864abd-c4a5-4eae-ad63-1715512e5bd1 main] INFO org.apache.hadoop.hive.metastore.ObjectStore - ObjectStore, initialize called 21:01:52.907 [2e864abd-c4a5-4eae-ad63-1715512e5bd1 main] WARN org.apache.hadoop.hive.metastore.MetaStoreDirectSql - Self-test query [select "DB_ID" from "DBS"] failed; direct SQL is disabled javax.jdo.JDODataStoreException: Error executing SQL query "select "DB_ID" from "DBS"". at org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:543) ~[datanucleus-api-jdo-4.2.1.jar:?] at org.datanucleus.api.jdo.JDOQuery.executeInternal(JDOQuery.java:388) ~[datanucleus-api-jdo-4.2.1.jar:?] at org.datanucleus.api.jdo.JDOQuery.execute(JDOQuery.java:213) ~[datanucleus-api-jdo-4.2.1.jar:?] at org.apache.hadoop.hive.metastore.MetaStoreDirectSql.runTestQuery(MetaStoreDirectSql.java:243) [hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.MetaStoreDirectSql.<init>(MetaStoreDirectSql.java:146) [hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.ObjectStore.initializeHelper(ObjectStore.java:406) [hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:338) [hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:299) [hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:77) [hadoop-common-3.0.0-cdh6.0.0.jar:?] at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:137) [hadoop-common-3.0.0-cdh6.0.0.jar:?] at org.apache.hadoop.hive.metastore.RawStoreProxy.<init>(RawStoreProxy.java:58) [hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:67) [hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStoreForConf(HiveMetaStore.java:612) [hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMSForConf(HiveMetaStore.java:578) [hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:572) [hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:639) [hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:416) [hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:78) [hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:84) [hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6866) [hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:248) [hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.<init>(SessionHiveMetaStoreClient.java:70) [hive-exec-core.jar:2.1.1-cdh6.0.0] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_141] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) [?:1.8.0_141] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [?:1.8.0_141] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) [?:1.8.0_141] at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1700) [hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:80) [hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:130) [hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:101) [hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:3554) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3606) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3586) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.getAllFunctions(Hive.java:3840) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.reloadFunctions(Hive.java:246) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.registerAllFunctionsOnce(Hive.java:229) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.<init>(Hive.java:386) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.create(Hive.java:330) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.getInternal(Hive.java:310) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.get(Hive.java:352) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.get(Hive.java:348) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.Driver.dumpMetaCallTimingWithoutEx(Driver.java:716) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:668) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1347) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1480) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1267) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1257) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:239) [hive-cli.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:187) [hive-cli.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:409) [hive-cli.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:342) [hive-cli.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.cli.CliDriver.processReader(CliDriver.java:489) [hive-cli.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.cli.CliDriver.processFile(CliDriver.java:505) [hive-cli.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:808) [hive-cli.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:774) [hive-cli.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:701) [hive-cli.jar:2.1.1-cdh6.0.0] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_141] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_141] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_141] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_141] at org.apache.sqoop.hive.HiveImport.executeScript(HiveImport.java:341) [sqoop.jar:?] at org.apache.sqoop.hive.HiveImport.importTable(HiveImport.java:246) [sqoop.jar:?] at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:543) [sqoop.jar:?] at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:634) [sqoop.jar:?] at org.apache.sqoop.Sqoop.run(Sqoop.java:145) [sqoop.jar:?] at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76) [hadoop-common-3.0.0-cdh6.0.0.jar:?] at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) [sqoop.jar:?] at org.apache.sqoop.Sqoop.runTool(Sqoop.java:232) [sqoop.jar:?] at org.apache.sqoop.Sqoop.runTool(Sqoop.java:241) [sqoop.jar:?] at org.apache.sqoop.Sqoop.main(Sqoop.java:250) [sqoop.jar:?] at org.apache.oozie.action.hadoop.SqoopMain.runSqoopJob(SqoopMain.java:214) [oozie-sharelib-sqoop.jar:?] at org.apache.oozie.action.hadoop.SqoopMain.run(SqoopMain.java:199) [oozie-sharelib-sqoop.jar:?] at org.apache.oozie.action.hadoop.LauncherMain.run(LauncherMain.java:101) [oozie-sharelib-oozie-5.0.0-cdh6.0.0.jar:?] at org.apache.oozie.action.hadoop.SqoopMain.main(SqoopMain.java:51) [oozie-sharelib-sqoop.jar:?] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_141] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_141] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_141] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_141] at org.apache.oozie.action.hadoop.LauncherAM.runActionMain(LauncherAM.java:410) [oozie-sharelib-oozie-5.0.0-cdh6.0.0.jar:?] at org.apache.oozie.action.hadoop.LauncherAM.access$300(LauncherAM.java:55) [oozie-sharelib-oozie-5.0.0-cdh6.0.0.jar:?] at org.apache.oozie.action.hadoop.LauncherAM$2.run(LauncherAM.java:223) [oozie-sharelib-oozie-5.0.0-cdh6.0.0.jar:?] at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_141] at javax.security.auth.Subject.doAs(Subject.java:422) [?:1.8.0_141] at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1685) [hadoop-common-3.0.0-cdh6.0.0.jar:?] at org.apache.oozie.action.hadoop.LauncherAM.run(LauncherAM.java:217) [oozie-sharelib-oozie-5.0.0-cdh6.0.0.jar:?] at org.apache.oozie.action.hadoop.LauncherAM$1.run(LauncherAM.java:153) [oozie-sharelib-oozie-5.0.0-cdh6.0.0.jar:?] at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_141] at javax.security.auth.Subject.doAs(Subject.java:422) [?:1.8.0_141] at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1685) [hadoop-common-3.0.0-cdh6.0.0.jar:?] at org.apache.oozie.action.hadoop.LauncherAM.main(LauncherAM.java:141) [oozie-sharelib-oozie-5.0.0-cdh6.0.0.jar:?] Caused by: java.sql.SQLSyntaxErrorException: Table/View 'DBS' does not exist. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement42.<init>(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.jdbc.Driver42.newEmbedPreparedStatement(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) ~[derby-10.14.1.0.jar:?] at com.jolbox.bonecp.ConnectionHandle.prepareStatement(ConnectionHandle.java:1193) ~[bonecp-0.8.0.RELEASE.jar:?] at org.datanucleus.store.rdbms.SQLController.getStatementForQuery(SQLController.java:345) ~[datanucleus-rdbms-4.1.7.jar:?] at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getPreparedStatementForQuery(RDBMSQueryUtils.java:211) ~[datanucleus-rdbms-4.1.7.jar:?] at org.datanucleus.store.rdbms.query.SQLQuery.performExecute(SQLQuery.java:633) ~[datanucleus-rdbms-4.1.7.jar:?] at org.datanucleus.store.query.Query.executeQuery(Query.java:1844) ~[datanucleus-core-4.1.6.jar:?] at org.datanucleus.store.rdbms.query.SQLQuery.executeWithArray(SQLQuery.java:807) ~[datanucleus-rdbms-4.1.7.jar:?] at org.datanucleus.store.query.Query.execute(Query.java:1715) ~[datanucleus-core-4.1.6.jar:?] at org.datanucleus.api.jdo.JDOQuery.executeInternal(JDOQuery.java:371) ~[datanucleus-api-jdo-4.2.1.jar:?] ... 88 more Caused by: org.apache.derby.iapi.error.StandardException: Table/View 'DBS' does not exist. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.compile.FromList.bindTables(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement42.<init>(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.jdbc.Driver42.newEmbedPreparedStatement(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) ~[derby-10.14.1.0.jar:?] at com.jolbox.bonecp.ConnectionHandle.prepareStatement(ConnectionHandle.java:1193) ~[bonecp-0.8.0.RELEASE.jar:?] at org.datanucleus.store.rdbms.SQLController.getStatementForQuery(SQLController.java:345) ~[datanucleus-rdbms-4.1.7.jar:?] at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getPreparedStatementForQuery(RDBMSQueryUtils.java:211) ~[datanucleus-rdbms-4.1.7.jar:?] at org.datanucleus.store.rdbms.query.SQLQuery.performExecute(SQLQuery.java:633) ~[datanucleus-rdbms-4.1.7.jar:?] at org.datanucleus.store.query.Query.executeQuery(Query.java:1844) ~[datanucleus-core-4.1.6.jar:?] at org.datanucleus.store.rdbms.query.SQLQuery.executeWithArray(SQLQuery.java:807) ~[datanucleus-rdbms-4.1.7.jar:?] at org.datanucleus.store.query.Query.execute(Query.java:1715) ~[datanucleus-core-4.1.6.jar:?] at org.datanucleus.api.jdo.JDOQuery.executeInternal(JDOQuery.java:371) ~[datanucleus-api-jdo-4.2.1.jar:?] ... 88 more 21:01:52.910 [2e864abd-c4a5-4eae-ad63-1715512e5bd1 main] INFO org.apache.hadoop.hive.metastore.ObjectStore - Initialized ObjectStore 21:01:52.932 [2e864abd-c4a5-4eae-ad63-1715512e5bd1 main] WARN DataNucleus.Query - Query for candidates of org.apache.hadoop.hive.metastore.model.MVersionTable and subclasses resulted in no possible candidates org.datanucleus.store.rdbms.exceptions.MissingTableException: Required table missing : "VERSION" in Catalog "" Schema "". DataNucleus requires this table to perform its persistence operations. Either your MetaData is incorrect, or you need to enable "datanucleus.schema.autoCreateTables" at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:606) ~[datanucleus-rdbms-4.1.7.jar:?] at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:3365) ~[datanucleus-rdbms-4.1.7.jar:?] at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2877) ~[datanucleus-rdbms-4.1.7.jar:?] at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:119) ~[datanucleus-rdbms-4.1.7.jar:?] at org.datanucleus.store.rdbms.RDBMSStoreManager.manageClasses(RDBMSStoreManager.java:1608) ~[datanucleus-rdbms-4.1.7.jar:?] at org.datanucleus.store.rdbms.RDBMSStoreManager.getDatastoreClass(RDBMSStoreManager.java:671) ~[datanucleus-rdbms-4.1.7.jar:?] at org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:425) ~[datanucleus-rdbms-4.1.7.jar:?] at org.datanucleus.store.rdbms.query.JDOQLQuery.compileQueryFull(JDOQLQuery.java:864) [datanucleus-rdbms-4.1.7.jar:?] at org.datanucleus.store.rdbms.query.JDOQLQuery.compileInternal(JDOQLQuery.java:346) [datanucleus-rdbms-4.1.7.jar:?] at org.datanucleus.store.query.Query.executeQuery(Query.java:1805) [datanucleus-core-4.1.6.jar:?] at org.datanucleus.store.query.Query.executeWithArray(Query.java:1733) [datanucleus-core-4.1.6.jar:?] at org.datanucleus.store.query.Query.execute(Query.java:1715) [datanucleus-core-4.1.6.jar:?] at org.datanucleus.api.jdo.JDOQuery.executeInternal(JDOQuery.java:371) [datanucleus-api-jdo-4.2.1.jar:?] at org.datanucleus.api.jdo.JDOQuery.execute(JDOQuery.java:213) [datanucleus-api-jdo-4.2.1.jar:?] at org.apache.hadoop.hive.metastore.ObjectStore.getMSchemaVersion(ObjectStore.java:7675) [hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.ObjectStore.getMetaStoreSchemaVersion(ObjectStore.java:7654) [hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.ObjectStore.checkSchema(ObjectStore.java:7609) [hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.ObjectStore.verifySchema(ObjectStore.java:7593) [hive-metastore.jar:2.1.1-cdh6.0.0] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_141] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_141] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_141] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_141] at org.apache.hadoop.hive.metastore.RawStoreProxy.invoke(RawStoreProxy.java:101) [hive-metastore.jar:2.1.1-cdh6.0.0] at com.sun.proxy.$Proxy42.verifySchema(Unknown Source) [?:?] at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMSForConf(HiveMetaStore.java:579) [hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:572) [hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:639) [hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:416) [hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:78) [hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:84) [hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6866) [hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:248) [hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.<init>(SessionHiveMetaStoreClient.java:70) [hive-exec-core.jar:2.1.1-cdh6.0.0] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_141] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) [?:1.8.0_141] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [?:1.8.0_141] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) [?:1.8.0_141] at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1700) [hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:80) [hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:130) [hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:101) [hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:3554) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3606) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3586) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.getAllFunctions(Hive.java:3840) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.reloadFunctions(Hive.java:246) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.registerAllFunctionsOnce(Hive.java:229) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.<init>(Hive.java:386) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.create(Hive.java:330) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.getInternal(Hive.java:310) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.get(Hive.java:352) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.get(Hive.java:348) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.Driver.dumpMetaCallTimingWithoutEx(Driver.java:716) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:668) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1347) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1480) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1267) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1257) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:239) [hive-cli.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:187) [hive-cli.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:409) [hive-cli.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:342) [hive-cli.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.cli.CliDriver.processReader(CliDriver.java:489) [hive-cli.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.cli.CliDriver.processFile(CliDriver.java:505) [hive-cli.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:808) [hive-cli.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:774) [hive-cli.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:701) [hive-cli.jar:2.1.1-cdh6.0.0] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_141] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_141] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_141] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_141] at org.apache.sqoop.hive.HiveImport.executeScript(HiveImport.java:341) [sqoop.jar:?] at org.apache.sqoop.hive.HiveImport.importTable(HiveImport.java:246) [sqoop.jar:?] at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:543) [sqoop.jar:?] at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:634) [sqoop.jar:?] at org.apache.sqoop.Sqoop.run(Sqoop.java:145) [sqoop.jar:?] at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76) [hadoop-common-3.0.0-cdh6.0.0.jar:?] at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) [sqoop.jar:?] at org.apache.sqoop.Sqoop.runTool(Sqoop.java:232) [sqoop.jar:?] at org.apache.sqoop.Sqoop.runTool(Sqoop.java:241) [sqoop.jar:?] at org.apache.sqoop.Sqoop.main(Sqoop.java:250) [sqoop.jar:?] at org.apache.oozie.action.hadoop.SqoopMain.runSqoopJob(SqoopMain.java:214) [oozie-sharelib-sqoop.jar:?] at org.apache.oozie.action.hadoop.SqoopMain.run(SqoopMain.java:199) [oozie-sharelib-sqoop.jar:?] at org.apache.oozie.action.hadoop.LauncherMain.run(LauncherMain.java:101) [oozie-sharelib-oozie-5.0.0-cdh6.0.0.jar:?] at org.apache.oozie.action.hadoop.SqoopMain.main(SqoopMain.java:51) [oozie-sharelib-sqoop.jar:?] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_141] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_141] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_141] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_141] at org.apache.oozie.action.hadoop.LauncherAM.runActionMain(LauncherAM.java:410) [oozie-sharelib-oozie-5.0.0-cdh6.0.0.jar:?] at org.apache.oozie.action.hadoop.LauncherAM.access$300(LauncherAM.java:55) [oozie-sharelib-oozie-5.0.0-cdh6.0.0.jar:?] at org.apache.oozie.action.hadoop.LauncherAM$2.run(LauncherAM.java:223) [oozie-sharelib-oozie-5.0.0-cdh6.0.0.jar:?] at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_141] at javax.security.auth.Subject.doAs(Subject.java:422) [?:1.8.0_141] at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1685) [hadoop-common-3.0.0-cdh6.0.0.jar:?] at org.apache.oozie.action.hadoop.LauncherAM.run(LauncherAM.java:217) [oozie-sharelib-oozie-5.0.0-cdh6.0.0.jar:?] at org.apache.oozie.action.hadoop.LauncherAM$1.run(LauncherAM.java:153) [oozie-sharelib-oozie-5.0.0-cdh6.0.0.jar:?] at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_141] at javax.security.auth.Subject.doAs(Subject.java:422) [?:1.8.0_141] at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1685) [hadoop-common-3.0.0-cdh6.0.0.jar:?] at org.apache.oozie.action.hadoop.LauncherAM.main(LauncherAM.java:141) [oozie-sharelib-oozie-5.0.0-cdh6.0.0.jar:?] 21:01:52.933 [2e864abd-c4a5-4eae-ad63-1715512e5bd1 main] WARN hive.ql.metadata.Hive - Failed to register all functions. java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1702) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:80) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:130) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:101) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:3554) ~[hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3606) ~[hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3586) ~[hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.getAllFunctions(Hive.java:3840) ~[hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.reloadFunctions(Hive.java:246) ~[hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.registerAllFunctionsOnce(Hive.java:229) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.<init>(Hive.java:386) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.create(Hive.java:330) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.getInternal(Hive.java:310) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.get(Hive.java:352) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.get(Hive.java:348) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.Driver.dumpMetaCallTimingWithoutEx(Driver.java:716) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:668) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1347) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1480) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1267) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1257) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:239) [hive-cli.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:187) [hive-cli.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:409) [hive-cli.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:342) [hive-cli.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.cli.CliDriver.processReader(CliDriver.java:489) [hive-cli.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.cli.CliDriver.processFile(CliDriver.java:505) [hive-cli.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:808) [hive-cli.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:774) [hive-cli.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:701) [hive-cli.jar:2.1.1-cdh6.0.0] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_141] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_141] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_141] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_141] at org.apache.sqoop.hive.HiveImport.executeScript(HiveImport.java:341) [sqoop.jar:?] at org.apache.sqoop.hive.HiveImport.importTable(HiveImport.java:246) [sqoop.jar:?] at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:543) [sqoop.jar:?] at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:634) [sqoop.jar:?] at org.apache.sqoop.Sqoop.run(Sqoop.java:145) [sqoop.jar:?] at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76) [hadoop-common-3.0.0-cdh6.0.0.jar:?] at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) [sqoop.jar:?] at org.apache.sqoop.Sqoop.runTool(Sqoop.java:232) [sqoop.jar:?] at org.apache.sqoop.Sqoop.runTool(Sqoop.java:241) [sqoop.jar:?] at org.apache.sqoop.Sqoop.main(Sqoop.java:250) [sqoop.jar:?] at org.apache.oozie.action.hadoop.SqoopMain.runSqoopJob(SqoopMain.java:214) [oozie-sharelib-sqoop.jar:?] at org.apache.oozie.action.hadoop.SqoopMain.run(SqoopMain.java:199) [oozie-sharelib-sqoop.jar:?] at org.apache.oozie.action.hadoop.LauncherMain.run(LauncherMain.java:101) [oozie-sharelib-oozie-5.0.0-cdh6.0.0.jar:?] at org.apache.oozie.action.hadoop.SqoopMain.main(SqoopMain.java:51) [oozie-sharelib-sqoop.jar:?] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_141] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_141] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_141] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_141] at org.apache.oozie.action.hadoop.LauncherAM.runActionMain(LauncherAM.java:410) [oozie-sharelib-oozie-5.0.0-cdh6.0.0.jar:?] at org.apache.oozie.action.hadoop.LauncherAM.access$300(LauncherAM.java:55) [oozie-sharelib-oozie-5.0.0-cdh6.0.0.jar:?] at org.apache.oozie.action.hadoop.LauncherAM$2.run(LauncherAM.java:223) [oozie-sharelib-oozie-5.0.0-cdh6.0.0.jar:?] at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_141] at javax.security.auth.Subject.doAs(Subject.java:422) [?:1.8.0_141] at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1685) [hadoop-common-3.0.0-cdh6.0.0.jar:?] at org.apache.oozie.action.hadoop.LauncherAM.run(LauncherAM.java:217) [oozie-sharelib-oozie-5.0.0-cdh6.0.0.jar:?] at org.apache.oozie.action.hadoop.LauncherAM$1.run(LauncherAM.java:153) [oozie-sharelib-oozie-5.0.0-cdh6.0.0.jar:?] at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_141] at javax.security.auth.Subject.doAs(Subject.java:422) [?:1.8.0_141] at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1685) [hadoop-common-3.0.0-cdh6.0.0.jar:?] at org.apache.oozie.action.hadoop.LauncherAM.main(LauncherAM.java:141) [oozie-sharelib-oozie-5.0.0-cdh6.0.0.jar:?] Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_141] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_141] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_141] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_141] at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1700) ~[hive-metastore.jar:2.1.1-cdh6.0.0] ... 63 more Caused by: org.apache.hadoop.hive.metastore.api.MetaException: Version information not found in metastore. at org.apache.hadoop.hive.metastore.ObjectStore.checkSchema(ObjectStore.java:7616) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.ObjectStore.verifySchema(ObjectStore.java:7593) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_141] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_141] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_141] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_141] at org.apache.hadoop.hive.metastore.RawStoreProxy.invoke(RawStoreProxy.java:101) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at com.sun.proxy.$Proxy42.verifySchema(Unknown Source) ~[?:?] at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMSForConf(HiveMetaStore.java:579) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:572) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:639) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:416) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:78) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:84) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6866) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:248) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.<init>(SessionHiveMetaStoreClient.java:70) ~[hive-exec-core.jar:2.1.1-cdh6.0.0] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_141] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_141] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_141] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_141] at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1700) ~[hive-metastore.jar:2.1.1-cdh6.0.0] ... 63 more 21:01:52.935 [2e864abd-c4a5-4eae-ad63-1715512e5bd1 main] WARN org.apache.hadoop.hive.ql.Driver - Caught exception attempting to write metadata call information org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient at org.apache.hadoop.hive.ql.metadata.Hive.registerAllFunctionsOnce(Hive.java:234) ~[hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.<init>(Hive.java:386) ~[hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.create(Hive.java:330) ~[hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.getInternal(Hive.java:310) ~[hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.get(Hive.java:352) ~[hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.get(Hive.java:348) ~[hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.Driver.dumpMetaCallTimingWithoutEx(Driver.java:716) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:668) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1347) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1480) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1267) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1257) [hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:239) [hive-cli.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:187) [hive-cli.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:409) [hive-cli.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:342) [hive-cli.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.cli.CliDriver.processReader(CliDriver.java:489) [hive-cli.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.cli.CliDriver.processFile(CliDriver.java:505) [hive-cli.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:808) [hive-cli.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:774) [hive-cli.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:701) [hive-cli.jar:2.1.1-cdh6.0.0] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_141] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_141] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_141] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_141] at org.apache.sqoop.hive.HiveImport.executeScript(HiveImport.java:341) [sqoop.jar:?] at org.apache.sqoop.hive.HiveImport.importTable(HiveImport.java:246) [sqoop.jar:?] at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:543) [sqoop.jar:?] at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:634) [sqoop.jar:?] at org.apache.sqoop.Sqoop.run(Sqoop.java:145) [sqoop.jar:?] at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76) [hadoop-common-3.0.0-cdh6.0.0.jar:?] at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) [sqoop.jar:?] at org.apache.sqoop.Sqoop.runTool(Sqoop.java:232) [sqoop.jar:?] at org.apache.sqoop.Sqoop.runTool(Sqoop.java:241) [sqoop.jar:?] at org.apache.sqoop.Sqoop.main(Sqoop.java:250) [sqoop.jar:?] at org.apache.oozie.action.hadoop.SqoopMain.runSqoopJob(SqoopMain.java:214) [oozie-sharelib-sqoop.jar:?] at org.apache.oozie.action.hadoop.SqoopMain.run(SqoopMain.java:199) [oozie-sharelib-sqoop.jar:?] at org.apache.oozie.action.hadoop.LauncherMain.run(LauncherMain.java:101) [oozie-sharelib-oozie-5.0.0-cdh6.0.0.jar:?] at org.apache.oozie.action.hadoop.SqoopMain.main(SqoopMain.java:51) [oozie-sharelib-sqoop.jar:?] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_141] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_141] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_141] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_141] at org.apache.oozie.action.hadoop.LauncherAM.runActionMain(LauncherAM.java:410) [oozie-sharelib-oozie-5.0.0-cdh6.0.0.jar:?] at org.apache.oozie.action.hadoop.LauncherAM.access$300(LauncherAM.java:55) [oozie-sharelib-oozie-5.0.0-cdh6.0.0.jar:?] at org.apache.oozie.action.hadoop.LauncherAM$2.run(LauncherAM.java:223) [oozie-sharelib-oozie-5.0.0-cdh6.0.0.jar:?] at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_141] at javax.security.auth.Subject.doAs(Subject.java:422) [?:1.8.0_141] at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1685) [hadoop-common-3.0.0-cdh6.0.0.jar:?] at org.apache.oozie.action.hadoop.LauncherAM.run(LauncherAM.java:217) [oozie-sharelib-oozie-5.0.0-cdh6.0.0.jar:?] at org.apache.oozie.action.hadoop.LauncherAM$1.run(LauncherAM.java:153) [oozie-sharelib-oozie-5.0.0-cdh6.0.0.jar:?] at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_141] at javax.security.auth.Subject.doAs(Subject.java:422) [?:1.8.0_141] at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1685) [hadoop-common-3.0.0-cdh6.0.0.jar:?] at org.apache.oozie.action.hadoop.LauncherAM.main(LauncherAM.java:141) [oozie-sharelib-oozie-5.0.0-cdh6.0.0.jar:?] Caused by: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1702) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:80) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:130) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:101) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:3554) ~[hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3606) ~[hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3586) ~[hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.getAllFunctions(Hive.java:3840) ~[hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.reloadFunctions(Hive.java:246) ~[hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.registerAllFunctionsOnce(Hive.java:229) ~[hive-exec-core.jar:2.1.1-cdh6.0.0] ... 54 more Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_141] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_141] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_141] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_141] at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1700) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:80) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:130) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:101) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:3554) ~[hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3606) ~[hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3586) ~[hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.getAllFunctions(Hive.java:3840) ~[hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.reloadFunctions(Hive.java:246) ~[hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.registerAllFunctionsOnce(Hive.java:229) ~[hive-exec-core.jar:2.1.1-cdh6.0.0] ... 54 more Caused by: org.apache.hadoop.hive.metastore.api.MetaException: Version information not found in metastore. at org.apache.hadoop.hive.metastore.ObjectStore.checkSchema(ObjectStore.java:7616) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.ObjectStore.verifySchema(ObjectStore.java:7593) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_141] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_141] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_141] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_141] at org.apache.hadoop.hive.metastore.RawStoreProxy.invoke(RawStoreProxy.java:101) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at com.sun.proxy.$Proxy42.verifySchema(Unknown Source) ~[?:?] at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMSForConf(HiveMetaStore.java:579) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:572) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:639) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:416) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:78) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:84) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6866) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:248) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.<init>(SessionHiveMetaStoreClient.java:70) ~[hive-exec-core.jar:2.1.1-cdh6.0.0] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_141] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_141] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_141] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_141] at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1700) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:80) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:130) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:101) ~[hive-metastore.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:3554) ~[hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3606) ~[hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3586) ~[hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.getAllFunctions(Hive.java:3840) ~[hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.reloadFunctions(Hive.java:246) ~[hive-exec-core.jar:2.1.1-cdh6.0.0] at org.apache.hadoop.hive.ql.metadata.Hive.registerAllFunctionsOnce(Hive.java:229) ~[hive-exec-core.jar:2.1.1-cdh6.0.0] ... 54 more 21:01:52.937 [2e864abd-c4a5-4eae-ad63-1715512e5bd1 main] INFO org.apache.hadoop.hive.ql.Driver - Completed compiling command(queryId=yarn_20181018210146_02430a51-f90f-462d-8b66-b22be72bdd4b); Time taken: 6.228 seconds 21:01:52.947 [2e864abd-c4a5-4eae-ad63-1715512e5bd1 main] INFO org.apache.hadoop.hive.conf.HiveConf - Using the default value passed in for log id: 2e864abd-c4a5-4eae-ad63-1715512e5bd1 21:01:52.947 [2e864abd-c4a5-4eae-ad63-1715512e5bd1 main] INFO org.apache.hadoop.hive.ql.session.SessionState - Resetting thread name to main 21:01:52.947 [main] INFO org.apache.hadoop.hive.conf.HiveConf - Using the default value passed in for log id: 2e864abd-c4a5-4eae-ad63-1715512e5bd1 21:01:52.959 [main] INFO org.apache.hadoop.hive.ql.session.SessionState - Deleted directory: /tmp/hive/hive/2e864abd-c4a5-4eae-ad63-1715512e5bd1 on fs with scheme hdfs 21:01:52.959 [main] INFO org.apache.hadoop.hive.ql.session.SessionState - Deleted directory: /tmp/yarn/2e864abd-c4a5-4eae-ad63-1715512e5bd1 on fs with scheme file 21:01:52.961 [main] ERROR org.apache.sqoop.tool.ImportTool - Import failed: java.io.IOException: Hive CliDriver exited with status=40000 at org.apache.sqoop.hive.HiveImport.executeScript(HiveImport.java:365) at org.apache.sqoop.hive.HiveImport.importTable(HiveImport.java:246) at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:543) at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:634) at org.apache.sqoop.Sqoop.run(Sqoop.java:145) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:232) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:241) at org.apache.sqoop.Sqoop.main(Sqoop.java:250) at org.apache.oozie.action.hadoop.SqoopMain.runSqoopJob(SqoopMain.java:214) at org.apache.oozie.action.hadoop.SqoopMain.run(SqoopMain.java:199) at org.apache.oozie.action.hadoop.LauncherMain.run(LauncherMain.java:101) at org.apache.oozie.action.hadoop.SqoopMain.main(SqoopMain.java:51) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.oozie.action.hadoop.LauncherAM.runActionMain(LauncherAM.java:410) at org.apache.oozie.action.hadoop.LauncherAM.access$300(LauncherAM.java:55) at org.apache.oozie.action.hadoop.LauncherAM$2.run(LauncherAM.java:223) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:422) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1685) at org.apache.oozie.action.hadoop.LauncherAM.run(LauncherAM.java:217) at org.apache.oozie.action.hadoop.LauncherAM$1.run(LauncherAM.java:153) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:422) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1685) at org.apache.oozie.action.hadoop.LauncherAM.main(LauncherAM.java:141) <<< Invocation of Sqoop command completed <<< Hadoop Job IDs executed by Sqoop: job_1539852703660_0026 java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.oozie.action.hadoop.LauncherAM.runActionMain(LauncherAM.java:410) at org.apache.oozie.action.hadoop.LauncherAM.access$300(LauncherAM.java:55) at org.apache.oozie.action.hadoop.LauncherAM$2.run(LauncherAM.java:223) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:422) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1685) at org.apache.oozie.action.hadoop.LauncherAM.run(LauncherAM.java:217) at org.apache.oozie.action.hadoop.LauncherAM$1.run(LauncherAM.java:153) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:422) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1685) at org.apache.oozie.action.hadoop.LauncherAM.main(LauncherAM.java:141) Caused by: java.lang.SecurityException: Intercepted System.exit(1) at org.apache.oozie.action.hadoop.security.LauncherSecurityManager.checkExit(LauncherSecurityManager.java:57) at java.lang.Runtime.exit(Runtime.java:107) at java.lang.System.exit(System.java:971) at org.apache.sqoop.Sqoop.main(Sqoop.java:251) at org.apache.oozie.action.hadoop.SqoopMain.runSqoopJob(SqoopMain.java:214) at org.apache.oozie.action.hadoop.SqoopMain.run(SqoopMain.java:199) at org.apache.oozie.action.hadoop.LauncherMain.run(LauncherMain.java:101) at org.apache.oozie.action.hadoop.SqoopMain.main(SqoopMain.java:51) ... 16 more Intercepting System.exit(1) Failing Oozie Launcher, Main Class [org.apache.oozie.action.hadoop.SqoopMain], exit code [1] Oozie Launcher, uploading action data to HDFS sequence file: hdfs://node12.exp.com:8020/user/hive/oozie-oozi/0000001-181018205849186-oozie-oozi-W/sqoop-9ef4--sqoop/action-data.seq 21:01:53.018 [main] INFO org.apache.hadoop.io.compress.CodecPool - Got brand-new compressor [.deflate] Stopping AM 21:01:53.050 [main] INFO org.apache.hadoop.yarn.client.api.impl.AMRMClientImpl - Waiting for application to be successfully unregistered. Callback notification attempts left 0 Callback notification trying http://node12.exp.com:11000/oozie/callback?id=0000001-181018205849186-oozie-oozi-W@sqoop-9ef4&status=FAILED Callback notification to http://node12.exp.com:11000/oozie/callback?id=0000001-181018205849186-oozie-oozi-W@sqoop-9ef4&status=FAILED succeeded Callback notification succeeded
出现上述原因是oozie把数据导入hive时,查不了hive元数据。
解决方法:
在hive-site.xml 添加属性:
<property>
<name>hive.metastore.uris</name>
<value>thrift://sv2lxgsed01.xxxx.com:9083</value>
</property>
然后在oozie 添加属性(配置hive路径):
<job-xml>/opt/cloudera/parcels/CDH/lib/hive/conf/hive-site.xml</job-xml>
或在cloudera manager上配置: