Re: RE: RE: [EXTERNAL] Cluster is unbalanced

2018-06-20 Thread Joshua Galbraith
>Also, our partition keys are not distributed evenly as I had pasted output earlier. Thanks, I see that now. Can you share the full output of nodetool tablestats and nodetool tablehistograms? Out of curiosity, are you running repairs on this cluster? If so, what type of repairs are you running a

Re: RE: RE: [EXTERNAL] Cluster is unbalanced

2018-06-20 Thread learner dba
Hi Joshua, Okay, that string appears to be a base64-encoded version 4 UUID. Why not use Cassandra's UUID data type to store that directly rather than storing the longer base64 string as text?  --> It's an old application and the person who coded it, has left the company.What does the UUID repr

Re: RE: RE: [EXTERNAL] Cluster is unbalanced

2018-06-20 Thread Joshua Galbraith
Okay, that string appears to be a base64-encoded version 4 UUID. Why not use Cassandra's UUID data type to store that directly rather than storing the longer base64 string as text? What does the UUID represent? Is it identifying a unique product, an image, or some other type of object? When and how

Re: RE: RE: [EXTERNAL] Cluster is unbalanced

2018-06-20 Thread learner dba
Partition key has value as:  MWY4MmI0MTQtYTk2YS00YmRjLTkxNDMtOWU0MjM1OWU2NzUy other column is blob. On Tuesday, June 19, 2018, 6:07:59 PM EDT, Joshua Galbraith wrote: > id text PRIMARY KEY What values are written to this id field? Can you give us some examples or explain the general

Re: RE: RE: [EXTERNAL] Cluster is unbalanced

2018-06-19 Thread Joshua Galbraith
> id text PRIMARY KEY What values are written to this id field? Can you give us some examples or explain the general use case? On Tue, Jun 19, 2018 at 1:18 PM, learner dba wrote: > Hi Sean, > > Here is create table: > > CREATE TABLE ks.cf ( > > id text PRIMARY KEY, > > accessdata blob >

Re: RE: RE: [EXTERNAL] Cluster is unbalanced

2018-06-19 Thread learner dba
Hi Sean, Here is create table: CREATE TABLE ks.cf (     id text PRIMARY KEY,     accessdata blob ) WITH bloom_filter_fp_chance = 0.01     AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}     AND comment = ''     AND compaction = {'class': 'org.apache.cassandra.db.compaction.Size