[ 
https://issues.apache.org/jira/browse/SPARK-26821?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Sujith updated SPARK-26821:
---------------------------
    Description: 
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|

+------+------++--
 +------+------++--

 

The above query will not give any result.

  was:
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  |
+-----+-------+--+
+-----+-------+--+


> 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
>            Priority: Major
>
> 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|
> +------+------++--
>  +------+------++--
>  
> The above query will not give any result.



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

Reply via email to