You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lens.apache.org by "Amareshwari Sriramadasu (JIRA)" <ji...@apache.org> on 2015/09/10 12:12:45 UTC
[jira] [Updated] (LENS-756) Example query on customer_city_name
failing
[ https://issues.apache.org/jira/browse/LENS-756?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Amareshwari Sriramadasu updated LENS-756:
-----------------------------------------
Attachment: LENS-756.patch
Straight forward patch.
Ran examples and verified
--------------------
Successful queries 148 out of 148queries
Total time for running examples(in millis) :1234906
> Example query on customer_city_name failing
> -------------------------------------------
>
> Key: LENS-756
> URL: https://issues.apache.org/jira/browse/LENS-756
> Project: Apache Lens
> Issue Type: Bug
> Components: cube, examples
> Affects Versions: 2.3
> Reporter: Amareshwari Sriramadasu
> Assignee: Amareshwari Sriramadasu
> Fix For: 2.4
>
> Attachments: LENS-756.patch
>
>
> Query:cube select customer_city_name, store_sales from sales where time_range_in(delivery_time, '2015-04-12-00', '2015-04-13-00')
> Total time for running examples(in millis) :1216047
> Exception in thread "main" LensAPIException(errorResult=LensAPIResult(apiVersion=null, id=8f82a87d-249c-41ef-9e26-80fd6aef1355, data=null, lensErrorTO=LensErrorTO(code=1001, message=Internal Server Error., stackTrace=org.apache.lens.server.api.error.LensException: Driver :org.apache.lens.driver.jdbc.JDBCDriver Cause :No dimension table has the queried columns for customer, columns: [id, city_id]
> Driver :org.apache.lens.driver.hive.HiveDriver Cause :No dimension table has the queried columns for customer, columns: [id, city_id]
> at org.apache.lens.server.query.QueryExecutionServiceImpl.rewriteAndSelect(QueryExecutionServiceImpl.java:1283)
> at org.apache.lens.server.query.QueryExecutionServiceImpl.executeAsyncInternal(QueryExecutionServiceImpl.java:1696)
> at org.apache.lens.server.query.QueryExecutionServiceImpl.executeAsync(QueryExecutionServiceImpl.java:1647)
> at org.apache.lens.server.query.QueryServiceResource.query(QueryServiceResource.java:226)
> at sun.reflect.GeneratedMethodAccessor44.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:601)
> at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
> at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:151)
> at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:171)
> at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:195)
> at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:104)
> at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:353)
> at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:343)
> at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
> at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:255)
> at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
> at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
> at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
> at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
> at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
> at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:318)
> at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:235)
> at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:983)
> at org.glassfish.jersey.grizzly2.httpserver.GrizzlyHttpContainer.service(GrizzlyHttpContainer.java:330)
> at org.glassfish.grizzly.http.server.HttpHandler$1.run(HttpHandler.java:212)
> at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:565)
> at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.run(AbstractThreadPool.java:545)
> at java.lang.Thread.run(Thread.java:722)
> , payload=null, childErrors=null), httpStatusCode=null))
> at org.apache.lens.client.LensStatement.executeQuery(LensStatement.java:309)
> at org.apache.lens.client.LensStatement.executeQuery(LensStatement.java:99)
> at org.apache.lens.examples.SampleQueries.runQueries(SampleQueries.java:135)
> at org.apache.lens.examples.SampleQueries.queryAll(SampleQueries.java:105)
> at org.apache.lens.examples.SampleQueries.main(SampleQueries.java:85)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)