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 same join but filtering for one of the missing row at time T2 which is now returned ?!
I re-ran query 1 to make sure it was not a timing issue, but had the same wrong partial result.
The two tables are using a salt of 2.
Using Phoenix 4.7, Hbase 1.1
For reference the content of each table and the plan of each query bellow
Query #1 plan
Query #2 plan
possibly relevant hbase settings
here the DDLs (replaced the irrelevant name of column by letters)