You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by ts...@apache.org on 2015/05/19 01:39:09 UTC
[34/51] [partial] drill-site git commit: Website update
http://git-wip-us.apache.org/repos/asf/drill-site/blob/ee640eab/docs/data-sources-and-file-formats/index.html
----------------------------------------------------------------------
diff --git a/docs/data-sources-and-file-formats/index.html b/docs/data-sources-and-file-formats/index.html
index c9c9fa2..11ca9cf 100644
--- a/docs/data-sources-and-file-formats/index.html
+++ b/docs/data-sources-and-file-formats/index.html
@@ -9,26 +9,21 @@
<title>Data Sources and File Formats - 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/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,58 +886,58 @@
</aside>
- <nav class="breadcrumbs">
+<nav class="breadcrumbs">
<li><a href="/docs/">Docs</a></li>
<li>Data Sources and File Formats</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/090-data-sources-and-file-formats.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/090-data-sources-and-file-formats.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
+
- <div class="int_title">
- <h1>Data Sources and File Formats</h1>
+ <div class="int_title left">
+ <h1>Data Sources and File Formats</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/data-sources-and-file-formats-introduction/">Data Sources and File Formats Introduction</a></li>
-
+ <div class="int_text" align="left">
+
+ <ul>
- <li><a href="/docs/hive-to-drill-data-type-mapping/">Hive-to-Drill Data Type Mapping</a></li>
-
+ <li><a href="/docs/data-sources-and-file-formats-introduction/">Data Sources and File Formats Introduction</a></li>
- <li><a href="/docs/deploying-and-using-a-hive-udf/">Deploying and Using a Hive UDF</a></li>
-
+
+ <li><a href="/docs/hive-to-drill-data-type-mapping/">Hive-to-Drill Data Type Mapping</a></li>
- <li><a href="/docs/parquet-format/">Parquet Format</a></li>
-
+
+ <li><a href="/docs/deploying-and-using-a-hive-udf/">Deploying and Using a Hive UDF</a></li>
- <li><a href="/docs/json-data-model/">JSON Data Model</a></li>
-
+
+ <li><a href="/docs/parquet-format/">Parquet Format</a></li>
- </ul>
+ <li><a href="/docs/json-data-model/">JSON Data Model</a></li>
- <div class="doc-nav">
+
+ </ul>
+
+
+ <div class="doc-nav">
<span class="previous-toc"><a href="/docs/sql-extensions/">← SQL Extensions</a></span><span class="next-toc"><a href="/docs/data-sources-and-file-formats-introduction/">Data Sources and File Formats 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/data-type-conversion/index.html
----------------------------------------------------------------------
diff --git a/docs/data-type-conversion/index.html b/docs/data-type-conversion/index.html
index 303e5fb..b704777 100644
--- a/docs/data-type-conversion/index.html
+++ b/docs/data-type-conversion/index.html
@@ -9,26 +9,21 @@
<title>Data Type Conversion - 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>
@@ -818,23 +897,23 @@
<li>Data Type Conversion</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/sql-functions/020-data-type-conversion.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/sql-functions/020-data-type-conversion.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
+
- <div class="int_title">
- <h1>Data Type Conversion</h1>
+ <div class="int_title left">
+ <h1>Data Type Conversion</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>Drill supports the following functions for casting and converting data types:</p>
+ <div class="int_text" align="left">
+
+ <p>Drill supports the following functions for casting and converting data types:</p>
<ul>
<li><a href="/docs/data-type-conversion#cast">CAST</a></li>
@@ -862,6 +941,11 @@
<p>If the SELECT statement includes a WHERE clause that compares a column of an unknown data type, cast both the value of the column and the comparison value in the WHERE clause. For example:</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT c_row, CAST(c_int AS DECIMAL(28,8)) FROM mydata WHERE CAST(c_int AS DECIMAL(28,8)) > -3.0;
</code></pre></div>
+<div class="admonition note">
+ <p class="first admonition-title">Note</p>
+ <p class="last">In this release, Drill disables the DECIMAL data type. To enable, set the planner.enable_decimal_data_type option to true. </p>
+</div>
+
<p>Use CONVERT_TO and CONVERT_FROM instead of the CAST function for converting binary data types with one exception: 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>
<p>Refer to the following tables for information about the data types to use for casting:</p>
@@ -879,6 +963,11 @@
<p>You cannot cast a character string that includes a decimal point to an INT or BIGINT. For example, if you have "1200.50" in a JSON file, attempting to select and cast the string to an INT fails. As a workaround, cast to a FLOAT or DECIMAL type, and then to an INT. </p>
+<div class="admonition note">
+ <p class="first admonition-title">Note</p>
+ <p class="last">In this release, Drill disables the DECIMAL data type. To enable, set the planner.enable_decimal_data_type option to true. </p>
+</div>
+
<p>The following example shows how to cast a character to a DECIMAL having two decimal places.</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CAST('1' as DECIMAL(28, 2)) FROM sys.version;
+------------+
@@ -910,13 +999,17 @@ SELECT CAST(456 as CHAR(3)) FROM sys.version;
<p>Cast an integer to a decimal.</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CAST(-2147483648 AS DECIMAL(28,8)) FROM sys.version;
-+------------+
-| EXPR$0 |
-+------------+
-| -2.147483648E9 |
-+------------+
-1 row selected (0.08 seconds)
++-----------------+
+| EXPR$0 |
++-----------------+
+| -2.147483648E9 |
++-----------------+
</code></pre></div>
+<div class="admonition note">
+ <p class="first admonition-title">Note</p>
+ <p class="last">In this release, Drill disables the DECIMAL data type. To enable, set the planner.enable_decimal_data_type option to true. </p>
+</div>
+
<h3 id="casting-intervals">Casting Intervals</h3>
<p>To cast interval data to the INTERVALDAY or INTERVALYEAR types use the following syntax:</p>
@@ -932,12 +1025,12 @@ CAST (column_name AS INTERVAL YEAR)
<li><p>Set the storage format to Parquet.</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">ALTER SESSION SET `store.format` = 'parquet';
-+------------+------------+
-| ok | summary |
-+------------+------------+
-| true | store.format updated. |
-+------------+------------+
-1 row selected (0.037 seconds)
++-------+------------------------+
+| ok | summary |
++-------+------------------------+
+| true | store.format updated. |
++-------+------------------------+
+1 row selected (0.072 seconds)
</code></pre></div></li>
<li><p>Use a CTAS statement to cast text from a JSON file to year and day intervals and to write the data to a Parquet table:</p>
@@ -975,14 +1068,14 @@ data as encoded VARBINARY data. To read HBase data in Drill, convert every colum
SELECT * FROM students;
-+------------+------------+------------+
-| 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="} |
++-------------+---------------------+---------------------------------------------------------------------------+
+| 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>You use the CONVERT_FROM function to decode the binary data to render it readable, selecting a data type to use from the <a href="/docs/data-type-conversion/#convert_to-and-convert_from-data-types">list of supported types</a>. JSON supports strings. To convert binary to strings, use the UTF8 type.:</p>
@@ -992,24 +1085,24 @@ SELECT * FROM students;
CONVERT_FROM(students.address.street, 'UTF8') AS street,
CONVERT_FROM(students.address.zipcode, 'UTF8') AS zipcode FROM students;
-+------------+------------+------------+------------+------------+
-| 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 |
++------------+------------+------------+------------------+------------+
+| 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>
<p>This example converts from VARCHAR to a JSON map:</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CONVERT_FROM('{x:100, y:215.6}' ,'JSON') AS MYCOL FROM sys.version;
-+------------+
-| MYCOL |
-+------------+
-| {"x":100,"y":215.6} |
-+------------+
-1 row selected (0.073 seconds)
++----------------------+
+| MYCOL |
++----------------------+
+| {"x":100,"y":215.6} |
++----------------------+
+1 row selected (0.163 seconds)
</code></pre></div>
<p>This example uses a list of BIGINT as input and returns a repeated list of vectors:</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CONVERT_FROM('[ [1, 2], [3, 4], [5]]' ,'JSON') AS MYCOL1 FROM sys.version;
@@ -1022,12 +1115,12 @@ SELECT * FROM students;
</code></pre></div>
<p>This example uses a map as input to return a repeated list vector (JSON).</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CONVERT_FROM('[{a : 100, b: 200}, {a:300, b: 400}]' ,'JSON') AS MYCOL1 FROM sys.version;
-+------------+
-| MYCOL1 |
-+------------+
-| [{"a":100,"b":200},{"a":300,"b":400}] |
-+------------+
-1 row selected (0.074 seconds)
++--------------------+
+| MYCOL1 |
++--------------------+
+| [[1,2],[3,4],[5]] |
++--------------------+
+1 row selected (0.141 seconds)
</code></pre></div>
<h3 id="set-up-a-storage-plugin-for-working-with-hbase-files">Set Up a Storage Plugin for Working with HBase Files</h3>
@@ -1127,12 +1220,12 @@ ls
</code></pre></div></li>
<li><p>Set up Drill to store data in Parquet format.</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">ALTER SESSION SET `store.format`='parquet';
-+------------+------------+
-| ok | summary |
-+------------+------------+
-| true | store.format updated. |
-+------------+------------+
-1 row selected (0.056 seconds)
++-------+------------------------+
+| ok | summary |
++-------+------------------------+
+| true | store.format updated. |
++-------+------------------------+
+1 row selected (0.07 seconds)
</code></pre></div></li>
<li><p>Use CONVERT_TO to convert the JSON data to a binary format in the Parquet file.</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">CREATE TABLE tmp.`json2parquet` AS SELECT
@@ -1152,14 +1245,14 @@ FROM tmp.`to_json`;
</code></pre></div></li>
<li><p>Take a look at the binary Parquet output:</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT * FROM tmp.`json2parquet`;
-+------------+------------+------------+------------+------------+
-| id | name | state | street | zip |
-+------------+------------+------------+------------+------------+
++-------------+-------------+-------------+-------------+-------------+
+| id | name | state | street | zip |
++-------------+-------------+-------------+-------------+-------------+
| [B@224388b2 | [B@7fc36fb0 | [B@77d9cd57 | [B@7c384839 | [B@530dd5e5 |
-| [B@3155d7fc | [B@7ad6fab1 | [B@37e4b978 | [B@94c91f3 | [B@201ed4a |
+| [B@3155d7fc | [B@7ad6fab1 | [B@37e4b978 | [B@94c91f3 | [B@201ed4a |
| [B@4fb2c078 | [B@607a2f28 | [B@75ae1c93 | [B@79d63340 | [B@5dbeed3d |
-| [B@2fcfec74 | [B@7baccc31 | [B@d91e466 | [B@6529eb7f | [B@232412bc |
-+------------+------------+------------+------------+------------+
+| [B@2fcfec74 | [B@7baccc31 | [B@d91e466 | [B@6529eb7f | [B@232412bc |
++-------------+-------------+-------------+-------------+-------------+
4 rows selected (0.12 seconds)
</code></pre></div></li>
<li><p>Use CONVERT_FROM to convert the Parquet data to a readable format:</p>
@@ -1170,14 +1263,14 @@ FROM tmp.`to_json`;
CONVERT_FROM(zip, 'UTF8') AS zip
FROM tmp.`json2parquet2`;
-+------------+------------+------------+------------+------------+
-| id | name | state | address | zip |
-+------------+------------+------------+------------+------------+
-| student1 | Alice | CA | 123 Ballmer Av | 12345 |
-| student2 | Bob | CA | 1 Infinite Loop | 12345 |
-| student3 | Frank | CA | 435 Walker Ct | 12345 |
++------------+------------+------------+------------------+------------+
+| id | name | state | address | zip |
++------------+------------+------------+------------------+------------+
+| 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.182 seconds)
</code></pre></div></li>
</ol>
@@ -1487,11 +1580,12 @@ use in your Drill queries as described in this section:</p>
</code></pre></div>
<p>Convert a date to a character string.</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_CHAR((CAST('2008-2-23' AS DATE)), 'yyyy-MMM-dd') FROM sys.version;
-+------------+
-| EXPR$0 |
-+------------+
-| 2008-Feb-23 |
-+------------+
++--------------+
+| EXPR$0 |
++--------------+
+| 2008-Feb-23 |
++--------------+
+1 row selected (0.166 seconds)
</code></pre></div>
<p>Convert a time to a string.</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_CHAR(CAST('12:20:30' AS TIME), 'HH mm ss') FROM sys.version;
@@ -1504,12 +1598,12 @@ use in your Drill queries as described in this section:</p>
</code></pre></div>
<p>Convert a timestamp to a string.</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_CHAR(CAST('2015-2-23 12:00:00' AS TIMESTAMP), 'yyyy MMM dd HH:mm:ss') FROM sys.version;
-+------------+
-| EXPR$0 |
-+------------+
-| 2015 Feb 23 12:00:00 |
-+------------+
-1 row selected (0.075 seconds)
++-----------------------+
+| EXPR$0 |
++-----------------------+
+| 2015 Feb 23 12:00:00 |
++-----------------------+
+1 row selected (0.142 seconds)
</code></pre></div>
<h2 id="to_date">TO_DATE</h2>
@@ -1684,32 +1778,33 @@ SELECT TO_NUMBER('12345', '##0.##E0') FROM sys.version;
<p>Convert a date to a timestamp. </p>
<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_TIMESTAMP('2008-2-23 12:00:00', 'yyyy-MM-dd HH:mm:ss') FROM sys.version;
-+------------+
-| EXPR$0 |
-+------------+
-| 2008-02-23 12:00:00.0 |
-+------------+
++------------------------+
+| EXPR$0 |
++------------------------+
+| 2008-02-23 12:00:00.0 |
++------------------------+
+1 row selected (0.126 seconds)
</code></pre></div>
<p>Convert Unix Epoch time to a timestamp.</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_TIMESTAMP(1427936330) FROM sys.version;
-+------------+
-| EXPR$0 |
-+------------+
-| 2015-04-01 17:58:50.0 |
-+------------+
-1 row selected (0.094 seconds)
++------------------------+
+| EXPR$0 |
++------------------------+
+| 2015-04-01 17:58:50.0 |
++------------------------+
+1 row selected (0.114 seconds)
</code></pre></div>
<p>Convert a UTC date to a timestamp offset from the UTC time zone code.</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_TIMESTAMP('2015-03-30 20:49:59.0 UTC', 'YYYY-MM-dd HH:mm:ss.s z') AS Original,
TO_CHAR(TO_TIMESTAMP('2015-03-30 20:49:59.0 UTC', 'YYYY-MM-dd HH:mm:ss.s z'), 'z') AS New_TZ
FROM sys.version;
-+------------+------------+
-| Original | New_TZ |
-+------------+------------+
-| 2015-03-30 20:49:00.0 | UTC |
-+------------+------------+
-1 row selected (0.129 seconds)
++------------------------+---------+
+| Original | New_TZ |
++------------------------+---------+
+| 2015-03-30 20:49:00.0 | UTC |
++------------------------+---------+
+1 row selected (0.148 seconds)
</code></pre></div>
<h2 id="time-zone-limitation">Time Zone Limitation</h2>
@@ -1719,26 +1814,26 @@ FROM sys.version;
<li><p>Take a look at the Drill time zone configuration by running the TIMEOFDAY function or by querying the system.options table. This TIMEOFDAY function returns the local date and time with time zone information. </p>
<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TIMEOFDAY() FROM sys.version;
-+------------+
-| EXPR$0 |
-+------------+
-| 2015-04-02 15:01:31.114 America/Los_Angeles |
-+------------+
-1 row selected (1.199 seconds)
++----------------------------------------------+
+| EXPR$0 |
++----------------------------------------------+
+| 2015-05-17 22:37:29.516 America/Los_Angeles |
++----------------------------------------------+
+1 row selected (0.108 seconds)
</code></pre></div></li>
<li><p>Configure the default time zone format in <drill installation directory>/conf/drill-env.sh by adding <code>-Duser.timezone=UTC</code> to DRILL_JAVA_OPTS. For example:</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">export DRILL_JAVA_OPTS="-Xms1G -Xmx$DRILL_MAX_HEAP -XX:MaxDirectMemorySize=$DRILL_MAX_DIRECT_MEMORY -XX:MaxPermSize=512M -XX:ReservedCodeCacheSize=1G -ea -Duser.timezone=UTC"
</code></pre></div></li>
-<li><p>Restart SQLLine.</p></li>
+<li><p>Restart the Drill shell.</p></li>
<li><p>Confirm that Drill is now set to UTC:</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TIMEOFDAY() FROM sys.version;
-+------------+
-| EXPR$0 |
-+------------+
-| 2015-04-02 17:05:02.424 UTC |
-+------------+
-1 row selected (1.191 seconds)
++----------------------------------------------+
+| EXPR$0 |
++----------------------------------------------+
+| 2015-05-17 22:37:57.082 America/Los_Angeles |
++----------------------------------------------+
+1 row selected (0.087 seconds)
</code></pre></div></li>
</ol>
@@ -1747,12 +1842,12 @@ FROM sys.version;
TO_CHAR(TO_TIMESTAMP('2015-03-30 20:49:59.0 UTC', 'YYYY-MM-dd HH:mm:ss.s z'), 'z') AS TimeZone
FROM sys.version;
-+------------+------------+
-| Original | TimeZone |
-+------------+------------+
-| 2015-03-30 20:49:00.0 | UTC |
-+------------+------------+
-1 row selected (0.299 seconds)
++------------------------+-----------+
+| Original | TimeZone |
++------------------------+-----------+
+| 2015-03-30 20:49:00.0 | UTC |
++------------------------+-----------+
+1 row selected (0.097 seconds)
</code></pre></div>
<!-- DRILL-448 Support timestamp with time zone -->
@@ -1762,17 +1857,17 @@ ISNUMERIC should be implemented as a SQL function
SELECT count(columns[0]) as number FROM dfs.`bla` WHERE ISNUMERIC(columns[0])=1
-->
+
-
- <div class="doc-nav">
+ <div class="doc-nav">
<span class="previous-toc"><a href="/docs/math-and-trig/">← Math and Trig</a></span><span class="next-toc"><a href="/docs/date-time-functions-and-arithmetic/">Date/Time Functions and Arithmetic →</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/data-types/index.html
----------------------------------------------------------------------
diff --git a/docs/data-types/index.html b/docs/data-types/index.html
index feb4d47..e7f1559 100644
--- a/docs/data-types/index.html
+++ b/docs/data-types/index.html
@@ -9,26 +9,21 @@
<title>Data Types - 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/alter-system-command/">ALTER SYSTEM Command</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/create-table-as-ctas-command/">CREATE TABLE AS (CTAS) 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-view-command/">CREATE VIEW 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/describe-command/">DESCRIBE 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/explain-commands/">EXPLAIN Commands</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-statements/">SELECT Statements</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/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-group-by/">SELECT GROUP 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-having/">SELECT HAVING</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-limit/">SELECT LIMIT</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-offset/">SELECT OFFSET</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,45 +895,45 @@
<li>Data Types</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/020-data-types.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/020-data-types.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
+
- <div class="int_title">
- <h1>Data Types</h1>
+ <div class="int_title left">
+ <h1>Data Types</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/supported-data-types/">Supported Data Types</a></li>
-
+ <div class="int_text" align="left">
+
+ <ul>
- <li><a href="/docs/date-time-and-timestamp/">Date, Time, and Timestamp</a></li>
-
+ <li><a href="/docs/supported-data-types/">Supported Data Types</a></li>
- <li><a href="/docs/handling-different-data-types/">Handling Different Data Types</a></li>
-
+
+ <li><a href="/docs/date-time-and-timestamp/">Date, Time, and Timestamp</a></li>
- </ul>
+ <li><a href="/docs/handling-different-data-types/">Handling Different Data Types</a></li>
- <div class="doc-nav">
+
+ </ul>
+
+
+ <div class="doc-nav">
<span class="previous-toc"><a href="/docs/sql-reference-introduction/">← SQL Reference Introduction</a></span><span class="next-toc"><a href="/docs/supported-data-types/">Supported Data Types →</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/date-time-and-timestamp/index.html
----------------------------------------------------------------------
diff --git a/docs/date-time-and-timestamp/index.html b/docs/date-time-and-timestamp/index.html
index 9e24d69..6c94c6b 100644
--- a/docs/date-time-and-timestamp/index.html
+++ b/docs/date-time-and-timestamp/index.html
@@ -9,26 +9,21 @@
<title>Date, Time, and Timestamp - 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,23 +897,23 @@
<li>Date, Time, and Timestamp</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/data-types/020-date-time-and-timestamp.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/data-types/020-date-time-and-timestamp.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
+
- <div class="int_title">
- <h1>Date, Time, and Timestamp</h1>
+ <div class="int_title left">
+ <h1>Date, Time, and Timestamp</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>Using familiar date and time formats, listed in the <a href="/docs/data-types/data-types">SQL data types table</a>, you can construct query date and time data. You need to cast textual data to date and time data types. The format of date, time, and timestamp text in a textual data source needs to match the SQL query format for successful casting. </p>
+ <div class="int_text" align="left">
+
+ <p>Using familiar date and time formats, listed in the <a href="/docs/data-types/data-types">SQL data types table</a>, you can construct query date and time data. You need to cast textual data to date and time data types. The format of date, time, and timestamp text in a textual data source needs to match the SQL query format for successful casting. </p>
<p>DATE, TIME, and TIMESTAMP store values in Coordinated Universal Time (UTC). Drill supports time functions in the range 1971 to 2037.</p>
@@ -948,17 +1027,17 @@ SELECT INTERVAL '13' month FROM sys.version;
</code></pre></div>
<p>For information about casting interval data, see the <a href="/docs/data-type-conversion#cast">"CAST"</a> function.</p>
+
-
- <div class="doc-nav">
+ <div class="doc-nav">
<span class="previous-toc"><a href="/docs/supported-data-types/">← Supported Data Types</a></span><span class="next-toc"><a href="/docs/handling-different-data-types/">Handling Different Data Types →</a></span>
</div>
-
- </div>
+
</div>
</div>
+</div>
</div>
<p class="push"></p>