[
https://issues.apache.org/jira/browse/SPARK-26821?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16759382#comment-16759382
]
Sujith edited comment on SPARK-26821 at 2/4/19 5:38 PM:
--------------------------------------------------------
cc [~dongjoon] [~vinodkc] [~srowen]
was (Author: s71955):
cc [~dongjoon] [~vinodkc]
> 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
