{"id":11502,"date":"2024-03-12T16:02:24","date_gmt":"2024-03-12T08:02:24","guid":{"rendered":"https:\/\/nj.transwarp.cn:8180\/?p=11502"},"modified":"2024-03-12T16:02:24","modified_gmt":"2024-03-12T08:02:24","slug":"%e5%a6%82%e4%bd%95%e9%80%9a%e8%bf%87api%e6%9f%a5%e7%9c%8bsql%e8%bf%90%e8%a1%8c%e8%bf%9b%e5%ba%a6","status":"publish","type":"post","link":"https:\/\/kbwp.transwarp.cn\/?p=11502","title":{"rendered":"\u5982\u4f55\u901a\u8fc7api\u67e5\u770bSQL\u8fd0\u884c\u8fdb\u5ea6"},"content":{"rendered":"

\u6982\u8981\u63cf\u8ff0<\/h3>\n

\u6709\u4e9b\u7528\u6237\u9700\u8981\u901a\u8fc7\u81ea\u5df1\u7684\u8fd0\u7ef4\u7ba1\u7406\u5e73\u53f0\u7ba1\u7406\u63d0\u4ea4\u5230\u6211\u4eecquark\u7684Query\u3002\u4e3b\u8981\u662f\u67e5\u770b\u4efb\u52a1\u8fdb\u5ea6<\/p>\n

\u8be6\u7ec6\u63cf\u8ff0<\/h3>\n

\u5b9e\u73b0\u539f\u7406<\/h4>\n

1.\u6bcf\u4e2asession\u53ea\u4f1a\u6267\u2f8f\u2f00\u4e2a\u67e5\u8be2\u8bed\u53e5\uff08\u5982SQL\uff09\u3002
\n2.\u6267\u2f8f\u67e5\u8be2\u8bed\u53e5\u4e4b\u524d\uff0c\u901a\u8fc7\u53c2\u6570ngmr.session.name\u4e3asession\u8bbe\u7f6e\u2f00\u4e2a\u2f83\u5b9a\u4e49\u540d\u79f0\u3002
\n3.\u901a\u8fc7\u2f83\u5b9a\u4e49\u7684session\u540d\u79f0\uff0c\u67e5\u770b\u6700\u8fd1\u7684\u67e5\u8be2\u8bed\u53e5\u7684\u6267\u2f8f\u72b6\u6001\/\u8017\u65f6\u7b49\u4fe1\u606f\uff0c\u6216\u8005kill\u8be5\u67e5\u8be2\u3002<\/p>\n

\u5b9e\u73b0\u65b9\u5f0f<\/h4>\n

1.\u4e3asession\u8bbe\u7f6e\u2f83\u5b9a\u4e49\u540d\u79f0
\n\u2f45\u5f0f1: \u5728\u6267\u2f8fSQL\u4e4b\u524d\u6267\u2f8f\uff1aset ngmr.session.name=my.s2;<\/p>\n

\u2f45\u5f0f2: beeline -u "jdbc:hive2:\/\/test2:10000\/default;?ngmr.session.name=my.s2" -n admin -p admin –maxWidth=1000 <\/p>\n

2.\u901a\u8fc7DBAService\u83b7\u53d6\u8fd0\u884c\u4e2d\u7684\u67e5\u8be2<\/p>\n

 curl -X POST \"http:\/\/172.22.23.4:4048\/api\/insights\/instance\/query\/sqlList?guardian_access_token=t4Dwqew6MXmaICtHBV2i-KTDH\" -H \"accept: *\/*\" -H \"Content-Type: application\/json\" -d \"{\\\"serverKey\\\":\\\"inceptor1@172.22.23.4:8888\\\",\\\"pagination\\\":{\\\"pageNumber\\\":1,\\\"pageSize\\\":1},\\\"filters\\\":{\\\"status\\\":[\\\"RUNNING\\\",\\\"SUBMITTED\\\",\\\"FETCHRESULT\\\",\\\"FILECOMMIT\\\",\\\"POSTRUN\\\"]},\\\"sorter\\\":{},\\\"enableHistory\\\":false}\"<\/code><\/pre>\n
3.\u53c2\u6570\u8bf4\u660e<\/p>\n
{\n  \"serverKey\": \"quark1@172.18.128.103:8888\", \/\/ quark\u670d\u52a1\u552f\u4e00\u6807\u8bc6\n  \"pagination\": {\n    \"pageNumber\": 1,\n    \"pageSize\": 20\n  },\n  \"filters\": {\n    \"status\": [  \/\/ \u8fd0\u884c\u4e2d\u7684\u4efb\u52a1\u7684\u4e0d\u540c\u9636\u6bb5\u72b6\u6001\n      \"RUNNING\",\n      \"SUBMITTED\",\n      \"FETCHRESULT\",\n      \"FILECOMMIT\",\n      \"POSTRUN\"\n    ],\n    \"sessionName\": \"my.s2\" \/\/ \u524d\u9762\u63d0\u4ea4\u8bbe\u7f6e\u7684ngmr.session.name\u7684\u503c\n  },\n  \"sorter\": {},\n  \"enableHistory\": false    \/\/ \u975e\u5386\u53f2\u67e5\u8be2\n}<\/code><\/pre>\n
4.\u8fd4\u56de\u7ed3\u679c<\/p>\n
{\n  \"total\": 2,\n  \"data\": {\n    \"queryLimitCN\": null,\n    \"queryLimitEN\": null,\n    \"sqls\": [\n      {\n        \"serverKey\": \"Inceptor::linux-idc-128-103::9c77aaab-29c4-4d4f-a733-d7c091781439\",\n        \"sqlId\": 55636,            \/\/ \u67e5\u8be2\u4efb\u52a1ID\uff0c\u540e\u9762kill\u4f1a\u9700\u8981\n        \"sqlContent\": \"SELECT *FROM dlx.product_dw WHERE price_group_id='L3'\",              \/\/ \u67e5\u8be2\u4efb\u52a1\u8be6\u60c5\n        \"mode\": \"cluster\",         \/\/ \u67e5\u8be2\u4efb\u52a1\u7684\u6267\u884c\u6a21\u5f0f\n        \"group\": \"inceptor\",\n        \"user\": \"hive\",            \/\/ \u67e5\u8be2\u4efb\u52a1\u7684\u63d0\u4ea4\u7528\u6237\n        \"sessionId\": 81692,\n        \"sessionName\": \"\",\n        \"status\": \"FETCHRESULT\",   \/\/ \u67e5\u8be2\u4efb\u52a1\u5f53\u524d\u6267\u884c\u9636\u6bb5\u72b6\u6001\uff0cFAILED\u8868\u793a\u5931\u8d25\uff0cSUCCESS\u8868\u793a\u6210\u529f\n        \"errMessage\": null,        \/\/ \u67e5\u8be2\u4efb\u52a1\u7684\u62a5\u9519\u4fe1\u606f\n        \"submissionTime\": 1684323388675, \/\/ \u67e5\u8be2\u4efb\u52a1\u5f00\u59cb\u65f6\u95f4\n        \"completionTime\": 0,       \/\/ \u67e5\u8be2\u4efb\u52a1\u5b8c\u6210\u65f6\u95f4\uff0c0\u8868\u793a\u672a\u7ed3\u675f\n        \"duration\": 2844654,       \/\/ \u67e5\u8be2\u4efb\u52a1\u603b\u8017\u65f6\n        \"latestTime\": 1684323390612,\n        \"jobStats\": { \/\/ job\u7684\u6267\u884c\u8fdb\u5ea6\n          \"running\": 0,\n          \"completed\": 1,\n          \"failed\": 0,\n          \"skipped\": 0,\n          \"unknown\": 0,\n          \"waiting\": 0,\n          \"expected\": 0,\n          \"totalCost\": 0\n        },\n        \"stageStats\": {\/\/ stage\u7684\u6267\u884c\u8fdb\u5ea6\n          \"running\": 0,\n          \"completed\": 1,\n          \"failed\": 0,\n          \"skipped\": 0,\n          \"unknown\": 0,\n          \"waiting\": 0,\n          \"expected\": 1,\n          \"totalCost\": 0\n        },\n        \"taskStats\": { \/\/ task\u7684\u6267\u884c\u8fdb\u5ea6\n          \"running\": 0,    \/\/ \u67e5\u8be2\u4efb\u52a1\u5360\u7528\u7684\u8ba1\u7b97\u8d44\u6e90\uff08executor\u6838\u6570\uff09\n          \"completed\": 47,\n          \"failed\": 0,\n          \"skipped\": 0,\n          \"unknown\": 0,\n          \"waiting\": 0,\n          \"expected\": 47,\n          \"totalCost\": 20593\n        },\n        \"poolNameSet\": [    \/\/ \u67e5\u8be2\u4efb\u52a1\u7684\u8d44\u6e90\u6c60\/\u8c03\u5ea6\u6c60\n          \"Q1\"\n        ],\n        \"jobTotal\": 1,\n        \"stageTotal\": 1,\n        \"taskTotal\": 47,\n        \"tags\": \"FINISHED\",\n        \"sqlLength\": 53,\n        \"shuffleReadSize\": 0,\n        \"shuffleWriteSize\": 0,\n        \"taskCost\": 20462,\n        \"tables\": [\n          \"dlx.product_dw\"\n        ],\n        \"inceptorTxnIds\": [],\n        \"waitArgoHoloTxnIds\": [],\n        \"blockArgoHoloTxnIds\": [],\n        \"argoHoloTxnIds\": [\n          0\n        ],\n        \"taskAbnormal\": [],\n        \"waitTime\": 36,\n        \"sqlType\": \"\",\n        \"uniqueSign\": \"Q09NTU9OK0luY2VwdG9yOjpsaW51eC1pZGMtMTI4LTEwMzo6OWM3N2FhYWItMjljNC00ZDRmLWE3MzMtZDdjMDkxNzgxNDM5KzU1NjM2\" \n      }\n    ],\n    \"statistics\": {\n      \"running\": 2,\n      \"success\": 0,\n      \"failed\": 0\n    }\n  },\n  \"messageCode\": 601,\n  \"message\": \"Success\",\n  \"info\": [],\n  \"warning\": [],\n  \"error\": [],\n  \"watchmanTimestamp\": 1684326233330\n}<\/code><\/pre>\n
\u6ce8\u610f\u4e8b\u9879<\/h3>\n
1.\u8bf7\u786e\u4fddinceptor\u6216\u8005quark\u90fd\u6253\u4e86\u6700\u65b0\u7248\u672c\u7684patch
\n2.dba\u5347\u7ea7dba-9.4.2-final\u6216\u4ee5\u4e0a\u7248\u672c
\n3.\u63d0\u4ea4\u4efb\u52a1\u65f6\u8bbe\u7f6e\u7684sessionName<\/p>\n","protected":false},"excerpt":{"rendered":"
\u6982\u8981\u63cf\u8ff0 \u6709\u4e9b\u7528\u6237\u9700\u8981\u901a\u8fc7\u81ea\u5df1\u7684\u8fd0\u7ef4\u7ba1\u7406\u5e73\u53f0\u7ba1\u7406\u63d0\u4ea4\u5230\u6211\u4eecquark\u7684Query\u3002\u4e3b\u8981\u662f\u67e5\u770b\u4efb\u52a1\u8fdb\u5ea6 \u8be6\u7ec6\u63cf\u8ff0 ..<\/p>\n
<\/div>\n
Read more<\/a><\/p>\n","protected":false},"author":161,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-11502","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"acf":[],"_links":{"self":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/11502","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/users\/161"}],"replies":[{"embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=11502"}],"version-history":[{"count":3,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/11502\/revisions"}],"predecessor-version":[{"id":11509,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/11502\/revisions\/11509"}],"wp:attachment":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=11502"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=11502"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=11502"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}