hbase安装hhttps://www.cnblogs.com/shanheyongmu/p/15657167.html
启动 ./bin/start-hbase.sh
停止 ./bin/stop-hbase.sh
命令行工具
./bin/hbase shell
如果要删除表或更改其设置,以及在某些其他情况下,则需要先使用 disable 命令禁用该表
禁用表disable 'test'
删除表 drop 'test'
Phoenix安装
HBase - Phoenix的安装使用教程1(基本介绍、安装部署) - 山河永慕~ - 博客园
启动 sqlline.py localhost:2181
查看 !table
退出 !exit
建表
CREATE TABLE IF NOT EXISTS 表名(
列名 类型 主键,
列簇.列名,
列簇.列名
)
CREATE TABLE IF NOT EXISTS "student"(
id VARCHAR primary key,
name VARCHAR,
age VARCHAR);
CREATE TABLE IF NOT EXISTS tbl_order (
id BIGINT not null primary key,
order_code char(20),
total_amount decimal(10,2),
create_time date,
user_id bigint
);
mybatis-plus3操作
Hbase+Phoenix+Mybatis+Springboot整合查询数据 - 入门小站 - 博客园
Phoenix Query Server提供了一种与Phoenix和HBase交互的替代方法
启动queryserver,默认监听8765
apache-phoenix-5.0.0-HBase-2.0-bin/bin/queryserver.py
有用的sql:
select TO_CHAR(OP_DATE,'yyyy-MM-dd HH:mm:ss') from tb_user_log; SELECT * FROM tb_user_log where TO_CHAR(CREATE_TIME,'yyyy-MM-dd HH:mm:ss') between '2022-01-25 07:00:00' and '2022-01-25 08:15:35'; SELECT <include refid="Base_Column_List_With_Out_Create_Time" />,TO_CHAR(CREATE_TIME,'yyyy-MM-dd HH:mm:ss') as CREATE_TIME FROM tb_user_log where TO_CHAR(CREATE_TIME,'yyyy-MM-dd HH:mm:ss') between #{s} and #{e}; SELECT <include refid="Base_Column_List_With_Out_Create_Time" />,TO_CHAR(CREATE_TIME,'yyyy-MM-dd HH:mm:ss') as CREATE_TIME FROM tb_user_log where TO_CHAR(CREATE_TIME,'yyyy-MM-dd HH:mm:ss') between '2022-01-25 07:00:00' and '2022-01-25 08:15:35'; SELECT <include refid="Base_Column_List_With_Out_Create_Time" />,TO_CHAR(CREATE_TIME,'yyyy-MM-dd HH:mm:ss') as CREATE_TIME FROM tb_user_log where CREATE_TIME between TO_DATE('2022-01-25 07:00:00') and TO_DATE('2022-01-25 08:15:35') -- 添加字段 alter table tb_user_log add col6 bigint; -- 删除字段 alter table tb_user_log drop column col6; -- 把tables表中cloumn2列等于bbb的都改成aaa Upsert Into Table (cloumn1,cloumn2,cloumn3) Select Cloumn1,'aaa',Cloumn3 From Table where Cloumn2='bbb';