Apache Phoenix Resources Gallery

This article contains Apache Phoenix Resources like slides, sample, etc.

Slides

Transforming HBase into a SQL Database

Apache Phoenix: Transforming HBase into a SQL Database from Hadoop_Summit

Taming HBase with Apache Phoenix and SQL

Taming HBase with Apache Phoenix and SQL from HBaseCon

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.