[
https://issues.apache.org/jira/browse/DRILL-4223?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16388637#comment-16388637
]
Ted Dunning commented on DRILL-4223:
------------------------------------
This is actually related to list_aggregate and some kind of inverse to
flatten/unnest. My guess is that if we had a JSON constructor, this would be
just about as good. The idea would be that columns could be specified to
determine the key and value in an object. Aggregation would be the final step
to get what John wants. Aggregation over structures is an open question since
you don't necessarily know the keys in a structure. It would be nice to be able
to apply an aggregation function to all members of the structure without
knowing which members exist.
> PIVOT and UNPIVOT to rotate table valued expressions
> ----------------------------------------------------
>
> Key: DRILL-4223
> URL: https://issues.apache.org/jira/browse/DRILL-4223
> Project: Apache Drill
> Issue Type: New Feature
> Components: Execution - Codegen, SQL Parser
> Reporter: Ashwin Aravind
> Priority: Major
>
> Capability to PIVOT and UNPIVOT table values expressions which are results of
> a SELECT query
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
