Phoenix搭建

[root@master packages]# ls
apache-hive-1.2.1-bin.tar.gz
apache-phoenix-4.15.0-HBase-1.4-bin.tar.gz
hadoop-2.7.6.tar.gz
hbase-1.4.6-bin.tar.gz
redis-6.2.6.tar.gz
zookeeper-3.4.6.tar.gz
[root@master packages]# tar -zxvf apache-phoenix-4.15.0-HBase-1.4-bin.tar.gz -C /usr/local/soft/
[root@master packages]# cd ..
[root@master soft]# ls
0??                                  packages
A??                                  redis
apache-phoenix-4.15.0-HBase-1.4-bin  redis-6.2.6
data                                 scripts
hadoop-2.7.6                         shell
hbase-1.4.6                          shell01
hive-1.2.1                           show
jars                                 test.txt
jdk1.8.0_171                         zookeeper-3.4.6
[root@master soft]# mv apache-phoenix-4.15.0-HBase-1.4-bin/ phoenix-4.15.0
[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-cluster.py
config                              pherf-standalone.py
daemon.py                           phoenix_sandbox.py
end2endTest.py                      phoenix_utils.py
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
[root@master bin]# cd ..
[root@master phoenix-4.15.0]# scp /usr/local/soft/phoenix-4.15.0/phoenix-4.15.0-HBase-1.4-server.jar master:/usr/local/soft/hbase-1.4.6/lib/
phoenix-4.15.0-HBase-1.4-serv 100%   42MB 147.4MB/s   00:00    
[root@master phoenix-4.15.0]# scp /usr/local/soft/phoenix-4.15.0/phoenix-4.15.0-HBase-1.4-server.jar node1:/usr/local/soft/hbase-1.4.6/lib/
phoenix-4.15.0-HBase-1.4-serv 100%   42MB 106.2MB/s   00:00    
[root@master phoenix-4.15.0]# scp /usr/local/soft/phoenix-4.15.0/phoenix-4.15.0-HBase-1.4-server.jar node2:/usr/local/soft/hbase-1.4.6/lib/
phoenix-4.15.0-HBase-1.4-serv 100%   42MB 106.4MB/s   00:00    

[root@master phoenix-4.15.0]# cd ~
[root@master ~]# su test
[test@master root]$ cd ~
[test@master ~]$ ls
公共  模板  视频  图片  文档  下载  音乐  桌面
[test@master ~]$ touch test.txt
[test@master ~]$ echo 1 >> test.txt
[test@master ~]$ cat test.txt

1
[test@master ~]$ scp test.txt node1:/root/ 
The authenticity of host 'node1 (192.168.49.120)' can't be established.
ECDSA key fingerprint is SHA256:yypdVNIA5twUXhXseiP8dyOhKbMaC78B1kiPR0daLec.
ECDSA key fingerprint is MD5:e8:48:11:76:85:c0:aa:23:a1:a5:bc:0b:c2:b2:81:08.
Are you sure you want to continue connecting (yes/no)? y
Please type 'yes' or 'no': yes
Warning: Permanently added 'node1,192.168.49.120' (ECDSA) to the list of known hosts.
test@node1's password: 
scp: /root//test.txt: Permission denied
[test@master ~]$ scp test.txt root@node1:/root
root@node1's password: 
test.txt                      100%    3     6.3KB/s   00:00    

[root@master phoenix-4.15.0]# vim /etc/profile
[root@master phoenix-4.15.0]# source /etc/profile
[root@master phoenix-4.15.0]# cd ~
[root@master ~]# ls -a
.
..
ac.sh
anaconda-ks.cfg
.bash_history
.bash_logout
.bash_profile
.bashrc
.cache
.config
.cshrc
.dbus
dump.rdb
.esd_auth
.hivehistory
.ICEauthority
initial-setup-ks.cfg
.local
.mozilla
mysql57-community-release-el7-10.noarch.rpm
.mysql_history
.oracle_jre_usage
.rediscli_history
.ssh
.swp
${system:java.io.tmpdir}
.tcshrc
.viminfo
.Xauthority
zookeeper.out
公共
模板
视频
图片
文档
下载
音乐
桌面

[root@master ~]# sqlline.py master,node1,node2
154/154 (100%) Done
Done
sqlline version 1.5.0
0: jdbc:phoenix:master,node1,node2> CREATE TABLE IF NOT EXISTS STUDENT (
. . . . . . . . . . . . . . . . . >  id VARCHAR NOT NULL PRIMARY KEY, 
. . . . . . . . . . . . . . . . . >  name VARCHAR,
. . . . . . . . . . . . . . . . . >  age BIGINT, 
. . . . . . . . . . . . . . . . . >  gender VARCHAR,
. . . . . . . . . . . . . . . . . >  clazz VARCHAR
. . . . . . . . . . . . . . . . . > );
No rows affected (2.296 seconds)
0: jdbc:phoenix:master,node1,node2>  !table
+------------+--------------+-------------+---------------+----+
| TABLE_CAT  | TABLE_SCHEM  | TABLE_NAME  |  TABLE_TYPE   | RE |
+------------+--------------+-------------+---------------+----+
|            | SYSTEM       | CATALOG     | SYSTEM TABLE  |    |
|            | SYSTEM       | CHILD_LINK  | SYSTEM TABLE  |    |
|            | SYSTEM       | FUNCTION    | SYSTEM TABLE  |    |
|            | SYSTEM       | LOG         | SYSTEM TABLE  |    |
|            | SYSTEM       | MUTEX       | SYSTEM TABLE  |    |
|            | SYSTEM       | SEQUENCE    | SYSTEM TABLE  |    |
|            | SYSTEM       | STATS       | SYSTEM TABLE  |    |
|            | SYSTEM       | TASK        | SYSTEM TABLE  |    |
|            |              | STUDENT     | TABLE         |    |
+------------+--------------+-------------+---------------+----+
0: jdbc:phoenix:master,node1,node2> upsert into STUDENT values('1500100004','葛德曜',24,'男','理科三班');
1 row affected (0.057 seconds)
0: jdbc:phoenix:master,node1,node2> upsert into STUDENT values('1500100005','宣谷芹',24,'男','理科六班');
1 row affected (0.013 seconds)
0: jdbc:phoenix:master,node1,node2> upsert into STUDENT values('1500100006','羿彦昌',24,'女','理科三班');
1 row affected (0.009 seconds)
0: jdbc:phoenix:master,node1,node2> select * from STUDENT ;
+-------------+-------+------+---------+--------+
|     ID      | NAME  | AGE  | GENDER  | CLAZZ  |
+-------------+-------+------+---------+--------+
| 1500100004  | 葛德曜   | 24   | 男       | 理科三班   |
| 1500100005  | 宣谷芹   | 24   | 男       | 理科六班   |
| 1500100006  | 羿彦昌   | 24   | 女       | 理科三班   |
+-------------+-------+------+---------+--------+
3 rows selected (0.03 seconds)
0: jdbc:phoenix:master,node1,node2> select * from STUDENT where age=24;
+-------------+-------+------+---------+--------+
|     ID      | NAME  | AGE  | GENDER  | CLAZZ  |
+-------------+-------+------+---------+--------+
| 1500100004  | 葛德曜   | 24   | 男       | 理科三班   |
| 1500100005  | 宣谷芹   | 24   | 男       | 理科六班   |
| 1500100006  | 羿彦昌   | 24   | 女       | 理科三班   |
+-------------+-------+------+---------+--------+
3 rows selected (0.029 seconds)
0: jdbc:phoenix:master,node1,node2> select gender ,count(*) from STUDENT group by gender;
+---------+-----------+
| GENDER  | COUNT(1)  |
+---------+-----------+
| 女       | 1         |
| 男       | 2         |
+---------+-----------+
2 rows selected (0.036 seconds)
0: jdbc:phoenix:master,node1,node2> select * from student order by gender;
+-------------+-------+------+---------+--------+
|     ID      | NAME  | AGE  | GENDER  | CLAZZ  |
+-------------+-------+------+---------+--------+
| 1500100006  | 羿彦昌   | 24   | 女       | 理科三班   |
| 1500100004  | 葛德曜   | 24   | 男       | 理科三班   |
| 1500100005  | 宣谷芹   | 24   | 男       | 理科六班   |
+-------------+-------+------+---------+--------+
3 rows selected (0.022 seconds)
0: jdbc:phoenix:master,node1,node2> delete from STUDENT where id='1500100004';
1 row affected (0.013 seconds)
0: jdbc:phoenix:master,node1,node2> drop table STUDENT;
No rows affected (3.549 seconds)
0: jdbc:phoenix:master,node1,node2> !quit
Closing: org.apache.phoenix.jdbc.PhoenixConnection