[jira] [Created] (SPARK-26821) filters not working with char datatype when querying against hive table

["Sujith (JIRA)" <ji...@apache.org>]

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