Matthew Jacobs has posted comments on this change. Change subject: KUDU-1517 Implement doc feedback from Sue M ......................................................................
Patch Set 1: (1 comment) http://gerrit.cloudera.org:8080/#/c/3638/1/docs/index.adoc File docs/index.adoc: PS1, Line 79: FROM > I would say: you can specify complex joins with a FROM clause in a subquery For DELETE Impala supports the following syntax: DELETE [FROM] target_table_name where_clause and the where_clause is the same where_clause you'd have for a select stmt. You can have subqueries in there if you want, e.g. delete from kudutbl where id in ( select other_id from another_tbl ); you could have put a join in there if you want. For UPDATE you don't have the optional FROM keyword before target_table_name, but there is a FROM keyword before the source table(s). UPDATE target_table SET col_name = expr [, ... // more cols to set ] FROM source_table [, ... // more source tables ] WHERE expr [, ... // more predicates ] In there you should be able to put a subquery in the source tables. I suspect the confusion comes from the difference in where the FROM goes. Perhaps we should separate them out. -- To view, visit http://gerrit.cloudera.org:8080/3638 To unsubscribe, visit http://gerrit.cloudera.org:8080/settings Gerrit-MessageType: comment Gerrit-Change-Id: I8a7647b3e5d4d36e82e06ce02a45a8811e4efed3 Gerrit-PatchSet: 1 Gerrit-Project: kudu Gerrit-Branch: master Gerrit-Owner: Misty Stanley-Jones <[email protected]> Gerrit-Reviewer: Kudu Jenkins Gerrit-Reviewer: Matthew Jacobs <[email protected]> Gerrit-Reviewer: Mike Percy <[email protected]> Gerrit-Reviewer: Misty Stanley-Jones <[email protected]> Gerrit-HasComments: Yes
