Repository: drill Updated Branches: refs/heads/gh-pages 79b45b1b9 -> 475e051c3
updates for the new Drill 1.9 drivers. Project: http://git-wip-us.apache.org/repos/asf/drill/repo Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/475e051c Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/475e051c Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/475e051c Branch: refs/heads/gh-pages Commit: 475e051c3e460d7dcf0e6d802c47dfa6766f885e Parents: 79b45b1 Author: Bridget Bevens <[email protected]> Authored: Fri Dec 23 16:01:37 2016 -0800 Committer: Bridget Bevens <[email protected]> Committed: Fri Dec 23 16:01:37 2016 -0800 ---------------------------------------------------------------------- .../010-interfaces-introduction.md | 10 +++--- .../010-odbc-configuration-reference.md | 38 ++++++++++---------- .../025-configuring-odbc-on-mac-os-x.md | 30 ++++------------ .../010-installing-the-driver-on-linux.md | 8 ++--- .../020-installing-the-driver-on-mac-os-x.md | 8 ++--- .../030-installing-the-driver-on-windows.md | 6 ++-- 6 files changed, 42 insertions(+), 58 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/drill/blob/475e051c/_docs/odbc-jdbc-interfaces/010-interfaces-introduction.md ---------------------------------------------------------------------- diff --git a/_docs/odbc-jdbc-interfaces/010-interfaces-introduction.md b/_docs/odbc-jdbc-interfaces/010-interfaces-introduction.md index a92e80b..c0d7854 100644 --- a/_docs/odbc-jdbc-interfaces/010-interfaces-introduction.md +++ b/_docs/odbc-jdbc-interfaces/010-interfaces-introduction.md @@ -1,6 +1,6 @@ --- title: "Interfaces Introduction" -date: 2016-01-20 22:37:33 UTC +date: 2016-12-24 00:01:38 UTC parent: "ODBC/JDBC Interfaces" --- You can connect to Apache Drill through the following interfaces: @@ -11,15 +11,15 @@ You can connect to Apache Drill through the following interfaces: * [JDBC]({{ site.baseurl }}/docs/using-jdbc-with-squirrel-on-windows/) * C++ API -*Apache Drill does not have an open source ODBC driver. However, MapR provides an ODBC 3.8 driver developed specifically for connecting Apache Drill to BI tools. +*Apache Drill does not have an open source ODBC driver. However, MapR provides an ODBC driver developed specifically for connecting Apache Drill to BI tools. ## Using ODBC to Access Apache Drill from BI Tools -MapR provides an ODBC 3.8 driver that connects Windows, Mac OS X, and Linux to Apache Drill and BI tools. Install the latest version of Apache Drill with the latest version of the MapR Drill ODBC driver. An ODBC driver that you installed with a older version of Drill probably will not work with an upgraded version of Drill. +MapR provides an ODBC driver that connects Windows, Mac OS X, and Linux to Apache Drill and BI tools. Install the latest version of Apache Drill with the latest version of the MapR Drill ODBC driver. An ODBC driver that you installed with an older version of Drill may not work with an upgraded version of Drill. -Access the latest MapR Drill ODBC drivers in the following location: +Access the latest MapR Drill ODBC drivers in the following location: -<http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v1.2.1.1000/> +<http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v1.3.0.1009/> ## Using JDBC to Access Apache Drill from SQuirrel http://git-wip-us.apache.org/repos/asf/drill/blob/475e051c/_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 e351092..4d2612f 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: +date: 2016-12-24 00:01:39 UTC parent: "Configuring ODBC" --- @@ -12,23 +12,25 @@ Drill ODBC Driver. You can use these options in a connection string or in the ## Configuration Options -The following table provides a list of the configuration options and a brief description. Subsequent sections describe options in more detail: - -| Property | Valid Values | Brief Description | -|--------------------|-------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| -| Catalog | DRILL | The name of the synthetic catalog under which all of the schemas/databases are organized. | -| ConnectionType | Direct or ZooKeeper | Direct connects to a Drill server using Host and Port properties. ZooKeeper connects to a ZooKeeper cluster using ZKQuorum and ZKClusterID properties. | -| Driver | MapR Drill ODBC Driver | The name of the installed driver. | -| Host | \<host name\> | If the ConnectionType property is set to Direct, set the host name of the Drill server using the Host property. | -| Port | 31010 | If the ConnectionType property is set to Direct, set the e TCP port on which the Drill server is listening. | -| Schema | \<schema name\> | The name of the database schema or storage plugin name to use when the query does not explicitly specify the schema or storage plugin. | -| ZKClusterID | drillbits1 | If the ConnectionType property is set to ZooKeeper, then set ZKClusterID to the name of the Drillbit cluster to use. | -| ZKQuorum | \<IP address\>,\<IP address\> . . . | If the ConnectionType property is set to ZooKeeper, then use ZKQuorum to indicate the server(s) in your ZooKeeper cluster. Separate multiple servers using a comma (,). | -| AuthenticationType | No Authentication or Basic Authentication | Basic Authentication enables [impersonation]({{site.baseurl}}/docs/configuring-user-impersonation/). | -| UID | \<user name\> | If AuthenticationType is Basic Authentication, set the UID to a user name. | -| PWD | \<password\> | If AuthenticationType is Basic Authentication, set the PWD to a password. | -| AdvancedProperties | {\<property\>;\<property\>; . . .} | Separate advanced properties using a semi-colon (;) and then surround all advanced properties in a connection string using braces { and }. | -| DisableAsync | 0 or 1 | Disables asynchronous ODBC connection and enables a synchronous connection. A change in state occurs during driver initialization and is propagated to all driver DSNs. | +The following table provides a list of the configuration options and a brief description. Subsequent sections describe options in more detail: + +| Property | Valid Values | Brief Description | +|--------------------|---------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| +| Catalog | DRILL | The name of the synthetic catalog under which all of the schemas/databases are organized. | +| ConnectionType | Direct or ZooKeeper | Direct connects to a Drill server using Host and Port properties. ZooKeeper connects to a ZooKeeper cluster using ZKQuorum and ZKClusterID properties. | +| Driver | MapR Drill ODBC Driver | The name of the installed driver. | +| Host | <host name> | If the ConnectionType property is set to Direct, set the host name of the Drill server using the Host property. | +| Port | 31010 | If the ConnectionType property is set to Direct, set the e TCP port on which the Drill server is listening. | +| Schema | <schema name> | The name of the database schema or storage plugin name to use when the query does not explicitly specify the schema or storage plugin. | +| ZKClusterID | drillbits1 | If the ConnectionType property is set to ZooKeeper, then set ZKClusterID to the name of the Drillbit cluster to use. | +| ZKQuorum | <IP address>,<IP address> . . . | If the ConnectionType property is set to ZooKeeper, then use ZKQuorum to indicate the server(s) in your ZooKeeper cluster. Separate multiple servers using a comma (,). | +| AuthenticationType | No Authentication or Basic Authentication | Basic Authentication enables impersonation. | +| UID | <user name> | If AuthenticationType is Basic Authentication, set the UID to a user name. | +| PWD | <password> | If AuthenticationType is Basic Authentication, set the PWD to a password. | +| DelegationUID | <impersonation_target> | The impersonation target for the authorized proxy user. See Configuring Inbound Impersonation. | +| AdvancedProperties | {<property>;<property>; . . .} | Separate advanced properties using a semi-colon (;) and then surround all advanced properties in a connection string using braces { and }. | +| DisableAsync | 0 or 1 | Disables asynchronous ODBC connection and enables a synchronous connection. A change in state occurs during driver initialization and is propagated to all driver DSNs. | + ### Catalog http://git-wip-us.apache.org/repos/asf/drill/blob/475e051c/_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 718a7cb..bab70ff 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: +date: 2016-12-24 00:01:39 UTC parent: "Configuring ODBC" --- ODBC driver managers use configuration files to define and configure ODBC data @@ -9,8 +9,7 @@ steps: * [Step 1: Set Environment Variables]({{site.baseurl}}/docs/configuring-odbc-on-mac-os-x/#step-1:-set-environment-variables) * [Step 2: Define the ODBC Data Sources in odbc.ini]({{site.baseurl}}/docs/configuring-odbc-on-mac-os-x/#step-2:-define-the-odbc-data-sources-in-.odbc.ini) -* [Step 3: (Optional) Define the ODBC Driver in odbcinst.ini]({{site.baseurl}}/docs/configuring-odbc-on-mac-os-x/#step-3:-(optional)-define-the-odbc-driver-in-.odbcinst.ini) -* [Step 4: Configure the MapR Drill ODBC Driver]({{site.baseurl}}/docs/configuring-odbc-on-mac-os-x/#step-4:-configure-the-mapr-drill-odbc-driver) +* [Step 3: Configure the MapR Drill ODBC Driver]({{site.baseurl}}/docs/configuring-odbc-on-mac-os-x/#step-4:-configure-the-mapr-drill-odbc-driver) ## Sample Configuration Files @@ -25,7 +24,6 @@ In your home directory, rename the files as hidden files. Use sudo if necessary: * .mapr.drillodbc.ini * .odbc.ini -* .odbcinst.ini The installer for Mac OS X creates a sample user DSN in odbc.ini in either of the following locations: @@ -40,10 +38,11 @@ Depending on the driver manager you use, the user DSN in one of these files will ## Step 1: Set Environment Variables -Create or modify the `/etc/launchd.conf` file to set environment variables. Set the SIMBAINI variable to point to the `.mapr.drillodbc.ini` file, the ODBCSYSINI varialbe to the `.odbcinst.ini` file, the ODBCINI variable to the `.odbc.ini` file, and the DYLD_LIBRARY_PATH to the location of the dynamic linker (DYLD) libraries and to the MapR Drill ODBC Driver. If you installed the iODBC driver manager using the DMG, the DYLD libraries are installed in `/usr/local/iODBC/lib`. The launchd.conf file should look something like this: +Create or modify the `/etc/launchd.conf` file to set environment variables. Set the SIMBAINI variable to point to the `.mapr.drillodbc.ini` file, the ODBCINI variable to the `.odbc.ini` file, and the DYLD_LIBRARY_PATH to the location of the dynamic linker (DYLD) libraries and to the MapR Drill ODBC Driver. + +If you installed the iODBC driver manager using the DMG, the DYLD libraries are installed in `/usr/local/iODBC/lib`. The launchd.conf file should look something like this: setenv SIMBAINI /Users/joeuser/.mapr.drillodbc.ini - setenv ODBCSYSINI /Users/joeuser/.odbcinst.ini setenv ODBCINI /Users/joeuser/.odbc.ini setenv DYLD_LIBRARY_PATH /usr/local/iODBC/lib:/opt/mapr/drillodbc/lib/universal @@ -131,24 +130,7 @@ behavior of DSNs using the MapR Drill ODBC Driver. ---------- -## Step 3: (Optional) Define the ODBC Driver in .odbcinst.ini - -The `.odbcinst.ini` is an optional configuration file that defines the ODBC -Drivers. This configuration file is optional because you can specify drivers -directly in the` .odbc.ini` configuration file. The following sample shows a possible configuration. - -**Example** - - [ODBC Drivers] - MapR Drill ODBC Driver=Installed - - [MapR Drill ODBC Driver] - Description=MapR Drill ODBC Driver - Driver=/opt/mapr/drillodbc/lib/universal/libmaprdrillodbc.dylib - ----------- - -## Step 4: Configure the MapR Drill ODBC Driver +## Step 3: Configure the MapR Drill ODBC Driver Configure the MapR Drill ODBC Driver for your environment by modifying the `.mapr.drillodbc.ini` configuration file. This configures the driver to work with your ODBC driver manager. The following sample shows a possible configuration, which you can use as is if you installed the default iODBC driver manager. http://git-wip-us.apache.org/repos/asf/drill/blob/475e051c/_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 326f1b0..8839d59 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: 2016-07-22 00:44:51 UTC +date: 2016-12-24 00:01:40 UTC parent: "Installing the ODBC Driver" --- Install the MapR Drill ODBC Driver on the machine from which you connect to @@ -38,10 +38,10 @@ If not, create an entry in `/etc/hosts` for each node in the following format: To install the driver, you need Administrator privileges on the computer. ## Step 1: Download the MapR Drill ODBC Driver -Download either the 32- or 64-bit driver: +Download either the 32 or 64-bit driver: - * [MapR Drill ODBC Driver (32-bit)](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v1.2.1.1000/MapRDrillODBC-32bit-1.2.1.i686.rpm) - * [MapR Drill ODBC Driver (64-bit)](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v1.2.1.1000/MapRDrillODBC-1.2.1.x86_64.rpm) + * [MapR Drill ODBC Driver (32-bit)](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v1.3.0.1009/maprdrill-1.3.0.1009-1.i686.rpm) + * [MapR Drill ODBC Driver (64-bit)](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v1.3.0.1009/maprdrill-1.3.0.1009-1.x86_64.rpm) ## Step 2: Install the MapR Drill ODBC Driver http://git-wip-us.apache.org/repos/asf/drill/blob/475e051c/_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 76b3015..150262c 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: 2016-01-20 21:22:50 UTC +date: 2016-12-24 00:01:40 UTC parent: "Installing the ODBC Driver" --- Install the MapR Drill ODBC Driver on the machine from which you connect to @@ -32,7 +32,7 @@ To install the driver, you need Administrator privileges on the computer. Click the following link to download the driver: -[MapR Drill ODBC Driver for Mac](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v1.2.1.1000/MapRDrillODBC.dmg) +[MapR Drill ODBC Driver for Mac](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v1.3.0.1009/MapR_Drill_1.3.dmg) ---------- @@ -40,7 +40,7 @@ Click the following link to download the driver: To install the driver, complete the following steps: - 1. Double-click `MapRDrillODBC.dmg` to mount the disk image. + 1. Double-click `MapRDrill1.3.dmg` to mount the disk image. 2. Double-click `MapRDrillODBC.pkg` to run the Installer. 3. Follow the instructions in the Installer to complete the installation process. 4. When the installation completes, click **Close.** @@ -57,7 +57,7 @@ To check the version of the driver you installed, use the following command on t $ pkgutil --info mapr.drillodbc package-id: mapr.drillodbc - version: 1.2.0 + version: 1.3.0 (may also display as 3.52.12) volume: / location: install-time: 1433465518 http://git-wip-us.apache.org/repos/asf/drill/blob/475e051c/_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 c2fd377..04640d6 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: 2016-04-12 21:31:46 UTC +date: 2016-12-24 00:01:41 UTC parent: "Installing the ODBC Driver" --- The MapR Drill ODBC Driver installer is available for 32- and 64-bit @@ -36,8 +36,8 @@ To install the driver, you need Administrator privileges on the computer. Download the installer that corresponds to the bitness of the client application from which you want to create an ODBC connection: -* [MapR Drill ODBC Driver (32-bit)](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v1.2.1.1000/MapRDrillODBC32.msi) -* [MapR Drill ODBC Driver (64-bit)](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v1.2.1.1000/MapRDrillODBC64.msi) +* [MapR Drill ODBC Driver (32-bit)](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v1.3.0.1009/MapR_Drill_1.3_32-bit.msi) +* [MapR Drill ODBC Driver (64-bit)](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v1.3.0.1009/MapR_Drill_1.3_64-bit.msi) ----------
