You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@phoenix.apache.org by ja...@apache.org on 2014/08/18 09:12:30 UTC
svn commit: r1618548 [1/2] - in /phoenix/site/publish/language:
datatypes.html functions.html index.html
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…" 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 ©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 > 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 > 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>, 'BASE62' )
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">ENCODE ( <a href="index.html#expression">expression</a> , ' BASE62 ' )</code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+ENCODE( <a href="index.html#expression">expression</a>, 'BASE62' )
+</pre>
+syntax-end -->
+<p>Encodes the expression according to the encoding format provided and returns the resulting string. For '<code>BASE62</code>', 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, 'BASE62')</p>
+
+<h3 id="decode" class="notranslate">DECODE</h3>
+<!-- railroad-start -->
+<pre name="bnf" style="display: none">
+DECODE( <a href="index.html#expression">expression</a>, 'HEX' )
+</pre>
+<div name="railroad">
+<table class="railroad"><tr class="railroad"><td class="d"><code class="c">DECODE ( <a href="index.html#expression">expression</a> , ' HEX ' )</code></td></tr></table>
+</div>
+<!-- railroad-end -->
+<!-- syntax-start
+<pre>
+DECODE( <a href="index.html#expression">expression</a>, 'HEX' )
+</pre>
+syntax-end -->
+<p>Decodes the expression according to the encoding format provided and returns the resulting value as a <code>VARBINARY</code>. For '<code>HEX</code>', 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('000000008512af277ffffff8', 'HEX')</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('Hello ')</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"> </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('John',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, 'UTC', 'Europe/Prague')</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('Indian/Cocos', 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…" 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 ©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>
+