http://git-wip-us.apache.org/repos/asf/drill-site/blob/ee640eab/docs/querying-complex-data/index.html ---------------------------------------------------------------------- diff --git a/docs/querying-complex-data/index.html b/docs/querying-complex-data/index.html index 2c6dcde..28244a7 100644 --- a/docs/querying-complex-data/index.html +++ b/docs/querying-complex-data/index.html @@ -9,26 +9,21 @@ <title>Querying Complex Data - Apache Drill</title> -<link href="/css/syntax.css" rel="stylesheet" type="text/css"> -<link href="/css/style.css" rel="stylesheet" type="text/css"> -<link href="/css/arrows.css" rel="stylesheet" type="text/css"> -<link href="/css/breadcrumbs.css" rel="stylesheet" type="text/css"> -<link href="/css/code.css" rel="stylesheet" type="text/css"> -<link rel="stylesheet" href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css"> -<link href="/css/responsive.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 language="javascript" type="text/javascript" src="/js/lib/jquery-1.11.1.min.js"></script> -<script language="javascript" type="text/javascript" src="/js/lib/jquery.easing.1.3.js"></script> +<link href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css" 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> @@ -63,6 +58,12 @@ <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/query-audit-logging/">Query Audit Logging</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> @@ -81,6 +82,8 @@ <li><a href="/docs/project-bylaws/">Project Bylaws</a></li> + <li><a href="/docs/log-and-debug/">Log and Debug</a></li> + </ul> </li> <li class='nav'> @@ -110,7 +113,9 @@ </ul> </div> - + <link href="/css/content.css" rel="stylesheet" type="text/css"> + + @@ -149,14 +154,7 @@ - <li class="toctree-l2"><a href="javascript: void(0);">Architectural Highlights</a></li> - <ul style="display: none"> - - <li class="toctree-l3"><a class="reference internal" href="/docs/flexibility/">Flexibility</a></li> - - <li class="toctree-l3"><a class="reference internal" href="/docs/performance/">Performance</a></li> - - </ul> + <li class="toctree-l2"><a class="reference internal" href="/docs/performance/">Performance</a></li> </ul> @@ -203,6 +201,10 @@ <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> @@ -300,7 +302,7 @@ - <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/configuring-the-drill-shell/">Configuring the Drill Shell</a></li> </ul> @@ -357,7 +359,7 @@ - <li class="toctree-l2"><a class="reference internal" href="/docs/using-jdbc/">Using JDBC</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> @@ -409,6 +411,10 @@ + <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-tibco-spotfire-server-with-drill/">Configuring Tibco Spotfire Server with Drill</a></li> + + + <li class="toctree-l2"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-desktop/">Using Apache Drill with Tableau 9 Desktop</a></li> @@ -487,6 +493,32 @@ + <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> + + + </ul> + + + + <li class="toctree-l1"><a class="reference internal" href="/docs/log-and-debug/">Log and Debug</a></li> + + + + <li class="toctree-l1"><a href="javascript: void(0);">Query Audit Logging</a></li> + <ul style="display: none"> + + + <li class="toctree-l2"><a class="reference internal" href="/docs/getting-query-information/">Getting Query Information</a></li> + + + </ul> + + + <li class="toctree-l1"><a href="javascript: void(0);">SQL Reference</a></li> <ul style="display: none"> @@ -563,27 +595,47 @@ <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-command/">ALTER SESSION Command</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/create-view/">CREATE VIEW</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/describe/">DESCRIBE</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system-command/">ALTER SYSTEM Command</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/create-table-as-ctas-command/">CREATE TABLE AS (CTAS) Command</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/create-view-command/">CREATE VIEW Command</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/describe-command/">DESCRIBE Command</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/explain-commands/">EXPLAIN Commands</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-statements/">SELECT Statements</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas-command/">SHOW DATABASES and SHOW SCHEMAS Command</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/show-files-command/">SHOW FILES Command</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/show-tables-command/">SHOW TABLES Command</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/use-command/">USE Command</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li> + + <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</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> @@ -782,6 +834,10 @@ <li class="toctree-l2"><a class="reference internal" href="/docs/what-is-apache-drill/">What is Apache Drill</a></li> + + <li class="toctree-l2"><a class="reference internal" href="/docs/partition-pruning/">Partition Pruning</a></li> + + </ul> @@ -800,6 +856,29 @@ <li class="toctree-l1"><a class="reference internal" href="/docs/project-bylaws/">Project Bylaws</a></li> + + <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> + + + </ul> + + </ul> </div> @@ -807,7 +886,7 @@ </aside> - <nav class="breadcrumbs"> +<nav class="breadcrumbs"> <li><a href="/docs/">Docs</a></li> @@ -816,54 +895,54 @@ <li>Querying Complex Data</li> </nav> - <div class="main-content-wrapper"> - <div class="main-content"> +<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/040-querying-complex-data.md"; target="_blank"><i class="fa fa-pencil-square-o"></i></a> - + + <a class="edit-link" href="https://github.com/apache/drill/blob/gh-pages/_docs/query-data/040-querying-complex-data.md"; target="_blank"><i class="fa fa-pencil-square-o"></i></a> + - <div class="int_title"> - <h1>Querying Complex Data</h1> + <div class="int_title left"> + <h1>Querying Complex Data</h1> - </div> + </div> - <link href="/css/docpage.css" rel="stylesheet" type="text/css"> + <link href="/css/docpage.css" rel="stylesheet" type="text/css"> - <div class="int_text" align="left"> - - <ul> - - <li><a href="/docs/querying-complex-data-introduction/">Querying Complex Data Introduction</a></li> - + <div class="int_text" align="left"> + + <ul> - <li><a href="/docs/sample-data-donuts/">Sample Data: Donuts</a></li> - + <li><a href="/docs/querying-complex-data-introduction/">Querying Complex Data Introduction</a></li> - <li><a href="/docs/selecting-flat-data/">Selecting Flat Data</a></li> - + + <li><a href="/docs/sample-data-donuts/">Sample Data: Donuts</a></li> - <li><a href="/docs/using-sql-functions-clauses-and-joins/">Using SQL Functions, Clauses, and Joins</a></li> - + + <li><a href="/docs/selecting-flat-data/">Selecting Flat Data</a></li> - <li><a href="/docs/selecting-nested-data-for-a-column/">Selecting Nested Data for a Column</a></li> - + + <li><a href="/docs/using-sql-functions-clauses-and-joins/">Using SQL Functions, Clauses, and Joins</a></li> - <li><a href="/docs/selecting-multiple-columns-within-nested-data/">Selecting Multiple Columns Within Nested Data</a></li> - + + <li><a href="/docs/selecting-nested-data-for-a-column/">Selecting Nested Data for a Column</a></li> - </ul> + <li><a href="/docs/selecting-multiple-columns-within-nested-data/">Selecting Multiple Columns Within Nested Data</a></li> - <div class="doc-nav"> + + </ul> + + + <div class="doc-nav"> <span class="previous-toc"><a href="/docs/querying-hbase/">â Querying HBase</a></span><span class="next-toc"><a href="/docs/querying-complex-data-introduction/">Querying Complex Data Introduction â</a></span> </div> - - </div> + </div> </div> +</div> </div> <p class="push"></p>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/ee640eab/docs/querying-directories/index.html ---------------------------------------------------------------------- diff --git a/docs/querying-directories/index.html b/docs/querying-directories/index.html index a19e234..8265cd4 100644 --- a/docs/querying-directories/index.html +++ b/docs/querying-directories/index.html @@ -9,26 +9,21 @@ <title>Querying Directories - Apache Drill</title> -<link href="/css/syntax.css" rel="stylesheet" type="text/css"> -<link href="/css/style.css" rel="stylesheet" type="text/css"> -<link href="/css/arrows.css" rel="stylesheet" type="text/css"> -<link href="/css/breadcrumbs.css" rel="stylesheet" type="text/css"> -<link href="/css/code.css" rel="stylesheet" type="text/css"> -<link rel="stylesheet" href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css"> -<link href="/css/responsive.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 language="javascript" type="text/javascript" src="/js/lib/jquery-1.11.1.min.js"></script> -<script language="javascript" type="text/javascript" src="/js/lib/jquery.easing.1.3.js"></script> +<link href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css" 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> @@ -63,6 +58,12 @@ <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/query-audit-logging/">Query Audit Logging</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> @@ -81,6 +82,8 @@ <li><a href="/docs/project-bylaws/">Project Bylaws</a></li> + <li><a href="/docs/log-and-debug/">Log and Debug</a></li> + </ul> </li> <li class='nav'> @@ -110,7 +113,9 @@ </ul> </div> - + <link href="/css/content.css" rel="stylesheet" type="text/css"> + + @@ -149,14 +154,7 @@ - <li class="toctree-l2"><a href="javascript: void(0);">Architectural Highlights</a></li> - <ul style="display: none"> - - <li class="toctree-l3"><a class="reference internal" href="/docs/flexibility/">Flexibility</a></li> - - <li class="toctree-l3"><a class="reference internal" href="/docs/performance/">Performance</a></li> - - </ul> + <li class="toctree-l2"><a class="reference internal" href="/docs/performance/">Performance</a></li> </ul> @@ -203,6 +201,10 @@ <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> @@ -300,7 +302,7 @@ - <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/configuring-the-drill-shell/">Configuring the Drill Shell</a></li> </ul> @@ -357,7 +359,7 @@ - <li class="toctree-l2"><a class="reference internal" href="/docs/using-jdbc/">Using JDBC</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> @@ -409,6 +411,10 @@ + <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-tibco-spotfire-server-with-drill/">Configuring Tibco Spotfire Server with Drill</a></li> + + + <li class="toctree-l2"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-desktop/">Using Apache Drill with Tableau 9 Desktop</a></li> @@ -487,6 +493,32 @@ + <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> + + + </ul> + + + + <li class="toctree-l1"><a class="reference internal" href="/docs/log-and-debug/">Log and Debug</a></li> + + + + <li class="toctree-l1"><a href="javascript: void(0);">Query Audit Logging</a></li> + <ul style="display: none"> + + + <li class="toctree-l2"><a class="reference internal" href="/docs/getting-query-information/">Getting Query Information</a></li> + + + </ul> + + + <li class="toctree-l1"><a href="javascript: void(0);">SQL Reference</a></li> <ul style="display: none"> @@ -563,27 +595,47 @@ <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-command/">ALTER SESSION Command</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/create-view/">CREATE VIEW</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/describe/">DESCRIBE</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-from/">SELECT FROM</a></li> + + <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system-command/">ALTER SYSTEM Command</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/create-table-as-ctas-command/">CREATE TABLE AS (CTAS) Command</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/create-view-command/">CREATE VIEW Command</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/describe-command/">DESCRIBE Command</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/explain-commands/">EXPLAIN Commands</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-statements/">SELECT Statements</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas-command/">SHOW DATABASES and SHOW SCHEMAS Command</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/show-files-command/">SHOW FILES Command</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-tables-command/">SHOW TABLES Command</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/use-command/">USE Command</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> @@ -782,6 +834,10 @@ <li class="toctree-l2"><a class="reference internal" href="/docs/what-is-apache-drill/">What is Apache Drill</a></li> + + <li class="toctree-l2"><a class="reference internal" href="/docs/partition-pruning/">Partition Pruning</a></li> + + </ul> @@ -800,6 +856,29 @@ <li class="toctree-l1"><a class="reference internal" href="/docs/project-bylaws/">Project Bylaws</a></li> + + <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> + + + </ul> + + </ul> </div> @@ -807,7 +886,7 @@ </aside> - <nav class="breadcrumbs"> +<nav class="breadcrumbs"> <li><a href="/docs/">Docs</a></li> @@ -818,23 +897,23 @@ <li>Querying Directories</li> </nav> - <div class="main-content-wrapper"> - <div class="main-content"> +<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/query-a-file-system/040-querying-directories.md"; target="_blank"><i class="fa fa-pencil-square-o"></i></a> - + + <a class="edit-link" href="https://github.com/apache/drill/blob/gh-pages/_docs/query-data/query-a-file-system/040-querying-directories.md"; target="_blank"><i class="fa fa-pencil-square-o"></i></a> + - <div class="int_title"> - <h1>Querying Directories</h1> + <div class="int_title left"> + <h1>Querying Directories</h1> - </div> + </div> - <link href="/css/docpage.css" rel="stylesheet" type="text/css"> + <link href="/css/docpage.css" rel="stylesheet" type="text/css"> - <div class="int_text" align="left"> - - <p>You can store multiple files in a directory and query them as if they were a + <div class="int_text" align="left"> + + <p>You can store multiple files in a directory and query them as if they were a single entity. You do not have to explicitly join the files. The files must be compatible, in the sense that they must have comparable data types and columns in the same order. This type of query is not limited to text files; you can @@ -847,20 +926,20 @@ the "union" of the two files, ordered by the first column:</p> <div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> select columns[0] as `Year`, columns[1] as Play from dfs.`/Users/brumsby/drill/testdata` order by 1; -+------------+------------+ -| Year | Play | -+------------+------------+ -| 1594 | Comedy of Errors | -| 1595 | Romeo and Juliet | ++------------+------------------------+ +| Year | Play | ++------------+------------------------+ +| 1594 | Comedy of Errors | +| 1595 | Romeo and Juliet | | 1596 | The Merchant of Venice | -| 1599 | As You Like It | -| 1599 | Hamlet | -| 1601 | Twelfth Night | -| 1606 | Macbeth | -| 1606 | King Lear | -| 1609 | The Winter's Tale | -| 1610 | The Tempest | -+------------+------------+ +| 1599 | As You Like It | +| 1599 | Hamlet | +| 1601 | Twelfth Night | +| 1606 | Macbeth | +| 1606 | King Lear | +| 1609 | The Winter's Tale | +| 1610 | The Tempest | ++------------+------------------------+ 10 rows selected (0.296 seconds) </code></pre></div> <p>You can drill down further and automatically query subdirectories as well. For @@ -893,11 +972,11 @@ subdirectories: <code>2012</code>, <code>2013</code>, and <code>2014</code>. The files inside the subdirectory named <code>2013</code>. The variable <code>dir0</code> refers to the first level down from logs, <code>dir1</code> to the next level, and so on.</p> <div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> use bob.logdata; -+------------+------------+ -| ok | summary | -+------------+------------+ ++------------+-----------------------------------------+ +| ok | summary | ++------------+-----------------------------------------+ | true | Default schema changed to 'bob.logdata' | -+------------+------------+ ++------------+-----------------------------------------+ 1 row selected (0.305 seconds) 0: jdbc:drill:> select * from logs where dir0='2013' limit 10; @@ -919,17 +998,17 @@ first level down from logs, <code>dir1</code> to the next level, and so on.</p> </code></pre></div> <p>For more information about querying directories, see the section, <a href="/docs/query-directory-functions">"Query Directory Functions"</a>.</p> + - - <div class="doc-nav"> + <div class="doc-nav"> <span class="previous-toc"><a href="/docs/querying-plain-text-files/">â Querying Plain Text Files</a></span><span class="next-toc"><a href="/docs/querying-hbase/">Querying HBase â</a></span> </div> - - </div> + </div> </div> +</div> </div> <p class="push"></p> http://git-wip-us.apache.org/repos/asf/drill-site/blob/ee640eab/docs/querying-hbase/index.html ---------------------------------------------------------------------- diff --git a/docs/querying-hbase/index.html b/docs/querying-hbase/index.html index 08c75aa..e51e86b 100644 --- a/docs/querying-hbase/index.html +++ b/docs/querying-hbase/index.html @@ -9,26 +9,21 @@ <title>Querying HBase - Apache Drill</title> -<link href="/css/syntax.css" rel="stylesheet" type="text/css"> -<link href="/css/style.css" rel="stylesheet" type="text/css"> -<link href="/css/arrows.css" rel="stylesheet" type="text/css"> -<link href="/css/breadcrumbs.css" rel="stylesheet" type="text/css"> -<link href="/css/code.css" rel="stylesheet" type="text/css"> -<link rel="stylesheet" href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css"> -<link href="/css/responsive.css" rel="stylesheet" type="text/css"> +<link href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css" 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"> +<link rel="shortcut icon" href="/favicon.ico" type="image/x-icon"/> +<link rel="icon" href="/favicon.ico" type="image/x-icon"/> -<script language="javascript" type="text/javascript" src="/js/lib/jquery-1.11.1.min.js"></script> -<script language="javascript" type="text/javascript" src="/js/lib/jquery.easing.1.3.js"></script> +<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> @@ -63,6 +58,12 @@ <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/query-audit-logging/">Query Audit Logging</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> @@ -81,6 +82,8 @@ <li><a href="/docs/project-bylaws/">Project Bylaws</a></li> + <li><a href="/docs/log-and-debug/">Log and Debug</a></li> + </ul> </li> <li class='nav'> @@ -110,7 +113,9 @@ </ul> </div> - + <link href="/css/content.css" rel="stylesheet" type="text/css"> + + @@ -149,14 +154,7 @@ - <li class="toctree-l2"><a href="javascript: void(0);">Architectural Highlights</a></li> - <ul style="display: none"> - - <li class="toctree-l3"><a class="reference internal" href="/docs/flexibility/">Flexibility</a></li> - - <li class="toctree-l3"><a class="reference internal" href="/docs/performance/">Performance</a></li> - - </ul> + <li class="toctree-l2"><a class="reference internal" href="/docs/performance/">Performance</a></li> </ul> @@ -203,6 +201,10 @@ <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> @@ -300,7 +302,7 @@ - <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/configuring-the-drill-shell/">Configuring the Drill Shell</a></li> </ul> @@ -357,7 +359,7 @@ - <li class="toctree-l2"><a class="reference internal" href="/docs/using-jdbc/">Using JDBC</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> @@ -409,6 +411,10 @@ + <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-tibco-spotfire-server-with-drill/">Configuring Tibco Spotfire Server with Drill</a></li> + + + <li class="toctree-l2"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-desktop/">Using Apache Drill with Tableau 9 Desktop</a></li> @@ -487,6 +493,32 @@ + <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> + + + </ul> + + + + <li class="toctree-l1"><a class="reference internal" href="/docs/log-and-debug/">Log and Debug</a></li> + + + + <li class="toctree-l1"><a href="javascript: void(0);">Query Audit Logging</a></li> + <ul style="display: none"> + + + <li class="toctree-l2"><a class="reference internal" href="/docs/getting-query-information/">Getting Query Information</a></li> + + + </ul> + + + <li class="toctree-l1"><a href="javascript: void(0);">SQL Reference</a></li> <ul style="display: none"> @@ -563,27 +595,47 @@ <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-command/">ALTER SESSION Command</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/create-view/">CREATE VIEW</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system-command/">ALTER SYSTEM Command</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/create-table-as-ctas-command/">CREATE TABLE AS (CTAS) Command</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/create-view-command/">CREATE VIEW Command</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/describe-command/">DESCRIBE Command</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/explain-commands/">EXPLAIN Commands</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-statements/">SELECT Statements</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas-command/">SHOW DATABASES and SHOW SCHEMAS Command</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/show-files-command/">SHOW FILES Command</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/show-tables-command/">SHOW TABLES Command</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/use-command/">USE Command</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li> + + <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li> + + <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li> + + <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</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> @@ -782,6 +834,10 @@ <li class="toctree-l2"><a class="reference internal" href="/docs/what-is-apache-drill/">What is Apache Drill</a></li> + + <li class="toctree-l2"><a class="reference internal" href="/docs/partition-pruning/">Partition Pruning</a></li> + + </ul> @@ -800,6 +856,29 @@ <li class="toctree-l1"><a class="reference internal" href="/docs/project-bylaws/">Project Bylaws</a></li> + + <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> + + + </ul> + + </ul> </div> @@ -807,7 +886,7 @@ </aside> - <nav class="breadcrumbs"> +<nav class="breadcrumbs"> <li><a href="/docs/">Docs</a></li> @@ -816,23 +895,23 @@ <li>Querying HBase</li> </nav> - <div class="main-content-wrapper"> - <div class="main-content"> +<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/030-querying-hbase.md"; target="_blank"><i class="fa fa-pencil-square-o"></i></a> - + + <a class="edit-link" href="https://github.com/apache/drill/blob/gh-pages/_docs/query-data/030-querying-hbase.md"; target="_blank"><i class="fa fa-pencil-square-o"></i></a> + - <div class="int_title"> - <h1>Querying HBase</h1> + <div class="int_title left"> + <h1>Querying HBase</h1> - </div> + </div> - <link href="/css/docpage.css" rel="stylesheet" type="text/css"> + <link href="/css/docpage.css" rel="stylesheet" type="text/css"> - <div class="int_text" align="left"> - - <p>This exercise creates two tables in HBase, students and clicks, that you can query with Drill. As an HBase user, you most likely are running Drill in distributed mode, in which Drill might start as a service. If you are not an HBase user and just kicking the tires, you might use the Drill Sandbox on a single-node cluster (embedded mode). In this case, you need to <a href="/docs/install-drill/">start Drill</a> before performing step 5 of this exercise. On the Drill Sandbox, HBase tables you create will be located in: /mapr/demo.mapr.com/tables</p> + <div class="int_text" align="left"> + + <p>This exercise creates two tables in HBase, students and clicks, that you can query with Drill. As an HBase user, you most likely are running Drill in distributed mode, in which Drill might start as a service. If you are not an HBase user and just kicking the tires, you might use the Drill Sandbox on a single-node cluster (embedded mode). In this case, you need to <a href="/docs/install-drill/">start Drill</a> before performing step 5 of this exercise. On the Drill Sandbox, HBase tables you create will be located in: <code>/mapr/demo.mapr.com/tables</code></p> <p>You use the CONVERT_TO and CONVERT_FROM functions to convert binary text to readable output. You use the CAST function to convert the binary INT to readable output in step 4 of <a href="/docs/querying-hbase/#query-hbase-tables">Query HBase Tables</a>. When converting an INT or BIGINT number, having a byte count in the destination/source that does not match the byte count of the number in the VARBINARY source/destination, use CAST.</p> @@ -932,17 +1011,21 @@ put 'clicks','click9','iteminfo:quantity','10' <p>SELECT * FROM students; The query returns binary results:</p> -<div class="highlight"><pre><code class="language-text" data-lang="text">+------------+------------+------------+ -| row_key | account | address | -+------------+------------+------------+ -| [B@e6d9eb7 | {"name":"QWxpY2U="} | {"state":"Q0E=","street":"MTIzIEJhbGxtZXIgQXY=","zipcode":"MTIzNDU="} | -| [B@2823a2b4 | {"name":"Qm9i"} | {"state":"Q0E=","street":"MSBJbmZpbml0ZSBMb29w","zipcode":"MTIzNDU="} | -| [B@3b8eec02 | {"name":"RnJhbms="} | {"state":"Q0E=","street":"NDM1IFdhbGtlciBDdA==","zipcode":"MTIzNDU="} | -| [B@242895da | {"name":"TWFyeQ=="} | {"state":"Q0E=","street":"NTYgU291dGhlcm4gUGt3eQ==","zipcode":"MTIzNDU="} | -+------------+------------+------------+ +<div class="highlight"><pre><code class="language-text" data-lang="text">+-------------+-----------------------+---------------------------------------------------------------------------+ +| row_key | account | address | ++-------------+-----------------------+---------------------------------------------------------------------------+ +| [B@e6d9eb7 | {"name":"QWxpY2U="} | {"state":"Q0E=","street":"MTIzIEJhbGxtZXIgQXY=","zipcode":"MTIzNDU="} | +| [B@2823a2b4 | {"name":"Qm9i"} | {"state":"Q0E=","street":"MSBJbmZpbml0ZSBMb29w","zipcode":"MTIzNDU="} | +| [B@3b8eec02 | {"name":"RnJhbms="} | {"state":"Q0E=","street":"NDM1IFdhbGtlciBDdA==","zipcode":"MTIzNDU="} | +| [B@242895da | {"name":"TWFyeQ=="} | {"state":"Q0E=","street":"NTYgU291dGhlcm4gUGt3eQ==","zipcode":"MTIzNDU="} | ++-------------+-----------------------+---------------------------------------------------------------------------+ 4 rows selected (1.335 seconds) -</code></pre></div> -<p>The Drill output reflects the actual data type of the HBase data, which is binary.</p></li> +</code></pre></div></li> +</ol> + +<p>The Drill output reflects the actual data type of the HBase data, which is binary.</p> + +<ol> <li><p>Issue the following query, that includes the CONVERT_FROM function, to convert the <code>students</code> table to readable data:</p> <div class="highlight"><pre><code class="language-text" data-lang="text"> SELECT CONVERT_FROM(row_key, 'UTF8') AS studentid, CONVERT_FROM(students.account.name, 'UTF8') AS name, @@ -957,14 +1040,14 @@ The query returns binary results:</p> </div> <p>The query returns readable data:</p> -<div class="highlight"><pre><code class="language-text" data-lang="text">+------------+------------+------------+------------+------------+ -| studentid | name | state | street | zipcode | -+------------+------------+------------+------------+------------+ -| student1 | Alice | CA | 123 Ballmer Av | 12345 | -| student2 | Bob | CA | 1 Infinite Loop | 12345 | -| student3 | Frank | CA | 435 Walker Ct | 12345 | +<div class="highlight"><pre><code class="language-text" data-lang="text">+------------+------------+------------+------------------+------------+ +| studentid | name | state | street | zipcode | ++------------+------------+------------+------------------+------------+ +| student1 | Alice | CA | 123 Ballmer Av | 12345 | +| student2 | Bob | CA | 1 Infinite Loop | 12345 | +| student3 | Frank | CA | 435 Walker Ct | 12345 | | student4 | Mary | CA | 56 Southern Pkwy | 12345 | -+------------+------------+------------+------------+------------+ ++------------+------------+------------+------------------+------------+ 4 rows selected (0.504 seconds) </code></pre></div></li> <li><p>Query the clicks table to see which students visited google.com:</p> @@ -974,13 +1057,13 @@ The query returns binary results:</p> CONVERT_FROM(clicks.clickinfo.url, 'UTF8') AS url FROM clicks WHERE clicks.clickinfo.url LIKE '%google%'; -+------------+------------+------------+------------+ -| clickid | studentid | time | url | -+------------+------------+------------+------------+ ++------------+------------+--------------------------+-----------------------+ +| clickid | studentid | time | url | ++------------+------------+--------------------------+-----------------------+ | click1 | student1 | 2014-01-01 12:01:01.0001 | http://www.google.com | | click3 | student2 | 2014-01-01 01:02:01.0001 | http://www.google.com | | click6 | student3 | 2013-02-01 12:01:01.0001 | http://www.google.com | -+------------+------------+------------+------------+ ++------------+------------+--------------------------+-----------------------+ 3 rows selected (0.294 seconds) </code></pre></div></li> <li><p>Query the clicks table to get the studentid of the student having 100 items. Use CONVERT_FROM to convert the textual studentid and itemtype data, but use CAST to convert the integer quantity.</p> @@ -998,17 +1081,17 @@ FROM clicks tbl WHERE tbl.iteminfo.quantity=100; </code></pre></div></li> </ol> + - - <div class="doc-nav"> + <div class="doc-nav"> <span class="previous-toc"><a href="/docs/querying-directories/">â Querying Directories</a></span><span class="next-toc"><a href="/docs/querying-complex-data/">Querying Complex Data â</a></span> </div> - - </div> + </div> </div> +</div> </div> <p class="push"></p> http://git-wip-us.apache.org/repos/asf/drill-site/blob/ee640eab/docs/querying-hive/index.html ---------------------------------------------------------------------- diff --git a/docs/querying-hive/index.html b/docs/querying-hive/index.html index 59726d8..1a3d1b6 100644 --- a/docs/querying-hive/index.html +++ b/docs/querying-hive/index.html @@ -9,26 +9,21 @@ <title>Querying Hive - Apache Drill</title> -<link href="/css/syntax.css" rel="stylesheet" type="text/css"> -<link href="/css/style.css" rel="stylesheet" type="text/css"> -<link href="/css/arrows.css" rel="stylesheet" type="text/css"> -<link href="/css/breadcrumbs.css" rel="stylesheet" type="text/css"> -<link href="/css/code.css" rel="stylesheet" type="text/css"> -<link rel="stylesheet" href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css"> -<link href="/css/responsive.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 language="javascript" type="text/javascript" src="/js/lib/jquery-1.11.1.min.js"></script> -<script language="javascript" type="text/javascript" src="/js/lib/jquery.easing.1.3.js"></script> +<link href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css" 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> @@ -63,6 +58,12 @@ <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/query-audit-logging/">Query Audit Logging</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> @@ -81,6 +82,8 @@ <li><a href="/docs/project-bylaws/">Project Bylaws</a></li> + <li><a href="/docs/log-and-debug/">Log and Debug</a></li> + </ul> </li> <li class='nav'> @@ -110,7 +113,9 @@ </ul> </div> - + <link href="/css/content.css" rel="stylesheet" type="text/css"> + + @@ -149,14 +154,7 @@ - <li class="toctree-l2"><a href="javascript: void(0);">Architectural Highlights</a></li> - <ul style="display: none"> - - <li class="toctree-l3"><a class="reference internal" href="/docs/flexibility/">Flexibility</a></li> - - <li class="toctree-l3"><a class="reference internal" href="/docs/performance/">Performance</a></li> - - </ul> + <li class="toctree-l2"><a class="reference internal" href="/docs/performance/">Performance</a></li> </ul> @@ -203,6 +201,10 @@ <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> @@ -300,7 +302,7 @@ - <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/configuring-the-drill-shell/">Configuring the Drill Shell</a></li> </ul> @@ -357,7 +359,7 @@ - <li class="toctree-l2"><a class="reference internal" href="/docs/using-jdbc/">Using JDBC</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> @@ -409,6 +411,10 @@ + <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-tibco-spotfire-server-with-drill/">Configuring Tibco Spotfire Server with Drill</a></li> + + + <li class="toctree-l2"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-desktop/">Using Apache Drill with Tableau 9 Desktop</a></li> @@ -487,6 +493,32 @@ + <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> + + + </ul> + + + + <li class="toctree-l1"><a class="reference internal" href="/docs/log-and-debug/">Log and Debug</a></li> + + + + <li class="toctree-l1"><a href="javascript: void(0);">Query Audit Logging</a></li> + <ul style="display: none"> + + + <li class="toctree-l2"><a class="reference internal" href="/docs/getting-query-information/">Getting Query Information</a></li> + + + </ul> + + + <li class="toctree-l1"><a href="javascript: void(0);">SQL Reference</a></li> <ul style="display: none"> @@ -563,27 +595,47 @@ <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-command/">ALTER SESSION Command</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/create-view/">CREATE VIEW</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/describe/">DESCRIBE</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-from/">SELECT FROM</a></li> + + <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system-command/">ALTER SYSTEM Command</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/create-table-as-ctas-command/">CREATE TABLE AS (CTAS) Command</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/create-view-command/">CREATE VIEW Command</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/describe-command/">DESCRIBE Command</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/explain-commands/">EXPLAIN Commands</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-statements/">SELECT Statements</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas-command/">SHOW DATABASES and SHOW SCHEMAS Command</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/show-files-command/">SHOW FILES Command</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-tables-command/">SHOW TABLES Command</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/use-command/">USE Command</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> @@ -782,6 +834,10 @@ <li class="toctree-l2"><a class="reference internal" href="/docs/what-is-apache-drill/">What is Apache Drill</a></li> + + <li class="toctree-l2"><a class="reference internal" href="/docs/partition-pruning/">Partition Pruning</a></li> + + </ul> @@ -800,6 +856,29 @@ <li class="toctree-l1"><a class="reference internal" href="/docs/project-bylaws/">Project Bylaws</a></li> + + <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> + + + </ul> + + </ul> </div> @@ -807,7 +886,7 @@ </aside> - <nav class="breadcrumbs"> +<nav class="breadcrumbs"> <li><a href="/docs/">Docs</a></li> @@ -816,23 +895,23 @@ <li>Querying Hive</li> </nav> - <div class="main-content-wrapper"> - <div class="main-content"> +<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/050-querying-hive.md"; target="_blank"><i class="fa fa-pencil-square-o"></i></a> - + + <a class="edit-link" href="https://github.com/apache/drill/blob/gh-pages/_docs/query-data/050-querying-hive.md"; target="_blank"><i class="fa fa-pencil-square-o"></i></a> + - <div class="int_title"> - <h1>Querying Hive</h1> + <div class="int_title left"> + <h1>Querying Hive</h1> - </div> + </div> - <link href="/css/docpage.css" rel="stylesheet" type="text/css"> + <link href="/css/docpage.css" rel="stylesheet" type="text/css"> - <div class="int_text" align="left"> - - <p>This is a simple exercise that provides steps for creating a Hive table and + <div class="int_text" align="left"> + + <p>This is a simple exercise that provides steps for creating a Hive table and inserting data that you can query using Drill. Before you perform the steps, download the <a href="http://doc.mapr.com/download/attachments/28868943/customers.csv?version=1&modificationDate=1426874930765&api=v2";>customers.csv</a> file.</p> @@ -849,7 +928,7 @@ download the <a href="http://doc.mapr.com/download/attachments/28868943/customer <div class="highlight"><pre><code class="language-text" data-lang="text">hive> load data local inpath '/<directory path>/customers.csv' overwrite into table customers;` </code></pre></div></li> <li><p>Issue <code>quit</code> or <code>exit</code> to leave the Hive shell.</p></li> -<li><p>Start Drill. Refer to [/docs/install-drill) for instructions.</p></li> +<li><p>Start the Drill shell. </p></li> <li><p>Issue the following query to Drill to get the first and last names of the first ten customers in the Hive table: </p> <div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:schema=hiveremote> SELECT firstname,lastname FROM hiveremote.`customers` limit 10;` </code></pre></div> @@ -873,17 +952,17 @@ download the <a href="http://doc.mapr.com/download/attachments/28868943/customer </code></pre></div></li> </ol> + - - <div class="doc-nav"> + <div class="doc-nav"> <span class="previous-toc"><a href="/docs/selecting-multiple-columns-within-nested-data/">â Selecting Multiple Columns Within Nested Data</a></span><span class="next-toc"><a href="/docs/querying-the-information-schema/">Querying the INFORMATION SCHEMA â</a></span> </div> - - </div> + </div> </div> +</div> </div> <p class="push"></p> http://git-wip-us.apache.org/repos/asf/drill-site/blob/ee640eab/docs/querying-json-files/index.html ---------------------------------------------------------------------- diff --git a/docs/querying-json-files/index.html b/docs/querying-json-files/index.html index 105e9dc..df174ae 100644 --- a/docs/querying-json-files/index.html +++ b/docs/querying-json-files/index.html @@ -9,26 +9,21 @@ <title>Querying JSON Files - Apache Drill</title> -<link href="/css/syntax.css" rel="stylesheet" type="text/css"> -<link href="/css/style.css" rel="stylesheet" type="text/css"> -<link href="/css/arrows.css" rel="stylesheet" type="text/css"> -<link href="/css/breadcrumbs.css" rel="stylesheet" type="text/css"> -<link href="/css/code.css" rel="stylesheet" type="text/css"> -<link rel="stylesheet" href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css"> -<link href="/css/responsive.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 language="javascript" type="text/javascript" src="/js/lib/jquery-1.11.1.min.js"></script> -<script language="javascript" type="text/javascript" src="/js/lib/jquery.easing.1.3.js"></script> +<link href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css" 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> @@ -63,6 +58,12 @@ <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/query-audit-logging/">Query Audit Logging</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> @@ -81,6 +82,8 @@ <li><a href="/docs/project-bylaws/">Project Bylaws</a></li> + <li><a href="/docs/log-and-debug/">Log and Debug</a></li> + </ul> </li> <li class='nav'> @@ -110,7 +113,9 @@ </ul> </div> - + <link href="/css/content.css" rel="stylesheet" type="text/css"> + + @@ -149,14 +154,7 @@ - <li class="toctree-l2"><a href="javascript: void(0);">Architectural Highlights</a></li> - <ul style="display: none"> - - <li class="toctree-l3"><a class="reference internal" href="/docs/flexibility/">Flexibility</a></li> - - <li class="toctree-l3"><a class="reference internal" href="/docs/performance/">Performance</a></li> - - </ul> + <li class="toctree-l2"><a class="reference internal" href="/docs/performance/">Performance</a></li> </ul> @@ -203,6 +201,10 @@ <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> @@ -300,7 +302,7 @@ - <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/configuring-the-drill-shell/">Configuring the Drill Shell</a></li> </ul> @@ -357,7 +359,7 @@ - <li class="toctree-l2"><a class="reference internal" href="/docs/using-jdbc/">Using JDBC</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> @@ -409,6 +411,10 @@ + <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-tibco-spotfire-server-with-drill/">Configuring Tibco Spotfire Server with Drill</a></li> + + + <li class="toctree-l2"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-desktop/">Using Apache Drill with Tableau 9 Desktop</a></li> @@ -487,6 +493,32 @@ + <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> + + + </ul> + + + + <li class="toctree-l1"><a class="reference internal" href="/docs/log-and-debug/">Log and Debug</a></li> + + + + <li class="toctree-l1"><a href="javascript: void(0);">Query Audit Logging</a></li> + <ul style="display: none"> + + + <li class="toctree-l2"><a class="reference internal" href="/docs/getting-query-information/">Getting Query Information</a></li> + + + </ul> + + + <li class="toctree-l1"><a href="javascript: void(0);">SQL Reference</a></li> <ul style="display: none"> @@ -563,27 +595,47 @@ <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-command/">ALTER SESSION Command</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/create-view/">CREATE VIEW</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/describe/">DESCRIBE</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-from/">SELECT FROM</a></li> + + <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system-command/">ALTER SYSTEM Command</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/create-table-as-ctas-command/">CREATE TABLE AS (CTAS) Command</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/create-view-command/">CREATE VIEW Command</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/describe-command/">DESCRIBE Command</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/explain-commands/">EXPLAIN Commands</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/select-statements/">SELECT Statements</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas-command/">SHOW DATABASES and SHOW SCHEMAS Command</a></li> + <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li> - <li class="toctree-l3"><a class="reference internal" href="/docs/show-files-command/">SHOW FILES Command</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-tables-command/">SHOW TABLES Command</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/use-command/">USE Command</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> @@ -782,6 +834,10 @@ <li class="toctree-l2"><a class="reference internal" href="/docs/what-is-apache-drill/">What is Apache Drill</a></li> + + <li class="toctree-l2"><a class="reference internal" href="/docs/partition-pruning/">Partition Pruning</a></li> + + </ul> @@ -800,6 +856,29 @@ <li class="toctree-l1"><a class="reference internal" href="/docs/project-bylaws/">Project Bylaws</a></li> + + <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> + + + </ul> + + </ul> </div> @@ -807,7 +886,7 @@ </aside> - <nav class="breadcrumbs"> +<nav class="breadcrumbs"> <li><a href="/docs/">Docs</a></li> @@ -818,69 +897,52 @@ <li>Querying JSON Files</li> </nav> - <div class="main-content-wrapper"> - <div class="main-content"> +<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/query-a-file-system/010-querying-json-files.md"; target="_blank"><i class="fa fa-pencil-square-o"></i></a> - + + <a class="edit-link" href="https://github.com/apache/drill/blob/gh-pages/_docs/query-data/query-a-file-system/010-querying-json-files.md"; target="_blank"><i class="fa fa-pencil-square-o"></i></a> + - <div class="int_title"> - <h1>Querying JSON Files</h1> + <div class="int_title left"> + <h1>Querying JSON Files</h1> - </div> + </div> - <link href="/css/docpage.css" rel="stylesheet" type="text/css"> + <link href="/css/docpage.css" rel="stylesheet" type="text/css"> - <div class="int_text" align="left"> - - <p>Your Drill installation includes a sample JSON file located in Drill's + <div class="int_text" align="left"> + + <p>Your Drill installation includes a sample JSON file located in Drill's classpath. The sample JSON file, <code>employee.json</code>, contains fictitious employee data. Use SQL syntax to query the sample <code>JSON</code> file.</p> <p>To view the data in the <code>employee.json</code> file, submit the following SQL query to Drill:</p> -<div class="highlight"><pre><code class="language-text" data-lang="text"> 0: jdbc:drill:zk=local> SELECT * FROM cp.`employee.json`; +<div class="highlight"><pre><code class="language-text" data-lang="text"> 0: jdbc:drill:zk=local> SELECT * FROM cp.`employee.json` LIMIT 5; </code></pre></div> <p>The query returns the following results:</p> +<div class="highlight"><pre><code class="language-text" data-lang="text">+--------------+----------------------------+---------------------+---------------+--------------+----------------------------+-----------+----------------+-------------+------------------------+----------+----------------+----------------------+-----------------+---------+-----------------------+ +| employee_id | full_name | first_name | last_name | position_id | position_title | store_id | department_id | birth_date | hire_date | salary | supervisor_id | education_level | marital_status | gender | management_role | ++--------------+----------------------------+---------------------+---------------+--------------+----------------------------+-----------+----------------+-------------+------------------------+----------+----------------+----------------------+-----------------+---------+-----------------------+ +| 1 | Sheri Nowmer | Sheri | Nowmer | 1 | President | 0 | 1 | 1961-08-26 | 1994-12-01 00:00:00.0 | 80000.0 | 0 | Graduate Degree | S | F | Senior Management | +| 2 | Derrick Whelply | Derrick | Whelply | 2 | VP Country Manager | 0 | 1 | 1915-07-03 | 1994-12-01 00:00:00.0 | 40000.0 | 1 | Graduate Degree | M | M | Senior Management | +| 4 | Michael Spence | Michael | Spence | 2 | VP Country Manager | 0 | 1 | 1969-06-20 | 1998-01-01 00:00:00.0 | 40000.0 | 1 | Graduate Degree | S | M | Senior Management | +| 5 | Maya Gutierrez | Maya | Gutierrez | 2 | VP Country Manager | 0 | 1 | 1951-05-10 | 1998-01-01 00:00:00.0 | 35000.0 | 1 | Bachelors Degree | M | F | Senior Management | -<p><strong>Example of partial output</strong></p> -<div class="highlight"><pre><code class="language-text" data-lang="text">+-------------+------------+------------+------------+-------------+-----------+ -| employee_id | full_name | first_name | last_name | position_id | position_ | -+-------------+------------+------------+------------+-------------+-----------+ -| 1101 | Steve Eurich | Steve | Eurich | 16 | Store T | -| 1102 | Mary Pierson | Mary | Pierson | 16 | Store T | -| 1103 | Leo Jones | Leo | Jones | 16 | Store Tem | -| 1104 | Nancy Beatty | Nancy | Beatty | 16 | Store T | -| 1105 | Clara McNight | Clara | McNight | 16 | Store | -| 1106 | Marcella Isaacs | Marcella | Isaacs | 17 | Stor | -| 1107 | Charlotte Yonce | Charlotte | Yonce | 17 | Stor | -| 1108 | Benjamin Foster | Benjamin | Foster | 17 | Stor | -| 1109 | John Reed | John | Reed | 17 | Store Per | -| 1110 | Lynn Kwiatkowski | Lynn | Kwiatkowski | 17 | St | -| 1111 | Donald Vann | Donald | Vann | 17 | Store Pe | -| 1112 | William Smith | William | Smith | 17 | Store | -| 1113 | Amy Hensley | Amy | Hensley | 17 | Store Pe | -| 1114 | Judy Owens | Judy | Owens | 17 | Store Per | -| 1115 | Frederick Castillo | Frederick | Castillo | 17 | S | -| 1116 | Phil Munoz | Phil | Munoz | 17 | Store Per | -| 1117 | Lori Lightfoot | Lori | Lightfoot | 17 | Store | -... -+-------------+------------+------------+------------+-------------+-----------+ -1,155 rows selected (0.762 seconds) 0: jdbc:drill:zk=local> </code></pre></div> + - - <div class="doc-nav"> + <div class="doc-nav"> <span class="previous-toc"><a href="/docs/querying-a-file-system-introduction/">â Querying a File System Introduction</a></span><span class="next-toc"><a href="/docs/querying-parquet-files/">Querying Parquet Files â</a></span> </div> - - </div> + </div> </div> +</div> </div> <p class="push"></p>
