[ https://issues.apache.org/jira/browse/SPARK-25098?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ice bai updated SPARK-25098: ---------------------------- Description: UDF ‘Cast’ will return NULL when input string starts/ends with special character, but hive doesn't. For examle, we get hour from a string ends with a blank : hive: ``` hive> SELECT CAST(' 2018-08-13' AS DATE);//starts with a blank OK 2018-08-13 hive> SELECT HOUR('2018-04-27 17:20:07 );//ends with a blank OK 17 ``` spark-sql: ``` spark-sql> SELECT CAST(' 2018-08-13' AS DATE);//starts with a blank NULL ``` was: UDF ‘Cast’ will return NULL when input string starts/ends with special character, but hive doesn't. For examle, we get hour from a string ends with a blank : hive: ``` hive> SELECT CAST(' 2018-08-13' AS DATE);;//starts with a blank OK 2018-08-13 select hour('2018-04-27 17:20:07 ``` spark-sql: ``` spark-sql> SELECT CAST(' 2018-08-13' AS DATE);//starts with a blank NULL ``` > ‘Cast’ will return NULL when input string starts/ends with special character > ----------------------------------------------------------------------------- > > Key: SPARK-25098 > URL: https://issues.apache.org/jira/browse/SPARK-25098 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 2.3.0 > Reporter: ice bai > Priority: Major > > UDF ‘Cast’ will return NULL when input string starts/ends with special > character, but hive doesn't. > For examle, we get hour from a string ends with a blank : > hive: > ``` > hive> SELECT CAST(' 2018-08-13' AS DATE);//starts with a blank > OK > 2018-08-13 > hive> SELECT HOUR('2018-04-27 17:20:07 );//ends with a blank > OK > 17 > ``` > spark-sql: > ``` > spark-sql> SELECT CAST(' 2018-08-13' AS DATE);//starts with a blank > NULL > ``` -- 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