You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "T Jake Luciani (JIRA)" <ji...@apache.org> on 2011/08/19 15:28:28 UTC
[jira] [Issue Comment Edited] (CASSANDRA-2474) CQL support for
compound columns
[ 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