Re: Configuring Cassandra to limit number of columns to read

2015-08-17 Thread Jonathan Haddad
What version of Cassandra are you running? On Fri, Aug 14, 2015 at 11:35 AM Ahmed Ferdous ahmed.ferd...@ze.com wrote: My mistake. I wanted to mean column keys. For each row, we have one column and for this column we have 250k+ column keys. When we are trying to load the list of column keys ,

Re: Configuring Cassandra to limit number of columns to read

2015-08-17 Thread Jonathan Haddad
Also, are you using Thrift? The terminology you're using, specifically column keys, suggests you are. On Mon, Aug 17, 2015 at 5:21 PM Jonathan Haddad j...@jonhaddad.com wrote: What version of Cassandra are you running? On Fri, Aug 14, 2015 at 11:35 AM Ahmed Ferdous ahmed.ferd...@ze.com

Configuring Cassandra to limit number of columns to read

2015-08-14 Thread Ahmed Ferdous
Hi Guys, We have designed a table to have rows with large number of columns (more than 250k). One of my colleagues, mistakenly ran a select on the and that caused the nodes to go out of memory. I was just wondering if there are ways to configure Cassandra 1. To limit number of columns that

Re: Configuring Cassandra to limit number of columns to read

2015-08-14 Thread Russell Bradberry
The idea that you have 250k columns is somewhat of an anti-pattern. In this case you would typically have a few columns and many rows, then just run a select with a limit clause in your partition. From: Jonathan Haddad Reply-To: user@cassandra.apache.org Date: Friday, August 14, 2015 at

RE: Configuring Cassandra to limit number of columns to read

2015-08-14 Thread Ahmed Ferdous
My mistake. I wanted to mean column keys. For each row, we have one column and for this column we have 250k+ column keys. When we are trying to load the list of column keys , Cassandra is having OOM error. Ahmed Ahmed Ferdous Systems Architect ZE PowerGroup Inc. Corporate: 604-244-1469

Re: Configuring Cassandra to limit number of columns to read

2015-08-14 Thread Jonathan Haddad
250k columns?As in, you have a CREATE TABLE statement that would have over 250K separate, typed fields? On Fri, Aug 14, 2015 at 11:07 AM Ahmed Ferdous ahmed.ferd...@ze.com wrote: Hi Guys, We have designed a table to have rows with large number of columns (more than 250k). One of my