This is an automated email from the ASF dual-hosted git repository.
gian pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/druid.git
The following commit(s) were added to refs/heads/master by this push:
new 7fea34abdda LOOKUP docs: clarify behavior of replaceMissingValueWith.
(#15879)
7fea34abdda is described below
commit 7fea34abdda047bd08dfcc9b87c67541ed8dbd00
Author: Gian Merlino <[email protected]>
AuthorDate: Sun Feb 11 13:11:00 2024 -0800
LOOKUP docs: clarify behavior of replaceMissingValueWith. (#15879)
Clarify behavior when expr is null.
---
docs/querying/sql-scalar.md | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/docs/querying/sql-scalar.md b/docs/querying/sql-scalar.md
index 8214d379321..d0bf351f666 100644
--- a/docs/querying/sql-scalar.md
+++ b/docs/querying/sql-scalar.md
@@ -102,7 +102,7 @@ String functions accept strings, and return a type
appropriate to the function.
|`CHAR_LENGTH(expr)`|Alias for `LENGTH`.|
|`CHARACTER_LENGTH(expr)`|Alias for `LENGTH`.|
|`STRLEN(expr)`|Alias for `LENGTH`.|
-|`LOOKUP(expr, lookupName, [replaceMissingValueWith])`|Look up `expr` in a
registered [query-time lookup table](lookups.md). Note that lookups can also be
queried directly using the [`lookup` schema](sql.md#from). Optional constant
`replaceMissingValueWith` can be passed as a third argument to be returned when
value is missing from lookup.|
+|`LOOKUP(expr, lookupName, [replaceMissingValueWith])`|Look up `expr` in a
registered [query-time lookup table](lookups.md) named `lookupName`. The
optional constant `replaceMissingValueWith`, if provided, is returned when the
`expr` is null or when the lookup does not contain a value for `expr`.<br /><br
/>Lookups can also be queried directly using the [`lookup`
schema](sql.md#from).|
|`LOWER(expr)`|Returns `expr` in all lowercase.|
|`UPPER(expr)`|Returns `expr` in all uppercase.|
|`LPAD(expr, length, [chars])`|Returns a string of `length` from `expr`
left-padded with `chars`. If `length` is shorter than the length of `expr`, the
result is `expr` which is truncated to `length`. The result will be null if
either `expr` or `chars` is null. If `chars` is an empty string, no padding is
added, however `expr` may be trimmed if necessary.|
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
