[
https://issues.apache.org/jira/browse/PHOENIX-1009?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
alex kamil updated PHOENIX-1009:
--------------------------------
Description:
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)
was:
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;
> 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)
