[jira] [Commented] (SPARK-39469) Infer date type for CSV schema inference

["Apache Spark (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/SPARK-39469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17554808#comment-17554808 ] 

Apache Spark commented on SPARK-39469:
--------------------------------------

User 'Jonathancui123' has created a pull request for this issue:
https://github.com/apache/spark/pull/36871

> Infer date type for CSV schema inference
> ----------------------------------------
>
>                 Key: SPARK-39469
>                 URL: https://issues.apache.org/jira/browse/SPARK-39469
>             Project: Spark
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 3.2.1
>            Reporter: Jonathan Cui
>            Priority: Major
>
> 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. 



--
This message was sent by Atlassian Jira
(v8.20.7#820007)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org