[PHOENIX-2743] HivePhoenixHandler for big-big join with predicate push down

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

Environment

hive-1.2.1

• Assignee: Sergey Soldatov
• Reporter: JeongMin Ju
• Created: 04/Mar/16 05:36
• Updated: 01/Aug/23 13:37
• Resolved: 20/Apr/16 01:44

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.

Issue Links

• breaks: PHOENIX-2857 Missing dependency in "uber" jars due to incorrect dependencyManagement.
• links to: GitHub Pull Request #165