You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Kuldeep Mishra <ku...@gmail.com> on 2013/01/29 08:07:00 UTC
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
Re: getting error for decimal type data
Posted by aaron morton <aa...@thelastpickle.com>.
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 <ri...@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.mishra@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 <ri...@impetus.co.in> wrote:
> Can you provide specs of the column family using describe.
>
> From: Kuldeep Mishra [mailto:kuld.cs.mishra@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.
RE: getting error for decimal type data
Posted by Rishabh Agrawal <ri...@impetus.co.in>.
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.mishra@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 <ri...@impetus.co.in>> wrote:
Can you provide specs of the column family using describe.
From: Kuldeep Mishra [mailto:kuld.cs.mishra@gmail.com<ma...@gmail.com>]
Sent: Tuesday, January 29, 2013 12:37 PM
To: user@cassandra.apache.org<ma...@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.
Re: getting error for decimal type data
Posted by Kuldeep Mishra <ku...@gmail.com>.
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.agrawal@impetus.co.in> wrote:
> Can you provide specs of the column family using describe.
>
>
>
> *From:* Kuldeep Mishra [mailto:kuld.cs.mishra@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
RE: getting error for decimal type data
Posted by Rishabh Agrawal <ri...@impetus.co.in>.
Can you provide specs of the column family using describe.
From: Kuldeep Mishra [mailto:kuld.cs.mishra@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.