cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Stefania (JIRA)" <>
Subject [jira] [Resolved] (CASSANDRA-8970) Allow custom time_format on cqlsh COPY TO
Date Tue, 03 Nov 2015 01:27:28 GMT


Stefania resolved CASSANDRA-8970.
    Resolution: Fixed

Closing since we'll fix the 2.1 problems in CASSANDRA-10633.

> Allow custom time_format on cqlsh COPY TO
> -----------------------------------------
>                 Key: CASSANDRA-8970
>                 URL:
>             Project: Cassandra
>          Issue Type: Improvement
>          Components: Tools
>            Reporter: Aaron Ploetz
>            Assignee: Aaron Ploetz
>            Priority: Trivial
>              Labels: cqlsh
>             Fix For: 2.2.4, 2.1.12, 3.0.0 rc2
>         Attachments: CASSANDRA-8970.patch
>   Original Estimate: 4h
>  Remaining Estimate: 4h
> When executing a COPY TO from cqlsh, the user is currently has no control over the format
of exported timestamp columns.  If the user has indicated a {{time_format}} in their cqlshrc
file, that format will be used.  Otherwise, the system default format will be used.
> The problem comes into play when the timestamp format used on a COPY TO, is not valid
when the data is sent back into Cassandra with a COPY FROM.
> For instance, if a user has {{time_format = %Y-%m-%d %H:%M:%S%Z}} specified in their
cqlshrc, COPY TO will format timestamp columns like this:
> {{userid|posttime|postcontent}}
> {{0|2015-03-14 14:59:00CDT|rtyeryerweh}}
> {{0|2015-03-14 14:58:00CDT|sdfsdfsdgfjdsgojr}}
> {{0|2015-03-12 14:27:00CDT|sdgfjdsgojr}}
> Executing a COPY FROM on that same file will produce an "unable to coerce to formatted
date(long)" error.
> Right now, the only way to change the way timestamps are formatted is to exit cqlsh,
modify the {{time_format}} property in cqlshrc, and restart cqlsh.  The ability to specify
a COPY option of TIME_FORMAT with a Python strftime format, would allow the user to quickly
alter the timestamp format for export, without reconfiguring cqlsh.
> {{aploetz@cqlsh:stackoverflow> COPY posts1 TO '/home/aploetz/posts1.csv' WITH DELIMITER='|'
AND HEADER=true AND TIME_FORMAT='%Y-%m-%d %H:%M:%S%z;}}

This message was sent by Atlassian JIRA

View raw message