常用命令杂记

--增改字段
alter table dwd.xxx add columns (column string comment 'XXX');
alter table dwd.xxx add columns (column string comment 'XXX');
alter table dwd.xxx change column column_old column_new string comment 'XXX';

--删除分区
alter table dws.xxx drop partition (dt='2021-07-08');

--计算数值
CAST(((pvsi.xxx * 100) / ptsi.xxx ) AS DECIMAL(38,2)) AS add_povy_acct_pct

--手动kill任务
hadoop job -kill job_1625010132008_0003
yarn application -kill application_1625010132008_0003

--转换内部表
EXTERNAL
alter table uuu set tblproperties('EXTERNAL' = 'TRUE');

 

--clickhouse
bin/ /usr/bin
conf/ /etc/clickhouse-server/
lib/ /var/lib/clickhouse
log/ /var/log/clickhouse