[jira] [Resolved] (SPARK-30026) Support all whitespaces as delimiter for inside a interval value

["Wenchen Fan (Jira)" <ji...@apache.org>]

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

Wenchen Fan resolved SPARK-30026.
---------------------------------
    Fix Version/s: 3.0.0
       Resolution: Fixed

Issue resolved by pull request 26662
[https://github.com/apache/spark/pull/26662]

> Support all whitespaces as delimiter for inside a interval value
> ----------------------------------------------------------------
>
>                 Key: SPARK-30026
>                 URL: https://issues.apache.org/jira/browse/SPARK-30026
>             Project: Spark
>          Issue Type: Sub-task
>          Components: SQL
>    Affects Versions: 3.0.0
>            Reporter: Kent Yao
>            Assignee: Kent Yao
>            Priority: Major
>             Fix For: 3.0.0
>
>
>  
> {code:sql}
>  
> postgres=# select interval E'1 \t day';
>  interval
> ----------
>  1 day
> (1 row)
> postgres=# select interval E'1\t' day;
>  interval
> ----------
>  1 day
> (1 row)
> postgres=# select interval '1 ' day;
>  interval
> ----------
>  1 day
> (1 row)
> {code}
>  
> We are now able to handle whitespaces for integral and fractional types, and the leading or trailing whitespaces for interval, date, and timestamps. But the current interval parser is not able to identify whitespaces as separates as PostgreSQL can do 



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

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