This is an automated email from the ASF dual-hosted git repository.

asf-gitbox-commits pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/hop-website.git


The following commit(s) were added to refs/heads/asf-site by this push:
     new a69e1944d3 Website updated to 5fba80f
a69e1944d3 is described below

commit a69e1944d39adff30f12c05e8eb07c1336d8e096
Author: jenkins <[email protected]>
AuthorDate: Fri Sep 25 13:10:33 2026 +0000

    Website updated to 5fba80f
---
 manual/next/pipeline/transforms/jsoninput.html | 21 ++++++++
 manual/next/workflow/actions/dbt.html          | 69 +++++++++++++++++++++++---
 2 files changed, 82 insertions(+), 8 deletions(-)

diff --git a/manual/next/pipeline/transforms/jsoninput.html 
b/manual/next/pipeline/transforms/jsoninput.html
index 83c0e9e637..38fdc615fe 100644
--- a/manual/next/pipeline/transforms/jsoninput.html
+++ b/manual/next/pipeline/transforms/jsoninput.html
@@ -3358,6 +3358,27 @@ See <a href="../formatting-values.html" class="xref 
page">Formatting numbers and
 <div class="paragraph">
 <p><strong>Example Path to filter on those that start with the letter 
'a':</strong> $.data[?(@=~/a.*/i)]</p>
 </div>
+<div class="paragraph">
+<p><strong>JsonPath functions</strong></p>
+</div>
+<div class="paragraph">
+<p>The aggregation functions provided by JayWay can be used at the end of a 
Path expression, e.g. <code>length()</code> (or its alias <code>size()</code>), 
<code>sum()</code>, <code>avg()</code>, <code>min()</code>, <code>max()</code>, 
<code>stddev()</code>, <code>keys()</code>, <code>first()</code>, 
<code>last()</code> and <code>index()</code>.</p>
+</div>
+<div class="paragraph">
+<p><strong>Example Path to retrieve the number of elements of an 
array:</strong> $.someArray.length()</p>
+</div>
+<div class="paragraph">
+<p>A function is applied to the value the Path points to. When the Path points 
to a single value, the function produces a single value and therefore a single 
output row, even when that value is itself a list, as with 
<code>keys()</code>.</p>
+</div>
+<div class="paragraph">
+<p>When the Path contains a wildcard before the function, the function is 
applied to every match and produces one row per match. For example, 
<code>$.orders[<strong>].lines.length()</code> returns the number of lines of 
each order. To aggregate over all matches instead, use a deep scan or pass the 
Path as a parameter to the function: <code>$..price.sum()</code> or 
<code>$.sum($.orders[</strong>].price)</code>. Note that 
<code>$.orders[*].price.sum()</code> does not work: the sum is appli [...]
+</div>
+<div class="paragraph">
+<p>Combining a single-value function field with a field whose Path matches 
several elements is not supported: the transform reports a structure error 
because the two Paths do not yield the same number of rows. Read such a value 
in a dedicated JSON Input transform when the other fields return multiple 
rows.</p>
+</div>
+<div class="paragraph">
+<p>When a function cannot be evaluated, for example <code>sum()</code> or 
<code>first()</code> on an empty array, the value is treated as missing: it is 
empty when <strong>Ignore missing path</strong> is enabled, otherwise the 
transform fails with the reason.</p>
+</div>
 </div>
 <div class="sect2">
 <h3 id="_additional_output_fields_tab"><a class="link" 
href="#_additional_output_fields_tab">Additional output fields tab</a></h3>
diff --git a/manual/next/workflow/actions/dbt.html 
b/manual/next/workflow/actions/dbt.html
index d8f427eb25..d439760a15 100644
--- a/manual/next/workflow/actions/dbt.html
+++ b/manual/next/workflow/actions/dbt.html
@@ -2833,6 +2833,11 @@
 <div class="sect1">
 <h2 id="_options"><a class="link" href="#_options">Options</a></h2>
 <div class="sectionbody">
+<div class="paragraph">
+<p>The options are organized on four tabs. The action name is above them and 
applies to all of them.</p>
+</div>
+<div class="sect2">
+<h3 id="_dbt_project"><a class="link" href="#_dbt_project">dbt project</a></h3>
 <table class="tableblock frame-all grid-all" style="width: 90%;">
 <colgroup>
 <col style="width: 25%;">
@@ -2846,10 +2851,6 @@
 </thead>
 <tbody>
 <tr>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Action 
name</p></td>
-<td class="tableblock halign-left valign-top"><p class="tableblock">The name 
of the workflow action.</p></td>
-</tr>
-<tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">dbt 
project</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">The <a 
href="../../metadata-types/dbt-project.html" class="xref page">dbt Project</a> 
metadata object to run against.</p></td>
 </tr>
@@ -2861,6 +2862,23 @@
 <td class="tableblock halign-left valign-top"><p 
class="tableblock">Target</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">The dbt 
target (<code>--target</code>). Overrides the default target of the dbt project 
when set.</p></td>
 </tr>
+</tbody>
+</table>
+</div>
+<div class="sect2">
+<h3 id="_selection"><a class="link" href="#_selection">Selection</a></h3>
+<table class="tableblock frame-all grid-all" style="width: 90%;">
+<colgroup>
+<col style="width: 25%;">
+<col style="width: 75%;">
+</colgroup>
+<thead>
+<tr>
+<th class="tableblock halign-left valign-top">Option</th>
+<th class="tableblock halign-left valign-top">Description</th>
+</tr>
+</thead>
+<tbody>
 <tr>
 <td class="tableblock halign-left valign-top"><p 
class="tableblock">--select</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Passed to 
dbt as <code>--select</code>, using dbt&#8217;s node selection syntax. Several 
selectors can be given in one value, separated by spaces.</p></td>
@@ -2870,6 +2888,27 @@
 <td class="tableblock halign-left valign-top"><p class="tableblock">Passed to 
dbt as <code>--exclude</code>.</p></td>
 </tr>
 <tr>
+<td class="tableblock halign-left valign-top"><p 
class="tableblock">--full-refresh</p></td>
+<td class="tableblock halign-left valign-top"><p class="tableblock">Passed to 
dbt as <code>--full-refresh</code>. dbt only accepts the flag for 
<code>run</code>, <code>build</code> and <code>seed</code>, so it is left out 
for the other operations.</p></td>
+</tr>
+</tbody>
+</table>
+</div>
+<div class="sect2">
+<h3 id="_execution"><a class="link" href="#_execution">Execution</a></h3>
+<table class="tableblock frame-all grid-all" style="width: 90%;">
+<colgroup>
+<col style="width: 25%;">
+<col style="width: 75%;">
+</colgroup>
+<thead>
+<tr>
+<th class="tableblock halign-left valign-top">Option</th>
+<th class="tableblock halign-left valign-top">Description</th>
+</tr>
+</thead>
+<tbody>
+<tr>
 <td class="tableblock halign-left valign-top"><p 
class="tableblock">--threads</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Passed to 
dbt as <code>--threads</code>. Left empty, dbt uses the thread count from 
<code>profiles.yml</code>.</p></td>
 </tr>
@@ -2878,13 +2917,26 @@
 <td class="tableblock halign-left valign-top"><p class="tableblock">Wall-clock 
limit for the dbt run. When it is reached, dbt and the processes it started are 
stopped and the action fails. Empty or <code>0</code> waits for dbt however 
long it takes.</p></td>
 </tr>
 <tr>
-<td class="tableblock halign-left valign-top"><p 
class="tableblock">--full-refresh</p></td>
-<td class="tableblock halign-left valign-top"><p class="tableblock">Passed to 
dbt as <code>--full-refresh</code>. dbt only accepts the flag for 
<code>run</code>, <code>build</code> and <code>seed</code>, so it is left out 
for the other operations.</p></td>
-</tr>
-<tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Emit 
OpenLineage</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Run dbt 
through <code>dbt-ol</code> and point it at the collector Hop&#8217;s own 
lineage sink uses. See <a href="#_lineage">Lineage</a>.</p></td>
 </tr>
+</tbody>
+</table>
+</div>
+<div class="sect2">
+<h3 id="_variables"><a class="link" href="#_variables">Variables</a></h3>
+<table class="tableblock frame-all grid-all" style="width: 90%;">
+<colgroup>
+<col style="width: 25%;">
+<col style="width: 75%;">
+</colgroup>
+<thead>
+<tr>
+<th class="tableblock halign-left valign-top">Option</th>
+<th class="tableblock halign-left valign-top">Description</th>
+</tr>
+</thead>
+<tbody>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Variables 
(--vars)</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Name/value 
pairs passed to dbt as <code>--vars</code>. See <a href="#_dbt_variables">dbt 
variables</a>.</p></td>
@@ -2897,6 +2949,7 @@
 </table>
 </div>
 </div>
+</div>
 <div class="sect1">
 <h2 id="_dbt_variables"><a class="link" href="#_dbt_variables">dbt 
variables</a></h2>
 <div class="sectionbody">

Reply via email to