drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tshi...@apache.org
Subject [33/51] [partial] drill-site git commit: Website update
Date Mon, 18 May 2015 23:39:08 GMT
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(&#39;2010-01-01 10:10:10&#39; AS TIMESTAMP), CAST(&#39;2001-01-01 11:10:10&#39;
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 &#39;2015-04-15&#39;, interval &#39;2&#39; 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 &#39;2015-04-15 22:55:55&#39;, interval &#39;10&#39; 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 &#39;22:55:55&#39;, interval &#39;10&#39; 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 &#39;2015-04-15 22:55:55&#39;, interval &#39;1-2&#39; 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 &#39;22:55:55&#39;, interval &#39;1 2:30:45.100&#39; 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 &#39;2015-04-15 22:55:55&#39;, interval &#39;10&#39; 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 &#39;22:55:55&#39;, interval &#39;10&#39; 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 &#39;2015-04-15 22:55:55&#39;, interval &#39;1-2&#39; 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 &#39;22:55:55&#39;, interval &#39;1 2:30:45.100&#39; 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>&lt;drill installation directory&gt;/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>


Mime
View raw message