[GitHub] [iceberg] rakesh-tmdc commented on issue #5424: MERGE INTO TABLE is not supported temporarily

[GitBox <gi...@apache.org>]

rakesh-tmdc commented on issue #5424:
URL: https://github.com/apache/iceberg/issues/5424#issuecomment-1220688298

   Hi I am also facing similar kind of issue with merge into functionality. I am using spark3.3.0 with iceberg 0.14.0 and getting below error with complete subquery -
   
   `Caused by: org.apache.spark.sql.AnalysisException: unresolved operator 'ReplaceIcebergData RelationV2[__metadata#404, uuid#405, ts#406, user_id#407, segment_id#408, activity#409, activity_occurrence#410, repeated_at#411] default.segment_table; 
   `
   With merge into clause -
   `MERGE INTO default.segment_table old USING (SELECT * FROM segment_final) new ON old.uuid = new.uuid AND old.repeated_at IS NULL WHEN MATCHED THEN UPDATE SET * WHEN NOT MATCHED THEN INSERT * `
   
   However when i am trying single merge condition seperatly like `WHEN MATCHED THEN UPDATE SET * ` or `WHEN NOT MATCHED THEN INSERT * ` its working fine.


-- 
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: issues-unsubscribe@iceberg.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org