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/02/05 09:06:35 UTC
[jira] [Closed] (LENS-131) Query fails when constants projected
[ https://issues.apache.org/jira/browse/LENS-131?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Arshad Matin closed LENS-131.
-----------------------------
> 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)