impala-reviews mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John Russell (Code Review)" <>
Subject [Impala-ASF-CR] Updates to DML statements for Impala + Kudu
Date Wed, 18 Jan 2017 19:08:44 GMT
John Russell has posted comments on this change.

Change subject: Updates to DML statements for Impala + Kudu

Patch Set 1:

File docs/topics/impala_delete.xml:

Line 49: DELETE [FROM] [<varname>database_name</varname>].<varname>table_name</varname>
[ WHERE <varname>where_conditions</varname> ]
> I think there is another form to describe:

PS1, Line 65:  <p>
            :       Normally, a <codeph>DELETE</codeph> operation for a Kudu table
fails if
            :       some partition key columns are not found, due to their being deleted or
            :       by a concurrent <codeph>UPDATE</codeph> or <codeph>DELETE</codeph>
            :       Specify <codeph>DELETE IGNORE <varname>rest_of_statement</varname></codeph>
            :       make the <codeph>DELETE</codeph> continue in this case. The
rows with the nonexistent
            :       duplicate partition key column values are not removed.
            :     </p>
> I don't think this is relevant anymore (the IGNORE keyword is gone)

Line 101: <!-- To do: investigate if the table reference can actually be a join clause,
to delete from multiple tables at once. -->
> Yes it can, using syntax like:
File docs/topics/impala_update.xml:

Line 50:   [ WHERE <varname>where_conditions</varname> ]
> similar to my comment on the DELETE, this can support UPDATE with JOIN
Example of the syntax? I get errors trying to put the join clause in different places:

update t1 join t2 on t1.x = t2.x set t1.y = true
Encountered: JOIN
Expected: SET

update t1, t2
Encountered: COMMA
Expected: SET

To view, visit
To unsubscribe, visit

Gerrit-MessageType: comment
Gerrit-Change-Id: I60512b7957fb53d86d3123a4f1d46fbb355f4665
Gerrit-PatchSet: 1
Gerrit-Project: Impala-ASF
Gerrit-Branch: master
Gerrit-Owner: John Russell <>
Gerrit-Reviewer: Ambreen Kazi <>
Gerrit-Reviewer: Dimitris Tsirogiannis <>
Gerrit-Reviewer: Jean-Daniel Cryans <>
Gerrit-Reviewer: John Russell <>
Gerrit-Reviewer: Matthew Jacobs <>
Gerrit-Reviewer: Todd Lipcon <>
Gerrit-HasComments: Yes

View raw message