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
