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

["Krzysztof Zarzycki (JIRA)" <ji...@apache.org>]

Krzysztof Zarzycki created KYLIN-4077:
-----------------------------------------

             Summary: 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
            Reporter: Krzysztof Zarzycki


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)