Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-2743

HivePhoenixHandler for big-big join with predicate push down

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 4.5.0, 4.6.0
    • Fix Version/s: 4.8.0
    • Environment:

      hive-1.2.1

      Description

      Phoenix support hash join & sort-merge join. But in case of big*big join does not process well.
      Therefore Need other method like Hive.
      I implemented hive-phoenix-handler that can access Apache Phoenix table on HBase using HiveQL.
      hive-phoenix-handler is very faster than hive-hbase-handler because of applying predicate push down.
      I am publishing source code to github for contribution and maybe will be completed by next week.
      https://github.com/mini666/hive-phoenix-handler

      please, review my proposal.

        Attachments

        1. PHOENIX-2743-0.98.patch
          327 kB
          Sergey Soldatov
        2. hivephoenixhandler.jstack
          881 kB
          Josh Elser
        3. PHOENIX-2743-1.patch
          258 kB
          Sergey Soldatov

          Issue Links

            Activity

              People

              • Assignee:
                sergey.soldatov Sergey Soldatov
                Reporter:
                mini666 JeongMin Ju
              • Votes:
                0 Vote for this issue
                Watchers:
                10 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 168h
                  168h
                  Remaining:
                  Remaining Estimate - 168h
                  168h
                  Logged:
                  Time Spent - Not Specified
                  Not Specified