[LENS-1247] Scheduler's submit job is not setting db and session config passed

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.6
• Component/s: server
• Assignee: Lavkesh Lahngir
• Reporter: Archana H
• Created: 01/Aug/16 13:21
• Updated: 22/Aug/16 07:45
• Resolved: 10/Aug/16 08:01

Description

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:

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

Issue Links

• Is contained by: LENS-1265 Scheduler Bug fixes