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 2015/10/08 02:04:55 UTC
drill-site git commit: metadata caching and odbc driver link updates
Repository: drill-site
Updated Branches:
refs/heads/asf-site 02bdbdac0 -> 0d36d04d0
metadata caching and odbc driver link updates
Project: http://git-wip-us.apache.org/repos/asf/drill-site/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill-site/commit/0d36d04d
Tree: http://git-wip-us.apache.org/repos/asf/drill-site/tree/0d36d04d
Diff: http://git-wip-us.apache.org/repos/asf/drill-site/diff/0d36d04d
Branch: refs/heads/asf-site
Commit: 0d36d04d090cba9348ae0797f62da63d66a6f46b
Parents: 02bdbda
Author: Bridget Bevens <bb...@maprtech.com>
Authored: Wed Oct 7 17:04:33 2015 -0700
Committer: Bridget Bevens <bb...@maprtech.com>
Committed: Wed Oct 7 17:04:33 2015 -0700
----------------------------------------------------------------------
.../browsing-data-and-defining-views/index.html | 2 +-
docs/configuring-odbc-on-linux/index.html | 11 +++++++----
docs/configuring-odbc-on-mac-os-x/index.html | 13 ++++++++-----
docs/configuring-odbc-on-windows/index.html | 6 +++++-
docs/drill-introduction/index.html | 2 +-
docs/img/explorer-connect.png | Bin 31369 -> 29945 bytes
docs/img/explorer-schemas.png | Bin 15580 -> 14332 bytes
docs/img/odbc-configure2.png | Bin 48218 -> 56060 bytes
docs/img/odbc-configure3.png | Bin 49108 -> 57224 bytes
docs/img/odbc-define-view.png | Bin 88744 -> 88806 bytes
docs/img/odbc-explorer-win.png | Bin 25610 -> 24127 bytes
docs/installing-the-driver-on-linux/index.html | 4 ++--
.../index.html | 4 ++--
.../installing-the-driver-on-windows/index.html | 4 ++--
.../index.html | 2 +-
docs/odbc-configuration-reference/index.html | 5 +++++
docs/optimizing-parquet-reading/index.html | 10 ++++------
docs/testing-the-odbc-connection/index.html | 6 +++---
feed.xml | 4 ++--
19 files changed, 43 insertions(+), 30 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/drill-site/blob/0d36d04d/docs/browsing-data-and-defining-views/index.html
----------------------------------------------------------------------
diff --git a/docs/browsing-data-and-defining-views/index.html b/docs/browsing-data-and-defining-views/index.html
index c93b89e..4ec1c0c 100644
--- a/docs/browsing-data-and-defining-views/index.html
+++ b/docs/browsing-data-and-defining-views/index.html
@@ -1027,7 +1027,7 @@ The data from <code>nation.parquet</code> appears in the Preview pane.
<li>Start Drill Explorer and connect to the sample DSN.<br></li>
<li>In the <strong>Schemas</strong> section on the <strong>Browse</strong> tab, navigate to the <code>/sample-data/nation.parquet</code> in the <code>dfs.default</code> schema. </li>
<li><p>On the <strong>SQL</strong> tab, in the <strong>View Definition SQL</strong> field, enter a query, as described in the <a href="">Specifying Column Names</a>. For example, modify the SELECT statement as follows:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT N_NAME, N_REGIONKEY FROM `dfs.default`.`./Users/drilluser/drill/apache-drill-1.0.0/sample-data/nation.parquet` WHERE N_REGIONKEY IN (2, 4)
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT N_NAME, N_REGIONKEY FROM `dfs.default`.`./Users/drilluser/drill/sample-data/nation.parquet` WHERE N_REGIONKEY IN (2, 4)
</code></pre></div>
<p>Do not put a semicolon at the end of the SQL statement. </p></li>
<li><p>Click <strong>Preview</strong>.
http://git-wip-us.apache.org/repos/asf/drill-site/blob/0d36d04d/docs/configuring-odbc-on-linux/index.html
----------------------------------------------------------------------
diff --git a/docs/configuring-odbc-on-linux/index.html b/docs/configuring-odbc-on-linux/index.html
index d405754..4e9e57e 100644
--- a/docs/configuring-odbc-on-linux/index.html
+++ b/docs/configuring-odbc-on-linux/index.html
@@ -1161,6 +1161,7 @@ file. This configures the driver to work with your ODBC driver manager. The foll
<p><strong>Example</strong></p>
<div class="highlight"><pre><code class="language-text" data-lang="text">. . .
[Driver]
+DisableAsync=0
DriverManagerEncoding=UTF-32
ErrorMessagesPath=/opt/mapr/drillodbc/ErrorMessages
LogLevel=0
@@ -1180,14 +1181,16 @@ ODBCInstLib=libiodbcinst.so
<p>To configure the MapR Drill ODBC Driver in the <code>mapr.drillodbc.ini</code> configuration file, complete the following steps:</p>
<ol>
-<li>Open the <code>mapr.drillodbc.ini</code> configuration file in a text editor.</li>
-<li>Edit the DriverManagerEncoding setting if necessary. The value is typically UTF-16 or UTF-32, but depends on the driver manager used. iODBC uses UTF-32 and unixODBC uses UTF-16. Review your ODBC Driver Manager documentation for the correct setting.</li>
-<li><p>Edit the <code>ODBCInstLib</code> setting. The value is the name of the <code>ODBCInst</code> shared library for the ODBC driver manager that you use. The configuration file defaults to the shared library for <code>iODBC</code>. In Linux, the shared library name for iODBC is <code>libiodbcinst.so</code>. </p>
+<li>Open the <code>mapr.drillodbc.ini</code> configuration file in a text editor.<br></li>
+<li>Edit the DisableAsync setting if you want to enable a synchronous ODBC connection for performance reasons. Change the default 0 to 1 to disable the asynchronous and enable the synchronous connection.<br>
+ A change in state occurs during driver initialization and is propagated to all driver DSNs.<br></li>
+<li>Edit the DriverManagerEncoding setting if necessary. The value is typically UTF-16 or UTF-32, but depends on the driver manager used. iODBC uses UTF-32 and unixODBC uses UTF-16. Review your ODBC Driver Manager documentation for the correct setting.<br></li>
+<li><p>Edit the <code>ODBCInstLib</code> setting. The value is the name of the <code>ODBCInst</code> shared library for the ODBC driver manager that you use. The configuration file defaults to the shared library for <code>iODBC</code>. In Linux, the shared library name for iODBC is <code>libiodbcinst.so</code>. </p>
<p>Specify an absolute or relative filename for the library. If you use
the relative file name, include the path to the library in the library path
environment variable. The library path environment variable is named
-<code>LD_LIBRARY_PATH</code>. </p></li>
+<code>LD_LIBRARY_PATH</code>. </p></li>
<li><p>Save the <code>mapr.drillodbc.ini</code> configuration file.</p></li>
</ol>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/0d36d04d/docs/configuring-odbc-on-mac-os-x/index.html
----------------------------------------------------------------------
diff --git a/docs/configuring-odbc-on-mac-os-x/index.html b/docs/configuring-odbc-on-mac-os-x/index.html
index 9dd9bcc..33eb986 100644
--- a/docs/configuring-odbc-on-mac-os-x/index.html
+++ b/docs/configuring-odbc-on-mac-os-x/index.html
@@ -1007,7 +1007,7 @@ steps:</p>
<h2 id="sample-configuration-files">Sample Configuration Files</h2>
<p>Before you connect to Drill through an ODBC client tool
-on Mac OS X, copy the following configuration files in <code>/opt/mapr/drillobdc/Setup</code> to your home directory unless the files already exist in your home directory:</p>
+on Mac OS X, copy the following configuration files in <code>/opt/mapr/drillodbc/Setup</code> to your home directory unless the files already exist in your home directory:</p>
<ul>
<li><code>mapr.drillodbc.ini</code></li>
@@ -1157,6 +1157,7 @@ file. This configures the driver to work with your ODBC driver manager. The foll
<p><strong>Example</strong></p>
<div class="highlight"><pre><code class="language-text" data-lang="text">[Driver]
## - Note that this default DriverManagerEncoding of UTF-32 is for iODBC.
+DisableAsync=0
DriverManagerEncoding=UTF-32
ErrorMessagesPath=/opt/mapr/drillodbc/ErrorMessages
@@ -1172,14 +1173,16 @@ ODBCInstLib=libiodbcinst.dylib
<p>To configure the MapR Drill ODBC Driver in the <code>mapr.drillodbc.ini</code> configuration file, complete the following steps:</p>
<ol>
-<li>Open the <code>mapr.drillodbc.ini</code> configuration file in a text editor.</li>
-<li>Edit the DriverManagerEncoding setting if necessary. The value is typically UTF-16 or UTF-32, but depends on the driver manager used. iODBC uses UTF-32 and unixODBC uses UTF-16. Review your ODBC Driver Manager documentation for the correct setting.</li>
-<li><p>Edit the <code>ODBCInstLib</code> setting. The value is the name of the <code>ODBCInst</code> shared library for the ODBC driver manager that you use. The configuration file defaults to the shared library for <code>iODBC</code>. The shared library name for <code>iODBC</code> is <code>libiodbcinst.dylib</code>.</p>
+<li>Open the <code>mapr.drillodbc.ini</code> configuration file in a text editor.<br></li>
+<li>Edit the DisableAsync setting if you want to enable a synchronous ODBC connection for performance reasons. Change the default 0 to 1 to disable the asynchronous and enable the synchronous connection.<br>
+ A change in state occurs during driver initialization and is propagated to all driver DSNs.<br></li>
+<li>Edit the DriverManagerEncoding setting if necessary. The value is typically UTF-16 or UTF-32, but depends on the driver manager used. iODBC uses UTF-32 and unixODBC uses UTF-16. Review your ODBC Driver Manager documentation for the correct setting.<br></li>
+<li><p>Edit the <code>ODBCInstLib</code> setting. The value is the name of the <code>ODBCInst</code> shared library for the ODBC driver manager that you use. The configuration file defaults to the shared library for <code>iODBC</code>. The shared library name for <code>iODBC</code> is <code>libiodbcinst.dylib</code>. </p>
<p>Specify an absolute or relative filename for the library. If you use
the relative file name, include the path to the library in the library path
environment variable. The library path environment variable is
-named <code>DYLD_LIBRARY_PATH</code>.</p></li>
+named <code>DYLD_LIBRARY_PATH</code>. </p></li>
<li><p>Save the <code>mapr.drillodbc.ini</code> configuration file.</p></li>
</ol>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/0d36d04d/docs/configuring-odbc-on-windows/index.html
----------------------------------------------------------------------
diff --git a/docs/configuring-odbc-on-windows/index.html b/docs/configuring-odbc-on-windows/index.html
index 2e14aed..fd15c9d 100644
--- a/docs/configuring-odbc-on-windows/index.html
+++ b/docs/configuring-odbc-on-windows/index.html
@@ -1049,7 +1049,11 @@ Name of the drillbit cluster. Check the drill-override.conf file for ZooKeeper n
<p>Check the <code>drill-override.conf</code> file for the cluster name.
<img src="/docs/img/odbc-configure3.png" alt=""></p>
-<p><a href="/docs/odbc-configuration-reference/">Advanced Properties</a>, <a href="/docs/odbc-configuration-reference/#logging-options">logging options</a>, and <a href="/docs/drill-explorer-introduction/">Drill Explorer</a> sections describe the options at the bottom of this dialog.</p>
+<p>The <a href="/docs/odbc-configuration-reference/">Advanced Properties</a> section describes the advanced properties.</p>
+
+<p>Select the Disable Async option to disable the asynchronous ODBC connection and enable a synchronous ODBC connection for performance reasons. By default the ODBC connection is asynchronous (Disable Asynch is not checked). A change in state occurs during driver initialization and is propagated to all driver DSNs.</p>
+
+<p><a href="/docs/odbc-configuration-reference/#logging-options">Logging Options</a> and <a href="/docs/drill-explorer-introduction/">Drill Explorer</a> sections describe the options at the bottom of this dialog.</p>
<h3 id="next-step">Next Step</h3>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/0d36d04d/docs/drill-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/drill-introduction/index.html b/docs/drill-introduction/index.html
index f85211a..98bb01e 100644
--- a/docs/drill-introduction/index.html
+++ b/docs/drill-introduction/index.html
@@ -1004,7 +1004,7 @@ This release of Drill fixes [many issues]() and introduces a number of enhanceme
* A number of new [SQL window functions](/docs/sql-window-functions)
* [NTILE](/docs/ranking-window-functions/#ntile)
- * [LEAD and LEAD](/docs/value-window-functions/#lag-lead)
+ * [LAG and LEAD](/docs/value-window-functions/#lag-lead)
* [FIRST_VALUE and LAST_VALUE](/docs/value-window-functions/#first_value-last_value)
* [Security](/docs/configuring-web-console-and-rest-api-security/) for Web Console and REST API operations
* Performance improvements for [querying HBase](/docs/querying-hbase/#querying-big-endian-encoded-data), which includes leveraging [ordered byte encoding](/docs/querying-hbase/#leveraging-hbase-ordered-byte-encoding)
http://git-wip-us.apache.org/repos/asf/drill-site/blob/0d36d04d/docs/img/explorer-connect.png
----------------------------------------------------------------------
diff --git a/docs/img/explorer-connect.png b/docs/img/explorer-connect.png
index b89c8f8..752bce9 100644
Binary files a/docs/img/explorer-connect.png and b/docs/img/explorer-connect.png differ
http://git-wip-us.apache.org/repos/asf/drill-site/blob/0d36d04d/docs/img/explorer-schemas.png
----------------------------------------------------------------------
diff --git a/docs/img/explorer-schemas.png b/docs/img/explorer-schemas.png
index 4f8ad9f..3a9a53a 100644
Binary files a/docs/img/explorer-schemas.png and b/docs/img/explorer-schemas.png differ
http://git-wip-us.apache.org/repos/asf/drill-site/blob/0d36d04d/docs/img/odbc-configure2.png
----------------------------------------------------------------------
diff --git a/docs/img/odbc-configure2.png b/docs/img/odbc-configure2.png
index 21db003..af79337 100644
Binary files a/docs/img/odbc-configure2.png and b/docs/img/odbc-configure2.png differ
http://git-wip-us.apache.org/repos/asf/drill-site/blob/0d36d04d/docs/img/odbc-configure3.png
----------------------------------------------------------------------
diff --git a/docs/img/odbc-configure3.png b/docs/img/odbc-configure3.png
index e04707b..9d6e9e0 100644
Binary files a/docs/img/odbc-configure3.png and b/docs/img/odbc-configure3.png differ
http://git-wip-us.apache.org/repos/asf/drill-site/blob/0d36d04d/docs/img/odbc-define-view.png
----------------------------------------------------------------------
diff --git a/docs/img/odbc-define-view.png b/docs/img/odbc-define-view.png
index 70b4af8..07ed985 100644
Binary files a/docs/img/odbc-define-view.png and b/docs/img/odbc-define-view.png differ
http://git-wip-us.apache.org/repos/asf/drill-site/blob/0d36d04d/docs/img/odbc-explorer-win.png
----------------------------------------------------------------------
diff --git a/docs/img/odbc-explorer-win.png b/docs/img/odbc-explorer-win.png
index 5d37cc9..04bda8a 100644
Binary files a/docs/img/odbc-explorer-win.png and b/docs/img/odbc-explorer-win.png differ
http://git-wip-us.apache.org/repos/asf/drill-site/blob/0d36d04d/docs/installing-the-driver-on-linux/index.html
----------------------------------------------------------------------
diff --git a/docs/installing-the-driver-on-linux/index.html b/docs/installing-the-driver-on-linux/index.html
index e91b49e..4d6c0f2 100644
--- a/docs/installing-the-driver-on-linux/index.html
+++ b/docs/installing-the-driver-on-linux/index.html
@@ -1042,8 +1042,8 @@ Example: <code>127.0.0.1 localhost</code></p></li>
<p>Download either the 32- or 64-bit driver:</p>
<ul>
-<li><a href="http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v1.1.0.1000/MapRDrillODBC-32bit-1.1.0.i686.rpm">MapR Drill ODBC Driver (32-bit)</a></li>
-<li><a href="http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v1.1.0.1000/MapRDrillODBC-1.1.0.x86_64.rpm">MapR Drill ODBC Driver (64-bit)</a></li>
+<li><a href="http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v1.2.0.1000/MapRDrillODBC-32bit-1.2.0.i686.rpm">MapR Drill ODBC Driver (32-bit)</a></li>
+<li><a href="http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v1.2.0.1000/MapRDrillODBC-1.2.0.x86_64.rpm">MapR Drill ODBC Driver (64-bit)</a></li>
</ul>
<h2 id="step-2:-install-the-mapr-drill-odbc-driver">Step 2: Install the MapR Drill ODBC Driver</h2>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/0d36d04d/docs/installing-the-driver-on-mac-os-x/index.html
----------------------------------------------------------------------
diff --git a/docs/installing-the-driver-on-mac-os-x/index.html b/docs/installing-the-driver-on-mac-os-x/index.html
index c9259ae..3a40e42 100644
--- a/docs/installing-the-driver-on-mac-os-x/index.html
+++ b/docs/installing-the-driver-on-mac-os-x/index.html
@@ -1026,7 +1026,7 @@ Example: <code>127.0.0.1 localhost</code></p></li>
<p>Click the following link to download the driver: </p>
-<p><a href="http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v1.1.0.1000/MapRDrillODBC.dmg">MapR Drill ODBC Driver for Mac</a></p>
+<p><a href="http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v1.2.0.1000/MapRDrillODBC.dmg">MapR Drill ODBC Driver for Mac</a></p>
<hr>
@@ -1057,7 +1057,7 @@ Example: <code>127.0.0.1 localhost</code></p></li>
<p>To check the version of the driver you installed, use the following command on the terminal command line:</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">$ pkgutil --info mapr.drillodbc
package-id: mapr.drillodbc
-version: 1.0.0
+version: 1.2.0
volume: /
location:
install-time: 1433465518
http://git-wip-us.apache.org/repos/asf/drill-site/blob/0d36d04d/docs/installing-the-driver-on-windows/index.html
----------------------------------------------------------------------
diff --git a/docs/installing-the-driver-on-windows/index.html b/docs/installing-the-driver-on-windows/index.html
index 9d165de..ce717f2 100644
--- a/docs/installing-the-driver-on-windows/index.html
+++ b/docs/installing-the-driver-on-windows/index.html
@@ -1036,8 +1036,8 @@ Example: <code>127.0.0.1 localhost</code></p></li>
<p>Download the installer that corresponds to the bitness of the client application from which you want to create an ODBC connection:</p>
<ul>
-<li><a href="http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v1.1.0.1000/MapRDrillODBC32.msi">MapR Drill ODBC Driver (32-bit)</a><br></li>
-<li><a href="http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v1.1.0.1000/MapRDrillODBC64.msi">MapR Drill ODBC Driver (64-bit)</a></li>
+<li><a href="http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v1.2.0.1000/MapRDrillODBC32.msi">MapR Drill ODBC Driver (32-bit)</a><br></li>
+<li><a href="http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v1.2.0.1000/MapRDrillODBC64.msi">MapR Drill ODBC Driver (64-bit)</a></li>
</ul>
<hr>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/0d36d04d/docs/installing-the-tdc-file-on-windows/index.html
----------------------------------------------------------------------
diff --git a/docs/installing-the-tdc-file-on-windows/index.html b/docs/installing-the-tdc-file-on-windows/index.html
index 4b6442b..8e62b3a 100644
--- a/docs/installing-the-tdc-file-on-windows/index.html
+++ b/docs/installing-the-tdc-file-on-windows/index.html
@@ -999,7 +999,7 @@
<ol>
<li><p>Click <strong>Start</strong>, and locate the Install Tableau TDC File app that the MapR Drill ODBC Driver installer installed.<br>
-For example, on Windows 8.1 in Apps, the Install Tableau TDC File appears under MaprDrill ODBC Driver 1.0:
+For example, on Windows 8.1 in Apps, the Install Tableau TDC File appears under MaprDrill ODBC Driver:
<img src="/docs/img/odbc-mapr-drill-apps.png" alt=""></p></li>
<li><p>Click <strong>Install Tableau TDC File</strong>. </p></li>
<li><p>When the installation completes, press any key to continue.<br>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/0d36d04d/docs/odbc-configuration-reference/index.html
----------------------------------------------------------------------
diff --git a/docs/odbc-configuration-reference/index.html b/docs/odbc-configuration-reference/index.html
index fcdab99..8db3e6c 100644
--- a/docs/odbc-configuration-reference/index.html
+++ b/docs/odbc-configuration-reference/index.html
@@ -1073,6 +1073,11 @@ Drill ODBC Driver. You can use these options in a connection string or in the
<td>{<property>;<property>; . . .}</td>
<td>Separate advanced properties using a semi-colon (;) and then surround all advanced properties in a connection string using braces { and }.</td>
</tr>
+<tr>
+<td>DisableAsync</td>
+<td>0 or 1</td>
+<td>Disables asynchronous ODBC connection and enables a synchronous connection. A change in state occurs during driver initialization and is propagated to all driver DSNs.</td>
+</tr>
</tbody></table>
<h3 id="catalog">Catalog</h3>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/0d36d04d/docs/optimizing-parquet-reading/index.html
----------------------------------------------------------------------
diff --git a/docs/optimizing-parquet-reading/index.html b/docs/optimizing-parquet-reading/index.html
index e6e19bf..7e144ba 100644
--- a/docs/optimizing-parquet-reading/index.html
+++ b/docs/optimizing-parquet-reading/index.html
@@ -991,13 +991,11 @@
<div class="int_text" align="left">
- <p>Parquet metadata caching is an optional feature in Drill 1.2 and later. When you use this feature, Drill generates a metadata cache file. Drill stores the metadata cache file in a directory you specify and its subdirectories. When you run a query on this directory or a subdirectory, Drill reads the metadata cache file instead of the actual files that contain the metadata during the query-planning phase. You can realize performance improvements during the query-planning phase when Drill reads just one metadata file instead of reading multiple files to fetch the metadata.</p>
-
-<p>The Parquet metadata caching feature enables Drill to speed up the cost of query planning. The actual query runtime will not be improved if the planning cost is not a bottleneck.</p>
+ <p>Parquet metadata caching is an optional feature in Drill 1.2 and later. When you use this feature, Drill generates a metadata cache file. Drill stores the metadata cache file in a directory you specify and its subdirectories. When you run a query on this directory or a subdirectory, Drill reads a single metadata cache file instead of retrieving metadata from multiple Parquet files during the query-planning phase.</p>
<h2 id="when-to-use-parquet-metadata-caching">When to Use Parquet Metadata Caching</h2>
-<p>Use Parquet metadata caching to optimize reads only when the planning phase of a query takes longer than the execution phase. Before using this feature, run your query and compare the time for executing the logical (planning) and physical (execution) operations to see if using this feature makes sense. The logical/planning operations must take longer than the physical/execution operations; otherwise, do not create Parquet metadata because Drill cannot optimize reads under these conditions.</p>
+<p>The scenarios in which metadata caching is useful is when the planning time is a significant percentage of the total elapsed time of the query. If the query execution time is the dominant factor then metadata caching will have very little impact. Before using this feature, run an EXPLAIN plan on your query and compare its time to the total time of query execution. Use these timings to determine whether metadata caching will be useful.</p>
<h2 id="how-to-trigger-generation-of-the-parquet-metadata-cache-file">How to Trigger Generation of the Parquet Metadata Cache File</h2>
@@ -1007,7 +1005,7 @@
<p>You need to run this command on a directory, nested or flat, only once during the session. Only the first query gathers the metadata unless the Parquet data changes, for example, you delete some data. If you did not make changes to the Parquet data, subsequent queries encounter the up-to-date Parquet metadata files. There is no need for Drill to regenerate the metadata. If there are changes, the metadata needs updating, so Drill regenerates the Parquet metadata when you issue the next query.</p>
-<p>The elapsed time of any queries that trigger regeneration of data can be greater than that of other queries.</p>
+<p>The elapsed time of the first query that triggers regeneration of metadata can be greater than that of subsequent queries that use that metadata.</p>
<h2 id="example-of-generating-parquet-metadata">Example of Generating Parquet Metadata</h2>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:schema=dfs> REFRESH TABLE METADATA t1;
@@ -1020,7 +1018,7 @@
</code></pre></div>
<h2 id="how-drill-generates-and-uses-parquet-metadata">How Drill Generates and Uses Parquet Metadata</h2>
-<p>After running the REFRESH TABLE METADATA command, Drill traverses directories in the case of nested directories to find the Parquet files. From the footers of the files, Drill gathers metadata, such as row counts and node affinity based on HDFS block locations. For each directory level, Drill saves a summary of the information from the footers in a single Parquet metadata cache file. The summary at each level covers that particular level and all lower levels; consequently, after generating metadata, you can query nested directories from any level. For example, you can query a subdirectory of Parquet files because Drill stores a Parquet metadata cache file at each level.</p>
+<p>After running the REFRESH TABLE METADATA command, Drill traverses directories in the case of nested directories to find the Parquet files. From the footers of the files, Drill gathers metadata, such as row counts and node affinity based on HDFS block locations. For each directory level, Drill saves a summary of the information from the footers in a single Parquet metadata cache file. The summary at each level covers that particular level and all child levels; consequently, after generating metadata, you can query nested directories from any level. In order to leverage the metadata cache file for a table t, the file must exist at the root directory of that table. For example, you can query a subdirectory of Parquet files because Drill stores a Parquet metadata cache file at each level.</p>
<p>At planning time, Drill reads only the metadata file. Parquet metadata caching has no effect on execution time. At execution time, Drill reads the actual files.</p>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/0d36d04d/docs/testing-the-odbc-connection/index.html
----------------------------------------------------------------------
diff --git a/docs/testing-the-odbc-connection/index.html b/docs/testing-the-odbc-connection/index.html
index 246d9c3..5e038a7 100644
--- a/docs/testing-the-odbc-connection/index.html
+++ b/docs/testing-the-odbc-connection/index.html
@@ -1018,8 +1018,8 @@ using the iODBC driver manager.</p>
<ol>
<li><p><a href="/docs/starting-drill-on-linux-and-mac-os-x/">Start Drill</a>. For example, to start Drill in local mode on a linux cluster: </p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">[root@centos23 drill-1.0.0]# bin/drill-localhost
-apache drill 1.0.0
+<div class="highlight"><pre><code class="language-text" data-lang="text">[root@centos23 drill-1.2.0]# bin/drill-localhost
+apache drill 1.2.0
"the only truly happy people are children, the creative minority and drill users"
</code></pre></div></li>
<li><p>In the <code>samples</code> directory of the driver manager installation, run <code>iodbctest</code> or <code>iodbctestw</code>. </p>
@@ -1047,7 +1047,7 @@ Enter ODBC connect string (? shows list):
<div class="highlight"><pre><code class="language-text" data-lang="text">DSN=<DSN Name>;ConnectionType=ZooKeeper;ZKQuorum=<Server1:Port1>,<Server2:Port2>;ZKClusterID=<Cluster Name>`
</code></pre></div>
<p>The output of a successful test is:<br>
- <code>Driver: 1.0.0.1001 (MapR Drill ODBC Driver)
+ <code>Driver: 1.2.0.1001 (MapR Drill ODBC Driver)
SQL></code><br>
After the <code>SQL></code> prompt appears, type <code>quit;</code>, and go to the Drill shell to run commands. Do not attempt to run SQL commands from this prompt.</p></li>
</ol>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/0d36d04d/feed.xml
----------------------------------------------------------------------
diff --git a/feed.xml b/feed.xml
index 605484d..c53fa76 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>Wed, 07 Oct 2015 15:54:20 -0700</pubDate>
- <lastBuildDate>Wed, 07 Oct 2015 15:54:20 -0700</lastBuildDate>
+ <pubDate>Wed, 07 Oct 2015 16:59:59 -0700</pubDate>
+ <lastBuildDate>Wed, 07 Oct 2015 16:59:59 -0700</lastBuildDate>
<generator>Jekyll v2.5.2</generator>
<item>