传统大数据团队如何做多维数据分析3- OLAP WareHouse

OLAP 云原生 演进方案

基础手册

SHOW WareHouse

将default warehouse中的值动态化 即实现该方法getWarehouseInfo

将自定义的warehouse也show

SHOW WAREHOUSES [WHERE WAREHOUSENAME=""/LIKE ""];

1. 实现自定义warehouse类，继承warehouse抽象类

runningSql和queuedSql需要评估剩余资源与该sql语句需要的资源来决定是否可以运行还是加入到queue中等待（参考virtual warehouse）

CREATE WareHouse

CREATE  WAREHOUSE [ IF NOT EXISTS ] <name>
       [ [ WITH ] objectProperties ]
       [ objectParams ]

DROP WareHouseDROP WAREHOUSE [ IF EXISTS ] <name> alter warehouse 修改配置参数property

ALTER WAREHOUSE [ IF EXISTS ] [ <name> ] { SUSPEND | RESUME [ IF SUSPENDED ] }
--! ALTER WAREHOUSE [ IF EXISTS ] [ <name> ] ABORT ALL QUERIES
ALTER WAREHOUSE [ IF EXISTS ] <name> RENAME TO <new_name>

ADD COMPUTE NODE

alter computer node computeNodeName/Id set warehouse="XXX" 为CN节点指定warehouse

新增 切换computer node

ALTER COMPUTE NODE [ <name> ] SET WAREHOUSE="xxx"

1. Show Nodes

SHOW NODES FROM WAREHOUSE <warehouse_name>; 

WareHouse To User

实现用户与warehouse的绑定 （取消system variables中的warehouse）或者计划支持为每个单独的用户指定默认仓库。用户的默认仓库用作该用户发起的所有会话的仓库。

SET WAREHOUSE="" 
ALTER USER sr_user SET PROPERTIES ('session.warehouse' = 'sr_warehouse');
CREATE USER 'sr_user' PROPERTIES ('session.warehouse' = 'sr_warehouse');

效果

ON xxx WareHouse

QUERY

compute

scan

On normal User WareHouse

query

scan

compute