You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@phoenix.apache.org by sa...@apache.org on 2015/10/24 00:16:37 UTC
svn commit: r1710288 [4/4] - in /phoenix: phoenix-docs/
phoenix-docs/src/docsrc/help/ phoenix-docs/src/docsrc/html/ site/publish/
site/publish/language/ site/source/src/site/ site/source/src/site/markdown/
Modified: phoenix/site/publish/mailing_list.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/mailing_list.html?rev=1710288&r1=1710287&r2=1710288&view=diff
==============================================================================
--- phoenix/site/publish/mailing_list.html (original)
+++ phoenix/site/publish/mailing_list.html Fri Oct 23 22:16:36 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-10-05
+ Generated by Apache Maven Doxia at 2015-10-23
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -111,6 +111,7 @@
<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="salted.html" title="Salted Tables">Salted Tables</a></li>
+ <li ><a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a></li>
</ul>
</li>
<li class="dropdown">
@@ -364,6 +365,9 @@
<li >
<a href="salted.html" title="Salted Tables">Salted Tables</a>
</li>
+ <li >
+ <a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
+ </li>
</ul>
</div>
<div class="span3 bottom-nav">
Modified: phoenix/site/publish/multi-tenancy.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/multi-tenancy.html?rev=1710288&r1=1710287&r2=1710288&view=diff
==============================================================================
--- phoenix/site/publish/multi-tenancy.html (original)
+++ phoenix/site/publish/multi-tenancy.html Fri Oct 23 22:16:36 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-10-01
+ Generated by Apache Maven Doxia at 2015-10-23
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -111,6 +111,7 @@
<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="salted.html" title="Salted Tables">Salted Tables</a></li>
+ <li ><a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a></li>
</ul>
</li>
<li class="dropdown">
@@ -373,6 +374,9 @@ WHERE event_type='L';
<li >
<a href="salted.html" title="Salted Tables">Salted Tables</a>
</li>
+ <li >
+ <a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
+ </li>
</ul>
</div>
<div class="span3 bottom-nav">
Modified: phoenix/site/publish/news.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/news.html?rev=1710288&r1=1710287&r2=1710288&view=diff
==============================================================================
--- phoenix/site/publish/news.html (original)
+++ phoenix/site/publish/news.html Fri Oct 23 22:16:36 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-10-01
+ Generated by Apache Maven Doxia at 2015-10-23
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -111,6 +111,7 @@
<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="salted.html" title="Salted Tables">Salted Tables</a></li>
+ <li ><a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a></li>
</ul>
</li>
<li class="dropdown">
@@ -355,6 +356,9 @@
<li >
<a href="salted.html" title="Salted Tables">Salted Tables</a>
</li>
+ <li >
+ <a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
+ </li>
</ul>
</div>
<div class="span3 bottom-nav">
Modified: phoenix/site/publish/paged.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/paged.html?rev=1710288&r1=1710287&r2=1710288&view=diff
==============================================================================
--- phoenix/site/publish/paged.html (original)
+++ phoenix/site/publish/paged.html Fri Oct 23 22:16:36 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-10-01
+ Generated by Apache Maven Doxia at 2015-10-23
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -111,6 +111,7 @@
<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="salted.html" title="Salted Tables">Salted Tables</a></li>
+ <li ><a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a></li>
</ul>
</li>
<li class="dropdown">
@@ -356,6 +357,9 @@ LIMIT 20
<li >
<a href="salted.html" title="Salted Tables">Salted Tables</a>
</li>
+ <li >
+ <a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
+ </li>
</ul>
</div>
<div class="span3 bottom-nav">
Modified: phoenix/site/publish/performance.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/performance.html?rev=1710288&r1=1710287&r2=1710288&view=diff
==============================================================================
--- phoenix/site/publish/performance.html (original)
+++ phoenix/site/publish/performance.html Fri Oct 23 22:16:36 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-10-01
+ Generated by Apache Maven Doxia at 2015-10-23
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -111,6 +111,7 @@
<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="salted.html" title="Salted Tables">Salted Tables</a></li>
+ <li ><a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a></li>
</ul>
</li>
<li class="dropdown">
@@ -381,6 +382,9 @@
<li >
<a href="salted.html" title="Salted Tables">Salted Tables</a>
</li>
+ <li >
+ <a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
+ </li>
</ul>
</div>
<div class="span3 bottom-nav">
Modified: phoenix/site/publish/pherf.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/pherf.html?rev=1710288&r1=1710287&r2=1710288&view=diff
==============================================================================
--- phoenix/site/publish/pherf.html (original)
+++ phoenix/site/publish/pherf.html Fri Oct 23 22:16:36 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-10-01
+ Generated by Apache Maven Doxia at 2015-10-23
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -111,6 +111,7 @@
<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="salted.html" title="Salted Tables">Salted Tables</a></li>
+ <li ><a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a></li>
</ul>
</li>
<li class="dropdown">
@@ -461,6 +462,9 @@
<li >
<a href="salted.html" title="Salted Tables">Salted Tables</a>
</li>
+ <li >
+ <a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
+ </li>
</ul>
</div>
<div class="span3 bottom-nav">
Modified: phoenix/site/publish/phoenix_mr.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/phoenix_mr.html?rev=1710288&r1=1710287&r2=1710288&view=diff
==============================================================================
--- phoenix/site/publish/phoenix_mr.html (original)
+++ phoenix/site/publish/phoenix_mr.html Fri Oct 23 22:16:36 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-10-01
+ Generated by Apache Maven Doxia at 2015-10-23
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -111,6 +111,7 @@
<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="salted.html" title="Salted Tables">Salted Tables</a></li>
+ <li ><a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a></li>
</ul>
</li>
<li class="dropdown">
@@ -491,6 +492,9 @@ job.waitForCompletion(true);
<li >
<a href="salted.html" title="Salted Tables">Salted Tables</a>
</li>
+ <li >
+ <a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
+ </li>
</ul>
</div>
<div class="span3 bottom-nav">
Modified: phoenix/site/publish/phoenix_on_emr.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/phoenix_on_emr.html?rev=1710288&r1=1710287&r2=1710288&view=diff
==============================================================================
--- phoenix/site/publish/phoenix_on_emr.html (original)
+++ phoenix/site/publish/phoenix_on_emr.html Fri Oct 23 22:16:36 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-10-01
+ Generated by Apache Maven Doxia at 2015-10-23
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -111,6 +111,7 @@
<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="salted.html" title="Salted Tables">Salted Tables</a></li>
+ <li ><a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a></li>
</ul>
</li>
<li class="dropdown">
@@ -360,6 +361,9 @@
<li >
<a href="salted.html" title="Salted Tables">Salted Tables</a>
</li>
+ <li >
+ <a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
+ </li>
</ul>
</div>
<div class="span3 bottom-nav">
Modified: phoenix/site/publish/phoenix_spark.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/phoenix_spark.html?rev=1710288&r1=1710287&r2=1710288&view=diff
==============================================================================
--- phoenix/site/publish/phoenix_spark.html (original)
+++ phoenix/site/publish/phoenix_spark.html Fri Oct 23 22:16:36 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-10-18
+ Generated by Apache Maven Doxia at 2015-10-23
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -111,6 +111,7 @@
<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="salted.html" title="Salted Tables">Salted Tables</a></li>
+ <li ><a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a></li>
</ul>
</li>
<li class="dropdown">
@@ -545,6 +546,9 @@ pr.vertices.saveToPhoenix("EMAIL_EN
<li >
<a href="salted.html" title="Salted Tables">Salted Tables</a>
</li>
+ <li >
+ <a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
+ </li>
</ul>
</div>
<div class="span3 bottom-nav">
Modified: phoenix/site/publish/pig_integration.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/pig_integration.html?rev=1710288&r1=1710287&r2=1710288&view=diff
==============================================================================
--- phoenix/site/publish/pig_integration.html (original)
+++ phoenix/site/publish/pig_integration.html Fri Oct 23 22:16:36 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-10-01
+ Generated by Apache Maven Doxia at 2015-10-23
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -111,6 +111,7 @@
<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="salted.html" title="Salted Tables">Salted Tables</a></li>
+ <li ><a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a></li>
</ul>
</li>
<li class="dropdown">
@@ -390,6 +391,9 @@ DUMP cnt;
<li >
<a href="salted.html" title="Salted Tables">Salted Tables</a>
</li>
+ <li >
+ <a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
+ </li>
</ul>
</div>
<div class="span3 bottom-nav">
Modified: phoenix/site/publish/recent.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/recent.html?rev=1710288&r1=1710287&r2=1710288&view=diff
==============================================================================
--- phoenix/site/publish/recent.html (original)
+++ phoenix/site/publish/recent.html Fri Oct 23 22:16:36 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-10-01
+ Generated by Apache Maven Doxia at 2015-10-23
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -111,6 +111,7 @@
<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="salted.html" title="Salted Tables">Salted Tables</a></li>
+ <li ><a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a></li>
</ul>
</li>
<li class="dropdown">
@@ -354,6 +355,9 @@
<li >
<a href="salted.html" title="Salted Tables">Salted Tables</a>
</li>
+ <li >
+ <a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
+ </li>
</ul>
</div>
<div class="span3 bottom-nav">
Modified: phoenix/site/publish/release.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/release.html?rev=1710288&r1=1710287&r2=1710288&view=diff
==============================================================================
--- phoenix/site/publish/release.html (original)
+++ phoenix/site/publish/release.html Fri Oct 23 22:16:36 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-10-01
+ Generated by Apache Maven Doxia at 2015-10-23
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -111,6 +111,7 @@
<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="salted.html" title="Salted Tables">Salted Tables</a></li>
+ <li ><a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a></li>
</ul>
</li>
<li class="dropdown">
@@ -347,6 +348,9 @@
<li >
<a href="salted.html" title="Salted Tables">Salted Tables</a>
</li>
+ <li >
+ <a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
+ </li>
</ul>
</div>
<div class="span3 bottom-nav">
Modified: phoenix/site/publish/release_notes.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/release_notes.html?rev=1710288&r1=1710287&r2=1710288&view=diff
==============================================================================
--- phoenix/site/publish/release_notes.html (original)
+++ phoenix/site/publish/release_notes.html Fri Oct 23 22:16:36 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-10-05
+ Generated by Apache Maven Doxia at 2015-10-23
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -111,6 +111,7 @@
<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="salted.html" title="Salted Tables">Salted Tables</a></li>
+ <li ><a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a></li>
</ul>
</li>
<li class="dropdown">
@@ -354,6 +355,9 @@
<li >
<a href="salted.html" title="Salted Tables">Salted Tables</a>
</li>
+ <li >
+ <a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
+ </li>
</ul>
</div>
<div class="span3 bottom-nav">
Modified: phoenix/site/publish/resources.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/resources.html?rev=1710288&r1=1710287&r2=1710288&view=diff
==============================================================================
--- phoenix/site/publish/resources.html (original)
+++ phoenix/site/publish/resources.html Fri Oct 23 22:16:36 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-10-02
+ Generated by Apache Maven Doxia at 2015-10-23
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -111,6 +111,7 @@
<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="salted.html" title="Salted Tables">Salted Tables</a></li>
+ <li ><a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a></li>
</ul>
</li>
<li class="dropdown">
@@ -399,6 +400,9 @@
<li >
<a href="salted.html" title="Salted Tables">Salted Tables</a>
</li>
+ <li >
+ <a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
+ </li>
</ul>
</div>
<div class="span3 bottom-nav">
Modified: phoenix/site/publish/roadmap.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/roadmap.html?rev=1710288&r1=1710287&r2=1710288&view=diff
==============================================================================
--- phoenix/site/publish/roadmap.html (original)
+++ phoenix/site/publish/roadmap.html Fri Oct 23 22:16:36 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-10-01
+ Generated by Apache Maven Doxia at 2015-10-23
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -111,6 +111,7 @@
<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="salted.html" title="Salted Tables">Salted Tables</a></li>
+ <li ><a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a></li>
</ul>
</li>
<li class="dropdown">
@@ -350,6 +351,9 @@
<li >
<a href="salted.html" title="Salted Tables">Salted Tables</a>
</li>
+ <li >
+ <a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
+ </li>
</ul>
</div>
<div class="span3 bottom-nav">
Added: phoenix/site/publish/rowtimestamp.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/rowtimestamp.html?rev=1710288&view=auto
==============================================================================
--- phoenix/site/publish/rowtimestamp.html (added)
+++ phoenix/site/publish/rowtimestamp.html Fri Oct 23 22:16:36 2015
@@ -0,0 +1,390 @@
+
+<!DOCTYPE html>
+<!--
+ Generated by Apache Maven Doxia at 2015-10-23
+ 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>Row timestamp | 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="//netdna.bootstrapcdn.com/bootswatch/2.3.2/flatly/bootstrap.min.css" rel="stylesheet" />
+ <link href="//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="//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]-->
+
+
+
+ </head>
+
+ <body class="page-rowtimestamp 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="who_is_using.html" title="Who is Using">Who is Using</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="resources.html" title="Presentations">Presentations</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="installation.html" title="Installation">Installation</a></li>
+ <li class="divider"/>
+ <li ><a href="contributing.html" title="How to Contribute">How to Contribute</a></li>
+ <li ><a href="develop.html" title="How to Develop">How to Develop</a></li>
+ <li ><a href="building_website.html" title="How to Update Website">How to Update Website</a></li>
+ <li ><a href="release.html" title="How to Release">How to Release</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="upgrading.html" title="Upgrading">Upgrading</a></li>
+ <li ><a href="release_notes.html" title="Release Notes">Release Notes</a></li>
+ <li ><a href="pherf.html" title="Performance Testing">Performance Testing</a></li>
+ <li class="divider"/>
+ <li ><a href="phoenix_spark.html" title="Apache Spark Integration">Apache Spark Integration</a></li>
+ <li ><a href="pig_integration.html" title="Apache Pig Integration">Apache Pig Integration</a></li>
+ <li ><a href="phoenix_mr.html" title="Map Reduce Integration">Map Reduce Integration</a></li>
+ <li ><a href="flume.html" title="Apache Flume Plugin">Apache Flume Plugin</a></li>
+ <li ><a href="phoenix_on_emr.html" title="Amazon EMR Support">Amazon EMR Support</a></li>
+ </ul>
+ </li>
+ <li class="dropdown">
+ <a href="#" class="dropdown-toggle" data-toggle="dropdown">Features <b class="caret"></b></a>
+ <ul class="dropdown-menu">
+ <li ><a href="secondary_indexing.html" title="Secondary Indexes">Secondary Indexes</a></li>
+ <li ><a href="udf.html" title="User-defined Functions">User-defined Functions</a></li>
+ <li ><a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a></li>
+ <li ><a href="server.html" title="Query Server">Query Server</a></li>
+ <li ><a href="tracing.html" title="Tracing">Tracing</a></li>
+ <li ><a href="array_type.html" title="ARRAY type">ARRAY type</a></li>
+ <li ><a href="sequences.html" title="Sequences">Sequences</a></li>
+ <li ><a href="update_statistics.html" title="Statistics Collection">Statistics Collection</a></li>
+ <li ><a href="joins.html" title="Joins">Joins</a></li>
+ <li ><a href="subqueries.html" title="Subqueries">Subqueries</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="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="salted.html" title="Salted Tables">Salted Tables</a></li>
+ <li class="active"><a href="" title="Row Timestamp Column">Row Timestamp Column</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="language/index.html" title="Grammar">Grammar</a></li>
+ <li ><a href="language/functions.html" title="Functions">Functions</a></li>
+ <li ><a href="language/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>Row timestamp</h1>
+</div>
+<p>Phoenix v 4.6 now provides a way of mapping HBaseâs native row timestamp to a Phoenix column. This helps take advantage of various optimizations that HBase provides for time ranges on the store files as well as various query optimization capabilities built within Phoenix.</p>
+<p>For a column to be designated as ROW_TIMESTAMP, certain constraints need to be followed: </p>
+<ul>
+ <li> Only a primary key column of type TIME, DATE, TIMESTAMP, BIGINT, UNSIGNED_LONG can be designated as ROW_TIMESTAMP. </li>
+ <li> Only one primary key column can be designated as ROW_TIMESTAMP. </li>
+ <li> The value of the column cannot be null (since it is directly mapped to HBase row timestamp). This also means a column can be declared as ROW_TIMESTAMP only when creating the table. </li>
+ <li> Value of a ROW_TIMESTAMP column cannot be negative. This means for a DATE/TIME/TIMESTAMP, the corresponding epoch time in milliseconds cannot be less than zero. </li>
+</ul>
+<p>When upserting rows for a table with row timestamp column, using UPSERT VALUES or UPSERT SELECT, one could explicitly provide the value for the row timestamp column or let Phoenix automatically set it. When not specified, Phoenix sets the value of the row timestamp column to be the server side time. The value of the column also ends up being the timestamp of the corresponding row in HBase.</p>
+<p><b>Sample schema:</b></p>
+<p>CREATE TABLE DESTINATION_METRICS_TABLE (CREATED_DATE NOT NULL DATE, METRIC_ID NOT NULL CHAR(15), METRIC_VALUE LONG CONSTRAINT PK PRIMARY KEY(CREATED_DATE <b>ROW_TIMESTAMP</b>, METRIC_ID)) SALT_BUCKETS = 8;</p>
+<p>UPSERT INTO DESTINATION_METRICS_TABLE VALUES (?, ?, ?) - this sets the value of CREATED_DATE to the value specified in corresponding bind param.</p>
+<p>UPSERT INTO DESTINATION_METRICS_TABLE (METRIC_ID, METRIC_VALUE) VALUES (?, ?) - this sets the value of CREATED_DATE to the server side time.</p>
+<p>UPSERT INTO DESTINATION_METRICS_TABLE (CREATED_DATE, METRICS_ID, METRIC_VALUE) SELECT DATE, METRICS_ID, METRIC_VALUE FROM SOURCE_METRICS_TABLE - this sets the value of the CREATED_DATE to the DATE selected from the SOURCE_METRICS_TABLE</p>
+<p>UPSERT INTO DESTINATION_METRICS_TABLE (METRICS_ID, METRIC_VALUE) SELECT METRICS_ID, METRIC_VALUE FROM SOURCE_METRICS_TABLE - this sets the value of the created_date in destination table to the server timestamp.</p>
+<p>When querying by filtering on the row timestamp column, apart from doing the regular optimizations that Phoenix does for row key columns, Phoenix is also able to appropriately set the min and max time ranges on the scans. With the help of this time range information, HBase on the server side is able to entirely skip those store files which do not have fall in the time range. This greatly improves performance especially when querying the tail-end of the data.</p>
+ </div>
+ </div>
+ </div>
+ </div>
+
+ </div><!-- /container -->
+
+ <!-- Footer
+ ================================================== -->
+ <footer class="well">
+ <div class="container">
+ <div class="row">
+ <div class="span2 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="who_is_using.html" title="Who is Using">Who is Using</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="resources.html" title="Presentations">Presentations</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="installation.html" title="Installation">Installation</a>
+ </li>
+ <li >
+ <a href="http:divider" title=""></a>
+ </li>
+ <li >
+ <a href="contributing.html" title="How to Contribute">How to Contribute</a>
+ </li>
+ <li >
+ <a href="develop.html" title="How to Develop">How to Develop</a>
+ </li>
+ <li >
+ <a href="building_website.html" title="How to Update Website">How to Update Website</a>
+ </li>
+ <li >
+ <a href="release.html" title="How to Release">How to Release</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="span2 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="upgrading.html" title="Upgrading">Upgrading</a>
+ </li>
+ <li >
+ <a href="release_notes.html" title="Release Notes">Release Notes</a>
+ </li>
+ <li >
+ <a href="pherf.html" title="Performance Testing">Performance Testing</a>
+ </li>
+ <li >
+ <a href="http:divider" title=""></a>
+ </li>
+ <li >
+ <a href="phoenix_spark.html" title="Apache Spark Integration">Apache Spark Integration</a>
+ </li>
+ <li >
+ <a href="pig_integration.html" title="Apache Pig Integration">Apache Pig Integration</a>
+ </li>
+ <li >
+ <a href="phoenix_mr.html" title="Map Reduce Integration">Map Reduce Integration</a>
+ </li>
+ <li >
+ <a href="flume.html" title="Apache Flume Plugin">Apache Flume Plugin</a>
+ </li>
+ <li >
+ <a href="phoenix_on_emr.html" title="Amazon EMR Support">Amazon EMR Support</a>
+ </li>
+ </ul>
+ </div>
+ <div class="span2 bottom-nav">
+ <ul class="nav nav-list">
+ <li class="nav-header">Features</li>
+ <li >
+ <a href="secondary_indexing.html" title="Secondary Indexes">Secondary Indexes</a>
+ </li>
+ <li >
+ <a href="udf.html" title="User-defined Functions">User-defined Functions</a>
+ </li>
+ <li >
+ <a href="bulk_dataload.html" title="Bulk Loading">Bulk Loading</a>
+ </li>
+ <li >
+ <a href="server.html" title="Query Server">Query Server</a>
+ </li>
+ <li >
+ <a href="tracing.html" title="Tracing">Tracing</a>
+ </li>
+ <li >
+ <a href="array_type.html" title="ARRAY type">ARRAY type</a>
+ </li>
+ <li >
+ <a href="sequences.html" title="Sequences">Sequences</a>
+ </li>
+ <li >
+ <a href="update_statistics.html" title="Statistics Collection">Statistics Collection</a>
+ </li>
+ <li >
+ <a href="joins.html" title="Joins">Joins</a>
+ </li>
+ <li >
+ <a href="subqueries.html" title="Subqueries">Subqueries</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="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="salted.html" title="Salted Tables">Salted Tables</a>
+ </li>
+ <li class="active">
+ <a href="#" title="Row Timestamp Column">Row Timestamp Column</a>
+ </li>
+ </ul>
+ </div>
+ <div class="span3 bottom-nav">
+ <ul class="nav nav-list">
+ <li class="nav-header">Reference</li>
+ <li >
+ <a href="language/index.html" title="Grammar">Grammar</a>
+ </li>
+ <li >
+ <a href="language/functions.html" title="Functions">Functions</a>
+ </li>
+ <li >
+ <a href="language/datatypes.html" title="Datatypes">Datatypes</a>
+ </li>
+ </ul>
+ </div>
+ <div class="span3 bottom-description">
+ <form action="http://search-hadoop.com/?" method="get"><input value="Phoenix" name="fc_project" type="hidden"><input placeholder="Search Phoenix…" 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 ©2015 <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="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
+
+ <script src="//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="//yandex.st/highlightjs/7.5/highlight.min.js"></script>
+
+ <script src="./js/reflow-skin.js"></script>
+
+ </body>
+</html>
Modified: phoenix/site/publish/salted.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/salted.html?rev=1710288&r1=1710287&r2=1710288&view=diff
==============================================================================
--- phoenix/site/publish/salted.html (original)
+++ phoenix/site/publish/salted.html Fri Oct 23 22:16:36 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-10-05
+ Generated by Apache Maven Doxia at 2015-10-23
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -111,6 +111,7 @@
<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 class="active"><a href="" title="Salted Tables">Salted Tables</a></li>
+ <li ><a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a></li>
</ul>
</li>
<li class="dropdown">
@@ -344,6 +345,9 @@
<li class="active">
<a href="#" title="Salted Tables">Salted Tables</a>
</li>
+ <li >
+ <a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
+ </li>
</ul>
</div>
<div class="span3 bottom-nav">
Modified: phoenix/site/publish/secondary_indexing.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/secondary_indexing.html?rev=1710288&r1=1710287&r2=1710288&view=diff
==============================================================================
--- phoenix/site/publish/secondary_indexing.html (original)
+++ phoenix/site/publish/secondary_indexing.html Fri Oct 23 22:16:36 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-10-05
+ Generated by Apache Maven Doxia at 2015-10-23
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -111,6 +111,7 @@
<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="salted.html" title="Salted Tables">Salted Tables</a></li>
+ <li ><a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a></li>
</ul>
</li>
<li class="dropdown">
@@ -592,6 +593,9 @@ CREATE LOCAL INDEX my_index ON my_table
<li >
<a href="salted.html" title="Salted Tables">Salted Tables</a>
</li>
+ <li >
+ <a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
+ </li>
</ul>
</div>
<div class="span3 bottom-nav">
Modified: phoenix/site/publish/sequences.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/sequences.html?rev=1710288&r1=1710287&r2=1710288&view=diff
==============================================================================
--- phoenix/site/publish/sequences.html (original)
+++ phoenix/site/publish/sequences.html Fri Oct 23 22:16:36 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-10-01
+ Generated by Apache Maven Doxia at 2015-10-23
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -111,6 +111,7 @@
<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="salted.html" title="Salted Tables">Salted Tables</a></li>
+ <li ><a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a></li>
</ul>
</li>
<li class="dropdown">
@@ -375,6 +376,9 @@ VALUES( NEXT VALUE FOR my_schema.my_sequ
<li >
<a href="salted.html" title="Salted Tables">Salted Tables</a>
</li>
+ <li >
+ <a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
+ </li>
</ul>
</div>
<div class="span3 bottom-nav">
Modified: phoenix/site/publish/server.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/server.html?rev=1710288&r1=1710287&r2=1710288&view=diff
==============================================================================
--- phoenix/site/publish/server.html (original)
+++ phoenix/site/publish/server.html Fri Oct 23 22:16:36 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-10-01
+ Generated by Apache Maven Doxia at 2015-10-23
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -111,6 +111,7 @@
<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="salted.html" title="Salted Tables">Salted Tables</a></li>
+ <li ><a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a></li>
</ul>
</li>
<li class="dropdown">
@@ -506,6 +507,9 @@ log4j.logger.org.eclipse.jetty.server=IN
<li >
<a href="salted.html" title="Salted Tables">Salted Tables</a>
</li>
+ <li >
+ <a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
+ </li>
</ul>
</div>
<div class="span3 bottom-nav">
Modified: phoenix/site/publish/skip_scan.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/skip_scan.html?rev=1710288&r1=1710287&r2=1710288&view=diff
==============================================================================
--- phoenix/site/publish/skip_scan.html (original)
+++ phoenix/site/publish/skip_scan.html Fri Oct 23 22:16:36 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-10-01
+ Generated by Apache Maven Doxia at 2015-10-23
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -111,6 +111,7 @@
<li ><a href="dynamic_columns.html" title="Dynamic Columns">Dynamic Columns</a></li>
<li class="active"><a href="" title="Skip Scan">Skip Scan</a></li>
<li ><a href="salted.html" title="Salted Tables">Salted Tables</a></li>
+ <li ><a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a></li>
</ul>
</li>
<li class="dropdown">
@@ -333,6 +334,9 @@ AND KEY2 IN (1, 2)
<li >
<a href="salted.html" title="Salted Tables">Salted Tables</a>
</li>
+ <li >
+ <a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
+ </li>
</ul>
</div>
<div class="span3 bottom-nav">
Modified: phoenix/site/publish/source.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/source.html?rev=1710288&r1=1710287&r2=1710288&view=diff
==============================================================================
--- phoenix/site/publish/source.html (original)
+++ phoenix/site/publish/source.html Fri Oct 23 22:16:36 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-10-01
+ Generated by Apache Maven Doxia at 2015-10-23
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -111,6 +111,7 @@
<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="salted.html" title="Salted Tables">Salted Tables</a></li>
+ <li ><a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a></li>
</ul>
</li>
<li class="dropdown">
@@ -339,6 +340,9 @@
<li >
<a href="salted.html" title="Salted Tables">Salted Tables</a>
</li>
+ <li >
+ <a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
+ </li>
</ul>
</div>
<div class="span3 bottom-nav">
Modified: phoenix/site/publish/subqueries.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/subqueries.html?rev=1710288&r1=1710287&r2=1710288&view=diff
==============================================================================
--- phoenix/site/publish/subqueries.html (original)
+++ phoenix/site/publish/subqueries.html Fri Oct 23 22:16:36 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-10-05
+ Generated by Apache Maven Doxia at 2015-10-23
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -111,6 +111,7 @@
<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="salted.html" title="Salted Tables">Salted Tables</a></li>
+ <li ><a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a></li>
</ul>
</li>
<li class="dropdown">
@@ -477,6 +478,9 @@ ORDER BY count(*) DESC;
<li >
<a href="salted.html" title="Salted Tables">Salted Tables</a>
</li>
+ <li >
+ <a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
+ </li>
</ul>
</div>
<div class="span3 bottom-nav">
Modified: phoenix/site/publish/team.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/team.html?rev=1710288&r1=1710287&r2=1710288&view=diff
==============================================================================
--- phoenix/site/publish/team.html (original)
+++ phoenix/site/publish/team.html Fri Oct 23 22:16:36 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-10-05
+ Generated by Apache Maven Doxia at 2015-10-23
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -111,6 +111,7 @@
<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="salted.html" title="Salted Tables">Salted Tables</a></li>
+ <li ><a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a></li>
</ul>
</li>
<li class="dropdown">
@@ -472,6 +473,9 @@
<li >
<a href="salted.html" title="Salted Tables">Salted Tables</a>
</li>
+ <li >
+ <a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
+ </li>
</ul>
</div>
<div class="span3 bottom-nav">
Modified: phoenix/site/publish/tracing.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/tracing.html?rev=1710288&r1=1710287&r2=1710288&view=diff
==============================================================================
--- phoenix/site/publish/tracing.html (original)
+++ phoenix/site/publish/tracing.html Fri Oct 23 22:16:36 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-10-05
+ Generated by Apache Maven Doxia at 2015-10-23
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -111,6 +111,7 @@
<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="salted.html" title="Salted Tables">Salted Tables</a></li>
+ <li ><a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a></li>
</ul>
</li>
<li class="dropdown">
@@ -515,6 +516,9 @@ Connection conn = DriverManager.getConne
<li >
<a href="salted.html" title="Salted Tables">Salted Tables</a>
</li>
+ <li >
+ <a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
+ </li>
</ul>
</div>
<div class="span3 bottom-nav">
Modified: phoenix/site/publish/tuning.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/tuning.html?rev=1710288&r1=1710287&r2=1710288&view=diff
==============================================================================
--- phoenix/site/publish/tuning.html (original)
+++ phoenix/site/publish/tuning.html Fri Oct 23 22:16:36 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-10-01
+ Generated by Apache Maven Doxia at 2015-10-23
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -111,6 +111,7 @@
<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="salted.html" title="Salted Tables">Salted Tables</a></li>
+ <li ><a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a></li>
</ul>
</li>
<li class="dropdown">
@@ -575,6 +576,9 @@
<li >
<a href="salted.html" title="Salted Tables">Salted Tables</a>
</li>
+ <li >
+ <a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
+ </li>
</ul>
</div>
<div class="span3 bottom-nav">
Modified: phoenix/site/publish/udf.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/udf.html?rev=1710288&r1=1710287&r2=1710288&view=diff
==============================================================================
--- phoenix/site/publish/udf.html (original)
+++ phoenix/site/publish/udf.html Fri Oct 23 22:16:36 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-10-01
+ Generated by Apache Maven Doxia at 2015-10-23
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -111,6 +111,7 @@
<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="salted.html" title="Salted Tables">Salted Tables</a></li>
+ <li ><a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a></li>
</ul>
</li>
<li class="dropdown">
@@ -465,6 +466,9 @@ Connection conn = DriverManager.getConne
<li >
<a href="salted.html" title="Salted Tables">Salted Tables</a>
</li>
+ <li >
+ <a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
+ </li>
</ul>
</div>
<div class="span3 bottom-nav">
Modified: phoenix/site/publish/update_statistics.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/update_statistics.html?rev=1710288&r1=1710287&r2=1710288&view=diff
==============================================================================
--- phoenix/site/publish/update_statistics.html (original)
+++ phoenix/site/publish/update_statistics.html Fri Oct 23 22:16:36 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-10-01
+ Generated by Apache Maven Doxia at 2015-10-23
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -111,6 +111,7 @@
<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="salted.html" title="Salted Tables">Salted Tables</a></li>
+ <li ><a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a></li>
</ul>
</li>
<li class="dropdown">
@@ -377,6 +378,9 @@
<li >
<a href="salted.html" title="Salted Tables">Salted Tables</a>
</li>
+ <li >
+ <a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
+ </li>
</ul>
</div>
<div class="span3 bottom-nav">
Modified: phoenix/site/publish/upgrading.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/upgrading.html?rev=1710288&r1=1710287&r2=1710288&view=diff
==============================================================================
--- phoenix/site/publish/upgrading.html (original)
+++ phoenix/site/publish/upgrading.html Fri Oct 23 22:16:36 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-10-01
+ Generated by Apache Maven Doxia at 2015-10-23
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -111,6 +111,7 @@
<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="salted.html" title="Salted Tables">Salted Tables</a></li>
+ <li ><a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a></li>
</ul>
</li>
<li class="dropdown">
@@ -343,6 +344,9 @@
<li >
<a href="salted.html" title="Salted Tables">Salted Tables</a>
</li>
+ <li >
+ <a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
+ </li>
</ul>
</div>
<div class="span3 bottom-nav">
Modified: phoenix/site/publish/views.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/views.html?rev=1710288&r1=1710287&r2=1710288&view=diff
==============================================================================
--- phoenix/site/publish/views.html (original)
+++ phoenix/site/publish/views.html Fri Oct 23 22:16:36 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-10-01
+ Generated by Apache Maven Doxia at 2015-10-23
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -111,6 +111,7 @@
<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="salted.html" title="Salted Tables">Salted Tables</a></li>
+ <li ><a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a></li>
</ul>
</li>
<li class="dropdown">
@@ -377,6 +378,9 @@ VALUES('John Doe', CURRENT_DATE(), NEXT
<li >
<a href="salted.html" title="Salted Tables">Salted Tables</a>
</li>
+ <li >
+ <a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
+ </li>
</ul>
</div>
<div class="span3 bottom-nav">
Modified: phoenix/site/publish/who_is_using.html
URL: http://svn.apache.org/viewvc/phoenix/site/publish/who_is_using.html?rev=1710288&r1=1710287&r2=1710288&view=diff
==============================================================================
--- phoenix/site/publish/who_is_using.html (original)
+++ phoenix/site/publish/who_is_using.html Fri Oct 23 22:16:36 2015
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<!--
- Generated by Apache Maven Doxia at 2015-10-05
+ Generated by Apache Maven Doxia at 2015-10-23
Rendered using Reflow Maven Skin 1.1.0 (http://andriusvelykis.github.io/reflow-maven-skin)
-->
<html xml:lang="en" lang="en">
@@ -111,6 +111,7 @@
<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="salted.html" title="Salted Tables">Salted Tables</a></li>
+ <li ><a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a></li>
</ul>
</li>
<li class="dropdown">
@@ -413,6 +414,9 @@
<li >
<a href="salted.html" title="Salted Tables">Salted Tables</a>
</li>
+ <li >
+ <a href="rowtimestamp.html" title="Row Timestamp Column">Row Timestamp Column</a>
+ </li>
</ul>
</div>
<div class="span3 bottom-nav">
Added: phoenix/site/source/src/site/markdown/rowtimestamp.md
URL: http://svn.apache.org/viewvc/phoenix/site/source/src/site/markdown/rowtimestamp.md?rev=1710288&view=auto
==============================================================================
--- phoenix/site/source/src/site/markdown/rowtimestamp.md (added)
+++ phoenix/site/source/src/site/markdown/rowtimestamp.md Fri Oct 23 22:16:36 2015
@@ -0,0 +1,35 @@
+# Row timestamp
+
+Phoenix v 4.6 now provides a way of mapping HBaseâs native row timestamp to a Phoenix column. This helps take advantage of various optimizations that HBase provides for time ranges on the store files as well as various query optimization capabilities built within Phoenix.
+
+For a column to be designated as ROW_TIMESTAMP, certain constraints need to be followed:
+<ul>
+<li> Only a primary key column of type TIME, DATE, TIMESTAMP, BIGINT, UNSIGNED_LONG can be designated as ROW_TIMESTAMP. </li>
+<li> Only one primary key column can be designated as ROW_TIMESTAMP. </li>
+<li> The value of the column cannot be null (since it is directly mapped to HBase row timestamp). This also means a column can be declared as ROW_TIMESTAMP only when creating the table. </li>
+<li> Value of a ROW_TIMESTAMP column cannot be negative. This means for a DATE/TIME/TIMESTAMP, the corresponding epoch time in milliseconds cannot be less than zero. </li>
+</ul>
+
+
+When upserting rows for a table with row timestamp column, using UPSERT VALUES or UPSERT SELECT, one could explicitly provide the value for the row timestamp column or let Phoenix automatically set it. When not specified, Phoenix sets the value of the row timestamp column to be the server side time. The value of the column also ends up being the timestamp of the corresponding row in HBase.
+
+
+<b>Sample schema:</b>
+
+CREATE TABLE DESTINATION_METRICS_TABLE
+(CREATED_DATE NOT NULL DATE,
+METRIC_ID NOT NULL CHAR(15),
+METRIC_VALUE LONG
+CONSTRAINT PK PRIMARY KEY(CREATED_DATE <b>ROW_TIMESTAMP</b>, METRIC_ID))
+SALT_BUCKETS = 8;
+
+UPSERT INTO DESTINATION_METRICS_TABLE VALUES (?, ?, ?) - this sets the value of CREATED_DATE to the value specified in corresponding bind param.
+
+UPSERT INTO DESTINATION_METRICS_TABLE (METRIC_ID, METRIC_VALUE) VALUES (?, ?) - this sets the value of CREATED_DATE to the server side time.
+
+UPSERT INTO DESTINATION_METRICS_TABLE (CREATED_DATE, METRICS_ID, METRIC_VALUE) SELECT DATE, METRICS_ID, METRIC_VALUE FROM SOURCE_METRICS_TABLE - this sets the value of the CREATED_DATE to the DATE selected from the SOURCE_METRICS_TABLE
+
+UPSERT INTO DESTINATION_METRICS_TABLE (METRICS_ID, METRIC_VALUE) SELECT METRICS_ID, METRIC_VALUE FROM SOURCE_METRICS_TABLE - this sets the value of the created_date in destination table to the server timestamp.
+
+
+When querying by filtering on the row timestamp column, apart from doing the regular optimizations that Phoenix does for row key columns, Phoenix is also able to appropriately set the min and max time ranges on the scans. With the help of this time range information, HBase on the server side is able to entirely skip those store files which do not have fall in the time range. This greatly improves performance especially when querying the tail-end of the data.
\ No newline at end of file
Modified: phoenix/site/source/src/site/site.xml
URL: http://svn.apache.org/viewvc/phoenix/site/source/src/site/site.xml?rev=1710288&r1=1710287&r2=1710288&view=diff
==============================================================================
--- phoenix/site/source/src/site/site.xml (original)
+++ phoenix/site/source/src/site/site.xml Fri Oct 23 22:16:36 2015
@@ -111,6 +111,7 @@
<item href="dynamic_columns.html" name="Dynamic Columns"/>
<item href="skip_scan.html" name="Skip Scan"/>
<item href="salted.html" name="Salted Tables"/>
+ <item href="rowtimestamp.html" name="Row Timestamp Column"/>
</menu>
<menu name="Reference">
<item href="language/index.html" name="Grammar"/>