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 355308743 Automatic Site Publish by Buildbot
355308743 is described below
commit 35530874310d6d90274f9f28c41d4aae8913f391
Author: buildbot <[email protected]>
AuthorDate: Mon Sep 5 10:06:45 2022 +0000
Automatic Site Publish by Buildbot
---
output/docs/supported-data-types/index.html | 135 +++++++------------------
output/feed.xml | 4 +-
output/zh/docs/supported-data-types/index.html | 135 +++++++------------------
output/zh/feed.xml | 4 +-
4 files changed, 76 insertions(+), 202 deletions(-)
diff --git a/output/docs/supported-data-types/index.html
b/output/docs/supported-data-types/index.html
index e1c3ea072..a0d22fbde 100644
--- a/output/docs/supported-data-types/index.html
+++ b/output/docs/supported-data-types/index.html
@@ -1466,83 +1466,21 @@
<p>Drill reads from and writes to data sources having a wide variety
of types.</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>
-
+<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>
<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>
@@ -1692,7 +1630,7 @@ Implicitly casts all textual data to VARCHAR.</li>
<td>2</td>
<td>INTERVALDAY</td>
<td>13</td>
- <td>SMALLINT*</td>
+ <td>SMALLINT<sup id="fnref:5" role="doc-noteref"><a href="#fn:5"
class="footnote" rel="footnote">5</a></sup></td>
</tr>
<tr>
<td>3</td>
@@ -1751,8 +1689,6 @@ Implicitly casts all textual data to VARCHAR.</li>
</tbody>
</table>
-<p>* Not supported in this release.</p>
-
<h2 id="explicit-casting">Explicit Casting</h2>
<p>In a textual file, such as CSV, Drill interprets every field as a VARCHAR,
as previously mentioned. To handle textual data, you can use the following
functions to cast and convert compatible data types:</p>
@@ -1809,7 +1745,7 @@ Converts a string to TIMESTAMP.</li>
<td> </td>
</tr>
<tr>
- <td>SMALLINT*</td>
+ <td>SMALLINT<sup id="fnref:6" role="doc-noteref"><a href="#fn:6"
class="footnote" rel="footnote">6</a></sup></td>
<td>yes</td>
<td>yes</td>
<td>yes</td>
@@ -1893,7 +1829,7 @@ Converts a string to TIMESTAMP.</li>
<td>yes</td>
</tr>
<tr>
- <td>FIXEDBINARY**</td>
+ <td>FIXEDBINARY<sup id="fnref:7" role="doc-noteref"><a href="#fn:7"
class="footnote" rel="footnote">7</a></sup></td>
<td>yes</td>
<td>yes</td>
<td>yes</td>
@@ -1905,7 +1841,7 @@ Converts a string to TIMESTAMP.</li>
<td>yes</td>
</tr>
<tr>
- <td>VARCHAR***</td>
+ <td>VARCHAR<sup id="fnref:8" role="doc-noteref"><a href="#fn:8"
class="footnote" rel="footnote">8</a></sup></td>
<td>yes</td>
<td>yes</td>
<td>yes</td>
@@ -1917,7 +1853,7 @@ Converts a string to TIMESTAMP.</li>
<td>yes</td>
</tr>
<tr>
- <td>VARBINARY**</td>
+ <td>VARBINARY<sup id="fnref:7:1" role="doc-noteref"><a href="#fn:7"
class="footnote" rel="footnote">7</a></sup></td>
<td>yes</td>
<td>yes</td>
<td>yes</td>
@@ -1931,17 +1867,6 @@ Converts a string to TIMESTAMP.</li>
</tbody>
</table>
-<p>* Not supported in this release.
-** Used to cast binary UTF-8 data coming to/from sources such as HBase.
-*** You cannot convert a character string having a decimal point to an INT or
BIGINT.</p>
-
-<div class="admonition note">
- <p class="first admonition-title">Note</p>
- <p class="last">The CAST function does not support all representations of
FIXEDBINARY and VARBINARY. Only the UTF-8 format is supported. </p>
-</div>
-
-<p>If your FIXEDBINARY or VARBINARY data is in a format other than UTF-8, or
big-endian encoded, use the CONVERT_TO/FROM functions instead of CAST.</p>
-
<h3 id="date-and-time-data-types">Date and Time Data Types</h3>
<table>
@@ -1973,7 +1898,7 @@ Converts a string to TIMESTAMP.</li>
<td>Yes</td>
</tr>
<tr>
- <td>FIXEDBINARY*</td>
+ <td>FIXEDBINARY<sup id="fnref:7:2" role="doc-noteref"><a href="#fn:7"
class="footnote" rel="footnote">7</a></sup></td>
<td>No</td>
<td>No</td>
<td>No</td>
@@ -1989,7 +1914,7 @@ Converts a string to TIMESTAMP.</li>
<td>Yes</td>
</tr>
<tr>
- <td>VARBINARY*</td>
+ <td>VARBINARY<sup id="fnref:7:3" role="doc-noteref"><a href="#fn:7"
class="footnote" rel="footnote">7</a></sup></td>
<td>No</td>
<td>No</td>
<td>Yes</td>
@@ -2039,8 +1964,6 @@ Converts a string to TIMESTAMP.</li>
</tbody>
</table>
-<p>* Used to cast binary UTF-8 data coming to/from sources such as HBase. The
CAST function does not support all representations of FIXEDBINARY and
VARBINARY. Only the UTF-8 format is supported.</p>
-
<h2 id="data-types-for-convert_to-and-convert_from-functions">Data Types for
CONVERT_TO and CONVERT_FROM Functions</h2>
<p>The <a
href="/docs/data-type-conversion/#convert_to-and-convert_from">CONVERT_TO
function</a> converts data to bytes from the input type. The <a
href="/docs/data-type-conversion/#convert_to-and-convert_from">CONVERT_FROM
function</a> converts data from bytes to the input type. For example, the
following CONVERT_TO function converts an integer to bytes using big endian
encoding:</p>
@@ -2189,6 +2112,8 @@ and CONVERT_FROM functions:</p>
<p>*_HADOOPV in the data type name denotes the variable length integer as
defined by Hadoop libraries. Use a *_HADOOPV type if user data is encoded in
this format by a Hadoop tool outside MapR.</p>
+<h3 id="footnotes">Footnotes</h3>
+
<div class="footnotes" role="doc-endnotes">
<ol>
<li id="fn:1" role="doc-endnote">
@@ -2203,6 +2128,18 @@ and CONVERT_FROM functions:</p>
<li id="fn:4" role="doc-endnote">
<p>The CHAR data type is internally represented as VARCHAR by Drill. <a
href="#fnref:4" class="reversefootnote" role="doc-backlink">↩</a></p>
</li>
+ <li id="fn:5" role="doc-endnote">
+ <p>Not supported in this release. <a href="#fnref:5"
class="reversefootnote" role="doc-backlink">↩</a></p>
+ </li>
+ <li id="fn:6" role="doc-endnote">
+ <p>Not supported in this release. <a href="#fnref:6"
class="reversefootnote" role="doc-backlink">↩</a></p>
+ </li>
+ <li id="fn:7" role="doc-endnote">
+ <p>Used to cast binary UTF-8 data coming to/from sources such as HBase.
The CAST function does not support all representations of FIXEDBINARY and
VARBINARY. Only the UTF-8 format is supported. If your FIXEDBINARY or VARBINARY
data is in a format other than UTF-8, or big-endian encoded, use the
CONVERT_TO/FROM functions instead of CAST. <a href="#fnref:7"
class="reversefootnote" role="doc-backlink">↩</a> <a href="#fnref:7:1"
class="reversefootnote" role="doc-backlink">↩< [...]
+ </li>
+ <li id="fn:8" role="doc-endnote">
+ <p>You cannot convert a character string having a decimal point to an
INT or BIGINT. <a href="#fnref:8" class="reversefootnote"
role="doc-backlink">↩</a></p>
+ </li>
</ol>
</div>
diff --git a/output/feed.xml b/output/feed.xml
index c0a5411f3..cb36e3d68 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 09:51:48 +0000</pubDate>
- <lastBuildDate>Mon, 05 Sep 2022 09:51:48 +0000</lastBuildDate>
+ <pubDate>Mon, 05 Sep 2022 10:04:36 +0000</pubDate>
+ <lastBuildDate>Mon, 05 Sep 2022 10:04:36 +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 85b28675d..75f9670aa 100644
--- a/output/zh/docs/supported-data-types/index.html
+++ b/output/zh/docs/supported-data-types/index.html
@@ -1466,83 +1466,21 @@
<p>Drill reads from and writes to data sources having a wide variety
of types.</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>
-
+<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>
<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>
@@ -1692,7 +1630,7 @@ Implicitly casts all textual data to VARCHAR.</li>
<td>2</td>
<td>INTERVALDAY</td>
<td>13</td>
- <td>SMALLINT*</td>
+ <td>SMALLINT<sup id="fnref:5" role="doc-noteref"><a href="#fn:5"
class="footnote" rel="footnote">5</a></sup></td>
</tr>
<tr>
<td>3</td>
@@ -1751,8 +1689,6 @@ Implicitly casts all textual data to VARCHAR.</li>
</tbody>
</table>
-<p>* Not supported in this release.</p>
-
<h2 id="explicit-casting">Explicit Casting</h2>
<p>In a textual file, such as CSV, Drill interprets every field as a VARCHAR,
as previously mentioned. To handle textual data, you can use the following
functions to cast and convert compatible data types:</p>
@@ -1809,7 +1745,7 @@ Converts a string to TIMESTAMP.</li>
<td> </td>
</tr>
<tr>
- <td>SMALLINT*</td>
+ <td>SMALLINT<sup id="fnref:6" role="doc-noteref"><a href="#fn:6"
class="footnote" rel="footnote">6</a></sup></td>
<td>yes</td>
<td>yes</td>
<td>yes</td>
@@ -1893,7 +1829,7 @@ Converts a string to TIMESTAMP.</li>
<td>yes</td>
</tr>
<tr>
- <td>FIXEDBINARY**</td>
+ <td>FIXEDBINARY<sup id="fnref:7" role="doc-noteref"><a href="#fn:7"
class="footnote" rel="footnote">7</a></sup></td>
<td>yes</td>
<td>yes</td>
<td>yes</td>
@@ -1905,7 +1841,7 @@ Converts a string to TIMESTAMP.</li>
<td>yes</td>
</tr>
<tr>
- <td>VARCHAR***</td>
+ <td>VARCHAR<sup id="fnref:8" role="doc-noteref"><a href="#fn:8"
class="footnote" rel="footnote">8</a></sup></td>
<td>yes</td>
<td>yes</td>
<td>yes</td>
@@ -1917,7 +1853,7 @@ Converts a string to TIMESTAMP.</li>
<td>yes</td>
</tr>
<tr>
- <td>VARBINARY**</td>
+ <td>VARBINARY<sup id="fnref:7:1" role="doc-noteref"><a href="#fn:7"
class="footnote" rel="footnote">7</a></sup></td>
<td>yes</td>
<td>yes</td>
<td>yes</td>
@@ -1931,17 +1867,6 @@ Converts a string to TIMESTAMP.</li>
</tbody>
</table>
-<p>* Not supported in this release.
-** Used to cast binary UTF-8 data coming to/from sources such as HBase.
-*** You cannot convert a character string having a decimal point to an INT or
BIGINT.</p>
-
-<div class="admonition note">
- <p class="first admonition-title">Note</p>
- <p class="last">The CAST function does not support all representations of
FIXEDBINARY and VARBINARY. Only the UTF-8 format is supported. </p>
-</div>
-
-<p>If your FIXEDBINARY or VARBINARY data is in a format other than UTF-8, or
big-endian encoded, use the CONVERT_TO/FROM functions instead of CAST.</p>
-
<h3 id="date-and-time-data-types">Date and Time Data Types</h3>
<table>
@@ -1973,7 +1898,7 @@ Converts a string to TIMESTAMP.</li>
<td>Yes</td>
</tr>
<tr>
- <td>FIXEDBINARY*</td>
+ <td>FIXEDBINARY<sup id="fnref:7:2" role="doc-noteref"><a href="#fn:7"
class="footnote" rel="footnote">7</a></sup></td>
<td>No</td>
<td>No</td>
<td>No</td>
@@ -1989,7 +1914,7 @@ Converts a string to TIMESTAMP.</li>
<td>Yes</td>
</tr>
<tr>
- <td>VARBINARY*</td>
+ <td>VARBINARY<sup id="fnref:7:3" role="doc-noteref"><a href="#fn:7"
class="footnote" rel="footnote">7</a></sup></td>
<td>No</td>
<td>No</td>
<td>Yes</td>
@@ -2039,8 +1964,6 @@ Converts a string to TIMESTAMP.</li>
</tbody>
</table>
-<p>* Used to cast binary UTF-8 data coming to/from sources such as HBase. The
CAST function does not support all representations of FIXEDBINARY and
VARBINARY. Only the UTF-8 format is supported.</p>
-
<h2 id="data-types-for-convert_to-and-convert_from-functions">Data Types for
CONVERT_TO and CONVERT_FROM Functions</h2>
<p>The <a
href="/zh/docs/data-type-conversion/#convert_to-and-convert_from">CONVERT_TO
function</a> converts data to bytes from the input type. The <a
href="/zh/docs/data-type-conversion/#convert_to-and-convert_from">CONVERT_FROM
function</a> converts data from bytes to the input type. For example, the
following CONVERT_TO function converts an integer to bytes using big endian
encoding:</p>
@@ -2189,6 +2112,8 @@ and CONVERT_FROM functions:</p>
<p>*_HADOOPV in the data type name denotes the variable length integer as
defined by Hadoop libraries. Use a *_HADOOPV type if user data is encoded in
this format by a Hadoop tool outside MapR.</p>
+<h3 id="footnotes">Footnotes</h3>
+
<div class="footnotes" role="doc-endnotes">
<ol>
<li id="fn:1" role="doc-endnote">
@@ -2203,6 +2128,18 @@ and CONVERT_FROM functions:</p>
<li id="fn:4" role="doc-endnote">
<p>The CHAR data type is internally represented as VARCHAR by Drill. <a
href="#fnref:4" class="reversefootnote" role="doc-backlink">↩</a></p>
</li>
+ <li id="fn:5" role="doc-endnote">
+ <p>Not supported in this release. <a href="#fnref:5"
class="reversefootnote" role="doc-backlink">↩</a></p>
+ </li>
+ <li id="fn:6" role="doc-endnote">
+ <p>Not supported in this release. <a href="#fnref:6"
class="reversefootnote" role="doc-backlink">↩</a></p>
+ </li>
+ <li id="fn:7" role="doc-endnote">
+ <p>Used to cast binary UTF-8 data coming to/from sources such as HBase.
The CAST function does not support all representations of FIXEDBINARY and
VARBINARY. Only the UTF-8 format is supported. If your FIXEDBINARY or VARBINARY
data is in a format other than UTF-8, or big-endian encoded, use the
CONVERT_TO/FROM functions instead of CAST. <a href="#fnref:7"
class="reversefootnote" role="doc-backlink">↩</a> <a href="#fnref:7:1"
class="reversefootnote" role="doc-backlink">↩< [...]
+ </li>
+ <li id="fn:8" role="doc-endnote">
+ <p>You cannot convert a character string having a decimal point to an
INT or BIGINT. <a href="#fnref:8" class="reversefootnote"
role="doc-backlink">↩</a></p>
+ </li>
</ol>
</div>
diff --git a/output/zh/feed.xml b/output/zh/feed.xml
index 0512e3758..c97d3fb40 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 09:51:48 +0000</pubDate>
- <lastBuildDate>Mon, 05 Sep 2022 09:51:48 +0000</lastBuildDate>
+ <pubDate>Mon, 05 Sep 2022 10:04:36 +0000</pubDate>
+ <lastBuildDate>Mon, 05 Sep 2022 10:04:36 +0000</lastBuildDate>
<generator>Jekyll v3.9.1</generator>
<item>
