[
https://issues.apache.org/jira/browse/KYLIN-4077?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16977190#comment-16977190
]
Yaqian Zhang commented on KYLIN-4077:
-------------------------------------
Hi:
Actually, versions before kylin 2.4.0 are supports queries with GROUP BY <any
constant>.
Group by constant failed after kylin 2.4.0.
I will try to fix this.
> 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
> Assignee: Yaqian Zhang
> 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
(v8.3.4#803005)
