cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jawahar Prasad JP (Commented) (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-3761) CQL 3.0
Date Mon, 23 Jan 2012 08:48:38 GMT

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

Jawahar Prasad JP commented on CASSANDRA-3761:
----------------------------------------------

Ok. I got it. Another question:

1. For example: I have columnfamily to store the broken links :

	broken_link_id uuid PRIMARY KEY,
	site_id uuid,
	site_url text,
	page_url text,
	broken_link text,
	anchor_text text,
	tstamp timestamp

I want something like this:
site_id, site_url, page_url, {broken_link_id,broken_link,anchor_text,tstamp}

I came up with this WRONG version:
CREATE COLUMNFAMILY broken_links (
	broken_link_id uuid,	
	site_id uuid,
	site_url text,
	page_url text,
	broken_link text,
	anchor_text text,
	tstamp timestamp,
	PRIMARY KEY(site_id, site_url, page_url)
);
Can you let me know how do I write this correctly please ? Or is there any doc to take a look
at this(for CQL) ?

2. How do you know what columns to be considered as composite based on PRIMARY KEY?
                
> CQL 3.0
> -------
>
>                 Key: CASSANDRA-3761
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-3761
>             Project: Cassandra
>          Issue Type: New Feature
>          Components: API
>            Reporter: Sylvain Lebresne
>              Labels: cql
>             Fix For: 1.1
>
>         Attachments: 0001-CQL-3.0.patch, 0002-Add-support-for-switching-the-CQL-version.patch,
0003-Makes-batches-atomic.patch, 0004-Thrift-gen-files.patch, cql_tests.py, create_cf_syntaxes.txt
>
>
> This ticket is a reformulation/generalization of CASSANDRA-2474. The core change of CQL
3.0 is to introduce the new syntaxes that were discussed in CASSANDRA-2474 that allow to:
> # Provide a better/more native support for wide rows, using the idea of transposed vie.
> # The generalization to composite columns.
> The attached text file create_cf_syntaxes.txt recall the new syntaxes introduced.
> The changes proposed above allow (and strongly suggest in some cases) a number of other
changes to the language that this ticket proposes to explore/implement (more details coming
in the comments).

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message