Use Phoenix

Available in VPC

Apache Phoenix is an open-source massively parallel relational database engine for Hadoop with HBase as its back up storage. It enables online transaction processing (OLTP) and data analytics in Hadoop.
Phoenix queries data through SQL and provides a JDBC driver that allows users to create, drop, and alter 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

When the app creation is completed, you can view the details. When the Status is Stable under the app's details, it means the app is running normally. The following describes how to check the app details.

1. From the NAVER Cloud Platform console, click the Services > Big Data & Analytics > Data Forest menu, in that order.
2. Click the Data Forest > Apps menu on the left.
3. Select an account.
4. Click the app whose details you want to view.
5. View the app details.
   
   • Quick links
     • AppMaster: A URL to view container logs. When creating an app, all apps are submitted to the YARN queue, and YARN provides a web UI to check detailed information of each app.
     • HBase Master Status UI: HBase's Master UI
     • Sqlline: A page to run phoenix-cli, and only phoenix-cli commands are available. Log in with the user account name and password with which the app is created. Refer to here for available commands.
   • Components: The PHOENIX-5.0.0 app type consists of master, region server, thrift, thrift2, rest, and sqlline components.
     • hbasemaster: You can manage region servers and monitor them using Zookeeper.
     • regionserver: You can manage regions and process client requests.
     • thrift: API server required to exchange data with HBase
     • thrift2: API server with concurrent features added to thrift
     • rest: API server to use the rest method
     • sqlline: phoenix-cli to run SQL

<Example>

• Sqlline access screen