DDL语句
1.修改字段注释,字段类型
alter table dev_dws.dws_transaction_data_h modify column order_cnt bigint comment '下单单数'
2.查看对应表的分区内容
mysql> show partitions from dev_ads.ads_real_deal_view \G
*************************** 1. row ***************************
PartitionId: 6942726
PartitionName: p20220524
VisibleVersion: 1
VisibleVersionTime: 2022-05-24 14:30:41
VisibleVersionHash: 0
State: NORMAL
PartitionKey: dt
Range: [types: [DATE]; keys: [2022-05-24]; ..types: [DATE]; keys: [2022-05-25]; )
DistributionKey: tenant_id, shop_id
Buckets: 32
ReplicationNum: 3
StorageMedium: HDD
CooldownTime: 9999-12-31 23:59:59
LastConsistencyCheckTime: NULL
DataSize: .000
IsInMemory: false
*************************** 2. row ***************************
PartitionId: 6942855
PartitionName: p20220525
VisibleVersion: 1
VisibleVersionTime: 2022-05-24 14:30:41
VisibleVersionHash: 0
State: NORMAL
PartitionKey: dt
Range: [types: [DATE]; keys: [2022-05-25]; ..types: [DATE]; keys: [2022-05-26]; )
DistributionKey: tenant_id, shop_id
Buckets: 32
ReplicationNum: 3
StorageMedium: HDD
CooldownTime: 9999-12-31 23:59:59
LastConsistencyCheckTime: NULL
DataSize: .000
IsInMemory: false
*************************** 3. row ***************************
PartitionId: 6942984
PartitionName: p20220526
VisibleVersion: 1
VisibleVersionTime: 2022-05-24 14:30:41
VisibleVersionHash: 0
State: NORMAL
PartitionKey: dt
Range: [types: [DATE]; keys: [2022-05-26]; ..types: [DATE]; keys: [2022-05-27]; )
DistributionKey: tenant_id, shop_id
Buckets: 32
ReplicationNum: 3
StorageMedium: HDD
CooldownTime: 9999-12-31 23:59:59
LastConsistencyCheckTime: NULL
DataSize: .000
IsInMemory: false
3.查看doris 节点 BE FE
查看BE状态
SHOW PROC '/backends';
查看FE状态
SHOW PROC '/frontends';
参考: dorisApache Doris常用命令
4. 建表语句
ALTER TABLE table_name RENAME TO new_table_name