[
https://issues.apache.org/jira/browse/CASSANDRA-2474?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13087699#comment-13087699
]
T Jake Luciani edited comment on CASSANDRA-2474 at 8/19/11 1:27 PM:
--------------------------------------------------------------------
I think the best we can do with no major changes to HiveQL is:
{code}
SELECT transposed(column) FROM foo WHERE key=X
{code}
This will return:
rowkey, subcol1, subcol2 ...
You could then also do supercol slices like transposed(column, start, end)
Looking at hive you can make functions return many columns:
http://massapi.com/source/hive-0.5.0-dev/src/contrib/src/java/org/apache/hadoop/hive/contrib/udtf/example/GenericUDTFExplode2.java.html
was (Author: tjake):
I think the best we can do with no major changes to HiveQL is:
{code}
SELECT transposed(column) FROM foo WHERE key=X
{code}
This will return:
rowkey, column, subcol, value
You could then also do supercol slices like transposed(column, start, end)
Looking at hive you can make functions return many columns:
http://massapi.com/source/hive-0.5.0-dev/src/contrib/src/java/org/apache/hadoop/hive/contrib/udtf/example/GenericUDTFExplode2.java.html
> 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
