DorisSQL 语法使用汇总

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