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,
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)