[
https://issues.apache.org/jira/browse/HIVE-26755?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17679822#comment-17679822
]
Stamatis Zampetakis commented on HIVE-26755:
--------------------------------------------
[~sbadhya] I remember that I found this bug while working in HIVE-21599 but I
didn't try to come up with a solution. Changing the property is a workaround
but I wouldn't consider it a solution although I am quite out-of-context right
now.
> Wrong results after renaming Parquet column
> -------------------------------------------
>
> Key: HIVE-26755
> URL: https://issues.apache.org/jira/browse/HIVE-26755
> Project: Hive
> Issue Type: Bug
> Components: HiveServer2, Parquet
> Affects Versions: 4.0.0-alpha-2
> Reporter: Stamatis Zampetakis
> Priority: Major
>
> Renaming the column of a Parquet table leads to wrong results when the query
> uses the renamed column.
> {code:sql}
> 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;
> {code}
> ||Correct results||
> |Alex|
> |Marco|
> {code:sql}
> alter table person change column age years_from_birth int;
> select fname from person where years_from_birth >=25;
> {code}
> After renaming the column the query above returns an empty result set.
> {code:sql}
> select years_from_birth from person;
> {code}
> ||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).
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
