Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here. Want to know more about what has changed? Check out the Community News blog.

Job Designer in Hue

Job Designer in Hue

New Contributor

I am currenlty using Cloudera express 5.2.0

 

If I use the comand line:

 

hive -e 'select * from default.sample_07 limit 20;'

 

All works as expected. However, If I use the job designer in hue/query editors/job designer and create a job with the above simple query, the job fails when it's submitted. It looks like the job cannot find any of the tables. See stderr log below.

___________________________

 

Log Type: stderr Log Length: 22305 SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/opt/cloudera/parcels/CDH-5.2.0-1.cdh5.2.0.p0.36/jars/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/data/7/yarn/nm/filecache/106/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory] 18/04/03 13:10:42 WARN conf.Configuration: file:/data/9/yarn/nm/usercache/admin/appcache/application_1522089177683_0036/container_1522089177683_0036_01_000002/hive-site.xml:an attempt to override final parameter: hadoop.ssl.require.client.cert; Ignoring. 18/04/03 13:10:42 WARN conf.Configuration: file:/data/9/yarn/nm/usercache/admin/appcache/application_1522089177683_0036/container_1522089177683_0036_01_000002/hive-site.xml:an attempt to override final parameter: mapreduce.job.end-notification.max.retry.interval; Ignoring. 18/04/03 13:10:42 WARN conf.Configuration: file:/data/9/yarn/nm/usercache/admin/appcache/application_1522089177683_0036/container_1522089177683_0036_01_000002/hive-site.xml:an attempt to override final parameter: hadoop.ssl.client.conf; Ignoring. 18/04/03 13:10:42 WARN conf.Configuration: file:/data/9/yarn/nm/usercache/admin/appcache/application_1522089177683_0036/container_1522089177683_0036_01_000002/hive-site.xml:an attempt to override final parameter: hadoop.ssl.keystores.factory.class; Ignoring. 18/04/03 13:10:42 WARN conf.Configuration: file:/data/9/yarn/nm/usercache/admin/appcache/application_1522089177683_0036/container_1522089177683_0036_01_000002/hive-site.xml:an attempt to override final parameter: hadoop.ssl.server.conf; Ignoring. 18/04/03 13:10:42 WARN conf.Configuration: file:/data/9/yarn/nm/usercache/admin/appcache/application_1522089177683_0036/container_1522089177683_0036_01_000002/hive-site.xml:an attempt to override final parameter: mapreduce.job.end-notification.max.attempts; Ignoring. Logging initialized using configuration in /data/9/yarn/nm/usercache/admin/appcache/application_1522089177683_0036/container_1522089177683_0036_01_000002/hive-log4j.properties 18/04/03 13:10:42 INFO SessionState: Logging initialized using configuration in /data/9/yarn/nm/usercache/admin/appcache/application_1522089177683_0036/container_1522089177683_0036_01_000002/hive-log4j.properties 18/04/03 13:10:42 INFO metastore.HiveMetaStore: 0: Opening raw store with implemenation class:org.apache.hadoop.hive.metastore.ObjectStore 18/04/03 13:10:42 INFO metastore.ObjectStore: ObjectStore, initialize called 18/04/03 13:10:43 INFO DataNucleus.Persistence: Property datanucleus.cache.level2 unknown - will be ignored 18/04/03 13:10:43 INFO DataNucleus.Persistence: Property hive.metastore.integral.jdo.pushdown unknown - will be ignored 18/04/03 13:10:43 WARN bonecp.BoneCPConfig: Max Connections < 1. Setting to 20 18/04/03 13:10:44 WARN conf.Configuration: file:/data/9/yarn/nm/usercache/admin/appcache/application_1522089177683_0036/container_1522089177683_0036_01_000002/hive-site.xml:an attempt to override final parameter: hadoop.ssl.require.client.cert; Ignoring. 18/04/03 13:10:44 WARN conf.Configuration: file:/data/9/yarn/nm/usercache/admin/appcache/application_1522089177683_0036/container_1522089177683_0036_01_000002/hive-site.xml:an attempt to override final parameter: mapreduce.job.end-notification.max.retry.interval; Ignoring. 18/04/03 13:10:44 WARN conf.Configuration: file:/data/9/yarn/nm/usercache/admin/appcache/application_1522089177683_0036/container_1522089177683_0036_01_000002/hive-site.xml:an attempt to override final parameter: hadoop.ssl.client.conf; Ignoring. 18/04/03 13:10:44 WARN conf.Configuration: file:/data/9/yarn/nm/usercache/admin/appcache/application_1522089177683_0036/container_1522089177683_0036_01_000002/hive-site.xml:an attempt to override final parameter: hadoop.ssl.keystores.factory.class; Ignoring. 18/04/03 13:10:44 WARN conf.Configuration: file:/data/9/yarn/nm/usercache/admin/appcache/application_1522089177683_0036/container_1522089177683_0036_01_000002/hive-site.xml:an attempt to override final parameter: hadoop.ssl.server.conf; Ignoring. 18/04/03 13:10:44 WARN conf.Configuration: file:/data/9/yarn/nm/usercache/admin/appcache/application_1522089177683_0036/container_1522089177683_0036_01_000002/hive-site.xml:an attempt to override final parameter: mapreduce.job.end-notification.max.attempts; Ignoring. 18/04/03 13:10:44 INFO metastore.ObjectStore: Setting MetaStore object pin classes with hive.metastore.cache.pinobjtypes="Table,StorageDescriptor,SerDeInfo,Partition,Database,Type,FieldSchema,Order" 18/04/03 13:10:44 WARN bonecp.BoneCPConfig: Max Connections < 1. Setting to 20 18/04/03 13:10:45 INFO metastore.MetaStoreDirectSql: MySQL check failed, assuming we are not on mysql: Lexical error at line 1, column 5. Encountered: "@" (64), after : "". 18/04/03 13:10:45 INFO DataNucleus.Datastore: The class "org.apache.hadoop.hive.metastore.model.MFieldSchema" is tagged as "embedded-only" so does not have its own datastore table. 18/04/03 13:10:45 INFO DataNucleus.Datastore: The class "org.apache.hadoop.hive.metastore.model.MOrder" is tagged as "embedded-only" so does not have its own datastore table. 18/04/03 13:10:47 INFO DataNucleus.Datastore: The class "org.apache.hadoop.hive.metastore.model.MFieldSchema" is tagged as "embedded-only" so does not have its own datastore table. 18/04/03 13:10:47 INFO DataNucleus.Datastore: The class "org.apache.hadoop.hive.metastore.model.MOrder" is tagged as "embedded-only" so does not have its own datastore table. 18/04/03 13:10:47 INFO metastore.ObjectStore: Initialized ObjectStore 18/04/03 13:10:47 WARN metastore.ObjectStore: Version information not found in metastore. hive.metastore.schema.verification is not enabled so recording the schema version 0.13.0 18/04/03 13:10:47 INFO metastore.HiveMetaStore: Added admin role in metastore 18/04/03 13:10:47 INFO metastore.HiveMetaStore: Added public role in metastore 18/04/03 13:10:47 INFO metastore.HiveMetaStore: No user is added in admin role, since config is empty 18/04/03 13:10:48 INFO session.SessionState: No Tez session required at this point. hive.execution.engine=mr. 18/04/03 13:10:48 INFO log.PerfLogger: <PERFLOG method=Driver.run from=org.apache.hadoop.hive.ql.Driver> 18/04/03 13:10:48 INFO log.PerfLogger: <PERFLOG method=TimeToSubmit from=org.apache.hadoop.hive.ql.Driver> 18/04/03 13:10:48 INFO ql.Driver: Concurrency mode is disabled, not creating a lock manager 18/04/03 13:10:48 INFO log.PerfLogger: <PERFLOG method=compile from=org.apache.hadoop.hive.ql.Driver> 18/04/03 13:10:48 INFO log.PerfLogger: <PERFLOG method=parse from=org.apache.hadoop.hive.ql.Driver> 18/04/03 13:10:48 INFO parse.ParseDriver: Parsing command: select * from default.sample_07 limit 20 18/04/03 13:10:48 INFO parse.ParseDriver: Parse Completed 18/04/03 13:10:48 INFO log.PerfLogger: </PERFLOG method=parse start=1522779048140 end=1522779048460 duration=320 from=org.apache.hadoop.hive.ql.Driver> 18/04/03 13:10:48 INFO log.PerfLogger: <PERFLOG method=semanticAnalyze from=org.apache.hadoop.hive.ql.Driver> 18/04/03 13:10:48 INFO parse.SemanticAnalyzer: Starting Semantic Analysis 18/04/03 13:10:48 INFO parse.SemanticAnalyzer: Completed phase 1 of Semantic Analysis 18/04/03 13:10:48 INFO parse.SemanticAnalyzer: Get metadata for source tables 18/04/03 13:10:48 WARN security.ShellBasedUnixGroupsMapping: got exception trying to get groups for user admin: id: admin: No such user 18/04/03 13:10:48 WARN security.UserGroupInformation: No groups available for user admin 18/04/03 13:10:48 WARN security.UserGroupInformation: No groups available for user admin 18/04/03 13:10:48 WARN conf.Configuration: file:/data/9/yarn/nm/usercache/admin/appcache/application_1522089177683_0036/container_1522089177683_0036_01_000002/hive-site.xml:an attempt to override final parameter: hadoop.ssl.require.client.cert; Ignoring. 18/04/03 13:10:48 WARN conf.Configuration: file:/data/9/yarn/nm/usercache/admin/appcache/application_1522089177683_0036/container_1522089177683_0036_01_000002/hive-site.xml:an attempt to override final parameter: mapreduce.job.end-notification.max.retry.interval; Ignoring. 18/04/03 13:10:48 WARN conf.Configuration: file:/data/9/yarn/nm/usercache/admin/appcache/application_1522089177683_0036/container_1522089177683_0036_01_000002/hive-site.xml:an attempt to override final parameter: hadoop.ssl.client.conf; Ignoring. 18/04/03 13:10:48 WARN conf.Configuration: file:/data/9/yarn/nm/usercache/admin/appcache/application_1522089177683_0036/container_1522089177683_0036_01_000002/hive-site.xml:an attempt to override final parameter: hadoop.ssl.keystores.factory.class; Ignoring. 18/04/03 13:10:48 WARN conf.Configuration: file:/data/9/yarn/nm/usercache/admin/appcache/application_1522089177683_0036/container_1522089177683_0036_01_000002/hive-site.xml:an attempt to override final parameter: hadoop.ssl.server.conf; Ignoring. 18/04/03 13:10:48 WARN conf.Configuration: file:/data/9/yarn/nm/usercache/admin/appcache/application_1522089177683_0036/container_1522089177683_0036_01_000002/hive-site.xml:an attempt to override final parameter: mapreduce.job.end-notification.max.attempts; Ignoring. 18/04/03 13:10:48 WARN conf.Configuration: file:/data/9/yarn/nm/usercache/admin/appcache/application_1522089177683_0036/container_1522089177683_0036_01_000002/hive-site.xml:an attempt to override final parameter: hadoop.ssl.require.client.cert; Ignoring. 18/04/03 13:10:48 WARN conf.Configuration: file:/data/9/yarn/nm/usercache/admin/appcache/application_1522089177683_0036/container_1522089177683_0036_01_000002/hive-site.xml:an attempt to override final parameter: mapreduce.job.end-notification.max.retry.interval; Ignoring. 18/04/03 13:10:48 WARN conf.Configuration: file:/data/9/yarn/nm/usercache/admin/appcache/application_1522089177683_0036/container_1522089177683_0036_01_000002/hive-site.xml:an attempt to override final parameter: hadoop.ssl.client.conf; Ignoring. 18/04/03 13:10:48 WARN conf.Configuration: file:/data/9/yarn/nm/usercache/admin/appcache/application_1522089177683_0036/container_1522089177683_0036_01_000002/hive-site.xml:an attempt to override final parameter: hadoop.ssl.keystores.factory.class; Ignoring. 18/04/03 13:10:48 WARN conf.Configuration: file:/data/9/yarn/nm/usercache/admin/appcache/application_1522089177683_0036/container_1522089177683_0036_01_000002/hive-site.xml:an attempt to override final parameter: hadoop.ssl.server.conf; Ignoring. 18/04/03 13:10:48 WARN conf.Configuration: file:/data/9/yarn/nm/usercache/admin/appcache/application_1522089177683_0036/container_1522089177683_0036_01_000002/hive-site.xml:an attempt to override final parameter: mapreduce.job.end-notification.max.attempts; Ignoring. 18/04/03 13:10:48 INFO metastore.HiveMetaStore: 0: get_table : db=default tbl=sample_07 18/04/03 13:10:48 INFO HiveMetaStore.audit: ugi=admin ip=unknown-ip-addr cmd=get_table : db=default tbl=sample_07 18/04/03 13:10:48 ERROR metadata.Hive: NoSuchObjectException(message:default.sample_07 table not found) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_table(HiveMetaStore.java:1569) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:106) at com.sun.proxy.$Proxy23.get_table(Unknown Source) at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTable(HiveMetaStoreClient.java:1008) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:90) at com.sun.proxy.$Proxy24.getTable(Unknown Source) at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:999) at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:941) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:1220) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:1189) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:9202) at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:206) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:434) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:332) at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:988) at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1053) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:924) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:914) at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:269) at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:221) at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:431) at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:367) at org.apache.hadoop.hive.cli.CliDriver.processReader(CliDriver.java:464) at org.apache.hadoop.hive.cli.CliDriver.processFile(CliDriver.java:474) at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:756) at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:694) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:633) at org.apache.oozie.action.hadoop.HiveMain.runHive(HiveMain.java:323) at org.apache.oozie.action.hadoop.HiveMain.run(HiveMain.java:284) at org.apache.oozie.action.hadoop.LauncherMain.run(LauncherMain.java:39) at org.apache.oozie.action.hadoop.HiveMain.main(HiveMain.java:66) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.oozie.action.hadoop.LauncherMapper.map(LauncherMapper.java:227) at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:54) at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:450) at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343) at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:168) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:415) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1614) at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:163) 18/04/03 13:10:48 ERROR parse.SemanticAnalyzer: org.apache.hadoop.hive.ql.parse.SemanticException: Line 0:-1 Table not found 'sample_07' at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:1240) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:1189) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:9202) at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:206) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:434) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:332) at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:988) at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1053) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:924) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:914) at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:269) at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:221) at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:431) at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:367) at org.apache.hadoop.hive.cli.CliDriver.processReader(CliDriver.java:464) at org.apache.hadoop.hive.cli.CliDriver.processFile(CliDriver.java:474) at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:756) at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:694) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:633) at org.apache.oozie.action.hadoop.HiveMain.runHive(HiveMain.java:323) at org.apache.oozie.action.hadoop.HiveMain.run(HiveMain.java:284) at org.apache.oozie.action.hadoop.LauncherMain.run(LauncherMain.java:39) at org.apache.oozie.action.hadoop.HiveMain.main(HiveMain.java:66) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.oozie.action.hadoop.LauncherMapper.map(LauncherMapper.java:227) at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:54) at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:450) at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343) at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:168) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:415) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1614) at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:163) FAILED: SemanticException Line 0:-1 Table not found 'sample_07' 18/04/03 13:10:48 ERROR ql.Driver: FAILED: SemanticException Line 0:-1 Table not found 'sample_07' org.apache.hadoop.hive.ql.parse.SemanticException: Line 0:-1 Table not found 'sample_07' at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:1491) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:1189) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:9202) at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:206) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:434) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:332) at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:988) at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1053) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:924) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:914) at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:269) at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:221) at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:431) at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:367) at org.apache.hadoop.hive.cli.CliDriver.processReader(CliDriver.java:464) at org.apache.hadoop.hive.cli.CliDriver.processFile(CliDriver.java:474) at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:756) at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:694) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:633) at org.apache.oozie.action.hadoop.HiveMain.runHive(HiveMain.java:323) at org.apache.oozie.action.hadoop.HiveMain.run(HiveMain.java:284) at org.apache.oozie.action.hadoop.LauncherMain.run(LauncherMain.java:39) at org.apache.oozie.action.hadoop.HiveMain.main(HiveMain.java:66) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.oozie.action.hadoop.LauncherMapper.map(LauncherMapper.java:227) at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:54) at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:450) at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343) at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:168) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:415) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1614) at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:163) Caused by: org.apache.hadoop.hive.ql.parse.SemanticException: Line 0:-1 Table not found 'sample_07' at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:1240) ... 35 more 18/04/03 13:10:48 INFO log.PerfLogger: </PERFLOG method=compile start=1522779048106 end=1522779048680 duration=574 from=org.apache.hadoop.hive.ql.Driver> 18/04/03 13:10:48 INFO log.PerfLogger: <PERFLOG method=releaseLocks from=org.apache.hadoop.hive.ql.Driver> 18/04/03 13:10:48 INFO log.PerfLogger: </PERFLOG method=releaseLocks start=1522779048680 end=1522779048681 duration=1 from=org.apache.hadoop.hive.ql.Driver> 18/04/03 13:10:48 INFO log.PerfLogger: <PERFLOG method=releaseLocks from=org.apache.hadoop.hive.ql.Driver> 18/04/03 13:10:48 INFO log.PerfLogger: </PERFLOG method=releaseLocks start=1522779048686 end=1522779048686 duration=0 from=org.apache.hadoop.hive.ql.Driver> Intercepting System.exit(40000) Failing Oozie Launcher, Main class [org.apache.oozie.action.hadoop.HiveMain], exit code [40000] 18/04/03 13:10:48 INFO zlib.ZlibFactory: Successfully loaded & initialized native-zlib library 18/04/03 13:10:48 INFO compress.CodecPool: Got brand-new compressor [.deflate] 18/04/03 13:10:48 INFO mapred.Task: Task:attempt_1522089177683_0036_m_000000_0 is done. And is in the process of committing 18/04/03 13:10:48 INFO mapred.Task: Task attempt_1522089177683_0036_m_000000_0 is allowed to commit now 18/04/03 13:10:48 INFO output.FileOutputCommitter: Saved output of task 'attempt_1522089177683_0036_m_000000_0' to hdfs://HADOOPMAN01.SPHTM.TULANE.EDU:8020/user/admin/oozie-oozi/0000006-180403122435466-oozie-oozi-W/Sample--hive/output/_temporary/1/task_1522089177683_0036_m_000000 18/04/03 13:10:48 INFO mapred.Task: Task 'attempt_1522089177683_0036_m_000000_0' done.

 

2 REPLIES 2

Re: Job Designer in Hue

New Contributor

ok, I finnaly figured out how to modify the workflow.xml to include

 

<job-xml>hive-site.xml</job-xml>

 

and rerun the job. This fixed the issue. Now my question is how do you make the job designer to always include the

 

<job-xml>hive-site.xml</job-xml>

 

in the workflow.xml?

Re: Job Designer in Hue

18/04/03 13:10:48 INFO HiveMetaStore.audit: ugi=admin ip=unknown-ip-addr cmd=get_table : db=default tbl=sample_07 18/04/03 13:10:48 ERROR metadata.Hive: NoSuchObjectException(message:default.sample_07 table not found) at 

This means that the hive-site.xml was not added to the workflow. It should be added has a file somehow or be present in a 'lib' directory of the workspace of the workflow.