phoenix学习---1

1.删除表。下面删除phoenix映射表，删除后hbase的也将被删除。

2.如果在操作打印下面的字符，说名这个功能还没有实现

3.查看日志

 4.删除表语句

(4phoenix映射表
  ---删除phoenix映射表的数据 hbase表的数据也没有了
  0: jdbc:phoenix:192.168.*:2181> DELETE FROM ZZ05; 
  ---phoenix关联映射表删除，同时hbase表也被一起删除
  0: jdbc:phoenix:192.168.*:2181> DROP TABLE ZZ05;
  ---删除phoenix映射表的同时hbase表也被一起删除
  0: jdbc:phoenix:192.168.*:2181> DROP TABLE IF EXISTS ZZ05;

 5.jdbc 连接phoniex

1. 使用Maven构建工程时，需要添加以下依赖

<dependencies>
    <dependency>
        <groupId>com.aliyun.phoenix</groupId>
        <artifactId>ali-phoenix-core</artifactId>
        <version>${version}</version>
    </dependency>
</dependencies>

2. 创建名为test.java的文件

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.PreparedStatement;
import java.sql.Statement;

public class test {

    public static void main(String[] args) throws SQLException {
        Statement stmt = null;
        ResultSet rset = null;
        
        Connection con = DriverManager.getConnection("jdbc:phoenix:[zookeeper]");
        stmt = con.createStatement();
        
        stmt.executeUpdate("create table test (mykey integer not null primary key, mycolumn varchar)");
        stmt.executeUpdate("upsert into test values (1,'Hello')");
        stmt.executeUpdate("upsert into test values (2,'World!')");
        con.commit();
        
        PreparedStatement statement = con.prepareStatement("select * from test");
        rset = statement.executeQuery();
        while (rset.next()) {
            System.out.println(rset.getString("mycolumn"));
        }
        statement.close();
        con.close();
    }
}