[jira] [Created] (FLINK-21781) Lookup Table based on rowkey ranges

["Felipe Lolas (Jira)" <ji...@apache.org>]

Felipe Lolas created FLINK-21781:
------------------------------------

             Summary: Lookup Table based on rowkey ranges
                 Key: FLINK-21781
                 URL: https://issues.apache.org/jira/browse/FLINK-21781
             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)