[jira] [Updated] (SPARK-27578) Add support for "interval '23:59:59' hour to second"

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:
--
Issue Type: Improvement  (was: Bug)

> Add support for "interval '23:59:59' hour to second"
> 
>
> 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 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) Add support for "interval '23:59:59' hour to second"

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:
--
Description: 
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}
 

 

  was:
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 Teradata can support it well now.
{code:java}
select interval '23:59:59.155' hour to second
{code}
 

 


> Add support for "interval '23:59:59' hour to second"
> 
>
> 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