This is an automated email from the ASF dual-hosted git repository.
dzamo pushed a commit to branch gh-pages
in repository https://gitbox.apache.org/repos/asf/drill.git
The following commit(s) were added to refs/heads/gh-pages by this push:
new 3396cd8 Document BIT_AND and BIT_OR bitwise logic aggregate functions.
3396cd8 is described below
commit 3396cd8f36b38e50a286f763a7c2123696acb9d8
Author: James Turton <[email protected]>
AuthorDate: Wed May 5 14:59:21 2021 +0200
Document BIT_AND and BIT_OR bitwise logic aggregate functions.
---
.../050-aggregate-and-aggregate-statistical.md | 37 +++++++++++++++++++---
1 file changed, 32 insertions(+), 5 deletions(-)
diff --git
a/_docs/sql-reference/sql-functions/050-aggregate-and-aggregate-statistical.md
b/_docs/sql-reference/sql-functions/050-aggregate-and-aggregate-statistical.md
index 05e683a..539e9f9 100644
---
a/_docs/sql-reference/sql-functions/050-aggregate-and-aggregate-statistical.md
+++
b/_docs/sql-reference/sql-functions/050-aggregate-and-aggregate-statistical.md
@@ -8,21 +8,23 @@ parent: "SQL Functions"
The following table lists the aggregate functions that you can use in Drill
queries.
+|-------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------|------------------------------------------------------------------------------------------------------------------------------------|
| **Function** | **Argument Type**
| **Return Type**
|
|-------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------|------------------------------------------------------------------------------------------------------------------------------------|
| ANY_VALUE(expression) | BIT, INT, BIGINT, FLOAT4,
FLOAT8, DATE, TIMESTAMP, TIME, VARCHAR, VARBINARY, LIST, MAP, INTERVAL,
INTERVALDAY, INTERVALYEAR, VARDECIMAL | Same as argument type
|
| AVG(expression) | SMALLINT, INTEGER, BIGINT,
FLOAT, DOUBLE, DECIMAL, INTERVAL
| DECIMAL for DECIMAL argument, DOUBLE for all
other arguments
|
| BOOL_AND(expression), BOOL_OR(expression) | BIT
| BIT
|
+| BIT_AND(expression), BIT_OR(expression) | INT, BIGINT
|
|
| COUNT(*) | -
| BIGINT
|
| COUNT([DISTINCT] expression) | any
| BIGINT
|
-| MAX(expression), MIN(expression) | BINARY, DECIMAL, VARCHAR, DATE,
TIME, or TIMESTAMP
| Same as argument type
|
-| SUM(expression) | SMALLINT, INTEGER, BIGINT,
FLOAT, DOUBLE, DECIMAL, INTERVAL
| DECIMAL for DECIMAL argument, BIGINT for any
integer-type argument (including BIGINT), DOUBLE for floating-point arguments
|
-
+| MAX(expression), MIN(expression) | BINARY, DECIMAL, VARCHAR, DATE,
TIME, or TIMESTAMP
| Same as argument type
|
+| SUM(expression) | SMALLINT, INTEGER, BIGINT,
FLOAT, DOUBLE, DECIMAL, INTERVAL
| DECIMAL for DECIMAL argument, BIGINT for
any integer-type argument (including BIGINT), DOUBLE for floating-point
arguments |
+|-------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------|------------------------------------------------------------------------------------------------------------------------------------|
- Drill 1.14 and later supports the ANY_VALUE function.
-- Starting in Drill 1.14, the DECIMAL data type is enabled by default.
-- AVG, COUNT, MIN, MAX, and SUM accept ALL and DISTINCT keywords. The default
is ALL.
+- Starting in Drill 1.14, the DECIMAL data type is enabled by default.
+- AVG, COUNT, MIN, MAX, and SUM accept ALL and DISTINCT keywords. The default
is ALL.
- The aggregate function examples use the `cp` storage plugin to access the
[`employee.json`]({{site.baseurl}}/docs/querying-json-files/) file installed
with Drill. By default, JSON reads numbers as double-precision floating point
numbers. These examples assume that you are using the default option
[all_text_mode]({{site.baseurl}}/docs/json-data-model/#handling-type-differences)
set to false.
## ANY_VALUE
@@ -175,6 +177,31 @@ Returns the result of a logical AND (resp. OR) over the
specified expression.
1. EVERY is nearly an alias for BOOL_AND but returns a TINYINT rather than a
BIT.
+## BIT_AND and BIT_OR
+Returns the result of a bitwise AND (resp. OR) over the specified expression.
+
+### BIT_AND and BIT_OR Syntax
+
+ BIT_AND(expression)
+ BIT_OR(expression)
+
+### BIT_AND and BIT_OR Examples
+
+ SELECT BIT_AND(position_id) FROM cp.`employee.json`;
+ |--------|
+ | EXPR$0 |
+ |--------|
+ | 0 |
+ |--------|
+
+ SELECT BIT_OR(position_id) FROM cp.`employee.json`;
+ |--------|
+ | EXPR$0 |
+ |--------|
+ | 31 |
+ |--------|
+
+
## COUNT
Returns the number of rows that match the given criteria.
