[ https://issues.apache.org/jira/browse/LENS-1247?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Lavkesh Lahngir resolved LENS-1247. ----------------------------------- Resolution: Fixed Fix Version/s: 2.7 > Scheduler's submit job is not setting db and session config passed > ------------------------------------------------------------------ > > Key: LENS-1247 > URL: https://issues.apache.org/jira/browse/LENS-1247 > Project: Apache Lens > Issue Type: Bug > Components: server > Reporter: Archana H > Assignee: Lavkesh Lahngir > Fix For: 2.7 > > > Job details: > | 59ede960-05b7-40ba-a19f-bd4ec59713d4 | <?xml version="1.0" encoding="UTF-8" > standalone="yes"?><job > xmlns="uri:lens:job:0.1"><name>job1</name><execution><session><db>exp_yoda</db></session><query><query>cube > select id,name from sample_dim where name != > 'first'</query></query></execution><trigger><frequency><enum>DAILY</enum></frequency></trigger><start_time>2016-08-02T00:00:00.000+05:30</start_time><end_time>2016-08-07T00:00:00.000+05:30</end_time></job> > | archana.h | SCHEDULED | 1470055222974 | 1470055223094 | job1 | > Error: > {CODE} > 01 Aug 2016 12:38:34 [d93a86f6-b748-4b7d-bdd0-d6aa40de8620] > [SchedulerEventListener_AsyncThread-5] ERROR > org.apache.lens.server.scheduler.SchedulerEventListener - Exception occurred > while launching the job instance for ae6523b3-f979-4dac-8274-15fc35e886fb for > nominal time 1467657000000 > org.apache.lens.server.api.error.LensMultiCauseException: > SEMANTIC_ERROR[Error while compiling statement: FAILED: SemanticException > [Error 10001]: Line 1:37 Table not found 'sample_dim'] > at > org.apache.lens.server.query.QueryExecutionServiceImpl.rewriteAndSelect(QueryExecutionServiceImpl.java:1596) > ~[classes/:na] > at > org.apache.lens.server.query.QueryExecutionServiceImpl.executeAsyncInternal(QueryExecutionServiceImpl.java:2047) > ~[classes/:na] > at > org.apache.lens.server.query.QueryExecutionServiceImpl.executeAsync(QueryExecutionServiceImpl.java:1970) > ~[classes/:na] > at > org.apache.lens.server.scheduler.SchedulerEventListener.process(SchedulerEventListener.java:149) > [classes/:na] > at > org.apache.lens.server.scheduler.SchedulerEventListener.process(SchedulerEventListener.java:48) > [classes/:na] > at > org.apache.lens.server.api.events.AsyncEventListener$1.run(AsyncEventListener.java:110) > [lens-server-api-2.6.8-inm-SNAPSHOT.jar:2.6.8-inm-SNAPSHOT] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > [na:1.8.0_40] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > [na:1.8.0_40] > at java.lang.Thread.run(Thread.java:745) [na:1.8.0_40] > Caused by: org.apache.hive.service.cli.HiveSQLException: Error while > compiling statement: FAILED: SemanticException [Error 10001]: Line 1:37 Table > not found 'sample_dim' > at > org.apache.hive.service.cli.thrift.ThriftCLIServiceClient.checkStatus(ThriftCLIServiceClient.java:99) > ~[hive-service-2.1.3-inm-SNAPSHOT.jar:2.1.3-inm-SNAPSHOT] > at > org.apache.hive.service.cli.thrift.ThriftCLIServiceClient.executeStatementInternal(ThriftCLIServiceClient.java:202) > ~[hive-service-2.1.3-inm-SNAPSHOT.jar:2.1.3-inm-SNAPSHOT] > at > org.apache.hive.service.cli.thrift.ThriftCLIServiceClient.executeStatement(ThriftCLIServiceClient.java:172) > ~[hive-service-2.1.3-inm-SNAPSHOT.jar:2.1.3-inm-SNAPSHOT] > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > ~[na:1.8.0_40] > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > ~[na:1.8.0_40] > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > ~[na:1.8.0_40] > at java.lang.reflect.Method.invoke(Method.java:497) ~[na:1.8.0_40] > at > org.apache.hive.service.cli.thrift.RetryingThriftCLIServiceClient.invokeInternal(RetryingThriftCLIServiceClient.java:322) > ~[hive-service-2.1.3-inm-SNAPSHOT.jar:2.1.3-inm-SNAPSHOT] > at > org.apache.hive.service.cli.thrift.RetryingThriftCLIServiceClient.invoke(RetryingThriftCLIServiceClient.java:350) > ~[hive-service-2.1.3-inm-SNAPSHOT.jar:2.1.3-inm-SNAPSHOT] > at com.sun.proxy.$Proxy89.executeStatement(Unknown Source) ~[na:na] > at > org.apache.hive.service.cli.thrift.RetryingThriftCLIServiceClient$CLIServiceClientWrapper.executeStatement(RetryingThriftCLIServiceClient.java:131) > ~[hive-service-2.1.3-inm-SNAPSHOT.jar:2.1.3-inm-SNAPSHOT] > at > org.apache.lens.driver.hive.HiveDriver.execute(HiveDriver.java:521) > ~[lens-driver-hive-2.6.8-inm-SNAPSHOT.jar:2.6.8-inm-SNAPSHOT] > at > org.apache.lens.driver.hive.HiveDriver.explain(HiveDriver.java:451) > ~[lens-driver-hive-2.6.8-inm-SNAPSHOT.jar:2.6.8-inm-SNAPSHOT] > at > org.apache.lens.driver.hive.HiveDriver.estimate(HiveDriver.java:422) > ~[lens-driver-hive-2.6.8-inm-SNAPSHOT.jar:2.6.8-inm-SNAPSHOT] > at > org.apache.lens.server.api.query.AbstractQueryContext$DriverEstimateRunnable.run(AbstractQueryContext.java:258) > ~[lens-server-api-2.6.8-inm-SNAPSHOT.jar:2.6.8-inm-SNAPSHOT] > at > org.apache.lens.server.query.QueryExecutionServiceImpl$RewriteEstimateRunnable.run(QueryExecutionServiceImpl.java:1680) > ~[classes/:na] > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > ~[na:1.8.0_40] > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > ~[na:1.8.0_40] > ... 3 common frames omitted > {CODE} -- This message was sent by Atlassian JIRA (v6.3.4#6332)