This is an automated email from the ASF dual-hosted git repository.
git-site-role pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/drill-site.git
The following commit(s) were added to refs/heads/asf-site by this push:
new a00e23fd2 Automatic Site Publish by Buildbot
a00e23fd2 is described below
commit a00e23fd2f34c111d4ce778bbdeaf35ba85e301c
Author: buildbot <[email protected]>
AuthorDate: Mon Sep 5 14:35:25 2022 +0000
Automatic Site Publish by Buildbot
---
output/docs/supported-data-types/index.html | 92 +++++++++++++++++++++-----
output/feed.xml | 4 +-
output/zh/docs/supported-data-types/index.html | 92 +++++++++++++++++++++-----
output/zh/feed.xml | 4 +-
4 files changed, 158 insertions(+), 34 deletions(-)
diff --git a/output/docs/supported-data-types/index.html
b/output/docs/supported-data-types/index.html
index a0d22fbde..4b62d1d53 100644
--- a/output/docs/supported-data-types/index.html
+++ b/output/docs/supported-data-types/index.html
@@ -1466,21 +1466,83 @@
<p>Drill reads from and writes to data sources having a wide variety
of types.</p>
-<p>| 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)<sup id="fnref:1"
role="doc-noteref"><a href="#fn:1" class="footnote" rel="footnote">1</a></sup>
| 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<sup id="fnref:2" role="doc-noteref"><a href="#fn:2"
class="footnote" rel="footnote">2</a></sup>
| A day-time or year-month interval
| ‘1 10:20:30.123’ (day-time) or ‘1-2’
year to month (year-month) |
-| SMALLINT<sup id="fnref:3" role="doc-noteref"><a href="#fn:3"
class="footnote" rel="footnote">3</a></sup>
| 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<sup id="fnref:4" role="doc-noteref"><a
href="#fn:4" class="footnote" rel="footnote">4</a></sup> 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. |</p>
+<table>
+ <thead>
+ <tr>
+ <th>SQL Data Type</th>
+ <th>Description</th>
+ <th>Example</th>
+ </tr>
+ </thead>
+ <tbody>
+ <tr>
+ <td>BIGINT</td>
+ <td>8-byte signed integer in the range -9,223,372,036,854,775,808 to
9,223,372,036,854,775,807</td>
+ <td>9223372036854775807</td>
+ </tr>
+ <tr>
+ <td>BINARY</td>
+ <td>Variable-length byte string</td>
+ <td>B@e6d9eb7</td>
+ </tr>
+ <tr>
+ <td>BOOLEAN</td>
+ <td>True or false</td>
+ <td>true</td>
+ </tr>
+ <tr>
+ <td>DATE</td>
+ <td>Years, months, and days in YYYY-MM-DD format since 4713 BC</td>
+ <td>2015-12-30</td>
+ </tr>
+ <tr>
+ <td>DECIMAL(p,s), or DEC(p,s), NUMERIC(p,s)<sup id="fnref:1"
role="doc-noteref"><a href="#fn:1" class="footnote"
rel="footnote">1</a></sup></td>
+ <td>38-digit precision number, precision is p, and scale is s</td>
+ <td>DECIMAL(6,2) is 1234.56, 4 digits before and 2 digits after the
decimal point</td>
+ </tr>
+ <tr>
+ <td>FLOAT</td>
+ <td>4-byte floating point number</td>
+ <td>0.456</td>
+ </tr>
+ <tr>
+ <td>DOUBLE, DOUBLE PRECISION</td>
+ <td>8-byte floating point number, precision-scalable</td>
+ <td>0.456</td>
+ </tr>
+ <tr>
+ <td>INTEGER or INT</td>
+ <td>4-byte signed integer in the range -2,147,483,648 to
2,147,483,647</td>
+ <td>2147483646</td>
+ </tr>
+ <tr>
+ <td>INTERVAL<sup id="fnref:2" role="doc-noteref"><a href="#fn:2"
class="footnote" rel="footnote">2</a></sup></td>
+ <td>A day-time or year-month interval</td>
+ <td>‘1 10:20:30.123’ (day-time) or ‘1-2’ year to month (year-month)</td>
+ </tr>
+ <tr>
+ <td>SMALLINT<sup id="fnref:3" role="doc-noteref"><a href="#fn:3"
class="footnote" rel="footnote">3</a></sup></td>
+ <td>2-byte signed integer in the range -32,768 to 32,767</td>
+ <td>32000</td>
+ </tr>
+ <tr>
+ <td>TIME</td>
+ <td>24-hour based time before or after January 1, 2001 in hours,
minutes, seconds format: HH:mm:ss</td>
+ <td>22:55:55.23</td>
+ </tr>
+ <tr>
+ <td>TIMESTAMP</td>
+ <td>JDBC timestamp in year, month, date hour, minute, second, and
optional milliseconds format: yyyy-MM-dd HH:mm:ss.SSS</td>
+ <td>2015-12-30 22:55:55.23</td>
+ </tr>
+ <tr>
+ <td>CHARACTER VARYING, CHARACTER, CHAR<sup id="fnref:4"
role="doc-noteref"><a href="#fn:4" class="footnote" rel="footnote">4</a></sup>
or VARCHAR</td>
+ <td>UTF8-encoded variable-length string. The default limit is 1
character. The maximum character limit is 2,147,483,647.</td>
+ <td>CHAR(30) casts data to a 30-character string maximum.</td>
+ </tr>
+ </tbody>
+</table>
+
<h2 id="decimal-data-type">DECIMAL Data Type</h2>
<p>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.</p>
diff --git a/output/feed.xml b/output/feed.xml
index cb36e3d68..81fbf36ea 100644
--- a/output/feed.xml
+++ b/output/feed.xml
@@ -6,8 +6,8 @@
</description>
<link>/</link>
<atom:link href="/feed.xml" rel="self" type="application/rss+xml"/>
- <pubDate>Mon, 05 Sep 2022 10:04:36 +0000</pubDate>
- <lastBuildDate>Mon, 05 Sep 2022 10:04:36 +0000</lastBuildDate>
+ <pubDate>Mon, 05 Sep 2022 14:33:17 +0000</pubDate>
+ <lastBuildDate>Mon, 05 Sep 2022 14:33:17 +0000</lastBuildDate>
<generator>Jekyll v3.9.1</generator>
<item>
diff --git a/output/zh/docs/supported-data-types/index.html
b/output/zh/docs/supported-data-types/index.html
index 75f9670aa..2c73d3fc8 100644
--- a/output/zh/docs/supported-data-types/index.html
+++ b/output/zh/docs/supported-data-types/index.html
@@ -1466,21 +1466,83 @@
<p>Drill reads from and writes to data sources having a wide variety
of types.</p>
-<p>| 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)<sup id="fnref:1"
role="doc-noteref"><a href="#fn:1" class="footnote" rel="footnote">1</a></sup>
| 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<sup id="fnref:2" role="doc-noteref"><a href="#fn:2"
class="footnote" rel="footnote">2</a></sup>
| A day-time or year-month interval
| ‘1 10:20:30.123’ (day-time) or ‘1-2’
year to month (year-month) |
-| SMALLINT<sup id="fnref:3" role="doc-noteref"><a href="#fn:3"
class="footnote" rel="footnote">3</a></sup>
| 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<sup id="fnref:4" role="doc-noteref"><a
href="#fn:4" class="footnote" rel="footnote">4</a></sup> 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. |</p>
+<table>
+ <thead>
+ <tr>
+ <th>SQL Data Type</th>
+ <th>Description</th>
+ <th>Example</th>
+ </tr>
+ </thead>
+ <tbody>
+ <tr>
+ <td>BIGINT</td>
+ <td>8-byte signed integer in the range -9,223,372,036,854,775,808 to
9,223,372,036,854,775,807</td>
+ <td>9223372036854775807</td>
+ </tr>
+ <tr>
+ <td>BINARY</td>
+ <td>Variable-length byte string</td>
+ <td>B@e6d9eb7</td>
+ </tr>
+ <tr>
+ <td>BOOLEAN</td>
+ <td>True or false</td>
+ <td>true</td>
+ </tr>
+ <tr>
+ <td>DATE</td>
+ <td>Years, months, and days in YYYY-MM-DD format since 4713 BC</td>
+ <td>2015-12-30</td>
+ </tr>
+ <tr>
+ <td>DECIMAL(p,s), or DEC(p,s), NUMERIC(p,s)<sup id="fnref:1"
role="doc-noteref"><a href="#fn:1" class="footnote"
rel="footnote">1</a></sup></td>
+ <td>38-digit precision number, precision is p, and scale is s</td>
+ <td>DECIMAL(6,2) is 1234.56, 4 digits before and 2 digits after the
decimal point</td>
+ </tr>
+ <tr>
+ <td>FLOAT</td>
+ <td>4-byte floating point number</td>
+ <td>0.456</td>
+ </tr>
+ <tr>
+ <td>DOUBLE, DOUBLE PRECISION</td>
+ <td>8-byte floating point number, precision-scalable</td>
+ <td>0.456</td>
+ </tr>
+ <tr>
+ <td>INTEGER or INT</td>
+ <td>4-byte signed integer in the range -2,147,483,648 to
2,147,483,647</td>
+ <td>2147483646</td>
+ </tr>
+ <tr>
+ <td>INTERVAL<sup id="fnref:2" role="doc-noteref"><a href="#fn:2"
class="footnote" rel="footnote">2</a></sup></td>
+ <td>A day-time or year-month interval</td>
+ <td>‘1 10:20:30.123’ (day-time) or ‘1-2’ year to month (year-month)</td>
+ </tr>
+ <tr>
+ <td>SMALLINT<sup id="fnref:3" role="doc-noteref"><a href="#fn:3"
class="footnote" rel="footnote">3</a></sup></td>
+ <td>2-byte signed integer in the range -32,768 to 32,767</td>
+ <td>32000</td>
+ </tr>
+ <tr>
+ <td>TIME</td>
+ <td>24-hour based time before or after January 1, 2001 in hours,
minutes, seconds format: HH:mm:ss</td>
+ <td>22:55:55.23</td>
+ </tr>
+ <tr>
+ <td>TIMESTAMP</td>
+ <td>JDBC timestamp in year, month, date hour, minute, second, and
optional milliseconds format: yyyy-MM-dd HH:mm:ss.SSS</td>
+ <td>2015-12-30 22:55:55.23</td>
+ </tr>
+ <tr>
+ <td>CHARACTER VARYING, CHARACTER, CHAR<sup id="fnref:4"
role="doc-noteref"><a href="#fn:4" class="footnote" rel="footnote">4</a></sup>
or VARCHAR</td>
+ <td>UTF8-encoded variable-length string. The default limit is 1
character. The maximum character limit is 2,147,483,647.</td>
+ <td>CHAR(30) casts data to a 30-character string maximum.</td>
+ </tr>
+ </tbody>
+</table>
+
<h2 id="decimal-data-type">DECIMAL Data Type</h2>
<p>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.</p>
diff --git a/output/zh/feed.xml b/output/zh/feed.xml
index c97d3fb40..acd979f95 100644
--- a/output/zh/feed.xml
+++ b/output/zh/feed.xml
@@ -6,8 +6,8 @@
</description>
<link>/</link>
<atom:link href="/zh/feed.xml" rel="self" type="application/rss+xml"/>
- <pubDate>Mon, 05 Sep 2022 10:04:36 +0000</pubDate>
- <lastBuildDate>Mon, 05 Sep 2022 10:04:36 +0000</lastBuildDate>
+ <pubDate>Mon, 05 Sep 2022 14:33:17 +0000</pubDate>
+ <lastBuildDate>Mon, 05 Sep 2022 14:33:17 +0000</lastBuildDate>
<generator>Jekyll v3.9.1</generator>
<item>
