phoenix映射hbase的简单操作

最新推荐文章于 2022-11-17 23:41:22 发布

原创最新推荐文章于 2022-11-17 23:41:22 发布 · 337 阅读

0 ·

CC 4.0 BY-SA版权

本文为博主原创文章，未经博主允许可以转载。

文章标签：

#hbase #大数据

HADOOP 专栏收录该内容

18 篇文章

订阅专栏

hbase shell
#创建表，插入数据
create 'cagy','info'
put 'cagy','rowkey01','info:name','cagy'

put 'cagy','rowkey02,'info:name','cagy2'

#映射表，以及查询
[root@namenode bin]# ./sqlline.py 
Setting property: [incremental, false]
Setting property: [isolation, TRANSACTION_READ_COMMITTED]
issuing: !connect jdbc:phoenix: none none org.apache.phoenix.jdbc.PhoenixDriver
Connecting to jdbc:phoenix:
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/opt/cloudera/parcels/PHOENIX-5.0.0-cdh6.2.0.p0.1308267/lib/phoenix/phoenix-5.0.0-cdh6.2.0-client.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/opt/cloudera/parcels/CDH-6.2.1-1.cdh6.2.1.p0.1425774/jars/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
Connected to: Phoenix (version 5.0)
Driver: PhoenixEmbeddedDriver (version 5.0)
Autocommit status: true
Transaction isolation: TRANSACTION_READ_COMMITTED
Building list of tables and columns for tab-completion (set fastconnect to true to skip)...
174/174 (100%) Done
Done
sqlline version 1.2.0
0: jdbc:phoenix:> create view "cagy"(rowkey varchar primary key,"info"."name" varchar);
No rows affected (6.816 seconds)
0: jdbc:phoenix:> 
0: jdbc:phoenix:> select * from "cagy";
+---------+-------+
| ROWKEY  | name  |
+---------+-------+
| row001  | cagy  |
| row002  | cagy  |
+---------+-------+
2 rows selected (0.056 seconds)
0: jdbc:phoenix:> select * from "cagy";
+---------+--------+
| ROWKEY  |  name  |
+---------+--------+
| row001  | cagy   |
| row002  | cagy1  |
+---------+--------+
2 rows selected (0.027 seconds)
0: jdbc:phoenix:> create view "cagy"(rowkey varchar primary key,"info"."name" varchar);