You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lens.apache.org by "Rajitha R (JIRA)" <ji...@apache.org> on 2017/12/19 09:32:00 UTC
[jira] [Commented] (LENS-1494) Failure in Lens example query
[ https://issues.apache.org/jira/browse/LENS-1494?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16296531#comment-16296531 ]
Rajitha R commented on LENS-1494:
---------------------------------
This is happening due to the alias with quotations in the rewritten query.
{code}
19 Dec 2017 09:30:35 [27c52632-448f-4e6a-a1a1-a4536138f674] [f4cfbe62-a3d6-485d-9793-8a52eefa405f estimate-3] INFO org.apache.lens.driver.jdbc.ColumnarSQLRewriter 1229 - Rewritten Query : select sum((mydb_sales_aggr_continuous_fact___sales.store_sales)) as `store_sales` from mydb_sales_aggr_continuous_fact mydb_sales_aggr_continuous_fact___sales where (mydb_sales_aggr_continuous_fact___sales.order_time) between '2017-12-17 15:00:35' and '2017-12-19 15:00:35'
{code}
As seen above `store_sales` is cause of the issue. This needs to be fixed.
> Failure in Lens example query
> ------------------------------
>
> Key: LENS-1494
> URL: https://issues.apache.org/jira/browse/LENS-1494
> Project: Apache Lens
> Issue Type: Bug
> Components: examples
> Reporter: Rajitha R
> Priority: Minor
>
> Able to run examples
> Successful queries 150 out of 151queries
> Total time for running examples(in millis) :839963
> 1 failed
> One Failiure
> Query:cube select store_sales from sales where time_range_in(order_time, 'now.second-2 days', 'now.second')
> 15 Dec 2017 10:08:41 [main] ERROR cliLogger - Exception for example query : "cube select store_sales from sales where time_range_in(order_time, 'now.second-2 days', 'now.second')"
> org.apache.lens.client.exceptions.LensAPIException: Semantic Error : unknown token:
> at org.apache.lens.client.LensStatement.submitQuery(LensStatement.java:482) ~[lens-client-2.7.1-SNAPSHOT.jar:2.7.1-SNAPSHOT]
> at org.apache.lens.client.LensStatement.executeQuery(LensStatement.java:95) ~[lens-client-2.7.1-SNAPSHOT.jar:2.7.1-SNAPSHOT]
> at org.apache.lens.examples.SampleQueries.runQueries(SampleQueries.java:138) [lens-examples-2.7.1-SNAPSHOT.jar:2.7.1-SNAPSHOT]
> at org.apache.lens.examples.SampleQueries.queryAll(SampleQueries.java:107) [lens-examples-2.7.1-SNAPSHOT.jar:2.7.1-SNAPSHOT]
> at org.apache.lens.examples.SampleQueries.main(SampleQueries.java:87) [lens-examples-2.7.1-SNAPSHOT.jar:2.7.1-SNAPSHOT]
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)