Details
-
Improvement
-
Status: Closed
-
Major
-
Resolution: Duplicate
-
None
-
None
-
None
-
None
Description
Hi,
Currently in a HBase table we model the data for a fast prefix filter scan, would be nice that we can use a lookup join as:
SELECT * FROM tbl LEFT JOIN hbaseTbl ON hbaseTbl.rowkey between tbl.field1 AND tbl.field2
In HBase we can traduce that as a RANGE SCAN operator with startRow = tbl.field1 and endRow = tbl.field2
Maybe too (same as Apache phoenix behaviour)
SELECT
*
FROM
tbl
LEFT JOIN
hbaseTbl
ON
hbaseTbl.rowkey LIKE tbl.field1 || '%'
traduced as RANGE SCAN with startRow=tbl.field1 - 1 (replacing the last character with lexicographical order -1) and endRow=tbl.field1
Attachments
Issue Links
- is duplicated by
-
FLINK-21782 Lookup Table based on rowkey ranges
- Open