Inconsistent Results on Table Join when Index and TIMESTAMP type involved

Hi All, I have a use case where I need to join a table with an index on itself in order to find the latest entry. In doing so, I've come a case in Phoenix (4.14.1) where I appear to get incorrect results if I do a join with TIMESTAMPs where indexes are involved. I have a suspicion that this is

Re: Inner Join Cursor Query fails with NullPointerException - JoinCompiler.java:187

On Sat, Dec 29, 2018 at 7:42 AM Jack Steenkamp > wrote: > >> Hi All, >> >> Using Phoenix 4.14.1, I have come across an inner join query in my >> application that fails with the NullPointerException if executed as part of >> a Cursor, but executes fine if done wit

Inner Join Cursor Query fails with NullPointerException - JoinCompiler.java:187

Hi All, Using Phoenix 4.14.1, I have come across an inner join query in my application that fails with the NullPointerException if executed as part of a Cursor, but executes fine if done without it. To reproduce this issue, you can run the attached program (assuming you update the JDBC_URL to

Re: Cursor Query Loops Eternally with Local Index, Returns Fine Without It

Hi Tomas, Sure - I've created https://issues.apache.org/jira/browse/PHOENIX-5072 with all the details. Thanks, On Tue, 18 Dec 2018 at 01:50, Thomas D'Silva wrote: > Jack, > > Can you please file a JIRA that includes you repro steps? > > On Fri, Dec 14, 2018 at 2:33 AM Jack Ste

Cursor Query Loops Eternally with Local Index, Returns Fine Without It

Hi All, I have come across a curious case with Phoenix (4.14.1) cursors where a particular query would carry on looping forever if executed when a local index is present. If however, I execute the same query without a local index on the table, then it works as expected. Please find attached a

Re: CursorUtil -> mapCursorIDQuery

Hi Josh, I've created https://issues.apache.org/jira/browse/PHOENIX-4860 for this. Thanks, On Tue, 21 Aug 2018 at 16:34, Jack Steenkamp wrote: > > Hi Josh, > > Glad I could help. The CursorUtil class it seems has not changed since > it was first created as part of PHOENIX-3572

Re: CursorUtil -> mapCursorIDQuery

er)? > * Want to create a Jira issue to track this? Else, I can do this for ya. > > On 8/21/18 9:48 AM, Jack Steenkamp wrote: > > Hi All, > > > > In my application I make heavy use of Apache Phoenix's Cursors > > (https://phoenix.apache.org/cursors.html) - and for t

CursorUtil -> mapCursorIDQuery

hopefully tighten up the class and prevent any potential inconsistencies. Regards, Jack Steenkamp