Kylin does support "group by 1, 2, 3" (which is the index of the column). see https://issues.apache.org/jira/browse/KYLIN-3480
I remember that JIRA was to better support tableau, as it will generate such SQL, and it is lucky that Calcite supports this. BTW, what's your Kylin and Tableau version? There are many tableau users here, seems this is the first reporting on this "group by 1.0000" issue. Best regards, Shaofeng Shi 史少锋 Apache Kylin PMC Email: [email protected] Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html Join Kylin user mail group: [email protected] Join Kylin dev mail group: [email protected] Krzysztof Zarzycki <[email protected]> 于2019年6月26日周三 下午10:06写道： > Hi there Kylin community, > I'm a user of Kylin and I connect with Tableau to it. I have an issue, > that Tableau generates queries, that add "GROUP BY 1.100000...01" clause, > which I claim is unnecessary, but it's hard to fight with Tableau. > Unfortunately this query cannot be executed by Kylin, showing an error: > 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" > > Does anyone knows how to overcome this issue? Tableau integration is > probably one of the most common integrations, so probably someone stumbled > upon this. > > What's even more interesting when I modify the query to "GROUP BY > 2.1000001", I get a different error message: > From line 2, column 10 to line 2, column 18: Ordinal out of range while > executing SQL: ... > > Which makes me thinking, that Kylin interprets this 1.100...01 constant as > 1 and then take it as column position from SELECT clause! That looks like a > bug. > > I also tried group by constant, like GROUP BY TRUE, but that doesn't work > either: > No DataTypeSerializer for type _literal_type while executing SQL: "select > count(*) from report_sales.kylin_sales_model GROUP BY TRUE LIMIT 50000" > > Only "GROUP BY ()" produced the right results. But I can't force Tableau > to change queries generated... > > > Thank you, > Krzysztof Zarzycki >
