[ https://issues.apache.org/jira/browse/KYLIN-4077?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Krzysztof Zarzycki updated KYLIN-4077: -------------------------------------- Environment: Apache Kylin 2.6.2-hadoop3 > 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 translated the query with Hive JdbcStorageHandler 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.3#76005)