Re: JOIN returning incomplete result

Thanks Maryann I have created https://issues.apache.org/jira/browse/PHOENIX-2894 adding the create statements. I have a hunch that the reverse sorting of the timestamp in the primary key has to do with that. On Thu, May 12, 2016 at 2:12 PM, Maryann Xue wrote: > Hi

Re: JOIN returning incomplete result

Hi Pierre, Thank you very much for reporting this issue! Can you create a JIRA with all the information you've attached above along with the table DDL info? I'll take a look at it. Thanks, Maryann On Thu, May 12, 2016 at 6:18 AM, pierre lacave wrote: > Hi > > I am seeing

JOIN returning incomplete result

Hi I am seeing weird result with joins where the output seems to be incomplete I tried to summarise the problem with the queries bellow. in query 1, I do a join over a period for which I would have expected to return a dozen of rows, but only one is returned for a time T1, in query 2, I do the