Repository: drill Updated Branches: refs/heads/gh-pages 392f7d06e -> 82686d6ed
edits to odbc driver docs per rhou Project: http://git-wip-us.apache.org/repos/asf/drill/repo Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/82686d6e Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/82686d6e Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/82686d6e Branch: refs/heads/gh-pages Commit: 82686d6ed635c36c3530f1edd7bb661432da5323 Parents: 392f7d0 Author: Bridget Bevens <[email protected]> Authored: Wed Jun 21 16:58:58 2017 -0700 Committer: Bridget Bevens <[email protected]> Committed: Wed Jun 21 16:58:58 2017 -0700 ---------------------------------------------------------------------- .../030-configuring-odbc-on-windows.md | 31 ++++++++++++-------- .../010-installing-the-driver-on-linux.md | 4 +-- .../020-installing-the-driver-on-mac-os-x.md | 9 ++---- .../030-installing-the-driver-on-windows.md | 17 +++++++---- 4 files changed, 34 insertions(+), 27 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/drill/blob/82686d6e/_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 7d4985e..4d1c26e 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,15 +1,17 @@ --- title: "Configuring ODBC on Windows" -date: 2017-06-06 23:26:12 UTC +date: 2017-06-21 23:58:59 UTC parent: "Configuring ODBC" --- -Complete one of the following steps to create an ODBC connection on Windows to Drill data -sources: +To create an ODBC connection to Drill data sources on Windows, complete the following steps: - * Create a Data Source Name - * Create an ODBC Connection String + * [Step 1: Create a Data Source Name (DSN)]({{site.baseurl}}/docs/configuring-odbc-on-windows/#create-a-data-source-name-(dsn)) + * [Step 2: Select an Authentication Option]({{site.baseurl}}/docs/configuring-odbc-on-windows/#select-an-authentication-option) + * [Step 3: Configure the Connection Type]({{site.baseurl}}/docs/configuring-odbc-on-windows/#configure-the-connection-type) + * [Step 4: Configure Advanced Properties (optional)]({{site.baseurl}}/docs/configuring-odbc-on-windows/#configure-advanced-properties-(optional)) + * [Additional Configuration Options]({{site.baseurl}}/docs/configuring-odbc-on-windows/#additional-configuration-options) -## Sample ODBC Configuration +## Step 1: Create a Data Source Name (DSN) You can see how to create a DSN to connect to Drill data sources by taking a look at the preconfigured sample that the installer sets up. If you want to create a DSN for a 32- or 64-bit application, you must use the 32- or 64-bit version of the ODBC Data Source Administrator to create the DSN. @@ -22,7 +24,7 @@ version of the ODBC Data Source Administrator to create the DSN. 2\. On the **System DSN** tab in System Data Sources, select **MapR Drill**. - The system DSN is available for all users who log in to the machine. You can set up a user DSN is available only to the user who creates the DSN on the **User DSN** tab. + The system DSN is available for all users who log in to the machine. A user DSN is available only to the user who creates the DSN on the **User DSN** tab. 3\. Click **Configure**. @@ -31,9 +33,9 @@ version of the ODBC Data Source Administrator to create the DSN.  - To access Drill Explorer, click **Drill Explorer...**. + To access Drill Explorer, click **Drill Explorer...**. See [Drill Explorer]({{site.baseurl}}/docs/drill-explorer-introduction/) for more information. -### Authentication Options +### Step 2: Select an Authentication Option 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. * **MapR-SASL** @@ -44,7 +46,7 @@ To password protect the DSN, select the appropriate authentication type in the * * **Plain Authentication** - configure UID and PWD properties. -### Direct to Drillbit and ZooKeeper Quorum Options +### Step 3: Configure the Connection Type In the **Connection Type** section, **Direct to Drillbit** is selected for using Drill in embedded mode. To use Drill in embedded mode, set the connection type to **Direct** and define HOST and PORT properties. For example: * `HOST=localhost` @@ -63,13 +65,16 @@ To use Drill in distributed mode, select **ZooKeeper Quorum**. If you select Zoo Check the `drill-override.conf` file for the cluster name. +## Step 4: Configure Advanced Properties (optional) -The [Advanced Properties]({{site.baseurl}}/docs/odbc-configuration-reference/) section describes the advanced configuration properties in detail. -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. +The [Advanced Properties]({{site.baseurl}}/docs/odbc-configuration-reference/) section describes the advanced configuration properties in detail. + +## Additional Configuration Options +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. -[Logging Options]({{site.baseurl}}/docs/odbc-configuration-reference/#logging-options) and [Drill Explorer]({{site.baseurl}}/docs/drill-explorer-introduction/) sections describe the options at the bottom of this dialog. +For information about logging options, see [Logging Options]({{site.baseurl}}/docs/odbc-configuration-reference/#logging-options). ### Next Step http://git-wip-us.apache.org/repos/asf/drill/blob/82686d6e/_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 1139e4f..4f7a691 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-06-07 00:02:29 UTC +date: 2017-06-21 23:59:00 UTC parent: "Installing the ODBC Driver" --- Install the MapR Drill ODBC Driver on the machine from which you connect to @@ -19,7 +19,7 @@ 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. +MapR-SASL is not supported on 32-bit machines. ## System Requirements http://git-wip-us.apache.org/repos/asf/drill/blob/82686d6e/_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 ea7bc3e..f31551c 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-06-21 21:09:03 UTC +date: 2017-06-21 23:59:00 UTC parent: "Installing the ODBC Driver" --- Install the MapR Drill ODBC Driver on the machine from which you connect to @@ -10,12 +10,7 @@ Install the MapR Drill ODBC Driver on a system that meets the [system requiremen * [Step 1: Download the MapR Drill ODBC Driver]({{site.baseurl}}/docs/installing-the-driver-on-mac-os-x/#step-1-download-the-mapr-drill-odbc-driver) * [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. + * [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 http://git-wip-us.apache.org/repos/asf/drill/blob/82686d6e/_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 d9a328c..bd6ce3d 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,20 +1,27 @@ --- title: "Installing the Driver on Windows" -date: 2017-06-07 00:02:30 UTC +date: 2017-06-21 23:59:01 UTC parent: "Installing the ODBC Driver" --- The MapR Drill ODBC Driver installer is available for 32- and 64-bit applications on Windows®. On 64-bit Windows operating systems, you can execute both 32- and 64-bit applications. However, 64-bit applications must use 64-bit drivers, and 32-bit applications must use 32-bit drivers. Make sure that you use the driver version that matches the bitness of the client application machine. * MapR Drill 1.3 32-bit.msi for 32-bit applications - * MapR Drill 1.3 64-bit.msi for 64-bit applications + * MapR Drill 1.3 64-bit.msi for 64-bit applications + +{% include startnote.html %}Currently Drill does not support a 32-bit Windows machine. However, the 32- or 64-bit MapR Drill ODBC Driver is supported on a 64-bit machine.{% include endnote.html %} -Install the MapR Drill ODBC Driver on a system that meets the system requirements. + +Install the MapR Drill ODBC Driver on a system that meets the system requirements. Complete the following steps, described in detail in this document: + + * [Step 1: Download the MapR Drill ODBC Driver]({{site.baseurl}}/docs/installing-the-driver-on-windows/#step-1:-download-the-mapr-drill-odbc-driver) + * [Step 2: Install the MapR Drill ODBC Driver]({{site.baseurl}}/docs/installing-the-driver-on-windows/#step-2:-install-the-mapr-drill-odbc-driver) + * [Step 3: Verify the installation]({{site.baseurl}}/docs/installing-the-driver-on-windows/#step-3:-verify-the-installation) ## Known Issue -Drill does not support running drillbits on 32-bit Windows machines. +The 32-bit driver does not support MapR-SASL. The 32-bit driver supports Plain and Kerberos authentication only. ## System Requirements @@ -26,7 +33,7 @@ requirements: * Windows Server 2008 or later * 75 MB of available disk space * .NET Framework 4.5, installed and enabled by default on Windows 8 and later - * Visual C++ Redistributable for Visual Studio 2013 installed (with the same bitness as the driver that you are installing) + * [Visual C++ Redistributable for Visual Studio 2013](https://www.microsoft.com/en-us/download/details.aspx?id=40784) installed (with the same bitness as the driver that you are installing) * 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 `\Windows\system32\drivers\etc\hosts` for each node in the following format:
