doris相关语法

1

1、建表预计
CREATE TABLE table1
(
    siteid INT DEFAULT '10',
    citycode SMALLINT,
    username VARCHAR(32) DEFAULT '',
    pv BIGINT SUM DEFAULT '0'
)
AGGREGATE KEY(siteid, citycode, username)
DISTRIBUTED BY HASH(siteid) BUCKETS 10
PROPERTIES("replication_num" = "1");

2、插入数据

 INSERT into table1 VALUES(1,2,'username1',2);
 
3、查询数据
 SELECT * from table1;
 
 
 CREATE TABLE table2
(
    siteid INT DEFAULT '10',
    citycode SMALLINT,
    username VARCHAR(32) DEFAULT '',
    pv BIGINT  DEFAULT '0'
)
AGGREGATE KEY(siteid, citycode, username,pv)
DISTRIBUTED BY HASH(siteid) BUCKETS 10
PROPERTIES("replication_num" = "1");

 INSERT into table2 VALUES(2,2,'username22',2);
 
SELECT * from table2;
 
 
 4、查询单台机器内存限制
 SHOW VARIABLES LIKE "%mem_limit%";
 
 5、查询正在变更的数据
 SHOW ALTER TABLE COLUMN;