[
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: [email protected]
For additional commands, e-mail: [email protected]
