impala-reviews mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Todd Lipcon (Code Review)" <>
Subject [Impala-ASF-CR] Updates to DML statements for Impala + Kudu
Date Wed, 11 Jan 2017 02:23:30 GMT
Todd Lipcon 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:

DELETE <table_ref> FROM <table ref list> WHERE ..

DELETE t1 from todd_test t1 JOIN todd_test2 t2 ON t1.o_orderkey = t2.o_orderkey;

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:

DELETE c FROM my_second_table c, stock_symbols s WHERE = s.symbol;

(but it only deletes from one of the tables)

Can also use JOIN syntax as shown above
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

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