cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Shaw (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-2883) Add Support for BigDecimal Java data type as the "DecimalType" AbstractType
Date Tue, 06 Sep 2011 21:53:10 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-2883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13098398#comment-13098398
] 

Rick Shaw commented on CASSANDRA-2883:
--------------------------------------

I store a full 32 bit integer encoding for the scale part of the data into C*, which is what
the Java class {{BigDecimal}} supports. but for a scale factor that is crazy huge. I could
easily be talked into using just a byte to support 128 or 256 scale. that is still 256 digits
after the decimal... The unscaled value is stored like {{IntegerType}}.

> Add Support for BigDecimal Java data type as the "DecimalType" AbstractType
> ---------------------------------------------------------------------------
>
>                 Key: CASSANDRA-2883
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2883
>             Project: Cassandra
>          Issue Type: Sub-task
>          Components: Core
>    Affects Versions: 0.8.1
>            Reporter: Rick Shaw
>            Assignee: Rick Shaw
>            Priority: Trivial
>              Labels: CQL, JDBC,, lhf
>             Fix For: 0.8.6
>
>         Attachments: add-decimaltype-v1.txt
>
>
> The JDBC Driver suite needs support for {{BigDecimal}} to complete it's data type support
for {{ResultSet}} and {{PreparedStatement}}. This datatype could also be used to represent
numeric (non-integer) counter values. This is a very simple addition to the collection of
data types supported by Cassandra. It is quite versatile like {{BigInteger}}. It can represent
decimal numbers of virtually any precision and scale. It is represented in Java as an arbitrary
precision integer unscaled value ( think {{IntegerType}} )and a 32-bit integer scale factor,
which could be represented as a {{IntegerType}} as well. This could share much of the logic
from the {{BigInteger}} ({{IntegerType}}) implementation. 
> CQL would need to add a datatype (decimal?). Decimal literal support is already provided
in CQL.
> This is low hanging fruit.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message