add decimal note to data type conversion functions
Project: http://git-wip-us.apache.org/repos/asf/drill/repo Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/f61eaf9e Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/f61eaf9e Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/f61eaf9e Branch: refs/heads/gh-pages Commit: f61eaf9eaa3bc910a4561d75681b573e2031e9aa Parents: 6089ab0 Author: Kristine Hahn <[email protected]> Authored: Sun May 17 19:43:59 2015 -0700 Committer: Kristine Hahn <[email protected]> Committed: Sun May 17 19:43:59 2015 -0700 ---------------------------------------------------------------------- _docs/075-getting-query-information.md | 2 +- _docs/sql-reference/sql-functions/020-data-type-conversion.md | 6 ++++++ 2 files changed, 7 insertions(+), 1 deletion(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/drill/blob/f61eaf9e/_docs/075-getting-query-information.md ---------------------------------------------------------------------- diff --git a/_docs/075-getting-query-information.md b/_docs/075-getting-query-information.md index 57c1678..d5e2953 100644 --- a/_docs/075-getting-query-information.md +++ b/_docs/075-getting-query-information.md @@ -2,7 +2,7 @@ title: "Getting Query Information" parent: "Query Audit Logging" --- -The query log provides audit log functionality for the queries executed by various drillbits in the cluster. The log records important information about queries executed on the Drillbit where Drill runs. The log includes query text, start time, end time, user, status, schema, and the query id. You can query one of the following log files, depending on whether you run Drill in embedded or distributed mode, to get audit logging information.: +The query log provides audit log functionality for the queries executed by various drillbits in the cluster. The log records important information about queries executed on the Drillbit where Drill runs. The log includes query text, start time, end time, user, status, schema, and the query id. You can query one of the following log files, depending on whether you run Drill in embedded or distributed mode, to get audit logging information: * `sqlline_queries.json` (embedded mode) * `drillbit_queries.json` (distributed mode) http://git-wip-us.apache.org/repos/asf/drill/blob/f61eaf9e/_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 239da85..a6ec16e 100644 --- a/_docs/sql-reference/sql-functions/020-data-type-conversion.md +++ b/_docs/sql-reference/sql-functions/020-data-type-conversion.md @@ -30,6 +30,8 @@ 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 %} + 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. Refer to the following tables for information about the data types to use for casting: @@ -54,6 +56,8 @@ 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 %} + ### 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. @@ -85,6 +89,8 @@ 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 %} + ### Casting Intervals To cast interval data to the INTERVALDAY or INTERVALYEAR types use the following syntax:
