Python 获取 Presto/Trino 查询详情

Python 脚本如下：

from requests import get

response = get('http://172.16.34.xxx:9090/v1/query', auth=('zb', ''))
data = response.json()
for query_infos in data:
    # print(query_infos)
    try:
        print(query_infos['session']['user'], query_infos['session']['source'], query_infos['session']['catalog'],
              query_infos['session']['schema'], query_infos['session']['remoteUserAddress'], query_infos['query'],query_infos['session']['startTime'])
    except KeyError as e:
        print('KeyError')