Hi ShaoFeng, thanks for the answer. The issue is I DON'T want group by index column. I want to execute sql with GROUP BY <constant>, like "GROUP BY TRUE" or "GROUP BY 1.1000001" which is something that Tableau produces. And I don't know how to achieve this. I run Kylin in version 2.6.2-hadoop3 (I have HDP 3.1) and Tableau I don't remember, but I can get back this information later.
śr., 26 cze 2019 o 16:35 ShaoFeng Shi <[email protected]> napisał(a): > 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 >> >
