Phoenix开启索引支持

 

<property>
  <name>hbase.regionserver.wal.codec</name>
  <value>org.apache.hadoop.hbase.regionserver.wal.IndexedWALEditCodec</value>
</property>
<property>
    <name>hbase.rpc.timeout</name>
    <value>60000000</value>
</property>
<property>
    <name>hbase.client.scanner.timeout.period</name>
    <value>60000000</value>
</property>
<property>
    <name>phoenix.query.timeoutMs</name>
    <value>60000000</value>
</property>

[root@master ~]# stop-hbase.sh
stopping hbase............
[root@master ~]# cd /usr/local/soft/hbase-1.4.6/
[root@master hbase-1.4.6]# cd conf/
[root@master conf]# ls
hadoop-metrics2-hbase.properties  hbase-site.xml
hbase-env.cmd                     log4j.properties
hbase-env.sh                      regionservers
hbase-policy.xml
[root@master conf]# vim hbase-site.xml
[root@master conf]# vim hbase-site.xml
[root@master conf]# scp hbase-site.xml node1:`pwd`
hbase-site.xml                100% 1701     1.6MB/s   00:00    
[root@master conf]# scp hbase-site.xml node2:`pwd`
hbase-site.xml                100% 1701   109.5KB/s   00:00    
[root@master conf]# start-hbase.sh

 <property>
    <name>hbase.rpc.timeout</name>
    <value>60000000</value>
</property>
<property>
    <name>hbase.client.scanner.timeout.period</name>
    <value>60000000</value>
</property>
<property>
    <name>phoenix.query.timeoutMs</name>
    <value>60000000</value>
</property>

[root@master conf]# cd ..
[root@master hbase-1.4.6]# cd ..
[root@master soft]# cd phoenix-4.15.0/
[root@master phoenix-4.15.0]# ls
bin
examples
LICENSE
NOTICE
phoenix-4.15.0-HBase-1.4-client.jar
phoenix-4.15.0-HBase-1.4-server.jar
phoenix-client-4.15.0-HBase-1.4-embedded.jar
phoenix-client-4.15.0-HBase-1.4.jar
phoenix-client-4.15.0-HBase-1.4-sources.jar
phoenix-core-4.15.0-HBase-1.4.jar
phoenix-core-4.15.0-HBase-1.4-sources.jar
phoenix-core-4.15.0-HBase-1.4-tests.jar
phoenix-pherf-4.15.0-HBase-1.4.jar
phoenix-pherf-4.15.0-HBase-1.4-minimal.jar
phoenix-pherf-4.15.0-HBase-1.4-sources.jar
phoenix-pherf-4.15.0-HBase-1.4-tests.jar
phoenix-server-4.15.0-HBase-1.4-sources.jar
phoenix-tracing-webapp-4.15.0-HBase-1.4.jar
phoenix-tracing-webapp-4.15.0-HBase-1.4-runnable.jar
phoenix-tracing-webapp-4.15.0-HBase-1.4-sources.jar
phoenix-tracing-webapp-4.15.0-HBase-1.4-tests.jar
python
README.md
[root@master phoenix-4.15.0]# cd bin
[root@master bin]# ls
argparse-1.4.0                      pherf-standalone.py
config                              phoenix_sandbox.py
daemon.py                           phoenix_utils.py
end2endTest.py                      phoenix_utils.pyc
hadoop-metrics2-hbase.properties    psql.py
hadoop-metrics2-phoenix.properties  queryserver.py
hbase-omid-client-config.yml        readme.txt
hbase-site.xml                      sandbox-log4j.properties
log4j.properties                    sqlline.py
omid-env.sh                         sqlline-thin.py
omid-server-configuration.yml       tephra
omid.sh                             tephra-env.sh
performance.py                      traceserver.py
pherf-cluster.py
[root@master bin]# vim hbase-site.xml 
[root@master bin]# sqlline.py master,node1,node2