Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Is it possible to join phoenix and hive tables in a sql ?

Is it possible to join phoenix and hive tables in a sql ?

New Contributor

Is it possible to join phoenix and hive tables in a sql ?

We are planning our ODS layer on phoenix because of CRUD operations and DataWerahous layer on Hive (There are only Insert operations) .

For example ; TableHive in Hive. TablePhoenix in Phoenix.

Select * from TableHive H ,TablePhoenix P where H.id=P.id;

( is it prossible ? ).

Thanks in advance,

2 REPLIES 2

Re: Is it possible to join phoenix and hive tables in a sql ?

Yes, see the Phoenix Storage Handler for Hive: https://phoenix.apache.org/hive_storage_handler.html

This provides access to Phoenix tables via Hive. This implementation is relatively new (so, possible for some issues to still shake-out), but this will be the best solution that you can use today (>=HDP-2.5)

Re: Is it possible to join phoenix and hive tables in a sql ?

New Contributor

Hi Josh,

one more question ..

Is it possible to join phoenix and hive tables by using spark sql ?

Don't have an account?
Coming from Hortonworks? Activate your account here