Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Create database in Phoenix

Solved Go to solution

Create database in Phoenix

Rising Star

How can I create database in Phoenix ?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Create database in Phoenix

Guru

@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.

2 REPLIES 2

Re: Create database in Phoenix

Guru

@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.

Highlighted

Re: Create database in Phoenix

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

Don't have an account?
Coming from Hortonworks? Activate your account here