You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by br...@apache.org on 2018/06/27 22:17:06 UTC
[drill-site] branch asf-site updated: doc edits and updates for
Drill 1.14
This is an automated email from the ASF dual-hosted git repository.
bridgetb pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/drill-site.git
The following commit(s) were added to refs/heads/asf-site by this push:
new 7d96ce4 doc edits and updates for Drill 1.14
7d96ce4 is described below
commit 7d96ce4604f9b57371ae9441105b1779aa476433
Author: Bridget Bevens <bb...@maprtech.com>
AuthorDate: Wed Jun 27 15:16:55 2018 -0700
doc edits and updates for Drill 1.14
---
.../aggregate-and-aggregate-statistical/index.html | 26 +++++-----
docs/aggregate-window-functions/index.html | 38 +++++++-------
docs/configuration-options-introduction/index.html | 6 +--
docs/custom-function-interfaces/index.html | 10 ++--
docs/data-type-conversion/index.html | 16 ++----
.../index.html | 6 ++-
docs/handling-different-data-types/index.html | 4 +-
docs/mapr-db-format/index.html | 4 +-
docs/math-and-trig/index.html | 14 ++---
docs/parquet-format/index.html | 4 +-
docs/querying-hive/index.html | 6 +--
docs/supported-data-types/index.html | 60 ++++++++++++++++------
feed.xml | 4 +-
13 files changed, 112 insertions(+), 86 deletions(-)
diff --git a/docs/aggregate-and-aggregate-statistical/index.html b/docs/aggregate-and-aggregate-statistical/index.html
index 8400143..71d3734 100644
--- a/docs/aggregate-and-aggregate-statistical/index.html
+++ b/docs/aggregate-and-aggregate-statistical/index.html
@@ -1232,7 +1232,7 @@
</div>
-
+ Jun 26, 2018
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1241,7 +1241,7 @@
<h2 id="aggregate-functions">Aggregate Functions</h2>
<p>The following tables list the aggregate and aggregate statistical functions that you can use in
-Drill queries:</p>
+Drill queries: </p>
<table><thead>
<tr>
@@ -1252,12 +1252,12 @@ Drill queries:</p>
</thead><tbody>
<tr>
<td>AVG(expression)</td>
-<td>SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE, DECIMAL, INTERVAL</td>
-<td>DECIMAL for any integer-type argument, DOUBLE for a floating-point argument, otherwise the same as the argument data type</td>
+<td>SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE, DECIMAL, INTERVAL</td>
+<td>DECIMAL for DECIMAL argument, DOUBLE for all other arguments</td>
</tr>
<tr>
<td>COUNT(*)</td>
-<td><em>-</em></td>
+<td>-</td>
<td>BIGINT</td>
</tr>
<tr>
@@ -1267,22 +1267,22 @@ Drill queries:</p>
</tr>
<tr>
<td>MAX(expression)</td>
-<td>BINARY, DECIMAL, VARCHAR, DATE, TIME, or TIMESTAMP</td>
-<td>same as argument type</td>
+<td>BINARY, DECIMAL, VARCHAR, DATE, TIME, or TIMESTAMP</td>
+<td>same as argument type</td>
</tr>
<tr>
<td>MIN(expression)</td>
-<td>BINARY, DECIMAL, VARCHAR, DATE, TIME, or TIMESTAMP</td>
-<td>same as argument type</td>
+<td>BINARY, DECIMAL, VARCHAR, DATE, TIME, or TIMESTAMP</td>
+<td>same as argument type</td>
</tr>
<tr>
<td>SUM(expression)</td>
-<td>SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE, DECIMAL, INTERVAL</td>
-<td>BIGINT for SMALLINT or INTEGER arguments, DECIMAL for BIGINT arguments, DOUBLE for floating-point arguments, otherwise the same as the argument data type</td>
+<td>SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE, DECIMAL, INTERVAL</td>
+<td>DECIMAL for DECIMAL argument, BIGINT for any integer-type argument (including BIGINT), DOUBLE for floating-point arguments</td>
</tr>
</tbody></table>
-<p>* In this release, Drill disables the DECIMAL data type, including casting to DECIMAL and reading DECIMAL types from Parquet and Hive. You can <a href="docs/supported-data-types/#enabling-the-decimal-type">enable the DECIMAL type</a>, but this is not recommended.</p>
+<p>Starting in Drill 1.14, the DECIMAL data type is enabled by default. </p>
<p>AVG, COUNT, MIN, MAX, and SUM accept ALL and DISTINCT keywords. The default is ALL.</p>
@@ -1500,7 +1500,7 @@ Population variance of input values (the population standard deviated squared)</
Sample variance of input values (sample standard deviation squared)</li>
</ul>
-<p>These functions take a SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE, or DECIMAL expression as the argument. If the expression is FLOAT, the function returns DOUBLE; otherwise, the function returns DECIMAL. As previously mentioned, DECIMAL is disabled. You can <a href="docs/supported-data-types/#enabling-the-decimal-type">enable the DECIMAL type</a>, but this is not recommended.</p>
+<p>These functions take a SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE, or DECIMAL expression as the argument. The functions return DECIMAL for DECIMAL arguments and DOUBLE for all other arguments.</p>
diff --git a/docs/aggregate-window-functions/index.html b/docs/aggregate-window-functions/index.html
index dbf2491..f0b509f 100644
--- a/docs/aggregate-window-functions/index.html
+++ b/docs/aggregate-window-functions/index.html
@@ -1232,7 +1232,7 @@
</div>
-
+ Jun 26, 2018
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1244,41 +1244,41 @@
<table><thead>
<tr>
-<th>Window Function</th>
-<th>Argument Type</th>
-<th>Return Type</th>
-<th>Description</th>
+<th><strong>Window Function</strong></th>
+<th><strong>Argument Type</strong></th>
+<th><strong>Return Type</strong></th>
+<th><strong>Description</strong></th>
</tr>
</thead><tbody>
<tr>
<td>AVG()</td>
-<td>SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE, DECIMAL, INTERVALYEAR or INTERVALDAY</td>
-<td>DECIMAL for any integer-type argument, DOUBLE for a floating-point argument, otherwise the same as the argument data type</td>
-<td>The AVG window function returns the average value for the input expression values. The AVG function works with numeric values and ignores NULL values.</td>
+<td>SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE, DECIMAL, INTERVALYEAR or INTERVALDAY</td>
+<td>DECIMAL for DECIMAL argument, DOUBLE for all other arguments</td>
+<td>The AVG window function returns the average value for the input expression values. The AVG function works with numeric values and ignores NULL values.</td>
</tr>
<tr>
<td>COUNT()</td>
-<td>All argument data types</td>
+<td>All argument data types</td>
<td>BIGINT</td>
-<td>The COUNT() window function counts the number of input rows. COUNT(*) counts all of the rows in the target table if they do or do not include nulls. COUNT(expression) computes the number of rows with non-NULL values in a specific column or expression.</td>
+<td>The COUNT() window function counts the number of input rows. COUNT(*) counts all of the rows in the target table if they do or do not include nulls. COUNT(expression) computes the number of rows with non-NULL values in a specific column or expression.</td>
</tr>
<tr>
<td>MAX()</td>
-<td>BINARY, DECIMAL, VARCHAR, DATE, TIME, or TIMESTAMP</td>
-<td>Same as argument type</td>
-<td>The MAX() window function returns the maximum value of the expression across all input values. The MAX function works with numeric values and ignores NULL values.</td>
+<td>BINARY, DECIMAL, VARCHAR, DATE, TIME, or TIMESTAMP</td>
+<td>Same as argument type</td>
+<td>The MAX() window function returns the maximum value of the expression across all input values. The MAX function works with numeric values and ignores NULL values.</td>
</tr>
<tr>
<td>MIN()</td>
-<td>BINARY, DECIMAL, VARCHAR, DATE, TIME, or TIMESTAMP</td>
-<td>Same as argument type</td>
-<td>The MIN () window function returns the minimum value of the expression across all input values. The MIN function works with numeric values and ignores NULL values.</td>
+<td>BINARY, DECIMAL, VARCHAR, DATE, TIME, or TIMESTAMP</td>
+<td>Same as argument type</td>
+<td>The MIN () window function returns the minimum value of the expression across all input values. The MIN function works with numeric values and ignores NULL values.</td>
</tr>
<tr>
<td>SUM()</td>
-<td>SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE, DECIMAL, INTERVALDAY, or INTERVALYEAR</td>
-<td>BIGINT for SMALLINT or INTEGER arguments, DECIMAL for BIGINT arguments, DOUBLE for floating-point arguments, otherwise the same as the argument data type</td>
-<td>The SUM () window function returns the sum of the expression across all input values. The SUM function works with numeric values and ignores NULL values.</td>
+<td>SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE, DECIMAL, INTERVALDAY, or INTERVALYEAR</td>
+<td>DECIMAL for DECIMAL argument, BIGINT for any integer-type argument (including BIGINT), DOUBLE for floating-point arguments</td>
+<td>The SUM () window function returns the sum of the expression across all input values. The SUM function works with numeric values and ignores NULL values.</td>
</tr>
</tbody></table>
diff --git a/docs/configuration-options-introduction/index.html b/docs/configuration-options-introduction/index.html
index 2ec2714..27db26a 100644
--- a/docs/configuration-options-introduction/index.html
+++ b/docs/configuration-options-introduction/index.html
@@ -1232,7 +1232,7 @@
</div>
- Jun 14, 2018
+ Jun 26, 2018
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1626,9 +1626,9 @@
<td>Output format for data written to tables with the CREATE TABLE AS (CTAS) command. Allowed values are parquet, json, psv, csv, or tsv.</td>
</tr>
<tr>
-<td>store.hive.optimize_scan_with_native_readers</td>
+<td>store.hive.parquet.optimize_scan_with_native_reader</td>
<td>FALSE</td>
-<td>By default, Drill reads Hive tables using the native Hive reader. When you enable this option, Drill reads Hive tables using Drill native readers, which enables faster reads and enforces direct memory usage. Starting in Drill 1.14, this option also enables Drill to apply filter push down optimizations.</td>
+<td>By default, Drill reads Hive tables using the native Hive reader. When you enable this option, Drill reads Hive tables using Drill native readers, which enables faster reads and enforces direct memory usage. Starting in Drill 1.14, this option also enables Drill to apply filter push down optimizations. Previously, this was the store.hive.optimize_scan_with_native_readers option, which is scheduled to be deprecated in Drill 1.15.</td>
</tr>
<tr>
<td>store.json.all_text_mode</td>
diff --git a/docs/custom-function-interfaces/index.html b/docs/custom-function-interfaces/index.html
index bef29bf..082d7a1 100644
--- a/docs/custom-function-interfaces/index.html
+++ b/docs/custom-function-interfaces/index.html
@@ -1230,7 +1230,7 @@
</div>
-
+ Jun 27, 2018
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1334,7 +1334,7 @@ You provide the code in this method that determines the action Drill takes when
<h2 id="example">Example</h2>
-<p>The following example shows the program created for the <code>mysecondmin</code> function:</p>
+<p>The following example shows the program created for the <code>mysecondmin</code> function. The <code>mysecondmin</code> function looks at all the incoming values to determine if there is a new minimum value. When an incoming value is less than the minimum value, the function replaces the second minimum value with the value that was previously the minimum value.</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">package org.apache.drill.udfs;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
@@ -1370,8 +1370,8 @@ public class MyUdfs {
public void add() {
if (in.value < min.value) {
- min.value = in.value;
secondMin.value = min.value;
+ min.value = in.value;
}
}
@@ -1381,8 +1381,8 @@ public class MyUdfs {
}
@Override
public void reset() {
- min.value = 0;
- secondMin.value = 0;
+ min.value = 999999999;
+ secondMin.value = 999999999;
}
}
diff --git a/docs/data-type-conversion/index.html b/docs/data-type-conversion/index.html
index d6111c7..2b2af7a 100644
--- a/docs/data-type-conversion/index.html
+++ b/docs/data-type-conversion/index.html
@@ -1232,7 +1232,7 @@
</div>
- Mar 26, 2018
+ Jun 27, 2018
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1280,12 +1280,9 @@
<h3 id="casting-a-character-string-to-a-number">Casting a Character String to a Number</h3>
-<p>You cannot cast a character string that includes a decimal point to an INT or BIGINT. For example, if you have "1200.50" in a JSON file, attempting to select and cast the string to an INT fails. As a workaround, cast to a FLOAT or DOUBLE type, and then cast to an INT, assuming you want to lose digits to the right of the decimal point. </p>
+<p>You can cast strings or numeric values to decimals, even if they contain decimal points. In cases where a value has a scale and precision greater than the scale and precision specified in the query, the value is rounded to fit the specified scale and precision.</p>
-<div class="admonition note">
- <p class="first admonition-title">Note</p>
- <p class="last">In this release, Drill disables the DECIMAL data type. To enable, set the planner.enable_decimal_data_type option to true. </p>
-</div>
+<p>You cannot cast a character string that includes a decimal point to an INT or BIGINT. For example, if you have "1200.50" in a JSON file, attempting to select and cast the string to an INT fails. As a workaround, cast to a FLOAT or DOUBLE type, and then cast to an INT, assuming you want to lose digits to the right of the decimal point. </p>
<p>The following example shows how to cast a character to a DECIMAL having two decimal places.</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CAST('1' as DECIMAL(28, 2)) FROM (VALUES(1));
@@ -1322,13 +1319,8 @@ SELECT CAST(456 as CHAR(3)) FROM (VALUES(1));
| EXPR$0 |
+-----------------+
| -2.147483648E9 |
-+-----------------+
++-----------------+
</code></pre></div>
-<div class="admonition note">
- <p class="first admonition-title">Note</p>
- <p class="last">In this release, Drill disables the DECIMAL data type. To enable, set the planner.enable_decimal_data_type option to true. </p>
-</div>
-
<h3 id="casting-intervals">Casting Intervals</h3>
<p>To cast interval data to interval types you can query from a data source such as JSON, for example, use the following syntax, respectively:</p>
diff --git a/docs/develop-custom-functions-introduction/index.html b/docs/develop-custom-functions-introduction/index.html
index d125f1b..4c8e7d0 100644
--- a/docs/develop-custom-functions-introduction/index.html
+++ b/docs/develop-custom-functions-introduction/index.html
@@ -1230,7 +1230,7 @@
</div>
- Nov 21, 2016
+ Jun 27, 2018
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1261,7 +1261,9 @@ separate aggregate value for each combination of values from the GROUP BY clause
<p>To develop custom functions for Drill, create a Java program that implements Drill’s <a href="/docs/developing-a-simple-function/">simple</a> or <a href="/docs/developing-an-aggregate-function/">aggregate</a> interface and then add your custom function(s) to Drill. </p>
-<p>As of Drill 1.9, there are two methods for adding custom functions to Drill. Administrators can manually add custom functions to Drill, or users can issue the CREATE FUNCTION USING JAR command to register their custom functions. The CREATE FUNCTION USING JAR command is part of the <a href="/docs/dynamic-udfs/">Dynamic UDF feature</a> which requires assistance from an administrator. </p>
+<p>As of Drill 1.9, there are two methods for adding custom functions to Drill. Administrators can manually add custom functions to Drill, or users can issue the CREATE FUNCTION USING JAR command to register their custom functions. The CREATE FUNCTION USING JAR command is part of the <a href="/docs/dynamic-udfs/">Dynamic UDF feature</a> which requires assistance from an administrator. </p>
+
+<p><strong>Note:</strong> Starting in Drill 1.14, Drill supports vardecimal as the decimal data type. For custom functions that return values with a decimal data type, you must specify an appropriate FunctionTemplate.ReturnType in the FunctionTemplate. Also, verify the result of functions in queries that have a LIMIT 0 clause when LIMIT 0 optimization is enabled. </p>
diff --git a/docs/handling-different-data-types/index.html b/docs/handling-different-data-types/index.html
index 4269ea6..f5102c9 100644
--- a/docs/handling-different-data-types/index.html
+++ b/docs/handling-different-data-types/index.html
@@ -1232,7 +1232,7 @@
</div>
-
+ Jun 27, 2018
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1298,7 +1298,7 @@
<p>FLOAT and DOUBLE yield approximate results. These are variable-precision numeric types. Drill does not cast/convert all values precisely to the internal format, but instead stores approximations. Slight differences can occur in the value stored and retrieved. The following guidelines are recommended:</p>
<ul>
-<li>For conversions involving monetary calculations, for example, that require precise results use the DECIMAL type instead of FLOAT or DOUBLE. In this release, Drill disables the DECIMAL data type, including casting to DECIMAL and reading DECIMAL types from Parquet and Hive. </li>
+<li>For conversions involving monetary calculations, for example, that require precise results use the DECIMAL type instead of FLOAT or DOUBLE. Starting in Drill 1.14, the DECIMAL data type is enabled by default. </li>
<li>For complex calculations or mission-critical applications, especially those involving infinity and underflow situations, carefully consider the limitations of type casting that involves FLOAT or DOUBLE.</li>
<li>Equality comparisons between floating-point values can produce unexpected results.</li>
</ul>
diff --git a/docs/mapr-db-format/index.html b/docs/mapr-db-format/index.html
index 87a95d0..a773f64 100644
--- a/docs/mapr-db-format/index.html
+++ b/docs/mapr-db-format/index.html
@@ -1230,7 +1230,7 @@
</div>
- Jun 20, 2018
+ Jun 26, 2018
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1247,7 +1247,7 @@
<p><strong>Example</strong> </p>
<div class="highlight"><pre><code class="language-text" data-lang="text"> SELECT * FROM mfs.`/users/max/mytable`;
</code></pre></div>
-<p><strong>Note:</strong> Starting in Drill 1.14, the MapR Drill installation package includes a hive-maprdb-json-handler, which enables you to create a Hive external table from a MapR-DB JSON table and then query the table from the Hive schema. The hive-maprdb-json-handler is not included in the Apache Drill installation package.</p>
+<p><strong>Note:</strong> Starting in Drill 1.14, the MapR Drill installation package includes a hive-maprdb-json-handler, which enables you to create Hive external tables from MapR-DB JSON tables and then query the tables using the Hive schema. Drill can use the native Drill reader to read the Hive external tables. The native Drill reader enables Drill to perform faster reads of data and apply filter pushdown optimizations. The hive-maprdb-json-handler is not included in the Apache Dril [...]
diff --git a/docs/math-and-trig/index.html b/docs/math-and-trig/index.html
index acc7721..17805da 100644
--- a/docs/math-and-trig/index.html
+++ b/docs/math-and-trig/index.html
@@ -1232,7 +1232,7 @@
</div>
-
+ Jun 27, 2018
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1245,12 +1245,14 @@
<li>BIGINT</li>
<li>FLOAT</li>
<li>DOUBLE</li>
-<li>SMALLINT*</li>
+<li>SMALLINT*<br></li>
+<li>DECIMAL**</li>
</ul>
-<p>* Not supported in this release.</p>
+<p>* Not supported. Drill treats SMALLINT as INT when reading from Parquet.<br>
+** Drill implicitly casts DECIMAL to DOUBLE for functions that take DOUBLE. </p>
-<p>Exceptions are the LSHIFT and RSHIFT functions, which take all types except FLOAT and DOUBLE types. DEGREES, EXP, RADIANS, and the multiple LOG functions take the input types in this list plus the DECIMAL type. In this release, Drill disables the DECIMAL data type. To enable the DECIMAL type, set the <code>planner.enable_decimal_data_type</code> option to <code>true</code>.</p>
+<p>Exceptions are the LSHIFT and RSHIFT functions, which take all types except FLOAT and DOUBLE types. DEGREES, EXP, RADIANS, and the multiple LOG functions take the input types in this list plus the DECIMAL type. </p>
<h2 id="table-of-math-functions">Table of Math Functions</h2>
@@ -1342,9 +1344,9 @@
<td>Returns the value of x to the y power.</td>
</tr>
<tr>
-<td>RADIANS</td>
+<td>RADIANS(x)</td>
<td>FLOAT8</td>
-<td>Converts x degress to radians.</td>
+<td>Converts x degrees to radians.</td>
</tr>
<tr>
<td>RAND</td>
diff --git a/docs/parquet-format/index.html b/docs/parquet-format/index.html
index ffaafd0..c25476b 100644
--- a/docs/parquet-format/index.html
+++ b/docs/parquet-format/index.html
@@ -1230,7 +1230,7 @@
</div>
- Aug 9, 2017
+ Jun 27, 2018
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1551,7 +1551,7 @@ FROM dfs.tmp.`sampleparquet` t;
</tr>
</tbody></table>
-<p>* In this release, Drill disables the DECIMAL data type, including casting to DECIMAL and reading DECIMAL types from Parquet and Hive. To enable the DECIMAL type, set the <code>planner.enable_decimal_data_type</code> option to <code>true</code>.</p>
+<p>* Starting in Drill 1.14, the DECIMAL data type is enabled by default.</p>
<h2 id="data-description-language-support">Data Description Language Support</h2>
diff --git a/docs/querying-hive/index.html b/docs/querying-hive/index.html
index 0f7f55c..4a7fff2 100644
--- a/docs/querying-hive/index.html
+++ b/docs/querying-hive/index.html
@@ -1230,7 +1230,7 @@
</div>
- Aug 4, 2016
+ Jun 26, 2018
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1284,9 +1284,9 @@ download the <a href="http://doc.mapr.com/download/attachments/28868943/customer
<h2 id="optimizing-reads-of-parquet-backed-tables">Optimizing Reads of Parquet-Backed Tables</h2>
-<p>Use the <code>store.hive.optimize_scan_with_native_readers</code> option to optimize reads of Parquet-backed external tables from Hive. When set to TRUE, this option uses Drill native readers instead of the Hive Serde interface, resulting in more performant queries of Parquet-backed external tables. (Drill 1.2 and later)</p>
+<p>Use the <code>store.hive.parquet.optimize_scan_with_native_reader</code> option to optimize reads of Parquet-backed external tables from Hive. When set to TRUE, this option uses Drill native readers instead of the Hive Serde interface, resulting in more performant queries of Parquet-backed external tables. (Drill 1.2 and later)</p>
-<p>Set the <code>store.hive.optimize_scan_with_native_readers</code> option as described in the section, <a href="/docs/planning-and-execution-options/">"Planning and Execution Options"</a>.</p>
+<p>Set the <code>store.hive.parquet.optimize_scan_with_native_reader</code> option as described in the section, <a href="/docs/planning-and-execution-options/">"Planning and Execution Options"</a>.</p>
diff --git a/docs/supported-data-types/index.html b/docs/supported-data-types/index.html
index 7239bd4..32fcb6a 100644
--- a/docs/supported-data-types/index.html
+++ b/docs/supported-data-types/index.html
@@ -1232,7 +1232,7 @@
</div>
- Mar 26, 2018
+ Jun 27, 2018
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1314,28 +1314,58 @@
</tr>
</tbody></table>
-<p>* In the 1.0 release, Drill disables the DECIMAL data type (an alpha feature), including casting to DECIMAL and reading DECIMAL types from Parquet and Hive. The NUMERIC data type is an alias for the DECIMAL data type.<br>
+<p>* Starting in Drill 1.14, the DECIMAL data type is enabled by default.<br>
** Internally, INTERVAL is represented as INTERVALDAY or INTERVALYEAR.<br>
*** SMALLINT is not currently supported.<br>
-**** The CHAR data type is internally represented as VARCHAR by Drill. </p>
+**** The CHAR data type is internally represented as VARCHAR by Drill. </p>
-<h2 id="enabling-the-decimal-type">Enabling the DECIMAL Type</h2>
+<h2 id="decimal-data-type">DECIMAL Data Type</h2>
-<p>To enable the DECIMAL type, set the <code>planner.enable_decimal_data_type</code> option to <code>true</code>. The DECIMAL type is released as an alpha feature and not recommended for production use.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text"> ALTER SYSTEM SET `planner.enable_decimal_data_type` = true;
+<p>Starting in Drill 1.14, DECIMAL data type support is enabled by default. Drill uses the vardecimal data type to store decimal and numeric data types in a compressed format that optimizes storage space. The vardecimal data type stores decimal and numeric values as variable length columns that can represent any decimal precision. </p>
-+-------+--------------------------------------------+
-| ok | summary |
-+-------+--------------------------------------------+
-| true | planner.enable_decimal_data_type updated. |
-+-------+--------------------------------------------+
-1 row selected (0.08 seconds)
+<p>In Drill, the SQL DECIMAL and NUMERIC data types map to the <a href="https://docs.oracle.com/javase/7/docs/api/java/math/BigDecimal.html">java.math.BigDecimal</a> Java data type. </p>
+
+<h3 id="syntax">Syntax</h3>
+
+<p>The DECIMAL data type accepts numeric values, for which you can define a precision and a scale, as shown: </p>
+<div class="highlight"><pre><code class="language-text" data-lang="text"> column_name DECIMAL[(precision[,scale])]
</code></pre></div>
-<h2 id="disabling-the-decimal-type">Disabling the DECIMAL Type</h2>
+<p>Precision is an integer that indicates how many digits the number will contain. Scale is an integer that indicates the number of digits to the right of the decimal point. For example, the number 2325.67 has a precision of 6 and scale of 2. In a query, DECIMAL (6,2). </p>
+
+<p>Scale cannot be greater than the precision. If you do not indicate a precision or scale, the default precision is 38 and scale is 0. </p>
+
+<h3 id="decimal-data-type-storage-format-support">Decimal Data Type Storage Format Support</h3>
+
+<p>Drill can read and write decimal data types for the following storage formats: </p>
+
+<ul>
+<li>hive<br></li>
+<li>jdbc </li>
+<li>avro<br></li>
+</ul>
-<p>By default, Drill disables the DECIMAL data type (an alpha feature), including casting to DECIMAL and reading DECIMAL types from Parquet and Hive. If you enabled the DECIMAL type by setting <code>planner.enable_decimal_data_type</code> = true, set the option to false to disable DECIMAL.</p>
+<p>Drill can only write decimal data types to the following storage format: </p>
-<p>When the DECIMAL type is disabled, you might see DECIMAL in the query plan, but Drill internally converts DECIMAL to NUMERIC.</p>
+<ul>
+<li>parquet<br></li>
+</ul>
+
+<h3 id="decimal-type-options">Decimal Type Options</h3>
+
+<p>You can use the <a href="/docs/set/">SET command</a> with the <code>planner.enable_decimal_data_type</code> option to turn DECIMAL data type support off and on. If you disable the <code>planner.enable_decimal_data_type</code> option (by setting it to false), Drill treats decimal literals as DOUBLE. </p>
+
+<p>Drill 1.14 introduces the following additional decimal-related options for the Parquet storage format that you can modify using the <a href="/docs/set/">SET command</a>: </p>
+
+<ul>
+<li><p><code>store.parquet.writer.use_primitive_types_for_decimals (boolean)</code><br>
+Allows Drill to use INT32 and INT64 logical types when storing decimal values in Parquet if the precision of the value allows it. Default is true. Set to false to prevent Drill from using INT32 and INT64 logical types, as shown: </p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">SET `store.parquet.writer.use_primitive_types_for_decimals` = false;
+</code></pre></div></li>
+<li><p><code>store.parquet.writer.logical_type_for_decimals</code>
+Indicates the logical type that Drill should use to store decimals. The default is fixed_len_byte_array. Alternatively, you can set this option to binary, as shown: </p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">SET `store.parquet.writer.logical_type_for_decimals` = 'binary';
+</code></pre></div></li>
+</ul>
<h2 id="composite-types">Composite Types</h2>
diff --git a/feed.xml b/feed.xml
index 26cf88a..1c87678 100644
--- a/feed.xml
+++ b/feed.xml
@@ -6,8 +6,8 @@
</description>
<link>/</link>
<atom:link href="/feed.xml" rel="self" type="application/rss+xml"/>
- <pubDate>Thu, 21 Jun 2018 16:44:14 -0700</pubDate>
- <lastBuildDate>Thu, 21 Jun 2018 16:44:14 -0700</lastBuildDate>
+ <pubDate>Wed, 27 Jun 2018 15:06:38 -0700</pubDate>
+ <lastBuildDate>Wed, 27 Jun 2018 15:06:38 -0700</lastBuildDate>
<generator>Jekyll v2.5.2</generator>
<item>