You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by dz...@apache.org on 2022/09/05 14:32:59 UTC
[drill-site] branch master updated: Fix table formatting in supported-data-types.
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 <ja...@somecomputer.xyz>
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.