[
https://issues.apache.org/jira/browse/LENS-131?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14306805#comment-14306805
]
Arshad Matin commented on LENS-131:
-----------------------------------
*Validation*
{noformat}
lens-shell>query execute cube select id,name from sample_dim
sample_dim.id sample_dim.name
5 fifth
6 six
7 seven
null eight
1 first
2 second
3 third
4 fourth
8 rows process in (17) seconds.
lens-shell>query execute cube select id,name,99 from sample_dim
sample_dim.id sample_dim.name _c2
5 fifth 99
6 six 99
7 seven 99
null eight 99
1 first 99
2 second 99
3 third 99
4 fourth 99
8 rows process in (15) seconds.
{noformat}
> Query fails when constants projected
> -------------------------------------
>
> Key: LENS-131
> URL: https://issues.apache.org/jira/browse/LENS-131
> Project: Apache Lens
> Issue Type: Bug
> Components: driver-jdbc
> Reporter: Sushil Mohanty
> Assignee: Sushil Mohanty
> Fix For: 2.0
>
> Attachments: LENS-131-5.patch, LENS-131.patch
>
>
> Queries having constants projected fails with below error.
> {CODE}
> select tab1.id ,99 as col2, sum(col3) as sum_col3 from tab1 group by
> tab1.id,99;
> ERROR 1054 (42S22): Unknown column '99' in 'group statement'
> {CODE}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
