[jira] [Created] (PHOENIX-1009) Support AS OF (flashback) feature

["alex kamil (JIRA)" <ji...@apache.org>]

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)