drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bridg...@apache.org
Subject [4/6] drill git commit: add zk connect example plus edits
Date Wed, 24 Jun 2015 00:16:24 GMT
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
 


Mime
View raw message