Jackhjf commented on issue #4341:
URL: https://github.com/apache/kyuubi/issues/4341#issuecomment-1455697791
> Fixed in #4358. Please have a check. @Jackhjf
Thanks for your work, I can get the correct result with the following use
case； @bowenliang123 @yaooqinn
create table yhbi.test_copy(id string,name string) using iceberg ;
create table yhbi.test_copy1(id1 string,name1 string) using iceberg ;
create table yhbi.test1(id string,name string) using iceberg（**name** is the
data masking field;
create table iceberg_spark.test_copy(id string,name string) using iceberg
（**name** is the data masking field）;
001
insert into yhbi.test_copy select *from iceberg_spark.test_copy
002
insert into yhbi.test_copy1 select *from iceberg_spark.test_copy
003
insert overwrite yhbi.test_copy1 select id,name as name1 from
iceberg_spark.test_copy
004
insert overwrite yhbi.test_copy1 select id ,name as name1 from
iceberg_spark.test_copy a where a.id in ("111111","11111");
005
insert overwrite yhbi.test_copy1 select id ,name as name1 from
iceberg_spark.test_copy order by id, name;
006
select max(name) from iceberg_spark.test_copy;
select min(name) from iceberg_spark.test_copy;
007
insert overwrite yhbi.test_copy1 select id ,count(name) from
iceberg_spark.test_copy group by id;
insert overwrite yhbi.test_copy1 select count(id) ,name from
iceberg_spark.test_copy group by name;
008
insert overwrite yhbi.test_copy1 select b.id,b.name from
iceberg_spark.test_copy a join iceberg_spark.test1 b on a.id=b.id;
009
insert overwrite yhbi.test_copy1 select id,name as name1 from
iceberg_spark.test_copy union select *from (select a.id ,a.name from
iceberg_spark.test1 a join iceberg_spark.test_copy b on a.id=b.id) c;
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
