[jira] [Assigned] (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 reassigned SPARK-30026:
-----------------------------------

    Assignee: Kent Yao

> 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
>
>  
> {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