Peter Rozsa has posted comments on this change. ( http://gerrit.cloudera.org:8080/22576 )
Change subject: Add 4.5.0 changelog and docs ...................................................................... Patch Set 2: (2 comments) http://gerrit.cloudera.org:8080/#/c/22576/1/docs/build/asf-site-html/topics/impala_iceberg.html File docs/build/asf-site-html/topics/impala_iceberg.html: http://gerrit.cloudera.org:8080/#/c/22576/1/docs/build/asf-site-html/topics/impala_iceberg.html@526 PS1, Line 526: <article class="topic concept nested1" aria-labelledby="ariaid-title13" id="impala_iceberg__iceberg_merge"> : <h2 class="title topictitle2" id="ariaid-title13">Merging data into Iceberg tables</h2> : <div class="body conbody"> : <div class="p"> : Impala can execute MERGE statements against Iceberg tables, e.g: : <pre class="pre codeblock"><code> : MERGE INTO ice_t USING source ON ice_t.a = source.id WHEN NOT MATCHED THEN INSERT VALUES(id, source.column1); : MERGE INTO ice_t USING source ON ice_t.a = source.id WHEN MATCHED THEN DELETE; : MERGE INTO ice_t USING source ON ice_t.a = source.id WHEN MATCHED THEN UPDATE SET b = source.b; : MERGE INTO ice_t USING source ON ice_t.a = source.id : WHEN MATCHED AND ice_t.a < 100 THEN UPDATE SET b = source.b : WHEN MATCHED THEN DELETE : WHEN NOT MATCHED THEN INSERT VALUES(id, source.column1); : </code></pre> : </div> : <div class="p"> : The limitations of the <code class="ph codeph">UPDATE</code> statement also apply to the <code class="ph codeph">MERGE</code> statement; in addition, : the limitations of the <code class="ph codeph">MERGE</code> statement: : <ul class="ul"> : <li class="li">Subqueries in source statements must be simple queries as internal rewrite is not supported.</li> : </ul> : </div> : <p class="p"> : More information about the <code class="ph codeph">MERGE</code> statement can be found at <a class="xref" href="impala_merge.html">MERGE Statement</a>. : </p> : </div> : </article> : : <article class="topic concept nested1" aria-labelledby="ariaid-title14" id="impala_iceberg__iceberg_load"> > These changes should be reflected in the plain html files as well. Done http://gerrit.cloudera.org:8080/#/c/22576/1/docs/build/asf-site-html/topics/impala_string_functions.html File docs/build/asf-site-html/topics/impala_string_functions.html: http://gerrit.cloudera.org:8080/#/c/22576/1/docs/build/asf-site-html/topics/impala_string_functions.html@2163 PS1, Line 2163: TRIM-FROM syntax is a SQL-standardized wrapper around : <code class="ph codeph">LTRIM</code> / <code class="ph codeph">RTRIM</code> / <code class="ph codeph">BTRIM</code>. : Depending on the first parameter <code class="ph codeph">LEADING</code> / : <code class="ph codeph">TRAILING</code> / <code class="ph codeph">BOTH</code>, wrapper resolves itself to : the corresponding underlying function. Default value is <code class="ph codeph">BOTH</code>. : If present, the <code class="ph codeph">chars_to_trim</code> parameter is passed forward to : the underlying function. Thus, given syntax may come in three different forms: : </p> : : <p class="p"> : Syntax #1: <code class="ph codeph">TRIM(<where> FROM <string>)</code> --> : <code class="ph codeph">{L|R|B}TRIM(string)</code>; : </p> : : <p class="p"> : Syntax #2: <code class="ph codeph">TRIM(<charset> FROM <string>)</code> --> : <code class="ph codeph">BTRIM(string, charset)</code>; : </p> : : <p class="p"> : Syntax #3: <code class="ph codeph">TRIM(<where> <charset> FROM <string>)</code> : --><code class="ph codeph">{L|R|B}TRIM(string, charset)</code>. : </p> > Do you know why this change is not reflected in the plain html files? It looks like an older state was applied to my local copy, after a clean rebuild, the plain-html files are also updated -- To view, visit http://gerrit.cloudera.org:8080/22576 To unsubscribe, visit http://gerrit.cloudera.org:8080/settings Gerrit-Project: Impala-ASF Gerrit-Branch: asf-site Gerrit-MessageType: comment Gerrit-Change-Id: I07ec0a197de8a625788a3b0485d5ecf237e554ba Gerrit-Change-Number: 22576 Gerrit-PatchSet: 2 Gerrit-Owner: Peter Rozsa <[email protected]> Gerrit-Reviewer: Peter Rozsa <[email protected]> Gerrit-Reviewer: Zoltan Borok-Nagy <[email protected]> Gerrit-Comment-Date: Tue, 04 Mar 2025 15:33:11 +0000 Gerrit-HasComments: Yes
