[
https://issues.apache.org/jira/browse/PHOENIX-1009?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14012593#comment-14012593
]
James Taylor commented on PHOENIX-1009:
---------------------------------------
+1. That's a cool idea, [~alexdl].
> Support AS OF (flashback) feature
> ---------------------------------
>
> Key: PHOENIX-1009
> URL: https://issues.apache.org/jira/browse/PHOENIX-1009
> Project: Phoenix
> Issue Type: Improvement
> Reporter: alex kamil
> Priority: Minor
>
> Add support for SELECT AS OF TIMESTAMP ("flashback") feature to allow
> point-in-time SQL queries.
> Be able to specify the AS OF clause for a single-table, multiple-tables
> (joins) as well as specify different times for different tables.
> The AS OF timestamp clause can also be used inside UPSERT SELECT and
> correlated sub-queries.
> example:
> SELECT * FROM table1
> AS OF TIMESTAMP
> TO_TIMESTAMP('2004-04-04 09:30:00', 'YYYY-MM-DD HH:MI:SS')
> WHERE name = 'abc';
> or
> select * from
> (select * from emp where ept=10)
> AS OF TIMESTAMP TO_TIMESTAMP(SYSDATE-1)
--
This message was sent by Atlassian JIRA
(v6.2#6252)
