drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bridg...@apache.org
Subject [drill-site] branch asf-site updated: doc edits and updates for Drill 1.14
Date Wed, 27 Jun 2018 22:17:06 GMT
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 <bbevens@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 &lt; 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 &quot;1200.50&quot; 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 &quot;1200.50&quot; 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(&#39;1&#39; 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/">&quot;Planning
and Execution Options&quot;</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/">&quot;Planning
and Execution Options&quot;</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` = &#39;binary&#39;;  
+</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>


Mime
View raw message