You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Neophytos Demetriou (JIRA)" <ji...@apache.org> on 2019/06/26 08:05:00 UTC
[jira] [Updated] (CASSANDRA-15184) Milliseconds are lost when importing with COPY FRΟΜ and an alternative DATETIMEFORMAT
[ https://issues.apache.org/jira/browse/CASSANDRA-15184?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Neophytos Demetriou updated CASSANDRA-15184:
--------------------------------------------
Summary: Milliseconds are lost when importing with COPY FRΟΜ and an alternative DATETIMEFORMAT (was: Milliseconds are lost when importing with COPY FRΟΜ and an alternative DATATIMEFORMAT)
> Milliseconds are lost when importing with COPY FRΟΜ and an alternative DATETIMEFORMAT
> -------------------------------------------------------------------------------------
>
> Key: CASSANDRA-15184
> URL: https://issues.apache.org/jira/browse/CASSANDRA-15184
> Project: Cassandra
> Issue Type: Bug
> Components: Legacy/Tools
> Reporter: Neophytos Demetriou
> Priority: Normal
> Attachments: temptable.csv, temptable2.csv
>
>
> With a table created as follows:
>
> {code:java}
> CREATE TABLE rc.temptable(id bigint, recorded_on timestamp, primary key(id));{code}
>
> The following does not work - milliseconds are lost - temptable2.csv is attached:
>
> {code:java}
> COPY rc.temptable(id,recorded_on) FROM 'temptable2.csv' WITH ERRFILE = 'temptable.err' AND HEADER = TRUE AND BOOLSTYLE = '1,0' AND DATETIMEFORMAT = '%Y-%m-%dT%H:%M:%S.%fZ'{code}
>
> We have tried with various files/formats and, in essence, we are forced to use the default cassandra format or milliseconds are lost. For instance, using temptable.csv (attached) and the following command (no cqlshrc and no CQLSH_DEFAULT_TIMESTAMP_FORMAT is defined) works fine:
> {code:java}
> COPY rc.temptable(id,recorded_on) FROM 'temptable.csv' WITH ERRFILE = 'temptable.err' AND HEADER = TRUE AND BOOLSTYLE = '1,0'{code}
> This is with: cqlsh 5.0.1, Cassandra 3.11.4, CQL spec 3.4.4, Native protocol v4.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org