Help & DocumentationElastic MapReduceEMR Developer GuidePhoenix on Hbase Developer GuidePhoenix Client Tutorial

Phoenix Client Tutorial

Last updated: 2019-07-26 17:47:10

PDF

The 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
                      CONSTRAINT pk PRIMARY KEY (host) );

  • Insert data

      0: jdbc:phoenix:>UPSERT INTO TEST(host,txn_count) VALUES(’192.168.1.1’,1);
  0: jdbc:phoenix:>UPSERT INTO TEST(host,txn_count) VALUES(’192.168.1.2’,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 the community documentation.