Mailing-List: contact issues-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Sat, 1 Jul 2017 06:58:00 +0000 (UTC)
From: "Bing Li (JIRA)" <jira@apache.org>
To: issues@hive.apache.org
Message-ID: <JIRA.13075060.1495770697000.151915.1498892280805@Atlassian.JIRA>
In-Reply-To: <JIRA.13075060.1495770697000@Atlassian.JIRA>
References: <JIRA.13075060.1495770697000@Atlassian.JIRA> <JIRA.13075060.1495770697271@jira-lw-us.apache.org>
Subject: [jira] [Commented] (HIVE-16766) Hive query with space as filter
 does not give proper result
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Sat, 01 Jul 2017 06:58:10 -0000


    [ https://issues.apache.org/jira/browse/HIVE-16766?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16071054#comment-16071054 ] 

Bing Li commented on HIVE-16766:
--------------------------------

Hi, Subash
Which Hive version did you use? Could you post the reproduce queries as well? 

I tried it on a Hive package built from branch-2.3, and it worked for me.

My Testing
==============
*hive> describe test;*
OK
col1                	string
col2                	string
Time taken: 0.057 seconds, Fetched: 2 row(s)
*hive> select * from test;*
OK
a1	a2
b1	b2
c1	c2
	D
Time taken: 0.22 seconds, Fetched: 4 row(s)

*hive> select count(1) as cnt from test where col1="" and col2="D";*
Query ID = root_20170630235239_b58b7dbc-14ef-4126-b56b-fdcf187acc09
Total jobs = 1
Launching Job 1 out of 1
In order to change the average load for a reducer (in bytes):
  set hive.exec.reducers.bytes.per.reducer=<number>
In order to limit the maximum number of reducers:
  set hive.exec.reducers.max=<number>
In order to set a constant number of reducers:
  set mapreduce.job.reduces=<number>
Starting Spark Job = f25577ce-2ed6-4c5c-a64a-6ff7419ab778
--------------------------------------------------------------------------------------
          STAGES   ATTEMPT        STATUS  TOTAL  COMPLETED  RUNNING  PENDING  FAILED
--------------------------------------------------------------------------------------
Stage-5 ........         0      FINISHED      1          1        0        0       0
Stage-6 ........         0      FINISHED      1          1        0        0       0
--------------------------------------------------------------------------------------
STAGES: 02/02    [==========================>>] 100%  ELAPSED TIME: 1.01 s
--------------------------------------------------------------------------------------
Status: Finished successfully in 1.01 seconds
OK
1
Time taken: 1.436 seconds, Fetched: 1 row(s)

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