cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "cristina rodriguez (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CASSANDRA-4853) composite row key
Date Wed, 24 Oct 2012 15:50:12 GMT
cristina rodriguez created CASSANDRA-4853:
---------------------------------------------

             Summary: composite row key
                 Key: CASSANDRA-4853
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4853
             Project: Cassandra
          Issue Type: Task
          Components: Documentation & website
    Affects Versions: 1.1.5
            Reporter: cristina rodriguez


I have a columnfamily with a composite key,

create column family MyCF
    with key_validation_class = 'CompositeType(UTF8Type, UTF8Type)'
    and comparator = 'CompositeType(UTF8Type, UTF8Type)'
    and default_validation_class='CompositeType(UTF8Type, UTF8Type)'
   
    ;

i store the row key with the value 1:1 ,1:2,1:3

-------------------
RowKey: 1:1
=> (column=colum1, value=value1, timestamp=1351093372962000)
-------------------
RowKey: 2:2
=> (column=colum1, value=value1, timestamp=1351093411137000)
-------------------
RowKey: 1:3
=> (column=colum1, value=value1, timestamp=1351093385820000)
-------------------
RowKey: 2:1
=> (column=colum1, value=value1, timestamp=1351093401162000)
-------------------
RowKey: 1:2
=> (column=colum1, value=value1, timestamp=1351093379274000)
-------------------
RowKey: 2:3
=> (column=colum1, value=value1, timestamp=1351093421393000)

i want to get all the row that estar wit 1,with cql  whit all that i read i thought it could
be posible, but i coudnĀ“t do it. 
i thought it would work with
select * from MyCF where key'1:';
any idea or example? 

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message