{"id":17899,"date":"2026-07-10T15:44:01","date_gmt":"2026-07-10T07:44:01","guid":{"rendered":"https:\/\/kbwp.transwarp.cn\/?p=17899"},"modified":"2026-07-10T15:47:35","modified_gmt":"2026-07-10T07:47:35","slug":"dbaservice%e6%9c%ac%e6%9c%ba%e5%87%a0%e5%8d%83%e5%b9%b4%e5%ad%98%e5%82%a8%e5%85%a8%e9%87%8fsql%e6%8c%87%e6%a0%87%e7%9a%84%e9%85%8d%e7%bd%ae%e6%96%b9%e6%a1%88","status":"publish","type":"post","link":"https:\/\/kbwp.transwarp.cn\/?p=17899","title":{"rendered":"DBAService\u672c\u96c6\u7fa4\u5b58\u50a8\u5168\u91cfsql\u6307\u6807\u7684\u914d\u7f6e\u65b9\u6848"},"content":{"rendered":"<h3>\u6982\u8981\u63cf\u8ff0<\/h3>\n<hr \/>\n<p>\u672c\u6587\u63cf\u8ff0DBAService\u53ef\u4ee5\u6307\u5b9ahdfs\u548c\u4f9d\u8d56\u8be5hdfs\u7684quark server\u6765\u5199\u5165\u5b58\u50a8SQL\u6307\u6807\uff0c\u5373\u652f\u6301\u5404\u96c6\u7fa4\u7684\u6240\u6709dbaservice\u53ef\u4ee5\u6307\u5b9a\u540c\u4e00\u4e2ahdfs\u548cquark server\uff0c\u5e76\u6700\u7ec8\u5c06\u6240\u6709SQL\u6307\u6807\u6570\u636e\u6c47\u603b\u5230\u4e00\u5f20\u5b8c\u6574\u7684(ORC)\u8868\u4e2d\u3002<\/p>\n<h3>\u8be6\u7ec6\u63cf\u8ff0<\/h3>\n<hr \/>\n<p>\u542f\u7528\u8be5\u529f\u80fd\u53ea\u9700\u914d\u7f6e\u4ee5\u4e0b\u51e0\u6b65\uff1a<br \/>\nNOTE: \u8981inceptor <code>hive.server2.authentication<\/code> \u5f00\u542f\u4e86KERBEROS\u6216\u8005LDAP\uff0cDBAservice\u90fd\u9700\u8981\u5f00\u542fKERBEROS\u5b89\u5168\uff0c\u8fd9\u6837\u624d\u4f1a\u81ea\u52a8\u5efadbaservice database \u548c\u8868\u3002<\/p>\n<h4>1. DBAService\u66f4\u65b0\u4f9d\u8d56HDFS<\/h4>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/01\/image-1768284777304.png\" alt=\"file\" \/><\/p>\n<p>dba\u4f9d\u8d56\u7684hdfs\u5fc5\u987b\u548c\u914d\u7f6e\u6307\u5b9a\u7684quark\/inceptor\u4f9d\u8d56\u7684hdfs\u76f8\u540c\u3002<\/p>\n<h4>2. \u4fee\u6539dbaservice.sql.storage.server.jdbc.url\u4e3a\u6307\u5b9a\u5b58\u50a8\u6570\u636eORC\u8868\u7684quark server\u7684jdbc\u5730\u5740<\/h4>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/01\/image-1768284818244.png\" alt=\"file\" \/><\/p>\n<p><code>dbaservice.sql.storage.server.jdbc.url<\/code>: <code>jdbc:hive2:\/\/172.18.131.171:10000<\/code><\/p>\n<p>\u5f00\u542f\u5168\u91cfSQL\u4fdd\u5b58\u529f\u80fd(\u9ed8\u8ba4\u672a\u4f9d\u8d56\u548c\u8be5\u914d\u7f6e\u4e3a\u7a7a\u5219\u4e0d\u5f00\u542f)<\/p>\n<h4>3. \u914d\u7f6e\u670d\u52a1\u91cd\u542fDBAService<\/h4>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/01\/image-1768284892154.png\" alt=\"file\" \/><\/p>\n<h3>\u9a8c\u8bc1<\/h3>\n<hr \/>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/01\/image-1768285087294.png\" alt=\"file\" \/><\/p>\n<p>DBAService\u7684\u672c\u5730\u76ee\u5f55\u4e0a\u4f1a\u6709\u8fd9\u4e2a\u8def\u5f84  <code>{path}\/tmp\/upload-hdfs<\/code><\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/01\/image-1768290090521.png\" alt=\"file\" \/><\/p>\n<p>\u5982\u679c\u6ca1\u6709\u770b\u5230\u6709\u81ea\u52a8\u5efa\u8868\u8981\u53bb\u770b\u4e0bdbaservice.log\uff0c\u53ef\u80fd\u662f\u76f8\u5173\u7684\u8d26\u53f7\u7684\u6743\u9650\u95ee\u9898\uff0c\u53ef\u4ee5\u624b\u52a8\u53bb\u8d4b\u6743\u4e00\u4e0b\uff0c\u6216\u8005\u662f\u628adba_insight\u7528\u6237\u7684admin\u6743\u9650\u53bb\u6389\uff0c\u5e94\u8be5\u5c31\u53ef\u4ee5\u81ea\u52a8\u5efa\u4e86\u3002<\/p>\n<p>\u6743\u9650\u6539\u5b8c\uff0c\u91cd\u542fdbaservice\u540e\uff0c\u5373\u53ef\u3002<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/01\/image-1768291253013.png\" alt=\"file\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6982\u8981\u63cf\u8ff0 \u672c\u6587\u63cf\u8ff0DBAService\u53ef\u4ee5\u6307\u5b9ahdfs\u548c\u4f9d\u8d56\u8be5hdfs\u7684quark server\u6765\u5199\u5165\u5b58\u50a8SQ ..<\/p>\n<div class=\"clear-fix\"><\/div>\n<p><a href=\"https:\/\/kbwp.transwarp.cn\/?p=17899\" title=\"read more...\">Read more<\/a><\/p>\n","protected":false},"author":15,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-17899","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\/17899","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\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=17899"}],"version-history":[{"count":3,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/17899\/revisions"}],"predecessor-version":[{"id":19060,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/17899\/revisions\/19060"}],"wp:attachment":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=17899"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=17899"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=17899"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}