Bridget's changes
Project: http://git-wip-us.apache.org/repos/asf/drill/repo Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/288ac7dc Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/288ac7dc Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/288ac7dc Branch: refs/heads/gh-pages Commit: 288ac7dcc0b2fc20f3267ac969fad394fbfe1e5b Parents: 79a47da Author: Kristine Hahn <[email protected]> Authored: Mon May 4 18:00:22 2015 -0700 Committer: Kristine Hahn <[email protected]> Committed: Mon May 4 18:00:22 2015 -0700 ---------------------------------------------------------------------- _data/docs.json | 176 ++++++++++++++++--- _docs/img/spotfire_1.png | Bin 0 -> 63223 bytes _docs/img/spotfire_2.png | Bin 0 -> 120724 bytes _docs/img/spotfire_3.png | Bin 0 -> 23075 bytes _docs/img/spotfire_4.png | Bin 0 -> 23999 bytes _docs/img/spotfire_5.png | Bin 0 -> 45511 bytes _docs/img/spotfire_6.png | Bin 0 -> 48674 bytes _docs/odbc-jdbc-interfaces/020-using-jdbc.md | 7 +- ...-using-microstrategy-analytics-with-drill.md | 11 +- ...-apache-drill-with-tibco-spotfire-desktop.md | 50 ++++++ .../odbc-jdbc-interfaces/060-using-spotfire.md | 50 ++++++ .../010-installing-the-driver-on-linux.md | 4 +- .../020-installing-the-driver-on-mac-os-x.md | 2 +- .../010-installing-the-driver-on-windows.md | 4 +- _docs/rn/070-0.9.0-rn.md | 29 +++ 15 files changed, 296 insertions(+), 37 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/drill/blob/288ac7dc/_data/docs.json ---------------------------------------------------------------------- diff --git a/_data/docs.json b/_data/docs.json index 6400359..95424c3 100644 --- a/_data/docs.json +++ b/_data/docs.json @@ -287,8 +287,8 @@ } ], "children": [], - "next_title": "Sample Datasets", - "next_url": "/docs/sample-datasets/", + "next_title": "Apache Drill 0.9.0 Release Notes", + "next_url": "/docs/apache-drill-0-9-0-release-notes/", "parent": "Release Notes", "previous_title": "Apache Drill 0.7.0 Release Notes", "previous_url": "/docs/apache-drill-0-7-0-release-notes/", @@ -296,6 +296,23 @@ "title": "Apache Drill 0.8.0 Release Notes", "url": "/docs/apache-drill-0-8-0-release-notes/" }, + "Apache Drill 0.9.0 Release Notes": { + "breadcrumbs": [ + { + "title": "Release Notes", + "url": "/docs/release-notes/" + } + ], + "children": [], + "next_title": "Sample Datasets", + "next_url": "/docs/sample-datasets/", + "parent": "Release Notes", + "previous_title": "Apache Drill 0.8.0 Release Notes", + "previous_url": "/docs/apache-drill-0-8-0-release-notes/", + "relative_path": "_docs/rn/070-0.9.0-rn.md", + "title": "Apache Drill 0.9.0 Release Notes", + "url": "/docs/apache-drill-0-9-0-release-notes/" + }, "Apache Drill Contribution Guidelines": { "breadcrumbs": [ { @@ -4510,14 +4527,48 @@ } ], "children": [], - "next_title": "Query Data", - "next_url": "/docs/query-data/", + "next_title": "Using Apache Drill with Tibco Spotfire Desktop", + "next_url": "/docs/using-apache-drill-with-tibco-spotfire-desktop/", "parent": "ODBC/JDBC Interfaces", "previous_title": "Using Drill Explorer on Windows", "previous_url": "/docs/using-drill-explorer-on-windows/", "relative_path": "_docs/odbc-jdbc-interfaces/050-using-microstrategy-analytics-with-drill.md", "title": "Using MicroStrategy Analytics with Drill", "url": "/docs/using-microstrategy-analytics-with-drill/" + }, + { + "breadcrumbs": [ + { + "title": "ODBC/JDBC Interfaces", + "url": "/docs/odbc-jdbc-interfaces/" + } + ], + "children": [], + "next_title": "Using Apache Drill with Tibco Spotfire Desktop", + "next_url": "/docs/using-apache-drill-with-tibco-spotfire-desktop/", + "parent": "ODBC/JDBC Interfaces", + "previous_title": "Using MicroStrategy Analytics with Drill", + "previous_url": "/docs/using-microstrategy-analytics-with-drill/", + "relative_path": "_docs/odbc-jdbc-interfaces/060-using-apache-drill-with-tibco-spotfire-desktop.md", + "title": "Using Apache Drill with Tibco Spotfire Desktop", + "url": "/docs/using-apache-drill-with-tibco-spotfire-desktop/" + }, + { + "breadcrumbs": [ + { + "title": "ODBC/JDBC Interfaces", + "url": "/docs/odbc-jdbc-interfaces/" + } + ], + "children": [], + "next_title": "Query Data", + "next_url": "/docs/query-data/", + "parent": "ODBC/JDBC Interfaces", + "previous_title": "Using Apache Drill with Tibco Spotfire Desktop", + "previous_url": "/docs/using-apache-drill-with-tibco-spotfire-desktop/", + "relative_path": "_docs/odbc-jdbc-interfaces/060-using-spotfire.md", + "title": "Using Apache Drill with Tibco Spotfire Desktop", + "url": "/docs/using-apache-drill-with-tibco-spotfire-desktop/" } ], "next_title": "Interfaces Introduction", @@ -5082,8 +5133,8 @@ "next_title": "Query Data Introduction", "next_url": "/docs/query-data-introduction/", "parent": "", - "previous_title": "Using MicroStrategy Analytics with Drill", - "previous_url": "/docs/using-microstrategy-analytics-with-drill/", + "previous_title": "Using Apache Drill with Tibco Spotfire Desktop", + "previous_url": "/docs/using-apache-drill-with-tibco-spotfire-desktop/", "relative_path": "_docs/070-query-data.md", "title": "Query Data", "url": "/docs/query-data/" @@ -5780,14 +5831,31 @@ } ], "children": [], - "next_title": "Sample Datasets", - "next_url": "/docs/sample-datasets/", + "next_title": "Apache Drill 0.9.0 Release Notes", + "next_url": "/docs/apache-drill-0-9-0-release-notes/", "parent": "Release Notes", "previous_title": "Apache Drill 0.7.0 Release Notes", "previous_url": "/docs/apache-drill-0-7-0-release-notes/", "relative_path": "_docs/rn/060-0.8.0-rn.md", "title": "Apache Drill 0.8.0 Release Notes", "url": "/docs/apache-drill-0-8-0-release-notes/" + }, + { + "breadcrumbs": [ + { + "title": "Release Notes", + "url": "/docs/release-notes/" + } + ], + "children": [], + "next_title": "Sample Datasets", + "next_url": "/docs/sample-datasets/", + "parent": "Release Notes", + "previous_title": "Apache Drill 0.8.0 Release Notes", + "previous_url": "/docs/apache-drill-0-8-0-release-notes/", + "relative_path": "_docs/rn/070-0.9.0-rn.md", + "title": "Apache Drill 0.9.0 Release Notes", + "url": "/docs/apache-drill-0-9-0-release-notes/" } ], "next_title": "Apache Drill 0.5.0 Release Notes", @@ -7280,8 +7348,8 @@ "next_title": "AOL Search", "next_url": "/docs/aol-search/", "parent": "", - "previous_title": "Apache Drill 0.8.0 Release Notes", - "previous_url": "/docs/apache-drill-0-8-0-release-notes/", + "previous_title": "Apache Drill 0.9.0 Release Notes", + "previous_url": "/docs/apache-drill-0-9-0-release-notes/", "relative_path": "_docs/140-sample-datasets.md", "title": "Sample Datasets", "url": "/docs/sample-datasets/" @@ -8042,6 +8110,23 @@ "title": "Useful Research", "url": "/docs/useful-research/" }, + "Using Apache Drill with Tibco Spotfire Desktop": { + "breadcrumbs": [ + { + "title": "ODBC/JDBC Interfaces", + "url": "/docs/odbc-jdbc-interfaces/" + } + ], + "children": [], + "next_title": "Query Data", + "next_url": "/docs/query-data/", + "parent": "ODBC/JDBC Interfaces", + "previous_title": "Using Apache Drill with Tibco Spotfire Desktop", + "previous_url": "/docs/using-apache-drill-with-tibco-spotfire-desktop/", + "relative_path": "_docs/odbc-jdbc-interfaces/060-using-spotfire.md", + "title": "Using Apache Drill with Tibco Spotfire Desktop", + "url": "/docs/using-apache-drill-with-tibco-spotfire-desktop/" + }, "Using Custom Functions in Queries": { "breadcrumbs": [ { @@ -8105,8 +8190,8 @@ } ], "children": [], - "next_title": "Query Data", - "next_url": "/docs/query-data/", + "next_title": "Using Apache Drill with Tibco Spotfire Desktop", + "next_url": "/docs/using-apache-drill-with-tibco-spotfire-desktop/", "parent": "ODBC/JDBC Interfaces", "previous_title": "Using Drill Explorer on Windows", "previous_url": "/docs/using-drill-explorer-on-windows/", @@ -9773,14 +9858,48 @@ } ], "children": [], - "next_title": "Query Data", - "next_url": "/docs/query-data/", + "next_title": "Using Apache Drill with Tibco Spotfire Desktop", + "next_url": "/docs/using-apache-drill-with-tibco-spotfire-desktop/", "parent": "ODBC/JDBC Interfaces", "previous_title": "Using Drill Explorer on Windows", "previous_url": "/docs/using-drill-explorer-on-windows/", "relative_path": "_docs/odbc-jdbc-interfaces/050-using-microstrategy-analytics-with-drill.md", "title": "Using MicroStrategy Analytics with Drill", "url": "/docs/using-microstrategy-analytics-with-drill/" + }, + { + "breadcrumbs": [ + { + "title": "ODBC/JDBC Interfaces", + "url": "/docs/odbc-jdbc-interfaces/" + } + ], + "children": [], + "next_title": "Using Apache Drill with Tibco Spotfire Desktop", + "next_url": "/docs/using-apache-drill-with-tibco-spotfire-desktop/", + "parent": "ODBC/JDBC Interfaces", + "previous_title": "Using MicroStrategy Analytics with Drill", + "previous_url": "/docs/using-microstrategy-analytics-with-drill/", + "relative_path": "_docs/odbc-jdbc-interfaces/060-using-apache-drill-with-tibco-spotfire-desktop.md", + "title": "Using Apache Drill with Tibco Spotfire Desktop", + "url": "/docs/using-apache-drill-with-tibco-spotfire-desktop/" + }, + { + "breadcrumbs": [ + { + "title": "ODBC/JDBC Interfaces", + "url": "/docs/odbc-jdbc-interfaces/" + } + ], + "children": [], + "next_title": "Query Data", + "next_url": "/docs/query-data/", + "parent": "ODBC/JDBC Interfaces", + "previous_title": "Using Apache Drill with Tibco Spotfire Desktop", + "previous_url": "/docs/using-apache-drill-with-tibco-spotfire-desktop/", + "relative_path": "_docs/odbc-jdbc-interfaces/060-using-spotfire.md", + "title": "Using Apache Drill with Tibco Spotfire Desktop", + "url": "/docs/using-apache-drill-with-tibco-spotfire-desktop/" } ], "next_title": "Interfaces Introduction", @@ -10151,8 +10270,8 @@ "next_title": "Query Data Introduction", "next_url": "/docs/query-data-introduction/", "parent": "", - "previous_title": "Using MicroStrategy Analytics with Drill", - "previous_url": "/docs/using-microstrategy-analytics-with-drill/", + "previous_title": "Using Apache Drill with Tibco Spotfire Desktop", + "previous_url": "/docs/using-apache-drill-with-tibco-spotfire-desktop/", "relative_path": "_docs/070-query-data.md", "title": "Query Data", "url": "/docs/query-data/" @@ -11830,14 +11949,31 @@ } ], "children": [], - "next_title": "Sample Datasets", - "next_url": "/docs/sample-datasets/", + "next_title": "Apache Drill 0.9.0 Release Notes", + "next_url": "/docs/apache-drill-0-9-0-release-notes/", "parent": "Release Notes", "previous_title": "Apache Drill 0.7.0 Release Notes", "previous_url": "/docs/apache-drill-0-7-0-release-notes/", "relative_path": "_docs/rn/060-0.8.0-rn.md", "title": "Apache Drill 0.8.0 Release Notes", "url": "/docs/apache-drill-0-8-0-release-notes/" + }, + { + "breadcrumbs": [ + { + "title": "Release Notes", + "url": "/docs/release-notes/" + } + ], + "children": [], + "next_title": "Sample Datasets", + "next_url": "/docs/sample-datasets/", + "parent": "Release Notes", + "previous_title": "Apache Drill 0.8.0 Release Notes", + "previous_url": "/docs/apache-drill-0-8-0-release-notes/", + "relative_path": "_docs/rn/070-0.9.0-rn.md", + "title": "Apache Drill 0.9.0 Release Notes", + "url": "/docs/apache-drill-0-9-0-release-notes/" } ], "next_title": "Apache Drill 0.5.0 Release Notes", @@ -11907,8 +12043,8 @@ "next_title": "AOL Search", "next_url": "/docs/aol-search/", "parent": "", - "previous_title": "Apache Drill 0.8.0 Release Notes", - "previous_url": "/docs/apache-drill-0-8-0-release-notes/", + "previous_title": "Apache Drill 0.9.0 Release Notes", + "previous_url": "/docs/apache-drill-0-9-0-release-notes/", "relative_path": "_docs/140-sample-datasets.md", "title": "Sample Datasets", "url": "/docs/sample-datasets/" http://git-wip-us.apache.org/repos/asf/drill/blob/288ac7dc/_docs/img/spotfire_1.png ---------------------------------------------------------------------- diff --git a/_docs/img/spotfire_1.png b/_docs/img/spotfire_1.png new file mode 100755 index 0000000..6faf91c Binary files /dev/null and b/_docs/img/spotfire_1.png differ http://git-wip-us.apache.org/repos/asf/drill/blob/288ac7dc/_docs/img/spotfire_2.png ---------------------------------------------------------------------- diff --git a/_docs/img/spotfire_2.png b/_docs/img/spotfire_2.png new file mode 100755 index 0000000..232f4fc Binary files /dev/null and b/_docs/img/spotfire_2.png differ http://git-wip-us.apache.org/repos/asf/drill/blob/288ac7dc/_docs/img/spotfire_3.png ---------------------------------------------------------------------- diff --git a/_docs/img/spotfire_3.png b/_docs/img/spotfire_3.png new file mode 100755 index 0000000..c04706a Binary files /dev/null and b/_docs/img/spotfire_3.png differ http://git-wip-us.apache.org/repos/asf/drill/blob/288ac7dc/_docs/img/spotfire_4.png ---------------------------------------------------------------------- diff --git a/_docs/img/spotfire_4.png b/_docs/img/spotfire_4.png new file mode 100755 index 0000000..cdf7458 Binary files /dev/null and b/_docs/img/spotfire_4.png differ http://git-wip-us.apache.org/repos/asf/drill/blob/288ac7dc/_docs/img/spotfire_5.png ---------------------------------------------------------------------- diff --git a/_docs/img/spotfire_5.png b/_docs/img/spotfire_5.png new file mode 100755 index 0000000..0c30d0f Binary files /dev/null and b/_docs/img/spotfire_5.png differ http://git-wip-us.apache.org/repos/asf/drill/blob/288ac7dc/_docs/img/spotfire_6.png ---------------------------------------------------------------------- diff --git a/_docs/img/spotfire_6.png b/_docs/img/spotfire_6.png new file mode 100755 index 0000000..f8d61c8 Binary files /dev/null and b/_docs/img/spotfire_6.png differ http://git-wip-us.apache.org/repos/asf/drill/blob/288ac7dc/_docs/odbc-jdbc-interfaces/020-using-jdbc.md ---------------------------------------------------------------------- diff --git a/_docs/odbc-jdbc-interfaces/020-using-jdbc.md b/_docs/odbc-jdbc-interfaces/020-using-jdbc.md old mode 100644 new mode 100755 index 294452a..af377b8 --- a/_docs/odbc-jdbc-interfaces/020-using-jdbc.md +++ b/_docs/odbc-jdbc-interfaces/020-using-jdbc.md @@ -27,16 +27,15 @@ You can copy the Drill JDBC `JAR` file from the following Drill installation directory on the node with Drill installed, to a directory on your Windows machine: - <drill_installation_directory>/jars/jdbc-driver/drill-jdbc-all-0.7.0-SNAPSHOT.jar + <drill_installation_directory>/jars/jdbc-driver/drill-jdbc-all-<version>.jar Or, you can download the [apache- -drill-0.7.0.tar.gz](http://www.apache.org/dyn/closer.cgi/drill/drill-0.7.0 -/apache-drill-0.7.0.tar.gz) file to a location on your Windows machine, and +drill-0.9.0.tar.gz](http://apache.osuosl.org/drill/drill-0.9.0/apache-drill-0.9.0-src.tar.gz) file to a location on your Windows machine, and extract the contents of the file. You may need to use a decompression utility, such as [7-zip](http://www.7-zip.org/) to extract the archive. Once extracted, you can locate the driver in the following directory: - <windows_directory>\apache-drill-<version>\jars\jdbc-driver\drill-jdbc-all-0.7.0-SNAPSHOT.jar + <windows_directory>\apache-drill-<version>\jars\jdbc-driver\drill-jdbc-all-<version>.jar ---------- http://git-wip-us.apache.org/repos/asf/drill/blob/288ac7dc/_docs/odbc-jdbc-interfaces/050-using-microstrategy-analytics-with-drill.md ---------------------------------------------------------------------- diff --git a/_docs/odbc-jdbc-interfaces/050-using-microstrategy-analytics-with-drill.md b/_docs/odbc-jdbc-interfaces/050-using-microstrategy-analytics-with-drill.md old mode 100644 new mode 100755 index 3c9dcaa..95b847a --- a/_docs/odbc-jdbc-interfaces/050-using-microstrategy-analytics-with-drill.md +++ b/_docs/odbc-jdbc-interfaces/050-using-microstrategy-analytics-with-drill.md @@ -16,17 +16,13 @@ Complete the following steps to use Apache Drill with MicroStrategy Analytics En ### Step 1: Install and Configure the MapR Drill ODBC Driver -Drill uses standard ODBC connectivity to provide you with easy data exploration capabilities on complex, schema-less data sets. Verify that the ODBC driver version is compatible with the Apache Drill version that you use. - -Ideally, you should upgrade to Drill 0.7, which uses the v0.07.0.0608 version of the driver. Earlier versions of Drill use the v0.07.0.0600 ODBC driver version located at: - -http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v0.07.0.0600/ +Drill uses standard ODBC connectivity to provide easy data exploration capabilities on complex, schema-less data sets. Verify that the ODBC driver version that you download correlates with the Apache Drill version that you use. Ideally, you should upgrade to the latest version of Apache Drill and the MapR Drill ODBC Driver. Complete the following steps to install and configure the driver: 1. Download the driver from the following location: - http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v0.07.0.0608/MapRDrillODBC32.msi + http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/ {% include startnote.html %}Use the 32-bit Windows driver for MicroStrategy 9.4.1.{% include endnote.html %} @@ -41,8 +37,7 @@ Complete the following steps to install and configure the driver: a. Verify the version number of the driver. -  - + b. Click Test to verify that the ODBC configuration works before using it with MicroStrategy.  http://git-wip-us.apache.org/repos/asf/drill/blob/288ac7dc/_docs/odbc-jdbc-interfaces/060-using-apache-drill-with-tibco-spotfire-desktop.md ---------------------------------------------------------------------- diff --git a/_docs/odbc-jdbc-interfaces/060-using-apache-drill-with-tibco-spotfire-desktop.md b/_docs/odbc-jdbc-interfaces/060-using-apache-drill-with-tibco-spotfire-desktop.md new file mode 100755 index 0000000..a559c71 --- /dev/null +++ b/_docs/odbc-jdbc-interfaces/060-using-apache-drill-with-tibco-spotfire-desktop.md @@ -0,0 +1,50 @@ +--- +title: "Using Apache Drill with Tibco Spotfire Desktop" +parent: "ODBC/JDBC Interfaces" +--- +Tibco Spotfire Desktop is a powerful analytic tool that enables SQL statements when connecting to data sources. Spotfire Desktop can utilize the powerful query capabilities of Apache Drill to query complex data structures. Use the MapR Drill ODBC Driver to configure Tibco Spotfire Desktop with Apache Drill. + +To use Spotfire Desktop with Apache Drill, complete the following steps: + +1. Install the Drill ODBC Driver from MapR. +2. Configure the Spotfire Desktop data connection for Drill. + +---------- + + +### Step 1: Install and Configure the MapR Drill ODBC Driver + +Drill uses standard ODBC connectivity to provide easy data exploration capabilities on complex, schema-less data sets. Verify that the ODBC driver version that you download correlates with the Apache Drill version that you use. Ideally, you should upgrade to the latest version of Apache Drill and the MapR Drill ODBC Driver. + +Complete the following steps to install and configure the driver: + +1. Download the 64-bit MapR Drill ODBC Driver for Windows from the following location:<br> [http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/) +**Note:** Spotfire Desktop 6.5.1 utilizes the 64-bit ODBC driver. +2. Complete steps 2-8 under on the following page to install the driver:<br> +[http://drill.apache.org/docs/step-1-install-the-mapr-drill-odbc-driver-on-windows/](http://drill.apache.org/docs/step-1-install-the-mapr-drill-odbc-driver-on-windows/) +3. Complete the steps on the following page to configure the driver:<br> +[http://drill.apache.org/docs/step-2-configure-odbc-connections-to-drill-data-sources/](http://drill.apache.org/docs/step-2-configure-odbc-connections-to-drill-data-sources/) + +---------- + + +### Step 2: Configure the Spotfire Desktop Data Connection for Drill +Complete the following steps to configure a Drill data connection: + +1. Select the **Add Data Connection** option or click the Add Data Connection button in the menu bar, as shown in the image below: +2. When the dialog window appears, click the **Add** button, and select **Other/Database** from the dropdown list. +3. In the Open Database window that appears, select **Odbc Data Provider** and then click **Configure**.  +4. In the Configure Data Source Connection window that appears, select the Drill DSN that you configured in the ODBC administrator, and enter the relevant credentials for Drill.<br>  +5. Click **OK** to continue. The Spotfire Desktop queries the Drill metadata for available schemas, tables, and views. You can navigate the schemas in the left-hand column. After you select a specific view or table, the relevant SQL displays in the right-hand column. + +6. Optionally, you can modify the SQL to work best with Drill. Simply change the schema.table.* notation in the SELECT statement to simply * or the relevant column names that are needed. +Note that Drill has certain reserved keywords that you must put in back ticks [ ` ] when needed. See [Drill Reserved Keywords](http://drill.apache.org/docs/reserved-keywords/). +7. Once the SQL is complete, provide a name for the Data Source and click **OK**. Spotfire Desktop queries Drill and retrieves the data for analysis. You can use the functionality of Spotfire Desktop to work with the data. + + +**NOTE:** You can use the SQL statement column to query data and complex structures that do not display in the left-hand schema column. A good example is JSON files in the file system. + +**SQL Example:**<br> +SELECT t.trans_id, t.`date`, t.user_info.cust_id as cust_id, t.user_info.device as device FROM dfs.clicks.`/clicks/clicks.campaign.json` t + +---------- http://git-wip-us.apache.org/repos/asf/drill/blob/288ac7dc/_docs/odbc-jdbc-interfaces/060-using-spotfire.md ---------------------------------------------------------------------- diff --git a/_docs/odbc-jdbc-interfaces/060-using-spotfire.md b/_docs/odbc-jdbc-interfaces/060-using-spotfire.md new file mode 100644 index 0000000..d59c3c1 --- /dev/null +++ b/_docs/odbc-jdbc-interfaces/060-using-spotfire.md @@ -0,0 +1,50 @@ +--- +title: "Using Apache Drill with Tibco Spotfire Desktop" +parent: "ODBC/JDBC Interfaces" +--- +Tibco Spotfire Desktop is a powerful analytic tool that enables SQL statements when connecting to data sources. Spotfire Desktop can utilize the powerful query capabilities of Apache Drill to query complex data structures. Use the MapR Drill ODBC Driver to configure Tibco Spotfire Desktop with Apache Drill. + +To use Spotfire Desktop with Apache Drill, complete the following steps: + +1. Install the Drill ODBC Driver from MapR. +2. Configure the Spotfire Desktop data connection for Drill. + +---------- + + +### Step 1: Install and Configure the MapR Drill ODBC Driver + +Drill uses standard ODBC connectivity to provide easy data exploration capabilities on complex, schema-less data sets. Verify that the ODBC driver version that you download correlates with the Apache Drill version that you use. Ideally, you should upgrade to the latest version of Apache Drill and the MapR Drill ODBC Driver. + +Complete the following steps to install and configure the driver: + +1. Download the 64-bit MapR Drill ODBC Driver for Windows from the following location:<br> [http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/) +**Note:** Spotfire Desktop 6.5.1 utilizes the 64-bit ODBC driver. +2. Complete steps 2-8 under on the following page to install the driver:<br> +[http://drill.apache.org/docs/step-1-install-the-mapr-drill-odbc-driver-on-windows/](http://drill.apache.org/docs/step-1-install-the-mapr-drill-odbc-driver-on-windows/) +3. Complete the steps on the following page to configure the driver:<br> +[http://drill.apache.org/docs/step-2-configure-odbc-connections-to-drill-data-sources/](http://drill.apache.org/docs/step-2-configure-odbc-connections-to-drill-data-sources/) + +---------- + + +### Step 2: Configure the Spotfire Desktop Data Connection for Drill +Complete the following steps to configure a Drill data connection: + +1. Select the **Add Data Connection** option or click the Add Data Connection button in the menu bar, as shown in the image below: +2. When the dialog window appears, click the **Add** button, and select **Other/Database** from the dropdown list. +3. In the Open Database window that appears, select **Odbc Data Provider** and then click **Configure**.  +4. In the Configure Data Source Connection window that appears, select the Drill DSN that you configured in the ODBC administrator, and enter the relevant credentials for Drill.<br>  +5. Click **OK** to continue. The Spotfire Desktop queries the Drill metadata for available schemas, tables, and views. You can navigate the schemas in the left-hand column. After you select a specific view or table, the relevant SQL displays in the right-hand column. +![]{{site.baseurl}}/docs/img/spotfire_5.png) +6. Optionally, you can modify the SQL to work best with Drill. Simply change the schema.table.* notation in the SELECT statement to simply * or the relevant column names that are needed. +Note that Drill has certain reserved keywords that you must put in back ticks [ ` ] when needed. See [Drill Reserved Keywords](http://drill.apache.org/docs/reserved-keywords/). +7. Once the SQL is complete, provide a name for the Data Source and click **OK**. Spotfire Desktop queries Drill and retrieves the data for analysis. You can use the functionality of Spotfire Desktop to work with the data. + + +**NOTE:** You can use the SQL statement column to query data and complex structures that do not display in the left-hand schema column. A good example is JSON files in the file system. + +**SQL Example:**<br> +SELECT t.trans_id, t.`date`, t.user_info.cust_id as cust_id, t.user_info.device as device FROM dfs.clicks.`/clicks/clicks.campaign.json` t + +---------- http://git-wip-us.apache.org/repos/asf/drill/blob/288ac7dc/_docs/odbc-jdbc-interfaces/using-odbc-on-linux-and-mac-os-x/010-installing-the-driver-on-linux.md ---------------------------------------------------------------------- diff --git a/_docs/odbc-jdbc-interfaces/using-odbc-on-linux-and-mac-os-x/010-installing-the-driver-on-linux.md b/_docs/odbc-jdbc-interfaces/using-odbc-on-linux-and-mac-os-x/010-installing-the-driver-on-linux.md index 921dd3b..efb994c 100755 --- a/_docs/odbc-jdbc-interfaces/using-odbc-on-linux-and-mac-os-x/010-installing-the-driver-on-linux.md +++ b/_docs/odbc-jdbc-interfaces/using-odbc-on-linux-and-mac-os-x/010-installing-the-driver-on-linux.md @@ -42,8 +42,8 @@ To install the driver, you need Administrator privileges on the computer. Click on a link below to download the driver: - * [MapR Drill ODBC Driver (32-bit)](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v0.08.1.0618/MapRDrillODBC-32bit-0.08.1.i686_DriverOnly.rpm) - * [MapR Drill ODBC Driver (64-bit)](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v0.08.1.0618/MapRDrillODBC-0.08.1.x86_64_DriverOnly.rpm) + * [MapR Drill ODBC Driver (32-bit)](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v0.09.0.0620/MapRDrillODBC-32bit-0.09.0.i686.rpm) + * [MapR Drill ODBC Driver (64-bit)](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v0.09.0.0620/MapRDrillODBC-0.09.0.x86_64.rpm) ## Step 2: Installing the MapR Drill ODBC Driver http://git-wip-us.apache.org/repos/asf/drill/blob/288ac7dc/_docs/odbc-jdbc-interfaces/using-odbc-on-linux-and-mac-os-x/020-installing-the-driver-on-mac-os-x.md ---------------------------------------------------------------------- diff --git a/_docs/odbc-jdbc-interfaces/using-odbc-on-linux-and-mac-os-x/020-installing-the-driver-on-mac-os-x.md b/_docs/odbc-jdbc-interfaces/using-odbc-on-linux-and-mac-os-x/020-installing-the-driver-on-mac-os-x.md index efc9ae7..377cb7d 100755 --- a/_docs/odbc-jdbc-interfaces/using-odbc-on-linux-and-mac-os-x/020-installing-the-driver-on-mac-os-x.md +++ b/_docs/odbc-jdbc-interfaces/using-odbc-on-linux-and-mac-os-x/020-installing-the-driver-on-mac-os-x.md @@ -35,7 +35,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_v0.08.1.0618/MapRDrillODBC_DriverOnly.dmg) +[MapR Drill ODBC Driver for Mac](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v0.09.0.0620/MapRDrillODBC.dmg) ---------- http://git-wip-us.apache.org/repos/asf/drill/blob/288ac7dc/_docs/odbc-jdbc-interfaces/using-odbc-on-windows/010-installing-the-driver-on-windows.md ---------------------------------------------------------------------- diff --git a/_docs/odbc-jdbc-interfaces/using-odbc-on-windows/010-installing-the-driver-on-windows.md b/_docs/odbc-jdbc-interfaces/using-odbc-on-windows/010-installing-the-driver-on-windows.md index 5d4319f..8a52539 100755 --- a/_docs/odbc-jdbc-interfaces/using-odbc-on-windows/010-installing-the-driver-on-windows.md +++ b/_docs/odbc-jdbc-interfaces/using-odbc-on-windows/010-installing-the-driver-on-windows.md @@ -27,8 +27,8 @@ To install the driver, you need Administrator privileges on the computer. ## Installing the Driver 1. 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_v0.08.1.0618/MapRDrillODBC32.msi) - * [MapR Drill ODBC Driver (64-bit)](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v0.08.1.0618/MapRDrillODBC64.msi) + * [MapR Drill ODBC Driver (32-bit)](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v0.09.0.0620/MapRDrillODBC32.msi) + * [MapR Drill ODBC Driver (64-bit)](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v0.09.0.0620/MapRDrillODBC64.msi) 2. Double-click the installer from the location where you downloaded it. 3. Click **Next.** 4. Select the check box to accept the terms of the License Agreement and click **Next**. http://git-wip-us.apache.org/repos/asf/drill/blob/288ac7dc/_docs/rn/070-0.9.0-rn.md ---------------------------------------------------------------------- diff --git a/_docs/rn/070-0.9.0-rn.md b/_docs/rn/070-0.9.0-rn.md new file mode 100755 index 0000000..edae5c8 --- /dev/null +++ b/_docs/rn/070-0.9.0-rn.md @@ -0,0 +1,29 @@ +--- +title: "Apache Drill 0.9.0 Release Notes" +parent: "Release Notes" +--- +It has been about a month since the release of Drill 0.8, which included [more than 240 improvements]({{ site.baseurl }}/blog/drill-0.8-released/). Today we're happy to announce the availability of Drill 0.9, providing additional enhancements and bug fixes. In fact, this release includes [200 resolved JIRAs](https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12313820&version=12328813). Some of the noteworthy features in Drill 0.9 are: + +* **Authentication** ([DRILL-2674](https://issues.apache.org/jira/browse/DRILL-2674)). Drill now supports username/password authentication through the Java and C++ clients, as well as JDBC and ODBC. On the server-side, Drill leverages Linux PAM to securely validate the credentials. Users can choose to use an external user directory such as Active Directory or LDAP. To enable authentication, set the `security.user.auth` option in `drill-override.conf`. +* **Impersonation** ([DRILL-2363](https://issues.apache.org/jira/browse/DRILL-2363)). Queries now execute and access resources using the identity of the user who submitted the query. Previously, all queries would run as the same user (eg, `drill`). With the new impersonation capability, the query will fail if the submitting user does not have permission to read the requested file(s) in the distributed file system. To enable impersonation, set the `drill.exec.impersonation` option in `drill-override.conf`. +* **Ownership chaining**. Drill now allows views with different owners to be chained. This represents a very flexible access control solution. For example, an administrator with access to raw, sensitive data could create a view called `masked` which would expose only a subset of the data to other users. The administrator would enable users to read the `masked` view but not the raw data. Note that Drill provides an option `max_chained_user_hops` that specifies how many ownership changed are allowed in a chain, thereby providing administrators (or data stewards) more control over sharing of data. +* **MongoDB authentication** ([DRILL-1502](https://issues.apache.org/jira/browse/DRILL-1502)). Drill can now connect to a MongoDB cluster that requires authentication. +* **Extended JSON datatypes**. Our friends at MongoDB invented [extended JSON](http://docs.mongodb.org/manual/reference/mongodb-extended-json/) - a set of extensions to the JSON format for supporting additional data types. We decided to embrace extended JSON in Drill. For example, standard JSON doesn't have a time type, so a time could be represented as either a string or a number: `{"foo": "19:20:30.450Z"}` is just a string. With extended JSON, the `$time` qualifier can be used to specify that `foo` is a time `{"foo": {"$time": "19:20:30.450Z"}}`. + We now support a number of qualifiers including `$bin`, `$date`, `$time`, `$interval`, `$numberLong` and `$dateDay` (see [the example](https://github.com/apache/drill/blob/master/exec/java-exec/src/test/resources/vector/complex/extended.json)). We're in the process of adding some additional qualifiers to make sure that all of MongoDB's extended types are supported (this is particularly important when querying data in MongoDB). +* **Avro support** ([DRILL-1512](https://issues.apache.org/jira/browse/DRILL-1512)). Drill can now read Avro files. This patch was contributed by Andrew Selden at Elastic.co (formerly known as Elasticsearch). +* **Improved error messages** ([DRILL-2675](https://issues.apache.org/jira/browse/DRILL-2675) and more). It can be challenging for a complex distributed system like Drill to translate low-level internal conditions into actionable messages to the user. This release includes several enhancements that enable Drill to accomplish just that in a variety of cases. +* **Parquet and Calcite enhancements** ([DRILL-1410](https://issues.apache.org/jira/browse/DRILL-1410) and [DRILL-1384](https://issues.apache.org/jira/browse/DRILL-1384)). Drill isn't a traditional query engine - it's the first analytical query engine with a JSON data model. This has required us to enhance Parquet (our columnar format) and Calcite (our SQL parser). These enhancements have now been contributed back to those projects, and Drill is using the latest versions which include these enhancements. +* **New sys tables for memory and thread information** ([DRILL-2275](https://issues.apache.org/jira/browse/DRILL-2275)). Drill includes two new `sys` tables that provide real-time metrics about memory utilization and threads on each of the nodes in the cluster. You can run a simple `SELECT *` to see what information is available: + + ```sql + SELECT * FROM sys.drillmemory; + SELECT * FROM sys.drillbitthreads; + ``` + +* **Support for very wide tables** ([DRILL-2739](https://issues.apache.org/jira/browse/DRILL-2739)). Drill previously had some issues with tables that had more than 4095 colums. This limitation has been addressed. + +You can now [download Drill 0.9]({{ site.baseurl }}/download/). As always, you can check out the official [release notes]({{ site.baseurl }}/docs/release-notes/) for more details. + +We're gearing up for Drill's 1.0 release later this month. Stay tuned! + +
