Repository: drill-site
Updated Branches:
refs/heads/asf-site f30add6fd -> 50300febe
updates to odbc driver docs for mac os x
Project: http://git-wip-us.apache.org/repos/asf/drill-site/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill-site/commit/50300feb
Tree: http://git-wip-us.apache.org/repos/asf/drill-site/tree/50300feb
Diff: http://git-wip-us.apache.org/repos/asf/drill-site/diff/50300feb
Branch: refs/heads/asf-site
Commit: 50300febe6177f5b57df9aaa214b75ba5197c831
Parents: f30add6
Author: Bridget Bevens <bbevens@maprtech.com>
Authored: Tue Jan 24 14:32:19 2017 -0800
Committer: Bridget Bevens <bbevens@maprtech.com>
Committed: Tue Jan 24 14:32:19 2017 -0800
----------------------------------------------------------------------
docs/configuring-odbc-on-mac-os-x/index.html | 119 +++++++++----------
docs/img/odbc_data_source_names.png | Bin 0 -> 142484 bytes
docs/img/odbc_login.png | Bin 0 -> 16687 bytes
docs/img/success.png | Bin 0 -> 31079 bytes
.../index.html | 30 +++--
docs/testing-the-odbc-connection/index.html | 14 +--
feed.xml | 4 +-
7 files changed, 85 insertions(+), 82 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/drill-site/blob/50300feb/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 ac08ed4..b226d00 100644
--- a/docs/configuring-odbc-on-mac-os-x/index.html
+++ b/docs/configuring-odbc-on-mac-os-x/index.html
@@ -1099,7 +1099,7 @@
</div>
- Dec 24, 2016
+ Jan 24, 2017
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1110,20 +1110,21 @@ sources and drivers. To configure an ODBC connection for Linux or
Mac OS X, comp
steps:</p>
<ul>
-<li><a href="/docs/configuring-odbc-on-mac-os-x/#step-1:-set-environment-variables">Step
1: Set Environment Variables</a></li>
-<li><a href="/docs/configuring-odbc-on-mac-os-x/#step-2:-define-the-odbc-data-sources-in-.odbc.ini">Step
2: Define the ODBC Data Sources in odbc.ini</a></li>
-<li><a href="/docs/configuring-odbc-on-mac-os-x/#step-4:-configure-the-mapr-drill-odbc-driver">Step
3: Configure the MapR Drill ODBC Driver</a></li>
+<li><a href="/docs/configuring-odbc-on-mac-os-x/#step-1:-copy-sample-configuration-files">Step
1: Copy Sample Configuration Files</a></li>
+<li><a href="/docs/configuring-odbc-on-mac-os-x/#step-2:-set-environment-variables">Step
2: Set Environment Variables</a></li>
+<li><a href="/docs/configuring-odbc-on-mac-os-x/#step-3:-define-the-odbc-data-sources-in-.odbc.ini">Step
3: Define the ODBC Data Sources in odbc.ini</a></li>
+<li><a href="/docs/configuring-odbc-on-mac-os-x/#step-4:-configure-the-mapr-drill-odbc-driver">Step
4: Configure the MapR Drill ODBC Driver</a></li>
</ul>
-<h2 id="sample-configuration-files">Sample Configuration Files</h2>
+<h2 id="step-1:-copy-sample-configuration-files">Step 1: Copy 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/drillodbc/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/drill/Setup</code>
to your home directory unless the files already exist in your home directory:</p>
<ul>
<li><code>mapr.drillodbc.ini</code></li>
-<li><code>odbc.ini</code></li>
-<li><code>odbcinst.ini</code></li>
+<li><code>.odbc.ini</code></li>
+<li><code>.odbcinst.ini</code></li>
</ul>
<p>In your home directory, rename the files as hidden files. Use sudo if necessary:</p>
@@ -1131,6 +1132,7 @@ on Mac OS X, copy the following configuration files in <code>/opt/mapr/drillodbc
<ul>
<li>.mapr.drillodbc.ini</li>
<li>.odbc.ini</li>
+<li>.odbcinst.ini</li>
</ul>
<p>The installer for Mac OS X creates a sample user DSN in odbc.ini in either of the
following locations:</p>
@@ -1149,20 +1151,19 @@ on Mac OS X, copy the following configuration files in <code>/opt/mapr/drillodbc
<hr>
-<h2 id="step-1:-set-environment-variables">Step 1: Set Environment Variables</h2>
+<h2 id="step-2:-set-environment-variables">Step 2: Set Environment Variables</h2>
-<p>Create or modify the <code>/etc/launchd.conf</code> file to set environment
variables. Set the SIMBAINI variable to point to the <code>.mapr.drillodbc.ini</code>
file, the ODBCINI variable to the <code>.odbc.ini</code> file, and the DYLD_LIBRARY_PATH
to the location of the dynamic linker (DYLD) libraries and to the MapR Drill ODBC Driver.
</p>
+<p>Create or modify the <code>/etc/launchd.conf</code> file to set environment
variables. Set the MAPRDRILLINI variable to point to the <code>.mapr.drillodbc.ini</code>
file. </p>
-<p>If you installed the iODBC driver manager using the DMG, the DYLD libraries are
installed in <code>/usr/local/iODBC/lib</code>. The launchd.conf file should look
something like this:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">setenv
SIMBAINI /Users/joeuser/.mapr.drillodbc.ini
+<p>If you installed the iODBC driver manager using the DMG, the dynamic linker (DYLD)
libraries are installed in <code>/usr/local/iODBC/lib</code>. The launchd.conf
file should look something like this:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">setenv
MAPRDRILLINI /Users/joeuser/.mapr.drillodbc.ini
setenv ODBCINI /Users/joeuser/.odbc.ini
-setenv DYLD_LIBRARY_PATH /usr/local/iODBC/lib:/opt/mapr/drillodbc/lib/universal
</code></pre></div>
<p>Restart the Mac OS X or run <code>launchctl load /etc/launchd.conf</code>.</p>
<hr>
-<h2 id="step-2:-define-the-odbc-data-sources-in-.odbc.ini">Step 2: Define the ODBC
Data Sources in .odbc.ini</h2>
+<h2 id="step-3:-define-the-odbc-data-sources-in-.odbc.ini">Step 3: Define the ODBC
Data Sources in .odbc.ini</h2>
<p>Define the ODBC data sources in the <code>~/.odbc.ini</code> configuration
file for your environment. </p>
@@ -1180,19 +1181,53 @@ PORT=
ZKQuorum=<host name>:<port>,<host name>:<port>
. . . <host name>:<port>
ZKClusterID=<cluster name in `drill-override.conf`>
</code></pre></div>
+<h3 id="authentication-properties">Authentication Properties</h3>
+
+<p>If the Drillbit requires a username and password for authentication, uncomment the
AuthenticationType, select Basic Authentication for the AuthenticationType, and configure
UID and PWD properties.</p>
+
+<h3 id="direct-and-zookeeper-quorum-properties">Direct and ZooKeeper Quorum Properties</h3>
+
+<p>To use Drill in distributed mode, set ConnectionType to Zookeeper, get the ZKQuorum
and ZKClusterID values from the <code>drill-override.conf</code> file, and define
the ZKQuorum and ZKClusterID properties. Format ZKQuorum as a comma separated list of ZooKeeper
nodes in the following format:<br>
+<code><host name/ip address> : <port number>, <host
name/ip address> : <port number>, . . .</code> </p>
+
+<p>For example:</p>
+
+<ul>
+<li><code>ZKQuorum=centos23:5181,centos28:5181,centos29:5181</code><br></li>
+<li><code>ZKClusterID=docs41cluster-drillbits</code></li>
+</ul>
+
+<p>To use Drill in local mode, do not define the ZKQuorum and ZKClusterID properties.
Start Drill using the drill-localhost command, set ConnectionType to Direct, and define HOST
and PORT properties. For example:</p>
+
+<ul>
+<li><code>HOST=centos32.lab:5181</code><br></li>
+<li><code>PORT=31010</code></li>
+</ul>
+
+<p><a href="/docs/odbc-configuration-reference/#configuration-options">Driver
Configuration Options</a> describes configuration options available for controlling
the
+behavior of DSNs using the MapR Drill ODBC Driver.</p>
+
+<h3 id="sample-configuration-file">Sample Configuration File</h3>
+
<p>The following sample shows a possible configuration for using Drill in embedded
mode. </p>
+
+<div class="admonition note">
+ <p class="first admonition-title">Note</p>
+ <p class="last">The password should be provided in the connection string or ODBC
application at connection time, not in the INI file. </p>
+</div>
+
<div class="highlight"><pre><code class="language-text" data-lang="text">[ODBC]
# Specify any global ODBC configuration here such as ODBC tracing.
[ODBC Data Sources]
-Sample MapR Drill DSN=MapR Drill ODBC Driver
+Sample MapR Drill=MapR Drill ODBC Driver
-[Sample MapR Drill DSN]
+[Sample MapR Drill]
# Description: DSN Description.
# This key is not necessary and only describes the data source.
Description=Sample MapR Drill ODBC Driver DSN
# Driver: The location where the ODBC driver is installed.
-Driver=/opt/mapr/drillodbc/lib/universal/libmaprdrillodbc.dylib
+Driver=/Library/mapr/drill/lib/libdrillodbc_sbu.dylib
# The DriverUnicodeEncoding setting is only used for SimbaDM
# When set to 1, SimbaDM runs in UTF-16 mode.
@@ -1211,40 +1246,14 @@ ZKQuorum=[Zookeeper Quorum]
ZKClusterID=[Cluster ID]
AuthenticationType=No Authentication
UID=[USERNAME]
-PWD=[PASSWORD]
+PWD=[PASSWORD]
AdvancedProperties=CastAnyToVarchar=true;HandshakeTimeout=5;QueryTimeout=180;TimestampTZDisplayTimezone=utc;ExcludedSchemas=sys,INFORMATION_SCHEMA;NumberOfPrefetchBuffers=5;
Catalog=DRILL
-Schema=
+Schema=
</code></pre></div>
-<h3 id="authentication-properties">Authentication Properties</h3>
-
-<p>To password protect the DSN, uncomment the AuthenticationType, select Basic Authentication
for the AuthenticationType, and configure UID and PWD properties.</p>
-
-<h3 id="direct-and-zookeeper-quorum-properties">Direct and ZooKeeper Quorum Properties</h3>
-
-<p>To use Drill in distributed mode, set ConnectionType to Zookeeper, get the ZKQuorum
and ZKClusterID values from the <code>drill-override.conf</code> file, and define
the ZKQuorum and ZKClusterID properties. Format ZKQuorum as a comma separated list of ZooKeeper
nodes in the following format:<br>
-<code><host name/ip address> : <port number>, <host
name/ip address> : <port number>, . . .</code> </p>
-
-<p>For example:</p>
-
-<ul>
-<li><code>ZKQuorum=centos23:5181,centos28:5181,centos29:5181</code><br></li>
-<li><code>ZKClusterID=docs41cluster-drillbits</code></li>
-</ul>
-
-<p>To use Drill in local mode, do not define the ZKQuorum and ZKClusterID properties.
Start Drill using the drill-localhost command, set ConnectionType to Direct, and define HOST
and PORT properties. For example:</p>
-
-<ul>
-<li><code>HOST=centos32.lab:5181</code><br></li>
-<li><code>PORT=31010</code></li>
-</ul>
-
-<p><a href="/docs/odbc-configuration-reference/#configuration-options">Driver
Configuration Options</a> describes configuration options available for controlling
the
-behavior of DSNs using the MapR Drill ODBC Driver.</p>
-
<hr>
-<h2 id="step-3:-configure-the-mapr-drill-odbc-driver">Step 3: Configure the MapR Drill
ODBC Driver</h2>
+<h2 id="step-4:-configure-the-mapr-drill-odbc-driver">Step 4: Configure the MapR Drill
ODBC Driver</h2>
<p>Configure the MapR Drill ODBC Driver for your environment by modifying the <code>.mapr.drillodbc.ini</code>
configuration
file. This configures the driver to work with your ODBC driver manager. The following sample
shows a possible configuration, which you can use as is if you installed the default iODBC
driver manager.</p>
@@ -1252,16 +1261,12 @@ 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
+DisableAsync=0
+ErrorMessagesPath=/Library/mapr/drill/ErrorMessages
LogLevel=0
LogPath=
SwapFilePath=/tmp
-
-# iODBC
-ODBCInstLib=libiodbcinst.dylib
</code></pre></div>
<h3 id="configuring-.mapr.drillodbc.ini">Configuring .mapr.drillodbc.ini</h3>
@@ -1271,14 +1276,8 @@ ODBCInstLib=libiodbcinst.dylib
<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>
-<li><p>Save the <code>mapr.drillodbc.ini</code> configuration file.</p></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>Save the <code>mapr.drillodbc.ini</code> configuration file.</li>
</ol>
<h3 id="next-step">Next Step</h3>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/50300feb/docs/img/odbc_data_source_names.png
----------------------------------------------------------------------
diff --git a/docs/img/odbc_data_source_names.png b/docs/img/odbc_data_source_names.png
new file mode 100644
index 0000000..a63eed7
Binary files /dev/null and b/docs/img/odbc_data_source_names.png differ
http://git-wip-us.apache.org/repos/asf/drill-site/blob/50300feb/docs/img/odbc_login.png
----------------------------------------------------------------------
diff --git a/docs/img/odbc_login.png b/docs/img/odbc_login.png
new file mode 100644
index 0000000..1a4be04
Binary files /dev/null and b/docs/img/odbc_login.png differ
http://git-wip-us.apache.org/repos/asf/drill-site/blob/50300feb/docs/img/success.png
----------------------------------------------------------------------
diff --git a/docs/img/success.png b/docs/img/success.png
new file mode 100644
index 0000000..e18fb00
Binary files /dev/null and b/docs/img/success.png differ
http://git-wip-us.apache.org/repos/asf/drill-site/blob/50300feb/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 3fdd754..16ee601 100644
--- a/docs/installing-the-driver-on-mac-os-x/index.html
+++ b/docs/installing-the-driver-on-mac-os-x/index.html
@@ -1099,7 +1099,7 @@
</div>
- Dec 24, 2016
+ Jan 24, 2017
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1118,11 +1118,13 @@ the Drill service.</p>
<h2 id="system-requirements">System Requirements</h2>
+<p>To install the driver, you need Administrator privileges on the computer.</p>
+
<ul>
-<li>Mac OS X version 10.6.8 or later<br></li>
+<li>Mac OS X version 10.8.0 or later<br></li>
<li>100 MB of available disk space<br></li>
<li>iODBC 3.52.7 or later<br>
-The iodbc-config file in the <code>/usr/local/iODBC/bin</code> includes the version.<br></li>
+The iodbc-config file in the <code>/usr/local/iODBC/bin</code> includes the version
of the driver.<br></li>
<li><p>The client must be able to resolve the actual host name of the Drill node
or nodes from the IP address. Verify that a DNS entry was created on the client machine for
the Drill node or nodes.<br>
If not, create an entry in <code>/etc/hosts</code> for each node in the following
format: </p>
@@ -1130,8 +1132,6 @@ If not, create an entry in <code>/etc/hosts</code> for each
node in the followin
Example: <code>127.0.0.1 localhost</code></p></li>
</ul>
-<p>To install the driver, you need Administrator privileges on the computer.</p>
-
<hr>
<h2 id="step-1:-download-the-mapr-drill-odbc-driver">Step 1: Download the MapR Drill
ODBC Driver</h2>
@@ -1147,7 +1147,7 @@ Example: <code>127.0.0.1 localhost</code></p></li>
<p>To install the driver, complete the following steps:</p>
<ol>
-<li>Double-click <code>MapRDrill1.3.dmg</code> to mount the disk image.</li>
+<li>Double-click <code>MapR_Drill_1.3.dmg</code> to mount the disk image.</li>
<li>Double-click <code>MapRDrillODBC.pkg</code> to run the Installer.</li>
<li>Follow the instructions in the Installer to complete the installation process.</li>
<li>When the installation completes, click <strong>Close.</strong></li>
@@ -1159,20 +1159,24 @@ Example: <code>127.0.0.1 localhost</code></p></li>
</div>
<ul>
-<li><code>/opt/mapr/drillodbc/ErrorMessages</code> – Error messages files
directory</li>
-<li><code>/opt/mapr/drillodbc/Setup</code> – Sample configuration files
directory</li>
-<li><code>/opt/mapr/drillodbc/lib/universal</code> – Binaries directory</li>
+<li><code>/Library/mapr/drill/ErrorMessages</code> – Error messages files
directory</li>
+<li><code>/Library/mapr/drill/Setup</code> – Sample configuration files
directory</li>
+<li><code>/Library/mapr/drill/lib</code> – Binaries directory</li>
</ul>
-<h2 id="step-3:-check-the-mapr-drill-odbc-driver-version">Step 3: Check the MapR Drill
ODBC Driver version</h2>
+<h2 id="step-3:-check-the-mapr-drill-odbc-driver-version">Step 3: Check the MapR Drill
ODBC Driver Version</h2>
<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
+<div class="highlight"><pre><code class="language-text" data-lang="text">$
pkgutil -pkg-info mapr.drillodbc
+
package-id: mapr.drillodbc
-version: 1.3.0 (may also display as 3.52.12)
+version: 1.3.0 (You may see 3.52.12.)
volume: /
location:
-install-time: 1433465518
+install-time: 1433465518
+</code></pre></div>
+<p>To display information about the iODBC driver manager installed on the machine,
issue the following command: </p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">/usr/local/iODBC/bin/iodbc-config
</code></pre></div>
<h3 id="next-step">Next Step</h3>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/50300feb/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 91822d3..76fd243 100644
--- a/docs/testing-the-odbc-connection/index.html
+++ b/docs/testing-the-odbc-connection/index.html
@@ -1099,7 +1099,7 @@
</div>
-
+ Jan 24, 2017
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1179,15 +1179,15 @@ Enter ODBC connect string (? shows list):
<ol>
<li><a href="/docs/starting-drill-on-linux-and-mac-os-x/">Start Drill</a>.<br></li>
<li>Start the iODBC Administrator.app in <code>/Applications</code>.<br>
-The iODBC Data Source Administrator dialog appears.<br></li>
-<li>On the User DSN tab, select the MapR Drill DSN.<br>
-<img src="/docs/img/odbc-mac1.png" alt=""><br></li>
+The iODBC Data Source Administrator dialog appears. </li>
+<li>On the User DSN tab, select the MapR Drill.<br>
+<img src="/docs/img/odbc_data_source_names.png" alt=""><br></li>
<li>Click <strong>Test</strong>.<br>
-The Login for Sample MapR Drill DSN dialog appears.<br>
-<img src="/docs/img/odbc-mac2.png" alt=""><br></li>
+The Login for Sample MapR Drill dialog appears.<br>
+<img src="/docs/img/odbc_login.png" alt=""><br></li>
<li>If you configured Basic Authentication in the <code>.odbc.ini</code>,
enter the user name and password you also configured; otherwise, click <strong>OK</strong>.<br>
The success message appears.<br>
-<img src="/docs/img/odbc-mac3.png" alt=""><br></li>
+<img src="/docs/img/success.png" alt=""><br></li>
</ol>
<h2 id="testing-the-odbc-connection-on-windows">Testing the ODBC Connection on Windows</h2>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/50300feb/feed.xml
----------------------------------------------------------------------
diff --git a/feed.xml b/feed.xml
index 57764b9..a30c9e1 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>Fri, 23 Dec 2016 16:36:27 -0800</pubDate>
- <lastBuildDate>Fri, 23 Dec 2016 16:36:27 -0800</lastBuildDate>
+ <pubDate>Tue, 24 Jan 2017 14:28:38 -0800</pubDate>
+ <lastBuildDate>Tue, 24 Jan 2017 14:28:38 -0800</lastBuildDate>
<generator>Jekyll v2.5.2</generator>
<item>
|