The Vertica Database Forums

Posted: **Tue Nov 24, 2015 11:13 am**

Hi ,

We have a scenario where we need to store long decimal values in Vertica tables (more than 13 decimals) eg: 10.123456789123456789.

What exactly the data type we need to use in Vertica to store this value.

We have tried with Decimal and we can store the value, but while retrieving we will be able to see only 13 characters length.

Another alternative is to store the value in VARCHAR format.....!!! But wanted to check is there any other way in Vertica.

Thank You!!

Posted: **Mon Dec 28, 2015 4:19 am**

Hi,

The numeric and decimal types (they are the same) should work.

Example:

Code: Select all

dbadmin=> create table test (c1 numeric(20, 18), c2 decimal(20, 18));
CREATE TABLE
dbadmin=> \d test;
                                     List of Fields by Tables
 Schema | Table | Column |      Type      | Size | Default | Not Null | Primary Key | Foreign Key
--------+-------+--------+----------------+------+---------+----------+-------------+-------------
 public | test  | c1     | numeric(20,18) |   16 |         | f        | f           |
 public | test  | c2     | numeric(20,18) |   16 |         | f        | f           |
(2 rows)

dbadmin=> insert into test values(10.123456789123456789, 10.123456789123456789);
 OUTPUT
--------
      1
(1 row)

dbadmin=> select * from test;
          c1           |          c2
-----------------------+-----------------------
 10.123456789123456789 | 10.123456789123456789
(1 row)

Note: NUMERICS that have a precision of 18 or less have similar performance characteristics as INTEGER, regardless of the scale. When possible Vertica recommends using a precision <= 18.

Take a look here for more info.:
http://my.vertica.com/docs/7.2.x/HTML/i ... UMERIC.htm

The Vertica Database Forums

How to store Decimal value with more than 13 digits

How to store Decimal value with more than 13 digits

Re: How to store Decimal value with more than 13 digits