Public signup for this instance is disabled. Our Jira Guidelines page explains how to get an account.
When the sql can rewrite, if the group by ordinal reference is still a numeric literal, it will throw exception
select 13, id, count(1) from dimtbl group by 1, 2;
ERROR: AnalysisException: GROUP BY: ordinal exceeds the number of items in the SELECT list: 13
Predicates in the SELECT and GROUP-BY cause failure with CNF rewrite enabled
Query with select alias the same as column name rewrite error for grouping exprs