[
https://issues.apache.org/jira/browse/CASSANDRA-2474?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13088958#comment-13088958
]
Jonathan Ellis edited comment on CASSANDRA-2474 at 8/22/11 7:44 PM:
--------------------------------------------------------------------
bq. Rather than trying to support all this flexibility on the fly in Hive, why
don't we let users create transposed projections in the DML?
I like that idea, as the next best thing to finding a syntax that works well
for both Hive and CQL.
So for CQL, I think we're close with the "transposed" idea. As explained
above, this allows using "'real' WHERE clauses [so] we get all the benefits of
regularity that implies."
I did note one problem with the transposed(x, y, z) syntax, though: you lose
the ability to compose with other functions in the SELECT clause. Currently
that just means count(), but it's conceivable that we'd add scalar functions
like sqrt(), or even aggregation like sum().
So I propose adding ".transposed" to the table name instead:
{noformat}
SELECT tweet_id, username, timestamp
FROM timeline.transposed
WHERE user_id='jbellis'
LIMIT 50
{noformat}
was (Author: jbellis):
bq. Rather than trying to support all this flexibility on the fly in Hive,
why don't we let users create transposed projections in the DML?
I like that idea, as the next best thing to finding a syntax that works well
for both Hive and CQL.
So for CQL, I think we're close with the "transposed" idea. As explained
above, "we have "real" WHERE clauses we get all the benefits of regularity that
implies."
I did note one problem with the transposed(x, y, z) syntax, though: you lose
the ability to compose with other functions in the SELECT clause. Currently
that just means count(), but it's conceivable that we'd add scalar functions
like sqrt(), or even aggregation like sum().
So I propose adding ".transposed" to the table name instead:
{noformat}
SELECT tweet_id, username, timestamp
FROM timeline.transposed
WHERE user_id='jbellis'
LIMIT 50
{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
