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/02/25 00:15:29 UTC
[20/51] [partial] drill-site git commit: Cleaning up deleted content.
http://git-wip-us.apache.org/repos/asf/drill-site/blob/d42f2cdd/docs/monitoring-and-canceling-queries-in-the-drill-web-ui/index.html
----------------------------------------------------------------------
diff --git a/docs/monitoring-and-canceling-queries-in-the-drill-web-ui/index.html b/docs/monitoring-and-canceling-queries-in-the-drill-web-ui/index.html
deleted file mode 100644
index c3fd9f0..0000000
--- a/docs/monitoring-and-canceling-queries-in-the-drill-web-ui/index.html
+++ /dev/null
@@ -1,1046 +0,0 @@
-<!DOCTYPE html>
-<html>
-
-<head>
-
-<meta charset="UTF-8">
-<meta name=viewport content="width=device-width, initial-scale=1">
-
-
-<title>Monitoring and Canceling Queries in the Drill Web UI - Apache Drill</title>
-
-<link href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css" rel="stylesheet" type="text/css"/>
-<link href='//fonts.googleapis.com/css?family=PT+Sans' rel='stylesheet' type='text/css'/>
-<link href="/css/site.css" rel="stylesheet" type="text/css"/>
-
-<link rel="shortcut icon" href="/favicon.ico" type="image/x-icon"/>
-<link rel="icon" href="/favicon.ico" type="image/x-icon"/>
-
-<script src="//ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js" language="javascript" type="text/javascript"></script>
-<script src="//cdnjs.cloudflare.com/ajax/libs/jquery-easing/1.3/jquery.easing.min.js" language="javascript" type="text/javascript"></script>
-<script language="javascript" type="text/javascript" src="/js/modernizr.custom.js"></script>
-<script language="javascript" type="text/javascript" src="/js/script.js"></script>
-<script language="javascript" type="text/javascript" src="/js/drill.js"></script>
-
-</head>
-
-
-<body onResize="resized();">
- <div class="page-wrap">
- <div class="bui"></div>
-
-<div id="menu" class="mw">
-<ul>
- <li class='toc-categories'>
- <a class="expand-toc-icon" href="javascript:void(0);"><i class="fa fa-bars"></i></a>
- </li>
- <li class="logo"><a href="/"></a></li>
- <li class='expand-menu'>
- <a href="javascript:void(0);"><span class='menu-text'>Menu</span><span class='expand-icon'><i class="fa fa-bars"></i></span></a>
- </li>
- <li class='clear-float'></li>
- <li class="documentation-menu">
- <a href="/docs/">Documentation</a>
- <ul>
-
- <li><a href="/docs/getting-started/">Getting Started</a></li>
-
- <li><a href="/docs/architecture/">Architecture</a></li>
-
- <li><a href="/docs/tutorials/">Tutorials</a></li>
-
- <li><a href="/docs/install-drill/">Install Drill</a></li>
-
- <li><a href="/docs/configure-drill/">Configure Drill</a></li>
-
- <li><a href="/docs/connect-a-data-source/">Connect a Data Source</a></li>
-
- <li><a href="/docs/odbc-jdbc-interfaces/">ODBC/JDBC Interfaces</a></li>
-
- <li><a href="/docs/query-data/">Query Data</a></li>
-
- <li><a href="/docs/performance-tuning/">Performance Tuning</a></li>
-
- <li><a href="/docs/log-and-debug/">Log and Debug</a></li>
-
- <li><a href="/docs/sql-reference/">SQL Reference</a></li>
-
- <li><a href="/docs/data-sources-and-file-formats/">Data Sources and File Formats</a></li>
-
- <li><a href="/docs/develop-custom-functions/">Develop Custom Functions</a></li>
-
- <li><a href="/docs/troubleshooting/">Troubleshooting</a></li>
-
- <li><a href="/docs/developer-information/">Developer Information</a></li>
-
- <li><a href="/docs/release-notes/">Release Notes</a></li>
-
- <li><a href="/docs/sample-datasets/">Sample Datasets</a></li>
-
- <li><a href="/docs/project-bylaws/">Project Bylaws</a></li>
-
- </ul>
- </li>
- <li class='nav'>
- <a href="/community-resources/">Community</a>
- <ul>
- <li><a href="/team/">Team</a></li>
- <li><a href="/mailinglists/">Mailing Lists</a></li>
- <li><a href="/community-resources/">Community Resources</a></li>
- </ul>
- </li>
- <li class='nav'><a href="/faq/">FAQ</a></li>
- <li class='nav'><a href="/blog/">Blog</a></li>
- <li id="twitter-menu-item"><a href="https://twitter.com/apachedrill" title="apachedrill on twitter" target="_blank"><img src="/images/twitter_32_26_white.png" alt="twitter logo" align="center"></a> </li>
- <li class='search-bar'>
- <form id="drill-search-form">
- <input type="text" placeholder="Search Apache Drill" id="drill-search-term" />
- <button type="submit">
- <i class="fa fa-search"></i>
- </button>
- </form>
- </li>
- <li class="d">
- <a href="/download/">
- <i class="fa fa-cloud-download"></i> Download
- </a>
- </li>
-</ul>
-</div>
-
- <link href="/css/content.css" rel="stylesheet" type="text/css">
-
-
-
-
-
-
-
-<aside class="sidebar">
- <div class="docsidebar">
- <div class="docsidebarwrapper">
- <ul style="display: block;">
-
-
- <li class="toctree-l1"><a href="javascript: void(0);">Getting Started</a></li>
- <ul style="display: none">
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/drill-introduction/">Drill Introduction</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/why-drill/">Why Drill</a></li>
-
-
- </ul>
-
-
-
- <li class="toctree-l1"><a href="javascript: void(0);">Architecture</a></li>
- <ul style="display: none">
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/architecture-introduction/">Architecture Introduction</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/drill-query-execution/">Drill Query Execution</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/core-modules/">Core Modules</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/performance/">Performance</a></li>
-
-
- </ul>
-
-
-
- <li class="toctree-l1"><a href="javascript: void(0);">Tutorials</a></li>
- <ul style="display: none">
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/tutorials-introduction/">Tutorials Introduction</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/drill-in-10-minutes/">Drill in 10 Minutes</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/analyzing-the-yelp-academic-dataset/">Analyzing the Yelp Academic Dataset</a></li>
-
-
-
- <li class="toctree-l2"><a href="javascript: void(0);">Learn Drill with the MapR Sandbox</a></li>
- <ul style="display: none">
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/about-the-mapr-sandbox/">About the MapR Sandbox</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/installing-the-apache-drill-sandbox/">Installing the Apache Drill Sandbox</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/getting-to-know-the-drill-sandbox/">Getting to Know the Drill Sandbox</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/lesson-1-learn-about-the-data-set/">Lesson 1: Learn about the Data Set</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/lesson-2-run-queries-with-ansi-sql/">Lesson 2: Run Queries with ANSI SQL</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/lesson-3-run-queries-on-complex-data-types/">Lesson 3: Run Queries on Complex Data Types</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/summary/">Summary</a></li>
-
- </ul>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/analyzing-highly-dynamic-datasets/">Analyzing Highly Dynamic Datasets</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/analyzing-social-media/">Analyzing Social Media</a></li>
-
-
- </ul>
-
-
-
- <li class="toctree-l1"><a href="javascript: void(0);">Install Drill</a></li>
- <ul style="display: none">
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/install-drill-introduction/">Install Drill Introduction</a></li>
-
-
-
- <li class="toctree-l2"><a href="javascript: void(0);">Installing Drill in Embedded Mode</a></li>
- <ul style="display: none">
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/embedded-mode-prerequisites/">Embedded Mode Prerequisites</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/installing-drill-on-linux-and-mac-os-x/">Installing Drill on Linux and Mac OS X</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/starting-drill-on-linux-and-mac-os-x/">Starting Drill on Linux and Mac OS X</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/installing-drill-on-windows/">Installing Drill on Windows</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/starting-drill-on-windows/">Starting Drill on Windows</a></li>
-
- </ul>
-
-
-
- <li class="toctree-l2"><a href="javascript: void(0);">Installing Drill in Distributed Mode</a></li>
- <ul style="display: none">
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/distributed-mode-prerequisites/">Distributed Mode Prerequisites</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/installing-drill-on-the-cluster/">Installing Drill on the Cluster</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/starting-drill-in-distributed-mode/">Starting Drill in Distributed Mode</a></li>
-
- </ul>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/starting-the-web-ui/">Starting the Web UI</a></li>
-
-
- </ul>
-
-
-
- <li class="toctree-l1"><a href="javascript: void(0);">Configure Drill</a></li>
- <ul style="display: none">
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/configure-drill-introduction/">Configure Drill Introduction</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-drill-memory/">Configuring Drill Memory</a></li>
-
-
-
- <li class="toctree-l2"><a href="javascript: void(0);">Configuring a Multitenant Cluster</a></li>
- <ul style="display: none">
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-a-multitenant-cluster-introduction/">Configuring a Multitenant Cluster Introduction</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-multitenant-resources/">Configuring Multitenant Resources</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-resources-for-a-shared-drillbit/">Configuring Resources for a Shared Drillbit</a></li>
-
- </ul>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-user-impersonation/">Configuring User Impersonation</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-user-authentication/">Configuring User Authentication</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-user-impersonation-with-hive-authorization/">Configuring User Impersonation with Hive Authorization</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-web-ui-and-rest-api-security/">Configuring Web UI and REST API Security</a></li>
-
-
-
- <li class="toctree-l2"><a href="javascript: void(0);">Configuration Options</a></li>
- <ul style="display: none">
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/configuration-options-introduction/">Configuration Options Introduction</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/start-up-options/">Start-Up Options</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/planning-and-execution-options/">Planning and Execution Options</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/persistent-configuration-storage/">Persistent Configuration Storage</a></li>
-
- </ul>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/ports-used-by-drill/">Ports Used by Drill</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-the-drill-shell/">Configuring the Drill Shell</a></li>
-
-
- </ul>
-
-
-
- <li class="toctree-l1"><a href="javascript: void(0);">Connect a Data Source</a></li>
- <ul style="display: none">
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/connect-a-data-source-introduction/">Connect a Data Source Introduction</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/storage-plugin-registration/">Storage Plugin Registration</a></li>
-
-
-
- <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li>
- <ul style="display: none">
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/workspaces/">Workspaces</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/hbase-storage-plugin/">HBase Storage Plugin</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/hive-storage-plugin/">Hive Storage Plugin</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/drill-default-input-format/">Drill Default Input Format</a></li>
-
- </ul>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/mongodb-plugin-for-apache-drill/">MongoDB Plugin for Apache Drill</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
- </ul>
-
-
-
- <li class="toctree-l1"><a href="javascript: void(0);">ODBC/JDBC Interfaces</a></li>
- <ul style="display: none">
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/interfaces-introduction/">Interfaces Introduction</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/using-the-jdbc-driver/">Using the JDBC Driver</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/using-jdbc-with-squirrel-on-windows/">Using JDBC with SQuirreL on Windows</a></li>
-
-
-
- <li class="toctree-l2"><a href="javascript: void(0);">Installing the ODBC Driver</a></li>
- <ul style="display: none">
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/installing-the-driver-on-linux/">Installing the Driver on Linux</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/installing-the-driver-on-mac-os-x/">Installing the Driver on Mac OS X</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/installing-the-driver-on-windows/">Installing the Driver on Windows</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/installing-the-tdc-file-on-windows/">Installing the TDC File on Windows</a></li>
-
- </ul>
-
-
-
- <li class="toctree-l2"><a href="javascript: void(0);">Configuring ODBC</a></li>
- <ul style="display: none">
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/odbc-configuration-reference/">ODBC Configuration Reference</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-odbc-on-linux/">Configuring ODBC on Linux</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-odbc-on-mac-os-x/">Configuring ODBC on Mac OS X</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-odbc-on-windows/">Configuring ODBC on Windows</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/testing-the-odbc-connection/">Testing the ODBC Connection</a></li>
-
- </ul>
-
-
-
- <li class="toctree-l2"><a href="javascript: void(0);">Using Drill Explorer</a></li>
- <ul style="display: none">
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/drill-explorer-introduction/">Drill Explorer Introduction</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/connecting-drill-explorer-to-data/">Connecting Drill Explorer to Data</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/browsing-data-and-defining-views/">Browsing Data and Defining Views</a></li>
-
- </ul>
-
-
-
- <li class="toctree-l2"><a href="javascript: void(0);">Using Drill with BI Tools</a></li>
- <ul style="display: none">
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/using-drill-with-bi-tools-introduction/">Using Drill with BI Tools Introduction</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/tableau-examples/">Tableau Examples</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/using-microstrategy-analytics-with-apache-drill/">Using MicroStrategy Analytics with Apache Drill</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/using-tibco-spotfire-desktop-with-drill/">Using Tibco Spotfire Desktop with Drill</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-tibco-spotfire-server-with-drill/">Configuring Tibco Spotfire Server with Drill</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-desktop/">Using Apache Drill with Tableau 9 Desktop</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-
- </ul>
-
-
- </ul>
-
-
-
- <li class="toctree-l1 current_section "><a href="javascript: void(0);">Query Data</a></li>
- <ul class="current_section">
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/query-data-introduction/">Query Data Introduction</a></li>
-
-
-
- <li class="toctree-l2"><a href="javascript: void(0);">Querying a File System</a></li>
- <ul style="display: none">
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/querying-a-file-system-introduction/">Querying a File System Introduction</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/querying-json-files/">Querying JSON Files</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/querying-parquet-files/">Querying Parquet Files</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/querying-plain-text-files/">Querying Plain Text Files</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/querying-directories/">Querying Directories</a></li>
-
- </ul>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/querying-hbase/">Querying HBase</a></li>
-
-
-
- <li class="toctree-l2"><a href="javascript: void(0);">Querying Complex Data</a></li>
- <ul style="display: none">
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/querying-complex-data-introduction/">Querying Complex Data Introduction</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/sample-data-donuts/">Sample Data: Donuts</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/selecting-flat-data/">Selecting Flat Data</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/using-sql-functions-clauses-and-joins/">Using SQL Functions, Clauses, and Joins</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/selecting-nested-data-for-a-column/">Selecting Nested Data for a Column</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/selecting-multiple-columns-within-nested-data/">Selecting Multiple Columns Within Nested Data</a></li>
-
- </ul>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/querying-hive/">Querying Hive</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/querying-the-information-schema/">Querying the INFORMATION SCHEMA</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/querying-system-tables/">Querying System Tables</a></li>
-
-
-
- <li class="toctree-l2 current"><a class="reference internal" href="/docs/monitoring-and-canceling-queries-in-the-drill-web-ui/">Monitoring and Canceling Queries in the Drill Web UI</a></li>
-
-
- </ul>
-
-
-
- <li class="toctree-l1"><a href="javascript: void(0);">Performance Tuning</a></li>
- <ul style="display: none">
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/performance-tuning-introduction/">Performance Tuning Introduction</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/partition-pruning/">Partition Pruning</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/choosing-a-storage-format/">Choosing a Storage Format</a></li>
-
-
-
- <li class="toctree-l2"><a href="javascript: void(0);">Query Plans and Tuning</a></li>
- <ul style="display: none">
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/query-plans-and-tuning-introduction/">Query Plans and Tuning Introduction</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/join-planning-guidelines/">Join Planning Guidelines</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/guidelines-for-optimizing-aggregation/">Guidelines for Optimizing Aggregation</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/modifying-query-planning-options/">Modifying Query Planning Options</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/sort-based-and-hash-based-memory-constrained-operators/">Sort-Based and Hash-Based Memory-Constrained Operators</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/enabling-query-queuing/">Enabling Query Queuing</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/controlling-parallelization-to-balance-performance-with-multi-tenancy/">Controlling Parallelization to Balance Performance with Multi-Tenancy</a></li>
-
- </ul>
-
-
-
- <li class="toctree-l2"><a href="javascript: void(0);">Identifying Performance Issues</a></li>
- <ul style="display: none">
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/query-plans/">Query Plans</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/query-profiles/">Query Profiles</a></li>
-
- </ul>
-
-
-
- <li class="toctree-l2"><a href="javascript: void(0);">Performance Tuning Reference</a></li>
- <ul style="display: none">
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/query-profile-column-descriptions/">Query Profile Column Descriptions</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/physical-operators/">Physical Operators</a></li>
-
- </ul>
-
-
- </ul>
-
-
-
- <li class="toctree-l1"><a href="javascript: void(0);">Log and Debug</a></li>
- <ul style="display: none">
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/log-and-debug-introduction/">Log and Debug Introduction</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/error-messages/">Error Messages</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/modify-logback-xml/">Modify logback.xml</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/review-the-java-stack-trace/">Review the Java Stack Trace</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/query-audit-logging/">Query Audit Logging</a></li>
-
-
- </ul>
-
-
-
- <li class="toctree-l1"><a href="javascript: void(0);">SQL Reference</a></li>
- <ul style="display: none">
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/sql-reference-introduction/">SQL Reference Introduction</a></li>
-
-
-
- <li class="toctree-l2"><a href="javascript: void(0);">Data Types</a></li>
- <ul style="display: none">
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/supported-data-types/">Supported Data Types</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/date-time-and-timestamp/">Date, Time, and Timestamp</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/handling-different-data-types/">Handling Different Data Types</a></li>
-
- </ul>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/lexical-structure/">Lexical Structure</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/operators/">Operators</a></li>
-
-
-
- <li class="toctree-l2"><a href="javascript: void(0);">SQL Functions</a></li>
- <ul style="display: none">
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/about-sql-function-examples/">About SQL Function Examples</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/math-and-trig/">Math and Trig</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/data-type-conversion/">Data Type Conversion</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/date-time-functions-and-arithmetic/">Date/Time Functions and Arithmetic</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/string-manipulation/">String Manipulation</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/aggregate-and-aggregate-statistical/">Aggregate and Aggregate Statistical</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/functions-for-handling-nulls/">Functions for Handling Nulls</a></li>
-
- </ul>
-
-
-
- <li class="toctree-l2"><a href="javascript: void(0);">SQL Window Functions</a></li>
- <ul style="display: none">
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/sql-window-functions-introduction/">SQL Window Functions Introduction</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/aggregate-window-functions/">Aggregate Window Functions</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/ranking-window-functions/">Ranking Window Functions</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/value-window-functions/">Value Window Functions</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/sql-window-functions-examples/">SQL Window Functions Examples</a></li>
-
- </ul>
-
-
-
- <li class="toctree-l2"><a href="javascript: void(0);">Nested Data Functions</a></li>
- <ul style="display: none">
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/nested-data-limitations/">Nested Data Limitations</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/flatten/">FLATTEN</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/kvgen/">KVGEN</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/repeated-count/">REPEATED_COUNT</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/repeated-contains/">REPEATED_CONTAINS</a></li>
-
- </ul>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/query-directory-functions/">Query Directory Functions</a></li>
-
-
-
- <li class="toctree-l2"><a href="javascript: void(0);">SQL Commands</a></li>
- <ul style="display: none">
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/create-table-as-ctas/">CREATE TABLE AS (CTAS)</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/partition-by-clause/">PARTITION BY Clause</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/create-view/">CREATE VIEW</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/describe/">DESCRIBE</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/drop-table/">DROP TABLE</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/explain/">EXPLAIN</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/show-files/">SHOW FILES</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/show-tables/">SHOW TABLES</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/use/">USE</a></li>
-
- </ul>
-
-
-
- <li class="toctree-l2"><a href="javascript: void(0);">SQL Conditional Expressions</a></li>
- <ul style="display: none">
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/case/">CASE</a></li>
-
- </ul>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/reserved-keywords/">Reserved Keywords</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/sql-extensions/">SQL Extensions</a></li>
-
-
- </ul>
-
-
-
- <li class="toctree-l1"><a href="javascript: void(0);">Data Sources and File Formats</a></li>
- <ul style="display: none">
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/data-sources-and-file-formats-introduction/">Data Sources and File Formats Introduction</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/hive-to-drill-data-type-mapping/">Hive-to-Drill Data Type Mapping</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/deploying-and-using-a-hive-udf/">Deploying and Using a Hive UDF</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/parquet-format/">Parquet Format</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/json-data-model/">JSON Data Model</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/text-files-csv-tsv-psv/">Text Files: CSV, TSV, PSV</a></li>
-
-
- </ul>
-
-
-
- <li class="toctree-l1"><a href="javascript: void(0);">Develop Custom Functions</a></li>
- <ul style="display: none">
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/develop-custom-functions-introduction/">Develop Custom Functions Introduction</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/developing-a-simple-function/">Developing a Simple Function</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/tutorial-develop-a-simple-function/">Tutorial: Develop a Simple Function</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/developing-an-aggregate-function/">Developing an Aggregate Function</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/adding-custom-functions-to-drill/">Adding Custom Functions to Drill</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/using-custom-functions-in-queries/">Using Custom Functions in Queries</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/custom-function-interfaces/">Custom Function Interfaces</a></li>
-
-
- </ul>
-
-
-
- <li class="toctree-l1"><a class="reference internal" href="/docs/troubleshooting/">Troubleshooting</a></li>
-
-
-
- <li class="toctree-l1"><a href="javascript: void(0);">Developer Information</a></li>
- <ul style="display: none">
-
-
- <li class="toctree-l2"><a href="javascript: void(0);">Develop Drill</a></li>
- <ul style="display: none">
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/compiling-drill-from-source/">Compiling Drill from Source</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/drill-patch-review-tool/">Drill Patch Review Tool</a></li>
-
- </ul>
-
-
-
- <li class="toctree-l2"><a href="javascript: void(0);">Contribute to Drill</a></li>
- <ul style="display: none">
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/apache-drill-contribution-guidelines/">Apache Drill Contribution Guidelines</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/apache-drill-contribution-ideas/">Apache Drill Contribution Ideas</a></li>
-
- </ul>
-
-
-
- <li class="toctree-l2"><a href="javascript: void(0);">Design Docs</a></li>
- <ul style="display: none">
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/drill-plan-syntax/">Drill Plan Syntax</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/rpc-overview/">RPC Overview</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/query-stages/">Query Stages</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/useful-research/">Useful Research</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/value-vectors/">Value Vectors</a></li>
-
- </ul>
-
-
- </ul>
-
-
-
- <li class="toctree-l1"><a href="javascript: void(0);">Release Notes</a></li>
- <ul style="display: none">
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-1-0-release-notes/">Apache Drill 1.1.0 Release Notes</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-8-0-release-notes/">Apache Drill 0.8.0 Release Notes</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-7-0-release-notes/">Apache Drill 0.7.0 Release Notes</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-6-0-release-notes/">Apache Drill 0.6.0 Release Notes</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-m1-release-notes-apache-drill-alpha/">Apache Drill M1 Release Notes (Apache Drill Alpha)</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-m1-release-notes-apache-drill-alpha/">Apache Drill M1 Release Notes (Apache Drill Alpha)</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-5-0-release-notes/">Apache Drill 0.5.0 Release Notes</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-4-0-release-notes/">Apache Drill 0.4.0 Release Notes</a></li>
-
-
- </ul>
-
-
-
- <li class="toctree-l1"><a href="javascript: void(0);">Sample Datasets</a></li>
- <ul style="display: none">
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/aol-search/">AOL Search</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/enron-emails/">Enron Emails</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/wikipedia-edit-history/">Wikipedia Edit History</a></li>
-
-
- </ul>
-
-
-
- <li class="toctree-l1"><a class="reference internal" href="/docs/project-bylaws/">Project Bylaws</a></li>
-
-
- </ul>
-
- </div>
- </div>
-</aside>
-
-
-<nav class="breadcrumbs">
- <li><a href="/docs/">Docs</a></li>
-
-
- <li><a href="/docs/query-data/">Query Data</a></li>
-
- <li>Monitoring and Canceling Queries in the Drill Web UI</li>
-</nav>
-
-<div class="main-content-wrapper">
- <div class="main-content">
-
-
- <a class="edit-link" href="https://github.com/apache/drill/blob/gh-pages/_docs/query-data/080-monitoring-and-canceling-queries-in-the-Drill-Web-UI.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
-
-
- <div class="int_title left">
- <h1>Monitoring and Canceling Queries in the Drill Web UI</h1>
-
- </div>
-
- <link href="/css/docpage.css" rel="stylesheet" type="text/css">
-
- <div class="int_text" align="left">
-
- <p>You can monitor and cancel queries from the Drill Web UI if you are <a href="/docs/configuring-web-ui-and-rest-api-security/">authorized</a> to do so. To access the Drill
-Web UI, the Drillbit process must be running on the Drill node that you use to
-access the Drill Web UI.</p>
-
-<p>To monitor or cancel a query from the Drill Web UI, complete the following
-steps:</p>
-
-<ol>
-<li><p>Navigate to the Drill Web UI at <code><drill_node_ip_address>:8047.</code><br>
-When you access the Drill Web UI, you see some general information about Drill
-running in your cluster, such as the nodes running the Drillbit process, the
-various ports Drill is using, and the amount of direct memory assigned to
-Drill.<br>
-<img src="/docs/img/7.png" alt="drill query flow"></p></li>
-<li><p>Select <strong>Profiles</strong> in the toolbar. A list of running and completed queries appears. Drill assigns a query ID to each query and lists the Foreman node. The Foreman is the Drillbit node that receives the query from the client or application. The Foreman drives the entire query.
-<img src="/docs/img/51.png" alt="drill query flow"> </p></li>
-<li><p>Click the <strong>Query ID</strong> for the query that you want to monitor or cancel. The Query and Planning window appears.<br>
-<img src="/docs/img/4.png" alt="drill query flow"></p></li>
-<li><p>Select <strong>Edit Query</strong>.</p></li>
-<li><p>Click <strong>Cancel query **to cancel the</strong> query. The following message appears:
-<img src="/docs/img/46.png" alt="drill query flow"> </p></li>
-<li><p>Optionally, you can re-run the query to see a query summary in this window.</p></li>
-</ol>
-
-
-
- <div class="doc-nav">
-
- <span class="previous-toc"><a href="/docs/querying-system-tables/">\u2190 Querying System Tables</a></span><span class="next-toc"><a href="/docs/performance-tuning/">Performance Tuning \u2192</a></span>
-</div>
-
-
- </div>
- </div>
-</div>
-
- </div>
- <p class="push"></p>
-<div id="footer" class="mw">
-<div class="wrapper">
-Copyright � 2012-2014 The Apache Software Foundation, licensed under the Apache License, Version 2.0.<br>
-Apache and the Apache feather logo are trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.<br/><br/>
-</div>
-</div>
-
- <script>
-(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
-(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
-m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
-})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
-
-ga('create', 'UA-53379651-1', 'auto');
-ga('send', 'pageview');
-</script>
-
-</body>
-</html>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/d42f2cdd/docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/050-configuring-spotfire-server.md
----------------------------------------------------------------------
diff --git a/docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/050-configuring-spotfire-server.md b/docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/050-configuring-spotfire-server.md
deleted file mode 100644
index 436776e..0000000
--- a/docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/050-configuring-spotfire-server.md
+++ /dev/null
@@ -1 +0,0 @@
----
title: "Configuring Tibco Spotfire Server with Drill"
parent: "Using Drill with BI Tools"
---
This document describes how to configure Tibco Spotfire Server (TSS) to integrate with Apache Drill and explore multiple data formats instantly on Hadoop. Users can combine these powerful platforms to rapidly gain analytical access to a wide variety of data types.
Complete the following steps to configure and use Apache Drill with TSS:
1. Install the Drill JDBC driver with TSS.
2. Configure the Drill Data Source Template in TSS with the TSS configuration tool.
3. Configure Drill data sources with Tibco Spotfire Desktop and Information Designer.
4. Query and analyze various data formats with Tibco Spotfire and Drill.
----------
### Step 1: Install and Configure the Drill JDBC Driver
Drill provides standard JDBC connectivity, making it easy to integrate data exploration capabilities on complex, schema-less data sets. Tibco Spotfire Server (TSS) requires Drill 1.0 or later, whic
h incudes the JDBC driver. The JDBC driver is bundled with the Drill configuration files, and it is recommended that you use the JDBC driver that is shipped with the specific Drill version.
For general instructions to install the Drill JDBC driver, see [Using JDBC](http://drill.apache.org/docs/using-jdbc/).
Complete the following steps to install and configure the JDBC driver for TSS:
1. Locate the JDBC driver in the Drill installation directory:
`<drill-home>/jars/jdbc-driver/drill-jdbc-all-<drill-version>.jar`
For example, on a MapR cluster:
`/opt/mapr/drill/drill-1.0.0/jars/jdbc-driver/drill-jdbc-all-1.0.0-SNAPSHOT.jar`
2. Locate the TSS library directory and copy the JDBC driver file to that directory:
`<TSS-home-directory>/tomcat/lib`
For example, on a Linux server:
`/usr/local/bin/tibco/tss/6.0.3/tomcat/lib`
For example, on a Windows server:
`C:\Program Files\apache-tomcat\lib`
3. Restart TSS to load the JDBC driver.
4. Verify that th
e TSS system can resolve the hostnames of the ZooKeeper nodes for the Drill cluster. You can do this by validating that DNS is properly configured for the TSS system and all the ZooKeeper nodes. Alternatively, you can add the hostnames and IP addresses of the ZooKeeper nodes to the TSS system hosts file.
For Linux systems, the hosts file is located here:
`/etc/hosts`
For Windows systems, the hosts file is located here:
`%WINDIR%\system32\drivers\etc\hosts`
----------
### Step 2: Configure the Drill Data Source Template in TSS
The Drill Data Source template can now be configured with the TSS Configuration Tool. The Windows-based TSS Configuration Tool is recommended. If TSS is installed on a Linux system, you also need to install TSS on a small Windows-based system so you can utilize the Configuration Tool. In this case, it is also recommended that you install the Drill JDBC driver on the TSS Windows system.
1. Click **Start > All Programs > TIBCO Spotfire Serve
r > Configure TIBCO Spotfire Server**. 
2. Enter the Configuration Tool password that was specified when TSS was initially installed.
3. Once the Configuration Tool has connected to TSS, click the **Configuration** tab, then **Data Source Templates**. 
4. In the Data Source Templates window, click the **New** button at the bottom of the window. 
5. Provide a name for the data source template, then copy the following XML template into the **Data Source Template** box. When complete, click **OK**. 
6. The new entry will now be available in the data source template. Check the box next to the new entry, then click **Save Configuration**. 
7. Select Database as the destination and click Next. 
8. Add a comment to the updated configuration and click **Finish**.
9. A response window is displayed to state that the configuration was successfully uploaded to TSS. Click **OK**. 
10. Restart TSS to enable it to use the Drill data source template.
#### XML Template
Make sure that you enter the correct ZooKeeper node name instead of `<zk-node>`, as well as the correct Drill cluster name instead of `<drill-cluster-name>` in the example below. This is just a template that will appear whenever a data source is configured. The hostnames of ZooKeeper nodes and the Drill cluster name can be found in the `$DRILL_HOME/conf/drill-override.conf` file on any of the Drill nodes in the cluster.
<jdbc-type-settings>
<type-name>drill</ty
pe-name>
<driver>org.apache.drill.jdbc.Driver</driver>
<connection-url-pattern>jdbc:drill:zk=<zk-node>:5181/drill/<drill-cluster-name>-drillbits</connection-url-pattern>
<ping-command>SELECT 1 FROM sys.version</ping-command>
<supports-catalogs>true</supports-catalogs>
<supports-schemas>true</supports-schemas>
<supports-procedures>false</supports-procedures>
<table-expression-pattern>[$$schema$$.]$$table$$</table-expression-pattern>
<column-name-pattern>`$$name$$`</column-name-pattern>
<table-name-pattern>`$$name$$`</table-name-pattern>
<schema-name-pattern>`$$name$$`</schema-name-pattern>
<catalog-name-pattern>`$$name$$`</catalog-name-pattern>
<procedure-name-pattern>`$$name$$`</procedure-name-pattern>
<column-alias-pattern>`$$name$$`</column-alias-pattern>
<java-to-sql-type-conversions>
<type-mapping>
<from max-length="32672">String</from>
<to>VARCHAR($$value$$)</to>
</type-mapping>
<type-mappin
g>
<from>String</from>
<to>VARCHAR(32672)</to>
</type-mapping>
<type-mapping>
<from>Integer</from>
<to>INTEGER</to>
</type-mapping>
</java-to-sql-type-conversions>
</jdbc-type-settings>
----------
### Step 3: Configure Drill Data Sources with Tibco Spotfire Desktop
To configure Drill data sources in TSS, you need to use the Tibco Spotfire Desktop client.
1. Open Tibco Spotfire Desktop. 
2. Log into TSS. 
3. Select the deployment area in TSS to be used. 
4. Click **Tools > Information Designer**. 
5. In the Information Designer, click **New > Data Source**. 
6. In the Data Source window, enter the name for the data source. Select the Drill Data Source template created in Step 2 as the type. Update the connection URL with the correct hostname of the ZooKeeper node(s) and the Drill cluster name. Note: The Zookeeper node(s) hostname(s) and Drill cluster name can be found in the `$DRILL_HOME/conf/drill-override.conf` file on any of the Drill nodes in the cluster. Enter the username and password used to connect to Drill. When completed, click **Save**. 
7. In the Save As window, verify the name and the folder where you want to save the new data source in TSS. Click **Save** when done. TSS will now validate the information and save the new data source in TSS.
8. When the data source is saved, it will appear in the **Data Sources** tab, and you will be able to navigate the schema. 
----------
### Step 4: Query and Analyze the Data
After the Drill data source has been configured in the Information Designer, the information elements can be defined.
1. In this example all the columns of a Hive table have been defined, using the Drill data source, and added to an information link. 
2. The SQL syntax to retrieve the data can be validated by clicking the **SQL** button. Many other operations can be performed in Information Link, including joins, filters, and so on. See the Tibco Spotfire documentation for details.
3. You can now import the data of this table into TSS by clicking the **Open Data** button. 
The data is now available in Tibco Spotfire Desktop to create various reports and tables as needed, and to be shared. For more information about creating charts, tables and reports, see the Tib
co Spotfire documentation.
...
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/drill-site/blob/d42f2cdd/docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/080-configuring-jreport.md
----------------------------------------------------------------------
diff --git a/docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/080-configuring-jreport.md b/docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/080-configuring-jreport.md
deleted file mode 100644
index 35f147a..0000000
--- a/docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/080-configuring-jreport.md
+++ /dev/null
@@ -1 +0,0 @@
----
title: "Configuring JReport with Drill"
parent: "Using Drill with BI Tools"
---
JReport is an embeddable BI solution that empowers users to analyze data and create reports and dashboards. JReport accesses data from Hadoop systems through Apache Drill. By visualizing data through Drill, users can perform their own reporting and data discovery for agile, on-the-fly decision-making.
You can use JReport 13.1 and the Apache Drill JDBC Driver to easily extract data and visualize it, creating reports and dashboards that you can embed into your own applications. Complete the following simple steps to use Apache Drill with JReport:
1. Install the Drill JDBC Driver with JReport.
2. Create a new JReport Catalog to manage the Drill connection.
3. Use JReport Designer to query the data and create a report.
----------
### Step 1: Install the Drill JDBC Driver with JReport
Drill provides standard JDBC connectivity to integrate with JReport. JReport 13.1 requires Drill 1.0 or later.
For g
eneral instructions on installing the Drill JDBC driver, see [Using JDBC]({{ site.baseurl }}/docs/using-the-jdbc-driver/).
1. Locate the JDBC driver in the Drill installation directory on any node where Drill is installed on the cluster:
<drill-home>/jars/jdbc-driver/drill-jdbc-all-<drill-version>.jar
2. Copy the Drill JDBC driver into the JReport `lib` folder:
%REPORTHOME%\lib\
For example, on Windows, copy the Drill JDBC driver jar file into:
C:\JReport\Designer\lib\drill-jdbc-all-1.0.0.jar
3. Add the location of the JAR file to the JReport CLASSPATH variable. On Windows, edit the `C:\JReport\Designer\bin\setenv.bat` file:

4. Verify that the JReport system can resolve the hostnames of the ZooKeeper nodes of the Drill cluster. You can do this by configuring DNS for all of the systems. Alternatively, you can edit the hosts file on the JReport system to include the host
names and IP addresses of all the ZooKeeper nodes used with the Drill cluster. For Linux systems, the hosts file is located at `/etc/hosts`. For Windows systems, the hosts file is located at `%WINDIR%\system32\drivers\etc\hosts` Here is an example of a Windows hosts file: 
----------
### Step 2: Create a New JReport Catalog to Manage the Drill Connection
1. Click Create **New -> Catalog\u2026**
2. Provide a catalog file name and click **\u2026** to choose the file-saving location.
3. Click **View -> Catalog Browser**.
4. Right-click **Data Source 1** and select **Add JDBC Connection**.
5. Fill in the **Driver**, **URL**, **User**, and **Password** fields. 
6. Click **Options** and select the **Qualifier** tab.
7. In the **Quote Qualifier** section, choose **User Defined** and change the quote character from \u201c to ` (backtick). 
8. Click **OK**. JReport will verify the connection and save all information.
9. Add tables and views to the JReport catalog by right-clicking the connection node and choosing **Add Table**. Now you can browse the schemas and add specific tables that you want to make available for building queries. 
10. Click **Done** when you have added all the tables you need.
### Step 3: Use JReport Designer
1. In the Catalog Browser, right-click **Queries** and select **Add Query\u2026**
2. Define a JReport query by using the Query Editor. You can also import your own SQL statements. 
3. Click **OK** to close the Query Editor, and click the **Save Catalog** button to save your progress to the catalog file.
**Note**: If the report returns errors, you may need to edit the query and add the
schema in front of the table name: `select column from schema.table_name` You can do this by clicking the **SQL** button on the Query Editor.
4. Use JReport Designer to query the data and create a report. 


\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/drill-site/blob/d42f2cdd/docs/odbc-jdbc-interfaces/using-odbc-on-windows/005-odbc-on-windows-introduction.md
----------------------------------------------------------------------
diff --git a/docs/odbc-jdbc-interfaces/using-odbc-on-windows/005-odbc-on-windows-introduction.md b/docs/odbc-jdbc-interfaces/using-odbc-on-windows/005-odbc-on-windows-introduction.md
deleted file mode 100644
index 827ef44..0000000
--- a/docs/odbc-jdbc-interfaces/using-odbc-on-windows/005-odbc-on-windows-introduction.md
+++ /dev/null
@@ -1,38 +0,0 @@
-
----
-title: "ODBC on Windows Introduction"
-parent: "Using ODBC on Windows"
----
-The MapR Drill ODBC driver provides BI tools access to Drill\u2019s flexible query
-capabilities so that users can quickly explore various data sources. The MapR
-Drill ODBC driver includes Drill Explorer, which is a simple user interface
-that enables users to examine the content of data sources and create views
-before visualizing the data in a BI tool.
-
-Once you install the MapR Drill ODBC Driver, you can create ODBC DSNs to Drill
-data sources using the ODBC Administrator tool and then use the DSNs to access
-the data from BI tools that work with ODBC. Drill can connect to data with
-well-defined schemas, such as Hive. Drill can also connect directly to data
-that is self-describing, such as HBase, Parquet, JSON, CSV, and TSV.
-
-Complete the following steps to connect to a Drill data source from a BI tool
-using ODBC:
-
- * [Step 1. Install the MapR Drill ODBC Driver]({{ site.baseurl }}/docs/step-1-install-the-mapr-drill-odbc-driver-on-windows)
- * [Step 2. Configure ODBC Connections to Drill Data Sources]({{ site.baseurl }}/docs/step-2-configure-odbc-connections-to-drill-data-sources)
- * [Step 3. Connect to Drill Data Sources from a BI Tool]({{ site.baseurl }}/docs/step-3-connect-to-drill-data-sources-from-a-bi-tool)
-
-For examples of how you can use the MapR Drill ODBC Driver to connect to Drill
-Data Sources from BI tools, see [Step 3. Connect to Drill Data Sources from a
-BI Tool]({{ site.baseurl }}/docs/step-3-connect-to-drill-data-sources-from-a-bi-tool). While the documentation includes examples for Tableau, you can use
-this driver with any BI tool that works with ODBC, such as Excel,
-MicroStrategy, and Toad.
-
-The following figure shows how a BI tool on Windows uses an ODBC connection to
-access data from a Hive table:
-
-
-
-The following components provide applications access to Drill data sources:
-
-<table ><tbody><tr><th >Component</th><th >Role</th></tr><tr><td valign="top">Drillbit</td><td valign="top">Accepts queries from clients, executes queries against Drill data sources, and returns the query results. </td></tr><tr><td valign="top">ODBC Data Source Administrator</td><td valign="top">The ODBC Data Source Administrator enables the creation of DSNs to Apache Drill data sources.<br /> In the figure above, the ODBC Data Source Administrator was used to create <code>Hive-DrillDataSources</code>.</td></tr><tr><td valign="top">ODBC DSN</td><td valign="top"><p>Provides applications information about how to connect to the Drill Source.</p>In the figure above, the <code>Hive-DrillDataSources</code> is a DSN that provides connection information to the Hive tables.</td></tr><tr><td colspan="1" valign="top">BI Tool</td><td colspan="1" valign="top"><p>Accesses Drill data sources using the connection information from the ODBC DSN.</p>In the figure above, the BI tool uses <code>Hive-Dri
llDataSources</code> to access the <code>hive_student</code> table.</td></tr></tbody></table></div>
\ No newline at end of file