Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: neutral (athena.apache.org: local policy)
MIME-Version: 1.0
Date: Tue, 7 Aug 2012 19:38:30 -0500
Message-ID: 
 <CAJ=yfkMKQu4UVKH5WbCFv76+jJ4bZ6LpPym6aPbScAvFhUwLaw@mail.gmail.com>
Subject: CQL / cli question
From: Greg Fausak <greg@named.com>
To: user <user@cassandra.apache.org>
Content-Type: text/plain; charset=ISO-8859-1

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