Re: Repair corrupt SSTable from power outage?

2015-10-06 Thread John Anderson
t;> sstablescrub successfully. >> >> I restarted my nodes with disk failure policy "best_effort", then I run >> the "nodetool scrub " >> >> Once done I removed the corrupt tables manually and started repair >> >> >> On Thu, O

Reading hundreds of thousands of rows at once?

2015-04-22 Thread John Anderson
Hey, I'm looking at querying around 500,000 rows that I need to pull into a Pandas data frame for processing. Currently testing this on a single cassandra node it takes around 21 seconds: https://gist.github.com/sontek/4ca95f5c5aa539663eaf I tried introducing multiprocessing so I could use 4

Data Modeling help for representing a survey form.

2013-08-30 Thread John Anderson
I have an existing system in postgres that I would like to move to cassandra. The system is for building registration forms for conferences. For example, you might want to build a registration form (or survey) that has a bunch of questions on it. An overview of this system I whiteboarded here: