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

ASF GitHub Bot commented on METAMODEL-195:
------------------------------------------

Github user albertostratio commented on a diff in the pull request:

    https://github.com/apache/metamodel/pull/70#discussion_r47059543
  
    --- Diff: core/src/main/java/org/apache/metamodel/query/SelectItem.java ---
    @@ -192,7 +223,7 @@ public SelectItem(FunctionType function, String 
expression, String alias) {
          *            the FromItem that holds the sub-query
          */
         public SelectItem(SelectItem subQuerySelectItem, FromItem 
subQueryFromItem) {
    -        this(null, subQueryFromItem, null, null, subQuerySelectItem, null, 
false);
    +        this(null, subQueryFromItem, null, null, null, subQuerySelectItem, 
null, false);
             if (subQueryFromItem.getSubQuery() == null) {
    --- End diff --
    
    Same comment as above


> Scalar function to get key from a MAP type field
> ------------------------------------------------
>
>                 Key: METAMODEL-195
>                 URL: https://issues.apache.org/jira/browse/METAMODEL-195
>             Project: Apache MetaModel
>          Issue Type: Improvement
>            Reporter: Kasper Sørensen
>
> Now that we have support for scalar functions, and we also support a host of 
> key/value or document oriented datastores, I think it would be really natural 
> to support a function for getting a value inside a map.
> Example:
> {code}
> SELECT MAP_VALUE(address, 'street') FROM contacts
> {code}
> Ideally the function would allow for a full "path" of keys so that you could 
> have maps-within-maps and so on.
> {code}
> SELECT MAP_VALUE(address, 'homeaddress.street') FROM contacts
> {code}
> Even more ideally we would also add a bit of query parser logic to allow 
> expressing the path as part of the operand itself:
> {code}
> SELECT address.homeaddress.street FROM contacts
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to