phoenix-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mujt...@apache.org
Subject svn commit: r1558181 [5/10] - in /incubator/phoenix/site/publish: ./ language/ language/images/
Date Tue, 14 Jan 2014 20:15:40 GMT
Added: incubator/phoenix/site/publish/language/functions.html
URL: http://svn.apache.org/viewvc/incubator/phoenix/site/publish/language/functions.html?rev=1558181&view=auto
==============================================================================
--- incubator/phoenix/site/publish/language/functions.html (added)
+++ incubator/phoenix/site/publish/language/functions.html Tue Jan 14 20:15:38 2014
@@ -0,0 +1,981 @@
+
+<!DOCTYPE html>
+<!--
+ Generated by Apache Maven Doxia at Jan 14, 2014
+ Rendered using Maven Reflow Skin 1.0.0 (http://andriusvelykis.github.com/reflow-maven-skin)
+-->
+<html  xml:lang="en" lang="en">
+
+	<head>
+		<meta charset="UTF-8" />
+		<title>Functions | Apache Phoenix</title>
+		<meta name="viewport" content="width=device-width, initial-scale=1.0" />
+		<meta name="description" content="" />
+		<meta http-equiv="content-language" content="en" />
+
+		<link href="http://netdna.bootstrapcdn.com/bootswatch/2.2.2/united/bootstrap.min.css" rel="stylesheet" />
+		<link href="http://netdna.bootstrapcdn.com/twitter-bootstrap/2.2.2/css/bootstrap-responsive.min.css" rel="stylesheet" />
+		<link href="../css/bootswatch.css" rel="stylesheet" />
+		<link href="../css/reflow-skin.css" rel="stylesheet" />
+		
+		<link href="http://yandex.st/highlightjs/7.3/styles/default.min.css" rel="stylesheet" />
+		
+		<link href="../css/lightbox.css" rel="stylesheet" />
+		
+		<link href="../css/site.css" rel="stylesheet" />
+		<link href="../css/print.css" rel="stylesheet" media="print" />
+		
+		<!-- Le HTML5 shim, for IE6-8 support of HTML5 elements -->
+		<!--[if lt IE 9]>
+			<script src="http://html5shim.googlecode.com/svn/trunk/html5.js"></script>
+		<![endif]-->
+<link href="stylesheet.css" rel="stylesheet" />
+	</head>
+
+	<body class="page-language-functions project-phoenix" data-spy="scroll" data-offset="60" data-target="#toc-scroll-target">
+
+		<div class="navbar navbar-fixed-top">
+			<div class="navbar-inner">
+				<div class="container">
+					<a class="btn btn-navbar" data-toggle="collapse" data-target=".nav-collapse">
+						<span class="icon-bar"></span>
+						<span class="icon-bar"></span>
+						<span class="icon-bar"></span>
+					</a>
+					<a class="brand" href="index.html"><div class="xtoplogo"></div></a>
+					<div class="nav-collapse collapse">
+						<ul class="nav pull-right">
+							<li class="dropdown">
+								<a href="#" class="dropdown-toggle" data-toggle="dropdown">About <b class="caret"></b></a>
+								<ul class="dropdown-menu">
+									<li><a href="http://phoenix.incubator.apache.org/" title="Overview" class="externalLink">Overview </a></li>
+									<li><a href="http://phoenix.incubator.apache.org/recent.html" title="New Features" class="externalLink">New Features </a></li>
+									<li><a href="http://phoenix.incubator.apache.org/roadmap.html" title="Roadmap" class="externalLink">Roadmap </a></li>
+									<li><a href="http://phoenix.incubator.apache.org/performance.html" title="Performance" class="externalLink">Performance </a></li>
+									<li><a href="http://phoenix.incubator.apache.org/team.html" title="Team" class="externalLink">Team </a></li>
+									<li><a href="http://phoenix.incubator.apache.org/mailing_list.html" title="Mailing Lists" class="externalLink">Mailing Lists </a></li>
+									<li><a href="http://phoenix.incubator.apache.org/source.html" title="Source Repository" class="externalLink">Source Repository </a></li>
+									<li><a href="http://phoenix.incubator.apache.org/issues.html" title="Issue Tracking" class="externalLink">Issue Tracking </a></li>
+									<li><a href="http://phoenix.incubator.apache.org/download.html" title="Download" class="externalLink">Download </a></li>
+								</ul>
+							</li>
+							<li class="dropdown">
+								<a href="#" class="dropdown-toggle" data-toggle="dropdown">Using <b class="caret"></b></a>
+								<ul class="dropdown-menu">
+									<li><a href="http://phoenix.incubator.apache.org/faq.html" title="F.A.Q." class="externalLink">F.A.Q. </a></li>
+									<li><a href="http://phoenix.incubator.apache.org/Phoenix-in-15-minutes-or-less.html" title="Phoenix Quick Start" class="externalLink">Phoenix Quick Start </a></li>
+									<li><a href="http://phoenix.incubator.apache.org/tuning.html" title="Configuration and Tuning" class="externalLink">Configuration and Tuning </a></li>
+									<li><a href="http://phoenix.incubator.apache.org/building.html" title="Building Project" class="externalLink">Building Project </a></li>
+									<li><a href="http://phoenix.incubator.apache.org/salted.html" title="Salted Tables" class="externalLink">Salted Tables </a></li>
+									<li><a href="http://phoenix.incubator.apache.org/paged.html" title="Paged Queries" class="externalLink">Paged Queries </a></li>
+									<li><a href="http://phoenix.incubator.apache.org/secondary_indexing.html" title="Secondary Indexing" class="externalLink">Secondary Indexing </a></li>
+									<li><a href="http://phoenix.incubator.apache.org/skip_scan.html" title="Skip Scan" class="externalLink">Skip Scan </a></li>
+									<li><a href="http://phoenix.incubator.apache.org/dynamic_columns.html" title="Dynamic Columns" class="externalLink">Dynamic Columns </a></li>
+									<li><a href="http://phoenix.incubator.apache.org/phoenix_on_emr.html" title="Phoenix on EMR" class="externalLink">Phoenix on EMR </a></li>
+									<li><a href="http://phoenix.incubator.apache.org/mr_dataload.html" title="Bulk CSV via M/R" class="externalLink">Bulk CSV via M/R </a></li>
+									<li><a href="http://phoenix.incubator.apache.org/flume.html" title="Apache Flume Plugin" class="externalLink">Apache Flume Plugin </a></li>
+									<li><a href="http://phoenix.incubator.apache.org/sequences.html" title="Sequences" class="externalLink">Sequences </a></li>
+								</ul>
+							</li>
+							<li class="dropdown">
+								<a href="#" class="dropdown-toggle" data-toggle="dropdown">Reference <b class="caret"></b></a>
+								<ul class="dropdown-menu">
+									<li><a href="http://phoenix.incubator.apache.org/language/index.html" title="Grammar" class="externalLink">Grammar </a></li>
+									<li><a href="http://phoenix.incubator.apache.org/language/functions.html" title="Functions" class="externalLink">Functions </a></li>
+									<li><a href="http://phoenix.incubator.apache.org/language/datatypes.html" title="Datatypes" class="externalLink">Datatypes </a></li>
+								</ul>
+							</li>
+						</ul>
+					</div><!--/.nav-collapse -->
+				</div>
+			</div>
+		</div>
+		
+	<div class="container">
+	
+	<!-- Masthead
+	================================================== -->
+	</header>
+
+	<div class="main-body">
+	<div class="row">
+		<div class="span12">
+			<div class="body-content">
+<div class="page-header">
+ <h1>Functions</h1>
+</div>
+
+<!-- } -->
+<h3 id="functions">Aggregate Functions</h3>
+<!-- syntax-start
+<p class="notranslate">
+
+    <a href="#avg" >AVG</a><br />
+
+    <a href="#count" >COUNT</a><br />
+
+    <a href="#max" >MAX</a><br />
+
+    <a href="#min" >MIN</a><br />
+
+    <a href="#sum" >SUM</a><br />
+
+    <a href="#percentile_cont" >PERCENTILE_CONT</a><br />
+
+    <a href="#percentile_disc" >PERCENTILE_DISC</a><br />
+
+    <a href="#percent_rank" >PERCENT_RANK</a><br />
+
+    <a href="#stddev_pop" >STDDEV_POP</a><br />
+
+    <a href="#stddev_samp" >STDDEV_SAMP</a><br />
+</p>
+syntax-end -->
+<!-- railroad-start -->
+<table class="notranslate index">
+    <tr>
+        <td class="index">
+            
+                <a href="#avg" >AVG</a><br />
+            
+                <a href="#count" >COUNT</a><br />
+            
+                <a href="#max" >MAX</a><br />
+            
+                <a href="#min" >MIN</a><br />
+                    </td><td class="index">
+            
+                <a href="#sum" >SUM</a><br />
+            
+                <a href="#percentile_cont" >PERCENTILE_CONT</a><br />
+            
+                <a href="#percentile_disc" >PERCENTILE_DISC</a><br />
+            
+                <a href="#percent_rank" >PERCENT_RANK</a><br />
+                    </td><td class="index">
+            
+                <a href="#stddev_pop" >STDDEV_POP</a><br />
+            
+                <a href="#stddev_samp" >STDDEV_SAMP</a><br />
+                    </td>
+    </tr>
+</table>
+<!-- railroad-end -->
+
+<h3>String Functions</h3>
+<!-- syntax-start
+<p class="notranslate">
+
+    <a href="#substr" >SUBSTR</a><br />
+
+    <a href="#trim" >TRIM</a><br />
+
+    <a href="#ltrim" >LTRIM</a><br />
+
+    <a href="#rtrim" >RTRIM</a><br />
+
+    <a href="#length" >LENGTH</a><br />
+
+    <a href="#regexp_substr" >REGEXP_SUBSTR</a><br />
+
+    <a href="#regexp_replace" >REGEXP_REPLACE</a><br />
+
+    <a href="#upper" >UPPER</a><br />
+
+    <a href="#lower" >LOWER</a><br />
+
+    <a href="#reverse" >REVERSE</a><br />
+
+    <a href="#to_char" >TO_CHAR</a><br />
+</p>
+syntax-end -->
+<!-- railroad-start -->
+<table class="notranslate index">
+    <tr>
+        <td class="index">
+            
+                <a href="#substr" >SUBSTR</a><br />
+            
+                <a href="#trim" >TRIM</a><br />
+            
+                <a href="#ltrim" >LTRIM</a><br />
+            
+                <a href="#rtrim" >RTRIM</a><br />
+                    </td><td class="index">
+            
+                <a href="#length" >LENGTH</a><br />
+            
+                <a href="#regexp_substr" >REGEXP_SUBSTR</a><br />
+            
+                <a href="#regexp_replace" >REGEXP_REPLACE</a><br />
+            
+                <a href="#upper" >UPPER</a><br />
+                    </td><td class="index">
+            
+                <a href="#lower" >LOWER</a><br />
+            
+                <a href="#reverse" >REVERSE</a><br />
+            
+                <a href="#to_char" >TO_CHAR</a><br />
+                    </td>
+    </tr>
+</table>
+<!-- railroad-end -->
+
+<h3>Time and Date Functions</h3>
+<!-- syntax-start
+<p class="notranslate">
+
+    <a href="#round" >ROUND</a><br />
+
+    <a href="#truncate" >TRUNCATE</a><br />
+
+    <a href="#to_date" >TO_DATE</a><br />
+
+    <a href="#current_date" >CURRENT_DATE</a><br />
+
+    <a href="#current_time" >CURRENT_TIME</a><br />
+</p>
+syntax-end -->
+<!-- railroad-start -->
+<table class="notranslate index">
+    <tr>
+        <td class="index">
+            
+                <a href="#round" >ROUND</a><br />
+            
+                <a href="#truncate" >TRUNCATE</a><br />
+                    </td><td class="index">
+            
+                <a href="#to_date" >TO_DATE</a><br />
+            
+                <a href="#current_date" >CURRENT_DATE</a><br />
+                    </td><td class="index">
+            
+                <a href="#current_time" >CURRENT_TIME</a><br />
+                    </td>
+    </tr>
+</table>
+<!-- railroad-end -->
+
+<h3>Other Functions</h3>
+<!-- syntax-start
+<p class="notranslate">
+
+    <a href="#md5" >MD5</a><br />
+
+    <a href="#invert" >INVERT</a><br />
+
+    <a href="#to_number" >TO_NUMBER</a><br />
+
+    <a href="#coalesce" >COALESCE</a><br />
+</p>
+syntax-end -->
+<!-- railroad-start -->
+<table class="notranslate index">
+    <tr>
+        <td class="index">
+            
+                <a href="#md5" >MD5</a><br />
+            
+                <a href="#invert" >INVERT</a><br />
+                    </td><td class="index">
+            
+                <a href="#to_number" >TO_NUMBER</a><br />
+            
+                <a href="#coalesce" >COALESCE</a><br />
+                    </td><td class="index">
+                    </td>
+    </tr>
+</table>
+<!-- railroad-end -->
+
+
+
+<h3 id="avg" class="notranslate">AVG</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+AVG ( { <a href="index.html#term">numericTerm</a> } )
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">AVG ( <a href="index.html#term">numericTerm</a> )</code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+AVG ( { <a href="index.html#term">numericTerm</a> } )
+</pre>
+syntax-end -->
+<p>The average (mean) value. If no rows are selected, the result is <code>NULL</code>. Aggregates are only allowed in select statements. The returned value is of the same data type as the parameter.</p>
+<p>Example:</p>
+<p class="notranslate">AVG(X)</p>
+
+<h3 id="count" class="notranslate">COUNT</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+COUNT( [ DISTINCT ] { * | { <a href="index.html#term">term</a> } } )
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">COUNT (</code></td><td class="d"><table class="railroad"><tr class="railroad"><td class="ts"></td><td class="d">&nbsp;</td><td class="te"></td></tr><tr class="railroad"><td class="ls"></td><td class="d"><code class="c">DISTINCT</code></td><td class="le"></td></tr></table></td><td class="d"><table class="railroad"><tr class="railroad"><td class="ts"></td><td class="d"><code class="c">*</code></td><td class="te"></td></tr><tr class="railroad"><td class="ls"></td><td class="d"><code class="c"><a href="index.html#term">term</a></code></td><td class="le"></td></tr></table></td><td class="d"><code class="c">)</code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+COUNT( [ DISTINCT ] { * | { <a href="index.html#term">term</a> } } )
+</pre>
+syntax-end -->
+<p>The count of all row, or of the non-null values. This method returns a long. When <code>DISTINCT</code> is used, it counts only distinct values. If no rows are selected, the result is 0. Aggregates are only allowed in select statements.</p>
+<p>Example:</p>
+<p class="notranslate">COUNT(*)</p>
+
+<h3 id="max" class="notranslate">MAX</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+MAX(<a href="index.html#term">term</a>)
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">MAX ( <a href="index.html#term">term</a> )</code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+MAX(<a href="index.html#term">term</a>)
+</pre>
+syntax-end -->
+<p>The highest value. If no rows are selected, the result is <code>NULL</code>. Aggregates are only allowed in select statements. The returned value is of the same data type as the parameter.</p>
+<p>Example:</p>
+<p class="notranslate">MAX(NAME)</p>
+
+<h3 id="min" class="notranslate">MIN</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+MIN(<a href="index.html#term">term</a>)
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">MIN ( <a href="index.html#term">term</a> )</code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+MIN(<a href="index.html#term">term</a>)
+</pre>
+syntax-end -->
+<p>The lowest value. If no rows are selected, the result is <code>NULL</code>. Aggregates are only allowed in select statements. The returned value is of the same data type as the parameter.</p>
+<p>Example:</p>
+<p class="notranslate">MIN(NAME)</p>
+
+<h3 id="sum" class="notranslate">SUM</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+SUM( { <a href="index.html#term">numericTerm</a> } )
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">SUM ( <a href="index.html#term">numericTerm</a> )</code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+SUM( { <a href="index.html#term">numericTerm</a> } )
+</pre>
+syntax-end -->
+<p>The sum of all values. If no rows are selected, the result is <code>NULL</code>. Aggregates are only allowed in select statements. The returned value is of the same data type as the parameter.</p>
+<p>Example:</p>
+<p class="notranslate">SUM(X)</p>
+
+<h3 id="percentile_cont" class="notranslate">PERCENTILE_CONT</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+PERCENTILE_CONT( { <a href="index.html#numeric">numeric</a> } ) WITHIN GROUP (ORDER BY { <a href="index.html#term">numericTerm</a> } { ASC | DESC } )
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">PERCENTILE_CONT ( <a href="index.html#numeric">numeric</a> ) WITHIN GROUP ( ORDER BY <a href="index.html#term">numericTerm</a></code></td><td class="d"><table class="railroad"><tr class="railroad"><td class="ts"></td><td class="d"><code class="c">ASC</code></td><td class="te"></td></tr><tr class="railroad"><td class="ls"></td><td class="d"><code class="c">DESC</code></td><td class="le"></td></tr></table></td><td class="d"><code class="c">)</code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+PERCENTILE_CONT( { <a href="index.html#numeric">numeric</a> } ) WITHIN GROUP (ORDER BY { <a href="index.html#term">numericTerm</a> } { ASC | DESC } )
+</pre>
+syntax-end -->
+<p>The nth percentile of values in the column. The percentile value can be between 0 and 1 inclusive. Aggregates are only allowed in select statements. The returned value is of decimal data type.</p>
+<p>Example:</p>
+<p class="notranslate">PERCENTILE_CONT( 0.9 ) WITHIN GROUP (ORDER BY X ASC)</p>
+
+<h3 id="percentile_disc" class="notranslate">PERCENTILE_DISC</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+PERCENTILE_DIST( { <a href="index.html#numeric">numeric</a> } ) WITHIN GROUP (ORDER BY { <a href="index.html#term">numericTerm</a> } { ASC | DESC } )
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">PERCENTILE_DIST ( <a href="index.html#numeric">numeric</a> ) WITHIN GROUP ( ORDER BY <a href="index.html#term">numericTerm</a></code></td><td class="d"><table class="railroad"><tr class="railroad"><td class="ts"></td><td class="d"><code class="c">ASC</code></td><td class="te"></td></tr><tr class="railroad"><td class="ls"></td><td class="d"><code class="c">DESC</code></td><td class="le"></td></tr></table></td><td class="d"><code class="c">)</code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+PERCENTILE_DIST( { <a href="index.html#numeric">numeric</a> } ) WITHIN GROUP (ORDER BY { <a href="index.html#term">numericTerm</a> } { ASC | DESC } )
+</pre>
+syntax-end -->
+<p><code>PERCENTILE_DISC</code> is an inverse distribution function that assumes a discrete distribution model. It takes a percentile value and a sort specification and returns an element from the set. Nulls are ignored in the calculation.</p>
+<p>Example:</p>
+<p class="notranslate">PERCENTILE_DISC( 0.9 ) WITHIN GROUP (ORDER BY X DESC)</p>
+
+<h3 id="percent_rank" class="notranslate">PERCENT_RANK</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+PERCENT_RANK( { <a href="index.html#numeric">numeric</a> } ) WITHIN GROUP (ORDER BY { <a href="index.html#term">numericTerm</a> } { ASC | DESC } )
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">PERCENT_RANK ( <a href="index.html#numeric">numeric</a> ) WITHIN GROUP ( ORDER BY <a href="index.html#term">numericTerm</a></code></td><td class="d"><table class="railroad"><tr class="railroad"><td class="ts"></td><td class="d"><code class="c">ASC</code></td><td class="te"></td></tr><tr class="railroad"><td class="ls"></td><td class="d"><code class="c">DESC</code></td><td class="le"></td></tr></table></td><td class="d"><code class="c">)</code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+PERCENT_RANK( { <a href="index.html#numeric">numeric</a> } ) WITHIN GROUP (ORDER BY { <a href="index.html#term">numericTerm</a> } { ASC | DESC } )
+</pre>
+syntax-end -->
+<p>The percentile rank for a hypothetical value, if inserted into the column. Aggregates are only allowed in select statements. The returned value is of decimal data type.</p>
+<p>Example:</p>
+<p class="notranslate">PERCENT_RANK( 100 ) WITHIN GROUP (ORDER BY X ASC)</p>
+
+<h3 id="stddev_pop" class="notranslate">STDDEV_POP</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+STDDEV_POP( { <a href="index.html#term">numericTerm</a> } )
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">STDDEV_POP ( <a href="index.html#term">numericTerm</a> )</code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+STDDEV_POP( { <a href="index.html#term">numericTerm</a> } )
+</pre>
+syntax-end -->
+<p>The population standard deviation of all values. Aggregates are only allowed in select statements. The returned value is of decimal data type.</p>
+<p>Example:</p>
+<p class="notranslate">STDDEV_POP( X )</p>
+
+<h3 id="stddev_samp" class="notranslate">STDDEV_SAMP</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+STDDEV_SAMP( { <a href="index.html#term">numericTerm</a> } )
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">STDDEV_SAMP ( <a href="index.html#term">numericTerm</a> )</code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+STDDEV_SAMP( { <a href="index.html#term">numericTerm</a> } )
+</pre>
+syntax-end -->
+<p>The sample standard deviation of all values. Aggregates are only allowed in select statements. The returned value is of decimal data type.</p>
+<p>Example:</p>
+<p class="notranslate">STDDEV_SAMP( X )</p>
+
+<h3 id="md5" class="notranslate">MD5</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+MD5( <a href="index.html#term">term</a> )
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">MD5 ( <a href="index.html#term">term</a> )</code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+MD5( <a href="index.html#term">term</a> )
+</pre>
+syntax-end -->
+<p>Computes the <code>MD5</code> hash of the argument, returning the result as a <code>BINARY</code>(16).</p>
+<p>Example:</p>
+<p class="notranslate">MD5(my_column)</p>
+
+<h3 id="invert" class="notranslate">INVERT</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+INVERT( <a href="index.html#term">term</a> )
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">INVERT ( <a href="index.html#term">term</a> )</code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+INVERT( <a href="index.html#term">term</a> )
+</pre>
+syntax-end -->
+<p>Inverts the bits of the argument. The return type will be the same as the argument.</p>
+<p>Example:</p>
+<p class="notranslate">INVERT(my_column)</p>
+
+<h3 id="to_number" class="notranslate">TO_NUMBER</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+TO_NUMBER( <a href="index.html#term">stringTerm</a> | <a href="index.html#term">timeStampTerm</a> [, <a href="index.html#string">formatString</a>] )
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="ts"></td><td class="d"><table class="railroad"><tr class="railroad"><td class="d"><code class="c">TO_NUMBER ( <a href="index.html#term">stringTerm</a></code></td></tr></table></td><td class="te"></td></tr><tr class="railroad"><td class="ls"></td><td class="d"><table class="railroad"><tr class="railroad"><td class="d"><code class="c"><a href="index.html#term">timeStampTerm</a></code></td><td class="d"><table class="railroad"><tr class="railroad"><td class="ts"></td><td class="d">&nbsp;</td><td class="te"></td></tr><tr class="railroad"><td class="ls"></td><td class="d"><table class="railroad"><tr class="railroad"><td class="d"><code class="c">, <a href="index.html#string">formatString</a></code></td></tr></table></td><td class="le"></td></tr></table></td><td class="d"><code class="c">)</code></td></tr></table></td><td class="le"></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+TO_NUMBER( <a href="index.html#term">stringTerm</a> | <a href="index.html#term">timeStampTerm</a> [, <a href="index.html#string">formatString</a>] )
+</pre>
+syntax-end -->
+<p>Formats a string or date/time/timeStamp as a number, optionally accepting a format string. For details on the format, see <code>java.text.DecimalFormat</code>. For date, time, and timeStamp terms, the result is the time in milliseconds since the epoch. This method returns a decimal number.</p>
+<p>Example:</p>
+<p class="notranslate">TO_NUMBER(&#39;&#36;123.33&#39;, &#39;\u00A4###.##&#39;)</p>
+
+<h3 id="coalesce" class="notranslate">COALESCE</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+COALESCE( <a href="index.html#term">firstTerm</a>, <a href="index.html#term">secondTerm</a> )
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">COALESCE ( <a href="index.html#term">firstTerm</a> , <a href="index.html#term">secondTerm</a> )</code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+COALESCE( <a href="index.html#term">firstTerm</a>, <a href="index.html#term">secondTerm</a> )
+</pre>
+syntax-end -->
+<p>Returns the value of the first argument if not null and the second argument otherwise. Useful to guarantee that a column in an <code>UPSERT SELECT</code> command will evaluate to a non null value.</p>
+<p>Example:</p>
+<p class="notranslate">COALESCE(last_update_date, CURRENT_DATE())</p>
+
+<h3 id="substr" class="notranslate">SUBSTR</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+SUBSTR( <a href="index.html#term">stringTerm</a>, <a href="index.html#int">startInt</a> [, <a href="index.html#int">lengthInt</a> ] )
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">SUBSTR ( <a href="index.html#term">stringTerm</a> , <a href="index.html#int">startInt</a></code></td><td class="d"><table class="railroad"><tr class="railroad"><td class="ts"></td><td class="d">&nbsp;</td><td class="te"></td></tr><tr class="railroad"><td class="ls"></td><td class="d"><table class="railroad"><tr class="railroad"><td class="d"><code class="c">, <a href="index.html#int">lengthInt</a></code></td></tr></table></td><td class="le"></td></tr></table></td><td class="d"><code class="c">)</code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+SUBSTR( <a href="index.html#term">stringTerm</a>, <a href="index.html#int">startInt</a> [, <a href="index.html#int">lengthInt</a> ] )
+</pre>
+syntax-end -->
+<p>Returns a substring of a string starting at the one-based position. If zero is used, the position is zero-based. If the start index is negative, then the start index is relative to the end of the string. The length is optional and if not supplied, the rest of the string will be returned.</p>
+<p>Example:</p>
+<p class="notranslate">SUBSTR(&#39;[Hello]&#39;, 2, 5)<br />SUBSTR(&#39;Hello World&#39;, -5)</p>
+
+<h3 id="trim" class="notranslate">TRIM</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+TRIM( <a href="index.html#term">stringTerm</a> )
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">TRIM ( <a href="index.html#term">stringTerm</a> )</code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+TRIM( <a href="index.html#term">stringTerm</a> )
+</pre>
+syntax-end -->
+<p>Removes leading and trailing spaces from the input string.</p>
+<p>Example:</p>
+<p class="notranslate">TRIM(&#39; &nbsp;Hello &nbsp;&#39;)</p>
+
+<h3 id="ltrim" class="notranslate">LTRIM</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+LTRIM( <a href="index.html#term">stringTerm</a> )
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">LTRIM ( <a href="index.html#term">stringTerm</a> )</code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+LTRIM( <a href="index.html#term">stringTerm</a> )
+</pre>
+syntax-end -->
+<p>Removes leading spaces from the input string.</p>
+<p>Example:</p>
+<p class="notranslate">LTRIM(&#39; &nbsp;Hello&#39;)</p>
+
+<h3 id="rtrim" class="notranslate">RTRIM</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+RTRIM( <a href="index.html#term">stringTerm</a> )
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">RTRIM ( <a href="index.html#term">stringTerm</a> )</code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+RTRIM( <a href="index.html#term">stringTerm</a> )
+</pre>
+syntax-end -->
+<p>Removes trailing spaces from the input string.</p>
+<p>Example:</p>
+<p class="notranslate">RTRIM(&#39;Hello &nbsp;&nbsp;&#39;)</p>
+
+<h3 id="length" class="notranslate">LENGTH</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+LENGTH( <a href="index.html#term">stringTerm</a> )
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">LENGTH ( <a href="index.html#term">stringTerm</a> )</code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+LENGTH( <a href="index.html#term">stringTerm</a> )
+</pre>
+syntax-end -->
+<p>Returns the length of the string in characters.</p>
+<p>Example:</p>
+<p class="notranslate">LENGTH(&#39;Hello&#39;)</p>
+
+<h3 id="regexp_substr" class="notranslate">REGEXP_SUBSTR</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+REGEXP_SUBSTR( <a href="index.html#term">stringTerm</a>, <a href="index.html#string">patternString</a> [, <a href="index.html#int">startInt</a> ] )
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">REGEXP_SUBSTR ( <a href="index.html#term">stringTerm</a> , <a href="index.html#string">patternString</a></code></td><td class="d"><table class="railroad"><tr class="railroad"><td class="ts"></td><td class="d">&nbsp;</td><td class="te"></td></tr><tr class="railroad"><td class="ls"></td><td class="d"><table class="railroad"><tr class="railroad"><td class="d"><code class="c">, <a href="index.html#int">startInt</a></code></td></tr></table></td><td class="le"></td></tr></table></td><td class="d"><code class="c">)</code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+REGEXP_SUBSTR( <a href="index.html#term">stringTerm</a>, <a href="index.html#string">patternString</a> [, <a href="index.html#int">startInt</a> ] )
+</pre>
+syntax-end -->
+<p>Returns a substring of a string by applying a regular expression start from the offset of a one-based position. Just like with <code>SUBSTR</code>, if the start index is negative, then it is relative to the end of the string. If not specified, the start index defaults to 1.</p>
+<p>Example:</p>
+<p class="notranslate">REGEXP_SUBSTR(&#39;na1-appsrv35-sj35&#39;, &#39;[^-]+&#39;) evaluates to &#39;na1&#39;</p>
+
+<h3 id="regexp_replace" class="notranslate">REGEXP_REPLACE</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+REGEXP_REPLACE( <a href="index.html#term">stringTerm</a>, <a href="index.html#string">patternString</a> [, <a href="index.html#string">replacementString</a> ] )
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">REGEXP_REPLACE ( <a href="index.html#term">stringTerm</a> , <a href="index.html#string">patternString</a></code></td><td class="d"><table class="railroad"><tr class="railroad"><td class="ts"></td><td class="d">&nbsp;</td><td class="te"></td></tr><tr class="railroad"><td class="ls"></td><td class="d"><table class="railroad"><tr class="railroad"><td class="d"><code class="c">, <a href="index.html#string">replacementString</a></code></td></tr></table></td><td class="le"></td></tr></table></td><td class="d"><code class="c">)</code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+REGEXP_REPLACE( <a href="index.html#term">stringTerm</a>, <a href="index.html#string">patternString</a> [, <a href="index.html#string">replacementString</a> ] )
+</pre>
+syntax-end -->
+<p>Returns a string by applying a regular expression and replacing the matches with the replacement string. If the replacement string is not specified, it defaults to an empty string.</p>
+<p>Example:</p>
+<p class="notranslate">REGEXP_REPLACE(&#39;abc123ABC&#39;, &#39;[0-9]+&#39;, &#39;#&#39;) evaluates to &#39;abc#ABC&#39;</p>
+
+<h3 id="upper" class="notranslate">UPPER</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+UPPER( <a href="index.html#term">stringTerm</a> )
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">UPPER ( <a href="index.html#term">stringTerm</a> )</code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+UPPER( <a href="index.html#term">stringTerm</a> )
+</pre>
+syntax-end -->
+<p>Returns upper case string of the string argument.</p>
+<p>Example:</p>
+<p class="notranslate">UPPER(&#39;Hello&#39;)</p>
+
+<h3 id="lower" class="notranslate">LOWER</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+LOWER( <a href="index.html#term">stringTerm</a> )
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">LOWER ( <a href="index.html#term">stringTerm</a> )</code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+LOWER( <a href="index.html#term">stringTerm</a> )
+</pre>
+syntax-end -->
+<p>Returns lower case string of the string argument.</p>
+<p>Example:</p>
+<p class="notranslate">LOWER(&#39;HELLO&#39;)</p>
+
+<h3 id="reverse" class="notranslate">REVERSE</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+REVERSE( <a href="index.html#term">stringTerm</a> )
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">REVERSE ( <a href="index.html#term">stringTerm</a> )</code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+REVERSE( <a href="index.html#term">stringTerm</a> )
+</pre>
+syntax-end -->
+<p>Returns reversed string of the string argument.</p>
+<p>Example:</p>
+<p class="notranslate">REVERSE(&#39;Hello&#39;)</p>
+
+<h3 id="to_char" class="notranslate">TO_CHAR</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+TO_CHAR( <a href="index.html#term">timestampTerm</a> | <a href="index.html#term">numberTerm</a> [, <a href="index.html#string">formatString</a>] )
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="ts"></td><td class="d"><table class="railroad"><tr class="railroad"><td class="d"><code class="c">TO_CHAR ( <a href="index.html#term">timestampTerm</a></code></td></tr></table></td><td class="te"></td></tr><tr class="railroad"><td class="ls"></td><td class="d"><table class="railroad"><tr class="railroad"><td class="d"><code class="c"><a href="index.html#term">numberTerm</a></code></td><td class="d"><table class="railroad"><tr class="railroad"><td class="ts"></td><td class="d">&nbsp;</td><td class="te"></td></tr><tr class="railroad"><td class="ls"></td><td class="d"><table class="railroad"><tr class="railroad"><td class="d"><code class="c">, <a href="index.html#string">formatString</a></code></td></tr></table></td><td class="le"></td></tr></table></td><td class="d"><code class="c">)</code></td></tr></table></td><td class="le"></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+TO_CHAR( <a href="index.html#term">timestampTerm</a> | <a href="index.html#term">numberTerm</a> [, <a href="index.html#string">formatString</a>] )
+</pre>
+syntax-end -->
+<p>Formats a date, time, timestamp, or number as a string. The default date format is <code>yyyy-MM-dd HH:mm:ss</code> and the default number format is <code>#,##0.###</code>. For details, see <code>java.text.SimpleDateFormat</code> for date/time values and <code>java.text.DecimalFormat</code> for numbers. This method returns a string.</p>
+<p>Example:</p>
+<p class="notranslate">TO_CHAR(myDate, &#39;2001-02-03 04:05:06&#39;)<br />TO_CHAR(myDecimal, &#39;#,##0.###&#39;)</p>
+
+<h3 id="round" class="notranslate">ROUND</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+ROUND(<a href="index.html#term">timestampTerm</a>, {&apos;DAY&apos; | &apos;HOUR&apos; | &apos;MINUTE&apos; | &apos;SECOND&apos; | &apos;MILLISECOND&apos;} [, <a href="index.html#number">multiplierNumber</a>])
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">ROUND ( <a href="index.html#term">timestampTerm</a> ,</code></td><td class="d"><table class="railroad"><tr class="railroad"><td class="ts"></td><td class="d"><table class="railroad"><tr class="railroad"><td class="d"><code class="c">&apos; DAY &apos;</code></td></tr></table></td><td class="te"></td></tr><tr class="railroad"><td class="ks"></td><td class="d"><table class="railroad"><tr class="railroad"><td class="d"><code class="c">&apos; HOUR &apos;</code></td></tr></table></td><td class="ke"></td></tr><tr class="railroad"><td class="ks"></td><td class="d"><table class="railroad"><tr class="railroad"><td class="d"><code class="c">&apos; MINUTE &apos;</code></td></tr></table></td><td class="ke"></td></tr><tr class="railroad"><td class="ks"></td><td class="d"><table class="railroad"><tr class="railroad"><td class="d"><code class="c">&apos; SECOND &apos;</code></td></tr></table></td><td class="ke"></td></tr><tr 
 class="railroad"><td class="ls"></td><td class="d"><table class="railroad"><tr class="railroad"><td class="d"><code class="c">&apos; MILLISECOND &apos;</code></td></tr></table></td><td class="le"></td></tr></table></td><td class="d"><table class="railroad"><tr class="railroad"><td class="ts"></td><td class="d">&nbsp;</td><td class="te"></td></tr><tr class="railroad"><td class="ls"></td><td class="d"><table class="railroad"><tr class="railroad"><td class="d"><code class="c">, <a href="index.html#number">multiplierNumber</a></code></td></tr></table></td><td class="le"></td></tr></table></td><td class="d"><code class="c">)</code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+ROUND(<a href="index.html#term">timestampTerm</a>, {&apos;DAY&apos; | &apos;HOUR&apos; | &apos;MINUTE&apos; | &apos;SECOND&apos; | &apos;MILLISECOND&apos;} [, <a href="index.html#number">multiplierNumber</a>])
+</pre>
+syntax-end -->
+<p>Rounds the timestamp to the nearest time unit specified. The multiplier is used to round to a multiple of a time unit (i.e. 10 minute) and defaults to 1 if not specified. This method returns a date.</p>
+<p>Example:</p>
+<p class="notranslate">ROUND(date, &#39;MINUTE&#39;, 30)<br />ROUND(time, &#39;HOUR&#39;)</p>
+
+<h3 id="truncate" class="notranslate">TRUNCATE</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+TRUNC(<a href="index.html#term">timestampTerm</a>, {&apos;DAY&apos; | &apos;HOUR&apos; | &apos;MINUTE&apos; | &apos;SECOND&apos; | &apos;MILLISECOND&apos;} [, <a href="index.html#int">multiplierInt</a>])
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">TRUNC ( <a href="index.html#term">timestampTerm</a> ,</code></td><td class="d"><table class="railroad"><tr class="railroad"><td class="ts"></td><td class="d"><table class="railroad"><tr class="railroad"><td class="d"><code class="c">&apos; DAY &apos;</code></td></tr></table></td><td class="te"></td></tr><tr class="railroad"><td class="ks"></td><td class="d"><table class="railroad"><tr class="railroad"><td class="d"><code class="c">&apos; HOUR &apos;</code></td></tr></table></td><td class="ke"></td></tr><tr class="railroad"><td class="ks"></td><td class="d"><table class="railroad"><tr class="railroad"><td class="d"><code class="c">&apos; MINUTE &apos;</code></td></tr></table></td><td class="ke"></td></tr><tr class="railroad"><td class="ks"></td><td class="d"><table class="railroad"><tr class="railroad"><td class="d"><code class="c">&apos; SECOND &apos;</code></td></tr></table></td><td class="ke"></td></tr><tr 
 class="railroad"><td class="ls"></td><td class="d"><table class="railroad"><tr class="railroad"><td class="d"><code class="c">&apos; MILLISECOND &apos;</code></td></tr></table></td><td class="le"></td></tr></table></td><td class="d"><table class="railroad"><tr class="railroad"><td class="ts"></td><td class="d">&nbsp;</td><td class="te"></td></tr><tr class="railroad"><td class="ls"></td><td class="d"><table class="railroad"><tr class="railroad"><td class="d"><code class="c">, <a href="index.html#int">multiplierInt</a></code></td></tr></table></td><td class="le"></td></tr></table></td><td class="d"><code class="c">)</code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+TRUNC(<a href="index.html#term">timestampTerm</a>, {&apos;DAY&apos; | &apos;HOUR&apos; | &apos;MINUTE&apos; | &apos;SECOND&apos; | &apos;MILLISECOND&apos;} [, <a href="index.html#int">multiplierInt</a>])
+</pre>
+syntax-end -->
+<p>Truncates the timestamp to the next time unit closer to 0. The multiplier is used to truncate to a multiple of a time unit (i.e. 10 minute) and defaults to 1 if not specified. This method returns a date.</p>
+<p>Example:</p>
+<p class="notranslate">TRUNCATE(timestamp, &#39;SECOND&#39;, 30)<br />TRUNCATE(date, &#39;DAY&#39;, 7)</p>
+
+<h3 id="to_date" class="notranslate">TO_DATE</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+TO_DATE( <a href="index.html#term">stringTerm</a> [, <a href="index.html#string">formatString</a>] )
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">TO_DATE ( <a href="index.html#term">stringTerm</a></code></td><td class="d"><table class="railroad"><tr class="railroad"><td class="ts"></td><td class="d">&nbsp;</td><td class="te"></td></tr><tr class="railroad"><td class="ls"></td><td class="d"><table class="railroad"><tr class="railroad"><td class="d"><code class="c">, <a href="index.html#string">formatString</a></code></td></tr></table></td><td class="le"></td></tr></table></td><td class="d"><code class="c">)</code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+TO_DATE( <a href="index.html#term">stringTerm</a> [, <a href="index.html#string">formatString</a>] )
+</pre>
+syntax-end -->
+<p>Parses a string and returns a date. The most important format characters are: y year, M month, d day, H hour, m minute, s second. The default format string is <code>yyyy-MM-dd HH:mm:ss</code>. For details of the format, see <code>java.text.SimpleDateFormat</code>.</p>
+<p>Example:</p>
+<p class="notranslate">TO_DATE(&#39;Sat, 3 Feb 2001 03:05:06 GMT&#39;, &#39;EEE, d MMM yyyy HH:mm:ss z&#39;)</p>
+
+<h3 id="current_date" class="notranslate">CURRENT_DATE</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+CURRENT_DATE()
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">CURRENT_DATE ( )</code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+CURRENT_DATE()
+</pre>
+syntax-end -->
+<p>Returns the current server-side date, bound at the start of the execution of a query based on the current time on the region server owning the metadata of the table being queried.</p>
+<p>Example:</p>
+<p class="notranslate">CURRENT_DATE()</p>
+
+<h3 id="current_time" class="notranslate">CURRENT_TIME</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+CURRENT_TIME()
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">CURRENT_TIME ( )</code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+CURRENT_TIME()
+</pre>
+syntax-end -->
+<p>Same as <code>CURRENT_DATE</code>(), except returns a value of type <code>TIME</code>. In either case, the underlying representation is the epoch time as a long value.</p>
+<p>Example:</p>
+<p class="notranslate">CURRENT_TIME()</p>
+
+<!-- [close] { -->
+
+<!-- } -->
+			</div>
+		</div>
+	</div>
+	</div>
+
+	</div><!-- /container -->
+	
+	<!-- Footer
+	================================================== -->
+	<footer class="well">
+		<div class="container">
+			<div class="row">
+				<div class="span3 bottom-nav">
+					<ul class="nav nav-list">
+						<li class="nav-header">About</li>
+						<li>
+							<a href="http://phoenix.incubator.apache.org/" title="Overview" class="externalLink">Overview </a>
+						</li>
+						<li>
+							<a href="http://phoenix.incubator.apache.org/recent.html" title="New Features" class="externalLink">New Features </a>
+						</li>
+						<li>
+							<a href="http://phoenix.incubator.apache.org/roadmap.html" title="Roadmap" class="externalLink">Roadmap </a>
+						</li>
+						<li>
+							<a href="http://phoenix.incubator.apache.org/performance.html" title="Performance" class="externalLink">Performance </a>
+						</li>
+						<li>
+							<a href="http://phoenix.incubator.apache.org/team.html" title="Team" class="externalLink">Team </a>
+						</li>
+						<li>
+							<a href="http://phoenix.incubator.apache.org/mailing_list.html" title="Mailing Lists" class="externalLink">Mailing Lists </a>
+						</li>
+						<li>
+							<a href="http://phoenix.incubator.apache.org/source.html" title="Source Repository" class="externalLink">Source Repository </a>
+						</li>
+						<li>
+							<a href="http://phoenix.incubator.apache.org/issues.html" title="Issue Tracking" class="externalLink">Issue Tracking </a>
+						</li>
+						<li>
+							<a href="http://phoenix.incubator.apache.org/download.html" title="Download" class="externalLink">Download </a>
+						</li>
+					</ul>
+				</div>
+				<div class="span3 bottom-nav">
+					<ul class="nav nav-list">
+						<li class="nav-header">Using</li>
+						<li>
+							<a href="http://phoenix.incubator.apache.org/faq.html" title="F.A.Q." class="externalLink">F.A.Q. </a>
+						</li>
+						<li>
+							<a href="http://phoenix.incubator.apache.org/Phoenix-in-15-minutes-or-less.html" title="Phoenix Quick Start" class="externalLink">Phoenix Quick Start </a>
+						</li>
+						<li>
+							<a href="http://phoenix.incubator.apache.org/tuning.html" title="Configuration and Tuning" class="externalLink">Configuration and Tuning </a>
+						</li>
+						<li>
+							<a href="http://phoenix.incubator.apache.org/building.html" title="Building Project" class="externalLink">Building Project </a>
+						</li>
+						<li>
+							<a href="http://phoenix.incubator.apache.org/salted.html" title="Salted Tables" class="externalLink">Salted Tables </a>
+						</li>
+						<li>
+							<a href="http://phoenix.incubator.apache.org/paged.html" title="Paged Queries" class="externalLink">Paged Queries </a>
+						</li>
+						<li>
+							<a href="http://phoenix.incubator.apache.org/secondary_indexing.html" title="Secondary Indexing" class="externalLink">Secondary Indexing </a>
+						</li>
+						<li>
+							<a href="http://phoenix.incubator.apache.org/skip_scan.html" title="Skip Scan" class="externalLink">Skip Scan </a>
+						</li>
+						<li>
+							<a href="http://phoenix.incubator.apache.org/dynamic_columns.html" title="Dynamic Columns" class="externalLink">Dynamic Columns </a>
+						</li>
+						<li>
+							<a href="http://phoenix.incubator.apache.org/phoenix_on_emr.html" title="Phoenix on EMR" class="externalLink">Phoenix on EMR </a>
+						</li>
+						<li>
+							<a href="http://phoenix.incubator.apache.org/mr_dataload.html" title="Bulk CSV via M/R" class="externalLink">Bulk CSV via M/R </a>
+						</li>
+						<li>
+							<a href="http://phoenix.incubator.apache.org/flume.html" title="Apache Flume Plugin" class="externalLink">Apache Flume Plugin </a>
+						</li>
+						<li>
+							<a href="http://phoenix.incubator.apache.org/sequences.html" title="Sequences" class="externalLink">Sequences </a>
+						</li>
+					</ul>
+				</div>
+				<div class="span3 bottom-nav">
+					<ul class="nav nav-list">
+						<li class="nav-header">Reference</li>
+						<li>
+							<a href="http://phoenix.incubator.apache.org/language/index.html" title="Grammar" class="externalLink">Grammar </a>
+						</li>
+						<li>
+							<a href="http://phoenix.incubator.apache.org/language/functions.html" title="Functions" class="externalLink">Functions </a>
+						</li>
+						<li>
+							<a href="http://phoenix.incubator.apache.org/language/datatypes.html" title="Datatypes" class="externalLink">Datatypes </a>
+						</li>
+					</ul>
+				</div>
+				<div class="span3 bottom-description">
+					<form action="https://www.google.com/search" method="get"><input value="phoenix.incubator.apache.org" name="sitesearch" type="hidden"><input placeholder="Search the site&hellip;" required="required" style="width:170px;" size="18" name="q" id="query" type="search"></form>
+				</div>
+			</div>
+		</div>
+	</footer>
+		
+	<div class="container subfooter">
+		<div class="row">
+			<div class="span12">
+				<p class="pull-right"><a href="#">Back to top</a></p>
+				<p class="copyright">Copyright &copy;2014 <a href="http://www.apache.org">Apache Software Foundation</a>. All Rights Reserved.</p>
+				<p class="version-date"><span class="projectVersion">Version: 2.2.3. </span><span class="publishDate">Last Published: 2014-01-14. </span></p>
+			</div>
+		</div>
+	</div>
+
+	<!-- Le javascript
+	================================================== -->
+	<!-- Placed at the end of the document so the pages load faster -->
+
+	<!-- Fallback jQuery loading from Google CDN:
+	     http://stackoverflow.com/questions/1014203/best-way-to-use-googles-hosted-jquery-but-fall-back-to-my-hosted-library-on-go -->
+	<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
+	<script type="text/javascript">
+		if (typeof jQuery == 'undefined')
+		{
+			document.write(unescape("%3Cscript src='../js/jquery-1.8.3.min.js' type='text/javascript'%3E%3C/script%3E"));
+		}
+	</script>
+	
+	<script src="http://netdna.bootstrapcdn.com/twitter-bootstrap/2.2.2/js/bootstrap.min.js"></script>
+	<script src="../js/lightbox.js"></script>
+	<script src="../js/jquery.smooth-scroll.min.js"></script>
+	<!-- back button support for smooth scroll -->
+	<script src="../js/jquery.ba-bbq.min.js"></script>
+	<script src="http://yandex.st/highlightjs/7.3/highlight.min.js"></script>
+
+	<script src="../js/reflow-skin.js"></script>
+	
+	</body>
+</html>

Added: incubator/phoenix/site/publish/language/images/div-d.png
URL: http://svn.apache.org/viewvc/incubator/phoenix/site/publish/language/images/div-d.png?rev=1558181&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/phoenix/site/publish/language/images/div-d.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/phoenix/site/publish/language/images/div-ke.png
URL: http://svn.apache.org/viewvc/incubator/phoenix/site/publish/language/images/div-ke.png?rev=1558181&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/phoenix/site/publish/language/images/div-ke.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/phoenix/site/publish/language/images/div-ks.png
URL: http://svn.apache.org/viewvc/incubator/phoenix/site/publish/language/images/div-ks.png?rev=1558181&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/phoenix/site/publish/language/images/div-ks.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/phoenix/site/publish/language/images/div-le.png
URL: http://svn.apache.org/viewvc/incubator/phoenix/site/publish/language/images/div-le.png?rev=1558181&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/phoenix/site/publish/language/images/div-le.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/phoenix/site/publish/language/images/div-ls.png
URL: http://svn.apache.org/viewvc/incubator/phoenix/site/publish/language/images/div-ls.png?rev=1558181&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/phoenix/site/publish/language/images/div-ls.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/phoenix/site/publish/language/images/div-te.png
URL: http://svn.apache.org/viewvc/incubator/phoenix/site/publish/language/images/div-te.png?rev=1558181&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/phoenix/site/publish/language/images/div-te.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/phoenix/site/publish/language/images/div-ts.png
URL: http://svn.apache.org/viewvc/incubator/phoenix/site/publish/language/images/div-ts.png?rev=1558181&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/phoenix/site/publish/language/images/div-ts.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream



Mime
View raw message