登录10.224.11.11服务器 执行以下命令,将结果文件返回。 curl --connect-timeout 300 -m 3600 --request POST 'http://10.224.11.11:9999' --header 'Content-Type: application/json' -d '{"query":"select FROM_UNIXTIME(\"Start Time\") as \"Start Time\" ,\"Device Group\" as \"Device Group\" , sum(\"Sessions\") as \"Sessions\" from (select common_device_group as \"Device Group\" ,TIME_FLOOR_WITH_FILL (common_start_time,'\''PT1H'\'','\''zero'\'') as \"Start Time\" ,sum(common_sessions) as \"Sessions\" from session_record where ((common_recv_time >= UNIX_TIMESTAMP('\''2022-08-30 10:31:41'\'') and common_recv_time < UNIX_TIMESTAMP('\''2022-09-06 10:31:41'\'')) AND ( ( common_device_group = '\''BOL-IGW'\'' OR common_device_group = '\''SSM-IGW'\'' OR common_device_group = '\''MWV-IGW'\'' OR common_device_group = '\''BJR-IGW'\'' OR common_device_group = '\''DIR-IGW'\'' ) ) and common_device_group IN ( select common_device_group from session_record where (common_recv_time >= UNIX_TIMESTAMP('\''2022-08-30 10:31:41'\'') and common_recv_time < UNIX_TIMESTAMP('\''2022-09-06 10:31:41'\''))AND ( ( common_device_group = '\''BOL-IGW'\'' OR common_device_group = '\''SSM-IGW'\'' OR common_device_group = '\''MWV-IGW'\'' OR common_device_group = '\''BJR-IGW'\'' OR common_device_group = '\''DIR-IGW'\'' ) ) group by common_device_group order by sum(common_sessions) desc limit 10) ) group by \"Device Group\",\"Start Time\") group by \"Start Time\" ,\"Device Group\" order by \"Start Time\" asc", "option": "long-term", "reportId": "9999999","format": "csv"}' > 249_19259_result_csv curl --connect-timeout 300 -m 3600 --request POST 'http://10.224.11.11:9999' --header 'Content-Type: application/json' -d '{"query":"select FROM_UNIXTIME(\"Start Time\") as \"Start Time\" ,\"Device Group\" as \"Device Group\" , sum(\"Sessions\") as \"Sessions\" from (select common_device_group as \"Device Group\" ,TIME_FLOOR_WITH_FILL (common_start_time,'\''PT1H'\'','\''zero'\'') as \"Start Time\" ,sum(common_sessions) as \"Sessions\" from session_record where ((common_recv_time >= UNIX_TIMESTAMP('\''2022-08-30 10:31:41'\'') and common_recv_time < UNIX_TIMESTAMP('\''2022-09-06 10:31:41'\'')) AND ( ( common_device_group = '\''BOL-IGW'\'' OR common_device_group = '\''SSM-IGW'\'' OR common_device_group = '\''MWV-IGW'\'' OR common_device_group = '\''BJR-IGW'\'' OR common_device_group = '\''DIR-IGW'\'' ) ) and common_device_group IN ( select common_device_group from session_record where (common_recv_time >= UNIX_TIMESTAMP('\''2022-08-30 10:31:41'\'') and common_recv_time < UNIX_TIMESTAMP('\''2022-09-06 10:31:41'\''))AND ( ( common_device_group = '\''BOL-IGW'\'' OR common_device_group = '\''SSM-IGW'\'' OR common_device_group = '\''MWV-IGW'\'' OR common_device_group = '\''BJR-IGW'\'' OR common_device_group = '\''DIR-IGW'\'' ) ) group by common_device_group order by sum(common_sessions) desc limit 10) ) group by \"Device Group\",\"Start Time\") group by \"Start Time\" ,\"Device Group\" order by \"Start Time\" asc", "option": "long-term", "reportId": "9999999","format": "json"}' > 249_19259_result_json