cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Akbar Pirani <>
Subject RE: Accessing dynamic columns via cqlsh
Date Thu, 15 Oct 2015 15:09:10 GMT
I do not think that cqlsh provides a way to get internal data. I hope I am wrong...

-----Original Message-----
From: Onur Yalaz─▒ []
Sent: Thursday, October 15, 2015 10:54 AM
Subject: Accessing dynamic columns via cqlsh


I have a cassandra cluster from pre-cql era and I am having problems accessing data via cqlsh.
As you can see below, I can not reach dynamic columns via cqlsh but they are accessible via

How can I make the data shown on cqlsh?

cqlsh:automation> select * from "EventKeys" where key='b5f0d4be-c0fc-4dc4-8e38-0a00e4552866'

  key                                        |eventId
  b5f0d4be-c0fc-4dc4-8e38-0a00e4552866 | ce3b0c03-dcce-4522-a35a-864909cb024f

(1 rows)

[default@keyspace] get EventKeys['b5f0d4be-c0fc-4dc4-8e38-0a00e4552866'];
=> (name=actionId, value=3038...............643333623661656362653939,
=> (name=code, b0a..........0a0a, timestamp=1431608711629003) => (name=eventId, value=ce3b0c03-dcce-4522-a35a-864909cb024f,
Returned 3 results.

ColumnFamily Description:
     ColumnFamily: EventKeys
       Key Validation Class: org.apache.cassandra.db.marshal.AsciiType
       Default column value validator:
       Cells sorted by: org.apache.cassandra.db.marshal.UTF8Type
       GC grace seconds: 864000
       Compaction min/max thresholds: 4/32
       Read repair chance: 0.1
       DC Local Read repair chance: 0.0
       Populate IO Cache on flush: false
       Replicate on write: true
       Caching: KEYS_ONLY
       Default time to live: 0
       Bloom Filter FP chance: 0.01
       Index interval: 128
       Speculative Retry: 99.0PERCENTILE
       Built indexes: [EventKeys.eventkeys_eventid_idx]
       Column Metadata:
         Column Name: scenarioId
           Validation Class: org.apache.cassandra.db.marshal.AsciiType
           Index Name: eventkeys_eventid_idx
           Index Type: KEYS
           Index Options: {}
       Compaction Strategy:
       Compaction Strategy Options:
         min_threshold: 4
         max_threshold: 32
       Compression Options:

CQL Desc of the table:

CREATE TABLE "EventKeys" (
   key ascii,
   "eventId" ascii,
   PRIMARY KEY (key)
   bloom_filter_fp_chance=0.010000 AND
   caching='KEYS_ONLY' AND
   comment='' AND
   dclocal_read_repair_chance=0.000000 AND
   gc_grace_seconds=864000 AND
   index_interval=128 AND
   read_repair_chance=0.100000 AND
   replicate_on_write='true' AND
   populate_io_cache_on_flush='false' AND
   default_time_to_live=0 AND
   speculative_retry='99.0PERCENTILE' AND
   memtable_flush_period_in_ms=0 AND
   compaction={'min_threshold': '4', 'class':
'SizeTieredCompactionStrategy', 'max_threshold': '32'} AND
   compression={'sstable_compression': 'SnappyCompressor'}; CREATE INDEX eventkeys_eventid_idx
ON "EventKeys" ("eventId");

This e-mail and any attachments, contain SP Richards confidential information that is proprietary,
privileged, and protected by applicable laws. If you have received this message in error and
are not the intended recipient, you should not retain, distribute, disclose or use any of
this information and you should destroy this e-mail, any attachments or copies therein forthwith.
Please notify the sender immediately by e-mail if you have received this e-mail in error.
View raw message