{"id":826,"date":"2019-11-05T17:18:39","date_gmt":"2019-11-05T09:18:39","guid":{"rendered":"https:\/\/nj.transwarp.cn:8180\/?p=826"},"modified":"2019-11-05T17:18:39","modified_gmt":"2019-11-05T09:18:39","slug":"beeline%e4%bd%bf%e7%94%a8hivevar%e4%bc%a0%e5%8f%82","status":"publish","type":"post","link":"https:\/\/kbwp.transwarp.cn\/?p=826","title":{"rendered":"beeline\u4f7f\u7528hivevar\u4f20\u53c2"},"content":{"rendered":"<h3>\u6982\u8981\u63cf\u8ff0<\/h3>\n<p>\u4f7f\u7528 beeline -f \u6267\u884c\u4e00\u4e2aSQL\u811a\u672c\u65f6\uff0c\u4f20\u5165\u53c2\u6570<\/p>\n<h3>\u8be6\u7ec6\u8bf4\u660e<\/h3>\n<p>\u4f7f\u7528\u53c2\u6570 &#8211;hivevar \u6765\u5b9e\u73b0<\/p>\n<ol>\n<li>\u521b\u5efa\u5b58\u50a8\u8fc7\u7a0b\n<pre><code class=\"language-sql\">CREATE OR REPLACE PROCEDURE param(p_in1 IN STRING,p_in2 IN STRING,p_out OUT string)\nIS\nBEGIN\nDBMS_OUTPUT.PUT_LINE(\"IN param 1:\"||p_in1)\nDBMS_OUTPUT.PUT_LINE(\"IN param 2:\"||p_in2)\np_out := 'ab'\nEND <\/code><\/pre>\n<\/li>\n<li>\u7f16\u5199SQL\u811a\u672c\n<pre><code class=\"language-shell\">declare\nout2 string\nbegin\nparam('${hivevar:in1}','${hivevar:in2}',out2)\nDBMS_OUTPUT.PUT_LINE(\"out param:\"||out2)\nend<\/code><\/pre>\n<p>3.beeline\u547d\u4ee4\u8c03\u7528SQL\u811a\u672c<\/p>\n<pre><code class=\"language-shell\">beeline -u \"jdbc:hive2:\/\/172.22.33.1:10000\/default\" -n hive -p 123456 --hivevar in1='aa' --hivevar in2='bb' -f .\/param.sql<\/code><\/pre>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2019\/09\/beeline1.png\" alt=\"\" \/><\/p>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>\u6982\u8981\u63cf\u8ff0 \u4f7f\u7528 beeline -f \u6267\u884c\u4e00\u4e2aSQL\u811a\u672c\u65f6\uff0c\u4f20\u5165\u53c2\u6570 \u8be6\u7ec6\u8bf4\u660e \u4f7f\u7528\u53c2\u6570 &#8211;hiv ..<\/p>\n<div class=\"clear-fix\"><\/div>\n<p><a href=\"https:\/\/kbwp.transwarp.cn\/?p=826\" title=\"read more...\">Read more<\/a><\/p>\n","protected":false},"author":14,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[38],"tags":[],"class_list":["post-826","post","type-post","status-publish","format-standard","hentry","category-configuration"],"acf":[],"_links":{"self":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/826","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\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=826"}],"version-history":[{"count":0,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/826\/revisions"}],"wp:attachment":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=826"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=826"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=826"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}