[ 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