You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Marcus Eriksson (Jira)" <ji...@apache.org> on 2019/11/11 12:56:00 UTC

[jira] [Updated] (CASSANDRA-15054) COPY DATETIMEFORMAT is applicable for all DATE/TS columns in a given file, instead it should be able to be specified per column

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

Marcus Eriksson updated CASSANDRA-15054:
----------------------------------------
    Change Category: Operability
      Fix Version/s:     (was: 3.0.x)
                     4.x
             Status: Open  (was: Triage Needed)

> COPY DATETIMEFORMAT is applicable for all DATE/TS columns in a given file, instead it should be able to be specified per column
> -------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: CASSANDRA-15054
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-15054
>             Project: Cassandra
>          Issue Type: Improvement
>          Components: CQL/Syntax
>            Reporter: Devopam Mittra
>            Priority: Normal
>              Labels: COPY, dateformat
>             Fix For: 4.x
>
>
> Currently we have an ability to specify a custom date/timestamp format per file load/extract using COPY utility via DATETIMEFORMAT option.
> This puts a limitation that all date/ts columns in a particular csv have to conform to the same format. e.g. my file has DOB and incorporation_date for an employee. But the format for both is not same since they come from different systems. 
> So, I don't have the ability yet in C* to handle this situation (which is quite common given a disparate ecosystem of extracts). 
> We should be able to rather specifiy the format for each date/ts field separately instead for ease of ingestion especially.
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org