tencent cloud


Phoenix Client Usage

Last updated: 2022-11-25 16:06:47

Apache Phoenix is a massively parallel relational database engine supporting OLTP for Hadoop with Apache HBase as its backing store. Phoenix compiles simple queries in just milliseconds and queries millions of rows of data in seconds. By default, the Phoenix client is integrated in HBase-enabled EMR clusters.

  1. Start the client.
    Switch to the hadoop user, go to the /usr/local/service/hbase/phoenix-client/bin directory, and use Phoenix's Python command line tool:

If the execution succeeds, the following result will be displayed:

  1. Phoenix supports SQL queries. The following are some common operations:
  • Create a table

    0: jdbc:phoenix:> CREATE TABLE IF NOT EXISTS TEST (
    host char(50) not null,
    txn_count bigint
  • Insert data

    0: jdbc:phoenix:>UPSERT INTO TEST(host,txn_count) VALUES('',1);
    0: jdbc:phoenix:>UPSERT INTO TEST(host,txn_count) VALUES('',2);
  • Query data

    0: jdbc:phoenix:>SELECT * FROM TEST;
  • Delete a data table

    0: jdbc:phoenix:>DROP TABLE IF EXISTS TEST;

For more operations and instructions, see Grammar.

Contact Us

Contact our sales team or business advisors to help your business.

Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

7x24 Phone Support