Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Is this Phoenix's bug

Highlighted

Is this Phoenix's bug

New Contributor

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

Re: Is this Phoenix's bug

New Contributor

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.