doris常用命令

SHOW PROC ‘/backends’; SHOW PROC ‘/frontends’; ALTER SYSTEM DROP FOLLOWER “211.67.156.98:9010”; ALTER SYSTEM ADD FOLLOWER “211.67.156.98:9010”; ALTER SYSTEM ADD BACKEND “192.168.0.1:9050”; IP 内存 priority_networks = 211.67.156.98/24 1stop fe 2 ALTER SYSTEM DROP FOLLOWER “211.67.156.98:9010”; ALTER SYSTEM ADD FOLLOWER “211.67.156.98:9010”; 3 换包 –helper 211.67.156.99:9010 –daemon /opt/user/jdk1.8.0_181/ SHOW PROC ‘/backends’; SHOW PROC ‘/frontends’;

ALTER SYSTEM DROP FOLLOWER “211.67.156.99:9010”; ALTER SYSTEM ADD FOLLOWER “211.67.156.99:9010”; curl -i -k https://117.158.83.73:8001/api/v1/auth/get-access-token curl -i -k https://172.16.251.2:8001/api/v1/auth/get-access-token select DISTINCT TO_CHAR(CLRQ,‘yyyy-MM-dd’) c from T_REC_CONSUME ORDER BY c desc; ALTER SESSION SET NLS_DATE_LANGUAGE=‘simplified chinese’; select DISTINCT TO_CHAR(cast(to_timestamp(OPDT,‘dd-MON-yy hh:mi:ss.ff AM’) as date),‘yyyy-MM-dd’) c from T_REC_KQMJ ORDER BY c desc; select DISTINCT TO_CHAR(CLRQ,‘yyyy-MM-dd’) c from T_REC_SAVE ORDER BY c desc; select DISTINCT TO_CHAR(SWINGTIME,‘yyyy-MM-dd’) c from DZ_T_SJTB_MJJL ORDER BY c desc; select DISTINCT TO_DATE((SUBSTR(HSRQ, 0, 10)||’ ‘||SUBSTR(HSRQ, 11, 18)),‘yyyy-MM-dd HH24:mi:ss’) c from T_TS_JYLS ORDER BY c desc; select DISTINCT left(CLRQ,10) c from T_REC_SAVE ORDER BY c desc; select DISTINCT left(CLRQ,10) c from T_REC_CONSUME ORDER BY c desc; SHOW PROC ‘/backends’; SHOW PROC ‘/frontends’; SHOW PROC ‘/statistic’; SHOW PROC ‘/statistic/6119160’; SHOW TABLET FROM dmm_dw.STU_COURSE; ADMIN SHOW REPLICA STATUS FROM dmm_dw.STU_COURSE PARTITION (p1, p2, p3) WHERE STATUS = “NORMAL”;

ADMIN SHOW REPLICA STATUS; SHOW PARTITIONS FROM dmm_dw.STU_COURSE; show create table dmm_dw.STU_COURSE; SHOW TABLET 6148330; ALTER SYSTEM DROP OBSERVER “211.67.156.100:9010”; –doris转换日期 select T1.OPDT, case when (T1.ho<12 and T1.ispm=1) then date_add(T1.OPDTF ,INTERVAL 12 HOUR) ELSE T1.OPDTF END opdtf from (select OPDT, str_to_date(regexp_replace(regexp_replace(OPDT,’.000000000’,’’),‘月 -’,’-20’),’%d-%m-%Y %H.%i.%s’) AS OPDTF, HOUR(str_to_date(regexp_replace(regexp_replace(OPDT,’.000000000’,’’),‘月 -’,’-20’),’%d- %m-%Y %H.%i.%s’)) AS ho, case when locate(‘下午’,OPDT)>0 then 1 ELSE0 END ispm from T_REC_KQMJ) T1; WHERE TO_DATE(MZRQ, ‘yyyy-mm-dd’) >= sysdate-1 WHERE DATE_FORMAT(gh.MZRQ, ‘%Y-%m-%d’) >= date_sub(CURDATE(), INTERVAL 30 DAY) WHERE extract(year from SQSJ)=extract(year from sysdate) WHERE YEAR(SQSJ)=YEAR(CURDATE()) 启动fe

sh bin/start_fe.sh –daemon 启动BE sh bin/start_be.sh –daemon