Repository: drill Updated Branches: refs/heads/gh-pages 824e44d85 -> 3a23e931e odbc driver edits from c.Skrbina Project: http://git-wip-us.apache.org/repos/asf/drill/repo Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/3a23e931 Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/3a23e931 Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/3a23e931 Branch: refs/heads/gh-pages Commit: 3a23e931e901bd40d66e2828e14f0e7cbb2ea133 Parents: 824e44d Author: Bridget Bevens Authored: Fri Jun 2 18:09:23 2017 -0700 Committer: Bridget Bevens Committed: Fri Jun 2 18:09:23 2017 -0700 ---------------------------------------------------------------------- _docs/img/explorer-connect.png | Bin 29945 -> 37761 bytes _docs/img/explorer-schemas.png | Bin 14332 -> 229615 bytes _docs/img/odbc-explorer-win-connect.png | Bin 0 -> 34764 bytes _docs/img/winstart.png | Bin 84587 -> 37279 bytes .../025-configuring-odbc-on-mac-os-x.md | 2 +- .../030-configuring-odbc-on-windows.md | 4 +- .../040-testing-the-odbc-connection.md | 72 ++++++++++--------- .../010-installing-the-driver-on-linux.md | 6 +- .../020-installing-the-driver-on-mac-os-x.md | 20 ++++-- .../030-installing-the-driver-on-windows.md | 6 +- 10 files changed, 63 insertions(+), 47 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/drill/blob/3a23e931/_docs/img/explorer-connect.png ---------------------------------------------------------------------- diff --git a/_docs/img/explorer-connect.png b/_docs/img/explorer-connect.png index 752bce9..12521c3 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/blob/3a23e931/_docs/img/explorer-schemas.png ---------------------------------------------------------------------- diff --git a/_docs/img/explorer-schemas.png b/_docs/img/explorer-schemas.png index 3a9a53a..40830ce 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/blob/3a23e931/_docs/img/odbc-explorer-win-connect.png ---------------------------------------------------------------------- diff --git a/_docs/img/odbc-explorer-win-connect.png b/_docs/img/odbc-explorer-win-connect.png new file mode 100644 index 0000000..c4f7a64 Binary files /dev/null and b/_docs/img/odbc-explorer-win-connect.png differ http://git-wip-us.apache.org/repos/asf/drill/blob/3a23e931/_docs/img/winstart.png ---------------------------------------------------------------------- diff --git a/_docs/img/winstart.png b/_docs/img/winstart.png index cca1a31..9a327a6 100644 Binary files a/_docs/img/winstart.png and b/_docs/img/winstart.png differ http://git-wip-us.apache.org/repos/asf/drill/blob/3a23e931/_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 530a2a8..455d1a2 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,6 +1,6 @@ --- title: "Configuring ODBC on Mac OS X" -date: 2017-05-31 23:17:32 UTC +date: 2017-06-03 01:09:30 UTC parent: "Configuring ODBC" --- ODBC driver managers use configuration files to define and configure ODBC data http://git-wip-us.apache.org/repos/asf/drill/blob/3a23e931/_docs/odbc-jdbc-interfaces/configuring-odbc/030-configuring-odbc-on-windows.md ---------------------------------------------------------------------- diff --git a/_docs/odbc-jdbc-interfaces/configuring-odbc/030-configuring-odbc-on-windows.md b/_docs/odbc-jdbc-interfaces/configuring-odbc/030-configuring-odbc-on-windows.md index be91ec7..5025170 100644 --- a/_docs/odbc-jdbc-interfaces/configuring-odbc/030-configuring-odbc-on-windows.md +++ b/_docs/odbc-jdbc-interfaces/configuring-odbc/030-configuring-odbc-on-windows.md @@ -1,6 +1,6 @@ --- title: "Configuring ODBC on Windows" -date: 2017-05-31 23:17:33 UTC +date: 2017-06-03 01:09:31 UTC parent: "Configuring ODBC" --- Complete one of the following steps to create an ODBC connection on Windows to Drill data @@ -31,7 +31,7 @@ version of the ODBC Data Source Administrator to create the DSN. ![](http://i.imgur.com/f9Avhcz.png) - To access **Drill Explorer**, click **Drill Explorer...**. + To access Drill Explorer, click **Drill Explorer...**. ### Authentication Options To password protect the DSN, select the appropriate authentication type in the **Authentication Type** dropdown. If the Drillbit does not require authentication (or to configure no password protection), you can use the No Authentication option. You do not need to configure additional settings. http://git-wip-us.apache.org/repos/asf/drill/blob/3a23e931/_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 31dc3f2..2a7046c 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,14 +1,15 @@ --- title: "Testing the ODBC Connection" -date: 2017-05-31 23:17:33 UTC +date: 2017-06-03 01:09:33 UTC parent: "Configuring ODBC" --- You can use DSN connection strings and DSN-less connection strings for your connections. -* [Example Connection String with DSN]({{site.baseurl}}/docs/testing-the-odbc-connection/#example-connection-string-with-DSN) -* [Example Connection Strings without DSN]({{site.baseurl}}/docs/testing-the-odbc-connection/#example-connection-strings-without-DSN) +* [Example Connection String with DSN]({{site.baseurl}}/docs/testing-the-odbc-connection/#example-connection-string-with-dsn) +* [Example Connection Strings without DSN]({{site.baseurl}}/docs/testing-the-odbc-connection/#example-connection-strings-without-dsn) + +## Example Connection String with DSN -## Example Connection String with DSN The following is an example of a connection string for a connection that uses a DSN: DSN=[DataSourceName] @@ -17,8 +18,7 @@ The following is an example of a connection string for a connection that uses a You can set additional configuration options by appending key-value pairs to the connection string. Configuration options that are passed in using a connection string take precedence over configuration options that are set in the DSN. - -## Example Connection Strings without DSN +## Example Connection Strings without DSN Some applications provide support for connecting to a data source using a driver without a DSN. To connect to a data source without using a DSN, use a connection string instead. The placeholders in the examples are defined as follows, in alphabetical order: @@ -37,19 +37,19 @@ The following is the format of a DSN-less connection string for a Drillbit that Driver=MapR Drill ODBC Driver;ConnectionType=Direct; Host=[*Server*];Port=[*PortNumber*] -For example: +Example: Driver=MapR Drill ODBC Driver;ConnectionType=Direct; Host=192.168.222.160;Port=31010 ###ZooKeeper Connections The following is the format of a DSN-less connection string for a ZooKeeper cluster that does not require authentication: -Driver=MapR Drill ODBC Driver; -ConnectionType=ZooKeeper; -ZKQuorum=[*Server1*]:[*PortNumber*1], [*Server2*]:[*PortNumber2*], [*Server3*]:[*PortNumber3*]; -ZKClusterID=[*ClusterName*] + Driver=MapR Drill ODBC Driver; + ConnectionType=ZooKeeper; + ZKQuorum=[*Server1*]:[*PortNumber*1], [*Server2*]:[*PortNumber2*], [*Server3*]:[*PortNumber3*]; + ZKClusterID=[*ClusterName*] -For example: +Example: Driver=MapR Drill ODBC Driver; ConnectionType=ZooKeeper; @@ -60,13 +60,13 @@ For example: ###Kerberos Authentication Connections The following is the format of a DSN-less connection string for a Drillbit that requires Kerberos authentication: -Driver=MapR Drill ODBC Driver; -ConnectionType=Direct; -Host=[*Server*];Port=[*PortNumber*]; -AuthenticationType=Kerberos; -KrbServiceHost=[*DomainName*];KrbServiceName=[*ServiceName*] + Driver=MapR Drill ODBC Driver; + ConnectionType=Direct; + Host=[*Server*];Port=[*PortNumber*]; + AuthenticationType=Kerberos; + KrbServiceHost=[*DomainName*];KrbServiceName=[*ServiceName*] -For example: +Example: Driver=MapR Drill ODBC Driver; ConnectionType=Direct; @@ -80,7 +80,7 @@ The following is the format of a DSN-less connection string for a Drillbit that Driver=MapR Drill ODBC Driver;ConnectionType=Direct; Host=[*Server*];Port=[*PortNumber*];AuthenticationType=MapRSASL -For example: +Example: Driver=MapR Drill ODBC Driver; ConnectionType=Direct; @@ -97,7 +97,7 @@ The following is the format of a DSN-less connection string for a Drillbit that AuthenticationType=Plain; UID=[*YourUserName*];PWD=[*YourPassword*] -For example: +Example: Driver=MapR Drill ODBC Driver;ConnectionType=Direct; Host=192.168.227.169;Port=31010; @@ -146,7 +146,7 @@ To test the ODBC connection on a Linux cluster, follow these steps: DSN | Driver ------------------------------------------------------------------------------ - Sample MapR Drill (64-bit) | MapR Drill ODBC Driver 64-bit + MapR Drill (64-bit) | MapR Drill ODBC Driver 64-bit Enter ODBC connect string (? shows list): 4. To test the connection if the DSN was previously configured in the `.odbc.ini`, type the following connection string: @@ -176,37 +176,39 @@ To test the ODBC connection on a Linux cluster, follow these steps: After the `SQL>` prompt appears, type `quit;`. Go to the Drill shell to run commands. Do not attempt to run SQL commands from this prompt. -This example shows a connection string for a direct connection: +Example: Connection String for a Direct Connection - DSN=Sample MapR Drill 64-bit; + DSN=MapR Drill 64-bit; ConnectionType=Direct; Host=localhost;Port=31010 -This example shows a connection string for a ZooKeeper cluster connection: +Example: Connection String for a ZooKeeper Cluster Connection - DSN=Sample MapR Drill 64-bit 64; + DSN=MapR Drill 64-bit 64; ConnectionType=ZooKeeper; ZKQuorum=centos23.lab:5181; ZKClusterID=docs60cluster-drillbits ## Testing the ODBC Connection on Mac OS X -To test the ODBC connection on Mac OS X, follow these steps. +To test the ODBC connection on Mac OS X: 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. Start the iODBC Data Source Administrator app in `/Applications`. The **iODBC Data Source Administrator** dialog appears. + +3. On the **ODBC DSN** tab, select **MapR Drill**. + + ![](http://i.imgur.com/Wcm99OI.png) + +4. Click **Test**. The **MapR Drill** login dialog appears. -3. On the User DSN tab, select **MapR Drill**. - ![]({{ site.baseurl }}/docs/img/odbc_data_source_names.png) + ![](http://i.imgur.com/T914QZk.png) -4. Click **Test**. - The Login for the MapR Drill dialog appears. - ![]({{ site.baseurl }}/docs/img/odbc_login.png) +5. If you configured Plain (or Basic Authentication) in the `.odbc.ini` file, enter the user name and password you also configured. +Otherwise, click **OK**. The success message displays. -5. If you configured Plain (or Basic) authentication in the `.odbc.ini`, enter the user name and password you also configured; otherwise, click **OK**. The success message displays. - ![]({{ site.baseurl }}/docs/img/success.png) + ![](http://i.imgur.com/G4YZY7n.png) ## Testing the ODBC Connection on Windows http://git-wip-us.apache.org/repos/asf/drill/blob/3a23e931/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/010-installing-the-driver-on-linux.md ---------------------------------------------------------------------- diff --git a/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/010-installing-the-driver-on-linux.md b/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/010-installing-the-driver-on-linux.md index c664400..96623d6 100644 --- a/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/010-installing-the-driver-on-linux.md +++ b/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/010-installing-the-driver-on-linux.md @@ -1,6 +1,6 @@ --- title: "Installing the Driver on Linux" -date: 2017-05-31 23:17:34 UTC +date: 2017-06-03 01:09:34 UTC parent: "Installing the ODBC Driver" --- Install the MapR Drill ODBC Driver on the machine from which you connect to @@ -17,6 +17,10 @@ Install the MapR Drill ODBC Driver on a system that meets the [system requiremen Verify that your system meets the system requirements before you start. +## Known Issue + +MapR SASL support for Kerberos and MapR tickets is only available on 64-bit machines. + ## System Requirements * One of the following distributions (32- and 64-bit editions are supported): http://git-wip-us.apache.org/repos/asf/drill/blob/3a23e931/_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 e0180fd..ae3a5ed 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: 2017-05-31 23:17:34 UTC +date: 2017-06-03 01:09:36 UTC parent: "Installing the ODBC Driver" --- Install the MapR Drill ODBC Driver on the machine from which you connect to @@ -12,6 +12,12 @@ 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) +## Known Issues + +- The 32- and 64-bit MapR Drill ODBC drivers are supported on 64-bit machines. +- MapR SASL support for Kerberos and MapR tickets is only available on 64-bit machines. + + ## System Requirements To install the driver, you need Administrator privileges on the computer. @@ -27,12 +33,10 @@ To install the driver, you need Administrator privileges on the computer. ## Step 1: Download the MapR Drill ODBC Driver +{% include startnote.html %}The most current (version 1.3.8) MapR Drill ODBC driver for Mac might not be available yet.{% include endnote.html %} -{% include startnote.html %}The most current (version 1.3.8) MapR Drill ODBC driver for Mac might not be available yet.{% include endnote.html %} - -Click the following link to download available drivers that support both 32- and 64-bit client applications: - -[MapR Drill ODBC Driver for Mac](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/) +To download available drivers that support both 32- and 64-bit client applications, click +[MapR Drill ODBC Driver for Mac](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/). ---------- @@ -45,7 +49,9 @@ To install the driver, complete the following steps: 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 %} + + +MapR Drill ODBC Driver files install in the following locations: * `/Library/mapr/drill/ErrorMessages` – Error messages files directory * `/Library/mapr/drill/Setup` – Sample configuration files directory http://git-wip-us.apache.org/repos/asf/drill/blob/3a23e931/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/030-installing-the-driver-on-windows.md ---------------------------------------------------------------------- diff --git a/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/030-installing-the-driver-on-windows.md b/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/030-installing-the-driver-on-windows.md index 792f163..25fb01d 100644 --- a/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/030-installing-the-driver-on-windows.md +++ b/_docs/odbc-jdbc-interfaces/installing-the-odbc-driver/030-installing-the-driver-on-windows.md @@ -1,6 +1,6 @@ --- title: "Installing the Driver on Windows" -date: 2017-05-31 23:17:35 UTC +date: 2017-06-03 01:09:38 UTC parent: "Installing the ODBC Driver" --- The MapR Drill ODBC Driver installer is available for 32- and 64-bit @@ -12,6 +12,10 @@ applications on Windows®. On 64-bit Windows operating systems, you can execute Install the MapR Drill ODBC Driver on a system that meets the system requirements. +## Known Issue + +Drill does not support running drillbits on 32-bit Windows machines. + ## System Requirements Each computer where you install the driver must meet the following system