Using Phoenix

Available in VPC

Apache Phoenix is an open-source, massively parallel relational database engine for Hadoop that uses HBase as its underlying storage. It enables online transaction processing (OLTP) and data analysis in Hadoop.
Phoenix queries data through SQL and provides a JDBC driver that allows you to create, delete, and change tables, views, indexes, and sequences using SQL. It processes data faster by compiling queries and other statements into native NoSQL storage APIs instead of using MapReduce.

Check Phoenix app details

Once the app is created, you can view its details. If the Status in the app details is Stable, the app is running normally.
To view app details:

1. In the VPC environment on the NAVER Cloud Platform console, navigate to > Services > Big Data & Analytics > Data Forest.
2. Click Data Forest > Apps on the left.
3. Select an account.
4. Click the app to view its details.
5. Review the app details.
   
   • Quick links
     • HBase Master Status UI: HBase Master UI.
     • Sqlline: Page for running phoenix-cli. Only phoenix-cli commands are supported. Log in using the account name and password used to create the app. For more information on supported commands, see here.
   • Component: PHOENIX-5.0.0 app type consists of master, region server, thrift, thrift2, rest, and sqlline components.
     • hbasemaster: Manages region servers and monitors them using Zookeeper.
     • regionserver: Handles region management and client requests.
     • thrift: API server for exchanging data with HBase.
     • thrift2: API server with added concurrency support.
     • rest: REST-based API server.
     • sqlline: Phoenix-cli to execute SQL.

Example:

• Sqlline access interface