You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@kylin.apache.org by xx...@apache.org on 2022/09/08 03:42:39 UTC
[kylin] branch doc5.0 updated: KYLIN-5257 add doc for query module
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
The following commit(s) were added to refs/heads/doc5.0 by this push:
new cae46d8d96 KYLIN-5257 add doc for query module
cae46d8d96 is described below
commit cae46d8d96bf7d05a7cca49f5761ab4fb9d8783e
Author: Mukvin <bo...@163.com>
AuthorDate: Thu Sep 8 11:37:06 2022 +0800
KYLIN-5257 add doc for query module
---
website/docs/query/history.md | 10 +++++-----
website/docs/query/images/query_history.en.png | Bin 247654 -> 0 bytes
website/docs/query/images/query_history.png | Bin 0 -> 81663 bytes
website/docs/query/images/query_history2.en.png | Bin 147978 -> 0 bytes
website/docs/query/images/query_history2.png | Bin 0 -> 38472 bytes
website/docs/query/images/query_history3.en.png | Bin 444360 -> 0 bytes
website/docs/query/images/query_history3.png | Bin 0 -> 81725 bytes
website/docs/query/images/query_history4.en.png | Bin 378233 -> 0 bytes
website/docs/query/images/query_history4.png | Bin 0 -> 80148 bytes
.../{query_history5.en.png => query_history5.png} | Bin
website/docs/query/insight/async_query.md | 12 ++++++------
.../query/insight/images/data_sql/date_sql1.en.png | Bin 261426 -> 0 bytes
.../query/insight/images/data_sql/date_sql1.png | Bin 0 -> 68417 bytes
.../query/insight/images/data_sql/date_sql2.en.png | Bin 269576 -> 0 bytes
.../query/insight/images/data_sql/date_sql2.png | Bin 0 -> 69851 bytes
.../insight/images/insight/insight_input_query.png | Bin 143172 -> 36415 bytes
.../insight/images/insight/insight_save_query.png | Bin 75146 -> 19561 bytes
.../insight/images/insight/insight_show_result.png | Bin 146467 -> 46656 bytes
.../images/insight/insight_step_duration1.png | Bin 71006 -> 39239 bytes
.../images/insight/insight_stop_query.en.png | Bin 135510 -> 0 bytes
.../insight/images/insight/insight_stop_query.png | Bin 0 -> 28138 bytes
.../insight/insight_stop_query_result.en.png | Bin 129988 -> 0 bytes
.../images/insight/insight_stop_query_result.png | Bin 0 -> 36180 bytes
website/docs/query/insight/images/spec/1.png | Bin 187872 -> 42897 bytes
website/docs/query/insight/images/spec/4.en.png | Bin 72467 -> 0 bytes
website/docs/query/insight/images/spec/4.png | Bin 0 -> 41281 bytes
website/docs/query/insight/images/spec/5.png | Bin 183604 -> 45295 bytes
website/docs/query/insight/images/spec/6.png | Bin 183680 -> 46880 bytes
website/docs/query/insight/images/spec/7.png | Bin 170998 -> 0 bytes
website/docs/query/insight/images/spec/8.png | Bin 176355 -> 0 bytes
website/docs/query/insight/insight.md | 8 +++-----
website/docs/query/insight/intro.md | 4 ++--
website/docs/query/insight/sql_spec.md | 8 ++++----
website/docs/query/optimization/query_enhanced.md | 2 +-
website/docs/query/optimization/segment_pruning.md | 2 +-
.../docs/query/pushdown/images/query_pushdown.png | Bin 51412 -> 10565 bytes
.../query/pushdown/images/query_pushdown_spark.png | Bin 264272 -> 0 bytes
website/docs/snapshot/images/snapshot_1.png | Bin 0 -> 39561 bytes
website/docs/snapshot/images/snapshot_1_en.png | Bin 160171 -> 0 bytes
website/docs/snapshot/images/snapshot_2.png | Bin 0 -> 92138 bytes
website/docs/snapshot/images/snapshot_2_en.png | Bin 327685 -> 0 bytes
website/docs/snapshot/images/snapshot_3.png | Bin 0 -> 89443 bytes
website/docs/snapshot/images/snapshot_3_en.png | Bin 313893 -> 0 bytes
website/docs/snapshot/images/snapshot_4.png | Bin 0 -> 64330 bytes
website/docs/snapshot/images/snapshot_4_en.png | Bin 49314 -> 0 bytes
website/docs/snapshot/images/snapshot_5.png | Bin 0 -> 44206 bytes
website/docs/snapshot/images/snapshot_5_en.png | Bin 39123 -> 0 bytes
website/docs/snapshot/images/snapshot_6.png | Bin 0 -> 38327 bytes
website/docs/snapshot/images/snapshot_6_en.png | Bin 53449 -> 0 bytes
website/docs/snapshot/images/snapshot_7.png | Bin 0 -> 27891 bytes
website/docs/snapshot/images/snapshot_7_en.png | Bin 45056 -> 0 bytes
website/docs/snapshot/images/snapshot_8.png | Bin 0 -> 17303 bytes
website/docs/snapshot/images/snapshot_8_en.png | Bin 71365 -> 0 bytes
website/docs/snapshot/images/snapshot_9.png | Bin 0 -> 43300 bytes
website/docs/snapshot/images/snapshot_9_en.png | Bin 38628 -> 0 bytes
website/docs/snapshot/snapshot_management.md | 18 +++++++++---------
56 files changed, 31 insertions(+), 33 deletions(-)
diff --git a/website/docs/query/history.md b/website/docs/query/history.md
index 3c29a70ac0..103567cd02 100644
--- a/website/docs/query/history.md
+++ b/website/docs/query/history.md
@@ -55,7 +55,7 @@ This page saves the basic information of queries, such as query time, SQL statem
Please enter the query history page by clicking **Query -> History** in the navigator bar, after executing the above SQL statements, you will see the following content.
-
+
Each line in the picture is a query history record. The meaning of the columns are as follows:
@@ -89,7 +89,7 @@ Each line in the picture is a query history record. The meaning of the columns a
When you click on the icon to the left of a query, the execution details of the query will be displayed, as shown below:
-
+
On the left is the SQL statement, you can copy and paste and then query. The fields on the right have the following meanings:
@@ -105,7 +105,7 @@ On the left is the SQL statement, you can copy and paste and then query. The fie
When you click on the error details to the right of a query failure, the exception details of that query are displayed，as shown below:
-
+
> **Note**: When SQL does not wrap, only the first 100 lines of SQL can be seen in the query execution details. When SQL wraps, the details display the first 2000 characters. You can click the copy button in the upper right corner of the SQL statement box to copy the complete SQL statement.
@@ -126,10 +126,10 @@ In order to ensure the read and write performance of the query history and datab
### Export query history
The query history can be exported as a csv file, as shown in the figure below, the export result is the filtered data.
-
+
You can also export the sql in the query history as a text file separately, as shown in the figure below, the export result is also the filtered data.
-
+
Query history support configuration export upper limit, the default value is 100000.
```kylin.query.query-history-download-max-size=100000```
diff --git a/website/docs/query/images/query_history.en.png b/website/docs/query/images/query_history.en.png
deleted file mode 100644
index f12f926d21..0000000000
Binary files a/website/docs/query/images/query_history.en.png and /dev/null differ
diff --git a/website/docs/query/images/query_history.png b/website/docs/query/images/query_history.png
new file mode 100644
index 0000000000..b01f3ff001
Binary files /dev/null and b/website/docs/query/images/query_history.png differ
diff --git a/website/docs/query/images/query_history2.en.png b/website/docs/query/images/query_history2.en.png
deleted file mode 100644
index e512786377..0000000000
Binary files a/website/docs/query/images/query_history2.en.png and /dev/null differ
diff --git a/website/docs/query/images/query_history2.png b/website/docs/query/images/query_history2.png
new file mode 100644
index 0000000000..41e0a278af
Binary files /dev/null and b/website/docs/query/images/query_history2.png differ
diff --git a/website/docs/query/images/query_history3.en.png b/website/docs/query/images/query_history3.en.png
deleted file mode 100644
index d9dedb9502..0000000000
Binary files a/website/docs/query/images/query_history3.en.png and /dev/null differ
diff --git a/website/docs/query/images/query_history3.png b/website/docs/query/images/query_history3.png
new file mode 100644
index 0000000000..91f92f8271
Binary files /dev/null and b/website/docs/query/images/query_history3.png differ
diff --git a/website/docs/query/images/query_history4.en.png b/website/docs/query/images/query_history4.en.png
deleted file mode 100644
index 72b95d2093..0000000000
Binary files a/website/docs/query/images/query_history4.en.png and /dev/null differ
diff --git a/website/docs/query/images/query_history4.png b/website/docs/query/images/query_history4.png
new file mode 100644
index 0000000000..b2322c2ba5
Binary files /dev/null and b/website/docs/query/images/query_history4.png differ
diff --git a/website/docs/query/images/query_history5.en.png b/website/docs/query/images/query_history5.png
similarity index 100%
rename from website/docs/query/images/query_history5.en.png
rename to website/docs/query/images/query_history5.png
diff --git a/website/docs/query/insight/async_query.md b/website/docs/query/insight/async_query.md
index 9e9c94512f..ea5071b391 100644
--- a/website/docs/query/insight/async_query.md
+++ b/website/docs/query/insight/async_query.md
@@ -26,7 +26,7 @@ Currently, asynchronous query only supports calling REST API. For how to use asy
Asynchronous query supports the following configuration in `kylin.properties`:
--`kylin.query.async.result-retain-days=7d`: The retention time of asynchronous query results on HDFS. The default is 7 days, that is, asynchronous query results and related files older than 7 days will be cleaned up
+- `kylin.query.async.result-retain-days=7d`: The retention time of asynchronous query results on HDFS. The default is 7 days, that is, asynchronous query results and related files older than 7 days will be cleaned up.
### Configure a separate cluster queue for asynchronous query
@@ -36,16 +36,16 @@ In general, the same cluster queue can be used for asynchronous query and normal
2. Specify the queue used for asynchronous queries. Three levels are supported for designation, the priority from high to low is as follows:
- -Query level, specified by API request parameter `spark_queue`
- -Project level, specified by setting `kylin.query.async-query.spark-conf.spark.yarn.queue`
- -System level, specified by setting `kylin.query.async-query.spark-conf.spark.yarn.queue` in the configuration file `/conf/kylin.properties`
+ - Query level, specified by API request parameter `spark_queue`
+ - Project level, specified by setting `kylin.query.async-query.spark-conf.spark.yarn.queue`
+ - System level, specified by setting `kylin.query.async-query.spark-conf.spark.yarn.queue` in the configuration file `/conf/kylin.properties`
> **Tip**: If none of the three are configured, the default queue is `default`
3. Set configuration: `kylin.query.async-query.submit-hadoop-conf-dir=$KYLIN_HOME/async_query_hadoop_conf`
-4. Put the hadoop configuration of the asynchronous query cluster into the $KYLIN_HOME/async_query_hadoop_conf directory, and put the hive-site.xml for building the cluster into this directory.
- If Kerberos authentication is enabled, you need to copy the krb5.conf file to the $KYLIN_HOME/async_query_hadoop_conf directory.
+4. Put the hadoop configuration of the asynchronous query cluster into the `$KYLIN_HOME/async_query_hadoop_conf` directory, and put the hive-site.xml for building the cluster into this directory.
+ If Kerberos authentication is enabled, you need to copy the `krb5.conf` file to the `$KYLIN_HOME/async_query_hadoop_conf` directory.
5. If Kerberos authentication is enabled between asynchronous query cluster, query cluster, and build cluster, the following additional configuration is required:
diff --git a/website/docs/query/insight/images/data_sql/date_sql1.en.png b/website/docs/query/insight/images/data_sql/date_sql1.en.png
deleted file mode 100644
index f407c6fa99..0000000000
Binary files a/website/docs/query/insight/images/data_sql/date_sql1.en.png and /dev/null differ
diff --git a/website/docs/query/insight/images/data_sql/date_sql1.png b/website/docs/query/insight/images/data_sql/date_sql1.png
new file mode 100644
index 0000000000..1c1118ec81
Binary files /dev/null and b/website/docs/query/insight/images/data_sql/date_sql1.png differ
diff --git a/website/docs/query/insight/images/data_sql/date_sql2.en.png b/website/docs/query/insight/images/data_sql/date_sql2.en.png
deleted file mode 100644
index e2b18d2fc5..0000000000
Binary files a/website/docs/query/insight/images/data_sql/date_sql2.en.png and /dev/null differ
diff --git a/website/docs/query/insight/images/data_sql/date_sql2.png b/website/docs/query/insight/images/data_sql/date_sql2.png
new file mode 100644
index 0000000000..292d4c0d27
Binary files /dev/null and b/website/docs/query/insight/images/data_sql/date_sql2.png differ
diff --git a/website/docs/query/insight/images/insight/insight_input_query.png b/website/docs/query/insight/images/insight/insight_input_query.png
index 901914ea51..87bf74768c 100644
Binary files a/website/docs/query/insight/images/insight/insight_input_query.png and b/website/docs/query/insight/images/insight/insight_input_query.png differ
diff --git a/website/docs/query/insight/images/insight/insight_save_query.png b/website/docs/query/insight/images/insight/insight_save_query.png
index abb2d3abb3..ed70dd27ae 100644
Binary files a/website/docs/query/insight/images/insight/insight_save_query.png and b/website/docs/query/insight/images/insight/insight_save_query.png differ
diff --git a/website/docs/query/insight/images/insight/insight_show_result.png b/website/docs/query/insight/images/insight/insight_show_result.png
index 075d114339..28420f4f91 100644
Binary files a/website/docs/query/insight/images/insight/insight_show_result.png and b/website/docs/query/insight/images/insight/insight_show_result.png differ
diff --git a/website/docs/query/insight/images/insight/insight_step_duration1.png b/website/docs/query/insight/images/insight/insight_step_duration1.png
index 39c0cabc13..8757d8c702 100644
Binary files a/website/docs/query/insight/images/insight/insight_step_duration1.png and b/website/docs/query/insight/images/insight/insight_step_duration1.png differ
diff --git a/website/docs/query/insight/images/insight/insight_stop_query.en.png b/website/docs/query/insight/images/insight/insight_stop_query.en.png
deleted file mode 100644
index a2cdf9401f..0000000000
Binary files a/website/docs/query/insight/images/insight/insight_stop_query.en.png and /dev/null differ
diff --git a/website/docs/query/insight/images/insight/insight_stop_query.png b/website/docs/query/insight/images/insight/insight_stop_query.png
new file mode 100644
index 0000000000..2dd0bef65a
Binary files /dev/null and b/website/docs/query/insight/images/insight/insight_stop_query.png differ
diff --git a/website/docs/query/insight/images/insight/insight_stop_query_result.en.png b/website/docs/query/insight/images/insight/insight_stop_query_result.en.png
deleted file mode 100644
index d467061575..0000000000
Binary files a/website/docs/query/insight/images/insight/insight_stop_query_result.en.png and /dev/null differ
diff --git a/website/docs/query/insight/images/insight/insight_stop_query_result.png b/website/docs/query/insight/images/insight/insight_stop_query_result.png
new file mode 100644
index 0000000000..7599cac5c8
Binary files /dev/null and b/website/docs/query/insight/images/insight/insight_stop_query_result.png differ
diff --git a/website/docs/query/insight/images/spec/1.png b/website/docs/query/insight/images/spec/1.png
index 6d689ceb30..4f157e6436 100644
Binary files a/website/docs/query/insight/images/spec/1.png and b/website/docs/query/insight/images/spec/1.png differ
diff --git a/website/docs/query/insight/images/spec/4.en.png b/website/docs/query/insight/images/spec/4.en.png
deleted file mode 100644
index 3422547389..0000000000
Binary files a/website/docs/query/insight/images/spec/4.en.png and /dev/null differ
diff --git a/website/docs/query/insight/images/spec/4.png b/website/docs/query/insight/images/spec/4.png
new file mode 100644
index 0000000000..0b3debbd4f
Binary files /dev/null and b/website/docs/query/insight/images/spec/4.png differ
diff --git a/website/docs/query/insight/images/spec/5.png b/website/docs/query/insight/images/spec/5.png
index fd41e4abb6..c61eb6241b 100644
Binary files a/website/docs/query/insight/images/spec/5.png and b/website/docs/query/insight/images/spec/5.png differ
diff --git a/website/docs/query/insight/images/spec/6.png b/website/docs/query/insight/images/spec/6.png
index 09612b034b..bf34980769 100644
Binary files a/website/docs/query/insight/images/spec/6.png and b/website/docs/query/insight/images/spec/6.png differ
diff --git a/website/docs/query/insight/images/spec/7.png b/website/docs/query/insight/images/spec/7.png
deleted file mode 100644
index 1a9f54a920..0000000000
Binary files a/website/docs/query/insight/images/spec/7.png and /dev/null differ
diff --git a/website/docs/query/insight/images/spec/8.png b/website/docs/query/insight/images/spec/8.png
deleted file mode 100644
index 62d1d542ea..0000000000
Binary files a/website/docs/query/insight/images/spec/8.png and /dev/null differ
diff --git a/website/docs/query/insight/insight.md b/website/docs/query/insight/insight.md
index 7878b557b8..935ee2b71f 100644
--- a/website/docs/query/insight/insight.md
+++ b/website/docs/query/insight/insight.md
@@ -52,11 +52,11 @@ When you need to optimize for slow queries, you should analyze the query's speci
After clicking the **Run Query** button, click the **Stop** button in the same position to stop the query.
-
+
After the query is stopped, query ID and error message will be displayed.
-
+
In addition, clicking the **Close** button of the query will also stop the query.
@@ -92,9 +92,7 @@ Support chart type: Line Chart, Bar Chart, Pie Chart.
### Other ways to execute SQL queries
-- [Integration with BI tools](../../integration/intro.md)
-
-
+- [Integration with BI tools](#TODO)
### Notices
diff --git a/website/docs/query/insight/intro.md b/website/docs/query/insight/intro.md
index 29386b0bbb..eea6bba7ff 100644
--- a/website/docs/query/insight/intro.md
+++ b/website/docs/query/insight/intro.md
@@ -15,7 +15,7 @@ last_update:
---
-kylin offers an Intelligent OLAP Platform for big data to simplify multidimensional analytics for cloud data lake. kylin finishes data loading and precomputation with the index building jobs and delivers sub-second query latency on massive dataset.
+kylin offers an Intelligent OLAP Platform for big data to simplify multidimensional analytics. kylin finishes data loading and precomputation with the index building jobs and delivers sub-second query latencydelivers sub-second query latency on massive dataset.
Unlike the execution process of regular queries, kylin will be using precalculated data to answer queries instead of doing the calculation online, which will improve query performance significantly.
@@ -37,7 +37,7 @@ Different from regular query engines, kylin uses precalculated results to replac
3. If all the `FROM` clauses match successfully, kylin will execute the query using index data.
- All the `FROM` clauses will be replaced by precalculated results, and the query will execute from there to get the final result. If you execute queries via Web UI, you can find the name(s) of the answering model(s) in the **Answered By** field after a query returns successfully. For more details, please refer to [Execute SQL Query in Web UI](insight.en.md).
+ All the `FROM` clauses will be replaced by precalculated results, and the query will execute from there to get the final result. If you execute queries via Web UI, you can find the name(s) of the answering model(s) in the **Answered By** field after a query returns successfully. For more details, please refer to [Execute SQL Query in Web UI](insight.md).
4. If there is one or more `FROM` clause cannot find a matching index, then kylin cannot execute the query using index data.x
diff --git a/website/docs/query/insight/sql_spec.md b/website/docs/query/insight/sql_spec.md
index 5675d3af11..1009841bb9 100755
--- a/website/docs/query/insight/sql_spec.md
+++ b/website/docs/query/insight/sql_spec.md
@@ -108,7 +108,7 @@ windowSpec:
')'
```
-> **Notice:** the versions of the realization may be different. Feel free to contact the technical support team if you have any questions.
+> **Notice:** the versions of the realization may be different. Feel free to contact the Kylin Community if you have any questions.
@@ -141,7 +141,7 @@ For example, table *DATES* contains column *YEAR* that overlap with kylin's keyw
You can just include the column with double-quotes to get the right result.
-
+
@@ -167,7 +167,7 @@ from SSB.P_LINEORDER
where LO_ORDERDATE = date '1992-06-03'
```
-
+
or
@@ -177,4 +177,4 @@ from SSB.P_LINEORDER
where LO_ORDERDATE = cast ( '1992-06-03' as date)
```
-
+
diff --git a/website/docs/query/optimization/query_enhanced.md b/website/docs/query/optimization/query_enhanced.md
index 5c99587daf..d974262e19 100644
--- a/website/docs/query/optimization/query_enhanced.md
+++ b/website/docs/query/optimization/query_enhanced.md
@@ -18,7 +18,7 @@ By default in Kylin, the relationship between tables in the query SQL must be co
But in some cases, part of `Left Join` queries can be semantically equivalently transformed into `Inner Join` queries, so we provide configuration parameters that allow users to use `Left Join` model to answer equivalent semantics `Inner Join` query.
-The configuration parameters starts to take effect from version of Kylin 4.2.4, which is closed by default.
+The configuration parameters starts to take effect from version of Kylin 5.0, which is closed by default.
diff --git a/website/docs/query/optimization/segment_pruning.md b/website/docs/query/optimization/segment_pruning.md
index 5fa0ff0667..1071db67ed 100644
--- a/website/docs/query/optimization/segment_pruning.md
+++ b/website/docs/query/optimization/segment_pruning.md
@@ -21,7 +21,7 @@ Starting from Kylin 5.0, we support the calculation of the dimension value range
This optimization is enable by default. Under normal circumstances, you do not need to pay attention to this optimization. In some extreme cases, system-level or project-level shutdown is supported.
-To disable it on the system level, configure the parameters in `$KYLIN_HOME/conf/kylin.properties` . To disable it on project level, add the configuration in **Setting-Advanced Settings-Custom Project Configuration**.
+To disable it on the system level, configure the parameters in `$KYLIN_HOME/conf/kylin.properties` . To disable it on project level, add the configuration in **Setting -> Advanced Settings -> Custom Project Configuration**.
`kylin.storage.columnar.dimension-range-filter-enabled=false`
diff --git a/website/docs/query/pushdown/images/query_pushdown.png b/website/docs/query/pushdown/images/query_pushdown.png
index 157744ad95..8185fcf753 100644
Binary files a/website/docs/query/pushdown/images/query_pushdown.png and b/website/docs/query/pushdown/images/query_pushdown.png differ
diff --git a/website/docs/query/pushdown/images/query_pushdown_spark.png b/website/docs/query/pushdown/images/query_pushdown_spark.png
deleted file mode 100644
index f396d6194b..0000000000
Binary files a/website/docs/query/pushdown/images/query_pushdown_spark.png and /dev/null differ
diff --git a/website/docs/snapshot/images/snapshot_1.png b/website/docs/snapshot/images/snapshot_1.png
new file mode 100644
index 0000000000..8ecd529ccb
Binary files /dev/null and b/website/docs/snapshot/images/snapshot_1.png differ
diff --git a/website/docs/snapshot/images/snapshot_1_en.png b/website/docs/snapshot/images/snapshot_1_en.png
deleted file mode 100644
index 15d4af5d7e..0000000000
Binary files a/website/docs/snapshot/images/snapshot_1_en.png and /dev/null differ
diff --git a/website/docs/snapshot/images/snapshot_2.png b/website/docs/snapshot/images/snapshot_2.png
new file mode 100644
index 0000000000..5bfc80615e
Binary files /dev/null and b/website/docs/snapshot/images/snapshot_2.png differ
diff --git a/website/docs/snapshot/images/snapshot_2_en.png b/website/docs/snapshot/images/snapshot_2_en.png
deleted file mode 100644
index 9101022d56..0000000000
Binary files a/website/docs/snapshot/images/snapshot_2_en.png and /dev/null differ
diff --git a/website/docs/snapshot/images/snapshot_3.png b/website/docs/snapshot/images/snapshot_3.png
new file mode 100644
index 0000000000..ee8cceab8b
Binary files /dev/null and b/website/docs/snapshot/images/snapshot_3.png differ
diff --git a/website/docs/snapshot/images/snapshot_3_en.png b/website/docs/snapshot/images/snapshot_3_en.png
deleted file mode 100644
index 9317403ccc..0000000000
Binary files a/website/docs/snapshot/images/snapshot_3_en.png and /dev/null differ
diff --git a/website/docs/snapshot/images/snapshot_4.png b/website/docs/snapshot/images/snapshot_4.png
new file mode 100644
index 0000000000..458e36fbc8
Binary files /dev/null and b/website/docs/snapshot/images/snapshot_4.png differ
diff --git a/website/docs/snapshot/images/snapshot_4_en.png b/website/docs/snapshot/images/snapshot_4_en.png
deleted file mode 100644
index b4b75e4b74..0000000000
Binary files a/website/docs/snapshot/images/snapshot_4_en.png and /dev/null differ
diff --git a/website/docs/snapshot/images/snapshot_5.png b/website/docs/snapshot/images/snapshot_5.png
new file mode 100644
index 0000000000..b705da8f58
Binary files /dev/null and b/website/docs/snapshot/images/snapshot_5.png differ
diff --git a/website/docs/snapshot/images/snapshot_5_en.png b/website/docs/snapshot/images/snapshot_5_en.png
deleted file mode 100644
index 47e88a2405..0000000000
Binary files a/website/docs/snapshot/images/snapshot_5_en.png and /dev/null differ
diff --git a/website/docs/snapshot/images/snapshot_6.png b/website/docs/snapshot/images/snapshot_6.png
new file mode 100644
index 0000000000..7991810968
Binary files /dev/null and b/website/docs/snapshot/images/snapshot_6.png differ
diff --git a/website/docs/snapshot/images/snapshot_6_en.png b/website/docs/snapshot/images/snapshot_6_en.png
deleted file mode 100644
index 5f11b66a25..0000000000
Binary files a/website/docs/snapshot/images/snapshot_6_en.png and /dev/null differ
diff --git a/website/docs/snapshot/images/snapshot_7.png b/website/docs/snapshot/images/snapshot_7.png
new file mode 100644
index 0000000000..7b9852f833
Binary files /dev/null and b/website/docs/snapshot/images/snapshot_7.png differ
diff --git a/website/docs/snapshot/images/snapshot_7_en.png b/website/docs/snapshot/images/snapshot_7_en.png
deleted file mode 100644
index 11963c604e..0000000000
Binary files a/website/docs/snapshot/images/snapshot_7_en.png and /dev/null differ
diff --git a/website/docs/snapshot/images/snapshot_8.png b/website/docs/snapshot/images/snapshot_8.png
new file mode 100644
index 0000000000..ef2db1f0c6
Binary files /dev/null and b/website/docs/snapshot/images/snapshot_8.png differ
diff --git a/website/docs/snapshot/images/snapshot_8_en.png b/website/docs/snapshot/images/snapshot_8_en.png
deleted file mode 100644
index e2fb1f5b2a..0000000000
Binary files a/website/docs/snapshot/images/snapshot_8_en.png and /dev/null differ
diff --git a/website/docs/snapshot/images/snapshot_9.png b/website/docs/snapshot/images/snapshot_9.png
new file mode 100644
index 0000000000..afe9d59a61
Binary files /dev/null and b/website/docs/snapshot/images/snapshot_9.png differ
diff --git a/website/docs/snapshot/images/snapshot_9_en.png b/website/docs/snapshot/images/snapshot_9_en.png
deleted file mode 100644
index dcfe0f42d0..0000000000
Binary files a/website/docs/snapshot/images/snapshot_9_en.png and /dev/null differ
diff --git a/website/docs/snapshot/snapshot_management.md b/website/docs/snapshot/snapshot_management.md
index 6f75c0f059..ce13c8959c 100644
--- a/website/docs/snapshot/snapshot_management.md
+++ b/website/docs/snapshot/snapshot_management.md
@@ -32,11 +32,11 @@ The snapshot management is disabled by default. You can enable it in advanced se
1. Navigate to **Settings -> Advanced Settings -> Snapshot Management**, turn on **Support Snapshot Management**.
- 
+ 
- 
+ 
- 
+ 
**Note**:
@@ -50,7 +50,7 @@ The snapshot management is disabled by default. You can enable it in advanced se
2. Navigate to **Data Asset -> Snapshot**, the snapshot list will be displayed, as shown below:
- 
+ 
**Fields Explanation:**
@@ -76,7 +76,7 @@ Above the snapshot lis are the operation buttons. Specific actions are listed be
- **Add Snapshots**：Select tables or databases to build snapshots. Click **Next** to set partition columns.
- 
+ 
Next, set the snapshot partition columns. Setting snapshot partition columns can improve the building speed by building partitions in parallel to a certain extent. By default, the system will build in a non-partitioned manner. Users can also set or detect partition columns , Also support specified partition value refresh.
> **Note**:
@@ -85,23 +85,23 @@ Above the snapshot lis are the operation buttons. Specific actions are listed be
>
> - Building in partitions can only increase the speed of the building task, and the result of the built snapshot is still full data.
- 
+ 
- **Refresh Snapshots**：Select snapshots to refresh.
- Full refresh: The refresh operation at this time builds the latest and full snapshot.
- Incremental refresh: For snapshots with source table partitions set, only the newly added partition value data will be refreshed (the built historical data will not be refreshed). It is recommended to select when the historical data is not updated.
- Custom partition value refresh: Specify single or multiple partition values for data refresh.
- 
+ 
- **Delete Snapshots**：Select snapshots to delete. It will discard all jobs related to the snapshots.
- 
+ 
- **Repair Snapshots**: When the source table has a structural change and is reloaded, the corresponding snapshot will change to "BROKEN" and can be repaired.
- 
+ 
According building tasks of snapshot，you can configure spark related configurations in `kylin.properties` to achieve more fine-grained control.（These configuration can be overridden at project level）