This is an automated email from the ASF dual-hosted git repository.
dzamo pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/drill-site.git
The following commit(s) were added to refs/heads/master by this push:
new b8e3f33ec Reformat data type footnotes in supported-data-types.
b8e3f33ec is described below
commit b8e3f33ecaf6b36318657a59d129f24f339cfdf5
Author: James Turton <[email protected]>
AuthorDate: Mon Sep 5 11:51:02 2022 +0200
Reformat data type footnotes in supported-data-types.
---
.../sql-reference/data-types/010-supported-data-types.md | 16 ++++++++--------
1 file changed, 8 insertions(+), 8 deletions(-)
diff --git a/_docs/en/sql-reference/data-types/010-supported-data-types.md
b/_docs/en/sql-reference/data-types/010-supported-data-types.md
index 389766f87..7acf74bce 100644
--- a/_docs/en/sql-reference/data-types/010-supported-data-types.md
+++ b/_docs/en/sql-reference/data-types/010-supported-data-types.md
@@ -11,21 +11,21 @@ Drill reads from and writes to data sources having a wide
variety of types.
| BINARY | Variable-length byte
string
| B@e6d9eb7
|
| BOOLEAN | True or false
| true
|
| DATE | Years, months, and days
in YYYY-MM-DD format since 4713 BC
| 2015-12-30
|
-| DECIMAL(p,s), or DEC(p,s), NUMERIC(p,s)* | 38-digit precision
number, precision is p, and scale is s
| DECIMAL(6,2) is 1234.56, 4 digits before and 2 digits
after the decimal point |
+| DECIMAL(p,s), or DEC(p,s), NUMERIC(p,s)[^1] | 38-digit precision
number, precision is p, and scale is s
| DECIMAL(6,2) is 1234.56, 4 digits before and 2 digits
after the decimal point |
| FLOAT | 4-byte floating point
number
| 0.456
|
| DOUBLE, DOUBLE PRECISION | 8-byte floating point
number, precision-scalable
| 0.456
|
| INTEGER or INT | 4-byte signed integer
in the range -2,147,483,648 to 2,147,483,647
| 2147483646
|
-| INTERVAL** | A day-time or
year-month interval
| '1 10:20:30.123' (day-time) or '1-2' year to month
(year-month) |
-| SMALLINT*** | 2-byte signed integer
in the range -32,768 to 32,767
| 32000
|
+| INTERVAL[^2] | A day-time or
year-month interval
| '1 10:20:30.123' (day-time) or '1-2' year to month
(year-month) |
+| SMALLINT[^3] | 2-byte signed integer
in the range -32,768 to 32,767
| 32000
|
| TIME | 24-hour based time
before or after January 1, 2001 in hours, minutes, seconds format: HH:mm:ss
| 22:55:55.23
|
| TIMESTAMP | JDBC timestamp in year,
month, date hour, minute, second, and optional milliseconds format: yyyy-MM-dd
HH:mm:ss.SSS | 2015-12-30 22:55:55.23
|
-| CHARACTER VARYING, CHARACTER, CHAR,**** or VARCHAR | UTF8-encoded
variable-length string. The default limit is 1 character. The maximum character
limit is 2,147,483,647. | CHAR(30) casts data to a 30-character string maximum.
|
+| CHARACTER VARYING, CHARACTER, CHAR[^4] or VARCHAR | UTF8-encoded
variable-length string. The default limit is 1 character. The maximum character
limit is 2,147,483,647. | CHAR(30) casts data to a 30-character string maximum.
|
-\* Starting in Drill 1.14, the DECIMAL data type is enabled by default.
-\*\* Internally, INTERVAL is represented as INTERVALDAY or INTERVALYEAR.
-\*\*\* SMALLINT is not currently supported.
-\*\*\*\* The CHAR data type is internally represented as VARCHAR by Drill.
+[^1]: Starting in Drill 1.14, the DECIMAL data type is enabled by default.
+[^2]: Internally, INTERVAL is represented as INTERVALDAY or INTERVALYEAR.
+[^3]: SMALLINT is not currently supported.
+[^4]: The CHAR data type is internally represented as VARCHAR by Drill.
## DECIMAL Data Type
