[PHOENIX-7044] Support Index on a generated column that extracts a scalar value from the JSON column

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Resolved
• Component/s: phoenix
• Assignee: Ranganath Govardhanagiri
• Reporter: Ranganath Govardhanagiri
• Created: 20/Sep/23 08:28
• Updated: 09/Nov/23 06:00
• Resolved: 09/Nov/23 06:00

Description

As per the Design doc attached we can implement the below proposal:

Using index expressions: Phoenix lets index’s PK to be defined as certain expressions. Aggregate (sum()), stateless(a constant value) or non-deterministic(rand()) is not allowed. But expressions like (mycol/2) is allowed. The Json function could be used as expression with some code changes. 

Issue Links

• links to: GitHub Pull Request #1708