[jira] [Created] (SPARK-29634) spark-sql can't query hive table values that with schema Char by equality.

["Zhaoyang Qin (Jira)" <ji...@apache.org>]

Zhaoyang Qin created SPARK-29634:
------------------------------------

             Summary: spark-sql can't query hive table values that with schema Char by equality.
                 Key: SPARK-29634
                 URL: https://issues.apache.org/jira/browse/SPARK-29634
             Project: Spark
          Issue Type: Bug
          Components: Spark Shell, SQL
    Affects Versions: 2.3.1, 2.2.1
         Environment: Spark 2.3.1

Hive 3.0.0

TPCDS Data & Tables
            Reporter: Zhaoyang Qin


spark-sql can't query hive table values that with schema Char by equality.

When i use spark-sql CLI  to execute a query with hive tables,The expected results can not be obtained. The query result is empty. Some equality conditions did not work as expected.I checked and found that the table fields had one thing in common: they were created as char，sometimes as varchar.Then I execute the following statement and return an empty result: select * from foo where bar = 'something'.In fact, the data does exist. Using hive sql returns the correct results.



--
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