[jira] [Updated] (SPARK-27793) Add day-time and year-month interval types

2021-03-02 Thread Maxim Gekk (Jira)


 [ 
https://issues.apache.org/jira/browse/SPARK-27793?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Maxim Gekk updated SPARK-27793:
---
Description: 
Extend Catalyst's type system by two new types that conform to the SQL standard 
(see SQL:2016, section 4.6.3):
# DayTimeIntervalType represents the day-time interval type,
# YearMonthIntervalType for SQL year-month interval type.

  was:
The day-time INTERVAL type contains the following fields:
# DAY - Unconstrained except by the leading field precision
# HOUR - Hours (within days) (0-23)
# MINUTE - Minutes (within hours) (0-59)
# SECOND - Seconds and possibly fractions of a second (0-59.999...)

The interval type should support all operations defined by SQL standard


> Add day-time and year-month interval types
> --
>
> Key: SPARK-27793
> URL: https://issues.apache.org/jira/browse/SPARK-27793
> Project: Spark
>  Issue Type: Sub-task
>  Components: SQL
>Affects Versions: 3.2.0
>Reporter: Maxim Gekk
>Priority: Major
>
> Extend Catalyst's type system by two new types that conform to the SQL 
> standard (see SQL:2016, section 4.6.3):
> # DayTimeIntervalType represents the day-time interval type,
> # YearMonthIntervalType for SQL year-month interval type.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

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



[jira] [Updated] (SPARK-27793) Add day-time and year-month interval types

2021-03-02 Thread Maxim Gekk (Jira)


 [ 
https://issues.apache.org/jira/browse/SPARK-27793?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Maxim Gekk updated SPARK-27793:
---
Summary: Add day-time and year-month interval types  (was: Support SQL 
day-time INTERVAL type)

> Add day-time and year-month interval types
> --
>
> Key: SPARK-27793
> URL: https://issues.apache.org/jira/browse/SPARK-27793
> Project: Spark
>  Issue Type: Sub-task
>  Components: SQL
>Affects Versions: 3.2.0
>Reporter: Maxim Gekk
>Priority: Major
>
> The day-time INTERVAL type contains the following fields:
> # DAY - Unconstrained except by the leading field precision
> # HOUR - Hours (within days) (0-23)
> # MINUTE - Minutes (within hours) (0-59)
> # SECOND - Seconds and possibly fractions of a second (0-59.999...)
> The interval type should support all operations defined by SQL standard



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

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