[
https://issues.apache.org/jira/browse/HIVE-16766?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16074405#comment-16074405
]
Subash commented on HIVE-16766:
-------------------------------
Hi Li,
The version we use is 1.1.0
And we use the below query,
select count(1) as cnt from table where col1=" "
The value is not blank "", its space " ".
When we perform this via JDBC we get 0 as the value though we have data.
Thanks,
Subash.
> Hive query with space as filter does not give proper result
> -----------------------------------------------------------
>
> Key: HIVE-16766
> URL: https://issues.apache.org/jira/browse/HIVE-16766
> Project: Hive
> Issue Type: Bug
> Reporter: Subash
> Assignee: Bing Li
> Priority: Critical
>
> Hi Team,
> I have used the query as below format and it does not give proper results.
> Since there is a split by \s+ in ExecuteStatementOperation class in line 48,
> I feel something goes wrong there. Could help me with this, if i am wrong ?
> I am using Hive JDBC version 1.1.0
> The sample query is as follows,
> select count(1) as cnt from table where col1=" " and col2="D";
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
