[jira] [Created] (CALCITE-3247) wrong sql format when transforming ANSI sql to hive sql

2019-08-13 Thread Jacky Woo (JIRA)
Jacky Woo created CALCITE-3247: -- Summary: wrong sql format when transforming ANSI sql to hive sql Key: CALCITE-3247 URL: https://issues.apache.org/jira/browse/CALCITE-3247 Project: Calcite Issue

[jira] [Created] (CALCITE-3248) support the Connector interface in the golang calcite driver

2019-08-13 Thread Tino Rusch (JIRA)
Tino Rusch created CALCITE-3248: --- Summary: support the Connector interface in the golang calcite driver Key: CALCITE-3248 URL: https://issues.apache.org/jira/browse/CALCITE-3248 Project: Calcite

Is group type "rollup" deduced correctly ?

2019-08-13 Thread Muhammad Gelbana
Based on those pages [1], [2], I understand that for group sets to be a rollup, all groups in the group set must be the same as the union set of groups but with gradually one less group removed from the end. For example, the following are valid rollup groups (The union set of groups is *(G1, G2, G3

Re: Is group type "rollup" deduced correctly ?

2019-08-13 Thread Julian Hyde
The key word is "sets". I think you will agree that ((5,3), (5), ()) is a rollup. Well, it is equivalent to ((3, 5), (5), ()) because each grouping set is a SET, and therefore the order of elements does not matter: (3, 5) is the same as (5, 3). Now, if you're using MySQL, for instance, I c