Uploaded image for project: 'Flink'
  1. Flink
  2. FLINK-21782

Lookup Table based on rowkey ranges

    XMLWordPrintableJSON

    Details

      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 or simply a RowPrefixFilter (does the same)

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                flolas Felipe Lolas
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated: