You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by ts...@apache.org on 2015/05/19 01:36:34 UTC
[11/31] drill git commit: minor edit
minor edit
Project: http://git-wip-us.apache.org/repos/asf/drill/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/e3b2c1a3
Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/e3b2c1a3
Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/e3b2c1a3
Branch: refs/heads/gh-pages
Commit: e3b2c1a319e3c826db4797873cf45b03a3ff46ac
Parents: f61eaf9
Author: Kristine Hahn <kh...@maprtech.com>
Authored: Sun May 17 19:46:23 2015 -0700
Committer: Kristine Hahn <kh...@maprtech.com>
Committed: Sun May 17 19:46:23 2015 -0700
----------------------------------------------------------------------
_docs/sql-reference/sql-functions/020-data-type-conversion.md | 6 +++---
1 file changed, 3 insertions(+), 3 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/drill/blob/e3b2c1a3/_docs/sql-reference/sql-functions/020-data-type-conversion.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-functions/020-data-type-conversion.md b/_docs/sql-reference/sql-functions/020-data-type-conversion.md
index a6ec16e..c60c096 100644
--- a/_docs/sql-reference/sql-functions/020-data-type-conversion.md
+++ b/_docs/sql-reference/sql-functions/020-data-type-conversion.md
@@ -30,7 +30,7 @@ If the SELECT statement includes a WHERE clause that compares a column of an unk
SELECT c_row, CAST(c_int AS DECIMAL(28,8)) FROM mydata WHERE CAST(c_int AS DECIMAL(28,8)) > -3.0;
-{% include startnote.html %}In this release, Drill disables the DECIMAL data type. To enable, set the planner.enable_decimal_data_type option to `true`.{% include endnote.html %}
+{% include startnote.html %}In this release, Drill disables the DECIMAL data type. To enable, set the planner.enable_decimal_data_type option to true.{% include endnote.html %}
Use CONVERT_TO and CONVERT_FROM instead of the CAST function for converting binary data types with one exception: When converting an INT or BIGINT number, having a byte count in the destination/source that does not match the byte count of the number in the VARBINARY source/destination, use CAST.
@@ -56,7 +56,7 @@ The following example shows how to cast a character to a DECIMAL having two deci
| 1.00 |
+------------+
-{% include startnote.html %}In this release, Drill disables the DECIMAL data type. To enable, set the planner.enable_decimal_data_type option to `true`.{% include endnote.html %}
+{% include startnote.html %}In this release, Drill disables the DECIMAL data type. To enable, set the planner.enable_decimal_data_type option to true.{% include endnote.html %}
### Casting a Number to a Character String
The first example shows Drill casting a number to a VARCHAR having a length of 3 bytes: The result is a 3-character string, 456. Drill supports the CHAR and CHARACTER VARYING alias.
@@ -89,7 +89,7 @@ Cast an integer to a decimal.
+------------+
1 row selected (0.08 seconds)
-{% include startnote.html %}In this release, Drill disables the DECIMAL data type. To enable, set the planner.enable_decimal_data_type option to `true`.{% include endnote.html %}
+{% include startnote.html %}In this release, Drill disables the DECIMAL data type. To enable, set the planner.enable_decimal_data_type option to true.{% include endnote.html %}
### Casting Intervals