yaooqinn commented on issue #26626: [SPARK-29986][SQL] Introduce java like string trim to UTF8String URL: https://github.com/apache/spark/pull/26626#issuecomment-557042553 > The thing we care is the SQL behavior, not java behavior. Can you check other databases and see if the `trim` function trims all chars whose ascii code <= 0x20? Not changing string functions, just for other types listed in pr desc. Besides, the former interval parser should be able to handle these control chars ```sql postgres=# select date E'2019-01-01\t'; date ------------ 2019-01-01 (1 row) postgres=# select date E'2019-01-01\t'; date ------------ 2019-01-01 (1 row) postgres=# select cast(E'1\t' as boolean); bool ------ t (1 row) postgres=# select timestamp E'2019-01-01\t'; timestamp --------------------- 2019-01-01 00:00:00 (1 row) ``` #### hive ```sql select date('2019-10-10\t'); "_c0" "2019-10-10" ```
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
