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

    • Type: Improvement
    • Status: Open
    • Priority: Normal
    • Resolution: Unresolved
    • Fix Version/s: 4.x
    • Component/s: CQL/Syntax
    • Labels:
    • Change Category:
      Operability
    • Complexity:
      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

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

              Dates

              • Created:
                Updated: