You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lens.apache.org by "Arshad Matin (JIRA)" <ji...@apache.org> on 2015/03/24 09:47:53 UTC
[jira] [Created] (LENS-432) Select statement is missing from
rewritten query
Arshad Matin created LENS-432:
---------------------------------
Summary: Select statement is missing from rewritten query
Key: LENS-432
URL: https://issues.apache.org/jira/browse/LENS-432
Project: Apache Lens
Issue Type: Bug
Reporter: Arshad Matin
{noformat}
lens-shell>query execute cube select 3.1415926BD from country_carrier_map limit 1
Launching query failed cause:Error while compiling statement: FAILED: ParseException line 1:8 cannot recognize input near 'FROM' 'mar12' '.' in select clause
lens-shell>
{noformat}
{noformat}
24 Mar 2015 08:44:39,557 [QuerySubmitter] INFO hive.ql.parse.ParseDriver - Parsing command: cube select 3.1415926BD from country_carrier_map limit 1
24 Mar 2015 08:44:39,558 [QuerySubmitter] INFO hive.ql.parse.ParseDriver - Parse Completed
24 Mar 2015 08:44:39,561 [estimate-29] INFO hive.ql.parse.ParseDriver - Parsing command: cube select 3.1415926BD from country_carrier_map limit 1
24 Mar 2015 08:44:39,562 [estimate-29] INFO hive.ql.parse.ParseDriver - Parse Completed
24 Mar 2015 08:44:39,562 [estimate-29] INFO org.apache.lens.cube.parse.CandidateTableResolver - Populated candidate dims:[country_carrier_map_table, country_carrier_map_subset] for country_carrier_map
24 Mar 2015 08:44:39,563 [estimate-29] INFO org.apache.lens.cube.parse.JoinResolver - No dimension tables to resolve and no join chains present!
24 Mar 2015 08:44:39,563 [estimate-29] INFO org.apache.lens.cube.parse.GroupbyResolver - Not promoting groupby expression to select, since there are expression projected
24 Mar 2015 08:44:39,563 [estimate-29] INFO org.apache.lens.cube.parse.StorageTableResolver - Adding existing partitionlatest
24 Mar 2015 08:44:39,563 [estimate-29] INFO org.apache.lens.cube.parse.StorageTableResolver - Storage:uh1_ib is not supported
24 Mar 2015 08:44:39,563 [estimate-29] INFO org.apache.lens.cube.parse.StorageTableResolver - Not considering dim table:country_carrier_map_subset as no candidate storage tables eixst
24 Mar 2015 08:44:39,568 [estimate-29] INFO org.apache.lens.cube.parse.CubeQueryContext - Available candidate dims are:[country_carrier_map_table], picking up country_carrier_map_table for querying
24 Mar 2015 08:44:39,568 [estimate-29] INFO org.apache.lens.cube.parse.CubeQueryContext - Picked Fact:null dimsToQuery:{country_carrier_map=country_carrier_map_table}
24 Mar 2015 08:44:39,568 [estimate-29] INFO org.apache.lens.driver.cube.RewriteUtil - Final rewritten query for driver:org.apache.lens.driver.hive.HiveDriver@3569158f is: SELECT FROM mar12.uh1_country_carrier_map_table country_carrier_map WHERE ((((country_carrier_map.dt = 'latest')))) LIMIT 1
24 Mar 2015 08:44:39,568 [estimate-29] INFO org.apache.lens.driver.hive.HiveDriver - Estimate: SELECT FROM mar12.uh1_country_carrier_map_table country_carrier_map WHERE ((((country_carrier_map.dt = 'latest')))) LIMIT 1
24 Mar 2015 08:44:39,569 [estimate-30] INFO hive.ql.parse.ParseDriver - Parsing command: cube select 3.1415926BD from country_carrier_map limit 1
24 Mar 2015 08:44:39,569 [estimate-30] INFO hive.ql.parse.ParseDriver - Parse Completed
24 Mar 2015 08:44:39,570 [estimate-30] INFO org.apache.lens.cube.parse.CandidateTableResolver - Populated candidate dims:[country_carrier_map_table, country_carrier_map_subset] for country_carrier_map
24 Mar 2015 08:44:39,570 [estimate-30] INFO org.apache.lens.cube.parse.JoinResolver - No dimension tables to resolve and no join chains present!
24 Mar 2015 08:44:39,570 [estimate-30] INFO org.apache.lens.cube.parse.GroupbyResolver - Not promoting groupby expression to select, since there are expression projected
24 Mar 2015 08:44:39,570 [estimate-30] INFO org.apache.lens.cube.parse.StorageTableResolver - Storage:uh1 is not supported
24 Mar 2015 08:44:39,571 [estimate-30] INFO org.apache.lens.cube.parse.StorageTableResolver - Not considering dim table:country_carrier_map_table as no candidate storage tables eixst
24 Mar 2015 08:44:39,575 [estimate-30] INFO org.apache.lens.cube.parse.CubeQueryContext - Available candidate dims are:[country_carrier_map_subset], picking up country_carrier_map_subset for querying
24 Mar 2015 08:44:39,575 [estimate-30] INFO org.apache.lens.cube.parse.CubeQueryContext - Picked Fact:null dimsToQuery:{country_carrier_map=country_carrier_map_subset}
24 Mar 2015 08:44:39,575 [estimate-30] INFO org.apache.lens.driver.cube.RewriteUtil - Final rewritten query for driver:org.apache.lens.driver.jdbc.JDBCDriver@5ffcaad4 is: SELECT FROM mar12.uh1_ib_country_carrier_map_subset country_carrier_map LIMIT 1
24 Mar 2015 08:44:39,575 [estimate-30] INFO hive.ql.parse.ParseDriver - Parsing command: SELECT FROM mar12.uh1_ib_country_carrier_map_subset country_carrier_map LIMIT 1
24 Mar 2015 08:44:39,576 [estimate-30] ERROR org.apache.lens.server.api.query.AbstractQueryContext - Setting driver cost failed for driver org.apache.lens.driver.jdbc.JDBCDriver@5ffcaad4 Cause: Driver :org.apache.lens.driver.jdbc.JDBCDriver Cause :line 1:8 cannot recognize input near 'FROM' 'mar12' '.' in select clause
org.apache.lens.api.LensException: org.apache.hadoop.hive.ql.parse.ParseException: line 1:8 cannot recognize input near 'FROM' 'mar12' '.' in select clause
at org.apache.lens.driver.jdbc.JDBCDriver.rewriteQuery(JDBCDriver.java:534)
at org.apache.lens.driver.jdbc.JDBCDriver.prepareInternal(JDBCDriver.java:749)
at org.apache.lens.driver.jdbc.JDBCDriver.validate(JDBCDriver.java:642)
at org.apache.lens.driver.jdbc.JDBCDriver.estimate(JDBCDriver.java:570)
at org.apache.lens.server.api.query.AbstractQueryContext$DriverEstimateRunnable.run(AbstractQueryContext.java:208)
at org.apache.lens.server.query.QueryExecutionServiceImpl$RewriteEstimateRunnable.run(QueryExecutionServiceImpl.java:1137)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:701)
Caused by: org.apache.hadoop.hive.ql.parse.ParseException: line 1:8 cannot recognize input near 'FROM' 'mar12' '.' in select clause
at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:202)
at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:166)
at org.apache.lens.cube.parse.HQLParser.parseHQL(HQLParser.java:120)
at org.apache.lens.driver.jdbc.JDBCDriver.rewriteQuery(JDBCDriver.java:522)
... 11 more
24 Mar 2015 08:44:39,577 [estimate-30] ERROR org.apache.lens.server.query.QueryExecutionServiceImpl - Estimate failed for driver org.apache.lens.driver.jdbc.JDBCDriver@5ffcaad4 cause: Driver :org.apache.lens.driver.jdbc.JDBCDriver Cause :line 1:8 cannot recognize input near 'FROM' 'mar12' '.' in select clause
24 Mar 2015 08:44:39,577 [QuerySubmitter] INFO org.apache.lens.driver.hive.HiveDriver - Hive driver query:SELECT FROM mar12.uh1_country_carrier_map_table country_carrier_map WHERE ((((country_carrier_map.dt = 'latest')))) LIMIT 1
24 Mar 2015 08:44:39,577 [QuerySubmitter] INFO org.apache.lens.driver.hive.HiveDriver - whetherCalculatePriority: true
24 Mar 2015 08:44:39,577 [QuerySubmitter] INFO org.apache.lens.driver.hive.HiveDriver - Explain: SELECT FROM mar12.uh1_country_carrier_map_table country_carrier_map WHERE ((((country_carrier_map.dt = 'latest')))) LIMIT 1
24 Mar 2015 08:44:39,577 [QuerySubmitter] INFO org.apache.lens.server.api.query.AbstractQueryContext - Generated metric id: b0562eef-fa56-4557-bd39-4710bf644620 for query: EXPLAIN EXTENDED SELECT FROM mar12.uh1_country_carrier_map_table country_carrier_map WHERE ((((country_carrier_map.dt = 'latest')))) LIMIT 1
24 Mar 2015 08:44:39,577 [QuerySubmitter] INFO org.apache.lens.driver.hive.HiveDriver - Hive driver query:EXPLAIN EXTENDED SELECT FROM mar12.uh1_country_carrier_map_table country_carrier_map WHERE ((((country_carrier_map.dt = 'latest')))) LIMIT 1
24 Mar 2015 08:44:39,578 [QuerySubmitter] INFO org.apache.lens.driver.hive.HiveDriver - New thrift connection class org.apache.lens.driver.hive.RemoteThriftConnection for thread:9 for user:dataqa connection ID=11
24 Mar 2015 08:44:39,578 [QuerySubmitter] INFO org.apache.lens.driver.hive.RemoteThriftConnection - HiveDriver connecting to HiveServer @ localhost:10000
24 Mar 2015 08:44:39,578 [QuerySubmitter] INFO org.apache.hive.service.cli.thrift.RetryingThriftCLIServiceClient - Connecting to localhost:10000
24 Mar 2015 08:44:39,590 [Grizzly-worker(3)] INFO org.apache.lens.server.AuthenticationFilter - Request from user: null, path=/queryapi/queries/59ecd676-9c6c-483e-b065-95469b9f717e
24 Mar 2015 08:44:39,699 [QuerySubmitter] INFO org.apache.hive.service.cli.thrift.RetryingThriftCLIServiceClient - Connected!
24 Mar 2015 08:44:39,700 [QuerySubmitter] INFO org.apache.lens.driver.hive.RemoteThriftConnection - HiveDriver connected to HiveServer @ localhost:10000
24 Mar 2015 08:44:39,710 [QuerySubmitter] INFO org.apache.lens.driver.hive.HiveDriver - No hive operation available for 5f7febcd-8ce6-42cf-9045-c7703fb0a7bf
24 Mar 2015 08:44:39,711 [QuerySubmitter] ERROR org.apache.lens.driver.hive.HiveDriver - could not set priority for lens session id:9c443acb-68af-425b-9f14-1f5ff5afa123User query: cube select 3.1415926BD from country_carrier_map limit 1
org.apache.lens.api.LensException: Error executing query
at org.apache.lens.driver.hive.HiveDriver.execute(HiveDriver.java:475)
at org.apache.lens.driver.hive.HiveDriver.explain(HiveDriver.java:386)
at org.apache.lens.driver.hive.HiveDriver.executeAsync(HiveDriver.java:494)
at org.apache.lens.server.query.QueryExecutionServiceImpl$QuerySubmitter.run(QueryExecutionServiceImpl.java:477)
at java.lang.Thread.run(Thread.java:701)
Caused by: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 1:25 cannot recognize input near 'FROM' 'mar12' '.' in select clause
at org.apache.hive.service.cli.thrift.ThriftCLIServiceClient.checkStatus(ThriftCLIServiceClient.java:52)
at org.apache.hive.service.cli.thrift.ThriftCLIServiceClient.executeStatementInternal(ThriftCLIServiceClient.java:151)
at org.apache.hive.service.cli.thrift.ThriftCLIServiceClient.executeStatement(ThriftCLIServiceClient.java:129)
at sun.reflect.GeneratedMethodAccessor30.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:622)
at org.apache.hive.service.cli.thrift.RetryingThriftCLIServiceClient.invokeInternal(RetryingThriftCLIServiceClient.java:301)
at org.apache.hive.service.cli.thrift.RetryingThriftCLIServiceClient.invoke(RetryingThriftCLIServiceClient.java:329)
at com.sun.proxy.$Proxy66.executeStatement(Unknown Source)
at org.apache.hive.service.cli.thrift.RetryingThriftCLIServiceClient$CLIServiceClientWrapper.executeStatement(RetryingThriftCLIServiceClient.java:111)
at org.apache.lens.driver.hive.HiveDriver.execute(HiveDriver.java:452)
... 4 more
24 Mar 2015 08:44:39,722 [QuerySubmitter] INFO org.apache.lens.driver.hive.HiveDriver - No hive operation available for 59ecd676-9c6c-483e-b065-95469b9f717e
24 Mar 2015 08:44:39,722 [QuerySubmitter] ERROR org.apache.lens.server.query.QueryExecutionServiceImpl - Error launching query 59ecd676-9c6c-483e-b065-95469b9f717e
org.apache.lens.api.LensException: Error executing async query
at org.apache.lens.driver.hive.HiveDriver.executeAsync(HiveDriver.java:513)
at org.apache.lens.server.query.QueryExecutionServiceImpl$QuerySubmitter.run(QueryExecutionServiceImpl.java:477)
at java.lang.Thread.run(Thread.java:701)
Caused by: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 1:8 cannot recognize input near 'FROM' 'mar12' '.' in select clause
at org.apache.hive.service.cli.thrift.ThriftCLIServiceClient.checkStatus(ThriftCLIServiceClient.java:52)
at org.apache.hive.service.cli.thrift.ThriftCLIServiceClient.executeStatementInternal(ThriftCLIServiceClient.java:151)
at org.apache.hive.service.cli.thrift.ThriftCLIServiceClient.executeStatementAsync(ThriftCLIServiceClient.java:139)
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.apache.hive.service.cli.thrift.RetryingThriftCLIServiceClient.invokeInternal(RetryingThriftCLIServiceClient.java:301)
at org.apache.hive.service.cli.thrift.RetryingThriftCLIServiceClient.invoke(RetryingThriftCLIServiceClient.java:329)
at com.sun.proxy.$Proxy66.executeStatementAsync(Unknown Source)
at org.apache.hive.service.cli.thrift.RetryingThriftCLIServiceClient$CLIServiceClientWrapper.executeStatementAsync(RetryingThriftCLIServiceClient.java:118)
at org.apache.lens.driver.hive.HiveDriver.executeAsync(HiveDriver.java:504)
... 2 more
24 Mar 2015 08:44:39,795 [Grizzly-worker(4)] INFO org.apache.lens.server.AuthenticationFilter - Request from user: null, path=/queryapi/queries/59ecd676-9c6c-483e-b065-95469b9f717e
{noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)