diff options
| author | wangwei <[email protected]> | 2021-08-31 09:46:28 +0800 |
|---|---|---|
| committer | wangwei <[email protected]> | 2021-08-31 09:46:28 +0800 |
| commit | e56574ff6734640cc71a9f7aa107dac2e7c43bf9 (patch) | |
| tree | ff757f429e80b65443bfd7464fc42977a10d84c6 | |
| parent | c650a8e2f44ae260add94e5f774319763664e771 (diff) | |
fix(entity): TOP_SERVER_IP指定limit限制，避免赋值为defaultResultNum
| -rw-r--r-- | src/main/resources/http-sql-template.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/main/resources/http-sql-template.sql b/src/main/resources/http-sql-template.sql index 08ba4f47..84f1ea64 100644 --- a/src/main/resources/http-sql-template.sql +++ b/src/main/resources/http-sql-template.sql @@ -28,7 +28,8 @@ SELECT DISTINCT(ip) FROM ( UNION ALL (select common_server_ip as ip from %s where %s AND (common_l4_protocol IN ('IPv4_TCP' , 'IPv6_TCP')) group by ip order by sum(common_sessions) desc limit 100000) UNION ALL - (select common_server_ip as ip from %s where %s AND (common_l4_protocol IN ('IPv4_TCP' , 'IPv6_TCP')) group by ip order by COUNT(DISTINCT(common_client_ip)) desc limit 100000)) + (select common_server_ip as ip from %s where %s AND (common_l4_protocol IN ('IPv4_TCP' , 'IPv6_TCP')) group by ip order by COUNT(DISTINCT(common_client_ip)) desc limit 100000) +) LIMIT 280000 #end #sql("ENTITY_TOP_SNI") |