1棒搜、下載安裝包
http://phoenix.apache.org/#
2、配置環(huán)境變量
export PHOENIX_HOME=~/phoenix-4.9.0-HBase-0.98
export PATH=${PHOENIX_HOME}/bin:${PATH}
export CLASS_PATH=${CLASS_PATH}:${PHOENIX_HOME}/phoenix-4.9.0-HBase-0.98-client.jar
# 拷貝phoenix-*-server.jar到hbase/lib目錄
# 移除低版本的phoenix-*-server.jar【ls ${HBASE_HOME}/lib/*phoenix*】
cp ${PHOENIX_HOME}/phoenix-4.9.0-HBase-0.98-server.jar ${HBASE_HOME}/lib/
# 替換phoenix原有配置
cp ${HBASE_HOME}/conf/hbase-site.xml ${PHOENIX_HOME}/bin/
3愁铺、自定義函數(shù)創(chuàng)建
# 設(shè)置允許使用自定義函數(shù)
方式一：在phoenix*/bin/hbase-site.xml中添加下列屬性
方式二：在phoenix-*-client.jar/hbase-default.xml中添加下列屬性
<property>
<name>phoenix.functions.allowUserDefinedFunctions</name>
<value>true</value>
</property>
# 執(zhí)行創(chuàng)建函數(shù)
CREATE FUNCTION ROWKEY(varchar) returns varchar as 'com.ai.phoenix.func.RowKeyEinvoice';
# 將lib添加到/hbase/lib中
將在定義函數(shù)jar上傳至hadoop此目錄【ocetl為目錄】
hadoop fs -mkdir -p /hbase/lib
hadoop fs -put rowkey-func.jar /hbase/lib
hadoop fs -put commons-lang3-3.4.jar /hbase/lib
# 重啟hbase
# 驗證
select * from E_INVOICE201703 where id = rowkey('17321017020100102001');
