Help Center> MapReduce Service> Developer Guide (3.x)> HBase Development Guide (Security Mode)> Developing an Application> Example Code Description> Writing Data to the PhoenixTable
View PDF

Writing Data to the PhoenixTable

Function

The Phoenix table enables data writing in HBase.

Example Code

The following code snippet belongs to the testPutmethod in the PhoenixSample class of the com.huawei.bigdata.hbase.examplespackage.

  /**
   * Put data
   */
  public void testPut() {
    LOG.info("Entering testPut.");
    String URL = "jdbc:phoenix:" + conf.get("hbase.zookeeper.quorum");
    // Insert
    String upsertSQL =
        "UPSERT INTO TEST VALUES(1,'John','100000', TO_DATE('1980-01-01','yyyy-MM-dd'))";
    try (Connection conn = DriverManager.getConnection(url, props);
        Statement stat = conn.createStatement()){
      // Execute Update SQL
      stat.executeUpdate(upsertSQL);
      conn.commit();
      LOG.info("Put successfully.");
    } catch (Exception e) {
      LOG.error("Put failed.", e);
    }
    LOG.info("Exiting testPut.");
  }
Parent topic: Example Code Description