Hi Kryzysztof, If you want to disable grouping by index, try to change the calcite property from "LENIENT" back to "DEFAULT":
kylin.query.calcite.extras-props.conformance=DEFAULT And then restart Kylin to take effect. Just take a try, 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年7月9日周二 下午4:42写道： > Does anyone in the group have a solution for this? > The version of Tableau I have is 2018.3. > I raised a jira ticket for this issue: > https://issues.apache.org/jira/browse/KYLIN-4077 > > Thank you for help, > Krzysztof > > > śr., 26 cze 2019 o 18:34 Krzysztof Zarzycki <[email protected]> > napisał(a): > >> 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 >>>> >>>
