[jira] [Updated] (SPARK-27578) Support INTERVAL ... HOUR TO SECOND syntax

2019-06-04 Thread Yuming Wang (JIRA) 


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

Yuming Wang updated SPARK-27578:

Issue Type: Sub-task  (was: Improvement)
Parent: SPARK-27764

> Support INTERVAL ... HOUR TO SECOND syntax
> --
>
> Key: SPARK-27578
> URL: https://issues.apache.org/jira/browse/SPARK-27578
> Project: Spark
>  Issue Type: Sub-task
>  Components: SQL
>Affects Versions: 3.0.0
>Reporter: Zhu, Lipeng
>Priority: Major
>
> Currently, SparkSQL can support interval format like this. 
>  
> {code:java}
> select interval '5 23:59:59.155' day to second.{code}
>  
> Can SparkSQL support grammar like below, as Presto/Teradata can support it 
> well now.
> {code:java}
> select interval '23:59:59.155' hour to second
> {code}
>  
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

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

[jira] [Updated] (SPARK-27578) Support INTERVAL ... HOUR TO SECOND syntax

2019-05-27 Thread Dongjoon Hyun (JIRA) 


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

Dongjoon Hyun updated SPARK-27578:
--
Summary: Support INTERVAL ... HOUR TO SECOND syntax  (was: Add support for 
"interval '23:59:59' hour to second")

> Support INTERVAL ... HOUR TO SECOND syntax
> --
>
> Key: SPARK-27578
> URL: https://issues.apache.org/jira/browse/SPARK-27578
> Project: Spark
>  Issue Type: Improvement
>  Components: SQL
>Affects Versions: 3.0.0
>Reporter: Zhu, Lipeng
>Priority: Major
>
> Currently, SparkSQL can support interval format like this. 
>  
> {code:java}
> select interval '5 23:59:59.155' day to second.{code}
>  
> Can SparkSQL support grammar like below, as Presto/Teradata can support it 
> well now.
> {code:java}
> select interval '23:59:59.155' hour to second
> {code}
>  
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

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