View Cassandra Partitions using CQLSH -


using cassandra, how see how many partitions created base on how created primary key? have been following tutorial , mentions go bin/cassandra-cli , use list command. however, latest cassandra install not come , have read other articles online have indicated cli deprecated.

is there anyway me see partitions created using cqlsh?

thanks in advance!

first of have investigate cassandra.yaml file see number of tokens configured. tells how many partitions each node own:

$ grep num_tokens conf/cassandra.yaml ... num_tokens: 128 ... $ grep initial_token conf/cassandra.yaml ... # initial_token: 1 ...

if initial token commented out, means node figure out it's own partition ranges during start-up.

next can check partition ranges using nodetool ring command:

$ bin/nodetool ring  datacenter: dc1 ========== address    rack        status state   load            owns                token                                                                                                                  9167006318991683417                          127.0.0.2  r1          down   normal  ?               ?                   -9178420363247798328                         127.0.0.2  r1          down   normal  ?               ?                   -9127364991967065057                         127.0.0.3  r1          down   normal  ?               ?                   -9063041387589326037

this shows partition range belongs node in cluster.

in example above each node owns 128 partition ranges. range between -9178420363247798327 , -9127364991967065057 belongs node 127.0.0.2.

you can use simple select tell each row's partition key:

cqlsh:mykeyspace> select token(key), key, added_date, title mytable;   system.token(key)    | key       | added_date               | title ----------------------+-----------+--------------------------+----------------------  -1651127669401031945 |  first    | 2013-10-16 00:00:00+0000 | hello world  -1651127669401031945 |  first    | 2013-04-16 00:00:00+0000 | bye world    356242581507269238 | second    | 2014-01-29 00:00:00+0000 | lorem ipsum    356242581507269238 | second    | 2013-03-17 00:00:00+0000 | today tomorrow    356242581507269238 | second    | 2012-04-03 00:00:00+0000 | it's meet  (5 rows)

finding partition key in partition ranges tell record stored.

also can use nodetool same in 1 simple step:

$ bin/nodetool getendpoints mykeyspace mytable 'first' 127.0.0.1 127.0.0.2

this tells records partition key 'first' located.

note: if of nodes down, getendpoints command won't list nodes, though should store record based on replication settings.


Comments

Post a Comment

Popular posts from this blog

angular - Ionic slides - dynamically add slides before and after -

hi i'm using ngfor create set of 3 slides while starting in middle i'm guaranteed able slide left or right on start. when slide right can simple listen reachedend , push slide array i'm looping. but have problem adding slide beginning. if same above , use e.g. array.unshift() or spread add item beginning, view think it's on position 0 , snaps view new slide. the code below work animates slide change index 1. slide = [0,1,2] //example loop slidechanged(event) { if(this.slides.isbeginning()){ this.slide = [this.slide[0]-1, ...this.slide]; this.slides.update(); this.slides.slideto(1) } } <ion-slides [initialslide]="1" (ionslidedidchange)="slidechanged($event)"> <ion-slide *ngfor="let item of slide"> <h1>slide {{item}}</h1> </ion-slide> </ion-slides> any appreciated! you can using ionslidenextend , ionslideprevend events slides . please
Read more

minify - Minimizing css files -

i want know how css files can minimized. currently, using external sites css minifier compress css files. however, after removing whitespaces, comments, etc, file sizes reduced 10-15%. how frameworks bootstrap manage make minimized versions kilobytes. as example, css is: body { background-color: #ff0; } the reduction goes 28 bytes 22 bytes other css files have lot more characters still smaller this. actually minifying code means it's remove thing code white space characters new line characters comments block delimiters it reduces amount of code has transferred on web , speed site load fastly.but unreadable format.
Read more

Add a dynamic header in angular 2 http provider -

i have http interceptor built via tutorial https://scotch.io/@kashyapmukkamala/using-http-interceptor-with-angular2 the problem need have dynamic header changes automatically once changes 'mode' in app. service able tell interceptor change header, or have interceptor pull header (which string)from service each request. able throwing away patch method, call http.patch('new header string') set header string. call in service controls 'mode' setting. wondering if there way interceptor pull recent value service each request or if can add method http provider via interceptor? i've tried call service in interceptor each request returns undefined. because creating new instance of service or copying value before service fired , loaded/changed data. i don't want pass header string every http provider call because defeats purpose of having interceptor, id able set once changes or have provider fetch service before makes request. tl;dr : need add autom
Read more