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)