fantasy2100 commented on issue #5179:
URL: https://github.com/apache/paimon/issues/5179#issuecomment-2701321364
@dark2momo Thank you very much for your reply, your explanation is very
clear.
I have one more question about `reordering the rows based on the
sequence-group field`.
Consider the following scenario:
CREATE TABLE t1
(
k INT,
a INT,
b INT,
g_1 INT,
PRIMARY KEY (k) NOT ENFORCED
) WITH (
'merge-engine' = 'partial-update',
'fields.a.aggregate-function' = 'sum',
'fields.b.aggregate-function' = '**first_value**',
'fields.g_1.sequence-group' = 'a,b'
);
INSERT INTO t1 VALUES (1, 1, 1, 1);
INSERT INTO t1 VALUES (1, 2, 2, 2);
INSERT INTO t1 VALUES (1, 3, 3, 1);
`SELECT * FROM t1` output `**1,6,3,2**`。
From the output it is inferred that the order of the records after
reordering is
+I(1, 3, 3, 1);
+I(1, 1, 1, 1);
+I(1, 2, 2, 2);
My question is, why is the order of records after reordering not.
+I(1, 1, 1, 1);
+I(1, 3, 3, 1);
+I(1, 2, 2, 2);
--
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]
