Re: any better way to retrieve data than using get_range_slices

2010-07-29 Thread Ken Matsumoto
Thank you, Aaron. Yes, we're now thinking Hadoop would be one of choices, too. So far, it doesn't matter if we use "SQL" or not as long as Cassandra can process millions of rows at a time in a practical time. As a result, what kind of patterns should be Cassandra more powerful than MySQL from t

Re: any better way to retrieve data than using get_range_slices

2010-07-28 Thread Aaron Morton
If you want to process millions of rows at a time take a look at the Hadoop and Pig integration. Try the Cloudera distro of Hadoop CHD3 it includes Pig with it. Pig is a "SQL" like language for doing large scale data analysis that compiles down to Java that is run in Hadoop jobs. http://hadoop.apac

any better way to retrieve data than using get_range_slices

2010-07-28 Thread Ken Matsumoto
Hi all, Are there any better way to retrieve data from Cassandra than using get_range_slices? Now I'm going to port some programs using MySQL to Cassandra. The program query is like below: "select * from Table_A where date > 1/1/2008 and date < 12/31/2009 and locationID = 1" The result of