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/06/06 23:43:45 UTC
drill git commit: odbc doc edits per cskrbina
Repository: drill
Updated Branches:
refs/heads/gh-pages 3a23e931e -> e6d419ca7
odbc doc edits per cskrbina
Project: http://git-wip-us.apache.org/repos/asf/drill/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/e6d419ca
Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/e6d419ca
Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/e6d419ca
Branch: refs/heads/gh-pages
Commit: e6d419ca7568cb89a2becdf5bb4fcc18d1abe0a3
Parents: 3a23e93
Author: Bridget Bevens <bb...@maprtech.com>
Authored: Tue Jun 6 16:26:06 2017 -0700
Committer: Bridget Bevens <bb...@maprtech.com>
Committed: Tue Jun 6 16:26:06 2017 -0700
----------------------------------------------------------------------
.../010-odbc-configuration-reference.md | 44 ++++++-------
.../020-configuring-odbc-on-linux.md | 33 ++++++----
.../025-configuring-odbc-on-mac-os-x.md | 2 +-
.../030-configuring-odbc-on-windows.md | 2 +-
.../040-testing-the-odbc-connection.md | 2 +-
.../010-installing-the-driver-on-linux.md | 6 +-
.../020-installing-the-driver-on-mac-os-x.md | 15 ++---
.../030-installing-the-driver-on-windows.md | 6 +-
.../020-connecting-drill-explorer-to-data.md | 69 ++++++++++++--------
9 files changed, 91 insertions(+), 88 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/drill/blob/e6d419ca/_docs/odbc-jdbc-interfaces/configuring-odbc/010-odbc-configuration-reference.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/configuring-odbc/010-odbc-configuration-reference.md b/_docs/odbc-jdbc-interfaces/configuring-odbc/010-odbc-configuration-reference.md
index 0a09b2f..b4972ee 100644
--- a/_docs/odbc-jdbc-interfaces/configuring-odbc/010-odbc-configuration-reference.md
+++ b/_docs/odbc-jdbc-interfaces/configuring-odbc/010-odbc-configuration-reference.md
@@ -1,6 +1,6 @@
---
title: "ODBC Configuration Reference"
-date: 2017-05-31 23:17:31 UTC
+date: 2017-06-06 23:26:11 UTC
parent: "Configuring ODBC"
---
You can use various configuration options to control the behavior of the MapR Drill ODBC Driver. You can use these options in a connection string or in the `odbc.ini` configuration file for the Mac OS X version or the driver.
@@ -11,27 +11,27 @@ You can use various configuration options to control the behavior of the MapR Dr
The following table provides a list of the configuration options and a brief description. Subsequent sections describe options in more detail:
-| Property | Default Values | Brief Description |
-|-------------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
-| AdvancedProperties | `CastAnyToVarchar=true; HandshakeTimeout=5; QueryTimeout=180;TimestampTZDisplayTimezone=local; ExcludedSchemas=sys,INFORMATION_SCHEMA; NumberOfPrefetchBuffers=5` | Not required. Advanced properties for configuring the driver. You can set custom connection properties by specifying them as advanced properties. If you specify a property that the driver does not explicitly support, the driver still accepts the property, and passes it to the server for processing. Separate advanced properties using a semi-colon (;) and then surround all advanced properties in a connection string using braces { and }. For example, `{<property>;<property>; . . .}` In addition, the following Advanced Properties string excludes the schemas named `test` and `abc`, sets the timeout to 30 seconds, and sets the time zone to Coordinated Universal Time:`HandshakeTimeout=30;QueryTimeout=30;TimestampTZDisplayTimezone=utc;ExcludedSchemas=test,abc`. |
-| AuthenticationType | No Authentication | Not required. This option specifies how the driver authenticates the connection to Drill. No Authentication: The driver does not authenticate the connection to Drill. Kerberos: The driver authenticates the connection using the Kerberos protocol. Plain: The driver authenticates the connection using a user name and a password. MapRSASL: The driver authenticates the connection using the MapR-SASL protocol. |
-| Catalog | The default catalog name specified in the driver's .did file (typically, DRILL). | Not required. The name of the synthetic catalog under which all of the schemas/databases are organized. This catalog name is used as the value for SQL_DATABASE_NAME or CURRENT CATALOG. |
-| ConnectionType | Direct to Drillbit (Direct) | Required. This option specifies whether the driver connects to a single server or a ZooKeeper cluster. Direct to Drillbit (Direct): The driver connects to a single Drill server. ZooKeeper Quorum (ZooKeeper): The driver connects to a ZooKeeper cluster. |
-| DelegationUID | none | Not required. If a value is specified for this setting, the driver delegates all operations against Drill to the specified user, rather than to the authenticated user for the connection. This option is applicable only when Plain authentication is enabled. |
-| DisableAsync | Clear (0) | Not required. This option specifies whether the driver supports asynchronous queries. Enabled (1): The driver does not support asynchronous queries. Disabled (0): The driver supports asynchronous queries. This option is not supported in connection strings or DSNs. Instead, it must be set as a driver-wide property in the mapr.drillodbc.ini file. Settings in that file apply to all connections that use the driver. |
-| Driver | MapR Drill ODBC Driver on Windows machines or the absolute path of the driver shared object file when installed on a non-Windows machine | On Windows, the name of the installed driver (MapR Drill ODBC Driver). On other platforms, the name of the installed driver as specified in odbcinst.ini, or the absolute path of the driver shared object file. |
-| Host | localhost | Required if the ConnectionType property is set to Direct to Drillbit. The IP address or host name of the Drill server. |
-| KrbServiceHost | none | Required for Kerberos authentication. The fully qualified domain name of the Drill server host. |
-| KrbServiceName | `map` (default) | Required for Kerberos authentication. The Kerberos service principal name of the Drill server. mapr is the default for the MapR Drill ODBC driver. |
-| LogLevel | OFF (0) | Not required. Use this property to enable or disable logging in the driver and to specify the amount of detail included in log files. Only enable logging long enough to capture an issue. Logging decreases performance and can consume a large quantity of disk space. This option is not supported in connection strings. To configure logging for the Windows driver, you must use the Logging Options dialog box. To configure logging for a non-Windows driver, you must use the mapr.drillodbc.ini file. |
-| LogPath | none | Required if logging is enabled. The full path to the folder where the driver saves log files when logging is enabled. When logging is enabled, the driver produces two log files at the location that you specify in the LogPath property: driver.log provides a log of driver activities, and drillclient.log provides a log of Drill client activities. This option is not supported in connection strings. To configure logging for the Windows driver, you must use the Logging Options dialog box. To configure logging for a non-Windows driver, you must use the mapr.drillodbc.ini file. |
-| Port | 31010 | Required if the ConnectionType property is set to Direct to Drillbit. The TCP port that the Drill server uses to listen for client connections. Set the TCP port on which the Drill server is listening. |
-| PWD | none | Required if AuthenticationType is Plain (also known as Basic Authentication). The password corresponding to the user name that you provided in the User field (the UID key). |
-| Schema | none | Not required. The name of the database schema to use when a schema is not explicitly specified in a query. You can still issue queries on other schemas by explicitly specifying the schema in the query. |
-| UID | none | Required if AuthenticationType is Plain (also known as Basic authentication). Set UID to a user name. |
-| UseOnlySSPI (on Windows only) | Clear (0) | Not required. This option is available only in the Windows driver. This option specifies how the driver handles Kerberos authentication: either with theSSPI plugin or with MIT Kerberos. Enabled (1): The driver handles Kerberos authentication by using the SSPI plugin instead of MIT Kerberos by default. Disabled (0): The driver uses MIT Kerberos to handle Kerberos authentication, and only uses the SSPI plugin if the GSSAPI library is not available. |
-| ZKClusterID | drillbits1 | Required if the ConnectionType property is set to ZooKeeper Quorum. Set ZKClusterID to the name of the Drillbit cluster to use. |
-| ZKQuorum | none | Required if the ConnectionType property is set to ZooKeeper. Set ZKQuorum to indicate the server(s) in your ZooKeeper cluster. Separate multiple servers using a comma (,). For example, `<IP address>`,`<IP address>`. |
|
+| Property | Default Values | Brief Description |
+|-------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
+| AdvancedProperties | `CastAnyToVarchar=true; HandshakeTimeout=5; QueryTimeout=180; TimestampTZDisplayTimezone=local; ExcludedSchemas= sys,INFORMATION_SCHEMA; NumberOfPrefetchBuffers=5` | Not required. Advanced properties for configuring the driver. You can set custom connection properties by specifying them as advanced properties. If you specify a property that the driver does not explicitly support, the driver still accepts the property, and passes it to the server for processing. Separate advanced properties using a semi-colon (;) and then surround all advanced properties in a connection string using braces { and }. For example, `{<property>;<property>; . . .}` In addition, the following Advanced Properties string excludes the schemas named `test` and `abc`, sets the timeout to 30 seconds, and sets the time zone to Coordinated Universal Time:`HandshakeTimeout=30;QueryTimeout=30;TimestampTZDisplayTimezone=utc;ExcludedSchemas=test,abc`. |
+| AuthenticationType | No Authentication | Not required. This option specifies how the driver authenticates the connection to Drill. No Authentication: The driver does not authenticate the connection to Drill. Kerberos: The driver authenticates the connection using the Kerberos protocol. Plain: The driver authenticates the connection using a user name and a password. MapRSASL: The driver authenticates the connection using the MapR-SASL protocol. |
+| Catalog | The default catalog name specified in the driver's .did file (typically, DRILL). | Not required. The name of the synthetic catalog under which all of the schemas/databases are organized. This catalog name is used as the value for SQL_DATABASE_NAME or CURRENT CATALOG. |
+| ConnectionType | Direct to Drillbit (Direct) | Required. This option specifies whether the driver connects to a single server or a ZooKeeper cluster. Direct to Drillbit (Direct): The driver connects to a single Drill server. ZooKeeper Quorum (ZooKeeper): The driver connects to a ZooKeeper cluster. |
+| DelegationUID | none | Not required. If a value is specified for this setting, the driver delegates all operations against Drill to the specified user, rather than to the authenticated user for the connection. This option is applicable only when Plain authentication is enabled. |
+| DisableAsync | Clear (0) | Not required. This option specifies whether the driver supports asynchronous queries. Enabled (1): The driver does not support asynchronous queries. Disabled (0): The driver supports asynchronous queries. This option is not supported in connection strings or DSNs. Instead, it must be set as a driver-wide property in the mapr.drillodbc.ini file. Settings in that file apply to all connections that use the driver. |
+| Driver | MapR Drill ODBC Driver on Windows machines or the absolute path of the driver shared object file when installed on a non-Windows machine | On Windows, the name of the installed driver (MapR Drill ODBC Driver). On other platforms, the name of the installed driver as specified in odbcinst.ini, or the absolute path of the driver shared object file. |
+| Host | localhost | Required if the ConnectionType property is set to Direct to Drillbit. The IP address or host name of the Drill server. |
+| KrbServiceHost | none | Required for Kerberos authentication. The fully qualified domain name of the Drill server host. |
+| KrbServiceName | `map` (default) | Required for Kerberos authentication. The Kerberos service principal name of the Drill server. mapr is the default for the MapR Drill ODBC driver. |
+| LogLevel | OFF (0) | Not required. Use this property to enable or disable logging in the driver and to specify the amount of detail included in log files. Only enable logging long enough to capture an issue. Logging decreases performance and can consume a large quantity of disk space. This option is not supported in connection strings. To configure logging for the Windows driver, you must use the Logging Options dialog box. To configure logging for a non-Windows driver, you must use the mapr.drillodbc.ini file. |
+| LogPath | none | Required if logging is enabled. The full path to the folder where the driver saves log files when logging is enabled. When logging is enabled, the driver produces two log files at the location that you specify in the LogPath property: driver.log provides a log of driver activities, and drillclient.log provides a log of Drill client activities. This option is not supported in connection strings. To configure logging for the Windows driver, you must use the Logging Options dialog box. To configure logging for a non-Windows driver, you must use the mapr.drillodbc.ini file. |
+| Port | 31010 | Required if the ConnectionType property is set to Direct to Drillbit. The TCP port that the Drill server uses to listen for client connections. Set the TCP port on which the Drill server is listening. |
+| PWD | none | Required if AuthenticationType is Plain (also known as Basic Authentication). The password corresponding to the user name that you provided in the User field (the UID key). |
+| Schema | none | Not required. The name of the database schema to use when a schema is not explicitly specified in a query. You can still issue queries on other schemas by explicitly specifying the schema in the query. |
+| UID | none | Required if AuthenticationType is Plain (also known as Basic authentication). Set UID to a user name. |
+| UseOnlySSPI (on Windows only) | Clear (0) | Not required. This option is available only in the Windows driver. This option specifies how the driver handles Kerberos authentication: either with the SSPI plugin or with MIT Kerberos. Enabled (1): The driver handles Kerberos authentication by using the SSPI plugin instead of MIT Kerberos by default. Disabled (0): The driver uses MIT Kerberos to handle Kerberos authentication, and only uses the SSPI plugin if the GSSAPI library is not available. |
+| ZKClusterID | drillbits1 | Required if the ConnectionType property is set to ZooKeeper Quorum. Set ZKClusterID to the name of the Drillbit cluster to use. |
+| ZKQuorum | none | Required if the ConnectionType property is set to ZooKeeper. Set ZKQuorum to indicate the server(s) in your ZooKeeper cluster. Separate multiple servers using a comma (,). For example, `<IP address>`,`<IP address>`. |
### Catalog
http://git-wip-us.apache.org/repos/asf/drill/blob/e6d419ca/_docs/odbc-jdbc-interfaces/configuring-odbc/020-configuring-odbc-on-linux.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/configuring-odbc/020-configuring-odbc-on-linux.md b/_docs/odbc-jdbc-interfaces/configuring-odbc/020-configuring-odbc-on-linux.md
index 7b78d59..7885485 100644
--- a/_docs/odbc-jdbc-interfaces/configuring-odbc/020-configuring-odbc-on-linux.md
+++ b/_docs/odbc-jdbc-interfaces/configuring-odbc/020-configuring-odbc-on-linux.md
@@ -1,6 +1,6 @@
---
title: "Configuring ODBC on Linux"
-date: 2017-05-31 23:17:32 UTC
+date: 2017-06-06 23:26:12 UTC
parent: "Configuring ODBC"
---
@@ -32,13 +32,19 @@ In your home directory, rename the files as hidden files. Use sudo if necessary:
## Step 1: Set Environment Variables
-1. Set the ODBCINI environment variable to point to the `.odbc.ini` in your home directory. For example:
+1. Set the ODBCINI environment variable to point to the `.odbc.ini` in your home directory.
+
+ Example:
`export ODBCINI=~/.odbc.ini`
-2. Set the MAPRDRILLINI environment variable to point to `.mapr.drillodbc.ini` in your home directory. For example:
+2. Set the MAPRDRILLINI environment variable to point to `.mapr.drillodbc.ini` in your home directory.
+
+ Example:
`export MAPRDRILLINI=~/.mapr.drillodbc.ini`
-3. Set the `LD_LIBRARY_PATH` environment variable to point to your ODBC driver manager libraries. For example:
+3. Set the `LD_LIBRARY_PATH` environment variable to point to your ODBC driver manager libraries.
+
+ Example:
`export LD_LIBRARY_PATH=/usr/local/lib`
You can have both 32- and 64-bit versions of the driver installed at the same time on the same computer.
@@ -57,7 +63,7 @@ Define the ODBC data sources in the `~/.odbc.ini` configuration file for your en
ZKQuorum=
ZKClusterID=
-To use Drill in distributed mode, set the following properties, described in detail in section ["Direct and ZooKeeper Quorum Properties"]({{site.baseurl}}/docs/configuring-odbc-on-linux/#direct-and-zookeeper-quorum-properties):
+To use Drill in distributed mode, set the following properties. (These properties are described in detail in the [Direct and ZooKeeper Quorum Properties]({{site.baseurl}}/docs/configuring-odbc-on-linux/#direct-and-zookeeper-quorum-properties) section.)
ConnectionType=ZooKeeper
HOST=
@@ -65,7 +71,7 @@ To use Drill in distributed mode, set the following properties, described in det
ZKQuorum=<host name>:<port>,<host name>:<port> . . . <host name>:<port>
ZKClusterID=<cluster name in `drill-override.conf`>
-The following Linux sample shows a possible configuration for using Drill in distributed mode. The example modifies the default Linux-installed `.odbc.ini` for a 64-bit system by commenting out 32-bit properties, adding 64-bit properties, and removes the extraneous MapR Drill 64-bit from `.odbc.ini`.
+The following Linux sample shows a possible configuration for using Drill in distributed mode.
[ODBC]
Trace=no
@@ -73,7 +79,8 @@ The following Linux sample shows a possible configuration for using Drill in dis
[ODBC Data Sources]
MapR Drill 32-bit=MapR Drill ODBC Driver 32-bit
MapR Drill 64-bit=MapR Drill ODBC Driver 64-bit
- [MapR Drill 32-bit]
+
+ [MapR Drill 32-bit]
# This key is not necessary and only describes the data source.
# Description=MapR Drill ODBC Driver (32-bit) DSN
@@ -90,10 +97,10 @@ The following Linux sample shows a possible configuration for using Drill in dis
# Values for ConnectionType, AdvancedProperties, Catalog, Schema should be set here.
# If ConnectionType is Direct, include Host and Port. If ConnectionType is ZooKeeper, include ZKQuorum and ZKClusterID
# They can also be specified on the connection string.
- # AuthenticationType:No authentication;Plain;Kerberos
+ # AuthenticationType:No authentication;Plain;Kerberos;
ConnectionType=Direct
- HOST=
- PORT=
+ HOST=[HOST]
+ PORT=[PORT]
ZKQuorum=[Zookeeper Quorum]
ZKClusterID=[Cluster ID]]
AuthenticationType=No Authentication
@@ -121,10 +128,10 @@ The following Linux sample shows a possible configuration for using Drill in dis
# Values for ConnectionType, AdvancedProperties, Catalog, Schema should be set here.
# If ConnectionType is Direct, include Host and Port. If ConnectionType is ZooKeeper, include ZKQuorum and ZKClusterID
# They can also be specified on the connection string.
- # AuthenticationType:No authentication;Plain;Kerberos;MapRSASL
+ # AuthenticationType:No authentication;Plain;Kerberos;MapRSASL;
ConnectionType=Direct
- HOST=
- PORT=
+ HOST=[HOST]
+ PORT=[PORT]
ZKQuorum=[Zookeeper Quorum]
ZKClusterID=[Cluster ID]]
AuthenticationType=No Authentication
http://git-wip-us.apache.org/repos/asf/drill/blob/e6d419ca/_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 455d1a2..11939b2 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-06-03 01:09:30 UTC
+date: 2017-06-06 23:26:12 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/e6d419ca/_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 5025170..7d4985e 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-06-03 01:09:31 UTC
+date: 2017-06-06 23:26:12 UTC
parent: "Configuring ODBC"
---
Complete one of the following steps to create an ODBC connection on Windows to Drill data
http://git-wip-us.apache.org/repos/asf/drill/blob/e6d419ca/_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 2a7046c..2d49016 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: 2017-06-03 01:09:33 UTC
+date: 2017-06-06 23:26:13 UTC
parent: "Configuring ODBC"
---
You can use DSN connection strings and DSN-less connection strings for your connections.
http://git-wip-us.apache.org/repos/asf/drill/blob/e6d419ca/_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 96623d6..2c50e8e 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-03 01:09:34 UTC
+date: 2017-06-06 23:26:13 UTC
parent: "Installing the ODBC Driver"
---
Install the MapR Drill ODBC Driver on the machine from which you connect to
@@ -17,10 +17,6 @@ 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/e6d419ca/_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 ae3a5ed..d157f5b 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-03 01:09:36 UTC
+date: 2017-06-06 23:26:14 UTC
parent: "Installing the ODBC Driver"
---
Install the MapR Drill ODBC Driver on the machine from which you connect to
@@ -12,12 +12,6 @@ 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.
@@ -33,7 +27,8 @@ 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 %}
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/).
@@ -49,9 +44,7 @@ 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.**
-
-
-MapR Drill ODBC Driver files install in the following locations:
+{% include startnote.html %}MapR Drill ODBC Driver files install in the following locations:{% include endnote.html %}
* `/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/e6d419ca/_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 25fb01d..e2e5fd0 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-06-03 01:09:38 UTC
+date: 2017-06-06 23:26:14 UTC
parent: "Installing the ODBC Driver"
---
The MapR Drill ODBC Driver installer is available for 32- and 64-bit
@@ -12,10 +12,6 @@ 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
http://git-wip-us.apache.org/repos/asf/drill/blob/e6d419ca/_docs/odbc-jdbc-interfaces/using-drill-explorer/020-connecting-drill-explorer-to-data.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/using-drill-explorer/020-connecting-drill-explorer-to-data.md b/_docs/odbc-jdbc-interfaces/using-drill-explorer/020-connecting-drill-explorer-to-data.md
index 65e15bc..049abde 100644
--- a/_docs/odbc-jdbc-interfaces/using-drill-explorer/020-connecting-drill-explorer-to-data.md
+++ b/_docs/odbc-jdbc-interfaces/using-drill-explorer/020-connecting-drill-explorer-to-data.md
@@ -1,60 +1,71 @@
---
title: "Connecting Drill Explorer to Data"
-date: 2017-05-31 00:03:42 UTC
+date: 2017-06-06 23:26:14 UTC
parent: "Using Drill Explorer"
---
The way you start Drill Explorer differs depending on your platform, but regardless of the platform, Drill must be running.
## Connecting Drill Explorer to Data on Linux
-You need an X-11 XDisplay to use Drill Explorer on Linux. Run the DrillExplorer executable in `/opt/mapr/drillodbc/DrillExplorer`, and then follow instructions from step 2 in the next section, "Connecting Drill Explorer to Data on Mac OS X."
+You need an X-11 XDisplay to use Drill Explorer on Linux. Run the DrillExplorer executable in `/opt/mapr/drillodbc/DrillExplorer`, and then follow instructions from step 2 in the next section, *Connecting Drill Explorer to Data on Mac OS X*.
## Connecting Drill Explorer to Data on Mac OS X
-1. On a node that is running Drill, run Drill Explorer. The Drill Explorer app is located in the `/Applications` directory.
- The Drill Explorer console appears.
+1. On a node that is running Drill, run Drill Explorer. The Drill Explorer app is located in the `/Applications` directory. The Drill Explorer console appears.
-2. Click **Connect** on the console.
- The Drill Explorer dialog appears.
- 
+2. Click **Connect** on the console. The Drill Explorer dialog appears.
+
+ 
-3. If you connect through a DSN, on the ODBC DSN tab, select the name of the DSN you configured. For example, select Sample MapR Drill DSN.
- Alternatively, if you use a DSN-less connection, on the Advanced tab, type a connection string in the text box. For example, type the following connection string:
+3. If you connect through a DSN, select the name of the DSN you configured on the **ODBC DSN** tab. For example, select **MapR Drill**. Alternatively, if you use a DSN-less connection, type a connection string in the text box on the **Advanced** tab.. For example, type the following connection string:
+
DRIVER=MapR Drill ODBC Driver;AdvancedProperties={HandshakeTimeout=0;QueryTimeout=0;TimestampTZDisplayTimezone=utc;ExcludedSchemas=sys, INFORMATION_SCHEMA;};Catalog=DRILL;Schema=;ConnectionType=ZooKeeper;ZKQuorum=192.168.39.43:5181;ZKClusterID=drillbits1
-5. If you set the [AuthenticationType property]({{ site.baseurl }}/docs/odbc-configuration-reference/#configuration-options) to Plain or Basic Authentication, which enables impersonation, respond to the prompt for a user name and password.
-4. Click **Connect** in the dialog.
- In the Schemas panel, the [schema]({{ site.baseurl }}/docs/odbc-configuration-reference/#schema) for the connected data source appear. For example, the default schema is `dfs`, which points to the local file system on your machine.
- 
+
+5. If you set the Authentication Type property to **Plain** (or Basic Authentication), which enables impersonation, respond to the prompt for a user name and password.
+
+4. Click **Connect** in the dialog. In the **Schemas** panel, the schema for the connected data source appear.
+
+ 
## Starting Drill Explorer on Windows
-In Windows 10, you can start Drill Explorer from the Start menu or from the ODBC Data Source Administrator.
+In Windows 10, you can start Drill Explorer in two ways::
+
+- Start menu
+- ODBC Data Source Administrator
+### Start Menu
To start Drill Explorer from the Start menu:
-1\. Click **Start**, and locate MaprR Drill ODBC Driver <*version*>.
-
- 
+1. Click **Start**, and locate **MaprR Drill Driver 1.3 <*version*>**.
-2\. Click **Drill Explorer**.
+2. Click **Drill Explorer**.
- 
-
-3\. Select the DSN that you want to explore. For example, select MapR Drill and click Connect.
+ 
-To start Drill Explorer from the ODBC Administrator in Windows 10:
+ The **ODBC Connection** dialog with the **DSN** tab displayed appears in Drill Explorer.
-1\. In the Settings field, enter **odbc**. Select a version and the ODBC Data Source Administrator <version> appears.
+
+
+3\. Select the DSN that you want to explore. For example, select **MapR Drill** and click **Connect**.
+
+
+### ODBC Data Source Administrator
+To start Drill Explorer from the ODBC Data Source Administrator:
+
+1. Enter **odbc** and select a version of the utility from the Windows Settings field. The **ODBC Data Source Administrator <*version*>** dialog appears.
- 
+ 
-3\. Click **System DSN**. Select MapR Drill and click Connect.
- The DSN Setup dialog appears showing the properties.
+3. Click the **System DSN** tab.
+
+5. Select **MapR Drill** and click **Configure**. The **MapR Drill ODBC Driver DSN Setup** dialog appears showing multiple configuration properties.
- 
+ 
+
+4. Click **Drill Explorer** at the bottom of the dialog. Drill Explorer appears.
+
-. Click **Drill Explorer** at the bottom of the dialog.
- Drill Explorer appears.