log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfigformore info.[root@hadoop01 log]## 这个错误是因为BE还没有部署,先不用管[root@hadoop01 log]# tail fe.logat org.apache.doris.datasource.InternalCatalog.createTable(InternalCatalog.java:1086)~[doris-fe.jar:1.2-SNAPSHOT]at o...
BackendId: 10003 Cluster: default_cluster IP: 172.21.32.5 HeartbeatPort: 9050 BePort: 9060 HttpPort: 8040 BrpcPort: 8060 LastStartTime: 2022-08-16 15:31:37 LastHeartbeat: 2022-08-17 13:33:17 Alive: true SystemDecommissioned: false ClusterDecommissioned: false TabletNum: 170 DataUsedCapacity...
执行完查询后,我们可以通过如下命令先获取 Profile 列表: mysql>showqueryprofile"/"\G***1.row***QueryId:8676cf2c28ac4081-95ead4b1b734b0b3User:rootDefaultDb:default_cluster:demoSQL:SELECTSUM(lo_extendedprice*lo_discount)ASREVENUEFROMlineorder,dateWHERElo_orderdate=d_datekeyANDd_weeknuminyear=6A...
BackendId: 10003 Cluster: default_cluster IP: 192.168.10.10 HeartbeatPort: 9050 BePort: 9060 HttpPort: 8040 BrpcPort: 8060 LastStartTime: 2022-08-16 15:31:37 LastHeartbeat: 2022-08-17 13:33:17 Alive: true SystemDecommissioned: false ClusterDecommissioned: false TabletNum: 170 DataUsedCapaci...
row *** BackendId: 11003 Cluster: default_cluster IP: 192.168.179.8 HeartbeatPort: 9050 BePort: 9060 HttpPort: 8040 BrpcPort: 8060 LastStartTime: 2023-02-06 20:14:36 LastHeartbeat: 2023-02-06 20:23:44 Alive: true SystemDecommissioned: false ClusterDecommissioned: false TabletNum: 0 Data...
| 10002 | default_cluster | 172.18.8.205 | hadoop01 | 9050 | 9060 | 8140 | 8060 | 2022-08-30 17:34:04 | 2022-08-30 17:49:56 | true | false | false | 33 | 2.713 KB | 4.018 TB | 5.269 TB | 23.73 % | 23.73 % | {"location" : "default"} | | 0.15.5-d987afe9d0 ...
fe.audit.log:审计日志,记录这个FE接收的所有SQL请求。 一条典型的FE日志如下:2021-09-16 23:13:22,502 INFO (tablet scheduler|43) [BeLoadRebalancer.selectAlternativeTabletsForCluster():85] cluster is balance: default_cluster with medium: HDD. skip ...
row *** BackendId: 10003 Cluster: default_cluster IP: 172.21.32.5 HeartbeatPort: 9050 BePort: 9060 HttpPort: 8040 BrpcPort: 8060 LastStartTime: 2022-08-16 15:31:37 LastHeartbeat: 2022-08-17 13:33:17 Alive: true SystemDecommissioned: false ClusterDecommissioned: false TabletNum: 170 ...
Create cluster 该语句用于新建逻辑集群 (cluster), 需要管理员权限。如果不使用多租户,直接创建一个名称为default_cluster的cluster。否则创建一个自定义名称的cluster。 语法: CREATE CLUSTER [IF NOT EXISTS] cluster_name PROPERTIES ("key"="value", ...) IDENTIFIED BY 'password' PROPERTIES 指定逻辑集群的属...
row *** QueryId: c257c52f93e149ee-ace8ac14e8c9fef9 User: root DefaultDb: default_cluster:db1 SQL: select tbl1.k1, sum(tbl1.k2) from tbl1 join tbl2 on tbl1.k1 = tbl2.k1 group by tbl1.k1 order by tbl1.k1 QueryType: Query StartTime: 2021-04-08 11:30:50 EndTime: 2021...