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 <[email protected]> Authored: Sun May 17 19:46:23 2015 -0700 Committer: Kristine Hahn <[email protected]> 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
