Hive
  1. Hive
  2. HIVE-2861

Support eventual constant expression for filter pushdown for key ranges in hbase

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Trivial Trivial
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.9.0
    • Component/s: HBase Handler
    • Labels:
      None

      Description

      Minor upgrade from HIVE-2771, which supports simple eventual constant expression as a filter (especially 'cast').

      For example,

      select * from hbase_pushdown where key > cast(20 + 30 as string);
      

        Activity

        Hide
        Hudson added a comment -

        Integrated in Hive-trunk-hadoop2 #54 (See https://builds.apache.org/job/Hive-trunk-hadoop2/54/)
        HIVE-2861 : Support eventual constant expression for filter pushdown for key ranges in hbase (navis via Ashutosh Chauhan) (Revision 1308763)

        Result = ABORTED
        hashutosh : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1308763
        Files :

        • /hive/trunk/hbase-handler/src/test/queries/hbase_ppd_key_range.q
        • /hive/trunk/hbase-handler/src/test/results/hbase_ppd_key_range.q.out
        • /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/index/IndexPredicateAnalyzer.java
        Show
        Hudson added a comment - Integrated in Hive-trunk-hadoop2 #54 (See https://builds.apache.org/job/Hive-trunk-hadoop2/54/ ) HIVE-2861 : Support eventual constant expression for filter pushdown for key ranges in hbase (navis via Ashutosh Chauhan) (Revision 1308763) Result = ABORTED hashutosh : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1308763 Files : /hive/trunk/hbase-handler/src/test/queries/hbase_ppd_key_range.q /hive/trunk/hbase-handler/src/test/results/hbase_ppd_key_range.q.out /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/index/IndexPredicateAnalyzer.java
        Hide
        Ashutosh Chauhan added a comment -

        This issue is closed now. It was released with the fix in 0.9.0. If there is a problem, please open a new jira and link this one with that.

        Show
        Ashutosh Chauhan added a comment - This issue is closed now. It was released with the fix in 0.9.0. If there is a problem, please open a new jira and link this one with that.
        Hide
        Hudson added a comment -

        Integrated in Hive-trunk-h0.21 #1350 (See https://builds.apache.org/job/Hive-trunk-h0.21/1350/)
        HIVE-2861 : Support eventual constant expression for filter pushdown for key ranges in hbase (navis via Ashutosh Chauhan) (Revision 1308763)

        Result = FAILURE
        hashutosh : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1308763
        Files :

        • /hive/trunk/hbase-handler/src/test/queries/hbase_ppd_key_range.q
        • /hive/trunk/hbase-handler/src/test/results/hbase_ppd_key_range.q.out
        • /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/index/IndexPredicateAnalyzer.java
        Show
        Hudson added a comment - Integrated in Hive-trunk-h0.21 #1350 (See https://builds.apache.org/job/Hive-trunk-h0.21/1350/ ) HIVE-2861 : Support eventual constant expression for filter pushdown for key ranges in hbase (navis via Ashutosh Chauhan) (Revision 1308763) Result = FAILURE hashutosh : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1308763 Files : /hive/trunk/hbase-handler/src/test/queries/hbase_ppd_key_range.q /hive/trunk/hbase-handler/src/test/results/hbase_ppd_key_range.q.out /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/index/IndexPredicateAnalyzer.java
        Hide
        Ashutosh Chauhan added a comment -

        Committed to trunk. Thanks, Navis!

        Show
        Ashutosh Chauhan added a comment - Committed to trunk. Thanks, Navis!
        Hide
        Phabricator added a comment -

        ashutoshc has accepted the revision "HIVE-2861 [jira] Support eventual constant expression for filter pushdown for key ranges in hbase".

        +1 will commit if tests pass.

        REVISION DETAIL
        https://reviews.facebook.net/D2259

        BRANCH
        DPAL-950

        Show
        Phabricator added a comment - ashutoshc has accepted the revision " HIVE-2861 [jira] Support eventual constant expression for filter pushdown for key ranges in hbase". +1 will commit if tests pass. REVISION DETAIL https://reviews.facebook.net/D2259 BRANCH DPAL-950
        Hide
        Phabricator added a comment -

        navis requested code review of "HIVE-2861 [jira] Support eventual constant expression for filter pushdown for key ranges in hbase".
        Reviewers: JIRA

        DPAL-950 Support eventual constant expression for filter pushdown for key ranges in hbase

        Minor upgrade from HIVE-2771, which supports simple eventual constant expression as a filter (especially 'cast').

        For example,

        select * from hbase_pushdown where key > cast(20 + 30 as string);

        TEST PLAN
        EMPTY

        REVISION DETAIL
        https://reviews.facebook.net/D2259

        AFFECTED FILES
        hbase-handler/src/test/queries/hbase_ppd_key_range.q
        hbase-handler/src/test/results/hbase_ppd_key_range.q.out
        ql/src/java/org/apache/hadoop/hive/ql/index/IndexPredicateAnalyzer.java

        MANAGE HERALD DIFFERENTIAL RULES
        https://reviews.facebook.net/herald/view/differential/

        WHY DID I GET THIS EMAIL?
        https://reviews.facebook.net/herald/transcript/4953/

        Tip: use the X-Herald-Rules header to filter Herald messages in your client.

        Show
        Phabricator added a comment - navis requested code review of " HIVE-2861 [jira] Support eventual constant expression for filter pushdown for key ranges in hbase". Reviewers: JIRA DPAL-950 Support eventual constant expression for filter pushdown for key ranges in hbase Minor upgrade from HIVE-2771 , which supports simple eventual constant expression as a filter (especially 'cast'). For example, select * from hbase_pushdown where key > cast(20 + 30 as string); TEST PLAN EMPTY REVISION DETAIL https://reviews.facebook.net/D2259 AFFECTED FILES hbase-handler/src/test/queries/hbase_ppd_key_range.q hbase-handler/src/test/results/hbase_ppd_key_range.q.out ql/src/java/org/apache/hadoop/hive/ql/index/IndexPredicateAnalyzer.java MANAGE HERALD DIFFERENTIAL RULES https://reviews.facebook.net/herald/view/differential/ WHY DID I GET THIS EMAIL? https://reviews.facebook.net/herald/transcript/4953/ Tip: use the X-Herald-Rules header to filter Herald messages in your client.

          People

          • Assignee:
            Navis
            Reporter:
            Navis
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development