You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by br...@apache.org on 2017/03/31 00:02:20 UTC
[2/2] drill git commit: edit tableau 10.2
edit tableau 10.2
Project: http://git-wip-us.apache.org/repos/asf/drill/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/1449b523
Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/1449b523
Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/1449b523
Branch: refs/heads/gh-pages
Commit: 1449b5235a0e3c9b948c2d5da7a08a62510bc197
Parents: eaf2f69
Author: Bridget Bevens <bb...@maprtech.com>
Authored: Thu Mar 30 16:49:57 2017 -0700
Committer: Bridget Bevens <bb...@maprtech.com>
Committed: Thu Mar 30 16:49:57 2017 -0700
----------------------------------------------------------------------
_data/docs.json | 116 +++++++++--
.../059-using-apache-drill-with-tableau-10.2.md | 201 ++++++++++---------
2 files changed, 208 insertions(+), 109 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/drill/blob/1449b523/_data/docs.json
----------------------------------------------------------------------
diff --git a/_data/docs.json b/_data/docs.json
index ce27026..9944ffc 100644
--- a/_data/docs.json
+++ b/_data/docs.json
@@ -6292,8 +6292,8 @@
}
],
"children": [],
- "next_title": "Using Apache Drill with Tableau 9 Desktop",
- "next_url": "/docs/using-apache-drill-with-tableau-9-desktop/",
+ "next_title": "Using Apache Drill with Tableau 10.2",
+ "next_url": "/docs/using-apache-drill-with-tableau-10-2/",
"parent": "Using Drill with BI Tools",
"previous_title": "Configuring Tibco Spotfire Server with Drill",
"previous_url": "/docs/configuring-tibco-spotfire-server-with-drill/",
@@ -6313,11 +6313,32 @@
}
],
"children": [],
- "next_title": "Using Apache Drill with Tableau 9 Server",
- "next_url": "/docs/using-apache-drill-with-tableau-9-server/",
+ "next_title": "Using Apache Drill with Tableau 9 Desktop",
+ "next_url": "/docs/using-apache-drill-with-tableau-9-desktop/",
"parent": "Using Drill with BI Tools",
"previous_title": "Using Qlik Sense with Drill",
"previous_url": "/docs/using-qlik-sense-with-drill/",
+ "relative_path": "_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/059-using-apache-drill-with-tableau-10.2.md",
+ "title": "Using Apache Drill with Tableau 10.2",
+ "url": "/docs/using-apache-drill-with-tableau-10-2/"
+ },
+ {
+ "breadcrumbs": [
+ {
+ "title": "Using Drill with BI Tools",
+ "url": "/docs/using-drill-with-bi-tools/"
+ },
+ {
+ "title": "ODBC/JDBC Interfaces",
+ "url": "/docs/odbc-jdbc-interfaces/"
+ }
+ ],
+ "children": [],
+ "next_title": "Using Apache Drill with Tableau 9 Server",
+ "next_url": "/docs/using-apache-drill-with-tableau-9-server/",
+ "parent": "Using Drill with BI Tools",
+ "previous_title": "Using Apache Drill with Tableau 10.2",
+ "previous_url": "/docs/using-apache-drill-with-tableau-10-2/",
"relative_path": "_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/060-using-apache-drill-with-tableau-9-desktop.md",
"title": "Using Apache Drill with Tableau 9 Desktop",
"url": "/docs/using-apache-drill-with-tableau-9-desktop/"
@@ -12754,6 +12775,27 @@
"title": "Useful Research",
"url": "/docs/useful-research/"
},
+ "Using Apache Drill with Tableau 10.2": {
+ "breadcrumbs": [
+ {
+ "title": "Using Drill with BI Tools",
+ "url": "/docs/using-drill-with-bi-tools/"
+ },
+ {
+ "title": "ODBC/JDBC Interfaces",
+ "url": "/docs/odbc-jdbc-interfaces/"
+ }
+ ],
+ "children": [],
+ "next_title": "Using Apache Drill with Tableau 9 Desktop",
+ "next_url": "/docs/using-apache-drill-with-tableau-9-desktop/",
+ "parent": "Using Drill with BI Tools",
+ "previous_title": "Using Qlik Sense with Drill",
+ "previous_url": "/docs/using-qlik-sense-with-drill/",
+ "relative_path": "_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/059-using-apache-drill-with-tableau-10.2.md",
+ "title": "Using Apache Drill with Tableau 10.2",
+ "url": "/docs/using-apache-drill-with-tableau-10-2/"
+ },
"Using Apache Drill with Tableau 9 Desktop": {
"breadcrumbs": [
{
@@ -12769,8 +12811,8 @@
"next_title": "Using Apache Drill with Tableau 9 Server",
"next_url": "/docs/using-apache-drill-with-tableau-9-server/",
"parent": "Using Drill with BI Tools",
- "previous_title": "Using Qlik Sense with Drill",
- "previous_url": "/docs/using-qlik-sense-with-drill/",
+ "previous_title": "Using Apache Drill with Tableau 10.2",
+ "previous_url": "/docs/using-apache-drill-with-tableau-10-2/",
"relative_path": "_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/060-using-apache-drill-with-tableau-9-desktop.md",
"title": "Using Apache Drill with Tableau 9 Desktop",
"url": "/docs/using-apache-drill-with-tableau-9-desktop/"
@@ -13019,8 +13061,8 @@
}
],
"children": [],
- "next_title": "Using Apache Drill with Tableau 9 Desktop",
- "next_url": "/docs/using-apache-drill-with-tableau-9-desktop/",
+ "next_title": "Using Apache Drill with Tableau 10.2",
+ "next_url": "/docs/using-apache-drill-with-tableau-10-2/",
"parent": "Using Drill with BI Tools",
"previous_title": "Configuring Tibco Spotfire Server with Drill",
"previous_url": "/docs/configuring-tibco-spotfire-server-with-drill/",
@@ -13040,11 +13082,32 @@
}
],
"children": [],
- "next_title": "Using Apache Drill with Tableau 9 Server",
- "next_url": "/docs/using-apache-drill-with-tableau-9-server/",
+ "next_title": "Using Apache Drill with Tableau 9 Desktop",
+ "next_url": "/docs/using-apache-drill-with-tableau-9-desktop/",
"parent": "Using Drill with BI Tools",
"previous_title": "Using Qlik Sense with Drill",
"previous_url": "/docs/using-qlik-sense-with-drill/",
+ "relative_path": "_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/059-using-apache-drill-with-tableau-10.2.md",
+ "title": "Using Apache Drill with Tableau 10.2",
+ "url": "/docs/using-apache-drill-with-tableau-10-2/"
+ },
+ {
+ "breadcrumbs": [
+ {
+ "title": "Using Drill with BI Tools",
+ "url": "/docs/using-drill-with-bi-tools/"
+ },
+ {
+ "title": "ODBC/JDBC Interfaces",
+ "url": "/docs/odbc-jdbc-interfaces/"
+ }
+ ],
+ "children": [],
+ "next_title": "Using Apache Drill with Tableau 9 Server",
+ "next_url": "/docs/using-apache-drill-with-tableau-9-server/",
+ "parent": "Using Drill with BI Tools",
+ "previous_title": "Using Apache Drill with Tableau 10.2",
+ "previous_url": "/docs/using-apache-drill-with-tableau-10-2/",
"relative_path": "_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/060-using-apache-drill-with-tableau-9-desktop.md",
"title": "Using Apache Drill with Tableau 9 Desktop",
"url": "/docs/using-apache-drill-with-tableau-9-desktop/"
@@ -13214,8 +13277,8 @@
}
],
"children": [],
- "next_title": "Using Apache Drill with Tableau 9 Desktop",
- "next_url": "/docs/using-apache-drill-with-tableau-9-desktop/",
+ "next_title": "Using Apache Drill with Tableau 10.2",
+ "next_url": "/docs/using-apache-drill-with-tableau-10-2/",
"parent": "Using Drill with BI Tools",
"previous_title": "Configuring Tibco Spotfire Server with Drill",
"previous_url": "/docs/configuring-tibco-spotfire-server-with-drill/",
@@ -15336,8 +15399,8 @@
}
],
"children": [],
- "next_title": "Using Apache Drill with Tableau 9 Desktop",
- "next_url": "/docs/using-apache-drill-with-tableau-9-desktop/",
+ "next_title": "Using Apache Drill with Tableau 10.2",
+ "next_url": "/docs/using-apache-drill-with-tableau-10-2/",
"parent": "Using Drill with BI Tools",
"previous_title": "Configuring Tibco Spotfire Server with Drill",
"previous_url": "/docs/configuring-tibco-spotfire-server-with-drill/",
@@ -15357,11 +15420,32 @@
}
],
"children": [],
- "next_title": "Using Apache Drill with Tableau 9 Server",
- "next_url": "/docs/using-apache-drill-with-tableau-9-server/",
+ "next_title": "Using Apache Drill with Tableau 9 Desktop",
+ "next_url": "/docs/using-apache-drill-with-tableau-9-desktop/",
"parent": "Using Drill with BI Tools",
"previous_title": "Using Qlik Sense with Drill",
"previous_url": "/docs/using-qlik-sense-with-drill/",
+ "relative_path": "_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/059-using-apache-drill-with-tableau-10.2.md",
+ "title": "Using Apache Drill with Tableau 10.2",
+ "url": "/docs/using-apache-drill-with-tableau-10-2/"
+ },
+ {
+ "breadcrumbs": [
+ {
+ "title": "Using Drill with BI Tools",
+ "url": "/docs/using-drill-with-bi-tools/"
+ },
+ {
+ "title": "ODBC/JDBC Interfaces",
+ "url": "/docs/odbc-jdbc-interfaces/"
+ }
+ ],
+ "children": [],
+ "next_title": "Using Apache Drill with Tableau 9 Server",
+ "next_url": "/docs/using-apache-drill-with-tableau-9-server/",
+ "parent": "Using Drill with BI Tools",
+ "previous_title": "Using Apache Drill with Tableau 10.2",
+ "previous_url": "/docs/using-apache-drill-with-tableau-10-2/",
"relative_path": "_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/060-using-apache-drill-with-tableau-9-desktop.md",
"title": "Using Apache Drill with Tableau 9 Desktop",
"url": "/docs/using-apache-drill-with-tableau-9-desktop/"
http://git-wip-us.apache.org/repos/asf/drill/blob/1449b523/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/059-using-apache-drill-with-tableau-10.2.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/059-using-apache-drill-with-tableau-10.2.md b/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/059-using-apache-drill-with-tableau-10.2.md
index 9aa6489..ca0f285 100644
--- a/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/059-using-apache-drill-with-tableau-10.2.md
+++ b/_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/059-using-apache-drill-with-tableau-10.2.md
@@ -1,93 +1,108 @@
----
-title: "Using Apache Drill with Tableau 10.2"
-date:
-parent: "Using Drill with BI Tools"
----
-
-**Author:** Andries Engelbrecht, Partner Systems Engineer, MapR Technologies
-
----
-
-The powerful combination of Drill and Tableau enables you to easily and directly work with various data formats and sources, elevating data self-service and discovery to a new level.
-
-Drill 1.10 fully supports Tableau level of detail (LoD) calculations and Tableau Sets for an enhanced user experience. Drill can also be used as a data source for Tableau Desktop on Mac, in addition to Tableau Desktop and Tableau Server on Windows.
-
---
-
-This document describes how to connect Tableau 10.2 to Apache Drill and instantly explore multiple data formats from various data sources.
-
-##Prerequisites
-Your system must meet the following prerequisites before you can complete the steps required to connect Tableau 10.2 to Apache Drill:
-
-- Tableau 10.2 or later
-- Apache Drill 1.10 or later
-- MapR Drill ODBC Driver v1.3.0 or later
-
-##Required Steps
-Complete the following steps to use Apache Drill with Tableau 10.2:
-1. [Install and Configure the MapR Drill ODBC Driver.]({{site.baseurl}}/docs/using-apache-drill-with-tableau-10.2)
-2. [Connect Tableau to Drill (using the Apache Drill Data Connector).]({{site.baseurl}}/docs/using-apache-drill-with-tableau-10.2)
-3. [Query and Analyze the Data (various data formats with Tableau and Drill).]({{site.baseurl}}/docs/using-apache-drill-with-tableau-10.2)
-
-
-
-## 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.
-
-To install and configure the ODBC driver, complete the following steps:
-
-1. Download the latest 64-bit MapR Drill ODBC Driver for Mac or Windows at: [http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/)
-2. Refer to the instructions appropriate for your system to install the ODBC driver:
- * [Windows](http://drill.apache.org/docs/installing-the-driver-on-windows/)
- * [Mac](http://drill.apache.org/docs/installing-the-driver-on-mac-os-x/)
-
-**Important:** Verify that the Tableau client system can resolve the hostnames for the Drill and Zookeeper nodes correctly. See the *System Requirements* section of the ODBC [Mac](http://drill.apache.org/docs/installing-the-driver-on-mac-os-x/) or [Windows](http://drill.apache.org/docs/installing-the-driver-on-windows/) installation page for instructions.
-
-
-## Step 2: Connect Tableau to Drill
-
-To connect Tableau to Drill, complete the following steps:
-
-**Note:** The [Tableau documentation](http://onlinehelp.tableau.com/current/pro/desktop/en-us/help.htm#examples_apachedrill.html) provides additional details, if needed.
-
-1. In a Tableau Workbook, click on **Data > New Data Source**.
-2. Select **Apache Drill**. 
-3. Choose whether to connect directly or using ZooKeeper. For production environments, connecting to ZooKeeper is recommended for resiliency and distribution of connection management on the Drill cluster.
-4. Enter the ZooKeeper Quorum/Drill Cluster ID or Drill Direct Server and Port information.
-5. Enter the authentication information.
-6. Click **Sign In**. Tableau connects to Drill and allows you to select various Tables and Views. 
-7. Click on the **Schema** drop-down list to display all available Drill schemas. When you select a schema, Tableau displays available tables or views. You can select the tables and views to build a Tableau Visualization. Additionally, you can use custom SQL by clicking on the **New Custom SQL** option. 
-
-**Note:** Tableau can natively work with Hive tables and Drill views. You can use custom SQL or create a view in Drill to represent the complex data in Drill data sources, such as data in files or HBase/MapR-DB tables, to Tableau. For more information, see [Tableau Examples](http://drill.apache.org/docs/tableau-examples/).
-
-
-##Step 3: Query and Analyze the Data
-
-Tableau can now use Drill to query various data sources and visualize the information, as shown in the following example.
-
-###Example
-A retailer has order data in CSV files on the distributed file system, product data in HBase, and customer data in Hive. The retailer wants to see the average order total by customer for each state (Tableau LoD), as well as the total number of orders and average revenue by customer for the top 5 states by revenue (Tableau Set).
-
-To find this information, the retail business analyst completes the following steps:
-
-1. Creates a LoD calculation for ordertotal by customer id. 
-2. Displays the states and the average revenue by customer for each state. 
-3. Creates a graph with the total revenue by state, ordered by highest revenue.
-4. Drags and selects the top 5 states, right-clicks, and selects Create Set.
-5. Enters a name for the set. 
-6. Creates a table showing the total number of orders and average revenue by customer for the top 5 states by revenue and also shows the number for the states not in the top 5. 
-
-You have completed the tutorial for configuring Tableau 10.2 to work with Apache Drill. For additional support, see
-[https://www.tableau.com/support/drivers](https://www.tableau.com/support/drivers).
-
-
-
-
-
-
-
-
-
-
-
-
+---
+title: "Using Apache Drill with Tableau 10.2"
+date: 2017-03-30 23:49:58 UTC
+parent: "Using Drill with BI Tools"
+---
+
+**Author:** Andries Engelbrecht, Partner Systems Engineer, MapR Technologies
+
+----------
+
+The powerful combination of Drill and Tableau enables you to easily and directly work with various data formats and sources, elevating data self-service and discovery to a new level.
+
+Drill 1.10 fully supports Tableau Level of Detail (LoD) calculations and Tableau Sets for an enhanced user experience. Drill can also be used as a data source for Tableau Desktop on Mac, in addition to Tableau Desktop and Tableau Server on Windows.
+
+----------
+
+
+This document describes how to connect Tableau 10.2 to Apache Drill and instantly explore multiple data formats from various data sources.
+
+----------
+
+###Prerequisites
+
+Your system must meet the following prerequisites before you can complete the steps required to connect Tableau 10.2 to Apache Drill:
+
+- Tableau 10.2 or later
+- Apache Drill 1.10 or later
+- MapR Drill ODBC Driver v1.3.0 or later
+
+----------
+
+###Required Steps
+
+Complete the following steps to use Apache Drill with Tableau 10.2:
+1. [Install and Configure the MapR Drill ODBC Driver.]({{site.baseurl}}/docs/using-apache-drill-with-tableau-10.2)
+2. [Connect Tableau to Drill (using the Apache Drill Data Connector).]({{site.baseurl}}/docs/using-apache-drill-with-tableau-10.2)
+3. [Query and Analyze the Data (various data formats with Tableau and Drill).]({{site.baseurl}}/docs/using-apache-drill-with-tableau-10.2)
+
+----------
+
+
+
+### 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.
+
+To install and configure the ODBC driver, complete the following steps:
+
+1. Download the latest 64-bit MapR Drill ODBC Driver for Mac or Windows at: [http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/)
+2. Refer to the instructions appropriate for your system to install the ODBC driver:
+ * [Windows](http://drill.apache.org/docs/installing-the-driver-on-windows/)
+ * [Mac](http://drill.apache.org/docs/installing-the-driver-on-mac-os-x/)
+
+**Important:** Verify that the Tableau client system can resolve the hostnames for the Drill and Zookeeper nodes correctly. See the *System Requirements* section of the ODBC [Mac](http://drill.apache.org/docs/installing-the-driver-on-mac-os-x/) or [Windows](http://drill.apache.org/docs/installing-the-driver-on-windows/) installation page for instructions.
+
+----------
+
+
+### Step 2: Connect Tableau to Drill
+
+To connect Tableau to Drill, complete the following steps:
+
+**Note:** The [Tableau documentation](http://onlinehelp.tableau.com/current/pro/desktop/en-us/help.htm#examples_apachedrill.html) provides additional details, if needed.
+
+1. In a Tableau Workbook, click on **Data > New Data Source**.
+2. Select **Apache Drill**. 
+3. Choose whether to connect directly or using ZooKeeper. For production environments, connecting to ZooKeeper is recommended for resiliency and distribution of connection management on the Drill cluster.
+4. Enter the ZooKeeper Quorum/Drill Cluster ID or Drill Direct Server and Port information.
+5. Enter the authentication information.
+6. Click **Sign In**. Tableau connects to Drill and allows you to select various Tables and Views. 
+7. Click on the **Schema** drop-down list to display all available Drill schemas. When you select a schema, Tableau displays available tables or views. You can select the tables and views to build a Tableau Visualization. Additionally, you can use custom SQL by clicking on the **New Custom SQL** option. 
+
+**Note:** Tableau can natively work with Hive tables and Drill views. You can use custom SQL or create a view in Drill to represent the complex data in Drill data sources, such as data in files or HBase/MapR-DB tables, to Tableau. For more information, see [Tableau Examples](http://drill.apache.org/docs/tableau-examples/).
+
+----------
+
+
+###Step 3: Query and Analyze the Data
+
+Tableau can now use Drill to query various data sources and visualize the information, as shown in the following example.
+
+####Example
+
+A retailer has order data in CSV files on the distributed file system, product data in HBase, and customer data in Hive. The retailer wants to see the average order total by customer for each state (Tableau LoD), as well as the total number of orders and average revenue by customer for the top 5 states by revenue (Tableau Set).
+
+To find this information, the retail business analyst completes the following steps:
+
+1. Creates a LoD calculation for ordertotal by customer id. 
+2. Displays the states and the average revenue by customer for each state. 
+3. Creates a graph with the total revenue by state, ordered by highest revenue.
+4. Drags and selects the top 5 states, right-clicks, and selects Create Set.
+5. Enters a name for the set. 
+6. Creates a table showing the total number of orders and average revenue by customer for the top 5 states by revenue and also shows the number for the states not in the top 5. 
+
+You have completed the tutorial for configuring Tableau 10.2 to work with Apache Drill. For additional support, see
+[https://www.tableau.com/support/drivers](https://www.tableau.com/support/drivers).
+
+
+
+
+
+
+
+
+
+
+
+