incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Greg Fausak <g...@named.com>
Subject CQL / cli question
Date Wed, 08 Aug 2012 00:38:30 GMT
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

Mime
View raw message