drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bridg...@apache.org
Subject drill git commit: odbc doc edits per cskrbina
Date Tue, 06 Jun 2017 23:43:45 GMT
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 <bbevens@maprtech.com>
Authored: Tue Jun 6 16:26:06 2017 -0700
Committer: Bridget Bevens <bbevens@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.  
-   ![sample mapr drill dsn]({{ site.baseurl }}/docs/img/explorer-connect.png)
+2. Click **Connect** on the console. The Drill Explorer dialog appears.  
+ 
+	![](http://i.imgur.com/vvr1vs4.png)
 
-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.  
-   ![explorer schemas]({{ site.baseurl }}/docs/img/explorer-schemas.png) 
+
+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.   
+ 
+	![](http://i.imgur.com/PZaVPRf.png)
 
 ## 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*>. 
-   
-   ![winstart]({{ site.baseurl }}/docs/img/winstart.png)
+1. Click **Start**, and locate **MaprR Drill Driver 1.3 <*version*>**. 
 
-2\. Click **Drill Explorer**.
+2. Click **Drill Explorer**.
    
-   ![odbcexplore]({{ site.baseurl }}/docs/img/odbc-explorer-win.png)
-
-3\. Select the DSN that you want to explore. For example, select MapR Drill and click Connect.
+	![](http://i.imgur.com/qswpcKS.png)
    
-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. 
+![](http://i.imgur.com/W1CQwH0.png)
+
+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. 
    
-   ![obdcconfig]({{ site.baseurl }}/docs/img/odbc-configure1.png)
+	![](http://i.imgur.com/W9ZO5PN.png)
    
-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.  
    
-   ![odbcconfig2]({{ site.baseurl }}/docs/img/odbc-configure2.png)
+	![](http://i.imgur.com/FlRRuSm.png)
+
+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.
 
 
 


Mime
View raw message