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)
