MasonMa-sy opened a new issue, #6092:
URL: https://github.com/apache/paimon/issues/6092

   ### Search before asking
   
   - [x] I searched in the [issues](https://github.com/apache/paimon/issues) 
and found nothing similar.
   
   
   ### Motivation
   
   The only aggregate function currently supported for nested types is 
nestd_update.
   There is no support for STRUCT type yet. For spark example
   ```sql
   CREATE TABLE t(
       k INT,
       a STRUCT<a1: BIGINT, a2: BIGINT>,
       g INT
   )
   TBLPROPERTIES ('primary-key' = 'k', 'merge-engine' = 'partial-update',
       'fields.g.sequence-group'='a.a1,a.a2',
       'fields.a.a1.aggregate-function'='sum',
       'fields.a.a2.aggregate-function'='product'
   )
   
   INSERT INTO t
   VALUES (1, STRUCT(1,3), 1);
   
   INSERT INTO t
   VALUES (1, STRUCT(2,4), 2);
   ```
   The result expected is `1, STRUCT(3,12), 2`. However the actually output is 
`1, STRUCT(2,4), 2` because of nested aggregate-function has not been 
implemented.
   
   ### Solution
   
   _No response_
   
   ### Anything else?
   
   _No response_
   
   ### Are you willing to submit a PR?
   
   - [ ] I'm willing to submit a PR!


-- 
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-unsubscr...@paimon.apache.org.apache.org

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

Reply via email to