Sujith created SPARK-26821: ------------------------------ Summary: filters not working with char datatype when querying against hive table Key: SPARK-26821 URL: https://issues.apache.org/jira/browse/SPARK-26821 Project: Spark Issue Type: Bug Components: SQL Affects Versions: 2.4.0 Reporter: Sujith
creates a table with a char type field, While inserting data to char data type column, if the data string length is less than the specified datatype length, spark2x will not process filter query properly leading to incorrect result . 0: jdbc:hive2://10.19.89.222:22550/default> create table jj(id int, name char(5)); +---------+--+ | Result | +---------+--+ +---------+--+ No rows selected (0.894 seconds) 0: jdbc:hive2://10.19.89.222:22550/default> insert into table jj values(232,'ds'); +---------+--+ | Result | +---------+--+ +---------+--+ No rows selected (1.815 seconds) 0: jdbc:hive2://10.19.89.222:22550/default> select * from jj where name='ds'; +-----+-------+--+ | id | name | +-----+-------+--+ +-----+-------+--+ -- This message was sent by Atlassian JIRA (v7.6.3#76005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org