ApsaraDB for HBase：HBase SQL(Phoenix) 入門

前提條件

已經準備好Phoenix的運行環境，若未準備請參考環境準備。

快速開始

1. 執行如下語句建立一個us_population表。

   CREATE TABLE IF NOT EXISTS us_population (
      state CHAR(2) NOT NULL,
      city VARCHAR NOT NULL,
      population BIGINT
      CONSTRAINT my_pk PRIMARY KEY (state, city));

2. 執行如下語句寫入資料。

   UPSERT INTO us_population VALUES('NY','New York',8143197);
   UPSERT INTO us_population VALUES('CA','Los Angeles',3844829);
   UPSERT INTO us_population VALUES('IL','Chicago',2842518);
   UPSERT INTO us_population VALUES('TX','Houston',2016582);
   UPSERT INTO us_population VALUES('PA','Philadelphia',1463281);
   UPSERT INTO us_population VALUES('AZ','Phoenix',1461575);
   UPSERT INTO us_population VALUES('TX','San Antonio',1256509);
   UPSERT INTO us_population VALUES('CA','San Diego',1255540);
   UPSERT INTO us_population VALUES('TX','Dallas',1213825);
   UPSERT INTO us_population VALUES('CA','San Jose',912332);

3. 查詢SQL。

   SELECT state as "State",count(city) as "City Count",sum(population) as "Population Sum"
   FROM us_population
   GROUP BY state
   ORDER BY sum(population) DESC;

4. 結果驗證。

   

API訪問Phoenix JDBC

• Phoenix 5.x SDK maven依賴：

  <dependency>
    <groupId>com.aliyun.phoenix</groupId>
    <artifactId>ali-phoenix-queryserver-client</artifactId>
    <version>5.2.1-HBase-2.x</version>
  </dependency>

• Phoenix 4.x SDK maven依賴：

  <dependency>
      <groupId>com.aliyun.phoenix</groupId>
      <artifactId>ali-phoenix-core</artifactId>
      <version>${參考FAQ中最新版本說明}</version>
  </dependency>

相關參考

程式碼範例請參考：參考樣本。