There is a conf which allows ordinals to be used for group by, i.e.
This isn't being picked up by materialized views when set in a view. Workaround is to not use ordinals. Script is attached.
create view campaigns.campaign_data_lview_bad as SELECT platform, platform_version, currency, sum(amount) as sum_amount, sum(duration) as sum_duration, count(user_ id) count_user_id, min(amount) min_amount, max(amount) max_amount, year , month FROM `campaigns`.`campaign_data` GROUP BY 1, 2, 3, 9, 10;
create materialized view aview620_bad stored as orc as select platform, platform_version, currency, sum_amount, sum_duration, count_user_id, min_amount, max_amoun t, year, month from `campaigns`.`campaign_data_lview_bad`;