Hive
  1. Hive
  2. HIVE-1643

support range scans and non-key columns in HBase filter pushdown

    Details

    • Type: Improvement Improvement
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: 0.9.0
    • Fix Version/s: None
    • Component/s: HBase Handler
    • Labels:

      Description

      HIVE-1226 added support for WHERE rowkey=3. We would like to support WHERE rowkey BETWEEN 10 and 20, as well as predicates on non-rowkeys (plus conjunctions etc). Non-rowkey conditions can't be used to filter out entire ranges, but they can be used to push the per-row filter processing as far down as possible.

      1. hbase_handler.patch
        13 kB
        Sandy Pratt
      2. Hive-1643.2.patch
        25 kB
        bharath v
      3. HIVE-1643.patch
        14 kB
        bharath v

        Issue Links

        There are no Sub-Tasks for this issue.

          Activity

          Ning Zhang made changes -
          Link This issue is related to HIVE-7207 [ HIVE-7207 ]
          Ashutosh Chauhan made changes -
          Status Patch Available [ 10002 ] Open [ 1 ]
          bharath v made changes -
          Attachment Hive-1643.2.patch [ 12540852 ]
          bharath v made changes -
          Attachment HIVE-1643.patch [ 12533024 ]
          bharath v made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Affects Version/s 0.9.0 [ 12317742 ]
          Affects Version/s 0.7.0 [ 12315150 ]
          Labels patch
          Assignee Vaibhav Aggarwal [ vaggarw ] bharath v [ bharathv ]
          Ashutosh Chauhan made changes -
          Link This issue incorporates HIVE-2815 [ HIVE-2815 ]
          Sandy Pratt made changes -
          Attachment hbase_handler.patch [ 12497043 ]
          John Sichi made changes -
          Assignee John Sichi [ jvs ] Vaibhav Aggarwal [ vaggarw ]
          Carl Steinbach made changes -
          Fix Version/s 0.7.0 [ 12315150 ]
          John Sichi made changes -
          Field Original Value New Value
          Link This issue relates to HIVE-1226 [ HIVE-1226 ]
          John Sichi created issue -

            People

            • Assignee:
              bharath v
              Reporter:
              John Sichi
            • Votes:
              4 Vote for this issue
              Watchers:
              19 Start watching this issue

              Dates

              • Created:
                Updated:

                Development