drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bridg...@apache.org
Subject drill-site git commit: metadata caching and odbc driver link updates
Date Thu, 08 Oct 2015 00:04:55 GMT
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 <bbevens@maprtech.com>
Authored: Wed Oct 7 17:04:33 2015 -0700
Committer: Bridget Bevens <bbevens@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>{&lt;property&gt;;&lt;property&gt;; . . .}</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&gt; 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 
 &quot;the only truly happy people are children, the creative minority and drill users&quot;
 </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=&lt;DSN
Name&gt;;ConnectionType=ZooKeeper;ZKQuorum=&lt;Server1:Port1&gt;,&lt;Server2:Port2&gt;;ZKClusterID=&lt;Cluster
Name&gt;`
 </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&gt;</code><br>
  After the <code>SQL&gt;</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>


Mime
View raw message