[jira] [Commented] (SPARK-41549) Create a TIME data type

["Harsh Verma (Jira)" <ji...@apache.org>]

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

Harsh Verma commented on SPARK-41549:
-------------------------------------

This is something I am also wondering why Spark do not support TIME data type. It is surfacing for me while working with Apache Iceberg tables, which has Time data type and Spark cannot work with such tables.

> Create a TIME data type
> -----------------------
>
>                 Key: SPARK-41549
>                 URL: https://issues.apache.org/jira/browse/SPARK-41549
>             Project: Spark
>          Issue Type: Wish
>          Components: SQL
>    Affects Versions: 3.3.1
>            Reporter: Patrick Grandjean
>            Priority: Major
>
> As a user of Spark SQL, I wish there was a {{TIME}} data type representing a time of day.
> Spark has recently added support for a {{DATE}} data type, backed by both {{java.sql.Date}} and {{java.time.LocalDate}} Java types. The new {{TIME}} data type would be backed by {{java.time.LocalTime}}.
> Today, the only alternative is to use {{TIMESTAMP}}. However, displaying rows with TIMESTAMP still shows a date in 1970 (ex: {{1970-01-01 18:20:00}}) which is both confusing and less readable.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

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