[
https://issues.apache.org/jira/browse/CASSANDRA-2474?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13087505#comment-13087505
]
Jonathan Ellis commented on CASSANDRA-2474:
-------------------------------------------
What about this?
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-BuiltinTableGeneratingFunctions%28UDTF%29
Could we write a UDTF such that we could write
{code}
SELECT transposed(subcolumn, value) FROM foo WHERE key=X AND column=Y
{code}
I'm guessing that would require some modifications to the UTDF code, it looks
like it's single-column only now. But it shouldn't be much of a stretch to add
support for more (he says sight unseen), and it's in the "spirit" of the
existing UDTF goals.
I think the LATERAL VIEW stuff is kind of orthogonal to the UTDF per se.
Basically a way to allow using normal columns a select with UTDF because
otherwise their compiler is too dumb to handle mixing the two.
> CQL support for compound columns
> --------------------------------
>
> Key: CASSANDRA-2474
> URL: https://issues.apache.org/jira/browse/CASSANDRA-2474
> Project: Cassandra
> Issue Type: Sub-task
> Components: API, Core
> Reporter: Eric Evans
> Labels: cql
> Fix For: 1.0
>
>
> For the most part, this boils down to supporting the specification of
> compound column names (the CQL syntax is colon-delimted terms), and then
> teaching the decoders (drivers) to create structures from the results.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
