Support Questions
Find answers, ask questions, and share your expertise

Is this Phoenix's bug

Explorer

hi,I find a problem when use phoenix'index to query ?

First I Execute sql

: 0: jdbc:phoenix:zookeeper1> select /*+ INDEX("SysActionLog" "SYSACTIONLOG_IDX")*/ "UserID","RowKey" from "SysActionLog" . . . . . . . . . . . . . > where "CreateTime" >= '20161130150108000' and "CreateTime" <= '20161130160108000' order by "CreateTime" desc limit 10; +-----------------

9930-1qa.png

sql 0: jdbc:phoenix:zookeeper1> select /*+ INDEX("SysActionLog" "SYSACTIONLOG_IDX")*/ "UserID","RowKey" from "SysActionLog" . . . . . . . . . . . . . > where "CreateTime" >= '20161130150108000' and "CreateTime" <= '20161130160108000' order by "CreateTime" desc limit 20;

9931-ws.png

so i Execute sql, 0:

jdbc:phoenix:zookeeper1> select /*+ INDEX("SysActionLog" "SYSACTIONLOG_IDX")*/ "UserID","RowKey" from "SysActionLog"

. . . . . . . . . . . . . > where "RowKey" < '20161130150108010#Open#WebApi#POST##' and "CreateTime" >= '20161130150108000' and "CreateTime" <= '20161130160108000' order by "CreateTime" desc limit 10;

9932-w3333.png

Problem is last sql should be have result.but can't find result .

In sql I remove createtime filter only use RowKey can query result

why? is this phoenix bug in phoenix 4.2

9929-erer.png

1 REPLY 1

Explorer

Can you reproduce this behavior without using index hints?

There has been many index stability fixes in the past few versions. I suggest you try this again on Phoenix 4.7+ (HDP2.5) to see if it still repros.