Sumit Nigam created PHOENIX-3354:
------------------------------------
Summary: SORT_MERGE join on single tenant, salted table misses
records randomly.
Key: PHOENIX-3354
URL: https://issues.apache.org/jira/browse/PHOENIX-3354
Project: Phoenix
Issue Type: Bug
Affects Versions: 4.6.0, 4.5.0
Environment: Hbase 1.1.2
Reporter: Sumit Nigam
Priority: Critical
Single-tenant, salted table on Hbase 1.1.2 has ~3 million records. It has a
secondary index as well. The SORT_MERGE join hint misses data randomly when
used in queries.
I will add the DDLs and explain plan for all the queries that access this table.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)