phoenix-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jamestay...@apache.org
Subject svn commit: r1618548 [1/2] - in /phoenix/site/publish/language: datatypes.html functions.html index.html
Date Mon, 18 Aug 2014 07:12:30 GMT
Author: jamestaylor
Date: Mon Aug 18 07:12:29 2014
New Revision: 1618548

URL: http://svn.apache.org/r1618548
Log:
Update language reference for 3.1/4.1 release

Modified:
    phoenix/site/publish/language/datatypes.html
    phoenix/site/publish/language/functions.html
    phoenix/site/publish/language/index.html

Modified: phoenix/site/publish/language/datatypes.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/language/datatypes.html?rev=1618548&r1=1618547&r2=1618548&view=diff
==============================================================================
--- phoenix/site/publish/language/datatypes.html (original)
+++ phoenix/site/publish/language/datatypes.html Mon Aug 18 07:12:29 2014
@@ -1,129 +1,11 @@
-
-<!DOCTYPE html>
-<!--
- Generated by Apache Maven Doxia at 2014-08-16
- Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
--->
-<html  xml:lang="en" lang="en">
-
-	<head>
-		<meta charset="UTF-8" />
-		<title>Data Types | 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.3.2/united/bootstrap.min.css" rel="stylesheet" />
-		<link href="http://netdna.bootstrapcdn.com/twitter-bootstrap/2.3.1/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.5/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-datatypes project-phoenix-site" 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="#top-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" id="top-nav-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="../index.html" title="Overview">Overview</a></li>
-									<li ><a href="../recent.html" title="New Features">New Features</a></li>
-									<li ><a href="../roadmap.html" title="Roadmap">Roadmap</a></li>
-									<li ><a href="../performance.html" title="Performance">Performance</a></li>
-									<li ><a href="../team.html" title="Team">Team</a></li>
-									<li ><a href="../contributing.html" title="Contributing">Contributing</a></li>
-									<li ><a href="../resources.html" title="Resources">Resources</a></li>
-									<li ><a href="../mailing_list.html" title="Mailing Lists">Mailing Lists</a></li>
-									<li ><a href="../source.html" title="Source Repository">Source Repository</a></li>
-									<li ><a href="../issues.html" title="Issue Tracking">Issue Tracking</a></li>
-									<li ><a href="../download.html" title="Download">Download</a></li>
-									<li class="divider"/>
-									<li ><a href="http://www.apache.org/licenses/" title="License" class="externalLink">License</a></li>
-									<li ><a href="http://www.apache.org/foundation/sponsorship.html" title="Sponsorship" class="externalLink">Sponsorship</a></li>
-									<li ><a href="http://www.apache.org/foundation/thanks.html" title="Thanks" class="externalLink">Thanks</a></li>
-									<li ><a href="http://www.apache.org/security/" title="Security" class="externalLink">Security</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="../faq.html" title="F.A.Q.">F.A.Q.</a></li>
-									<li ><a href="../Phoenix-in-15-minutes-or-less.html" title="Quick Start">Quick Start</a></li>
-									<li ><a href="../building.html" title="Building">Building</a></li>
-									<li ><a href="../tuning.html" title="Tuning">Tuning</a></li>
-									<li ><a href="../upgrade_from_2_2.html" title="Upgrade from 2.2">Upgrade from 2.2</a></li>
-									<li class="divider"/>
-									<li ><a href="../secondary_indexing.html" title="Secondary Indexes">Secondary Indexes</a></li>
-									<li ><a href="../joins.html" title="Joins">Joins</a></li>
-									<li ><a href="../views.html" title="Views">Views</a></li>
-									<li ><a href="../multi-tenancy.html" title="Multi tenancy">Multi tenancy</a></li>
-									<li ><a href="../sequences.html" title="Sequences">Sequences</a></li>
-									<li ><a href="../array_type.html" title="ARRAY type">ARRAY type</a></li>
-									<li ><a href="../salted.html" title="Salted Tables">Salted Tables</a></li>
-									<li ><a href="../paged.html" title="Paged Queries">Paged Queries</a></li>
-									<li ><a href="../dynamic_columns.html" title="Dynamic Columns">Dynamic Columns</a></li>
-									<li ><a href="../skip_scan.html" title="Skip Scan">Skip Scan</a></li>
-									<li ><a href="../bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
-									<li ><a href="../tracing.html" title="Tracing">Tracing</a></li>
-									<li class="divider"/>
-									<li ><a href="../phoenix_on_emr.html" title="Amazon EMR Support">Amazon EMR Support</a></li>
-									<li ><a href="../flume.html" title="Apache Flume Plugin">Apache Flume Plugin</a></li>
-									<li ><a href="../pig_integration.html" title="Apache Pig Integration">Apache Pig Integration</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="index.html" title="Grammar">Grammar</a></li>
-									<li ><a href="functions.html" title="Functions">Functions</a></li>
-									<li class="active"><a href="" title="Datatypes">Datatypes</a></li>
-								</ul>
-							</li>
-						</ul>
-					</div><!--/.nav-collapse -->
-				</div>
-			</div>
-		</div>
-		
-	<div class="container">
-	
-	<!-- Masthead
-	================================================== -->
-
-	<header>
-	</header>
-
-	<div class="main-body">
-	<div class="row">
-		<div class="span12">
-			<div class="body-content">
-<div class="page-header">
- <h1>Data Types</h1>
-</div>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
+<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
+<head><meta http-equiv="Content-Type" content="text/html;charset=utf-8" /><title>
+Data Types
+</title><link rel="stylesheet" type="text/css" href="stylesheet.css" />
+<!-- [search] { -->
+</head>
+<body>
 
 <!-- } -->
 <h2 id="dataTypes">Index</h2>
@@ -673,186 +555,5 @@ syntax-end -->
 
 <!-- [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="../index.html" title="Overview">Overview</a>
-						</li>
-						<li >
-							<a href="../recent.html" title="New Features">New Features</a>
-						</li>
-						<li >
-							<a href="../roadmap.html" title="Roadmap">Roadmap</a>
-						</li>
-						<li >
-							<a href="../performance.html" title="Performance">Performance</a>
-						</li>
-						<li >
-							<a href="../team.html" title="Team">Team</a>
-						</li>
-						<li >
-							<a href="../contributing.html" title="Contributing">Contributing</a>
-						</li>
-						<li >
-							<a href="../resources.html" title="Resources">Resources</a>
-						</li>
-						<li >
-							<a href="../mailing_list.html" title="Mailing Lists">Mailing Lists</a>
-						</li>
-						<li >
-							<a href="../source.html" title="Source Repository">Source Repository</a>
-						</li>
-						<li >
-							<a href="../issues.html" title="Issue Tracking">Issue Tracking</a>
-						</li>
-						<li >
-							<a href="../download.html" title="Download">Download</a>
-						</li>
-						<li >
-							<a href="http:divider" title=""></a>
-						</li>
-						<li >
-							<a href="http://www.apache.org/licenses/" title="License" class="externalLink">License</a>
-						</li>
-						<li >
-							<a href="http://www.apache.org/foundation/sponsorship.html" title="Sponsorship" class="externalLink">Sponsorship</a>
-						</li>
-						<li >
-							<a href="http://www.apache.org/foundation/thanks.html" title="Thanks" class="externalLink">Thanks</a>
-						</li>
-						<li >
-							<a href="http://www.apache.org/security/" title="Security" class="externalLink">Security</a>
-						</li>
-					</ul>
-				</div>
-				<div class="span3 bottom-nav">
-					<ul class="nav nav-list">
-						<li class="nav-header">Using</li>
-						<li >
-							<a href="../faq.html" title="F.A.Q.">F.A.Q.</a>
-						</li>
-						<li >
-							<a href="../Phoenix-in-15-minutes-or-less.html" title="Quick Start">Quick Start</a>
-						</li>
-						<li >
-							<a href="../building.html" title="Building">Building</a>
-						</li>
-						<li >
-							<a href="../tuning.html" title="Tuning">Tuning</a>
-						</li>
-						<li >
-							<a href="../upgrade_from_2_2.html" title="Upgrade from 2.2">Upgrade from 2.2</a>
-						</li>
-						<li >
-							<a href="http:divider" title=""></a>
-						</li>
-						<li >
-							<a href="../secondary_indexing.html" title="Secondary Indexes">Secondary Indexes</a>
-						</li>
-						<li >
-							<a href="../joins.html" title="Joins">Joins</a>
-						</li>
-						<li >
-							<a href="../views.html" title="Views">Views</a>
-						</li>
-						<li >
-							<a href="../multi-tenancy.html" title="Multi tenancy">Multi tenancy</a>
-						</li>
-						<li >
-							<a href="../sequences.html" title="Sequences">Sequences</a>
-						</li>
-						<li >
-							<a href="../array_type.html" title="ARRAY type">ARRAY type</a>
-						</li>
-						<li >
-							<a href="../salted.html" title="Salted Tables">Salted Tables</a>
-						</li>
-						<li >
-							<a href="../paged.html" title="Paged Queries">Paged Queries</a>
-						</li>
-						<li >
-							<a href="../dynamic_columns.html" title="Dynamic Columns">Dynamic Columns</a>
-						</li>
-						<li >
-							<a href="../skip_scan.html" title="Skip Scan">Skip Scan</a>
-						</li>
-						<li >
-							<a href="../bulk_dataload.html" title="Bulk Loading">Bulk Loading</a>
-						</li>
-						<li >
-							<a href="../tracing.html" title="Tracing">Tracing</a>
-						</li>
-						<li >
-							<a href="http:divider" title=""></a>
-						</li>
-						<li >
-							<a href="../phoenix_on_emr.html" title="Amazon EMR Support">Amazon EMR Support</a>
-						</li>
-						<li >
-							<a href="../flume.html" title="Apache Flume Plugin">Apache Flume Plugin</a>
-						</li>
-						<li >
-							<a href="../pig_integration.html" title="Apache Pig Integration">Apache Pig Integration</a>
-						</li>
-					</ul>
-				</div>
-				<div class="span3 bottom-nav">
-					<ul class="nav nav-list">
-						<li class="nav-header">Reference</li>
-						<li >
-							<a href="index.html" title="Grammar">Grammar</a>
-						</li>
-						<li >
-							<a href="functions.html" title="Functions">Functions</a>
-						</li>
-						<li class="active">
-							<a href="#" title="Datatypes">Datatypes</a>
-						</li>
-					</ul>
-				</div>
-				<div class="span3 bottom-description">
-					<form action="https://www.google.com/search" method="get"><input value="phoenix.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>
-			</div>
-		</div>
-	</div>
-
-	<!-- Le javascript
-	================================================== -->
-	<!-- Placed at the end of the document so the pages load faster -->
-	<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
-	
-	<script src="http://netdna.bootstrapcdn.com/twitter-bootstrap/2.3.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.5/highlight.min.js"></script>
-
-	<script src="../js/reflow-skin.js"></script>
-	
-	</body>
-</html>
+<!-- } --></body></html>
+

Modified: phoenix/site/publish/language/functions.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/language/functions.html?rev=1618548&r1=1618547&r2=1618548&view=diff
==============================================================================
--- phoenix/site/publish/language/functions.html (original)
+++ phoenix/site/publish/language/functions.html Mon Aug 18 07:12:29 2014
@@ -1,129 +1,11 @@
-
-<!DOCTYPE html>
-<!--
- Generated by Apache Maven Doxia at 2014-08-16
- Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/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.3.2/united/bootstrap.min.css" rel="stylesheet" />
-		<link href="http://netdna.bootstrapcdn.com/twitter-bootstrap/2.3.1/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.5/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-site" 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="#top-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" id="top-nav-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="../index.html" title="Overview">Overview</a></li>
-									<li ><a href="../recent.html" title="New Features">New Features</a></li>
-									<li ><a href="../roadmap.html" title="Roadmap">Roadmap</a></li>
-									<li ><a href="../performance.html" title="Performance">Performance</a></li>
-									<li ><a href="../team.html" title="Team">Team</a></li>
-									<li ><a href="../contributing.html" title="Contributing">Contributing</a></li>
-									<li ><a href="../resources.html" title="Resources">Resources</a></li>
-									<li ><a href="../mailing_list.html" title="Mailing Lists">Mailing Lists</a></li>
-									<li ><a href="../source.html" title="Source Repository">Source Repository</a></li>
-									<li ><a href="../issues.html" title="Issue Tracking">Issue Tracking</a></li>
-									<li ><a href="../download.html" title="Download">Download</a></li>
-									<li class="divider"/>
-									<li ><a href="http://www.apache.org/licenses/" title="License" class="externalLink">License</a></li>
-									<li ><a href="http://www.apache.org/foundation/sponsorship.html" title="Sponsorship" class="externalLink">Sponsorship</a></li>
-									<li ><a href="http://www.apache.org/foundation/thanks.html" title="Thanks" class="externalLink">Thanks</a></li>
-									<li ><a href="http://www.apache.org/security/" title="Security" class="externalLink">Security</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="../faq.html" title="F.A.Q.">F.A.Q.</a></li>
-									<li ><a href="../Phoenix-in-15-minutes-or-less.html" title="Quick Start">Quick Start</a></li>
-									<li ><a href="../building.html" title="Building">Building</a></li>
-									<li ><a href="../tuning.html" title="Tuning">Tuning</a></li>
-									<li ><a href="../upgrade_from_2_2.html" title="Upgrade from 2.2">Upgrade from 2.2</a></li>
-									<li class="divider"/>
-									<li ><a href="../secondary_indexing.html" title="Secondary Indexes">Secondary Indexes</a></li>
-									<li ><a href="../joins.html" title="Joins">Joins</a></li>
-									<li ><a href="../views.html" title="Views">Views</a></li>
-									<li ><a href="../multi-tenancy.html" title="Multi tenancy">Multi tenancy</a></li>
-									<li ><a href="../sequences.html" title="Sequences">Sequences</a></li>
-									<li ><a href="../array_type.html" title="ARRAY type">ARRAY type</a></li>
-									<li ><a href="../salted.html" title="Salted Tables">Salted Tables</a></li>
-									<li ><a href="../paged.html" title="Paged Queries">Paged Queries</a></li>
-									<li ><a href="../dynamic_columns.html" title="Dynamic Columns">Dynamic Columns</a></li>
-									<li ><a href="../skip_scan.html" title="Skip Scan">Skip Scan</a></li>
-									<li ><a href="../bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
-									<li ><a href="../tracing.html" title="Tracing">Tracing</a></li>
-									<li class="divider"/>
-									<li ><a href="../phoenix_on_emr.html" title="Amazon EMR Support">Amazon EMR Support</a></li>
-									<li ><a href="../flume.html" title="Apache Flume Plugin">Apache Flume Plugin</a></li>
-									<li ><a href="../pig_integration.html" title="Apache Pig Integration">Apache Pig Integration</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="index.html" title="Grammar">Grammar</a></li>
-									<li class="active"><a href="" title="Functions">Functions</a></li>
-									<li ><a href="datatypes.html" title="Datatypes">Datatypes</a></li>
-								</ul>
-							</li>
-						</ul>
-					</div><!--/.nav-collapse -->
-				</div>
-			</div>
-		</div>
-		
-	<div class="container">
-	
-	<!-- Masthead
-	================================================== -->
-
-	<header>
-	</header>
-
-	<div class="main-body">
-	<div class="row">
-		<div class="span12">
-			<div class="body-content">
-<div class="page-header">
- <h1>Functions</h1>
-</div>
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
+<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
+<head><meta http-equiv="Content-Type" content="text/html;charset=utf-8" /><title>
+Functions
+</title><link rel="stylesheet" type="text/css" href="stylesheet.css" />
+<!-- [search] { -->
+</head>
+<body>
 
 <!-- } -->
 <h3 id="functions">Aggregate Functions</h3>
@@ -146,6 +28,12 @@
 
     <a href="#percent_rank" >PERCENT_RANK</a><br />
 
+    <a href="#first_value" >FIRST_VALUE</a><br />
+
+    <a href="#last_value" >LAST_VALUE</a><br />
+
+    <a href="#nth_value" >NTH_VALUE</a><br />
+
     <a href="#stddev_pop" >STDDEV_POP</a><br />
 
     <a href="#stddev_samp" >STDDEV_SAMP</a><br />
@@ -163,17 +51,23 @@ syntax-end -->
                 <a href="#max" >MAX</a><br />
             
                 <a href="#min" >MIN</a><br />
-                    </td><td class="index">
             
                 <a href="#sum" >SUM</a><br />
+                    </td><td class="index">
             
                 <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="#first_value" >FIRST_VALUE</a><br />
+            
+                <a href="#last_value" >LAST_VALUE</a><br />
                     </td><td class="index">
             
+                <a href="#nth_value" >NTH_VALUE</a><br />
+            
                 <a href="#stddev_pop" >STDDEV_POP</a><br />
             
                 <a href="#stddev_samp" >STDDEV_SAMP</a><br />
@@ -194,6 +88,8 @@ syntax-end -->
 
     <a href="#rtrim" >RTRIM</a><br />
 
+    <a href="#lpad" >LPAD</a><br />
+
     <a href="#length" >LENGTH</a><br />
 
     <a href="#regexp_substr" >REGEXP_SUBSTR</a><br />
@@ -223,14 +119,16 @@ syntax-end -->
                 <a href="#rtrim" >RTRIM</a><br />
                     </td><td class="index">
             
+                <a href="#lpad" >LPAD</a><br />
+            
                 <a href="#length" >LENGTH</a><br />
             
                 <a href="#regexp_substr" >REGEXP_SUBSTR</a><br />
             
                 <a href="#regexp_replace" >REGEXP_REPLACE</a><br />
+                    </td><td class="index">
             
                 <a href="#upper" >UPPER</a><br />
-                    </td><td class="index">
             
                 <a href="#lower" >LOWER</a><br />
             
@@ -251,6 +149,10 @@ syntax-end -->
     <a href="#current_date" >CURRENT_DATE</a><br />
 
     <a href="#current_time" >CURRENT_TIME</a><br />
+
+    <a href="#convert_tz" >CONVERT_TZ</a><br />
+
+    <a href="#timezone_offset" >TIMEZONE_OFFSET</a><br />
 </p>
 syntax-end -->
 <!-- railroad-start -->
@@ -259,12 +161,16 @@ syntax-end -->
         <td class="index">
             
                 <a href="#to_date" >TO_DATE</a><br />
-                    </td><td class="index">
             
                 <a href="#current_date" >CURRENT_DATE</a><br />
                     </td><td class="index">
             
                 <a href="#current_time" >CURRENT_TIME</a><br />
+            
+                <a href="#convert_tz" >CONVERT_TZ</a><br />
+                    </td><td class="index">
+            
+                <a href="#timezone_offset" >TIMEZONE_OFFSET</a><br />
                     </td>
     </tr>
 </table>
@@ -313,6 +219,10 @@ syntax-end -->
     <a href="#array_elem" >ARRAY_ELEM</a><br />
 
     <a href="#array_length" >ARRAY_LENGTH</a><br />
+
+    <a href="#any" >ANY</a><br />
+
+    <a href="#all" >ALL</a><br />
 </p>
 syntax-end -->
 <!-- railroad-start -->
@@ -321,10 +231,14 @@ syntax-end -->
         <td class="index">
             
                 <a href="#array_elem" >ARRAY_ELEM</a><br />
-                    </td><td class="index">
             
                 <a href="#array_length" >ARRAY_LENGTH</a><br />
                     </td><td class="index">
+            
+                <a href="#any" >ANY</a><br />
+            
+                <a href="#all" >ALL</a><br />
+                    </td><td class="index">
                     </td>
     </tr>
 </table>
@@ -338,6 +252,10 @@ syntax-end -->
 
     <a href="#invert" >INVERT</a><br />
 
+    <a href="#encode" >ENCODE</a><br />
+
+    <a href="#decode" >DECODE</a><br />
+
     <a href="#coalesce" >COALESCE</a><br />
 </p>
 syntax-end -->
@@ -347,11 +265,15 @@ syntax-end -->
         <td class="index">
             
                 <a href="#md5" >MD5</a><br />
-                    </td><td class="index">
             
                 <a href="#invert" >INVERT</a><br />
                     </td><td class="index">
             
+                <a href="#encode" >ENCODE</a><br />
+            
+                <a href="#decode" >DECODE</a><br />
+                    </td><td class="index">
+            
                 <a href="#coalesce" >COALESCE</a><br />
                     </td>
     </tr>
@@ -504,6 +426,60 @@ syntax-end -->
 <p>Example:</p>
 <p class="notranslate">PERCENT_RANK( 100 ) WITHIN GROUP (ORDER BY X ASC)</p>
 
+<h3 id="first_value" class="notranslate">FIRST_VALUE</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+FIRST_VALUE( { <a href="index.html#expression">expression</a> } ) WITHIN GROUP (ORDER BY { <a href="index.html#expression">expression</a> } { ASC | DESC } )
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">FIRST_VALUE ( <a href="index.html#expression">expression</a> ) WITHIN GROUP ( ORDER BY <a href="index.html#expression">expression</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>
+FIRST_VALUE( { <a href="index.html#expression">expression</a> } ) WITHIN GROUP (ORDER BY { <a href="index.html#expression">expression</a> } { ASC | DESC } )
+</pre>
+syntax-end -->
+<p>The first value in each distinct group ordered according to the <code>ORDER BY</code> specification.</p>
+<p>Example:</p>
+<p class="notranslate">FIRST_VALUE( name ) WITHIN GROUP (ORDER BY salary DESC)</p>
+
+<h3 id="last_value" class="notranslate">LAST_VALUE</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+LAST_VALUE( { <a href="index.html#expression">expression</a> } ) WITHIN GROUP (ORDER BY { <a href="index.html#expression">expression</a> } { ASC | DESC } )
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">LAST_VALUE ( <a href="index.html#expression">expression</a> ) WITHIN GROUP ( ORDER BY <a href="index.html#expression">expression</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>
+LAST_VALUE( { <a href="index.html#expression">expression</a> } ) WITHIN GROUP (ORDER BY { <a href="index.html#expression">expression</a> } { ASC | DESC } )
+</pre>
+syntax-end -->
+<p>The last value in each distinct group ordered according to the <code>ORDER BY</code> specification.</p>
+<p>Example:</p>
+<p class="notranslate">LAST_VALUE( name ) WITHIN GROUP (ORDER BY salary DESC)</p>
+
+<h3 id="nth_value" class="notranslate">NTH_VALUE</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+NTH_VALUE( { <a href="index.html#expression">expression</a>, <a href="index.html#numeric">nthNumeric</a> } ) WITHIN GROUP (ORDER BY { <a href="index.html#expression">expression</a> } { ASC | DESC } )
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">NTH_VALUE ( <a href="index.html#expression">expression</a> , <a href="index.html#numeric">nthNumeric</a> ) WITHIN GROUP ( ORDER BY <a href="index.html#expression">expression</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>
+NTH_VALUE( { <a href="index.html#expression">expression</a>, <a href="index.html#numeric">nthNumeric</a> } ) WITHIN GROUP (ORDER BY { <a href="index.html#expression">expression</a> } { ASC | DESC } )
+</pre>
+syntax-end -->
+<p>The nth value in each distinct group ordered according to the <code>ORDER BY</code> specification.</p>
+<p>Example:</p>
+<p class="notranslate">NTH_VALUE( name, 2 ) WITHIN GROUP (ORDER BY salary DESC)</p>
+
 <h3 id="stddev_pop" class="notranslate">STDDEV_POP</h3>
 <!-- railroad-start -->
 <pre name="bnf" style="display: none">
@@ -576,6 +552,42 @@ syntax-end -->
 <p>Example:</p>
 <p class="notranslate">ARRAY_LENGTH(my_array_col)<br />ARRAY_LENGTH(ARRAY[1,2,3])</p>
 
+<h3 id="any" class="notranslate">ANY</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+ANY( <a href="index.html#term">arrayTerm</a> )
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">ANY ( <a href="index.html#term">arrayTerm</a> )</code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+ANY( <a href="index.html#term">arrayTerm</a> )
+</pre>
+syntax-end -->
+<p>Used on the right-hand side of a comparison expression to test that any array element satisfies the comparison expression against the left-hand side.</p>
+<p>Example:</p>
+<p class="notranslate">1 = ANY(my_array)<br />10 &gt; ANY(my_array)</p>
+
+<h3 id="all" class="notranslate">ALL</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+ALL( <a href="index.html#term">arrayTerm</a> )
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">ALL ( <a href="index.html#term">arrayTerm</a> )</code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+ALL( <a href="index.html#term">arrayTerm</a> )
+</pre>
+syntax-end -->
+<p>Used on the right-hand side of a comparison expression to test that all array elements satisfy the comparison expression against the left-hand side. of the array.</p>
+<p>Example:</p>
+<p class="notranslate">1 = ALL(my_array)<br />10 &gt; ALL(my_array)</p>
+
 <h3 id="md5" class="notranslate">MD5</h3>
 <!-- railroad-start -->
 <pre name="bnf" style="display: none">
@@ -612,6 +624,42 @@ syntax-end -->
 <p>Example:</p>
 <p class="notranslate">INVERT(my_column)</p>
 
+<h3 id="encode" class="notranslate">ENCODE</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+ENCODE( <a href="index.html#expression">expression</a>, &apos;BASE62&apos; )
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">ENCODE ( <a href="index.html#expression">expression</a> , &apos; BASE62 &apos; )</code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+ENCODE( <a href="index.html#expression">expression</a>, &apos;BASE62&apos; )
+</pre>
+syntax-end -->
+<p>Encodes the expression according to the encoding format provided and returns the resulting string. For &#39;<code>BASE62</code>&#39;, converts the given base 10 number to a base 62 number and returns a string representing the number.</p>
+<p>Example:</p>
+<p class="notranslate">ENCODE(myNumber, &#39;BASE62&#39;)</p>
+
+<h3 id="decode" class="notranslate">DECODE</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+DECODE( <a href="index.html#expression">expression</a>, &apos;HEX&apos; )
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">DECODE ( <a href="index.html#expression">expression</a> , &apos; HEX &apos; )</code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+DECODE( <a href="index.html#expression">expression</a>, &apos;HEX&apos; )
+</pre>
+syntax-end -->
+<p>Decodes the expression according to the encoding format provided and returns the resulting value as a <code>VARBINARY</code>. For &#39;<code>HEX</code>&#39;, converts the hex string expression to its binary representation, providing a mechanism for inputting binary data through the console.</p>
+<p>Example:</p>
+<p class="notranslate">DECODE(&#39;000000008512af277ffffff8&#39;, &#39;HEX&#39;)</p>
+
 <h3 id="coalesce" class="notranslate">COALESCE</h3>
 <!-- railroad-start -->
 <pre name="bnf" style="display: none">
@@ -792,6 +840,24 @@ syntax-end -->
 <p>Example:</p>
 <p class="notranslate">RTRIM(&#39;Hello &nbsp;&nbsp;&#39;)</p>
 
+<h3 id="lpad" class="notranslate">LPAD</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+LPAD( <a href="index.html#term">stringTerm</a>, <a href="index.html#numeric">lengthNumeric</a>, [<a href="index.html#string">padString</a>] )
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">LPAD ( <a href="index.html#term">stringTerm</a> , <a href="index.html#numeric">lengthNumeric</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"><code class="c"><a href="index.html#string">padString</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>
+LPAD( <a href="index.html#term">stringTerm</a>, <a href="index.html#numeric">lengthNumeric</a>, [<a href="index.html#string">padString</a>] )
+</pre>
+syntax-end -->
+<p>Pads the string expression with the specific pad character (space by default) up to the length argument.</p>
+<p>Example:</p>
+<p class="notranslate">LPAD(&#39;John&#39;,30)</p>
+
 <h3 id="length" class="notranslate">LENGTH</h3>
 <!-- railroad-start -->
 <pre name="bnf" style="display: none">
@@ -972,188 +1038,43 @@ syntax-end -->
 <p>Example:</p>
 <p class="notranslate">CURRENT_TIME()</p>
 
+<h3 id="convert_tz" class="notranslate">CONVERT_TZ</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+CONVERT_TZ(<a href="index.html#term">dateTerm</a>|<a href="index.html#term">timeTerm</a>|<a href="index.html#term">timestampTerm</a>, <a href="index.html#string">fromTimeZoneString</a>, <a href="index.html#string">toTimeZoneString</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">CONVERT_TZ ( <a href="index.html#term">dateTerm</a></code></td></tr></table></td><td class="te"></td></tr><tr class="railroad"><td class="ks"></td><td class="d"><code class="c"><a href="index.html#term">timeTerm</a></code></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"><a href="index.html#term">timestampTerm</a> , <a href="index.html#string">fromTimeZoneString</a> , <a href="index.html#string">toTimeZoneString</a> )</code></td></tr></table></td><td class="le"></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+CONVERT_TZ(<a href="index.html#term">dateTerm</a>|<a href="index.html#term">timeTerm</a>|<a href="index.html#term">timestampTerm</a>, <a href="index.html#string">fromTimeZoneString</a>, <a href="index.html#string">toTimeZoneString</a>)
+</pre>
+syntax-end -->
+<p>Converts date/time from one time zone to another returning the shifted date/time value.</p>
+<p>Example:</p>
+<p class="notranslate">CONVERT_TZ(myDate, &#39;UTC&#39;, &#39;Europe/Prague&#39;)</p>
+
+<h3 id="timezone_offset" class="notranslate">TIMEZONE_OFFSET</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+TIMEZONE_OFFSET(<a href="index.html#string">timeZoneString</a>, <a href="index.html#term">dateTerm</a>|<a href="index.html#term">timeTerm</a>|<a href="index.html#term">timestampTerm</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">TIMEZONE_OFFSET ( <a href="index.html#string">timeZoneString</a> , <a href="index.html#term">dateTerm</a></code></td></tr></table></td><td class="te"></td></tr><tr class="railroad"><td class="ks"></td><td class="d"><code class="c"><a href="index.html#term">timeTerm</a></code></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"><a href="index.html#term">timestampTerm</a> )</code></td></tr></table></td><td class="le"></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+TIMEZONE_OFFSET(<a href="index.html#string">timeZoneString</a>, <a href="index.html#term">dateTerm</a>|<a href="index.html#term">timeTerm</a>|<a href="index.html#term">timestampTerm</a>)
+</pre>
+syntax-end -->
+<p>Returns offset (shift in minutes) of a time zone at particular date/time in minutes.</p>
+<p>Example:</p>
+<p class="notranslate">TIMEZONE_OFFSET(&#39;Indian/Cocos&#39;, myDate)</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="../index.html" title="Overview">Overview</a>
-						</li>
-						<li >
-							<a href="../recent.html" title="New Features">New Features</a>
-						</li>
-						<li >
-							<a href="../roadmap.html" title="Roadmap">Roadmap</a>
-						</li>
-						<li >
-							<a href="../performance.html" title="Performance">Performance</a>
-						</li>
-						<li >
-							<a href="../team.html" title="Team">Team</a>
-						</li>
-						<li >
-							<a href="../contributing.html" title="Contributing">Contributing</a>
-						</li>
-						<li >
-							<a href="../resources.html" title="Resources">Resources</a>
-						</li>
-						<li >
-							<a href="../mailing_list.html" title="Mailing Lists">Mailing Lists</a>
-						</li>
-						<li >
-							<a href="../source.html" title="Source Repository">Source Repository</a>
-						</li>
-						<li >
-							<a href="../issues.html" title="Issue Tracking">Issue Tracking</a>
-						</li>
-						<li >
-							<a href="../download.html" title="Download">Download</a>
-						</li>
-						<li >
-							<a href="http:divider" title=""></a>
-						</li>
-						<li >
-							<a href="http://www.apache.org/licenses/" title="License" class="externalLink">License</a>
-						</li>
-						<li >
-							<a href="http://www.apache.org/foundation/sponsorship.html" title="Sponsorship" class="externalLink">Sponsorship</a>
-						</li>
-						<li >
-							<a href="http://www.apache.org/foundation/thanks.html" title="Thanks" class="externalLink">Thanks</a>
-						</li>
-						<li >
-							<a href="http://www.apache.org/security/" title="Security" class="externalLink">Security</a>
-						</li>
-					</ul>
-				</div>
-				<div class="span3 bottom-nav">
-					<ul class="nav nav-list">
-						<li class="nav-header">Using</li>
-						<li >
-							<a href="../faq.html" title="F.A.Q.">F.A.Q.</a>
-						</li>
-						<li >
-							<a href="../Phoenix-in-15-minutes-or-less.html" title="Quick Start">Quick Start</a>
-						</li>
-						<li >
-							<a href="../building.html" title="Building">Building</a>
-						</li>
-						<li >
-							<a href="../tuning.html" title="Tuning">Tuning</a>
-						</li>
-						<li >
-							<a href="../upgrade_from_2_2.html" title="Upgrade from 2.2">Upgrade from 2.2</a>
-						</li>
-						<li >
-							<a href="http:divider" title=""></a>
-						</li>
-						<li >
-							<a href="../secondary_indexing.html" title="Secondary Indexes">Secondary Indexes</a>
-						</li>
-						<li >
-							<a href="../joins.html" title="Joins">Joins</a>
-						</li>
-						<li >
-							<a href="../views.html" title="Views">Views</a>
-						</li>
-						<li >
-							<a href="../multi-tenancy.html" title="Multi tenancy">Multi tenancy</a>
-						</li>
-						<li >
-							<a href="../sequences.html" title="Sequences">Sequences</a>
-						</li>
-						<li >
-							<a href="../array_type.html" title="ARRAY type">ARRAY type</a>
-						</li>
-						<li >
-							<a href="../salted.html" title="Salted Tables">Salted Tables</a>
-						</li>
-						<li >
-							<a href="../paged.html" title="Paged Queries">Paged Queries</a>
-						</li>
-						<li >
-							<a href="../dynamic_columns.html" title="Dynamic Columns">Dynamic Columns</a>
-						</li>
-						<li >
-							<a href="../skip_scan.html" title="Skip Scan">Skip Scan</a>
-						</li>
-						<li >
-							<a href="../bulk_dataload.html" title="Bulk Loading">Bulk Loading</a>
-						</li>
-						<li >
-							<a href="../tracing.html" title="Tracing">Tracing</a>
-						</li>
-						<li >
-							<a href="http:divider" title=""></a>
-						</li>
-						<li >
-							<a href="../phoenix_on_emr.html" title="Amazon EMR Support">Amazon EMR Support</a>
-						</li>
-						<li >
-							<a href="../flume.html" title="Apache Flume Plugin">Apache Flume Plugin</a>
-						</li>
-						<li >
-							<a href="../pig_integration.html" title="Apache Pig Integration">Apache Pig Integration</a>
-						</li>
-					</ul>
-				</div>
-				<div class="span3 bottom-nav">
-					<ul class="nav nav-list">
-						<li class="nav-header">Reference</li>
-						<li >
-							<a href="index.html" title="Grammar">Grammar</a>
-						</li>
-						<li class="active">
-							<a href="#" title="Functions">Functions</a>
-						</li>
-						<li >
-							<a href="datatypes.html" title="Datatypes">Datatypes</a>
-						</li>
-					</ul>
-				</div>
-				<div class="span3 bottom-description">
-					<form action="https://www.google.com/search" method="get"><input value="phoenix.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>
-			</div>
-		</div>
-	</div>
-
-	<!-- Le javascript
-	================================================== -->
-	<!-- Placed at the end of the document so the pages load faster -->
-	<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
-	
-	<script src="http://netdna.bootstrapcdn.com/twitter-bootstrap/2.3.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.5/highlight.min.js"></script>
-
-	<script src="../js/reflow-skin.js"></script>
-	
-	</body>
-</html>
+<!-- } --></body></html>
+



Mime
View raw message