You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@flink.apache.org by "Felipe Lolas (Jira)" <ji...@apache.org> on 2021/03/14 17:46:00 UTC
[jira] [Created] (FLINK-21782) Lookup Table based on rowkey ranges
Felipe Lolas created FLINK-21782:
------------------------------------
Summary: Lookup Table based on rowkey ranges
Key: FLINK-21782
URL: https://issues.apache.org/jira/browse/FLINK-21782
Project: Flink
Issue Type: Improvement
Reporter: Felipe Lolas
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:
{code:java}
SELECT
*
FROM
tbl
LEFT JOIN
hbaseTbl
ON
hbaseTbl.rowkey between tbl.field1 AND tbl.field2{code}
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)
{code:java}
SELECT
*
FROM
tbl
LEFT JOIN
hbaseTbl
ON
hbaseTbl.rowkey LIKE tbl.field1 || '%'{code}
traduced as RANGE SCAN with startRow=tbl.field1 - 1 (replacing the last character with lexicographical order -1) and endRow=tbl.field1
--
This message was sent by Atlassian Jira
(v8.3.4#803005)