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: [email protected]
For additional commands, e-mail: [email protected]
