Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-11233

COPY TO Column of Type Double Precision gets Truncated to lesser precision

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Normal
    • Resolution: Not A Problem
    • Fix Version/s: None
    • Component/s: Legacy/CQL
    • Labels:
    • Environment:

      [cqlsh 5.0.1 | Cassandra 2.1.11.908 | DSE 4.8.2 | CQL spec 3.2.1 | Native protocol v3]

    • Severity:
      Normal

      Description

      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

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              walkowicz@gmail.com Jason Walkowicz
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: