Zoltán Borók-Nagy created IMPALA-12586:
------------------------------------------
Summary: Updating Kudu table with UPDATE FROM might not be
deterministic
Key: IMPALA-12586
URL: https://issues.apache.org/jira/browse/IMPALA-12586
Project: IMPALA
Issue Type: Bug
Reporter: Zoltán Borók-Nagy
If we use the following syntax to update a Kudu table:
{code:java}
UPDATE t1 SET c3 = upper(c3)
FROM kudu_table t1 JOIN non_kudu_table t2
ON t1.id = t2.id;
{code}
and non_kudu_table have multiple matches based on the JOIN condition, then the
kudu_table will be updated randomly.
In that case it would be better to raise an error.
Interestingly enough, Microsoft SQL Server also has UPDATE FROM, and had the
same issue:
https://sqlserverfast.com/blog/hugo/2008/03/lets-deprecate-update-from/
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
