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
> Great that we support this feature. Thanks for the syntax details Matt.
Sure.

Here's a fancy example of an UPDATE:

 
[localhost:21000] > explain update default.managed_kudu set name = 
t1.string_col from managed_kudu inner join ( select id, string_col from 
functional.alltypestiny ) t1 where x = t1.id;
Query: explain update default.managed_kudu set name = t1.string_col from 
managed_kudu inner join ( select id, string_col from functional.alltypestiny ) 
t1 where x = t1.id
Query submitted at: 2016-08-15 16:20:42 (Coordinator: http://0.0.0.0:25000)
Query progress can be monitored at: 
http://0.0.0.0:25000/query_plan?query_id=56437d577087cd04:f6b43be2772bb7bf
+------------------------------------------------------------------------------------+
| Explain String                                                                
     |
+------------------------------------------------------------------------------------+
| Estimated Per-Host Requirements: Memory=2.03GB VCores=2                       
     |
| WARNING: The following tables are missing relevant table and/or column 
statistics. |
| default.managed_kudu                                                          
     |
|                                                                               
     |
| UPDATE KUDU [default.managed_kudu]                                            
     |
| |  check keys exist: false                                                    
     |
| |                                                                             
     |
| 02:HASH JOIN [INNER JOIN, BROADCAST]                                          
     |
| |  hash predicates: id = x                                                    
     |
| |  runtime filters: RF000 <- x                                                
     |
| |                                                                             
     |
| |--03:EXCHANGE [BROADCAST]                                                    
     |
| |  |                                                                          
     |
| |  00:SCAN KUDU [default.managed_kudu]                                        
     |
| |                                                                             
     |
| 01:SCAN HDFS [functional.alltypestiny]                                        
     |
|    partitions=4/4 files=4 size=460B                                           
     |
|    runtime filters: RF000 -> id                                               
     |
+------------------------------------------------------------------------------------+


-- 
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