amrishlal opened a new pull request #7511:
URL: https://github.com/apache/pinot/pull/7511


   ## Description
   This PR allows for supporting top-level array path expressions 
(`jsonColumn[1]` in the query below) in JSON queries.
   
   `SELECT jsonColumn[1] FROM testTable WHERE intColumn=14`
   
   **Note:**
   Ideally top-level path expressions should be specified as 
`jsonColumn.[1]`(dot between column name and array subscript). However, Calcite 
parser will throw error with this path expressions and hence as a workaround 
this PR is adding support for specifying top-level path expressions as 
`jsonColumn[1]` (without any dot). This latter path expression should be 
treated as a shortcut to the former path expression (and is not expected to 
cause any compatibility issues if and when we add support for full json path 
expressions in Calcite grammar).
   
   ## Upgrade Notes
   Does this PR prevent a zero down-time upgrade? (Assume upgrade order: 
Controller, Broker, Server, Minion)
   * [ ] Yes (Please label as **<code>backward-incompat</code>**, and complete 
the section below on Release Notes)
   
   Does this PR fix a zero-downtime upgrade introduced earlier?
   * [ ] Yes (Please label this as **<code>backward-incompat</code>**, and 
complete the section below on Release Notes)
   
   Does this PR otherwise need attention when creating release notes? Things to 
consider:
   - New configuration options
   - Deprecation of configurations
   - Signature changes to public methods/interfaces
   - New plugins added or old plugins removed
   * [ ] Yes (Please label this PR as **<code>release-notes</code>** and 
complete the section on Release Notes)
   ## Release Notes
   <!-- If you have tagged this as either backward-incompat or release-notes,
   you MUST add text here that you would like to see appear in release notes of 
the
   next release. -->
   
   <!-- If you have a series of commits adding or enabling a feature, then
   add this section only in final commit that marks the feature completed.
   Refer to earlier release notes to see examples of text.
   -->
   ## Documentation
   <!-- If you have introduced a new feature or configuration, please add it to 
the documentation as well.
   See 
https://docs.pinot.apache.org/developers/developers-and-contributors/update-document
   -->
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to