This is an automated email from the ASF dual-hosted git repository.
xxyu pushed a commit to branch doc5.0
in repository https://gitbox.apache.org/repos/asf/kylin.git
commit abaac71bbfeb43b9af42ed291f8a4c9c6c437f9c
Author: Mukvin <boyboys...@163.com>
AuthorDate: Tue Sep 13 17:36:29 2022 +0800
KYLIN-5265 add doc for operators and functions in query
---
website/docs/configuration/configuration.md | 4 +-
website/docs/configuration/hadoop_queue_config.md | 4 +-
website/docs/datasource/data_sampling.md | 6 +-
.../on-premises/deploy_mode/cluster_deployment.md | 4 +-
.../on-premises/installation/install_validation.md | 4 +-
.../docs/deployment/on-premises/prerequisite.md | 4 +-
.../rdbms_metastore/mysql/install_mysql.md | 4 +-
.../postgresql/install_postgresql.md | 4 +-
.../rdbms_metastore/query_history_fields.md | 67 ++++++++++++++
website/docs/modeling/data_modeling.md | 4 +-
website/docs/modeling/model_concepts_operations.md | 4 +-
.../model_design/advance_guide/fast_bitmap.md | 4 +-
.../model_design/advance_guide/integer_encoding.md | 4 +-
.../modeling/model_design/advance_guide/intro.md | 4 +-
.../advance_guide/model_metadata_managment.md | 4 +-
.../advance_guide/multilevel_partitioning.md | 4 +-
.../modeling/model_design/aggregation_group.md | 6 +-
.../docs/modeling/model_design/computed_column.md | 6 +-
website/docs/modeling/model_design/intro.md | 4 +-
.../model_design/measure_design/collect_set.md | 4 +-
.../modeling/model_design/measure_design/corr.md | 4 +-
.../system-operation/maintenance_mode.md | 2 +-
..._list_tables.en.png => insight_list_tables.png} | Bin
website/docs/query/insight/insight.md | 2 +-
.../function/arithmetic_function.md | 2 +-
.../operator_function/function/bitmap_function.md | 34 +++----
.../function/datetime_function.md | 2 -
.../function/grouping_function.md | 6 +-
...tic_function.en.png => arithmetic_function.png} | Bin
.../function/images/bitmap_uuid.1.en.png | Bin 76211 -> 0 bytes
.../function/images/bitmap_uuid.1.png | Bin 0 -> 52060 bytes
.../function/images/date_string.png | Bin 16860 -> 0 bytes
.../function/images/first_last_value.png | Bin 0 -> 98094 bytes
.../function/images/first_last_value_en.png | Bin 355492 -> 0 bytes
.../operator_function/function/images/grouping.png | Bin 0 -> 79187 bytes
.../function/images/grouping_en.png | Bin 273305 -> 0 bytes
.../function/images/grouping_sets.1.png | Bin 11933 -> 0 bytes
.../function/images/grouping_sets.2.png | Bin 11140 -> 0 bytes
.../function/images/grouping_sets_function.png | Bin 0 -> 72071 bytes
.../function/images/grouping_sets_function_en.png | Bin 304051 -> 0 bytes
.../function/images/intersect_bitmap_uuid.1.en.png | Bin 79531 -> 0 bytes
.../function/images/intersect_bitmap_uuid.1.png | Bin 0 -> 54730 bytes
.../images/intersect_bitmap_uuid2.1.en.png | Bin 81244 -> 0 bytes
.../function/images/intersect_bitmap_uuid2.1.png | Bin 141068 -> 56125 bytes
.../function/images/intersect_count.1.en.png | Bin 140322 -> 0 bytes
.../function/images/intersect_count.1.png | Bin 0 -> 103495 bytes
.../function/images/intersect_count.2.en.png | Bin 78565 -> 0 bytes
.../function/images/intersect_count.2.png | Bin 0 -> 56203 bytes
.../function/images/intersect_count2.1.en.png | Bin 85828 -> 0 bytes
.../function/images/intersect_count2.1.png | Bin 0 -> 53468 bytes
.../images/intersect_count_by_col.1.en.png | Bin 97364 -> 0 bytes
.../function/images/intersect_count_by_col.1.png | Bin 0 -> 66295 bytes
.../function/images/intersect_value.1.en.png | Bin 154131 -> 0 bytes
.../function/images/intersect_value.1.png | Bin 0 -> 116300 bytes
.../function/images/intersect_value.2.en.png | Bin 83196 -> 0 bytes
.../function/images/intersect_value.2.png | Bin 0 -> 55034 bytes
.../function/images/intersect_value2.1.en.png | Bin 83837 -> 0 bytes
.../function/images/intersect_value2.1.png | Bin 0 -> 53146 bytes
.../operator_function/function/images/lead_lag.png | Bin 0 -> 85270 bytes
.../function/images/lead_lag_en.png | Bin 300367 -> 0 bytes
.../operator_function/function/images/ntile.png | Bin 0 -> 77099 bytes
.../operator_function/function/images/ntile_en.png | Bin 283175 -> 0 bytes
.../operator_function/function/images/operator.png | Bin 24501 -> 0 bytes
.../function/images/rank_and_drank.png | Bin 0 -> 83000 bytes
.../function/images/rank_and_drank_en.png | Bin 118075 -> 0 bytes
.../function/images/rollup_function.png | Bin 0 -> 71960 bytes
.../function/images/rollup_function_en.png | Bin 241884 -> 0 bytes
.../images/{row_number_en.png => row_number.png} | Bin
.../function/images/timestamp_string.png | Bin 19170 -> 0 bytes
.../function/intersect_function.md | 80 ++++++++---------
.../operator_function/function/string_function.md | 4 +-
.../operator_function/function/type_function.md | 2 -
.../operator_function/function/window_function.md | 12 ++-
.../insight/operator_function/operator/intro.md | 4 -
.../operator_function/operator/logical_operator.md | 3 -
.../operator_function/operator/string_operator.md | 2 -
website/docs/quickstart/expert_mode_tutorial.md | 4 +-
website/docs/quickstart/intro.md | 4 +-
website/docs/quickstart/quick_start.md | 4 +-
website/docs/quickstart/sample_dataset.md | 2 +-
.../restapi/image/{job_api_en.png => job_api.png} | Bin
website/docs/restapi/image/metrics_store_en.png | Bin 245660 -> 0 bytes
website/docs/restapi/image/work_follow_en.png | Bin 50463 -> 0 bytes
website/docs/restapi/job_api.md | 2 +-
website/sidebars.js | 98 +++++++++++++++++++++
85 files changed, 286 insertions(+), 136 deletions(-)
diff --git a/website/docs/configuration/configuration.md
b/website/docs/configuration/configuration.md
index edd2b53567..76d32d294f 100644
--- a/website/docs/configuration/configuration.md
+++ b/website/docs/configuration/configuration.md
@@ -9,9 +9,9 @@ pagination_prev: null
pagination_next: null
keywords:
- Basic Configuration
-draft: true
+draft: false
last_update:
- date: 08/16/2022
+ date: 09/13/2022
---
This chapter will introduce some common configurations, the main contents are
as follows:
diff --git a/website/docs/configuration/hadoop_queue_config.md
b/website/docs/configuration/hadoop_queue_config.md
index 13284780e3..0e5ad811d3 100644
--- a/website/docs/configuration/hadoop_queue_config.md
+++ b/website/docs/configuration/hadoop_queue_config.md
@@ -9,9 +9,9 @@ pagination_prev: null
pagination_next: null
keywords:
- hadoop queue configuration
-draft: true
+draft: false
last_update:
- date: 08/16/2022
+ date: 09/13/2022
---
In the case of a multiple-tenants environment, to securely share a large
cluster, each tenant needs to have the allocated resources in a timely manner
under the constraints of the allocated capacities. To achieve computing
resources allocation and separation, each Kylin instance or project can be
configured to use a different YARN queue.
diff --git a/website/docs/datasource/data_sampling.md
b/website/docs/datasource/data_sampling.md
index 1223190fb6..baafeff66d 100644
--- a/website/docs/datasource/data_sampling.md
+++ b/website/docs/datasource/data_sampling.md
@@ -56,11 +56,11 @@ Kylin supports data sampling during data loading. If you
want to manually sample
Question: Why are the Chinese comments garbled in the sampled results?
-Answer: This issue is often caused by improper encoding settings. Please
confirm whether any Chinese comments in the source Hive table are garbled via
the Hive client. If yes, please modify the encoding in MySQL metabase. Below we
use [CDH](../../installation/install_uninstall/install_on_cdh.en.md) platform
as an example to show how to modify encoding:
+Answer: This issue is often caused by improper encoding settings. Please
confirm whether any Chinese comments in the source Hive table are garbled via
the Hive client. If yes, please modify the encoding in MySQL metabase. Below we
use [Apache
Hadoop](../deployment/on-premises/installation/platform/install_on_apache_hadoop.md)
platform as an example to show how to modify encoding:
-1. Log in to the CDH server.
+1. Log in to the server.
2. Run the `mysql -uroot -p` command and enter your password.
-3. Run the `use metastore``;` command to enter the Metastore database.
+3. Run the `use metastore;` command to enter the Metastore database.
4. Modify the encoding of the following columns to utf8:
- Column COMMENT in COLUMNS_V2
- Column PARAM_VALUE in TABLE_PARAMS
diff --git
a/website/docs/deployment/on-premises/deploy_mode/cluster_deployment.md
b/website/docs/deployment/on-premises/deploy_mode/cluster_deployment.md
index 560aae9f97..4bdcb8fb71 100644
--- a/website/docs/deployment/on-premises/deploy_mode/cluster_deployment.md
+++ b/website/docs/deployment/on-premises/deploy_mode/cluster_deployment.md
@@ -10,9 +10,9 @@ pagination_next: null
keywords:
- cluster deployment
- cluster
-draft: true
+draft: false
last_update:
- date: 08/12/2022
+ date: 09/13/2022
---
All Kylin state information instance is stored in a RDBMS database, so running
Kylin on multiple nodes in a cluster is good practice for better load balance
and higher availability. Currently, we only support deployment with one `all`
node and multiple `query` nodes.
diff --git
a/website/docs/deployment/on-premises/installation/install_validation.md
b/website/docs/deployment/on-premises/installation/install_validation.md
index c2ad50844a..b7cb0ff4ac 100644
--- a/website/docs/deployment/on-premises/installation/install_validation.md
+++ b/website/docs/deployment/on-premises/installation/install_validation.md
@@ -10,9 +10,9 @@ pagination_next: null
keywords:
- install
- validation
-draft: true
+draft: false
last_update:
- date: 08/12/2022
+ date: 09/13/2022
---
Kylin uses the open source **SSB** (Star Schema Benchmark) dataset for star
schema OLAP scenarios as a test dataset. You can verify whether the
installation is successful by running a script to import the SSB dataset into
Hive. The SSB dataset is from multiple CSV files.
diff --git a/website/docs/deployment/on-premises/prerequisite.md
b/website/docs/deployment/on-premises/prerequisite.md
index 4b3c7981a9..45f4dae62f 100644
--- a/website/docs/deployment/on-premises/prerequisite.md
+++ b/website/docs/deployment/on-premises/prerequisite.md
@@ -9,9 +9,9 @@ pagination_prev: intro
pagination_next: null
keywords:
- prerequisite
-draft: true
+draft: false
last_update:
- date: 08/11/2022
+ date: 09/13/2022
---
To ensure system performance and stability, we recommend you run Kylin on a
dedicated Hadoop cluster.
diff --git
a/website/docs/deployment/on-premises/rdbms_metastore/mysql/install_mysql.md
b/website/docs/deployment/on-premises/rdbms_metastore/mysql/install_mysql.md
index e9206ffc48..2fdcfe0b4e 100644
--- a/website/docs/deployment/on-premises/rdbms_metastore/mysql/install_mysql.md
+++ b/website/docs/deployment/on-premises/rdbms_metastore/mysql/install_mysql.md
@@ -11,9 +11,9 @@ keywords:
- mysql
- install mysql
- install
-draft: true
+draft: false
last_update:
- date: 08/11/2022
+ date: 09/13/2022
---
### Prerequisite
diff --git
a/website/docs/deployment/on-premises/rdbms_metastore/postgresql/install_postgresql.md
b/website/docs/deployment/on-premises/rdbms_metastore/postgresql/install_postgresql.md
index 3030bf0370..0edaf1575d 100644
---
a/website/docs/deployment/on-premises/rdbms_metastore/postgresql/install_postgresql.md
+++
b/website/docs/deployment/on-premises/rdbms_metastore/postgresql/install_postgresql.md
@@ -9,9 +9,9 @@ pagination_prev: null
pagination_next: null
keywords:
- mysql
-draft: true
+draft: false
last_update:
- date: 08/11/2022
+ date: 09/13/2022
---
### <span id="preparation">Prerequisite</span>
diff --git
a/website/docs/deployment/on-premises/rdbms_metastore/query_history_fields.md
b/website/docs/deployment/on-premises/rdbms_metastore/query_history_fields.md
new file mode 100644
index 0000000000..260c602a07
--- /dev/null
+++
b/website/docs/deployment/on-premises/rdbms_metastore/query_history_fields.md
@@ -0,0 +1,67 @@
+---
+title: Query History Field Table
+language: en
+sidebar_label: Query History Field Table
+pagination_label: Query History Field Table
+toc_min_heading_level: 2
+toc_max_heading_level: 6
+pagination_prev: null
+pagination_next: null
+keywords:
+ - query history field table
+draft: false
+last_update:
+ date: 09/13/2022
+---
+
+Starting with Kylin 5.0, the system uses RDBMS to store query history. And
each metadata will store two tables related to query history:
+
+- *query_history* : information for each query
+- *query_history_realization* : each index that hit by query
+
+### ***query_history*** table
+
+| Field Name | Description
|
+| ---------------------- |
------------------------------------------------------------ |
+| id | auto increment primary key
|
+| cache_hit | whether the query hits the cache
|
+| duration | duration of query execution
|
+| engine_type | four query objects, the blue name indicates the
query hits model (index group), *HIVE* indicates that the query is pushed down
to Hive, *CONSTANTS* indicates the query constant, and the blank indicates that
the query failed. |
+| error_type | error message when error occurs during query
execution |
+| server | if hostname exists, use hostname of query node,
otherwise use IP address of query node |
+| index_hit | whether the query hits index or not
|
+| is_agg_index_used | whether the query hits the aggregate index or not
|
+| is_table_index_used | whether the query hits table index or not
|
+| is_table_snapshot_used | whether the query hits the dimension table
|
+| month | the month in which the query is submitted, which is
needed to count the history of the query by month. |
+| query_first_day_of_month | the initial time of the month in which the query
time is located. This field is required when statistically querying the history
by month |
+| query_first_day_of_week | the initial time of the week in which the query
time is located. This field is required when statistically querying the history
by month |
+| query_day | the initial time of the day in which the query
time is located. This field is required when statistically querying the history
by month |
+| query_id | query identity
|
+| query_status | two query statuses, *SUCCEEDED* indicates that the
query was successful, *FAILED* indicates that the query was abnormal |
+| query_time | query start time
|
+| realizations | a string concatenated by the model ID number,
Layout ID number, and index type，which format is *modelId#layoutId#indexType* |
+| result_row_count | number of query results
|
+| sql_text | SQL statement that was submitted
|
+| sql_pattern | the sql pattern of SQL statement that was submitted
. This field is needed when sql is accelerated. |
+| submitter | Kyligence Enterprise user who submits the query
|
+| total_scan_bytes | total scanned lines of the query
|
+| total_scan_count | total scanned bytes of the query
|
+| project_name | project name
|
+| reserved_field_1 | reserved field, currently unused
|
+| reserved_field_2 | reserved field, currently unused
|
+| reserved_field_3 | Starting from 4.2, this field is used to record the
reason why the index cannot be recommended
|
+| reserved_field_4 | reserved field, currently unused
|
+
+### ***query_history_realization*** table
+
+| Field Name | Description |
+| ---------- | ------------------------------------------------------------ |
+| query_time | unix timestamp of query start time (when query start to
execute) |
+| duration | duration of query execution |
+| index_type | three index types, *Table Index* for table index, *Agg Index*
for aggregate index, and *Table Snapshot* for dimension table |
+| layout_id | ID of layout |
+| model | ID of model |
+| query_id | ID of query |
+| project_name | Project name |
+
diff --git a/website/docs/modeling/data_modeling.md
b/website/docs/modeling/data_modeling.md
index e2afa8eeb3..955c0368fe 100755
--- a/website/docs/modeling/data_modeling.md
+++ b/website/docs/modeling/data_modeling.md
@@ -9,9 +9,9 @@ pagination_prev: null
pagination_next: null
keywords:
- model design overview
-draft: true
+draft: false
last_update:
- date: 08/17/2022
+ date: 09/13/2022
---
Kylin model consists of multiple tables and their join relations. Kylin
follows multidimensional modeling theory to build star or snowflake schemas
based on tables. Kylin also leverages pre-computation technique and will reuse
the pre-computed results to answer queries, so there's no need to traverse all
data when there is a query, thus achieving sub-second query times on PB-level
data.
diff --git a/website/docs/modeling/model_concepts_operations.md
b/website/docs/modeling/model_concepts_operations.md
index e96a2ec584..39e99f115c 100644
--- a/website/docs/modeling/model_concepts_operations.md
+++ b/website/docs/modeling/model_concepts_operations.md
@@ -10,9 +10,9 @@ pagination_next: null
keywords:
- model concepts
- model operations
-draft: true
+draft: false
last_update:
- date: 08/19/2022
+ date: 09/13/2022
---
diff --git a/website/docs/modeling/model_design/advance_guide/fast_bitmap.md
b/website/docs/modeling/model_design/advance_guide/fast_bitmap.md
index b7a66b8162..6d9ccf7075 100644
--- a/website/docs/modeling/model_design/advance_guide/fast_bitmap.md
+++ b/website/docs/modeling/model_design/advance_guide/fast_bitmap.md
@@ -9,9 +9,9 @@ pagination_prev: null
pagination_next: null
keywords:
- query optimization for exact hit index
-draft: true
+draft: false
last_update:
- date: 08/19/2022
+ date: 09/13/2022
---
Since Kylin 5, the system has enhanced the optimization of queries that hit
the index exactly (the query contains dimensions that are exactly the same as
the dimensions of the selected index), and it also improves the performance in
count distinct scenario.
diff --git
a/website/docs/modeling/model_design/advance_guide/integer_encoding.md
b/website/docs/modeling/model_design/advance_guide/integer_encoding.md
index 9f783e6f28..d7dfbbdb79 100644
--- a/website/docs/modeling/model_design/advance_guide/integer_encoding.md
+++ b/website/docs/modeling/model_design/advance_guide/integer_encoding.md
@@ -9,9 +9,9 @@ pagination_prev: null
pagination_next: null
keywords:
- skip dictionary encoding optimization for integer type
-draft: true
+draft: false
last_update:
- date: 08/19/2022
+ date: 09/13/2022
---
Starting from Kylin 5, the system supports no dictionary encoding for integer
types
diff --git a/website/docs/modeling/model_design/advance_guide/intro.md
b/website/docs/modeling/model_design/advance_guide/intro.md
index a3db8e4a75..f0db643d96 100644
--- a/website/docs/modeling/model_design/advance_guide/intro.md
+++ b/website/docs/modeling/model_design/advance_guide/intro.md
@@ -9,9 +9,9 @@ pagination_prev: null
pagination_next: null
keywords:
- model advanced settings
-draft: true
+draft: false
last_update:
- date: 08/19/2022
+ date: 09/13/2022
---
This section describes the advanced settings applied to the model.
diff --git
a/website/docs/modeling/model_design/advance_guide/model_metadata_managment.md
b/website/docs/modeling/model_design/advance_guide/model_metadata_managment.md
index 21cf8d336c..a634c924b2 100644
---
a/website/docs/modeling/model_design/advance_guide/model_metadata_managment.md
+++
b/website/docs/modeling/model_design/advance_guide/model_metadata_managment.md
@@ -9,9 +9,9 @@ pagination_prev: null
pagination_next: null
keywords:
- model metadata management
-draft: true
+draft: false
last_update:
- date: 08/19/2022
+ date: 09/13/2022
---
diff --git
a/website/docs/modeling/model_design/advance_guide/multilevel_partitioning.md
b/website/docs/modeling/model_design/advance_guide/multilevel_partitioning.md
index efce545672..56d9716c20 100644
---
a/website/docs/modeling/model_design/advance_guide/multilevel_partitioning.md
+++
b/website/docs/modeling/model_design/advance_guide/multilevel_partitioning.md
@@ -9,9 +9,9 @@ pagination_prev: null
pagination_next: null
keywords:
- multi-level partitioning (beta)
-draft: true
+draft: false
last_update:
- date: 08/19/2022
+ date: 09/13/2022
---
diff --git a/website/docs/modeling/model_design/aggregation_group.md
b/website/docs/modeling/model_design/aggregation_group.md
index e3a09b5f49..72652281d8 100644
--- a/website/docs/modeling/model_design/aggregation_group.md
+++ b/website/docs/modeling/model_design/aggregation_group.md
@@ -9,9 +9,9 @@ pagination_prev: null
pagination_next: null
keywords:
- aggregate index
-draft: true
+draft: false
last_update:
- date: 08/19/2022
+ date: 09/13/2022
---
@@ -291,7 +291,7 @@ We'll introduce how to set Max Dimension Combination (MDC)
in this section. Clic
> **Note**: The setting of MDC will not take effect until you submit the Edit
> Aggregate Index page.
-
+
Aggregate index-level MDC affects all aggregate groups. Aggregate group-level
MDC takes effect only for a single aggregate group. The priority of the
aggregate group-level level MDC is higher than that of aggregate index-level
MDC. The specific setting rules are as follows:
diff --git a/website/docs/modeling/model_design/computed_column.md
b/website/docs/modeling/model_design/computed_column.md
index 977c121cf8..df57713efc 100644
--- a/website/docs/modeling/model_design/computed_column.md
+++ b/website/docs/modeling/model_design/computed_column.md
@@ -9,9 +9,9 @@ pagination_prev: null
pagination_next: null
keywords:
- computed column
-draft: true
+draft: false
last_update:
- date: 08/19/2022
+ date: 09/13/2022
---
@@ -57,7 +57,7 @@ This section will describe the supported computed columns in
Kylin, which includ
- Unexpected errors may occur when the computed column share the same name
with other columns.
- Aggregate functions such as `SUM`, `MIN`, `MAX`, etc. are not allowed when
defining the computed column expression.
- Expression only containing constants is not recommended to create computed
column, such as `POWER(CAST(2 AS DOUBLE), 2)`.
- - If a function expression contains a column using the keywords as column
name, it cannot be recommended as a computed column. For more details about
keywords, please refer the **Keywords** section in [SQL
Specification](../../../query/insight/sql_spec.en.md).
+ - If a function expression contains a column using the keywords as column
name, it cannot be recommended as a computed column. For more details about
keywords, please refer the **Keywords** section in [SQL
Specification](../../query/insight/sql_spec.md).
- Computed columns only support `Hive` data source in current version.
- Computed columns cannot be used as time partition columns and join keys.
- If a function expression contains a table name or column name that is not
started with letters or includes special characters, need to double quote this
name. For example: `"100_KYLIN_SALES"."100_PRICE" *
"100_KYLIN_SALES"."200_ITEM_COUNT"`
diff --git a/website/docs/modeling/model_design/intro.md
b/website/docs/modeling/model_design/intro.md
index ca8e595b7c..9c94754b8d 100644
--- a/website/docs/modeling/model_design/intro.md
+++ b/website/docs/modeling/model_design/intro.md
@@ -9,9 +9,9 @@ pagination_prev: null
pagination_next: null
keywords:
- advanced model design
-draft: true
+draft: false
last_update:
- date: 08/19/2022
+ date: 09/13/2022
---
In this chapter, we take the Kylin built-in dataset as an example, to show you
how to design a data model.
diff --git a/website/docs/modeling/model_design/measure_design/collect_set.md
b/website/docs/modeling/model_design/measure_design/collect_set.md
index 7065e31e23..bda2897bfd 100644
--- a/website/docs/modeling/model_design/measure_design/collect_set.md
+++ b/website/docs/modeling/model_design/measure_design/collect_set.md
@@ -9,9 +9,9 @@ pagination_prev: null
pagination_next: null
keywords:
- collect_set
-draft: true
+draft: false
last_update:
- date: 08/19/2022
+ date: 09/13/2022
---
diff --git a/website/docs/modeling/model_design/measure_design/corr.md
b/website/docs/modeling/model_design/measure_design/corr.md
index 9b7abc6183..4f2bc0f844 100644
--- a/website/docs/modeling/model_design/measure_design/corr.md
+++ b/website/docs/modeling/model_design/measure_design/corr.md
@@ -9,9 +9,9 @@ pagination_prev: null
pagination_next: null
keywords:
- corr
-draft: true
+draft: false
last_update:
- date: 08/19/2022
+ date: 09/13/2022
---
Correlation coefficient is used in statics to measure how strong a
relationship is between two variables. The Correlation coefficient is using
Pearson correlation underneath.
diff --git a/website/docs/operations/system-operation/maintenance_mode.md
b/website/docs/operations/system-operation/maintenance_mode.md
index 1765bb97d9..1fd1491fb6 100644
--- a/website/docs/operations/system-operation/maintenance_mode.md
+++ b/website/docs/operations/system-operation/maintenance_mode.md
@@ -73,4 +73,4 @@ When running the following commands, the system will
automatically turn on the m
- [reset admin password](../access-control/user_management.md)
- [junk file clean](junk_file_clean.md)
- - [metadata
restore](cli_tool/metadata_tool/metadata_backup_restore.en.md#metadata-restore----metadata_restore)
+ - [metadata
restore](cli_tool/metadata_tool/metadata_backup_restore.md#metadata-restore----metadata_restore)
diff --git
a/website/docs/query/insight/images/insight/insight_list_tables.en.png
b/website/docs/query/insight/images/insight/insight_list_tables.png
similarity index 100%
rename from website/docs/query/insight/images/insight/insight_list_tables.en.png
rename to website/docs/query/insight/images/insight/insight_list_tables.png
diff --git a/website/docs/query/insight/insight.md
b/website/docs/query/insight/insight.md
index 7ead86fc08..5287edcea5 100644
--- a/website/docs/query/insight/insight.md
+++ b/website/docs/query/insight/insight.md
@@ -17,7 +17,7 @@ last_update:
Open kylin Web UI, click **Query -> Insight** button on the navigation bar,
all query-able tables will be listed on the left side of page. Enter SQL in
textbox on the right side of page, query result will be shown at the below
textbox.
-
+
diff --git
a/website/docs/query/insight/operator_function/function/arithmetic_function.md
b/website/docs/query/insight/operator_function/function/arithmetic_function.md
index 0ac084d476..63c2f10a5d 100644
---
a/website/docs/query/insight/operator_function/function/arithmetic_function.md
+++
b/website/docs/query/insight/operator_function/function/arithmetic_function.md
@@ -22,7 +22,7 @@ last_update:
| MOD(numeric1, numeric2) | Returns the remainder (modulus) of
*numeric1* divided by *numeric2*. The result is negative only if *numeric1* is
negative | `MOD(-3, 2)` = -1 | ✔️ | ✔️ | ❌ | ❌ |
| SQRT(numeric) | Returns the square root of *numeric*
| `SQRT(16)` = 4.0 | ✔️ | ✔️ | ✔️ | ❌ |
| CBRT(numeric) | Returns the cube root of *numeric*.
| ` CBRT(27.0)` = 3.0 | ✔️ | ✔️ | ✔️ | ✔️ |
-| HYPOT(numeric1, numeric2) | Returns
 | ` HYPOT(3, 4)` =
5.0 | ✔️ | ✔️ | ✔️ | ✔️ |
+| HYPOT(numeric1, numeric2) | Returns
 | ` HYPOT(3, 4)` = 5.0 |
✔️ | ✔️ | ✔️ | ✔️ |
| LN(numeric) | Returns the natural logarithm (base *e*) of
*numeric* | ` LN(2)` = 0.6931471805599453 | ✔️ | ✔️ | ✔️ | ✔️ |
| LOG(base, numeric) | Returns the logarithm of *numeric* with
*base*. | ` LOG(10, 100)` = 2.0 | ✔️ | ✔️ | ✔️ | ✔️ |
| LOG10(numeric) | Returns the base 10 logarithm of *numeric*
| ` LOG10(100)` = 2.0 | ✔️ | ✔️ | ✔️ | ✔️ |
diff --git
a/website/docs/query/insight/operator_function/function/bitmap_function.md
b/website/docs/query/insight/operator_function/function/bitmap_function.md
index 9e0541d3b9..044cd7b232 100644
--- a/website/docs/query/insight/operator_function/function/bitmap_function.md
+++ b/website/docs/query/insight/operator_function/function/bitmap_function.md
@@ -41,11 +41,11 @@ Kylin version is 5.0 or higher.
- Query Example 1
- ```select bitmap_uuid(SELLER_ID) from KYLIN_SALES where
PART_DT=date'2012-01-01'```
+ ```select bitmap_uuid(LO_CUSTKEY) from SSB.P_LINEORDER where
LO_ORDERDATE=date'2012-01-01'```
- Response Example 1
- 
+ 
Return a string which points to a hidden serialized bitmap. The bitmap
result is the de-duplicated seller id set of online transactions on New Year's
Day. The bitmap can be used as an input to other bitmap functions.
@@ -75,14 +75,14 @@ Kylin version is 5.0 or higher.
```
select intersect_bitmap_uuid(
- SELLER_ID, LSTG_FORMAT_NAME,
- array['FP-GTC|FP-non GTC', 'Others'])
- from KYLIN_SALES
+ LO_CUSTKEY, LO_SHIPMODE,
+ array['AIR', 'Others'])
+ from SSB.P_LINEORDER
```
- Response Example 1
- 
+ 
Return a string which points to a hidden serialized bitmap. The bitmap
result is the de-duplicated seller id set who have transactions in either type
'FP-GTC' and 'Others', or type 'FP-non GTC' or 'Others' on New Year's Day. The
bitmap can be used as an input to other bitmap functions.
@@ -108,14 +108,14 @@ Kylin version is 5.0 or higher.
```
select intersect_bitmap_uuid_v2(
- SELLER_ID, LSTG_FORMAT_NAME,
- array['FP.*GTC', 'Other.*'], 'REGEXP')
- from KYLIN_SALES
+ LO_CUSTKEY, LO_SHIPMODE,
+ array['A*R', 'Other.*'], 'REGEXP')
+ from SSB.P_LINEORDER
```
- Response Example 1
- 
+ 
Return a string which points to a hidden serialized bitmap. The regular
expression can match 'FP-GTC', 'FP-non GTC' and 'Others', The bitmap result is
the de-duplicated seller id set who have transactions in either type 'FP-GTC'
and 'Others', or type 'FP-non GTC' or 'Others' on New Year's Day. The bitmap
can be used as an input to other bitmap functions.
@@ -137,17 +137,17 @@ Kylin version is 5.0 or higher.
```
select intersect_count_by_col(Array[t1.a1,t2.a2]) from
- (select bitmap_uuid(SELLER_ID) as a1
- from KYLIN_SALES) t1,
- (select intersect_bitmap_uuid(
- SELLER_ID, LSTG_FORMAT_NAME,
- array['FP-GTC|FP-non GTC', 'Others']) as a2
- from KYLIN_SALES) t2
+ (select bitmap_uuid(LO_CUSTKEY) as a1
+ from SSB.P_LINEORDER) t1,
+ (select intersect_bitmap_uuid(
+ LO_CUSTKEY, LO_SHIPMODE,
+ array['AIR', 'Others']) as a2
+ from SSB.P_LINEORDER) t2
```
- Response Example 1
- 
+ 
Function `bitmap_uuid` and `intersect_bitmap_uuid` return two serialized
bitmap. `intersect_count_by_col` then find the intersection on two bitmaps and
return distinct count.
diff --git
a/website/docs/query/insight/operator_function/function/datetime_function.md
b/website/docs/query/insight/operator_function/function/datetime_function.md
index baa38e4a09..60748a0f96 100644
--- a/website/docs/query/insight/operator_function/function/datetime_function.md
+++ b/website/docs/query/insight/operator_function/function/datetime_function.md
@@ -15,8 +15,6 @@ last_update:
date: 08/17/2022
---
-## Date and Time Functions
-
| Syntax | Description
| Example
| Normal Query | Pushdown Query | Defined as Computed Column |
Suggested as Computed Column |
| ----------------------------------------- |
------------------------------------------------------------ |
------------------------------------------------------------ | ------------ |
-------------- | -------------------------- | ---------------------------- |
| CURRENT_DATE | Returns the current date in the
session time zone, in a value of datatype DATE | ` CURRENT_DATE`<br /> =
2018-10-10 | ✔️ | ✔️ | ✔️
| ✔️ |
diff --git
a/website/docs/query/insight/operator_function/function/grouping_function.md
b/website/docs/query/insight/operator_function/function/grouping_function.md
index 230f818b06..cbe2801ff9 100644
--- a/website/docs/query/insight/operator_function/function/grouping_function.md
+++ b/website/docs/query/insight/operator_function/function/grouping_function.md
@@ -39,7 +39,7 @@ GROUP BY
- Result Example
-
+
### CUBE(expression) 和 ROLLUP(expression)
@@ -62,7 +62,7 @@ GROUP BY
- Result Example
-
+
@@ -92,4 +92,4 @@ GROUP BY
You can see that the result of the GROUPING function in both columns in the
first row is 1, indicating that the NULL in the two columns LO_CUSTKEY and
LO_ORDERKEY in this row are placeholders due to the GROUPING SETS function.
-
+
diff --git
a/website/docs/query/insight/operator_function/function/images/arithmetic_function.en.png
b/website/docs/query/insight/operator_function/function/images/arithmetic_function.png
similarity index 100%
rename from
website/docs/query/insight/operator_function/function/images/arithmetic_function.en.png
rename to
website/docs/query/insight/operator_function/function/images/arithmetic_function.png
diff --git
a/website/docs/query/insight/operator_function/function/images/bitmap_uuid.1.en.png
b/website/docs/query/insight/operator_function/function/images/bitmap_uuid.1.en.png
deleted file mode 100644
index 241ada2a02..0000000000
Binary files
a/website/docs/query/insight/operator_function/function/images/bitmap_uuid.1.en.png
and /dev/null differ
diff --git
a/website/docs/query/insight/operator_function/function/images/bitmap_uuid.1.png
b/website/docs/query/insight/operator_function/function/images/bitmap_uuid.1.png
new file mode 100644
index 0000000000..437ff3931e
Binary files /dev/null and
b/website/docs/query/insight/operator_function/function/images/bitmap_uuid.1.png
differ
diff --git
a/website/docs/query/insight/operator_function/function/images/date_string.png
b/website/docs/query/insight/operator_function/function/images/date_string.png
deleted file mode 100644
index 3af79731ad..0000000000
Binary files
a/website/docs/query/insight/operator_function/function/images/date_string.png
and /dev/null differ
diff --git
a/website/docs/query/insight/operator_function/function/images/first_last_value.png
b/website/docs/query/insight/operator_function/function/images/first_last_value.png
new file mode 100644
index 0000000000..c552e7571c
Binary files /dev/null and
b/website/docs/query/insight/operator_function/function/images/first_last_value.png
differ
diff --git
a/website/docs/query/insight/operator_function/function/images/first_last_value_en.png
b/website/docs/query/insight/operator_function/function/images/first_last_value_en.png
deleted file mode 100644
index f9d41c0c08..0000000000
Binary files
a/website/docs/query/insight/operator_function/function/images/first_last_value_en.png
and /dev/null differ
diff --git
a/website/docs/query/insight/operator_function/function/images/grouping.png
b/website/docs/query/insight/operator_function/function/images/grouping.png
new file mode 100644
index 0000000000..b492d94af2
Binary files /dev/null and
b/website/docs/query/insight/operator_function/function/images/grouping.png
differ
diff --git
a/website/docs/query/insight/operator_function/function/images/grouping_en.png
b/website/docs/query/insight/operator_function/function/images/grouping_en.png
deleted file mode 100644
index 95450c9024..0000000000
Binary files
a/website/docs/query/insight/operator_function/function/images/grouping_en.png
and /dev/null differ
diff --git
a/website/docs/query/insight/operator_function/function/images/grouping_sets.1.png
b/website/docs/query/insight/operator_function/function/images/grouping_sets.1.png
deleted file mode 100644
index 706204eb32..0000000000
Binary files
a/website/docs/query/insight/operator_function/function/images/grouping_sets.1.png
and /dev/null differ
diff --git
a/website/docs/query/insight/operator_function/function/images/grouping_sets.2.png
b/website/docs/query/insight/operator_function/function/images/grouping_sets.2.png
deleted file mode 100644
index 08c8608eea..0000000000
Binary files
a/website/docs/query/insight/operator_function/function/images/grouping_sets.2.png
and /dev/null differ
diff --git
a/website/docs/query/insight/operator_function/function/images/grouping_sets_function.png
b/website/docs/query/insight/operator_function/function/images/grouping_sets_function.png
new file mode 100644
index 0000000000..982dd04b8a
Binary files /dev/null and
b/website/docs/query/insight/operator_function/function/images/grouping_sets_function.png
differ
diff --git
a/website/docs/query/insight/operator_function/function/images/grouping_sets_function_en.png
b/website/docs/query/insight/operator_function/function/images/grouping_sets_function_en.png
deleted file mode 100644
index 6eac9acb19..0000000000
Binary files
a/website/docs/query/insight/operator_function/function/images/grouping_sets_function_en.png
and /dev/null differ
diff --git
a/website/docs/query/insight/operator_function/function/images/intersect_bitmap_uuid.1.en.png
b/website/docs/query/insight/operator_function/function/images/intersect_bitmap_uuid.1.en.png
deleted file mode 100644
index 820a8dde14..0000000000
Binary files
a/website/docs/query/insight/operator_function/function/images/intersect_bitmap_uuid.1.en.png
and /dev/null differ
diff --git
a/website/docs/query/insight/operator_function/function/images/intersect_bitmap_uuid.1.png
b/website/docs/query/insight/operator_function/function/images/intersect_bitmap_uuid.1.png
new file mode 100644
index 0000000000..846af8c0f6
Binary files /dev/null and
b/website/docs/query/insight/operator_function/function/images/intersect_bitmap_uuid.1.png
differ
diff --git
a/website/docs/query/insight/operator_function/function/images/intersect_bitmap_uuid2.1.en.png
b/website/docs/query/insight/operator_function/function/images/intersect_bitmap_uuid2.1.en.png
deleted file mode 100644
index 65d8e33ad5..0000000000
Binary files
a/website/docs/query/insight/operator_function/function/images/intersect_bitmap_uuid2.1.en.png
and /dev/null differ
diff --git
a/website/docs/query/insight/operator_function/function/images/intersect_bitmap_uuid2.1.png
b/website/docs/query/insight/operator_function/function/images/intersect_bitmap_uuid2.1.png
index 4b6ff1fe6f..2a009b0445 100644
Binary files
a/website/docs/query/insight/operator_function/function/images/intersect_bitmap_uuid2.1.png
and
b/website/docs/query/insight/operator_function/function/images/intersect_bitmap_uuid2.1.png
differ
diff --git
a/website/docs/query/insight/operator_function/function/images/intersect_count.1.en.png
b/website/docs/query/insight/operator_function/function/images/intersect_count.1.en.png
deleted file mode 100644
index d95db345e6..0000000000
Binary files
a/website/docs/query/insight/operator_function/function/images/intersect_count.1.en.png
and /dev/null differ
diff --git
a/website/docs/query/insight/operator_function/function/images/intersect_count.1.png
b/website/docs/query/insight/operator_function/function/images/intersect_count.1.png
new file mode 100644
index 0000000000..3202f91a44
Binary files /dev/null and
b/website/docs/query/insight/operator_function/function/images/intersect_count.1.png
differ
diff --git
a/website/docs/query/insight/operator_function/function/images/intersect_count.2.en.png
b/website/docs/query/insight/operator_function/function/images/intersect_count.2.en.png
deleted file mode 100644
index f0b7c9fb3f..0000000000
Binary files
a/website/docs/query/insight/operator_function/function/images/intersect_count.2.en.png
and /dev/null differ
diff --git
a/website/docs/query/insight/operator_function/function/images/intersect_count.2.png
b/website/docs/query/insight/operator_function/function/images/intersect_count.2.png
new file mode 100644
index 0000000000..83911ef8fe
Binary files /dev/null and
b/website/docs/query/insight/operator_function/function/images/intersect_count.2.png
differ
diff --git
a/website/docs/query/insight/operator_function/function/images/intersect_count2.1.en.png
b/website/docs/query/insight/operator_function/function/images/intersect_count2.1.en.png
deleted file mode 100644
index 692a40be5e..0000000000
Binary files
a/website/docs/query/insight/operator_function/function/images/intersect_count2.1.en.png
and /dev/null differ
diff --git
a/website/docs/query/insight/operator_function/function/images/intersect_count2.1.png
b/website/docs/query/insight/operator_function/function/images/intersect_count2.1.png
new file mode 100644
index 0000000000..a71540bd81
Binary files /dev/null and
b/website/docs/query/insight/operator_function/function/images/intersect_count2.1.png
differ
diff --git
a/website/docs/query/insight/operator_function/function/images/intersect_count_by_col.1.en.png
b/website/docs/query/insight/operator_function/function/images/intersect_count_by_col.1.en.png
deleted file mode 100644
index b9f052c30c..0000000000
Binary files
a/website/docs/query/insight/operator_function/function/images/intersect_count_by_col.1.en.png
and /dev/null differ
diff --git
a/website/docs/query/insight/operator_function/function/images/intersect_count_by_col.1.png
b/website/docs/query/insight/operator_function/function/images/intersect_count_by_col.1.png
new file mode 100644
index 0000000000..dd56fa05f0
Binary files /dev/null and
b/website/docs/query/insight/operator_function/function/images/intersect_count_by_col.1.png
differ
diff --git
a/website/docs/query/insight/operator_function/function/images/intersect_value.1.en.png
b/website/docs/query/insight/operator_function/function/images/intersect_value.1.en.png
deleted file mode 100644
index 35cf3d444f..0000000000
Binary files
a/website/docs/query/insight/operator_function/function/images/intersect_value.1.en.png
and /dev/null differ
diff --git
a/website/docs/query/insight/operator_function/function/images/intersect_value.1.png
b/website/docs/query/insight/operator_function/function/images/intersect_value.1.png
new file mode 100644
index 0000000000..8f9de2536f
Binary files /dev/null and
b/website/docs/query/insight/operator_function/function/images/intersect_value.1.png
differ
diff --git
a/website/docs/query/insight/operator_function/function/images/intersect_value.2.en.png
b/website/docs/query/insight/operator_function/function/images/intersect_value.2.en.png
deleted file mode 100644
index 0f989339da..0000000000
Binary files
a/website/docs/query/insight/operator_function/function/images/intersect_value.2.en.png
and /dev/null differ
diff --git
a/website/docs/query/insight/operator_function/function/images/intersect_value.2.png
b/website/docs/query/insight/operator_function/function/images/intersect_value.2.png
new file mode 100644
index 0000000000..80f545c82a
Binary files /dev/null and
b/website/docs/query/insight/operator_function/function/images/intersect_value.2.png
differ
diff --git
a/website/docs/query/insight/operator_function/function/images/intersect_value2.1.en.png
b/website/docs/query/insight/operator_function/function/images/intersect_value2.1.en.png
deleted file mode 100644
index 7fede543cd..0000000000
Binary files
a/website/docs/query/insight/operator_function/function/images/intersect_value2.1.en.png
and /dev/null differ
diff --git
a/website/docs/query/insight/operator_function/function/images/intersect_value2.1.png
b/website/docs/query/insight/operator_function/function/images/intersect_value2.1.png
new file mode 100644
index 0000000000..c6ca853c55
Binary files /dev/null and
b/website/docs/query/insight/operator_function/function/images/intersect_value2.1.png
differ
diff --git
a/website/docs/query/insight/operator_function/function/images/lead_lag.png
b/website/docs/query/insight/operator_function/function/images/lead_lag.png
new file mode 100644
index 0000000000..c3ef0b145f
Binary files /dev/null and
b/website/docs/query/insight/operator_function/function/images/lead_lag.png
differ
diff --git
a/website/docs/query/insight/operator_function/function/images/lead_lag_en.png
b/website/docs/query/insight/operator_function/function/images/lead_lag_en.png
deleted file mode 100644
index ba416a3840..0000000000
Binary files
a/website/docs/query/insight/operator_function/function/images/lead_lag_en.png
and /dev/null differ
diff --git
a/website/docs/query/insight/operator_function/function/images/ntile.png
b/website/docs/query/insight/operator_function/function/images/ntile.png
new file mode 100644
index 0000000000..59cd957c74
Binary files /dev/null and
b/website/docs/query/insight/operator_function/function/images/ntile.png differ
diff --git
a/website/docs/query/insight/operator_function/function/images/ntile_en.png
b/website/docs/query/insight/operator_function/function/images/ntile_en.png
deleted file mode 100644
index 2cec509510..0000000000
Binary files
a/website/docs/query/insight/operator_function/function/images/ntile_en.png and
/dev/null differ
diff --git
a/website/docs/query/insight/operator_function/function/images/operator.png
b/website/docs/query/insight/operator_function/function/images/operator.png
deleted file mode 100644
index 5a84847396..0000000000
Binary files
a/website/docs/query/insight/operator_function/function/images/operator.png and
/dev/null differ
diff --git
a/website/docs/query/insight/operator_function/function/images/rank_and_drank.png
b/website/docs/query/insight/operator_function/function/images/rank_and_drank.png
new file mode 100644
index 0000000000..f886d47c5d
Binary files /dev/null and
b/website/docs/query/insight/operator_function/function/images/rank_and_drank.png
differ
diff --git
a/website/docs/query/insight/operator_function/function/images/rank_and_drank_en.png
b/website/docs/query/insight/operator_function/function/images/rank_and_drank_en.png
deleted file mode 100644
index ada729f0ed..0000000000
Binary files
a/website/docs/query/insight/operator_function/function/images/rank_and_drank_en.png
and /dev/null differ
diff --git
a/website/docs/query/insight/operator_function/function/images/rollup_function.png
b/website/docs/query/insight/operator_function/function/images/rollup_function.png
new file mode 100644
index 0000000000..5d61ceee47
Binary files /dev/null and
b/website/docs/query/insight/operator_function/function/images/rollup_function.png
differ
diff --git
a/website/docs/query/insight/operator_function/function/images/rollup_function_en.png
b/website/docs/query/insight/operator_function/function/images/rollup_function_en.png
deleted file mode 100644
index 566bd0cafa..0000000000
Binary files
a/website/docs/query/insight/operator_function/function/images/rollup_function_en.png
and /dev/null differ
diff --git
a/website/docs/query/insight/operator_function/function/images/row_number_en.png
b/website/docs/query/insight/operator_function/function/images/row_number.png
similarity index 100%
rename from
website/docs/query/insight/operator_function/function/images/row_number_en.png
rename to
website/docs/query/insight/operator_function/function/images/row_number.png
diff --git
a/website/docs/query/insight/operator_function/function/images/timestamp_string.png
b/website/docs/query/insight/operator_function/function/images/timestamp_string.png
deleted file mode 100644
index 583e75d695..0000000000
Binary files
a/website/docs/query/insight/operator_function/function/images/timestamp_string.png
and /dev/null differ
diff --git
a/website/docs/query/insight/operator_function/function/intersect_function.md
b/website/docs/query/insight/operator_function/function/intersect_function.md
index 86b5317682..181986bddb 100644
---
a/website/docs/query/insight/operator_function/function/intersect_function.md
+++
b/website/docs/query/insight/operator_function/function/intersect_function.md
@@ -44,37 +44,37 @@ kylin supports the following intersection function,
- Query Example 1
- Take the sample dataset provided by kylin as an example, table `KYLIN_SALES`
simulates the online transaction data, and the following query can return the
percentile of sellers who are trading day by day during 2012.01.01 to
2012.01.03.
+ Take the sample dataset provided by kylin as an example, table
`SSB.P_LINEORDER` simulates the online transaction data, and the following
query can return the percentile of sellers who are trading day by day during
1992.01.01 to 1992.01.03.
```SQL
- select LSTG_FORMAT_NAME,
- intersect_count(SELLER_ID, PART_DT, array[date'2012-01-01']) as first_day,
- intersect_count(SELLER_ID, PART_DT, array[date'2012-01-02']) as second_day,
- intersect_count(SELLER_ID, PART_DT, array[date'2012-01-03']) as third_day,
- intersect_count(SELLER_ID, PART_DT,
array[date'2012-01-01',date'2012-01-02']) as retention_oneday,
- intersect_count(SELLER_ID, PART_DT,
array[date'2012-01-01',date'2012-01-02',date'2012-01-03']) as retention_twoday
- from KYLIN_SALES
- where PART_DT in (date'2012-01-01',date'2012-01-02',date'2012-01-03')
- group by LSTG_FORMAT_NAME
+ select LO_SHIPMODE,
+ intersect_count(LO_CUSTKEY, LO_ORDERDATE, array[date'1992-01-01']) as
first_day,
+ intersect_count(LO_CUSTKEY, LO_ORDERDATE, array[date'1992-01-02']) as
second_day,
+ intersect_count(LO_CUSTKEY, LO_ORDERDATE, array[date'1992-01-03']) as
third_day,
+ intersect_count(LO_CUSTKEY, LO_ORDERDATE,
array[date'1992-01-01',date'1992-01-02']) as retention_oneday,
+ intersect_count(LO_CUSTKEY, LO_ORDERDATE,
array[date'1992-01-01',date'1992-01-02',date'1992-01-03']) as retention_twoday
+ from SSB.P_LINEORDER
+ where LO_ORDERDATE in (date'1992-01-01',date'1992-01-02',date'1992-01-03')
+ group by LO_SHIPMODE
```
- Response Example 1
- 
+ 
The result shows that there is no seller keeps trading constantly during
this period.
- Query Example 2
```sql
- select
- intersect_count(SELLER_ID, LSTG_FORMAT_NAME, array['FP-GTC|FP-non
GTC|Others', 'Others']) as test_column
- from kylin_sales
+ select
+ intersect_count(LO_CUSTKEY, LO_SHIPMODE, array['RAIL|SHIP|TRUCK', 'TRUCK'])
as test_column
+ from SSB.P_LINEORDER
```
- Response Example 2
- 
+ 
### INTERSECT_VALUE
@@ -99,37 +99,37 @@ kylin supports the following intersection function,
- Query Example 1
- Fact table `KYLIN_SALES_TEST` simulates the online transaction data. And
data type of `SELLER_ID` column is `integer`. The following query can return
the ids of sellers who are trading day by day during 2012.01.01 to 2012.01.03.
+ Fact table `SSB.P_LINEORDER` simulates the online transaction data. And data
type of `LO_CUSTKEY` column is `integer`. The following query can return the
ids of sellers who are trading day by day during 1992.01.01 to 1992.01.03.
```SQL
- select LSTG_FORMAT_NAME,
- intersect_value(SELLER_ID, PART_DT, array[date'2012-01-01']) as first_day,
- intersect_value(SELLER_ID, PART_DT, array[date'2012-01-02']) as second_day,
- intersect_value(SELLER_ID, PART_DT, array[date'2012-01-03']) as third_day,
- intersect_value(SELLER_ID, PART_DT,
array[date'2012-01-01',date'2012-01-02']) as retention_oneday,
- intersect_value(SELLER_ID, PART_DT,
array[date'2012-01-01',date'2012-01-02',date'2012-01-03']) as retention_twoday
- from KYLIN_SALES
- where PART_DT in (date'2012-01-01',date'2012-01-02',date'2012-01-03')
- group by LSTG_FORMAT_NAME
+ select LO_SHIPMODE,
+ intersect_value(LO_CUSTKEY, LO_ORDERDATE, array[date'1992-01-01']) as
first_day,
+ intersect_value(LO_CUSTKEY, LO_ORDERDATE, array[date'1992-01-02']) as
second_day,
+ intersect_value(LO_CUSTKEY, LO_ORDERDATE, array[date'1992-01-03']) as
third_day,
+ intersect_value(LO_CUSTKEY, LO_ORDERDATE,
array[date'1992-01-01',date'1992-01-02']) as retention_oneday,
+ intersect_value(LO_CUSTKEY, LO_ORDERDATE,
array[date'1992-01-01',date'1992-01-02',date'1992-01-03']) as retention_twoday
+ from SSB.P_LINEORDER
+ where PART_DT in (date'1992-01-01',date'1992-01-02',date'1992-01-03')
+ group by LO_SHIPMODE
```
- Response Example 1
- 
+ 
The result shows that set of keeping trading constantly's sellerId during
this period.
- Query Example 2
```sql
- select
- intersect_value(SELLER_ID, LSTG_FORMAT_NAME, array['FP-GTC|FP-non
GTC|Others', 'Others']) as test_column
- from kylin_sales
+ select
+ intersect_count(LO_CUSTKEY, LO_SHIPMODE, array['RAIL|SHIP|TRUCK', 'TRUCK'])
as test_column
+ from SSB.P_LINEORDER
```
- Response Example 2
- 
+ 
### INTERSECT_COUNT_V2
@@ -150,15 +150,15 @@ kylin supports the following intersection function,
- Query Example 1
```sql
- select intersect_count_v2(
- LSTG_SITE_ID, LSTG_FORMAT_NAME,
- array['FP.*GTC', 'Other.*'], 'REGEXP')
- from kylin_sales
+ select intersect_count_v2(
+ LO_CUSTKEY, LO_SHIPMODE,
+ array['R*L', 'TRU.*'], 'SHIP')
+ from SSB.P_LINEORDER
```
- Response Example 1
- 
+ 
### INTERSECT_VALUE_V2
@@ -179,16 +179,16 @@ kylin supports the following intersection function,
- Query Example 1
- ```sql
+ ```sql
select intersect_value_v2(
- LSTG_SITE_ID, LSTG_FORMAT_NAME,
- array['FP.*GTC', 'Other.*'], 'REGEXP')
- from kylin_sales
+ LO_CUSTKEY, LO_SHIPMODE,
+ array['R*L', 'TRU.*'], 'SHIP')
+ from SSB.P_LINEORDER
```
- Response Example 1
- 
+ 
### Limitations
- All the above functions don't support pushdown query
diff --git
a/website/docs/query/insight/operator_function/function/string_function.md
b/website/docs/query/insight/operator_function/function/string_function.md
index 05329b9d66..d560049b24 100644
--- a/website/docs/query/insight/operator_function/function/string_function.md
+++ b/website/docs/query/insight/operator_function/function/string_function.md
@@ -16,8 +16,8 @@ last_update:
| Syntax | Description
| Example
| Normal Query | Pushdown Query | Defined as
Computed Column | Suggested as Computed Column |
| ------------------------------------------------------------ |
------------------------------------------------------------ |
------------------------------------------------------------ | ------------ |
-------------- | -------------------------- | ---------------------------- |
-| CHAR_LENGTH(string) | Returns the
number of characters in a character string |
`CHAR_LENGTH('Kyligence')`<br /> = 9 | ✔️ |
✔️ | ✔️ | ✔️ |
-| CHARACTER_LENGTH(string) | As
CHAR_LENGTH(*string*) | `
CHARACTER_LENGTH('Kyligence')`<br /> = 9 | ✔️ | ✔️
| ✔️ | ✔️ |
+| CHAR_LENGTH(string) | Returns the
number of characters in a character string | `CHAR_LENGTH('Kylin')`<br />
= 5 | ✔️ | ✔️ | ✔️
| ✔️ |
+| CHARACTER_LENGTH(string) | As
CHAR_LENGTH(*string*) | `
CHARACTER_LENGTH('Kylin')`<br /> = 5 | ✔️ | ✔️
| ✔️ | ✔️ |
| UPPER(string) | Returns a
character string converted to upper case | ` UPPER('Kylin')`<br /> =
KYLIN | ✔️ | ✔️ | ✔️
| ✔️ |
| LOWER(string) | Returns a
character string converted to lower case | ` LOWER('Kylin')`<br /> =
kylin | ✔️ | ✔️ | ✔️
| ✔️ |
| POSITION(string1 IN string2) | Returns the
position of the first occurrence of *string1* in *string2* | ` POSITION('Kyli'
IN 'Kylin')`<br /> = 1 | ✔️ | ✔️ | ✔️
| ✔️ |
diff --git
a/website/docs/query/insight/operator_function/function/type_function.md
b/website/docs/query/insight/operator_function/function/type_function.md
index e86e6518a5..076c853d19 100644
--- a/website/docs/query/insight/operator_function/function/type_function.md
+++ b/website/docs/query/insight/operator_function/function/type_function.md
@@ -14,8 +14,6 @@ last_update:
date: 08/17/2022
---
-## Type Functions
-
| Syntax | Description
| Example
| Normal Query | Pushdown Query
| Defined as Computed Column
| Suggested as Computed Column |
| ------------------- |
------------------------------------------------------------ |
------------------------------------------------------------ |
------------------------------------------------------------ |
------------------------------------------------------------ |
------------------------------------------------------------ |
------------------------------------------------------------ |
| CAST(value AS type) | Converts a value to a given type. | Example 1:
Converts `time` to `string`<br />`CAST(CURRENT_DATE as varchar)`<br /> =
2018-10-10 | ✔️ | ✔️ | ✔️ | ✔️ |
diff --git
a/website/docs/query/insight/operator_function/function/window_function.md
b/website/docs/query/insight/operator_function/function/window_function.md
index 84f362e0ae..c78d7af0ac 100644
--- a/website/docs/query/insight/operator_function/function/window_function.md
+++ b/website/docs/query/insight/operator_function/function/window_function.md
@@ -68,7 +68,7 @@ And then we'll illustrate the usage of every single window
function with table *
```
- **Result**
- 
+ 
- **Result Explanation**
For buyer with id '1', there are four orders with quantity of 1, and the
above three functions are compared as follows:
@@ -97,13 +97,11 @@ And then we'll illustrate the usage of every single window
function with table *
LO_PARTKEY
FROM SSB.P_LINEORDER
WHERE LO_QUANTITY >= 48
-WINDOW w AS (PARTITION BY LO_CUSTKEY ORDER BY LO_QUANTITY);
+ WINDOW w AS (PARTITION BY LO_CUSTKEY ORDER BY LO_QUANTITY);
```
- **Result**
- 
-
-
+ 
- **FIRST_VALUE**
@@ -135,7 +133,7 @@ WINDOW w AS (PARTITION BY LO_CUSTKEY ORDER BY LO_QUANTITY);
```
- **Result**
- 
+ 
@@ -162,4 +160,4 @@ WINDOW w AS (PARTITION BY LO_CUSTKEY ORDER BY LO_QUANTITY);
```
- **Result**
- 
+ 
diff --git a/website/docs/query/insight/operator_function/operator/intro.md
b/website/docs/query/insight/operator_function/operator/intro.md
index ebf98c3135..c0a7e59b00 100644
--- a/website/docs/query/insight/operator_function/operator/intro.md
+++ b/website/docs/query/insight/operator_function/operator/intro.md
@@ -14,8 +14,4 @@ last_update:
date: 08/17/2022
---
-
-
-## Operators
-
This chapter will introduce operators that applicable to SQL statements.
diff --git
a/website/docs/query/insight/operator_function/operator/logical_operator.md
b/website/docs/query/insight/operator_function/operator/logical_operator.md
index da48b93cba..61e2e87cf7 100644
--- a/website/docs/query/insight/operator_function/operator/logical_operator.md
+++ b/website/docs/query/insight/operator_function/operator/logical_operator.md
@@ -14,9 +14,6 @@ last_update:
date: 08/17/2022
---
-
-## Logical Operators
-
This section introduces the logical operators supported by Apache Kylin. The
values of logical propositions are TRUE, FALSE, and UNKNOWN. The following
`boolean` refers to a logical proposition.
| Operator | Description | Syntax
| Example |
diff --git
a/website/docs/query/insight/operator_function/operator/string_operator.md
b/website/docs/query/insight/operator_function/operator/string_operator.md
index 1fc34b88c0..29f6768d5d 100644
--- a/website/docs/query/insight/operator_function/operator/string_operator.md
+++ b/website/docs/query/insight/operator_function/operator/string_operator.md
@@ -15,7 +15,5 @@ last_update:
---
-## String Operator
-
diff --git a/website/docs/quickstart/expert_mode_tutorial.md
b/website/docs/quickstart/expert_mode_tutorial.md
index b010131dd7..7c307d335a 100644
--- a/website/docs/quickstart/expert_mode_tutorial.md
+++ b/website/docs/quickstart/expert_mode_tutorial.md
@@ -9,9 +9,9 @@ pagination_prev: null
pagination_next: null
keywords:
- expert mode tutorial
-draft: true
+draft: false
last_update:
- date: 08/12/2022
+ date: 09/13/2022
---
diff --git a/website/docs/quickstart/intro.md b/website/docs/quickstart/intro.md
index 3406130758..3d75bccb32 100644
--- a/website/docs/quickstart/intro.md
+++ b/website/docs/quickstart/intro.md
@@ -10,9 +10,9 @@ pagination_next: null
keywords:
- intro
- overview
-draft: true
+draft: false
last_update:
- date: 08/12/2022
+ date: 09/13/2022
---
diff --git a/website/docs/quickstart/quick_start.md
b/website/docs/quickstart/quick_start.md
index 36723d664c..797c809dc7 100644
--- a/website/docs/quickstart/quick_start.md
+++ b/website/docs/quickstart/quick_start.md
@@ -9,9 +9,9 @@ pagination_prev: null
pagination_next: null
keywords:
- quick start
-draft: true
+draft: false
last_update:
- date: 08/12/2022
+ date: 09/13/2022
---
In this guide, we will explain how to quickly install and start Kylin 5.
diff --git a/website/docs/quickstart/sample_dataset.md
b/website/docs/quickstart/sample_dataset.md
index 68aa91cb4e..7362728b7a 100755
--- a/website/docs/quickstart/sample_dataset.md
+++ b/website/docs/quickstart/sample_dataset.md
@@ -11,7 +11,7 @@ keywords:
- sample dataset
draft: false
last_update:
- date: 08/19/2022
+ date: 09/13/2022
---
Kylin is embedded with a standard SSB dataset (approximately 5.9 MB) for
testing or trying out different functions. This SSB dataset contains 5 tables
and 1 view. LINEORDER serves as a central fact table with 60,175 rows of data.
diff --git a/website/docs/restapi/image/job_api_en.png
b/website/docs/restapi/image/job_api.png
similarity index 100%
rename from website/docs/restapi/image/job_api_en.png
rename to website/docs/restapi/image/job_api.png
diff --git a/website/docs/restapi/image/metrics_store_en.png
b/website/docs/restapi/image/metrics_store_en.png
deleted file mode 100644
index 3595063e76..0000000000
Binary files a/website/docs/restapi/image/metrics_store_en.png and /dev/null
differ
diff --git a/website/docs/restapi/image/work_follow_en.png
b/website/docs/restapi/image/work_follow_en.png
deleted file mode 100644
index 784ad483b0..0000000000
Binary files a/website/docs/restapi/image/work_follow_en.png and /dev/null
differ
diff --git a/website/docs/restapi/job_api.md b/website/docs/restapi/job_api.md
index 8fbe91db9e..40fc8c54ad 100644
--- a/website/docs/restapi/job_api.md
+++ b/website/docs/restapi/job_api.md
@@ -33,7 +33,7 @@ last_update:
- URL Parameters
- `time_filter` - `required` `int`
- 
+ 
- `project` - `optional` `string`, project name
diff --git a/website/sidebars.js b/website/sidebars.js
index b6fc750bbb..10f48ce8e6 100644
--- a/website/sidebars.js
+++ b/website/sidebars.js
@@ -116,6 +116,10 @@ const sidebars = {
},
],
},
+ {
+ type: 'doc',
+ id:
'deployment/on-premises/rdbms_metastore/query_history_fields'
+ },
]
},
{
@@ -674,6 +678,100 @@ const sidebars = {
type: 'doc',
id: 'query/insight/async_query'
},
+ {
+ type: 'category',
+ label: 'Operators and Functions',
+ link: {
+ type: 'doc',
+ id: 'query/insight/operator_function/intro'
+ },
+ items: [
+ {
+ type: 'doc',
+ id:
'query/insight/operator_function/model_priority'
+ },
+ {
+ type: 'category',
+ label: 'Operators',
+ link: {
+ type: 'doc',
+ id:
'query/insight/operator_function/operator/intro',
+ },
+ items: [
+ {
+ type: 'doc',
+ id:
'query/insight/operator_function/operator/arithmetic_operator',
+ },
+ {
+ type: 'doc',
+ id:
'query/insight/operator_function/operator/comparison_operator',
+ },
+ {
+ type: 'doc',
+ id:
'query/insight/operator_function/operator/logical_operator',
+ },
+ {
+ type: 'doc',
+ id:
'query/insight/operator_function/operator/string_operator',
+ },
+ ],
+ },
+ {
+ type: 'category',
+ label: 'Function',
+ link: {
+ type: 'doc',
+ id:
'query/insight/operator_function/function/intro',
+ },
+ items: [
+ {
+ type: 'doc',
+ id:
'query/insight/operator_function/function/aggregate_function',
+ },
+ {
+ type: 'doc',
+ id:
'query/insight/operator_function/function/arithmetic_function',
+ },
+ {
+ type: 'doc',
+ id:
'query/insight/operator_function/function/bitmap_function',
+ },
+ {
+ type: 'doc',
+ id:
'query/insight/operator_function/function/conditional_function',
+ },
+ {
+ type: 'doc',
+ id:
'query/insight/operator_function/function/datetime_function',
+ },
+ {
+ type: 'doc',
+ id:
'query/insight/operator_function/function/grouping_function',
+ },
+ {
+ type: 'doc',
+ id:
'query/insight/operator_function/function/intersect_function',
+ },
+ {
+ type: 'doc',
+ id:
'query/insight/operator_function/function/miscellaneous_function',
+ },
+ {
+ type: 'doc',
+ id:
'query/insight/operator_function/function/string_function',
+ },
+ {
+ type: 'doc',
+ id:
'query/insight/operator_function/function/type_function',
+ },
+ {
+ type: 'doc',
+ id:
'query/insight/operator_function/function/window_function',
+ },
+ ],
+ }
+ ],
+ },
],
},
{
