The cli is probably trying to read more data than it can keep in memory. Try using the LIMIT clause for the list statement, or getting a single row, to reduce the size of the read.
Alternatively try increase the heap size for the cassandra-cli in bin/cassandra-cli > Built indexes: [STUDENT.STUDENT_AGE_idx, > STUDENT.STUDENT_BIG_DECIMAL_idx, STUDENT.STUDENT_PERCENTAGE_idx, > STUDENT.STUDENT_ROLL_NUMBER_idx, STUDENT.STUDENT_SEMESTER_idx, > STUDENT.STUDENT_STUDENT_NAME_idx, STUDENT.STUDENT_UNIQUE_ID_idx] > > You have a lot of indexes there. Consider if they are all needed. cheers ----------------- Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com On 29/01/2013, at 10:41 PM, Rishabh Agrawal <rishabh.agra...@impetus.co.in> wrote: > Did u trt accessing this cf from CQL, I think it must work from there, also > try accessing it through any API and see if error persists. > > Thanks > Rishabh Agrawal > From: Kuldeep Mishra [mailto:kuld.cs.mis...@gmail.com] > Sent: Tuesday, January 29, 2013 2:51 PM > To: user@cassandra.apache.org > Subject: Re: getting error for decimal type data > > ColumnFamily: STUDENT > Key Validation Class: org.apache.cassandra.db.marshal.LongType > Default column value validator: > org.apache.cassandra.db.marshal.BytesType > Columns sorted by: org.apache.cassandra.db.marshal.UTF8Type > GC grace seconds: 864000 > Compaction min/max thresholds: 4/32 > Read repair chance: 0.1 > DC Local Read repair chance: 0.0 > Replicate on write: true > Caching: KEYS_ONLY > Bloom Filter FP chance: default > Built indexes: [STUDENT.STUDENT_AGE_idx, > STUDENT.STUDENT_BIG_DECIMAL_idx, STUDENT.STUDENT_PERCENTAGE_idx, > STUDENT.STUDENT_ROLL_NUMBER_idx, STUDENT.STUDENT_SEMESTER_idx, > STUDENT.STUDENT_STUDENT_NAME_idx, STUDENT.STUDENT_UNIQUE_ID_idx] > Column Metadata: > Column Name: PERCENTAGE > Validation Class: org.apache.cassandra.db.marshal.FloatType > Index Name: STUDENT_PERCENTAGE_idx > Index Type: KEYS > Column Name: AGE > Validation Class: org.apache.cassandra.db.marshal.IntegerType > Index Name: STUDENT_AGE_idx > Index Type: KEYS > Column Name: SEMESTER > Validation Class: org.apache.cassandra.db.marshal.UTF8Type > Index Name: STUDENT_SEMESTER_idx > Index Type: KEYS > Column Name: ROLL_NUMBER > Validation Class: org.apache.cassandra.db.marshal.LongType > Index Name: STUDENT_ROLL_NUMBER_idx > Index Type: KEYS > Column Name: UNIQUE_ID > Validation Class: org.apache.cassandra.db.marshal.LongType > Index Name: STUDENT_UNIQUE_ID_idx > Index Type: KEYS > Column Name: STUDENT_NAME > Validation Class: org.apache.cassandra.db.marshal.UTF8Type > Index Name: STUDENT_STUDENT_NAME_idx > Index Type: KEYS > Column Name: BIG_DECIMAL > Validation Class: org.apache.cassandra.db.marshal.DecimalType > Index Name: STUDENT_BIG_DECIMAL_idx > Index Type: KEYS > Compaction Strategy: > org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy > Compression Options: > sstable_compression: org.apache.cassandra.io.compress.SnappyCompressor > > > for value of BIG_DECIMAL is 2.28542855225E-825373481 > > > > Thanks > Kuldeep > > On Tue, Jan 29, 2013 at 1:52 PM, Rishabh Agrawal > <rishabh.agra...@impetus.co.in> wrote: > Can you provide specs of the column family using describe. > > From: Kuldeep Mishra [mailto:kuld.cs.mis...@gmail.com] > Sent: Tuesday, January 29, 2013 12:37 PM > To: user@cassandra.apache.org > Subject: getting error for decimal type data > > while I an trying to list column family data using cassandra-cli then I am > getting following problem for decimal type data, > any suggestion will be appreciated. > > Exception in thread "main" java.lang.OutOfMemoryError: Java heap space > at java.lang.AbstractStringBuilder.<init>(AbstractStringBuilder.java:45) > at java.lang.StringBuilder.<init>(StringBuilder.java:80) > at java.math.BigDecimal.getValueString(BigDecimal.java:2885) > at java.math.BigDecimal.toPlainString(BigDecimal.java:2869) > at > org.apache.cassandra.cql.jdbc.JdbcDecimal.getString(JdbcDecimal.java:72) > at > org.apache.cassandra.db.marshal.DecimalType.getString(DecimalType.java:62) > at org.apache.cassandra.cli.CliClient.printSliceList(CliClient.java:2873) > at org.apache.cassandra.cli.CliClient.executeList(CliClient.java:1486) > at > org.apache.cassandra.cli.CliClient.executeCLIStatement(CliClient.java:272) > at > org.apache.cassandra.cli.CliMain.processStatementInteractive(CliMain.java:210) > at org.apache.cassandra.cli.CliMain.main(CliMain.java:337) > > > -- > Thanks and Regards > Kuldeep Kumar Mishra > +919540965199 > > > > > > > > NOTE: This message may contain information that is confidential, proprietary, > privileged or otherwise protected by law. The message is intended solely for > the named addressee. If received in error, please destroy and notify the > sender. Any use of this email is prohibited when received in error. Impetus > does not represent, warrant and/or guarantee, that the integrity of this > communication has been maintained nor that the communication is free of > errors, virus, interception or interference. > > > > -- > Thanks and Regards > Kuldeep Kumar Mishra > +919540965199 > > > > > > > > NOTE: This message may contain information that is confidential, proprietary, > privileged or otherwise protected by law. The message is intended solely for > the named addressee. If received in error, please destroy and notify the > sender. Any use of this email is prohibited when received in error. Impetus > does not represent, warrant and/or guarantee, that the integrity of this > communication has been maintained nor that the communication is free of > errors, virus, interception or interference.
