alex kamil created PHOENIX-1009:
-----------------------------------
Summary: 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 SYSDATE ? 1;
--
This message was sent by Atlassian JIRA
(v6.2#6252)
