Create Phoenix Schemas in HDP 2.5

[#1]

A often requested feature has popped up in HDP 2.5, Phoenix namespace mapping AKA Phoenix schemas. This feature allows creation of schemas and development within a schema work space. This guide will walk through steps to enable this feature and how to use it.

Use Case:

Create 2 schemea named "schema1" and "scheama2"

Within both schemas create table customer.

Create another schema named "schema3".

Drop schema "schema3"

Note - A schema can only be dropped if it is empty (does not host any tables).

1. Through Ambari go to HBase. Select Advanced tab

2. Add a parameter to hbase-site.xml. To do this go to "Custom hbase-site" and click on "Add Property"

3. Add the property

Key: phoenix.schema.isNamespaceMappingEnabled

Value: true

Click on Add button. A restart hbase service will be required.

4. Test the functionality, use sqlline.py. It is located under

/usr/hdp/current/phoenix/bin

Note - I am using /usr/hdp/2.5.0.0-1245/phoenix/bin since I want to prove to the audience I am in fact using HDP 2.5.

5. Create two schemeas named "schema1" and "schmea2"

6. Set work space to use schema1 and create table customer

7. Set work space to use schema2 and create table customer

8. Run a !table to view all schemas and tables

9. Create a schema "schema3" and drop "schema3"

That's it! Simple and easy to use. Enjoy the new feature

[#2]

Hi @Sunile Manjee, you article is great. I tried following the same steps and was successful in creating a schema and a table within it. But if i try to drop the table, i see the error that "Table not found". And if i try to create the table, i see the message "Table exists". Any thoughts on it.