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 <mi...@apache.org>
Gerrit-Reviewer: Kudu Jenkins
Gerrit-Reviewer: Matthew Jacobs <m...@cloudera.com>
Gerrit-Reviewer: Mike Percy <mpe...@apache.org>
Gerrit-Reviewer: Misty Stanley-Jones <mi...@apache.org>
Gerrit-HasComments: Yes

Reply via email to