Kent Yao created SPARK-30026:
--------------------------------

             Summary: 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


 
{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: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to