Apache Phoenix Resources Gallery
This article contains Apache Phoenix Resources like slides, sample, etc.
Slides
Transforming HBase into a SQL Database
Taming HBase with Apache Phoenix and SQL
Mapping Phoenix table to an existing HBase table
From Phoenix F.A.Q. Question: How I map 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.
F.A.Q. example
Run FAQHBaseTableCreation will create tabele t1.
Run FAQHBaseTablePutData put 5 rows data.
HBaseTableMappingTest including 2 methods:
- testViewMapping()
- testTableMapping()
Coresponding shows View mapping HBase table and Table mapping HBase Table.