[
https://issues.apache.org/jira/browse/CASSANDRA-2474?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13079777#comment-13079777
]
Jonathan Ellis commented on CASSANDRA-2474:
-------------------------------------------
Coming back to this. Maybe the best idea so far is Jake's hint:
{noformat}
SELECT /*+TRANSPOSED*/ subcolumn, value FROM foo WHERE key=X and column=Y;
{noformat}
I have to say though that I still think this is ugly as sin. :-|
But I can't come up with anything better that doesn't require the Hive
metastore.
Is the Hive driver flexible enough that we can add syntax?
{noformat}
SELECT TRANSPOSED subcolumn, value FROM foo WHERE key=X and column=Y;
{noformat}
> 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
