[
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
