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 a4fcff1f7 Fix table formatting in supported-data-types.
a4fcff1f7 is described below
commit a4fcff1f75e92f6472a240ef076188ba98cb4df5
Author: James Turton <[email protected]>
AuthorDate: Mon Sep 5 16:32:44 2022 +0200
Fix table formatting in supported-data-types.
---
.../data-types/010-supported-data-types.md | 29 +++++++++++-----------
1 file changed, 15 insertions(+), 14 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 1af42ff5a..a12671fd1 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
@@ -5,21 +5,22 @@ parent: "Data Types"
---
Drill reads from and writes to data sources having a wide variety of types.
-| SQL Data Type | Description
| Example
|
-|----------------------------------------------------|----------------------------------------------------------------------------------------------------------------------|--------------------------------------------------------------------------------|
-| BIGINT | 8-byte signed integer
in the range -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
| 9223372036854775807
|
-| 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)[^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[^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
|
+| SQL Data Type | Description
| Example
|
+|---------------------------------------------------|----------------------------------------------------------------------------------------------------------------------|--------------------------------------------------------------------------------|
+| BIGINT | 8-byte signed integer in
the range -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
| 9223372036854775807
|
+| 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)[^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[^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[^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.
|
+
## DECIMAL Data Type
Starting in Drill 1.14, DECIMAL data type support is enabled by default. Drill
uses the vardecimal data type to store decimal and numeric data types in a
compressed format that optimizes storage space. The vardecimal data type stores
decimal and numeric values as variable length columns that can represent any
decimal precision.
