Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-39469

Infer date type for CSV schema inference

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 3.2.1
    • 3.4.0
    • SQL
    • None

    Description

      1. If a column contains only dates, it should be of “date” type in the inferred schema

      • If the date format and the timestamp format are identical (e.g. both are yyyy/mm/dd), entries will default to being interpreted as Date

      2. If a column contains dates and timestamps, it should be of “timestamp” type in the inferred schema

       

      A similar issue was opened in the past but was reverted due to the lack of strict pattern matching. 

      Attachments

        Issue Links

          Activity

            People

              jonathancui123 Jonathan Cui
              jonathancui123 Jonathan Cui
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: