1、Phoenix是Apache项目,可实现SQL语句查询Hbase数据
2、下载并解压,并配置环境变量
3、复制Phoenix的JAR文件到Hbase的lib目录中
4、重启Hbase
5、使用Phonenix的sqlline.py连接zookeeper上的Hbase
6、查看Hadoop上的文件
增加了
SYSTEM.CATALOG、SYSTEM
.SEQUENCE、SYSTEM
.STATS这几个目录
7、Phoenix创建表
8、在Hbase中查询Phoenix中创建的表
报错信息显示未知的表,其实是Hbase对表名区分大小写,Phoenix中创建的表test,在Hbase中成了’TEST‘
2、下载并解压,并配置环境变量
3、复制Phoenix的JAR文件到Hbase的lib目录中
- grid@master1:~/phoenix/common$ cp phoenix-core-3.3.1.jar /home/grid/hbase/lib/
- grid@master1:~/phoenix/common$ scp phoenix-core-3.3.1.jar slave1:/home/grid/hbase/lib/
- phoenix-core-3.3.1.jar 100% 2380KB 2.3MB/s 00:00
- grid@master1:~/phoenix/common$ scp phoenix-core-3.3.1.jar slave2:/home/grid/hbase/lib/
- phoenix-core-3.3.1.jar 100% 2380KB 2.3MB/s 00:00
- grid@master1:~/phoenix/common$ scp phoenix-core-3.3.1.jar slave3:/home/grid/hbase/lib/
- phoenix-core-3.3.1.jar 100% 2380KB 2.3MB/s 00:00
5、使用Phonenix的sqlline.py连接zookeeper上的Hbase
- grid@master1:~$ sqlline.py master1
- Setting property: [isolation, TRANSACTION_READ_COMMITTED]
- issuing: !connect jdbc:phoenix:master1 none none org.apache.phoenix.jdbc.PhoenixDriver
- Connecting to jdbc:phoenix:master1
- Connected to: Phoenix (version 3.3)
- Driver: PhoenixEmbeddedDriver (version 3.3)
- Autocommit status: true
- Transaction isolation: TRANSACTION_READ_COMMITTED
- Building list of tables and columns for tab-completion (set fastconnect to true to skip)...
- 68/68 (100%) Done
- Done
- sqlline version 1.1.8
- 0: jdbc:phoenix:master1>
- drwxr-xr-x - grid supergroup 0 2015-09-24 11:58 /hbase/SYSTEM.CATALOG
- -rw-r--r-- 1 grid supergroup 1924 2015-09-24 11:58 /hbase/SYSTEM.CATALOG/.tableinfo.0000000002
- drwxr-xr-x - grid supergroup 0 2015-09-24 11:58 /hbase/SYSTEM.CATALOG/.tmp
- drwxr-xr-x - grid supergroup 0 2015-09-24 11:42 /hbase/SYSTEM.CATALOG/ce23398bbf72dc695a5ab2f6f1960654
- -rw-r--r-- 1 grid supergroup 249 2015-09-24 11:42 /hbase/SYSTEM.CATALOG/ce23398bbf72dc695a5ab2f6f1960654/.regioninfo
- drwxr-xr-x - grid supergroup 0 2015-09-24 11:42 /hbase/SYSTEM.CATALOG/ce23398bbf72dc695a5ab2f6f1960654/0
- drwxr-xr-x - grid supergroup 0 2015-09-24 11:58 /hbase/SYSTEM.SEQUENCE
- -rw-r--r-- 1 grid supergroup 2042 2015-09-24 11:58 /hbase/SYSTEM.SEQUENCE/.tableinfo.0000000001
- drwxr-xr-x - grid supergroup 0 2015-09-24 11:58 /hbase/SYSTEM.SEQUENCE/.tmp
- drwxr-xr-x - grid supergroup 0 2015-09-24 11:58 /hbase/SYSTEM.SEQUENCE/00803cd5c775e83a54ab8216d241c498
- -rw-r--r-- 1 grid supergroup 312 2015-09-24 11:58 /hbase/SYSTEM.SEQUENCE/00803cd5c775e83a54ab8216d241c498/.regioninfo
- drwxr-xr-x - grid supergroup 0 2015-09-24 11:58 /hbase/SYSTEM.SEQUENCE/00803cd5c775e83a54ab8216d241c498/0
- drwxr-xr-x - grid supergroup 0 2015-09-24 11:58 /hbase/SYSTEM.SEQUENCE/020a89f81ce905b72d7d22dbb5cc26bb
- -rw-r--r-- 1 grid supergroup 312 2015-09-24 11:58 /hbase/SYSTEM.SEQUENCE/020a89f81ce905b72d7d22dbb5cc26bb/.regioninfo
-
- .........................................................................................................................
- -rw-r--r-- 1 grid supergroup 312 2015-09-24 11:58 /hbase/SYSTEM.SEQUENCE/ff74f65e383d89652ca1cfd12134bfe2/.regioninfo
- drwxr-xr-x - grid supergroup 0 2015-09-24 11:58 /hbase/SYSTEM.SEQUENCE/ff74f65e383d89652ca1cfd12134bfe2/0
- drwxr-xr-x - grid supergroup 0 2015-09-24 11:58 /hbase/SYSTEM.SEQUENCE/fffe41c42ea32dc1ef97befcf90b220c
- -rw-r--r-- 1 grid supergroup 312 2015-09-24 11:58 /hbase/SYSTEM.SEQUENCE/fffe41c42ea32dc1ef97befcf90b220c/.regioninfo
- drwxr-xr-x - grid supergroup 0 2015-09-24 11:58 /hbase/SYSTEM.SEQUENCE/fffe41c42ea32dc1ef97befcf90b220c/0
- drwxr-xr-x - grid supergroup 0 2015-09-24 11:58 /hbase/SYSTEM.STATS
- -rw-r--r-- 1 grid supergroup 1760 2015-09-24 11:58 /hbase/SYSTEM.STATS/.tableinfo.0000000001
- drwxr-xr-x - grid supergroup 0 2015-09-24 11:58 /hbase/SYSTEM.STATS/.tmp
- drwxr-xr-x - grid supergroup 0 2015-09-24 11:58 /hbase/SYSTEM.STATS/b8f4908021c3ce0053947ae7fd92525e
- -rw-r--r-- 1 grid supergroup 243 2015-09-24 11:58 /hbase/SYSTEM.STATS/b8f4908021c3ce0053947ae7fd92525e/.regioninfo
- drwxr-xr-x - grid supergroup 0 2015-09-24 11:58 /hbase/SYSTEM.STATS/b8f4908021c3ce0053947ae7fd92525e/0
7、Phoenix创建表
- 0: jdbc:phoenix:master1> create table test(id integer primary key,name varchar(50));
- No rows affected (1.423 seconds)
- 0: jdbc:phoenix:master1> upsert into test values (1,'aaa');
- 1 row affected (0.137 seconds)
- 0: jdbc:phoenix:master1> upsert into test values (2,'bbb');
- 1 row affected (0.013 seconds)
- hbase(main):007:0> scan 'test'
- ROW COLUMN+CELL
-
- ERROR: Unknown table
-
- .....................................
- hbase(main):003:0> scan 'TEST'
- ROW COLUMN+CELL
- \x80\x00\x00\x01 column=0:NAME, timestamp=1443097208715, value=aaa
- \x80\x00\x00\x01 column=0:_0, timestamp=1443097208715, value=
- \x80\x00\x00\x02 column=0:NAME, timestamp=1443097216122, value=bbb
- \x80\x00\x00\x02 column=0:_0, timestamp=1443097216122, value=
- 2 row(s) in 0.0800 seconds
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12219480/viewspace-1808565/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/12219480/viewspace-1808565/