[ https://issues.apache.org/jira/browse/SPARK-31210?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17063743#comment-17063743 ]
jiaan.geng edited comment on SPARK-31210 at 3/21/20, 10:10 AM: --------------------------------------------------------------- {code:java} spark-sql> create table test_table_like2 (subject string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ','; Time taken: 1.455 seconds spark-sql> insert into test_table_like2 values ('100 times'), ('1000 times'), ('100%'); Moved to trash: /home/xitong/hive/stagingdir_hive_2020-03-21_11-28-44_313_1325551588233295250-1/-ext-10000/_temporary Moved to trash: /home/xitong/hive/stagingdir_hive_2020-03-21_11-28-44_313_1325551588233295250-1 Time taken: 6.55 seconds spark-sql> select * from test_table_like2 where subject like '100^%' escape '^'; 100% {code} was (Author: beliefer): {code:java} spark-sql> create table test_table_like2 (subject string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ','; Time taken: 1.455 seconds spark-sql> insert into test_table_like2 values ('100 times'), ('1000 times'), ('100%'); Moved to trash: /home/xitong/hive/stagingdir_hive_2020-03-21_11-28-44_313_1325551588233295250-1/-ext-10000/_temporary Moved to trash: /home/xitong/hive/stagingdir_hive_2020-03-21_11-28-44_313_1325551588233295250-1 Time taken: 6.55 seconds spark-sql> select * from test_table_like2 where subject like '100^%' escape '^'; 20/03/21 11:30:45 ERROR LzoCodec: Failed to load/initialize native-lzo library 100% {code} > An issue for Spark SQL LIKE-with-ESCAPE clause > ---------------------------------------------- > > Key: SPARK-31210 > URL: https://issues.apache.org/jira/browse/SPARK-31210 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 3.0.0 > Reporter: Mingli Rui > Priority: Major > > I try to use LIKE with ESCAPE for Spark 3.0.0-preview2. But I find in it > doesn't work in below cases. > The database table > ============== > create or replace table test_table_like ( subject string) > insert into $test_table_like values ('100 times'), ('1000 times'), ('100%') > > Repro > ==== > val result2 = sparkSession.sql( > s"select * from test_table_like where subject like '100^%' escape '^' order > by 1") > "100%" is expected to returned, but it doesn't. I debug into the code to > check the logical plan. > In the logical plan, the LIKE is transformed as "StartsWith(subject#130, > 100^)". It looks it is incorrect. > > -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org