drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tshi...@apache.org
Subject [10/31] drill git commit: add decimal note to data type conversion functions
Date Mon, 18 May 2015 23:36:33 GMT
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 <khahn@maprtech.com>
Authored: Sun May 17 19:43:59 2015 -0700
Committer: Kristine Hahn <khahn@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:


Mime
View raw message