[jira] [Commented] (LENS-756) Example query on customer_city_name failing
[ https://issues.apache.org/jira/browse/LENS-756?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14738601#comment-14738601 ] Hadoop QA commented on LENS-756: Applied patch: [LENS-756.patch|https://issues.apache.org/jira/secure/attachment/12755101/LENS-756.patch] and ran command: mvn clean install. Result: Success. Build Job: https://builds.apache.org/job/PreCommit-Lens-Build/53/ > 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 >
[jira] [Commented] (LENS-756) Example query on customer_city_name failing
[ https://issues.apache.org/jira/browse/LENS-756?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14738174#comment-14738174 ] Amareshwari Sriramadasu commented on LENS-756: -- I tried to fix this, but does not seem straightforward : Created LENS-771 for tracking. Planning to remove multiple chain ref columns from customer_city_name for examples to pass, as part of this jira. > 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 > > > 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 >