[HIVE-22265] Ordinals in view are not being picked up in materialized view

• Type: Sub-task
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: 3.1.2
• Component/s: CBO, Materialized views
• Assignee: Unassigned
• Reporter: Steve Carlin
• Created: 27/Sep/19 21:34
• Updated: 11/Feb/20 00:52

Description

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`;