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:08 UTC
[33/51] [partial] drill-site git commit: Website update
http://git-wip-us.apache.org/repos/asf/drill-site/blob/ee640eab/docs/date-time-functions-and-arithmetic/index.html
----------------------------------------------------------------------
diff --git a/docs/date-time-functions-and-arithmetic/index.html b/docs/date-time-functions-and-arithmetic/index.html
index 8f7e170..a38e244 100644
--- a/docs/date-time-functions-and-arithmetic/index.html
+++ b/docs/date-time-functions-and-arithmetic/index.html
@@ -9,26 +9,21 @@
<title>Date/Time Functions and Arithmetic - 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/alter-system-command/">ALTER SYSTEM 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/create-table-as-ctas-command/">CREATE TABLE AS (CTAS) 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-view-command/">CREATE VIEW 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/describe-command/">DESCRIBE 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/explain-commands/">EXPLAIN Commands</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-statements/">SELECT Statements</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-databases-and-show-schemas-command/">SHOW DATABASES and SHOW SCHEMAS 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/show-files-command/">SHOW FILES 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-tables-command/">SHOW TABLES 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/use-command/">USE 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/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,25 +897,25 @@
<li>Date/Time Functions and Arithmetic</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/030-date-time-functions-and-arithmetic.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/030-date-time-functions-and-arithmetic.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
+
- <div class="int_title">
- <h1>Date/Time Functions and Arithmetic</h1>
+ <div class="int_title left">
+ <h1>Date/Time Functions and Arithmetic</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>In addition to the TO_DATE, TO_TIME, and TO_TIMESTAMP functions, Drill supports a number of other date/time functions and arithmetic operators for use with dates, times, and intervals. Drill supports time functions based on the Gregorian calendar and in the range 1971 to 2037.</p>
+ <div class="int_text" align="left">
+
+ <p>In addition to the TO_DATE, TO_TIME, and TO_TIMESTAMP functions, Drill supports a number of other date/time functions and arithmetic operators for use with dates, times, and intervals. Drill supports time functions based on the Gregorian calendar and in the range 1971 to 2037.</p>
-<p>This section defines the following date/time functions:</p>
+<p>This section covers the Drill <a href="/docs/data-type-conversion/#time-zone-limitation">time zone limitation</a> and defines the following date/time functions:</p>
<table><thead>
<tr>
@@ -853,15 +932,15 @@
<td>DOUBLE</td>
</tr>
<tr>
-<td><a href="/docs/date-time-functions-and-arithmetic#current_*x*-local*x*-now-and-timeofday">CURRENT_DATE</a></td>
+<td><a href="/docs/date-time-functions-and-arithmetic/#other-date-and-time-functions">CURRENT_DATE</a></td>
<td>DATE</td>
</tr>
<tr>
-<td><a href="/docs/date-time-functions-and-arithmetic#current_*x*-local*x*-now-and-timeofday">CURRENT_TIME</a></td>
+<td><a href="/docs/date-time-functions-and-arithmetic/#other-date-and-time-functions">CURRENT_TIME</a></td>
<td>TIME</td>
</tr>
<tr>
-<td><a href="/docs/date-time-functions-and-arithmetic#current_*x*-local*x*-now-and-timeofday">CURRENT_TIMESTAMP</a></td>
+<td><a href="/docs/date-time-functions-and-arithmetic/#other-date-and-time-functions">CURRENT_TIMESTAMP</a></td>
<td>TIMESTAMP</td>
</tr>
<tr>
@@ -877,19 +956,19 @@
<td>DATE, TIMESTAMOP</td>
</tr>
<tr>
-<td><a href="/docs/date-time-functions-and-arithmetic#current_*x*-local*x*-now-and-timeofday">LOCALTIME</a></td>
+<td><a href="/docs/date-time-functions-and-arithmetic/#other-date-and-time-functions">LOCALTIME</a></td>
<td>TIME</td>
</tr>
<tr>
-<td><a href="/docs/date-time-functions-and-arithmetic#current_*x*-local*x*-now-and-timeofday">LOCALTIMESTAMP</a></td>
+<td><a href="/docs/date-time-functions-and-arithmetic/#other-date-and-time-functions">LOCALTIMESTAMP</a></td>
<td>TIMESTAMP</td>
</tr>
<tr>
-<td><a href="/docs/date-time-functions-and-arithmetic#current_*x*-local*x*-now-and-timeofday">NOW</a></td>
+<td><a href="/docs/date-time-functions-and-arithmetic/#other-date-and-time-functions">NOW</a></td>
<td>TIMESTAMP</td>
</tr>
<tr>
-<td><a href="/docs/date-time-functions-and-arithmetic#current_*x*-local*x*-now-and-timeofday">TIMEOFDAY</a></td>
+<td><a href="/docs/date-time-functions-and-arithmetic/#other-date-and-time-functions">TIMEOFDAY</a></td>
<td>VARCHAR</td>
</tr>
</tbody></table>
@@ -920,14 +999,14 @@
</code></pre></div>
<p>Find the interval between 11:10:10 PM on January 1, 2001 and 10:10:10 PM on January 1, 2001.</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT AGE(CAST('2010-01-01 10:10:10' AS TIMESTAMP), CAST('2001-01-01 11:10:10' AS TIMESTAMP)) FROM sys.version;
-+------------+
-| EXPR$0 |
-+------------+
-| P109M16DT82800S |
-+------------+
-1 row selected (0.161 seconds)
++------------------+
+| EXPR$0 |
++------------------+
+| P109M16DT82800S |
++------------------+
+1 row selected (0.122 seconds)
</code></pre></div>
-<p>For information about how to read the interval data, see the <a href="/docs/date-time-and-timestamp#interval">Interval section</a>.</p>
+<p>For information about how to read the interval data, see the <a href="/docs/date-time-and-timestamp/#intervalyear-and-intervalday">Interval section</a>.</p>
<h2 id="date_add">DATE_ADD</h2>
@@ -960,21 +1039,21 @@ DATE_ADD(keyword literal, interval expr)
</code></pre></div>
<p>Add two months to April 15, 2015.</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_ADD(date '2015-04-15', interval '2' month) FROM sys.version;
-+------------+
-| EXPR$0 |
-+------------+
-| 2015-06-15 00:00:00.0 |
-+------------+
-1 row selected (0.073 seconds)
++------------------------+
+| EXPR$0 |
++------------------------+
+| 2015-06-15 00:00:00.0 |
++------------------------+
+1 row selected (0.107 seconds)
</code></pre></div>
<p>Add 10 hours to the timestamp 2015-04-15 22:55:55.</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_ADD(timestamp '2015-04-15 22:55:55', interval '10' hour) FROM sys.version;
-+------------+
-| EXPR$0 |
-+------------+
-| 2015-04-16 08:55:55.0 |
-+------------+
-1 row selected (0.068 seconds)
++------------------------+
+| EXPR$0 |
++------------------------+
+| 2015-04-16 08:55:55.0 |
++------------------------+
+1 row selected (0.199 seconds)
</code></pre></div>
<p>Add 10 hours to the time 22 hours, 55 minutes, 55 seconds.</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_ADD(time '22:55:55', interval '10' hour) FROM sys.version;
@@ -987,21 +1066,21 @@ DATE_ADD(keyword literal, interval expr)
</code></pre></div>
<p>Add 1 year and 1 month to the timestamp 2015-04-15 22:55:55.</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_ADD(timestamp '2015-04-15 22:55:55', interval '1-2' year to month) FROM sys.version;
-+------------+
-| EXPR$0 |
-+------------+
-| 2016-06-15 22:55:55.0 |
-+------------+
-1 row selected (0.065 seconds)
++------------------------+
+| EXPR$0 |
++------------------------+
+| 2016-06-15 22:55:55.0 |
++------------------------+
+1 row selected (0.106 seconds)
</code></pre></div>
<p>Add 1 day 2 and 1/2 hours and 45.100 seconds to the time 22:55:55.</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_ADD(time '22:55:55', interval '1 2:30:45.100' day to second) FROM sys.version;
-+------------+
-| EXPR$0 |
-+------------+
-| 01:26:40.100 |
-+------------+
-1 row selected (0.07 seconds)
++---------------+
+| EXPR$0 |
++---------------+
+| 01:26:40.100 |
++---------------+
+1 row selected (0.106 seconds)
</code></pre></div>
<h2 id="date_part">DATE_PART</h2>
@@ -1092,12 +1171,12 @@ DATE_SUB(keyword literal, interval expr)
</code></pre></div>
<p>Subtract 10 hours from the timestamp 2015-04-15 22:55:55.</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_SUB(timestamp '2015-04-15 22:55:55', interval '10' hour) FROM sys.version;
-+------------+
-| EXPR$0 |
-+------------+
-| 2015-04-15 12:55:55.0 |
-+------------+
-1 row selected (0.068 seconds)
++------------------------+
+| EXPR$0 |
++------------------------+
+| 2015-04-15 12:55:55.0 |
++------------------------+
+1 row selected (0.108 seconds)
</code></pre></div>
<p>Subtract 10 hours from the time 22 hours, 55 minutes, 55 seconds.</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_SUB(time '22:55:55', interval '10' hour) FROM sys.version;
@@ -1110,23 +1189,23 @@ DATE_SUB(keyword literal, interval expr)
</code></pre></div>
<p>Subtract 1 year and 1 month from the timestamp 2015-04-15 22:55:55.</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_SUB(timestamp '2015-04-15 22:55:55', interval '1-2' year to month) FROM sys.version;
-+------------+
-| EXPR$0 |
-+------------+
-| 2014-02-15 22:55:55.0 |
-+------------+
-1 row selected (0.073 seconds)
++------------------------+
+| EXPR$0 |
++------------------------+
+| 2014-02-15 22:55:55.0 |
++------------------------+
+1 row selected (0.108 seconds)
</code></pre></div>
<p>Subtract 1 day, 2 and 1/2 hours, and 45.100 seconds from the time 22:55:55.</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_ADD(time '22:55:55', interval '1 2:30:45.100' day to second) FROM sys.version;
-+------------+
-| EXPR$0 |
-+------------+
-| 01:26:40.100 |
-+------------+
-1 row selected (0.073 seconds)
++---------------+
+| EXPR$0 |
++---------------+
+| 01:26:40.100 |
++---------------+
+1 row selected (0.095 seconds)
</code></pre></div>
-<h2 id="current_x,-local*x*,-now,-and-timeofday">CURRENT_<em>x</em>, LOCAL*x*, NOW, and TIMEOFDAY</h2>
+<h2 id="other-date-and-time-functions">Other Date and Time Functions</h2>
<p>The following examples show how to use these functions:</p>
@@ -1155,58 +1234,58 @@ SELECT CURRENT_TIME FROM sys.version;
1 row selected (0.073 seconds)
SELECT CURRENT_TIMESTAMP FROM sys.version;
-+-------------------+
-| current_timestamp |
-+-------------------+
-| 2015-04-02 14:32:34.047 |
-+-------------------+
-1 row selected (0.061 seconds)
++--------------------------+
+| CURRENT_TIMESTAMP |
++--------------------------+
+| 2015-05-17 22:45:55.848 |
++--------------------------+
+1 row selected (0.109 seconds)
SELECT LOCALTIME FROM sys.version;
-+------------+
-| localtime |
-+------------+
-| 14:33:04.95 |
-+------------+
-1 row selected (0.051 seconds)
++---------------+
+| LOCALTIME |
++---------------+
+| 22:46:19.656 |
++---------------+
+1 row selected (0.105 seconds)
SELECT LOCALTIMESTAMP FROM sys.version;
-+----------------+
-| LOCALTIMESTAMP |
-+----------------+
-| 2015-04-02 23:13:13.204 |
-+----------------+
-1 row selected (0.105 seconds)
++--------------------------+
+| LOCALTIMESTAMP |
++--------------------------+
+| 2015-05-17 22:46:47.944 |
++--------------------------+
+1 row selected (0.08 seconds)
SELECT NOW() FROM sys.version;
-+------------+
-| EXPR$0 |
-+------------+
-| 2015-04-02 23:14:30.076 |
-+------------+
-1 row selected (0.05 seconds)
++--------------------------+
+| EXPR$0 |
++--------------------------+
+| 2015-05-17 22:47:11.008 |
++--------------------------+
+1 row selected (0.085 seconds)
</code></pre></div></li>
</ul>
-<p>If you set up Drill for <a href="/docs/casting-converting-data-types/time-zone-limitation">UTC time</a>, TIMEOFDAY returns the result for the UTC time zone.</p>
+<p>If you set up Drill for <a href="/docs/data-type-conversion/#time-zone-limitation">UTC time</a>, TIMEOFDAY returns the result for the UTC time zone.</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TIMEOFDAY() FROM sys.version;
-+------------+
-| EXPR$0 |
-+------------+
++-----------------------------+
+| EXPR$0 |
++-----------------------------+
| 2015-04-02 22:05:02.424 UTC |
-+------------+
++-----------------------------+
1 row selected (1.191 seconds)
</code></pre></div>
<p>If you did not set up Drill for UTC time, TIMEOFDAY 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:47:38.012 America/Los_Angeles |
++----------------------------------------------+
+1 row selected (0.08 seconds)
</code></pre></div>
<h2 id="extract">EXTRACT</h2>
@@ -1294,17 +1373,17 @@ SELECT NOW() FROM sys.version;
+------------+
1 row selected (0.033 seconds)
</code></pre></div>
+
-
- <div class="doc-nav">
+ <div class="doc-nav">
<span class="previous-toc"><a href="/docs/data-type-conversion/">← Data Type Conversion</a></span><span class="next-toc"><a href="/docs/string-manipulation/">String Manipulation →</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/deploying-and-using-a-hive-udf/index.html
----------------------------------------------------------------------
diff --git a/docs/deploying-and-using-a-hive-udf/index.html b/docs/deploying-and-using-a-hive-udf/index.html
index 5ad0fbd..114a3d8 100644
--- a/docs/deploying-and-using-a-hive-udf/index.html
+++ b/docs/deploying-and-using-a-hive-udf/index.html
@@ -9,26 +9,21 @@
<title>Deploying and Using a Hive UDF - Apache Drill</title>
-<link href="/css/syntax.css" rel="stylesheet" type="text/css">
-<link href="/css/style.css" rel="stylesheet" type="text/css">
-<link href="/css/arrows.css" rel="stylesheet" type="text/css">
-<link href="/css/breadcrumbs.css" rel="stylesheet" type="text/css">
-<link href="/css/code.css" rel="stylesheet" type="text/css">
-<link rel="stylesheet" href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css">
-<link href="/css/responsive.css" rel="stylesheet" type="text/css">
-
-<link rel="shortcut icon" href="/favicon.ico" type="image/x-icon">
-<link rel="icon" href="/favicon.ico" type="image/x-icon">
-
-<script language="javascript" type="text/javascript" src="/js/lib/jquery-1.11.1.min.js"></script>
-<script language="javascript" type="text/javascript" src="/js/lib/jquery.easing.1.3.js"></script>
+<link href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css" rel="stylesheet" type="text/css"/>
+<link href="/css/site.css" rel="stylesheet" type="text/css"/>
+
+<link rel="shortcut icon" href="/favicon.ico" type="image/x-icon"/>
+<link rel="icon" href="/favicon.ico" type="image/x-icon"/>
+
+<script src="//ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js" language="javascript" type="text/javascript"></script>
+<script src="//cdnjs.cloudflare.com/ajax/libs/jquery-easing/1.3/jquery.easing.min.js" language="javascript" type="text/javascript"></script>
<script language="javascript" type="text/javascript" src="/js/modernizr.custom.js"></script>
<script language="javascript" type="text/javascript" src="/js/script.js"></script>
<script language="javascript" type="text/javascript" src="/js/drill.js"></script>
-
</head>
+
<body onResize="resized();">
<div class="page-wrap">
<div class="bui"></div>
@@ -63,6 +58,12 @@
<li><a href="/docs/query-data/">Query Data</a></li>
+ <li><a href="/docs/performance-tuning/">Performance Tuning</a></li>
+
+ <li><a href="/docs/log-and-debug/">Log and Debug</a></li>
+
+ <li><a href="/docs/query-audit-logging/">Query Audit Logging</a></li>
+
<li><a href="/docs/sql-reference/">SQL Reference</a></li>
<li><a href="/docs/data-sources-and-file-formats/">Data Sources and File Formats</a></li>
@@ -81,6 +82,8 @@
<li><a href="/docs/project-bylaws/">Project Bylaws</a></li>
+ <li><a href="/docs/log-and-debug/">Log and Debug</a></li>
+
</ul>
</li>
<li class='nav'>
@@ -110,7 +113,9 @@
</ul>
</div>
-
+ <link href="/css/content.css" rel="stylesheet" type="text/css">
+
+
@@ -149,14 +154,7 @@
- <li class="toctree-l2"><a href="javascript: void(0);">Architectural Highlights</a></li>
- <ul style="display: none">
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/flexibility/">Flexibility</a></li>
-
- <li class="toctree-l3"><a class="reference internal" href="/docs/performance/">Performance</a></li>
-
- </ul>
+ <li class="toctree-l2"><a class="reference internal" href="/docs/performance/">Performance</a></li>
</ul>
@@ -203,6 +201,10 @@
<li class="toctree-l2"><a class="reference internal" href="/docs/analyzing-highly-dynamic-datasets/">Analyzing Highly Dynamic Datasets</a></li>
+
+ <li class="toctree-l2"><a class="reference internal" href="/docs/analyzing-social-media/">Analyzing Social Media</a></li>
+
+
</ul>
@@ -300,7 +302,7 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/partition-pruning/">Partition Pruning</a></li>
+ <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-the-drill-shell/">Configuring the Drill Shell</a></li>
</ul>
@@ -357,7 +359,7 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/using-jdbc/">Using JDBC</a></li>
+ <li class="toctree-l2"><a class="reference internal" href="/docs/using-jdbc-with-squirrel-on-windows/">Using JDBC with SQuirreL on Windows</a></li>
@@ -409,6 +411,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-tibco-spotfire-server-with-drill/">Configuring Tibco Spotfire Server with Drill</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-desktop/">Using Apache Drill with Tableau 9 Desktop</a></li>
@@ -487,6 +493,32 @@
+ <li class="toctree-l1"><a href="javascript: void(0);">Performance Tuning</a></li>
+ <ul style="display: none">
+
+
+ <li class="toctree-l2"><a class="reference internal" href="/docs/performance-tuning-introduction/">Performance Tuning Introduction</a></li>
+
+
+ </ul>
+
+
+
+ <li class="toctree-l1"><a class="reference internal" href="/docs/log-and-debug/">Log and Debug</a></li>
+
+
+
+ <li class="toctree-l1"><a href="javascript: void(0);">Query Audit Logging</a></li>
+ <ul style="display: none">
+
+
+ <li class="toctree-l2"><a class="reference internal" href="/docs/getting-query-information/">Getting Query Information</a></li>
+
+
+ </ul>
+
+
+
<li class="toctree-l1"><a href="javascript: void(0);">SQL Reference</a></li>
<ul style="display: none">
@@ -563,27 +595,47 @@
<li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
- <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session-command/">ALTER SESSION Command</a></li>
+ <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+
+ <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
+
+ <li class="toctree-l3"><a class="reference internal" href="/docs/create-table-as-ctas/">CREATE TABLE AS (CTAS)</a></li>
+
+ <li class="toctree-l3"><a class="reference internal" href="/docs/create-view/">CREATE VIEW</a></li>
+
+ <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
+
+ <li class="toctree-l3"><a class="reference internal" href="/docs/describe/">DESCRIBE</a></li>
+
+ <li class="toctree-l3"><a class="reference internal" href="/docs/explain/">EXPLAIN</a></li>
+
+ <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
+
+ <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li>
+
+ <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li>
- <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system-command/">ALTER SYSTEM Command</a></li>
+ <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li>
- <li class="toctree-l3"><a class="reference internal" href="/docs/create-table-as-ctas-command/">CREATE TABLE AS (CTAS) Command</a></li>
+ <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li>
- <li class="toctree-l3"><a class="reference internal" href="/docs/create-view-command/">CREATE VIEW Command</a></li>
+ <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li>
- <li class="toctree-l3"><a class="reference internal" href="/docs/describe-command/">DESCRIBE Command</a></li>
+ <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li>
- <li class="toctree-l3"><a class="reference internal" href="/docs/explain-commands/">EXPLAIN Commands</a></li>
+ <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li>
- <li class="toctree-l3"><a class="reference internal" href="/docs/select-statements/">SELECT Statements</a></li>
+ <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li>
- <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas-command/">SHOW DATABASES and SHOW SCHEMAS Command</a></li>
+ <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li>
- <li class="toctree-l3"><a class="reference internal" href="/docs/show-files-command/">SHOW FILES Command</a></li>
+ <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li>
- <li class="toctree-l3"><a class="reference internal" href="/docs/show-tables-command/">SHOW TABLES Command</a></li>
+ <li class="toctree-l3"><a class="reference internal" href="/docs/show-files/">SHOW FILES</a></li>
- <li class="toctree-l3"><a class="reference internal" href="/docs/use-command/">USE Command</a></li>
+ <li class="toctree-l3"><a class="reference internal" href="/docs/show-tables/">SHOW TABLES</a></li>
+
+ <li class="toctree-l3"><a class="reference internal" href="/docs/use/">USE</a></li>
</ul>
@@ -782,6 +834,10 @@
<li class="toctree-l2"><a class="reference internal" href="/docs/what-is-apache-drill/">What is Apache Drill</a></li>
+
+ <li class="toctree-l2"><a class="reference internal" href="/docs/partition-pruning/">Partition Pruning</a></li>
+
+
</ul>
@@ -800,6 +856,29 @@
<li class="toctree-l1"><a class="reference internal" href="/docs/project-bylaws/">Project Bylaws</a></li>
+
+ <li class="toctree-l1"><a href="javascript: void(0);">Log and Debug</a></li>
+ <ul style="display: none">
+
+
+ <li class="toctree-l2"><a class="reference internal" href="/docs/log-and-debug-introduction/">Log and Debug Introduction</a></li>
+
+
+
+ <li class="toctree-l2"><a class="reference internal" href="/docs/error-messages/">Error Messages</a></li>
+
+
+
+ <li class="toctree-l2"><a class="reference internal" href="/docs/modify-logback-xml/">Modify logback.xml</a></li>
+
+
+
+ <li class="toctree-l2"><a class="reference internal" href="/docs/review-the-java-stack-trace/">Review the Java Stack Trace</a></li>
+
+
+ </ul>
+
+
</ul>
</div>
@@ -807,7 +886,7 @@
</aside>
- <nav class="breadcrumbs">
+<nav class="breadcrumbs">
<li><a href="/docs/">Docs</a></li>
@@ -816,23 +895,23 @@
<li>Deploying and Using a Hive UDF</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/data-sources-and-file-formats/030-deploying-and-using-a-hive-udf.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/data-sources-and-file-formats/030-deploying-and-using-a-hive-udf.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
+
- <div class="int_title">
- <h1>Deploying and Using a Hive UDF</h1>
+ <div class="int_title left">
+ <h1>Deploying and Using a Hive UDF</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>If the extensive Hive functions, such as the mathematical and date functions, which Drill supports do not meet your needs, you can use a Hive UDF in Drill queries. Drill supports your existing Hive scalar UDFs. You can do queries on Hive tables and access existing Hive input/output formats, including custom serdes. Drill serves as a complement to Hive deployments by offering low latency queries.</p>
+ <div class="int_text" align="left">
+
+ <p>If the extensive Hive functions, such as the mathematical and date functions, which Drill supports do not meet your needs, you can use a Hive UDF in Drill queries. Drill supports your existing Hive scalar UDFs. You can do queries on Hive tables and access existing Hive input/output formats, including custom serdes. Drill serves as a complement to Hive deployments by offering low latency queries.</p>
<h2 id="creating-the-udf">Creating the UDF</h2>
@@ -859,8 +938,8 @@
<p>To set up the UDF:</p>
<ol>
-<li>Register Hive. <a href="/docs/registering-hive/">Register a Hive storage plugin</a> that connects Drill to a Hive data source.</li>
-<li>In Drill 0.7 and later, add the JAR for the UDF to the Drill CLASSPATH. In earlier versions of Drill, place the JAR file in the <code>/jars/3rdparty</code> directory of the Drill installation on all nodes running a Drillbit.</li>
+<li>Register Hive. <a href="/docs/hive-storage-plugin/">Register a Hive storage plugin</a> that connects Drill to a Hive data source.</li>
+<li>Add the JAR for the UDF to the Drill CLASSPATH. In earlier versions of Drill, place the JAR file in the <code>/jars/3rdparty</code> directory of the Drill installation on all nodes running a Drillbit.</li>
<li>On each Drill node in the cluster, restart the Drillbit.
<code><drill installation directory>/bin/drillbit.sh restart</code></li>
</ol>
@@ -870,17 +949,17 @@
<p>Use a Hive UDF just as you would use a Drill custom function. For example, to query using a Hive UDF named upper-to-lower that takes a column.value argument, the SELECT statement looks something like this: </p>
<div class="highlight"><pre><code class="language-text" data-lang="text"> SELECT upper-to-lower(my_column.myvalue) FROM mytable;
</code></pre></div>
+
-
- <div class="doc-nav">
+ <div class="doc-nav">
<span class="previous-toc"><a href="/docs/hive-to-drill-data-type-mapping/">← Hive-to-Drill Data Type Mapping</a></span><span class="next-toc"><a href="/docs/parquet-format/">Parquet Format →</a></span>
</div>
-
- </div>
+
</div>
</div>
+</div>
</div>
<p class="push"></p>