GROUP BY 1?

Hi Calcite community, I'm trying to validate a SQL like the one below. SELECT user_id, COUNT(1) cnt FROM schema.table_name GROUP BY 1; It looks like in the default configuration, GROUP BY 1 is not considered valid. It complains user_id is not being grouped. Is there a quick configuration

Re: GROUP BY 1?

ite community, > > I'm trying to validate a SQL like the one below. > > SELECT user_id, COUNT(1) cnt FROM schema.table_name GROUP BY 1; > > It looks like in the default configuration, GROUP BY 1 is not considered > valid. It complains user_id is not being grouped. > >