ad1happy2go commented on issue #9865:
URL: https://github.com/apache/hudi/issues/9865#issuecomment-1763763568

   @CrystalCat There is a known issue with MERGE INTO when using with Global 
Index and partition path update. MERGE INTO (Expression payload) Code path 
doesn't support it yet. 
   
   JIRA - https://issues.apache.org/jira/browse/HUDI-6737
   
   I was able to reproduce the issue with your schema only when we try to 
update partition path - 
   
   ```
   drop table hudi_events;
   CREATE TABLE default.hudi_events (
     timestamp INT,
     visitorid INT,
     event STRING,
     itemid INT,
     transactionid INT
   ) USING HUDI
   PARTITIONED BY (event)
   TBLPROPERTIES (
     primaryKey = 'visitorid',
      preCombineField = 'timestamp',
      hoodie.index.type= 'GLOBAL_BLOOM',
     type = 'cow'
   );
   
   insert into hudi_events values (1,1,1,1,'a');
   
   Drop table default.events_incremental;
   CREATE TABLE default.events_incremental (
     timestamp INT,
     visitorid INT,
     event STRING,
     itemid INT,
     transactionid INT
   ) USING PARQUET;
   
   
   insert into events_incremental values (1,1,'b',2,1);
   
   
   merge into hudi_events as target
   using events_incremental as source
   on target.timestamp = source.timestamp
   when matched then update set *
   when not matched then insert *
   ;
   -- Getting - Caused by: java.lang.ArrayIndexOutOfBoundsException: 25
   ```
   
   But when I try to use timestamp column , then 
   
   


-- 
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]

Reply via email to