Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. 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

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Normal
    • Resolution: Unresolved
    • 5.x
    • CQL/Syntax
    • Operability
    • Challenging

    Description

      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.

       

      Attachments

        Activity

          People

            Unassigned Unassigned
            devopam Devopam Mittra
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: