Steve Carlin created HIVE-22265: ----------------------------------- Summary: Ordinals in view are not being picked up in materialized view Key: HIVE-22265 URL: https://issues.apache.org/jira/browse/HIVE-22265 Project: Hive Issue Type: Sub-task Components: CBO Affects Versions: 3.1.2 Reporter: Steve Carlin Attachments: lv-exp-unalias.sql
There is a conf which allows ordinals to be used for group by, i.e. hive.groupby.position.alias This isn't being picked up by materialized views when set in a view. Workaround is to not use ordinals. Script is attached. Example: 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`; -- This message was sent by Atlassian Jira (v8.3.4#803005)