2.1 KiB
【E21-OLAP】查询现场流量分布情况
| ID | Creation Date | Assignee | Status |
|---|---|---|---|
| OMPUB-371 | 2022-02-17T10:08:16.000+0800 | 刘菊 | 完成 |
OAP-PE 站点从监控上发现，Transaction Records 日志规模是Session Records 两倍，需要查看数据分布，并做进一步的分析。
1：登录10.224.11.35服务器。 2：进入clickhouse客户端： clickhouse-client -h 127.0.0.1 --port 9001 -m -u tsg_query --password ***** 3：分别查询以下sql： SELECT common_schema_type,sum(common_sessions) FROM tsg_galaxy_v3.transaction_record tr WHERE common_recv_time >= toDateTime('2022-02-15 00:00:00') AND common_recv_time < toDateTime('2022-02-16 00:00:00') GROUP BY common_schema_type;
SELECT common_schema_type,sum(common_sessions) FROM tsg_galaxy_v3.transaction_record tr WHERE common_recv_time >= toDateTime('2022-02-03 00:00:00') AND common_recv_time < toDateTime('2022-02-04 00:00:00') GROUP BY common_schema_type;
SELECT common_schema_type,sum(common_sessions) FROM tsg_galaxy_v3.transaction_record tr WHERE common_recv_time >= toDateTime('2022-02-03 00:00:00') AND common_recv_time < toDateTime('2022-02-04 00:00:00') AND common_device_group = 'OAP-PE' GROUP BY common_schema_type;
SELECT common_schema_type,sum(common_sessions) FROM tsg_galaxy_v3.transaction_record tr WHERE common_recv_time >= toDateTime('2022-02-15 00:00:00') AND common_recv_time < toDateTime('2022-02-16 00:00:00') AND common_device_group = 'OAP-PE' GROUP BY common_schema_type;liuju commented on 2022-02-17T14:41:22.941+0800:
use tsg_galaxy_v3;
liuju commented on 2022-02-17T14:50:03.945+0800:
sql 语句查询结果已上传附件。
Attachments
Attachment: 微信图片_20220217094943.png
Attachment: 微信图片_20220217094951.png
