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 ef629140f7a [doc](data-type) fix decimal type storeage(bytes) (#841)
ef629140f7a is described below
commit ef629140f7af81208c50484c35d0e753dcc07cbe
Author: Ibson <[email protected]>
AuthorDate: Wed Jul 10 14:24:51 2024 +0800
[doc](data-type) fix decimal type storeage(bytes) (#841)
data type decimal storeage bytes should be 4/8/16 not 2004/8/16
Co-authored-by: pusheng.li01 <[email protected]>
---
docs/table-design/data-type.md | 2 +-
.../docusaurus-plugin-content-docs/current/table-design/data-type.md | 2 +-
.../version-2.0/table-design/data-type.md | 2 +-
.../version-2.1/table-design/data-type.md | 2 +-
versioned_docs/version-2.0/table-design/data-type.md | 2 +-
versioned_docs/version-2.1/table-design/data-type.md | 2 +-
6 files changed, 6 insertions(+), 6 deletions(-)
diff --git a/docs/table-design/data-type.md b/docs/table-design/data-type.md
index 281aba8bafa..0cfb9e8f553 100644
--- a/docs/table-design/data-type.md
+++ b/docs/table-design/data-type.md
@@ -38,7 +38,7 @@ The list of data types supported by Doris is as follows:
| LARGEINT | 16 | Integer value, range [-2 ^ 127 + 1~ 2 ^
127 - 1]. |
| FLOAT | 4 | Single precision, a floating ponit
number, range [-3.4 * 10 ^ 38~ 3.4 * 10 ^ 38]. |
| DOUBLE | 8 | Double precision, a floating ponit
number, range [-1.79 * 10 ^ 308~ 1.79 * 10 ^ 308] |
-| DECIMAL | 2004/8/16 | An exact fixed-point number, defined by
its precision (total number of digits) and scale (number of digits to the right
of the decimal point). Format:DECIMAL(M[,D]), M stands for precision, D
stands scale. The range for the significant digits M is [1, 38], while the
range for the decimal digits D is [0, precision]. The storage requirements for
different precision values are as follows: - When 0 < precision <= 9, it
occupies 4 bytes. - When 9 < pr [...]
+| DECIMAL | 4/8/16 | An exact fixed-point number, defined by
its precision (total number of digits) and scale (number of digits to the right
of the decimal point). Format:DECIMAL(M[,D]), M stands for precision, D
stands scale. The range for the significant digits M is [1, 38], while the
range for the decimal digits D is [0, precision]. The storage requirements for
different precision values are as follows: - When 0 < precision <= 9, it
occupies 4 bytes. - When 9 < pr [...]
| DATE | 16 | DATE holds values for a calendar year,
month and day, the supported range is ['0000-01-01', '9999-12-31']. Default
print format: 'yyyy-MM-dd'. |
| DATETIME | 16 | A DATE and TIME combination Format:
DATETIME ([P]). The optional parameter P represents time precision, with a
value range of [0,6], supporting up to 6 decimal places (microseconds). When
not set, it is 0. The supported range is ['0000-01-01 00:00:00 [.000000]',
'9999-12-31 23:59:59 [.999999]']. Default print format: 'yyy-MM-dd HH: mm:
ss. SSSSSS '. |
| CHAR | M | A FIXED length string, the parameter M
specifies the column length in characters. The range of M is from 1 to 255. |
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/data-type.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/data-type.md
index b6e9b6f95af..ab2039050a3 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/data-type.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/data-type.md
@@ -40,7 +40,7 @@ Apache Doris 已支持的数据类型列表如下：
| LARGEINT | 16 | 有符号整数，范围 [-2^127 + 1 ~ 2^127 - 1]。
|
| FLOAT | 4 | 浮点数，范围 [-3.4*10^38 ~ 3.4*10^38]。
|
| DOUBLE | 8 | 浮点数，范围 [-1.79*10^308 ~ 1.79*10^308]。
|
-| DECIMAL | 2004/8/16 | 高精度定点数，格式：DECIMAL(M[,D])。其中，M
代表一共有多少个有效数字（precision），D 代表小数位有多少数字（scale）。有效数字 M 的范围是 [1, 38]，小数位数字数量 D 的范围是
[0, precision]。 <p>0 < precision <= 9 的场合，占用 4 字节。</p> <p>9 < precision <= 18
的场合，占用 8 字节。</p> <p>16 < precision <= 38 的场合，占用 16 字节。</p> |
+| DECIMAL | 4/8/16 | 高精度定点数，格式：DECIMAL(M[,D])。其中，M
代表一共有多少个有效数字（precision），D 代表小数位有多少数字（scale）。有效数字 M 的范围是 [1, 38]，小数位数字数量 D 的范围是
[0, precision]。 <p>0 < precision <= 9 的场合，占用 4 字节。</p> <p>9 < precision <= 18
的场合，占用 8 字节。</p> <p>16 < precision <= 38 的场合，占用 16 字节。</p> |
| DATE | 16 | 日期类型，目前的取值范围是 ['0000-01-01',
'9999-12-31']，默认的打印形式是 'yyyy-MM-dd'。 |
| DATETIME | 16 | 日期时间类型，格式：DATETIME([P])。可选参数 P 表示时间精度，取值范围是 [0,
6]，即最多支持 6 位小数（微秒）。不设置时为 0。<p>取值范围是 ['0000-01-01 00:00:00[.000000]',
'9999-12-31 23:59:59[.999999]']。打印的形式是 'yyyy-MM-dd HH:mm:ss.SSSSSS'。 </p>|
| CHAR | M | 定长字符串，M 代表的是定长字符串的字节长度。M 的范围是 1-255。 |
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/table-design/data-type.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/table-design/data-type.md
index b6e9b6f95af..ab2039050a3 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/table-design/data-type.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/table-design/data-type.md
@@ -40,7 +40,7 @@ Apache Doris 已支持的数据类型列表如下：
| LARGEINT | 16 | 有符号整数，范围 [-2^127 + 1 ~ 2^127 - 1]。
|
| FLOAT | 4 | 浮点数，范围 [-3.4*10^38 ~ 3.4*10^38]。
|
| DOUBLE | 8 | 浮点数，范围 [-1.79*10^308 ~ 1.79*10^308]。
|
-| DECIMAL | 2004/8/16 | 高精度定点数，格式：DECIMAL(M[,D])。其中，M
代表一共有多少个有效数字（precision），D 代表小数位有多少数字（scale）。有效数字 M 的范围是 [1, 38]，小数位数字数量 D 的范围是
[0, precision]。 <p>0 < precision <= 9 的场合，占用 4 字节。</p> <p>9 < precision <= 18
的场合，占用 8 字节。</p> <p>16 < precision <= 38 的场合，占用 16 字节。</p> |
+| DECIMAL | 4/8/16 | 高精度定点数，格式：DECIMAL(M[,D])。其中，M
代表一共有多少个有效数字（precision），D 代表小数位有多少数字（scale）。有效数字 M 的范围是 [1, 38]，小数位数字数量 D 的范围是
[0, precision]。 <p>0 < precision <= 9 的场合，占用 4 字节。</p> <p>9 < precision <= 18
的场合，占用 8 字节。</p> <p>16 < precision <= 38 的场合，占用 16 字节。</p> |
| DATE | 16 | 日期类型，目前的取值范围是 ['0000-01-01',
'9999-12-31']，默认的打印形式是 'yyyy-MM-dd'。 |
| DATETIME | 16 | 日期时间类型，格式：DATETIME([P])。可选参数 P 表示时间精度，取值范围是 [0,
6]，即最多支持 6 位小数（微秒）。不设置时为 0。<p>取值范围是 ['0000-01-01 00:00:00[.000000]',
'9999-12-31 23:59:59[.999999]']。打印的形式是 'yyyy-MM-dd HH:mm:ss.SSSSSS'。 </p>|
| CHAR | M | 定长字符串，M 代表的是定长字符串的字节长度。M 的范围是 1-255。 |
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/data-type.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/data-type.md
index b6e9b6f95af..ab2039050a3 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/data-type.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/data-type.md
@@ -40,7 +40,7 @@ Apache Doris 已支持的数据类型列表如下：
| LARGEINT | 16 | 有符号整数，范围 [-2^127 + 1 ~ 2^127 - 1]。
|
| FLOAT | 4 | 浮点数，范围 [-3.4*10^38 ~ 3.4*10^38]。
|
| DOUBLE | 8 | 浮点数，范围 [-1.79*10^308 ~ 1.79*10^308]。
|
-| DECIMAL | 2004/8/16 | 高精度定点数，格式：DECIMAL(M[,D])。其中，M
代表一共有多少个有效数字（precision），D 代表小数位有多少数字（scale）。有效数字 M 的范围是 [1, 38]，小数位数字数量 D 的范围是
[0, precision]。 <p>0 < precision <= 9 的场合，占用 4 字节。</p> <p>9 < precision <= 18
的场合，占用 8 字节。</p> <p>16 < precision <= 38 的场合，占用 16 字节。</p> |
+| DECIMAL | 4/8/16 | 高精度定点数，格式：DECIMAL(M[,D])。其中，M
代表一共有多少个有效数字（precision），D 代表小数位有多少数字（scale）。有效数字 M 的范围是 [1, 38]，小数位数字数量 D 的范围是
[0, precision]。 <p>0 < precision <= 9 的场合，占用 4 字节。</p> <p>9 < precision <= 18
的场合，占用 8 字节。</p> <p>16 < precision <= 38 的场合，占用 16 字节。</p> |
| DATE | 16 | 日期类型，目前的取值范围是 ['0000-01-01',
'9999-12-31']，默认的打印形式是 'yyyy-MM-dd'。 |
| DATETIME | 16 | 日期时间类型，格式：DATETIME([P])。可选参数 P 表示时间精度，取值范围是 [0,
6]，即最多支持 6 位小数（微秒）。不设置时为 0。<p>取值范围是 ['0000-01-01 00:00:00[.000000]',
'9999-12-31 23:59:59[.999999]']。打印的形式是 'yyyy-MM-dd HH:mm:ss.SSSSSS'。 </p>|
| CHAR | M | 定长字符串，M 代表的是定长字符串的字节长度。M 的范围是 1-255。 |
diff --git a/versioned_docs/version-2.0/table-design/data-type.md
b/versioned_docs/version-2.0/table-design/data-type.md
index f093502a21f..e0066d810c2 100644
--- a/versioned_docs/version-2.0/table-design/data-type.md
+++ b/versioned_docs/version-2.0/table-design/data-type.md
@@ -38,7 +38,7 @@ The list of data types supported by Doris is as follows:
| LARGEINT | 16 | Integer value, range [-2 ^ 127 + 1~ 2 ^
127 - 1]. |
| FLOAT | 4 | Single precision, a floating ponit
number, range [-3.4 * 10 ^ 38~ 3.4 * 10 ^ 38]. |
| DOUBLE | 8 | Double precision, a floating ponit
number, range [-1.79 * 10 ^ 308~ 1.79 * 10 ^ 308] |
-| DECIMAL | 2004/8/16 | An exact fixed-point number, defined by
its precision (total number of digits) and scale (number of digits to the right
of the decimal point). Format:DECIMAL(M[,D]), M stands for precision, D
stands scale. The range for the significant digits M is [1, 38], while the
range for the decimal digits D is [0, precision]. The storage requirements for
different precision values are as follows: - When 0 < precision <= 9, it
occupies 4 bytes. - When 9 < pr [...]
+| DECIMAL | 4/8/16 | An exact fixed-point number, defined by
its precision (total number of digits) and scale (number of digits to the right
of the decimal point). Format:DECIMAL(M[,D]), M stands for precision, D
stands scale. The range for the significant digits M is [1, 38], while the
range for the decimal digits D is [0, precision]. The storage requirements for
different precision values are as follows: - When 0 < precision <= 9, it
occupies 4 bytes. - When 9 < pr [...]
| DATE | 16 | DATE holds values for a calendar year,
month and day, the supported range is ['0000-01-01', '9999-12-31']. Default
print format: 'yyyy-MM-dd'. |
| DATETIME | 16 | A DATE and TIME combination Format:
DATETIME ([P]). The optional parameter P represents time precision, with a
value range of [0,6], supporting up to 6 decimal places (microseconds). When
not set, it is 0. The supported range is ['0000-01-01 00:00:00 [.000000]',
'9999-12-31 23:59:59 [.999999]']. Default print format: 'yyy-MM-dd HH: mm:
ss. SSSSSS '. |
| CHAR | M | A FIXED length string, the parameter M
specifies the column length in characters. The range of M is from 1 to 255. |
diff --git a/versioned_docs/version-2.1/table-design/data-type.md
b/versioned_docs/version-2.1/table-design/data-type.md
index 281aba8bafa..0cfb9e8f553 100644
--- a/versioned_docs/version-2.1/table-design/data-type.md
+++ b/versioned_docs/version-2.1/table-design/data-type.md
@@ -38,7 +38,7 @@ The list of data types supported by Doris is as follows:
| LARGEINT | 16 | Integer value, range [-2 ^ 127 + 1~ 2 ^
127 - 1]. |
| FLOAT | 4 | Single precision, a floating ponit
number, range [-3.4 * 10 ^ 38~ 3.4 * 10 ^ 38]. |
| DOUBLE | 8 | Double precision, a floating ponit
number, range [-1.79 * 10 ^ 308~ 1.79 * 10 ^ 308] |
-| DECIMAL | 2004/8/16 | An exact fixed-point number, defined by
its precision (total number of digits) and scale (number of digits to the right
of the decimal point). Format:DECIMAL(M[,D]), M stands for precision, D
stands scale. The range for the significant digits M is [1, 38], while the
range for the decimal digits D is [0, precision]. The storage requirements for
different precision values are as follows: - When 0 < precision <= 9, it
occupies 4 bytes. - When 9 < pr [...]
+| DECIMAL | 4/8/16 | An exact fixed-point number, defined by
its precision (total number of digits) and scale (number of digits to the right
of the decimal point). Format:DECIMAL(M[,D]), M stands for precision, D
stands scale. The range for the significant digits M is [1, 38], while the
range for the decimal digits D is [0, precision]. The storage requirements for
different precision values are as follows: - When 0 < precision <= 9, it
occupies 4 bytes. - When 9 < pr [...]
| DATE | 16 | DATE holds values for a calendar year,
month and day, the supported range is ['0000-01-01', '9999-12-31']. Default
print format: 'yyyy-MM-dd'. |
| DATETIME | 16 | A DATE and TIME combination Format:
DATETIME ([P]). The optional parameter P represents time precision, with a
value range of [0,6], supporting up to 6 decimal places (microseconds). When
not set, it is 0. The supported range is ['0000-01-01 00:00:00 [.000000]',
'9999-12-31 23:59:59 [.999999]']. Default print format: 'yyy-MM-dd HH: mm:
ss. SSSSSS '. |
| CHAR | M | A FIXED length string, the parameter M
specifies the column length in characters. The range of M is from 1 to 255. |
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
