Maxim Gekk created SPARK-30826: ---------------------------------- Summary: 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
# 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