[jira] [Created] (SPARK-30826) LIKE returns wrong result from external table using parquet

["Maxim Gekk (Jira)" <ji...@apache.org>]

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-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org