[ 
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)

Reply via email to