[ https://issues.apache.org/jira/browse/SPARK-30826?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Wenchen Fan resolved SPARK-30826. --------------------------------- Fix Version/s: 3.0.0 2.4.6 Resolution: Fixed Issue resolved by pull request 27574 [https://github.com/apache/spark/pull/27574] > LIKE returns wrong result from external table using parquet > ----------------------------------------------------------- > > Key: SPARK-30826 > URL: https://issues.apache.org/jira/browse/SPARK-30826 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 2.4.5, 3.0.0 > Reporter: Maxim Gekk > Assignee: Maxim Gekk > Priority: Major > Fix For: 2.4.6, 3.0.0 > > > # Write a parquet file with a column in upper case: > {code:scala} > Seq("42").toDF("COL").write.parquet(path) > {code} > # Create an external table on top of the written parquet files with a column > in lower case > {code:sql} > CREATE TABLE t1 (col STRING) > USING parquet > OPTIONS (path '$path') > {code} > # Read the table using LIKE > {code:sql} > SELECT * FROM t1 WHERE col LIKE '4%' > {code} > It returns empty set but must be one row with 42. -- 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