Reply
New Contributor
Posts: 2
Registered: ‎04-03-2018

Job Designer in Hue

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.

 

New Contributor
Posts: 2
Registered: ‎04-03-2018

Re: Job Designer in Hue

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?

Cloudera Employee
Posts: 716
Registered: ‎07-30-2013

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.

Announcements