[ 
https://issues.apache.org/jira/browse/CASSANDRA-2474?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13095666#comment-13095666
 ] 

Pavel Yaskevich commented on CASSANDRA-2474:
--------------------------------------------

bq. we probably don't want the colons in the default aliases

I think we better have them so users won't get confused

bq. it would be good to make composite columns less of a special case. Instead 
of "column" for a normal column and "parent/column" for supercolumns and 
"component1..componentN" for composite, use component1 for normal, component1/2 
for super, component1/N for composite.

Maybe it is better if we will support (..,..,..) notation for composite 
columns, replace :column with :name and leave :parent for supercolumns? It will 
allow us to drop special casing. As I mentioned in my previous comment:

{noformat}
SELECT :name as (date, company), :value as price FROM stockhist WHERE 
<key_alias>='GOOG' AND date >= '2011-01-02' LIMIT 50

and

SELECT :parent as company, :name as (date, <attr>), :value as price FROM 
stockhist WHERE company='GOOG' AND date >= '2011-01-02' AND <key_alias> = '...' 
LIMIT 50
{noformat}

I'm not very familiar with composite columns by from what I can see we are 
forced to work with what we have in the statement without re-creation because 
even in your example when we will try to add a new <location> field it will be 
very hard to guess how column name was looking previously...

> 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
>            Assignee: Pavel Yaskevich
>              Labels: cql
>             Fix For: 1.0
>
>         Attachments: screenshot-1.jpg, screenshot-2.jpg
>
>
> 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

        

Reply via email to