You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@lens.apache.org by "Sushil Mohanty (JIRA)" <ji...@apache.org> on 2015/01/14 12:29:34 UTC

[jira] [Commented] (LENS-131) Query fails when constants projected

    [ https://issues.apache.org/jira/browse/LENS-131?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14276809#comment-14276809 ] 

Sushil Mohanty commented on LENS-131:
-------------------------------------

RB request : 
https://reviews.apache.org/r/29881/

> 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
>
>
> 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)