[HIVE-26755] Wrong results after renaming Parquet column

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 4.0.0-alpha-2
• Component/s: HiveServer2, Parquet
• Assignee: Unassigned
• Reporter: Stamatis Zampetakis
• Created: 17/Nov/22 14:43
• Updated: 23/Jan/23 14:31

Description

Renaming the column of a Parquet table leads to wrong results when the query uses the renamed column.

create table person (id int, fname string, lname string, age int) stored as parquet;

insert into person values (1, 'Victor', 'Hugo', 23);
insert into person values (2, 'Alex', 'Dumas', 38);
insert into person values (3, 'Marco', 'Pollo', 25);

select fname from person where age >=25;

Correct results
Alex
Marco

alter table person change column age years_from_birth int;
select fname from person where years_from_birth >=25;

After renaming the column the query above returns an empty result set.

select years_from_birth from person;

Wrong results
NULL
NULL
NULL

After renaming the column the query returns the correct number of rows but all filled with nulls.

The problem is reproducible on current master (commit ae0cabffeaf284a6d2ec13a6993c87770818fbb9).

Issue Links

• Discovered while testing: HIVE-21599 Wrong results for partitioned Parquet table when files contain partition column