Raghavendra Singh created LENS-151:
--------------------------------------

             Summary: queries with dim attributes having alias names with 
spaces are failing
                 Key: LENS-151
                 URL: https://issues.apache.org/jira/browse/LENS-151
             Project: Apache Lens
          Issue Type: Bug
            Reporter: Raghavendra Singh
            Assignee: Himanshu Gahlaut
             Fix For: 2.0


query with dim attributes having alias names with spaces
like 

{CODE}
cube select dim1 as `dim name`,m1 as `measure1` from testcube where 
time_range_in(col,from.to)
{CODE}

are failing (at group by auto resolution )

error:-
{CODE}
org.apache.hadoop.hive.ql.parse.SemanticException: 
org.apache.hadoop.hive.ql.parse.ParseException: line 1:40 character '<EOF>' not 
supported here
        at 
org.apache.lens.cube.parse.GroupbyResolver.promoteSelect(GroupbyResolver.java:81)
        at 
org.apache.lens.cube.parse.GroupbyResolver.rewriteContext(GroupbyResolver.java:160)
        at 
org.apache.lens.cube.parse.CubeQueryRewriter.rewrite(CubeQueryRewriter.java:186)
        at 
org.apache.lens.cube.parse.CubeQueryRewriter.rewrite(CubeQueryRewriter.java:170)
        at 
org.apache.lens.cube.parse.CubeQueryRewriter.rewrite(CubeQueryRewriter.java:181)
        at 
org.apache.lens.driver.cube.RewriteUtil.rewriteQuery(RewriteUtil.java:249)
        at 
org.apache.lens.server.query.QueryExecutionServiceImpl.explain(QueryExecutionServiceImpl.java:1788)
        at 
org.apache.lens.server.query.QueryServiceResource.query(QueryServiceResource.java:223)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:622)
        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:701)
Caused by: org.apache.hadoop.hive.ql.parse.ParseException: line 1:40 character 
'<EOF>' not supported here
        at 
org.apache.hadoop.hive.ql.parse.ParseDriver.parseExpression(ParseDriver.java:276)
        at org.apache.lens.cube.parse.HQLParser.parseExpr(HQLParser.java:185)
        at 
org.apache.lens.cube.parse.GroupbyResolver.promoteSelect(GroupbyResolver.java:79)
        ... 33 more
{CODE}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to