What does “hash” Data look like?
Rahul On Jul 24, 2018, 11:30 AM -0400, Arpan Khandelwal <arpan...@gmail.com>, wrote: > I need to clone data from one keyspace to another keyspace. > We do it by taking snapshot of keyspace1 and restoring in keyspace2 using > sstableloader. > > Suppose we have following table with index on hash column. Table has around > 10M rows. > --------------------- > CREATE TABLE message ( > id uuid, > messageid uuid, > parentid uuid, > label text, > properties map<text,text>, > text1 text, > text2 text, > text3 text, > category text, > hash text, > info map<text,text>, > creationtimestamp bigint, > lastupdatedtimestamp bigint, > PRIMARY KEY ( (id) ) > ); > > CREATE INDEX ON message ( hash ); > --------------------- > Cassandra crashes when i load data using sstableloader. Load is happening > correctly but seems that cassandra crashes when its trying to build index on > table with huge data. > > I have two questions. > 1. Is there any better way to clone keyspace? > 2. How can i optimize sstableloader to load data and not crash cassandra > while building index. > > Thanks > Arpan