[GitHub] [kyuubi] Jackhjf commented on issue #4341: [Bug] When using kyuubi to do data masking, an error is reported

["Jackhjf (via GitHub)" <gi...@apache.org>]

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: notifications-unsubscribe@kyuubi.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@kyuubi.apache.org
For additional commands, e-mail: notifications-help@kyuubi.apache.org