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:33 UTC
[10/31] drill git commit: add decimal note to data type conversion
functions
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 <kh...@maprtech.com>
Authored: Sun May 17 19:43:59 2015 -0700
Committer: Kristine Hahn <kh...@maprtech.com>
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: