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