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
