[PHOENIX-6434] Secondary Indexes on PHOENIX_ROW_TIMESTAMP()

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 5.1.0, 4.16.0
• Fix Version/s: 4.16.1, 5.2.0, 5.1.2
• Assignee: Unassigned
• Reporter: Kadir Ozdemir
• Created: 30/Mar/21 21:36
• Updated: 23/Apr/21 03:38
• Resolved: 22/Apr/21 19:57

Description

PHOENIX-5629 introduced the function PHOENIX_ROW_TIMESTAMP() that returns the last modified time of a row. PHOENIX_ROW_TIMESTAMP() can be used as a projection column and referred in a WHERE clause. It is desirable to have indexes on row timestamps. This will result in fast time range queries. 

Issue Links

• links to: GitHub Pull Request #1194