phoenix 根据条件更新_用 Phoenix 通过 SQL 语句更新操作 HBase 数据

Apache Phoenix 官方站点：https://phoenix.apache.org/

Phoenix支持的sql语句： https://phoenix.apache.org/language/index.html

Phoenix 支持的DataTypes：https://phoenix.apache.org/language/datatypes.html

Phoenix 支持的函数：https://phoenix.apache.org/language/functions.html

Apache Phoenix 官方站点：https://phoenix.apache.org/

Phoenix支持的sql语句： https://phoenix.apache.org/language/index.html

Phoenix 支持的DataTypes：https://phoenix.apache.org/language/datatypes.html

Phoenix 支持的函数：https://phoenix.apache.org/language/functions.html

一、安装使用

Phoenix 安装很简单，下载对应hbase版本的Phoenix，以phoenix-4.4.0-HBase-0.98-bin.tar.gz为例，解压文件，将phoenix-4.4.0-server.jar 拷贝到hbase安装目录的lib下，注意：每台regionserver均需要拷贝，重启hbase server即可，官方如下：

download and expand the latest phoenix-[version]-bin.tar.

Add the phoenix-[version]-server.jar to the classpath of all HBase region server and master and remove any previous version. An easy way to do this is to copy it into the HBase lib directory (use phoenix-core-[version].jar for Phoenix 3.x)

restart the region servers

Add the phoenix-[version]-client.jar to the classpath of any Phoenix client.

download and setup SQuirrel as your SQL client so you can issue adhoc SQL against your HBase cluster

download and expand the latest phoenix-[version]-bin.tar.

Add the phoenix-[version]-server.jar to the classpath of all HBase region server and master and remove any previous version. An easy way to do this is to copy it into the HBase lib directory (use phoenix-core-[version].jar for Phoenix 3.x)

restart the region servers

Add the phoenix-[version]-client.jar to the classpath of any Phoenix client.

download and setup SQuirrel as your SQL client so you can issue adhoc SQL against your HBase cluster

通过案例，create 表，插入语句，更新语句，删除语句案例，详细可参考：https://phoenix.apache.org/faq.html

Phoenix 连接hbase的命令如下，sqlline.py [zookeeper]：

从上面能够看到，已经连接到了hbase集群上面，Phoe