Dear Experts

Thanks for your time and attention.

I am try to use Phoenix on top of HBase, which HBase contain some exist tables, I am confused about how map HBase table to a Phoenix one.

 * is there any examples or documents for this?

I have done some test, as [1] figure, I use the following DDL to create mapping table:

CREATE TABLE IF NOT EXISTS \"Customer\" (ROW_ID VARCHAR PRIMARY KEY, \"sales\".\"amount\" VARCHAR, \"sales\".\"product\" VARCHAR, \"customer\".\"city\" VARCHAR, \"customer\".\"name\" VARCHAR)

This can map fine, but the mapped column only are qualifier like

ROW_ID/VARCHAR  amount/VARCHAR  product/VARCHAR  city/VARCHAR name/VARCHAR

So my another question:

* Is there a way to customize column name during mapping? also any documents or example?

Thanks very much.

Kylin

[1] http://ksoong.org/hbase-datamodel/


--
JBoss By Redhat
Mobile: +86 18611907049
ksoong.org

Reply via email to