Create database in Phoenix

[#1]

How can I create database in Phoenix ?

[#2 · Accepted solution]

@Dinesh Das

Remember that Apache Phoenix is a SQL Skin over HBase. The underlying database is HBase, but accessed via Phoenix is one wishes to use it for SQL. Here are a couple of good links that can help explain further:

https://phoenix.apache.org/Phoenix-in-15-minutes-or-less.html

https://hortonworks.com/hadoop-tutorial/introduction-apache-hbase-concepts-apache-phoenix-new-backup...

As always, if you find this post useful, don't forget to accept and/or upvote the answer.

[#3]

You can create a Schema(which is similar to databases) by using following grammar.

https://phoenix.apache.org/language/index.html#create_schema

Schema will be mapped to a namespace in HBase so your tables can be segregated logically as well as physically.

https://phoenix.apache.org/namspace_mapping.html