[ 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