[
https://issues.apache.org/jira/browse/PHOENIX-5526?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17040374#comment-17040374
]
Antoine Felgueiras commented on PHOENIX-5526:
---------------------------------------------
I get the same behaviour on the same version. It seems to happened after a
manual merge. No resolution for now.
> Query returns different results when using "=" and "like" after where clause.
> -----------------------------------------------------------------------------
>
> Key: PHOENIX-5526
> URL: https://issues.apache.org/jira/browse/PHOENIX-5526
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.7.0
> Reporter: Rishi
> Priority: Major
> Labels: performance
> Attachments: likeVS=.PNG
>
>
> We have two queries as below,
> *select distinct <few coloums>*
> *from <hbase.table>*
> *where* tag = 'FRIEDEN.L2408.Apf'
> *and* measurement_dttm *between* '2019-09-20 00:00:00.000' *and* '2019-10-07
> 23:59:59.000'
> *and* sample_rate = '1m'
> *order by* measurement_dttm;
> *select* * *from <hbase.table>* *where* tag *like* '%FRIEDEN.L2408.Apf' *and*
> measurement_dttm *between* '2019-09-20 00:00:00.000' *and* '2019-10-07
> 23:59:59.000' *and* server = 'cltecrdpip1' *and* sample_rate = '1m' *order
> by* measurement_dttm;
>
> Both the queries are silimilar and the only difference is "LIKE" and "="
> after where clause. But still we are getting different records and counts.
>
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
