add zk connect example plus edits
formatting
Project: http://git-wip-us.apache.org/repos/asf/drill/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/7de2ea77
Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/7de2ea77
Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/7de2ea77
Branch: refs/heads/gh-pages
Commit: 7de2ea77b985d3c892e28dd00377b55585d92454
Parents: e033059
Author: Kristine Hahn <khahn@maprtech.com>
Authored: Tue Jun 23 13:47:07 2015 -0700
Committer: Kristine Hahn <khahn@maprtech.com>
Committed: Tue Jun 23 14:27:31 2015 -0700
----------------------------------------------------------------------
.../020-configuring-odbc-on-linux.md | 6 ++--
.../040-testing-the-odbc-connection.md | 34 +++++++++++---------
2 files changed, 22 insertions(+), 18 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/drill/blob/7de2ea77/_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 ad83541..e89103a 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
@@ -45,7 +45,7 @@ Only include the path to the shared libraries corresponding to the driver
matchi
## Step 2: Define the ODBC Data Sources in .odbc.ini
-Define the ODBC data sources in the `~/.odbc.ini` configuration file for your environment.
You set the following properties for using Drill in embedded mode:
+Define the ODBC data sources in the `~/.odbc.ini` configuration file for your environment.
To use Drill in embedded mode, set the following properties:
ConnectionType=Direct
HOST=localhost
@@ -53,7 +53,7 @@ Define the ODBC data sources in the `~/.odbc.ini` configuration file for
your en
ZKQuorum=
ZKClusterID=
-You set the following properties for using Drill in distributed mode:
+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):
ConnectionType=ZooKeeper
HOST=
@@ -108,7 +108,7 @@ The following Linux sample shows a possible configuration for using Drill
in dis
To password protect the DSN, uncomment the AuthenticationType, select Basic Authentication
for the AuthenticationType, and configure UID and PWD properties.
### Direct and ZooKeeper Quorum Properties
-To use Drill in distributed mode, set ConnectionType to Zookeeper, get the ZKQuorum and ZKClusterID
values from the `drill-override.conf` file, and define the ZKQuorum and ZKClusterID properties.
Format ZKQuorum as a comma separated list of ZooKeeper nodes in the following format:
+To use Drill in distributed mode, set ConnectionType to Zookeeper, get the ZKQuorum and ZKClusterID
values from the `drill-override.conf` file, and define the ZKQuorum and ZKClusterID properties.
The `drill-override.conf` is in the `/drill/drill-<version>/conf` directory. Format
ZKQuorum as a comma separated list of ZooKeeper nodes in the following format:
`<host name/ip address> : <port number>, <host name/ip address> : <port
number>, . . .`
For example:
http://git-wip-us.apache.org/repos/asf/drill/blob/7de2ea77/_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 46ee4e2..88bf8e3 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
@@ -19,25 +19,27 @@ There are 32-bit and 64-bit installations of the iODBC driver manager
available.
Visit [http://www.iodbc.org](http://www.iodbc.org/) for further details on
using the iODBC driver manager.
-**Example**
+### Example of a Test on Linux
To test the ODBC connection on a Linux cluster, follow these steps:
-1. [Start Drill]({{site.baseurl}}/docs/starting-drill-on-linux-and-mac-os-x/). For example,
to start Drill in local mode on a linux cluster:
+1. [Start Drill]({{site.baseurl}}/docs/starting-drill-on-linux-and-mac-os-x/). For example,
to start Drill in local mode on a linux cluster:
+
[root@centos23 drill-1.0.0]# bin/drill-localhost
apache drill 1.0.0
"the only truly happy people are children, the creative minority and drill users"
-2. Run `iodbctest` or `iodbctestw`.
- The prompt for an ODBC connection string appears.
+2. In the `samples` directory of the driver manager installation, run `iodbctest` or `iodbctestw`.
+
[root@centos23 libiodbc-3.52.7]# samples/iodbctest
- iODBC Demonstration program
+ iODBC Demonstration program
This program shows an interactive SQL processor
Driver Manager: 03.52.0709.0909
+ The prompt for an ODBC connection string appears.
Enter ODBC connect string (? shows list): ?
-3. Type ? to see the DSN name.
+3. Type ? to see the DSN name.
Output is:
DSN | Driver
@@ -47,26 +49,28 @@ To test the ODBC connection on a Linux cluster, follow these steps:
4. If you are connecting directly to a Drillbit, type an ODBC connection string using the
following format:
- `DSN=<DSN name>;ConnectionType=Direct;Host=<Host Name>;Port=<Port Number>`
+ DSN=<DSN name>;ConnectionType=Direct;Host=<Host Name>;Port=<Port Number>
OR
If you are connecting to a ZooKeeper cluster, type an ODBC connection string using the
following format:
- `DSN=<DSN Name>;ConnectionType=ZooKeeper;ZKQuorum=<Server1:Port1>
-,<Server2:Port2>;ZKClusterID=<Cluster Name>`
+ DSN=<DSN Name>;ConnectionType=ZooKeeper;ZKQuorum=<Server1:Port1>,<Server2:Port2>;ZKClusterID=<Cluster
Name>`
- The following example shows a connection string:
+ The output of a successful test is:
+ `Driver: 1.0.0.1001 (MapR Drill ODBC Driver)
+ SQL> `
+ After the `SQL>` prompt appears, type `quit;`, and go to the Drill shell to run commands.
Do not attempt to run SQL commands from this prompt.
- `DSN=Sample MapR Drill DSN 64;ConnectionType=Direct;Host=localhost;Port=31010`
+### Example Connection Strings
- The output of a successful test is:
+The following example shows a connection string for a direct connection:
- `Driver: 1.0.0.1001 (MapR Drill ODBC Driver)
+ DSN=Sample MapR Drill DSN 64;ConnectionType=Direct;Host=localhost;Port=31010
- SQL> `
+The following example shows a connection string for a ZooKeeper cluster connection:
- After he `SQL>` prompt appears, go to the Drill shell to run commands. Do not attempt
to run SQL commands from this prompt.
+ DSN=Sample MapR Drill DSN 64;ConnectionType=ZooKeeper;ZKQuorum=centos23.lab:5181;ZKClusterID=docs41cluster-drillbits
## Testing the ODBC Connection on Mac OS X
|