Filtering on top of hash join fails

Hi, I am attempting to join two relations where the LHS has many more rows than the RHS (LHS = >5m, RHS = 70k). The relations are joined on the PK of the LHS with a unique foreign key from the RHS, so that rows from the RHS are matched one-to-one with the LHS. I found that the Foreign Key to

Local Index Replication and Region Splits

Hi, We have set up Phoenix with this configuration: - Multiple clusters replicating to each other - Replication set up for each table (main "0" CF and local index "L#0" CF) As I understand, local index rowkeys are pre-pended by the region start value of the corresponding data rowkey to

Local Index data not replicating for older HBase versions

Hi, We are on Phoenix 4.14-cdh5.11. We are experiencing an issue where local index data is not being replicated through HBase replication. As suggested in a previous email thread (

Large differences in query execution time for similar queries

Hi, I am using Phoenix 4.14-cdh5.11, with sqlline-thin as the client. I am seeing strange patterns around SELECT query execution time: 1. Increasing the LIMIT past a certain "threshold" results in significantly slower execution time. 2. Adding just one column (BIGINT) to the SELECT results in