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.
please, review my proposal.