You are viewing a plain text version of this content. The canonical link for it is here.
Posted to gitbox@hive.apache.org by "InvisibleProgrammer (via GitHub)" <gi...@apache.org> on 2023/01/30 20:44:39 UTC
[GitHub] [hive] InvisibleProgrammer commented on pull request #3993: HIVE-26980: Creation of materialized view stored by Iceberg fails if …
InvisibleProgrammer commented on PR #3993:
URL: https://github.com/apache/hive/pull/3993#issuecomment-1409307463
Hi, @kasakrisz !
Thank you for fixing that issue. I have faced with the exact same in https://issues.apache.org/jira/browse/HIVE-26977?
Could you please add that qtest as well to validate your fix fixes the other issue as well. I already tested it on my computer and it worked.
```
set iceberg.mr.schema.auto.conversion=true;
set hive.vectorized.execution.enabled=true;
set hive.explain.user=false;
drop table if exists source_table;
create external table source_table
(
id char(16)
);
insert into source_table values ('ID_1');
insert into source_table values ('ID_2');
drop table if exists target_table;
explain
create table target_table
stored by iceberg
stored as orc
as select * from source_table;
create table target_table
stored by iceberg
stored as orc
as select * from source_table;
select count(*) from target_table;
```
Thank you,
Zsolt
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org
For additional commands, e-mail: gitbox-help@hive.apache.org