drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bridg...@apache.org
Subject drill git commit: mac odbc driver doc edits
Date Tue, 24 Jan 2017 22:27:01 GMT
Repository: drill
Updated Branches:
  refs/heads/gh-pages ef850846a -> a111852bd


mac odbc driver doc edits


Project: http://git-wip-us.apache.org/repos/asf/drill/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/a111852b
Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/a111852b
Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/a111852b

Branch: refs/heads/gh-pages
Commit: a111852bd569e82aa6cd2b994b09640aed5c42d5
Parents: ef85084
Author: Bridget Bevens <bbevens@maprtech.com>
Authored: Tue Jan 24 14:24:24 2017 -0800
Committer: Bridget Bevens <bbevens@maprtech.com>
Committed: Tue Jan 24 14:24:24 2017 -0800

----------------------------------------------------------------------
 _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
 .../025-configuring-odbc-on-mac-os-x.md         | 103 +++++++++----------
 .../040-testing-the-odbc-connection.md          |  18 ++--
 .../020-installing-the-driver-on-mac-os-x.md    |  31 +++---
 6 files changed, 76 insertions(+), 76 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/drill/blob/a111852b/_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/blob/a111852b/_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/blob/a111852b/_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/blob/a111852b/_docs/odbc-jdbc-interfaces/configuring-odbc/025-configuring-odbc-on-mac-os-x.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/configuring-odbc/025-configuring-odbc-on-mac-os-x.md
b/_docs/odbc-jdbc-interfaces/configuring-odbc/025-configuring-odbc-on-mac-os-x.md
index bab70ff..da36b28 100644
--- a/_docs/odbc-jdbc-interfaces/configuring-odbc/025-configuring-odbc-on-mac-os-x.md
+++ b/_docs/odbc-jdbc-interfaces/configuring-odbc/025-configuring-odbc-on-mac-os-x.md
@@ -1,29 +1,31 @@
 ---
 title: "Configuring ODBC on Mac OS X"
-date: 2016-12-24 00:01:39 UTC
+date: 2017-01-24 22:24:25 UTC
 parent: "Configuring ODBC"
 ---
 ODBC driver managers use configuration files to define and configure ODBC data
 sources and drivers. To configure an ODBC connection for Linux or Mac OS X, complete the
following
 steps:
 
-* [Step 1: Set Environment Variables]({{site.baseurl}}/docs/configuring-odbc-on-mac-os-x/#step-1:-set-environment-variables)
-* [Step 2: Define the ODBC Data Sources in odbc.ini]({{site.baseurl}}/docs/configuring-odbc-on-mac-os-x/#step-2:-define-the-odbc-data-sources-in-.odbc.ini)
-* [Step 3: Configure the MapR Drill ODBC Driver]({{site.baseurl}}/docs/configuring-odbc-on-mac-os-x/#step-4:-configure-the-mapr-drill-odbc-driver)
+* [Step 1: Copy Sample Configuration Files]({{site.baseurl}}/docs/configuring-odbc-on-mac-os-x/#step-1:-copy-sample-configuration-files)
+* [Step 2: Set Environment Variables]({{site.baseurl}}/docs/configuring-odbc-on-mac-os-x/#step-2:-set-environment-variables)
+* [Step 3: Define the ODBC Data Sources in odbc.ini]({{site.baseurl}}/docs/configuring-odbc-on-mac-os-x/#step-3:-define-the-odbc-data-sources-in-.odbc.ini)
+* [Step 4: Configure the MapR Drill ODBC Driver]({{site.baseurl}}/docs/configuring-odbc-on-mac-os-x/#step-4:-configure-the-mapr-drill-odbc-driver)
 
-## Sample Configuration Files
+## Step 1: Copy Sample Configuration Files
 
 Before you connect to Drill through an ODBC client tool
-on Mac OS X, copy the following configuration files in `/opt/mapr/drillodbc/Setup` to your
home directory unless the files already exist in your home directory:
+on Mac OS X, copy the following configuration files in `/opt/mapr/drill/Setup` to your home
directory unless the files already exist in your home directory:
 
 * `mapr.drillodbc.ini`
-* `odbc.ini`
-* `odbcinst.ini`
+* `.odbc.ini`
+* `.odbcinst.ini`
 
 In your home directory, rename the files as hidden files. Use sudo if necessary:
 
 * .mapr.drillodbc.ini
 * .odbc.ini
+* .odbcinst.ini
 
 The installer for Mac OS X creates a sample user DSN in odbc.ini in either of the following
locations:
 
@@ -36,21 +38,20 @@ Depending on the driver manager you use, the user DSN in one of these
files will
 
 ----------
 
-## Step 1: Set Environment Variables 
+## Step 2: Set Environment Variables 
 
-Create or modify the `/etc/launchd.conf` file to set environment variables. Set the SIMBAINI
variable to point to the `.mapr.drillodbc.ini` file, the ODBCINI variable to the `.odbc.ini`
file, and the DYLD_LIBRARY_PATH to the location of the dynamic linker (DYLD) libraries and
to the MapR Drill ODBC Driver. 
+Create or modify the `/etc/launchd.conf` file to set environment variables. Set the MAPRDRILLINI
variable to point to the `.mapr.drillodbc.ini` file. 
 
-If you installed the iODBC driver manager using the DMG, the DYLD libraries are installed
in `/usr/local/iODBC/lib`. The launchd.conf file should look something like this:
+If you installed the iODBC driver manager using the DMG, the dynamic linker (DYLD) libraries
are installed in `/usr/local/iODBC/lib`. The launchd.conf file should look something like
this:
 
-    setenv SIMBAINI /Users/joeuser/.mapr.drillodbc.ini
+    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
 
 Restart the Mac OS X or run `launchctl load /etc/launchd.conf`.
 
 ----------
 
-## Step 2: Define the ODBC Data Sources in .odbc.ini
+## Step 3: Define the ODBC Data Sources in .odbc.ini
 
 Define the ODBC data sources in the `~/.odbc.ini` configuration file for your environment.

 
@@ -70,20 +71,44 @@ You set the following properties for using Drill in distributed mode:
     ZKQuorum=<host name>:<port>,<host name>:<port> . . . <host
name>:<port>
     ZKClusterID=<cluster name in `drill-override.conf`>
 
+### Authentication Properties
+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.
+
+### Direct and ZooKeeper Quorum Properties
+To use Drill in distributed mode, set ConnectionType to Zookeeper, get the ZKQuorum and ZKClusterID
values from the `drill-override.conf` file, and define the ZKQuorum and ZKClusterID properties.
Format ZKQuorum as a comma separated list of ZooKeeper nodes in the following format:  
+`<host name/ip address> : <port number>, <host name/ip address> : <port
number>, . . .` 
+
+For example:
+
+* `ZKQuorum=centos23:5181,centos28:5181,centos29:5181`  
+* `ZKClusterID=docs41cluster-drillbits`
+
+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:
+
+* `HOST=centos32.lab:5181`  
+* `PORT=31010`
+
+[Driver Configuration Options]({{ site.baseurl }}/docs/odbc-configuration-reference/#configuration-options)
describes configuration options available for controlling the
+behavior of DSNs using the MapR Drill ODBC Driver.
+
+###Sample Configuration File
 The following sample shows a possible configuration for using Drill in embedded mode. 
+
+{% include startnote.html %}The password should be provided in the connection string or ODBC
application at connection time, not in the INI file.{% include endnote.html %}
+ 
           
     [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.
@@ -102,35 +127,15 @@ The following sample shows a possible configuration for using Drill
in embedded
     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=  
 
 
-### Authentication Properties
-To password protect the DSN, uncomment the AuthenticationType, select Basic Authentication
for the AuthenticationType, and configure UID and PWD properties.
-
-### Direct and ZooKeeper Quorum Properties
-To use Drill in distributed mode, set ConnectionType to Zookeeper, get the ZKQuorum and ZKClusterID
values from the `drill-override.conf` file, and define the ZKQuorum and ZKClusterID properties.
Format ZKQuorum as a comma separated list of ZooKeeper nodes in the following format:  
-`<host name/ip address> : <port number>, <host name/ip address> : <port
number>, . . .` 
-
-For example:
-
-* `ZKQuorum=centos23:5181,centos28:5181,centos29:5181`  
-* `ZKClusterID=docs41cluster-drillbits`
-
-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:
-
-* `HOST=centos32.lab:5181`  
-* `PORT=31010`
-
-[Driver Configuration Options]({{ site.baseurl }}/docs/odbc-configuration-reference/#configuration-options)
describes configuration options available for controlling the
-behavior of DSNs using the MapR Drill ODBC Driver.
-
 ----------
 
-## Step 3: Configure the MapR Drill ODBC Driver
+## Step 4: Configure the MapR Drill ODBC Driver
 
 Configure the MapR Drill ODBC Driver for your environment by modifying the `.mapr.drillodbc.ini`
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.
@@ -139,17 +144,13 @@ file. This configures the driver to work with your ODBC driver manager.
The foll
 
     [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
-
 ### Configuring .mapr.drillodbc.ini
 
 To configure the MapR Drill ODBC Driver in the `mapr.drillodbc.ini` configuration file, complete
the following steps:
@@ -157,14 +158,8 @@ To configure the MapR Drill ODBC Driver in the `mapr.drillodbc.ini` configuratio
   1. Open the `mapr.drillodbc.ini` configuration file in a text editor.  
   2. 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.  
      A change in state occurs during driver initialization and is propagated to all driver
DSNs.  
-  3. 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.  
-  4. Edit the `ODBCInstLib` setting. The value is the name of the `ODBCInst` shared library
for the ODBC driver manager that you use. The configuration file defaults to the shared library
for `iODBC`. The shared library name for `iODBC` is `libiodbcinst.dylib`.  
-      
-     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 `DYLD_LIBRARY_PATH`.  
-  5. Save the `mapr.drillodbc.ini` configuration file.
+  3. 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.
+  4. Save the `mapr.drillodbc.ini` configuration file.
 
 ### Next Step
 

http://git-wip-us.apache.org/repos/asf/drill/blob/a111852b/_docs/odbc-jdbc-interfaces/configuring-odbc/040-testing-the-odbc-connection.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/configuring-odbc/040-testing-the-odbc-connection.md
b/_docs/odbc-jdbc-interfaces/configuring-odbc/040-testing-the-odbc-connection.md
index f5b9f7c..d55a49c 100644
--- a/_docs/odbc-jdbc-interfaces/configuring-odbc/040-testing-the-odbc-connection.md
+++ b/_docs/odbc-jdbc-interfaces/configuring-odbc/040-testing-the-odbc-connection.md
@@ -1,6 +1,6 @@
 ---
 title: "Testing the ODBC Connection"
-date:  
+date: 2017-01-24 22:24:25 UTC
 parent: "Configuring ODBC"
 ---
 The procedure for testing the ODBC connection differs depending on your platform, as described
in the following sections:
@@ -79,15 +79,15 @@ To test the ODBC connection on Mac OS X, follow these steps.
 
 1. [Start Drill]({{site.baseurl}}/docs/starting-drill-on-linux-and-mac-os-x/).  
 2. Start the iODBC Administrator.app in `/Applications`.  
-   The iODBC Data Source Administrator dialog appears.  
-2. On the User DSN tab, select the MapR Drill DSN.  
-   ![]({{ site.baseurl }}/docs/img/odbc-mac1.png)  
-3. Click **Test**.  
-   The Login for Sample MapR Drill DSN dialog appears.  
-   ![]({{ site.baseurl }}/docs/img/odbc-mac2.png)  
-4. If you configured Basic Authentication in the `.odbc.ini`, enter the user name and password
you also configured; otherwise, click **OK**.  
+   The iODBC Data Source Administrator dialog appears. 
+3. On the User DSN tab, select the MapR Drill.  
+   ![]({{ site.baseurl }}/docs/img/odbc_data_source_names.png)  
+4. Click **Test**.  
+   The Login for Sample MapR Drill dialog appears.  
+   ![]({{ site.baseurl }}/docs/img/odbc_login.png)  
+5. If you configured Basic Authentication in the `.odbc.ini`, enter the user name and password
you also configured; otherwise, click **OK**.  
    The success message appears.  
-   ![]({{ site.baseurl }}/docs/img/odbc-mac3.png)  
+   ![]({{ site.baseurl }}/docs/img/success.png)  
    
 ## Testing the ODBC Connection on Windows
 

http://git-wip-us.apache.org/repos/asf/drill/blob/a111852b/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/020-installing-the-driver-on-mac-os-x.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/020-installing-the-driver-on-mac-os-x.md
b/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/020-installing-the-driver-on-mac-os-x.md
index 150262c..b6577e2 100644
--- a/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/020-installing-the-driver-on-mac-os-x.md
+++ b/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/020-installing-the-driver-on-mac-os-x.md
@@ -1,6 +1,6 @@
 ---
 title: "Installing the Driver on Mac OS X"
-date: 2016-12-24 00:01:40 UTC
+date: 2017-01-24 22:24:26 UTC
 parent: "Installing the ODBC Driver"
 ---
 Install the MapR Drill ODBC Driver on the machine from which you connect to
@@ -12,19 +12,20 @@ Install the MapR Drill ODBC Driver on a system that meets the [system
requiremen
   * [Step 2: Install the MapR Drill ODBC Driver]({{site.baseurl}}/docs/installing-the-driver-on-mac-os-x/#step-2-install-the-mapr-drill-odbc-driver)

   * [Step 3: Check the MapR Drill ODBC Driver Version]({{site.baseurl}}/docs/installing-the-driver-on-mac-os-x/#step-3-check-the-mapr-drill-odbc-driver-version)
 
-## System Requirements
+## System Requirements  
+To install the driver, you need Administrator privileges on the computer.
 
-  * Mac OS X version 10.6.8 or later  
+  * Mac OS X version 10.8.0 or later  
   * 100 MB of available disk space  
   * iODBC 3.52.7 or later  
-    The iodbc-config file in the `/usr/local/iODBC/bin` includes the version.  
+    The iodbc-config file in the `/usr/local/iODBC/bin` includes the version of the driver.
 
   * 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.   
 If not, create an entry in `/etc/hosts` for each node in the following format:  
 
     `<drill-machine-IP> <drill-machine-hostname>`  
     Example: `127.0.0.1 localhost`
 
-To install the driver, you need Administrator privileges on the computer.
+
 
 ----------
 
@@ -40,27 +41,31 @@ Click the following link to download the driver:
 
 To install the driver, complete the following steps:
 
-  1. Double-click `MapRDrill1.3.dmg` to mount the disk image.
+  1. Double-click `MapR_Drill_1.3.dmg` to mount the disk image.
   2. Double-click `MapRDrillODBC.pkg` to run the Installer.
   3. Follow the instructions in the Installer to complete the installation process.
   4. When the installation completes, click **Close.**
 
 {% include startnote.html %}MapR Drill ODBC Driver files install in the following locations:{%
include endnote.html %}
 
-  * `/opt/mapr/drillodbc/ErrorMessages` – Error messages files directory
-  * `/opt/mapr/drillodbc/Setup` – Sample configuration files directory
-  * `/opt/mapr/drillodbc/lib/universal` – Binaries directory
+  * `/Library/mapr/drill/ErrorMessages` – Error messages files directory
+  * `/Library/mapr/drill/Setup` – Sample configuration files directory
+  * `/Library/mapr/drill/lib` – Binaries directory
 
-## Step 3: Check the MapR Drill ODBC Driver version
+## Step 3: Check the MapR Drill ODBC Driver Version
 
 To check the version of the driver you installed, use the following command on the terminal
command line:
 
-    $ pkgutil --info mapr.drillodbc
+    $ 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  
+To display information about the iODBC driver manager installed on the machine, issue the
following command:  
+
+    /usr/local/iODBC/bin/iodbc-config
 
 ### Next Step
 


Mime
View raw message