[ https://issues.apache.org/jira/browse/SPARK-29634?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16961830#comment-16961830 ]
Zhaoyang Qin commented on SPARK-29634: -------------------------------------- Hive doc says: {panel:title=Char} Char types are similar to Varchar but they are fixed-length meaning that values shorter than the specified length value are padded with spaces but trailing spaces are not important during comparisons. The maximum length is fixed at 255. {panel} > 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.2.1, 2.3.1 > Environment: Spark 2.3.1 > Hive 3.0.0 > TPCDS Data & Tables > Reporter: Zhaoyang Qin > Priority: Major > Labels: spark-sql, spark-sql-perf > > 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-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org