You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Greg Fausak <gr...@named.com> on 2012/08/08 02:38:30 UTC
CQL / cli question
I think I'm having a major brain fart here, I am just not getting something.
I have the following CF declared in CQL -3
create columnfamily testCQL5( ac_event_id int, ac_c text,
ac_mtcreation bigint, ac_action text , ac_id text, PRIMARY KEY (ac_c,
ac_mtcreation));
I can do this:
cqlsh:op2> select * from testCQL5 where ac_c = '2099.t4.l1.cisco.com';
ac_c | ac_mtcreation | ac_action | ac_event_id | ac_id
----------------------+---------------+-----------+-------------+----------------
2099.t4.l1.cisco.com | 767473 | Suspense | 101 | a common comme
2099.t4.l1.cisco.com | 987987987 | UP | 123 | ThisIsMe
and this...
cqlsh:op2> select * from testCQL5 where ac_mtcreation > 600000 and
ac_mtcreation < 800000;
ac_c | ac_mtcreation | ac_action | ac_event_id | ac_id
----------------------+---------------+-----------+-------------+----------------
2099.t4.l1.cisco.com | 767473 | Suspense | 101 | a common comme
1171.t4.l1.cisco.com | 757473 | JACKSON | 100 | this is the ID
I can do this:
cqlsh:op2> select * from testCQL5 where ac_c = '2099.t4.l1.cisco.com'
and ac_mtcreation > 600000 and ac_mtcreation < 800000;
ac_c | ac_mtcreation | ac_action | ac_event_id | ac_id
----------------------+---------------+-----------+-------------+----------------
2099.t4.l1.cisco.com | 767473 | Suspense | 101 | a common comme
I can do the former query in the cli, using this statement:
[default@op2] get testCQL5['2099.t4.l1.cisco.com'];
=> (column=767473:ac_action, value=Suspense, timestamp=1344354369232000)
=> (column=767473:ac_event_id, value=e, timestamp=1344354369232001)
=> (column=767473:ac_id, value=a common comme, timestamp=1344354369232002)
=> (column=987987987:ac_action, value=UP, timestamp=1344354733386000)
=> (column=987987987:ac_event_id, value={, timestamp=1344355513787000)
=> (column=987987987:ac_id, value=ThisIsMe, timestamp=1344354749195000)
Returned 6 results.
How can I do the next two CQL queries using the cli? Or even a query
that tells me the
ac_mtcreation time of 767473?
create column family testcql5
with column_type = 'Standard'
and comparator =
'CompositeType(org.apache.cassandra.db.marshal.LongType,org.apache.cassandra.db.marshal.UTF8Type)'
and default_validation_class = 'UTF8Type'
and key_validation_class = 'UTF8Type'
and read_repair_chance = 0.1
and dclocal_read_repair_chance = 0.0
and gc_grace = 864000
and min_compaction_threshold = 4
and max_compaction_threshold = 32
and replicate_on_write = true
and compaction_strategy =
'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'
and caching = 'KEYS_ONLY'
and compression_options = {'sstable_compression' :
'org.apache.cassandra.io.compress.SnappyCompressor'};
I am really pulling my hair out over this. Any help would be appreciated!
Thanks,
-greg