http://git-wip-us.apache.org/repos/asf/drill-site/blob/ee640eab/docs/nested-data-functions/index.html ---------------------------------------------------------------------- diff --git a/docs/nested-data-functions/index.html b/docs/nested-data-functions/index.html index 4d15851..1807cd4 100644 --- a/docs/nested-data-functions/index.html +++ b/docs/nested-data-functions/index.html @@ -9,26 +9,21 @@ <title>Nested Data Functions - 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 current_section "><a href="javascript: void(0);">SQL Reference</a></li> <ul class="current_section"> @@ -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/alter-system-command/">ALTER SYSTEM 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-table-as-ctas-command/">CREATE TABLE AS (CTAS) 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-view-command/">CREATE VIEW 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/describe-command/">DESCRIBE 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/explain-commands/">EXPLAIN Commands</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/select-statements/">SELECT Statements</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-databases-and-show-schemas-command/">SHOW DATABASES and SHOW SCHEMAS 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-files-command/">SHOW FILES 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-tables-command/">SHOW TABLES 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/use-command/">USE 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/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,51 +895,51 @@ <li>Nested Data Functions</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/sql-reference/060-nested-data-functions.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/sql-reference/060-nested-data-functions.md"; target="_blank"><i class="fa fa-pencil-square-o"></i></a> + - <div class="int_title"> - <h1>Nested Data Functions</h1> + <div class="int_title left"> + <h1>Nested Data Functions</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/nested-data-limitations/">Nested Data Limitations</a></li> - + <div class="int_text" align="left"> + + <ul> - <li><a href="/docs/flatten/">FLATTEN</a></li> - + <li><a href="/docs/nested-data-limitations/">Nested Data Limitations</a></li> - <li><a href="/docs/kvgen/">KVGEN</a></li> - + + <li><a href="/docs/flatten/">FLATTEN</a></li> - <li><a href="/docs/repeated-count/">REPEATED_COUNT</a></li> - + + <li><a href="/docs/kvgen/">KVGEN</a></li> - <li><a href="/docs/repeated-contains/">REPEATED_CONTAINS</a></li> - + + <li><a href="/docs/repeated-count/">REPEATED_COUNT</a></li> - </ul> + <li><a href="/docs/repeated-contains/">REPEATED_CONTAINS</a></li> - <div class="doc-nav"> + + </ul> + + + <div class="doc-nav"> <span class="previous-toc"><a href="/docs/functions-for-handling-nulls/">â Functions for Handling Nulls</a></span><span class="next-toc"><a href="/docs/nested-data-limitations/">Nested Data Limitations â</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/nested-data-limitations/index.html ---------------------------------------------------------------------- diff --git a/docs/nested-data-limitations/index.html b/docs/nested-data-limitations/index.html index 9507e78..cb09e2a 100644 --- a/docs/nested-data-limitations/index.html +++ b/docs/nested-data-limitations/index.html @@ -9,26 +9,21 @@ <title>Nested Data Limitations - 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 current_section "><a href="javascript: void(0);">SQL Reference</a></li> <ul class="current_section"> @@ -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,35 +897,35 @@ <li>Nested Data Limitations</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/sql-reference/nested-data-functions/005-nested-data-limitations.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/sql-reference/nested-data-functions/005-nested-data-limitations.md"; target="_blank"><i class="fa fa-pencil-square-o"></i></a> + - <div class="int_title"> - <h1>Nested Data Limitations</h1> + <div class="int_title left"> + <h1>Nested Data Limitations</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>Do not use Map, Array, and repeated scalar types in GROUP BY or ORDER BY clauses or in a comparison operator. Drill does not support comparisons between VARCHAR:REPEATED and VARCHAR:REPEATED.</p> + <div class="int_text" align="left"> + + <p>Do not use Map, Array, and repeated scalar types in GROUP BY or ORDER BY clauses or in a comparison operator. Drill does not support comparisons between VARCHAR:REPEATED and VARCHAR:REPEATED.</p> + - - <div class="doc-nav"> + <div class="doc-nav"> <span class="previous-toc"><a href="/docs/nested-data-functions/">â Nested Data Functions</a></span><span class="next-toc"><a href="/docs/flatten/">FLATTEN â</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/odbc-jdbc-interfaces/index.html ---------------------------------------------------------------------- diff --git a/docs/odbc-jdbc-interfaces/index.html b/docs/odbc-jdbc-interfaces/index.html index 632f484..27629c2 100644 --- a/docs/odbc-jdbc-interfaces/index.html +++ b/docs/odbc-jdbc-interfaces/index.html @@ -9,26 +9,21 @@ <title>ODBC/JDBC Interfaces - 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/alter-system-command/">ALTER SYSTEM 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-table-as-ctas-command/">CREATE TABLE AS (CTAS) 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/create-view-command/">CREATE VIEW 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/describe-command/">DESCRIBE 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/explain-commands/">EXPLAIN Commands</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/select-statements/">SELECT Statements</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-databases-and-show-schemas-command/">SHOW DATABASES and SHOW SCHEMAS 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-files-command/">SHOW FILES 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/show-tables-command/">SHOW TABLES 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/use-command/">USE 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-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,101 +886,104 @@ </aside> - <nav class="breadcrumbs"> +<nav class="breadcrumbs"> <li><a href="/docs/">Docs</a></li> <li>ODBC/JDBC Interfaces</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/060-odbc-jdbc-interfaces.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/060-odbc-jdbc-interfaces.md"; target="_blank"><i class="fa fa-pencil-square-o"></i></a> + - <div class="int_title"> - <h1>ODBC/JDBC Interfaces</h1> + <div class="int_title left"> + <h1>ODBC/JDBC Interfaces</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"> + <div class="int_text" align="left"> + + <ul> + + <li><a href="/docs/interfaces-introduction/">Interfaces Introduction</a></li> + + + <li><a href="/docs/using-jdbc-with-squirrel-on-windows/">Using JDBC with SQuirreL on Windows</a></li> + + + <li><a href="/docs/using-odbc-on-linux-and-mac-os-x/">Using ODBC on Linux and Mac OS X</a></li> <ul> - <li><a href="/docs/interfaces-introduction/">Interfaces Introduction</a></li> - + <li><a href="/docs/odbc-on-linux-and-mac-introduction/">ODBC on Linux and Mac Introduction</a></li> - <li><a href="/docs/using-jdbc/">Using JDBC</a></li> - + <li><a href="/docs/installing-the-driver-on-linux/">Installing the Driver on Linux</a></li> - <li><a href="/docs/using-odbc-on-linux-and-mac-os-x/">Using ODBC on Linux and Mac OS X</a></li> - - <ul> - - <li><a href="/docs/odbc-on-linux-and-mac-introduction/">ODBC on Linux and Mac Introduction</a></li> - - <li><a href="/docs/installing-the-driver-on-linux/">Installing the Driver on Linux</a></li> - - <li><a href="/docs/installing-the-driver-on-mac-os-x/">Installing the Driver on Mac OS X</a></li> - - <li><a href="/docs/configuring-connections-on-linux-and-mac-os-x/">Configuring Connections on Linux and Mac OS X</a></li> - - <li><a href="/docs/driver-configuration-options/">Driver Configuration Options</a></li> - - <li><a href="/docs/using-a-connection-string/">Using a Connection String</a></li> - - <li><a href="/docs/advanced-properties/">Advanced Properties</a></li> - - <li><a href="/docs/testing-the-odbc-connection/">Testing the ODBC Connection</a></li> - - </ul> + <li><a href="/docs/installing-the-driver-on-mac-os-x/">Installing the Driver on Mac OS X</a></li> + <li><a href="/docs/configuring-connections-on-linux-and-mac-os-x/">Configuring Connections on Linux and Mac OS X</a></li> - <li><a href="/docs/using-odbc-on-windows/">Using ODBC on Windows</a></li> - - <ul> - - <li><a href="/docs/installing-the-driver-on-windows/">Installing the Driver on Windows</a></li> - - <li><a href="/docs/configuring-connections-on-windows/">Configuring Connections on Windows</a></li> - - <li><a href="/docs/connecting-to-odbc-data-sources/">Connecting to ODBC Data Sources</a></li> - - <li><a href="/docs/tableau-examples/">Tableau Examples</a></li> - - <li><a href="/docs/using-drill-explorer-on-windows/">Using Drill Explorer on Windows</a></li> - - </ul> + <li><a href="/docs/driver-configuration-options/">Driver Configuration Options</a></li> + <li><a href="/docs/using-a-connection-string/">Using a Connection String</a></li> - <li><a href="/docs/using-microstrategy-analytics-with-apache-drill/">Using MicroStrategy Analytics with Apache Drill</a></li> - + <li><a href="/docs/advanced-properties/">Advanced Properties</a></li> - <li><a href="/docs/using-tibco-spotfire-with-drill/">Using Tibco Spotfire with Drill</a></li> - + <li><a href="/docs/testing-the-odbc-connection/">Testing the ODBC Connection</a></li> - <li><a href="/docs/using-apache-drill-with-tableau-9-desktop/">Using Apache Drill with Tableau 9 Desktop</a></li> - + </ul> + + + <li><a href="/docs/using-odbc-on-windows/">Using ODBC on Windows</a></li> - <li><a href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li> + <ul> + <li><a href="/docs/installing-the-driver-on-windows/">Installing the Driver on Windows</a></li> + + <li><a href="/docs/configuring-connections-on-windows/">Configuring Connections on Windows</a></li> + + <li><a href="/docs/connecting-to-odbc-data-sources/">Connecting to ODBC Data Sources</a></li> + + <li><a href="/docs/tableau-examples/">Tableau Examples</a></li> + + <li><a href="/docs/using-drill-explorer-on-windows/">Using Drill Explorer on Windows</a></li> </ul> + + <li><a href="/docs/using-microstrategy-analytics-with-apache-drill/">Using MicroStrategy Analytics with Apache Drill</a></li> + + + <li><a href="/docs/using-tibco-spotfire-with-drill/">Using Tibco Spotfire with Drill</a></li> + + + <li><a href="/docs/configuring-tibco-spotfire-server-with-drill/">Configuring Tibco Spotfire Server with Drill</a></li> + + + <li><a href="/docs/using-apache-drill-with-tableau-9-desktop/">Using Apache Drill with Tableau 9 Desktop</a></li> + + + <li><a href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li> - <div class="doc-nav"> + + </ul> + + + <div class="doc-nav"> <span class="previous-toc"><a href="/docs/mapr-db-format/">â MapR-DB Format</a></span><span class="next-toc"><a href="/docs/interfaces-introduction/">Interfaces 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/odbc-on-linux-and-mac-introduction/index.html ---------------------------------------------------------------------- diff --git a/docs/odbc-on-linux-and-mac-introduction/index.html b/docs/odbc-on-linux-and-mac-introduction/index.html index 9a8a7d4..017f511 100644 --- a/docs/odbc-on-linux-and-mac-introduction/index.html +++ b/docs/odbc-on-linux-and-mac-introduction/index.html @@ -9,26 +9,21 @@ <title>ODBC on Linux and Mac Introduction - 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,40 +897,40 @@ <li>ODBC on Linux and Mac Introduction</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/odbc-jdbc-interfaces/using-odbc-on-linux-and-mac-os-x/005-odbc-on-linux-and-mac-introduction.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/odbc-jdbc-interfaces/using-odbc-on-linux-and-mac-os-x/005-odbc-on-linux-and-mac-introduction.md"; target="_blank"><i class="fa fa-pencil-square-o"></i></a> + - <div class="int_title"> - <h1>ODBC on Linux and Mac Introduction</h1> + <div class="int_title left"> + <h1>ODBC on Linux and Mac Introduction</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>The MapR Drill ODBC driver provides BI tools access to Drillâs flexible query + <div class="int_text" align="left"> + + <p>The MapR Drill ODBC driver provides BI tools access to Drillâs flexible query capabilities so you can quickly explore various data sources. Once you install the MapR Drill ODBC Driver, you can configure ODBC connections to access Drill from BI tools through the connections. 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.</p> + - - <div class="doc-nav"> + <div class="doc-nav"> <span class="previous-toc"><a href="/docs/using-odbc-on-linux-and-mac-os-x/">â Using ODBC on Linux and Mac OS X</a></span><span class="next-toc"><a href="/docs/installing-the-driver-on-linux/">Installing the Driver on Linux â</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/operators/index.html ---------------------------------------------------------------------- diff --git a/docs/operators/index.html b/docs/operators/index.html index 4149061..dddd0e3 100644 --- a/docs/operators/index.html +++ b/docs/operators/index.html @@ -9,26 +9,21 @@ <title>Operators - 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 current_section "><a href="javascript: void(0);">SQL Reference</a></li> <ul class="current_section"> @@ -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>Operators</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/sql-reference/040-operators.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/sql-reference/040-operators.md"; target="_blank"><i class="fa fa-pencil-square-o"></i></a> + - <div class="int_title"> - <h1>Operators</h1> + <div class="int_title left"> + <h1>Operators</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 use various types of operators in your Drill queries to perform + <div class="int_text" align="left"> + + <p>You can use various types of operators in your Drill queries to perform operations on your data.</p> <h2 id="logical-operators">Logical Operators</h2> @@ -915,7 +994,7 @@ operations on your data.</p> <li>IN</li> </ul> -<p>See <a href="/docs/select-statements">SELECT Statements</a>.</p> +<p>See <a href="/docs/select">SELECT Statements</a>.</p> <h2 id="string-concatenate-operator">String Concatenate Operator</h2> @@ -930,17 +1009,17 @@ operations on your data.</p> <p>The concat function treats NULL as an empty string. The concatenate operator (||) returns NULL if any input is NULL.</p> + - - <div class="doc-nav"> + <div class="doc-nav"> <span class="previous-toc"><a href="/docs/lexical-structure/">â Lexical Structure</a></span><span class="next-toc"><a href="/docs/sql-functions/">SQL Functions â</a></span> </div> - - </div> + </div> </div> +</div> </div> <p class="push"></p>
