RE: Accessing dynamic columns via cqlsh

[Akbar Pirani]

I do not think that cqlsh provides a way to get internal data. I hope I am 
wrong...

-----Original Message-----
From: Onur Yalazı [mailto:onur.yal...@8digits.com]
Sent: Thursday, October 15, 2015 10:54 AM
To: user@cassandra.apache.org
Subject: Accessing dynamic columns via cqlsh

Hello,

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 cassandra-cli.

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,
timestamp=1431608711629002)
=> (name=code, b0a..........0a0a, timestamp=1431608711629003) => (name=eventId, 
value=ce3b0c03-dcce-4522-a35a-864909cb024f,
timestamp=1431608711629000)
Returned 3 results.


ColumnFamily Description:
     ColumnFamily: EventKeys
       Key Validation Class: org.apache.cassandra.db.marshal.AsciiType
       Default column value validator:
org.apache.cassandra.db.marshal.BytesType
       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:
org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy
       Compaction Strategy Options:
         min_threshold: 4
         max_threshold: 32
       Compression Options:
         sstable_compression:
org.apache.cassandra.io.compress.SnappyCompressor


CQL Desc of the table:

CREATE TABLE "EventKeys" (
   key ascii,
   "eventId" ascii,
   PRIMARY KEY (key)
) WITH COMPACT STORAGE AND
   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.