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 <[email protected]>
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）
