This article contains Apache Phoenix Resources like slides, sample, etc.
Transforming HBase into a SQL Database
Taming HBase with Apache Phoenix and SQL
Mapping Phoenix table to an existing HBase table
You can create both a Phoenix table or view through the CREATE TABLE/CREATE VIEW DDL statement on a pre-existing HBase table. In both cases, we’ll leave the HBase metadata as-is, except for with a TABLE we turn KEEP_DELETED_CELLS on. For CREATE TABLE, we’ll create any metadata (table, column families) that doesn’t already exist. We’ll also add an empty key value for each row so that queries behave as expected (without requiring all columns to be projected during scans). More details refer to http://phoenix.apache.org/faq.html#How_I_map_Phoenix_table_to_an_existing_HBase_table.
Run FAQHBaseTableCreation will create tabele
Run FAQHBaseTablePutData put 5 rows data.
HBaseTableMappingTest including 2 methods:
Coresponding shows View mapping HBase table and Table mapping HBase Table.