[ https://issues.apache.org/jira/browse/SPARK-37344?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17444439#comment-17444439 ]
Apache Spark commented on SPARK-37344: -------------------------------------- User 'AngersZhuuuu' has created a pull request for this issue: https://github.com/apache/spark/pull/34616 > 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.1.1, 3.1.2, 3.2.0 > Reporter: ocean > Priority: Major > Labels: incorrect > > 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