question Re: Create database in Phoenix in Archives of Support Questions (Read Only)

Create database in Phoenix

das_dineshk — Wed, 03 May 2017 22:53:47 GMT

How can I create database in Phoenix ?

Re: Create database in Phoenix

ssahi — Wed, 03 May 2017 23:08:04 GMT

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-restore-utility-hbase/

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

Re: Create database in Phoenix

asinghal — Wed, 02 Aug 2017 12:24:44 GMT

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