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

["ASF GitHub Bot (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/PHOENIX-7044?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17774827#comment-17774827 ] 

ASF GitHub Bot commented on PHOENIX-7044:
-----------------------------------------

ranganathg opened a new pull request, #1708:
URL: https://github.com/apache/phoenix/pull/1708

   …alar value from the JSON column




> Support Index on a generated column that extracts a scalar value from the JSON column
> -------------------------------------------------------------------------------------
>
>                 Key: PHOENIX-7044
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-7044
>             Project: Phoenix
>          Issue Type: Sub-task
>          Components: phoenix
>            Reporter: Ranganath Govardhanagiri
>            Assignee: Ranganath Govardhanagiri
>            Priority: Major
>
> 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. 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)