This is an automated email from the ASF dual-hosted git repository.
luzhijing pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new ee05517c96e8 [Doc](timezone) Update the method for updating the
tzfiles (#451)
ee05517c96e8 is described below
commit ee05517c96e8e964da665682152677401297543a
Author: zclllyybb <zhaochan...@selectdb.com>
AuthorDate: Fri Mar 22 09:54:36 2024 +0800
[Doc](timezone) Update the method for updating the tzfiles (#451)
---
docs/advanced/time-zone.md | 31 +++++++++++++++++++++-
.../current/advanced/time-zone.md | 31 +++++++++++++++++++++-
.../version-2.0/query/query-variables/time-zone.md | 31 +++++++++++++++++++++-
.../version-2.1/advanced/time-zone.md | 31 +++++++++++++++++++++-
.../version-2.0/query/query-variables/time-zone.md | 31 +++++++++++++++++++++-
versioned_docs/version-2.1/advanced/time-zone.md | 31 +++++++++++++++++++++-
6 files changed, 180 insertions(+), 6 deletions(-)
diff --git a/docs/advanced/time-zone.md b/docs/advanced/time-zone.md
index 6a102abe8932..06f87579e3c2 100644
--- a/docs/advanced/time-zone.md
+++ b/docs/advanced/time-zone.md
@@ -174,7 +174,36 @@ In summary, the best practice for dealing with time zone
issues is to:
### Daylight Saving Time
-The start and end times for Daylight Saving Time are taken from the [current
time zone data source](#data-source) and may not necessarily correspond exactly
to the actual officially recognised times for the current year's time zone
location. This data is maintained by ICANN. If you need to ensure that Daylight
Saving Time behaves as specified for the current year, please make sure that
data source selected by Doris is the latest ICANN published time zone data,
which could be downloaded a [...]
+The start and end times for Daylight Saving Time are taken from the [current
time zone data source](#data-source) and may not necessarily correspond exactly
to the actual officially recognised times for the current year's time zone
location. This data is maintained by ICANN. If you need to ensure that Daylight
Saving Time behaves as specified for the current year, please make sure that
data source selected by Doris is the latest ICANN published time zone data. See
below for download access.
+
+### Data update
+
+Real-world time zone and daylight saving time data may change from time to
time for a variety of reasons, and IANA periodically records these changes and
updates the corresponding time zone files. If you want the time zone
information in Doris to be up to date with the latest IANA data, do one of the
followings:
+
+1. Use the Package Manager to update
+
+Depending on the package manager used by the current operating system, you can
update the time zone data directly using the corresponding command:
+
+```shell
+# yum
+> sudo yum update tzdata
+# apt
+> sudo apt update tzdata
+```
+
+The data updated in this way is located under the system `$TZDIR` (typically
`usr/share/zoneinfo`). If `use_doris_tzfile = true`, the user should overwrite
it to the `zoneinfo` directory in the BE deployment directory.
+
+2. pull the IANA time zone database manually (recommended)
+
+Most Linux distributions have a package manager where tzdata is not
synchronised in a timely manner. If the accuracy of the time zone data is
important, you can pull the data published by IANA on a regular basis:
+
+```shell
+wget https://www.iana.org/time-zones/repository/tzdb-latest.tar.lz
+```
+
+Then generate the specific zoneinfo data according the README file in the
extracted folder. The generated data should be copied to `$TZDIR` or to the BE
deployment directory, depending on the value of the BE config
`use_doris_tzfile`.
+
+Please note that all the above operations **must** be restarted **on the
corresponding BE to take effect after they are done on the BE machine.
## Extended Reading
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/advanced/time-zone.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/advanced/time-zone.md
index d1e8ffe4be5b..b0cddce3f35b 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/advanced/time-zone.md
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/advanced/time-zone.md
@@ -170,7 +170,36 @@ mysql> select * from dtv23;
### 夏令时
-夏令时的起讫时间来自于[当前时区数据源](#数据来源)，不一定与当年度时区所在地官方实际确认时间完全一致。该数据由 ICANN
进行维护。如果需要确保夏令时表现与当年度实际规定一致，请保证 Doris 所选择的数据源为最新的 ICANN
所公布时区数据，下载途径见于[拓展阅读](#拓展阅读)中。
+夏令时的起讫时间来自于[当前时区数据源](#数据来源)，不一定与当年度时区所在地官方实际确认时间完全一致。该数据由 ICANN
进行维护。如果需要确保夏令时表现与当年度实际规定一致，请保证 Doris 所选择的数据源为最新的 ICANN 所公布时区数据，下载途径见下文。
+
+### 数据更新
+
+真实世界中的时区与夏令时相关数据，将会因各种原因而不定期发生变化。IANA 会定期记录这些变化并更新相应时区文件。如果希望 Doris
中的时区信息与最新的IANA 数据保持一致，请采取下列方式进行更新：
+
+1. 使用包管理器更新
+
+根据当前操作系统使用的包管理器，用户可以使用对应的命令直接更新时区数据：
+
+```shell
+# yum
+> sudo yum update tzdata
+# apt
+> sudo apt update tzdata
+```
+
+该方式更新的数据位于系统 `$TZDIR` 下（一般为 `usr/share/zoneinfo`）。如果 `use_doris_tzfile =
true`，则用户应当将其覆盖至 BE 部署目录下的 `zoneinfo` 目录。
+
+2. 直接拉取 IANA 时区数据库（推荐）
+
+大多数 Linux 发行版的包管理器，tzdata 的同步并不及时。如果对时区数据准确性要求较高，可以直接拉取 IANA 定期公布的数据：
+
+```shell
+wget https://www.iana.org/time-zones/repository/tzdb-latest.tar.lz
+```
+
+然后根据解压后文件夹中的 README 文件，生成具体的 zoneinfo 数据。生成的数据应当拷贝至 `$TZDIR` 还是 BE 部署目录，取决于 BE
config `use_doris_tzfile` 的值。
+
+请注意，以上所有操作在 BE 所在机器上完成后，都**必须重启**对应 BE 才能生效。
## 拓展阅读
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/query/query-variables/time-zone.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/query/query-variables/time-zone.md
index 6c92d9053134..8ea5b396f73b 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/query/query-variables/time-zone.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/query/query-variables/time-zone.md
@@ -187,7 +187,36 @@ mysql> select * from dtv23;
### 夏令时
-夏令时的起讫时间来自于[当前时区数据源](#数据来源)，不一定与当年度时区所在地官方实际确认时间完全一致。该数据由 ICANN
进行维护。如果需要确保夏令时表现与当年度实际规定一致，请保证 Doris 所选择的数据源为最新的 ICANN
所公布时区数据，下载途径见于[拓展阅读](#拓展阅读)中。
+夏令时的起讫时间来自于[当前时区数据源](#数据来源)，不一定与当年度时区所在地官方实际确认时间完全一致。该数据由 ICANN
进行维护。如果需要确保夏令时表现与当年度实际规定一致，请保证 Doris 所选择的数据源为最新的 ICANN 所公布时区数据，下载途径见下文。
+
+### 数据更新
+
+真实世界中的时区与夏令时相关数据，将会因各种原因而不定期发生变化。IANA 会定期记录这些变化并更新相应时区文件。如果希望 Doris
中的时区信息与最新的IANA 数据保持一致，请采取下列方式进行更新：
+
+1. 使用包管理器更新
+
+根据当前操作系统使用的包管理器，用户可以使用对应的命令直接更新时区数据：
+
+```shell
+# yum
+> sudo yum update tzdata
+# apt
+> sudo apt update tzdata
+```
+
+该方式更新的数据位于系统 `$TZDIR` 下（一般为 `usr/share/zoneinfo`）。如果 `use_doris_tzfile =
true`，则用户应当将其覆盖至 BE 部署目录下的 `zoneinfo` 目录。
+
+2. 直接拉取 IANA 时区数据库（推荐）
+
+大多数 Linux 发行版的包管理器，tzdata 的同步并不及时。如果对时区数据准确性要求较高，可以直接拉取 IANA 定期公布的数据：
+
+```shell
+wget https://www.iana.org/time-zones/repository/tzdb-latest.tar.lz
+```
+
+然后根据解压后文件夹中的 README 文件，生成具体的 zoneinfo 数据。生成的数据应当拷贝至 `$TZDIR` 还是 BE 部署目录，取决于 BE
config `use_doris_tzfile` 的值。
+
+请注意，以上所有操作在 BE 所在机器上完成后，都**必须重启**对应 BE 才能生效。
## 拓展阅读
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/advanced/time-zone.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/advanced/time-zone.md
index d1e8ffe4be5b..b0cddce3f35b 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/advanced/time-zone.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/advanced/time-zone.md
@@ -170,7 +170,36 @@ mysql> select * from dtv23;
### 夏令时
-夏令时的起讫时间来自于[当前时区数据源](#数据来源)，不一定与当年度时区所在地官方实际确认时间完全一致。该数据由 ICANN
进行维护。如果需要确保夏令时表现与当年度实际规定一致，请保证 Doris 所选择的数据源为最新的 ICANN
所公布时区数据，下载途径见于[拓展阅读](#拓展阅读)中。
+夏令时的起讫时间来自于[当前时区数据源](#数据来源)，不一定与当年度时区所在地官方实际确认时间完全一致。该数据由 ICANN
进行维护。如果需要确保夏令时表现与当年度实际规定一致，请保证 Doris 所选择的数据源为最新的 ICANN 所公布时区数据，下载途径见下文。
+
+### 数据更新
+
+真实世界中的时区与夏令时相关数据，将会因各种原因而不定期发生变化。IANA 会定期记录这些变化并更新相应时区文件。如果希望 Doris
中的时区信息与最新的IANA 数据保持一致，请采取下列方式进行更新：
+
+1. 使用包管理器更新
+
+根据当前操作系统使用的包管理器，用户可以使用对应的命令直接更新时区数据：
+
+```shell
+# yum
+> sudo yum update tzdata
+# apt
+> sudo apt update tzdata
+```
+
+该方式更新的数据位于系统 `$TZDIR` 下（一般为 `usr/share/zoneinfo`）。如果 `use_doris_tzfile =
true`，则用户应当将其覆盖至 BE 部署目录下的 `zoneinfo` 目录。
+
+2. 直接拉取 IANA 时区数据库（推荐）
+
+大多数 Linux 发行版的包管理器，tzdata 的同步并不及时。如果对时区数据准确性要求较高，可以直接拉取 IANA 定期公布的数据：
+
+```shell
+wget https://www.iana.org/time-zones/repository/tzdb-latest.tar.lz
+```
+
+然后根据解压后文件夹中的 README 文件，生成具体的 zoneinfo 数据。生成的数据应当拷贝至 `$TZDIR` 还是 BE 部署目录，取决于 BE
config `use_doris_tzfile` 的值。
+
+请注意，以上所有操作在 BE 所在机器上完成后，都**必须重启**对应 BE 才能生效。
## 拓展阅读
diff --git a/versioned_docs/version-2.0/query/query-variables/time-zone.md
b/versioned_docs/version-2.0/query/query-variables/time-zone.md
index 6a102abe8932..06f87579e3c2 100644
--- a/versioned_docs/version-2.0/query/query-variables/time-zone.md
+++ b/versioned_docs/version-2.0/query/query-variables/time-zone.md
@@ -174,7 +174,36 @@ In summary, the best practice for dealing with time zone
issues is to:
### Daylight Saving Time
-The start and end times for Daylight Saving Time are taken from the [current
time zone data source](#data-source) and may not necessarily correspond exactly
to the actual officially recognised times for the current year's time zone
location. This data is maintained by ICANN. If you need to ensure that Daylight
Saving Time behaves as specified for the current year, please make sure that
data source selected by Doris is the latest ICANN published time zone data,
which could be downloaded a [...]
+The start and end times for Daylight Saving Time are taken from the [current
time zone data source](#data-source) and may not necessarily correspond exactly
to the actual officially recognised times for the current year's time zone
location. This data is maintained by ICANN. If you need to ensure that Daylight
Saving Time behaves as specified for the current year, please make sure that
data source selected by Doris is the latest ICANN published time zone data. See
below for download access.
+
+### Data update
+
+Real-world time zone and daylight saving time data may change from time to
time for a variety of reasons, and IANA periodically records these changes and
updates the corresponding time zone files. If you want the time zone
information in Doris to be up to date with the latest IANA data, do one of the
followings:
+
+1. Use the Package Manager to update
+
+Depending on the package manager used by the current operating system, you can
update the time zone data directly using the corresponding command:
+
+```shell
+# yum
+> sudo yum update tzdata
+# apt
+> sudo apt update tzdata
+```
+
+The data updated in this way is located under the system `$TZDIR` (typically
`usr/share/zoneinfo`). If `use_doris_tzfile = true`, the user should overwrite
it to the `zoneinfo` directory in the BE deployment directory.
+
+2. pull the IANA time zone database manually (recommended)
+
+Most Linux distributions have a package manager where tzdata is not
synchronised in a timely manner. If the accuracy of the time zone data is
important, you can pull the data published by IANA on a regular basis:
+
+```shell
+wget https://www.iana.org/time-zones/repository/tzdb-latest.tar.lz
+```
+
+Then generate the specific zoneinfo data according the README file in the
extracted folder. The generated data should be copied to `$TZDIR` or to the BE
deployment directory, depending on the value of the BE config
`use_doris_tzfile`.
+
+Please note that all the above operations **must** be restarted **on the
corresponding BE to take effect after they are done on the BE machine.
## Extended Reading
diff --git a/versioned_docs/version-2.1/advanced/time-zone.md
b/versioned_docs/version-2.1/advanced/time-zone.md
index 6a102abe8932..06f87579e3c2 100644
--- a/versioned_docs/version-2.1/advanced/time-zone.md
+++ b/versioned_docs/version-2.1/advanced/time-zone.md
@@ -174,7 +174,36 @@ In summary, the best practice for dealing with time zone
issues is to:
### Daylight Saving Time
-The start and end times for Daylight Saving Time are taken from the [current
time zone data source](#data-source) and may not necessarily correspond exactly
to the actual officially recognised times for the current year's time zone
location. This data is maintained by ICANN. If you need to ensure that Daylight
Saving Time behaves as specified for the current year, please make sure that
data source selected by Doris is the latest ICANN published time zone data,
which could be downloaded a [...]
+The start and end times for Daylight Saving Time are taken from the [current
time zone data source](#data-source) and may not necessarily correspond exactly
to the actual officially recognised times for the current year's time zone
location. This data is maintained by ICANN. If you need to ensure that Daylight
Saving Time behaves as specified for the current year, please make sure that
data source selected by Doris is the latest ICANN published time zone data. See
below for download access.
+
+### Data update
+
+Real-world time zone and daylight saving time data may change from time to
time for a variety of reasons, and IANA periodically records these changes and
updates the corresponding time zone files. If you want the time zone
information in Doris to be up to date with the latest IANA data, do one of the
followings:
+
+1. Use the Package Manager to update
+
+Depending on the package manager used by the current operating system, you can
update the time zone data directly using the corresponding command:
+
+```shell
+# yum
+> sudo yum update tzdata
+# apt
+> sudo apt update tzdata
+```
+
+The data updated in this way is located under the system `$TZDIR` (typically
`usr/share/zoneinfo`). If `use_doris_tzfile = true`, the user should overwrite
it to the `zoneinfo` directory in the BE deployment directory.
+
+2. pull the IANA time zone database manually (recommended)
+
+Most Linux distributions have a package manager where tzdata is not
synchronised in a timely manner. If the accuracy of the time zone data is
important, you can pull the data published by IANA on a regular basis:
+
+```shell
+wget https://www.iana.org/time-zones/repository/tzdb-latest.tar.lz
+```
+
+Then generate the specific zoneinfo data according the README file in the
extracted folder. The generated data should be copied to `$TZDIR` or to the BE
deployment directory, depending on the value of the BE config
`use_doris_tzfile`.
+
+Please note that all the above operations **must** be restarted **on the
corresponding BE to take effect after they are done on the BE machine.
## Extended Reading
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
