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 2017/01/24 22:27:01 UTC
drill git commit: mac odbc driver doc edits
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 <bb...@maprtech.com>
Authored: Tue Jan 24 14:24:24 2017 -0800
Committer: Bridget Bevens <bb...@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` \u2013 Error messages files directory
- * `/opt/mapr/drillodbc/Setup` \u2013 Sample configuration files directory
- * `/opt/mapr/drillodbc/lib/universal` \u2013 Binaries directory
+ * `/Library/mapr/drill/ErrorMessages` \u2013 Error messages files directory
+ * `/Library/mapr/drill/Setup` \u2013 Sample configuration files directory
+ * `/Library/mapr/drill/lib` \u2013 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