ocean created SPARK-37344: ----------------------------- Summary: split function behave differently between spark 2.3 and spark 3.2 Key: SPARK-37344 URL: https://issues.apache.org/jira/browse/SPARK-37344 Project: Spark Issue Type: Bug Components: SQL Affects Versions: 3.2.0, 3.1.2, 3.1.1 Reporter: ocean
while use split function in sql, it behave differently between 2.3 and 3.2, which cause incorrect problem. we can use this sql to reproduce this problem: create table split_test ( id int,name string) insert into split_test values(1,"abc;def") explain extended select split(name,'\\\\;') from split_test spark3: spark-sql> Explain extended select split(name,'\\\\;') from split_test; == Parsed Logical Plan == 'Project [unresolvedalias('split('name, \\;), None)] +- 'UnresolvedRelation [split_test], [], false spark2: spark-sql> Explain extended select split(name,'\\\\;') from split_test; == Parsed Logical Plan == 'Project [unresolvedalias('split('name, \;), None)] +- 'UnresolvedRelation split_test It looks like the deal of escape is different -- This message was sent by Atlassian Jira (v8.20.1#820001) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org