You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Rishi (Jira)" <ji...@apache.org> on 2019/10/14 15:22:00 UTC
[jira] [Created] (PHOENIX-5526) Query returns different results
when using "=" and "like" after where clause.
Rishi created PHOENIX-5526:
------------------------------
Summary: 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
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)