Created
November 21, 2018 16:26
-
-
Save tkroman/3f7da4197dc8636d769d3e4ac18145d9 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
cqlsh:ks> CREATE TABLE collection_table( k int primary key, l list<text>, s set<text>, m map<text, int>); | |
cqlsh:ks> insert into collection_table (k, l, s, m) values (1, ['a','b','c'], {'a','b','c'}, {'a':1,'b':2,'c':3}); | |
cqlsh:ks> select * from collection_table; | |
@ Row 1 | |
---+-------------------------- | |
k | 1 | |
l | ['a', 'b', 'c'] | |
m | {'a': 1, 'b': 2, 'c': 3} | |
s | {'a', 'b', 'c'} | |
(1 rows) | |
Tracing session: 9c8be570-eda9-11e8-99e2-399d8477c401 | |
activity | timestamp | source | source_elapsed | client | |
-----------------------------------------------------------------------------------------------------------------------+----------------------------+------------+----------------+------------ | |
Execute CQL3 query | 2018-11-21 18:22:16.647000 | 172.17.0.6 | 0 | 172.17.0.1 | |
Parsing select * from collection_table \n; [SharedPool-Worker-1] | 2018-11-21 18:22:16.649000 | 172.17.0.6 | 1155 | 172.17.0.1 | |
Preparing statement [SharedPool-Worker-1] | 2018-11-21 18:22:16.651000 | 172.17.0.6 | 3697 | 172.17.0.1 | |
Computing ranges to query [SharedPool-Worker-1] | 2018-11-21 18:22:16.655000 | 172.17.0.6 | 8158 | 172.17.0.1 | |
Submitting range requests on 257 ranges with a concurrency of 1 (0.0 rows per range expected) [SharedPool-Worker-1] | 2018-11-21 18:22:16.658000 | 172.17.0.6 | 10987 | 172.17.0.1 | |
Submitted 1 concurrent range requests [SharedPool-Worker-1] | 2018-11-21 18:22:16.660000 | 172.17.0.6 | 13183 | 172.17.0.1 | |
Executing seq scan across 0 sstables for (min(-9223372036854775808), min(-9223372036854775808)] [SharedPool-Worker-2] | 2018-11-21 18:22:16.660000 | 172.17.0.6 | 13319 | 172.17.0.1 | |
Read 1 live and 0 tombstone cells [SharedPool-Worker-2] | 2018-11-21 18:22:16.661000 | 172.17.0.6 | 13684 | 172.17.0.1 | |
Request complete | 2018-11-21 18:22:16.668217 | 172.17.0.6 | 21217 | 172.17.0.1 | |
cqlsh:ks> update collection_table set l = l + ['d'], s = s + {'d'}, m = m + {'d': 4} where k = 1; | |
cqlsh:ks> select * from collection_table ; | |
@ Row 1 | |
---+---------------------------------- | |
k | 1 | |
l | ['a', 'b', 'c', 'd'] | |
m | {'a': 1, 'b': 2, 'c': 3, 'd': 4} | |
s | {'a', 'b', 'c', 'd'} | |
(1 rows) | |
Tracing session: fa93db50-eda9-11e8-99e2-399d8477c401 | |
activity | timestamp | source | source_elapsed | client | |
-----------------------------------------------------------------------------------------------------------------------+----------------------------+------------+----------------+------------ | |
Execute CQL3 query | 2018-11-21 18:24:54.406000 | 172.17.0.6 | 0 | 172.17.0.1 | |
Parsing select * from collection_table ; [SharedPool-Worker-1] | 2018-11-21 18:24:54.406000 | 172.17.0.6 | 423 | 172.17.0.1 | |
Preparing statement [SharedPool-Worker-1] | 2018-11-21 18:24:54.406000 | 172.17.0.6 | 687 | 172.17.0.1 | |
Computing ranges to query [SharedPool-Worker-1] | 2018-11-21 18:24:54.407000 | 172.17.0.6 | 1087 | 172.17.0.1 | |
Submitting range requests on 257 ranges with a concurrency of 1 (0.0 rows per range expected) [SharedPool-Worker-1] | 2018-11-21 18:24:54.407000 | 172.17.0.6 | 1569 | 172.17.0.1 | |
Submitted 1 concurrent range requests [SharedPool-Worker-1] | 2018-11-21 18:24:54.408000 | 172.17.0.6 | 2651 | 172.17.0.1 | |
Executing seq scan across 0 sstables for (min(-9223372036854775808), min(-9223372036854775808)] [SharedPool-Worker-3] | 2018-11-21 18:24:54.409000 | 172.17.0.6 | 2970 | 172.17.0.1 | |
Read 1 live and 0 tombstone cells [SharedPool-Worker-3] | 2018-11-21 18:24:54.410000 | 172.17.0.6 | 4100 | 172.17.0.1 | |
Request complete | 2018-11-21 18:24:54.415776 | 172.17.0.6 | 9776 | 172.17.0.1 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment