[jira] [Commented] (KYLIN-4077) Kylin does not handle queries with GROUP BY constant.

["Xi Chen (JIRA)" <ji...@apache.org>]

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

Xi Chen commented on KYLIN-4077:
--------------------------------

Run into the same issue after upgrading from 2.2.0 to 2.6.3.

It can be easily reproduced with a simple query with sample cube:
{code:java}
select part_dt, count(*), 'true' as t from kylin_sales GROUP BY part_dt, 'true'
{code}
Would you please have a look at this issue? [~Wayne0101]

> Kylin does not handle queries with GROUP BY constant. 
> ------------------------------------------------------
>
>                 Key: KYLIN-4077
>                 URL: https://issues.apache.org/jira/browse/KYLIN-4077
>             Project: Kylin
>          Issue Type: Bug
>         Environment: Apache Kylin 2.6.2-hadoop3
>            Reporter: Krzysztof Zarzycki
>            Priority: Major
>
> I connect Tableau to Kylin and one of the queries it generates has a clause {{GROUP BY 1.100000001}}  , that Kylin cannot handle. 
> {code:java}
> From line 1, column 8 to line 1, column 15: Aggregate expression is illegal in GROUP BY clause while executing SQL: "select count(*) from report_sales.kylin_sales_model GROUP BY 1.1000001 LIMIT 50000"  {code}
> Alternatively, I connected to Kylin with Hive JdbcStorageHandler and it translates the query to {{GROUP BY TRUE}} and that is also not handled. 
> {code:java}
> No DataTypeSerializer for type _literal_type while executing SQL: "select count(*) from report_sales.kylin_sales_model GROUP BY TRUE LIMIT 50000"  {code}
> Expected behavior:
> Kylin supports queries with {{GROUP BY <any constant>}} 



--
This message was sent by Atlassian JIRA
(v7.6.14#76016)