cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jason Walkowicz (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (CASSANDRA-11233) COPY TO Column of Type Double Precision gets Truncated to lesser precision
Date Thu, 25 Feb 2016 17:06:18 GMT

     [ https://issues.apache.org/jira/browse/CASSANDRA-11233?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jason Walkowicz resolved CASSANDRA-11233.
-----------------------------------------
    Resolution: Not A Problem

Precision Can Be set within cqlshrc:

Example:
  
[ui]
float_precision=12

> COPY TO Column of Type Double Precision gets Truncated to lesser precision  
> ----------------------------------------------------------------------------
>
>                 Key: CASSANDRA-11233
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-11233
>             Project: Cassandra
>          Issue Type: Bug
>          Components: CQL
>         Environment: [cqlsh 5.0.1 | Cassandra 2.1.11.908 | DSE 4.8.2 | CQL spec 3.2.1
| Native protocol v3]
>            Reporter: Jason Walkowicz
>              Labels: cqlsh
>
> I am copying a table between two exact table configs but different names with the CQLSH
COPY command.
> Example:
> COPY "my"."data"(number) TO 'export.csv';
> COPY "my"."datacopy"(number) FROM 'export.csv';
> The column i'm copying TO and FROM is of type double. The problem is it appears that
the copy is truncating the precision of the column.
> For example:
> Original Data:
> 5.084936038014788E8
> After Copy
> 5.0849E8



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message