This is an automated email from the ASF dual-hosted git repository.
github-bot pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/arrow-datafusion.git
The following commit(s) were added to refs/heads/asf-site by this push:
new b39f184837 Publish built docs triggered by
2d114364457b5a0ba530ad265ac7618c5688fa8e
b39f184837 is described below
commit b39f184837d442542f038bb26272d63a7e435dc4
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Mon Sep 25 19:49:26 2023 +0000
Publish built docs triggered by 2d114364457b5a0ba530ad265ac7618c5688fa8e
---
_sources/user-guide/expressions.md.txt | 10 +++++-----
searchindex.js | 2 +-
user-guide/expressions.html | 2 +-
3 files changed, 7 insertions(+), 7 deletions(-)
diff --git a/_sources/user-guide/expressions.md.txt
b/_sources/user-guide/expressions.md.txt
index 6d4dea691b..dbd8c814b4 100644
--- a/_sources/user-guide/expressions.md.txt
+++ b/_sources/user-guide/expressions.md.txt
@@ -139,11 +139,11 @@ Unlike to some databases the math functions in Datafusion
works the same way as
## Conditional Expressions
-| Function | Notes
|
-| -------- |
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|
-| coalesce | Returns the first of its arguments that is not null. Null is
returned only if all arguments are null. It is often used to substitute a
default value for null values when data is retrieved for display. |
-| case | CASE expression. Example: `case(expr).when(expr, expr).when(expr,
expr).otherwise(expr).end()`.
|
-| nullif | Returns a null value if `value1` equals `value2`; otherwise it
returns `value1`. This can be used to perform the inverse operation of the
`coalesce` expression. |
+| Function | Notes
[...]
+| -------- |
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[...]
+| coalesce | Returns the first of its arguments that is not null. Null is
returned only if all arguments are null. It is often used to substitute a
default value for null values when data is retrieved for display.
[...]
+| case | CASE expression. The expression may chain multiple `when`
expressions and end with an `end` or `otherwise` expression. Example:</br>
<pre><code>case(col("a") % lit(3))</br> .when(lit(0),
lit("A"))</br> .when(lit(1),
lit("B"))</br> .when(lit(2),
lit("C"))</br> .end()</code></pre>or, end with
`otherwise` to match any other conditions:
<pre><code>case(col("b").gt(lit(100)))</br> &nb [...]
+| nullif | Returns a null value if `value1` equals `value2`; otherwise it
returns `value1`. This can be used to perform the inverse operation of the
`coalesce` expression.
[...]
## String Expressions
diff --git a/searchindex.js b/searchindex.js
index a35f89ac0e..07df441b04 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"docnames": ["contributor-guide/architecture",
"contributor-guide/communication", "contributor-guide/index",
"contributor-guide/quarterly_roadmap", "contributor-guide/roadmap",
"contributor-guide/specification/index",
"contributor-guide/specification/invariants",
"contributor-guide/specification/output-field-name-semantic", "index",
"library-user-guide/adding-udfs", "library-user-guide/building-logical-plans",
"library-user-guide/catalogs", "library-user-guide/custom-tab [...]
\ No newline at end of file
+Search.setIndex({"docnames": ["contributor-guide/architecture",
"contributor-guide/communication", "contributor-guide/index",
"contributor-guide/quarterly_roadmap", "contributor-guide/roadmap",
"contributor-guide/specification/index",
"contributor-guide/specification/invariants",
"contributor-guide/specification/output-field-name-semantic", "index",
"library-user-guide/adding-udfs", "library-user-guide/building-logical-plans",
"library-user-guide/catalogs", "library-user-guide/custom-tab [...]
\ No newline at end of file
diff --git a/user-guide/expressions.html b/user-guide/expressions.html
index 844b4dd262..1059d9d6d2 100644
--- a/user-guide/expressions.html
+++ b/user-guide/expressions.html
@@ -770,7 +770,7 @@ expressions such as <code class="docutils literal
notranslate"><span class="pre"
<td><p>Returns the first of its arguments that is not null. Null is returned
only if all arguments are null. It is often used to substitute a default value
for null values when data is retrieved for display.</p></td>
</tr>
<tr class="row-odd"><td><p>case</p></td>
-<td><p>CASE expression. Example: <code class="docutils literal
notranslate"><span class="pre">case(expr).when(expr,</span> <span
class="pre">expr).when(expr,</span> <span
class="pre">expr).otherwise(expr).end()</span></code>.</p></td>
+<td><p>CASE expression. The expression may chain multiple <code
class="docutils literal notranslate"><span class="pre">when</span></code>
expressions and end with an <code class="docutils literal notranslate"><span
class="pre">end</span></code> or <code class="docutils literal
notranslate"><span class="pre">otherwise</span></code> expression.
Example:</br> <pre><code>case(col(“a”) % lit(3))</br> .when(lit(0),
lit(“A”))</br> .when(lit(1), lit(“B”))</br> .when(lit(2), lit(“C”))</b
[...]
</tr>
<tr class="row-even"><td><p>nullif</p></td>
<td><p>Returns a null value if <code class="docutils literal
notranslate"><span class="pre">value1</span></code> equals <code
class="docutils literal notranslate"><span class="pre">value2</span></code>;
otherwise it returns <code class="docutils literal notranslate"><span
class="pre">value1</span></code>. This can be used to perform the inverse
operation of the <code class="docutils literal notranslate"><span
class="pre">coalesce</span></code> expression.</p></td>
