1 of 5

HBase/Drill Join Types

2 of 5

A: HBase fact with small dimension (bloomjoin)

Scan

HBaseBloomScan

Bloom Builder

Broadcast Exchange

Sideband Sink

HashJoin

Tee

Scan

HBaseScan

Broadcast Exchange

HashJoin

Original

Alt

3 of 5

B: Highly selective filter (non row-key), non-covering index

ElasticScan

HBaseScan

Filter

HBase Probe Scan

Original

Alt

4 of 5

C: Somewhat selective filter (non row-key), non-covering

ElasticScan

HBaseScan

Filter

HBase Skip Scan

Sort(rowkey)

OrderedExchange (region targeted)

ElasticScan

HBaseScan

HashJoin

Sideband

Used Regions

Original

Alt 1

Alt 2

5 of 5

D: Filter with covering index

ElasticScan

HBaseScan

Filter

Original

Alt