{"id":2165,"date":"2023-04-20T13:38:21","date_gmt":"2023-04-20T05:38:21","guid":{"rendered":"https:\/\/nj.transwarp.cn:8180\/?p=2165"},"modified":"2023-04-20T13:38:20","modified_gmt":"2023-04-20T05:38:20","slug":"6-x%e4%bb%a5%e4%b8%8b%e7%89%88%e6%9c%acinceptor%e5%a6%82%e4%bd%95%e4%bd%bf%e7%94%a8aes%e5%8a%a0%e5%af%86%e8%a7%a3%e5%af%86%e5%87%bd%e6%95%b0","status":"publish","type":"post","link":"https:\/\/kbwp.transwarp.cn\/?p=2165","title":{"rendered":"6.x\u4ee5\u4e0b\u7248\u672cinceptor\u5982\u4f55\u4f7f\u7528aes\u52a0\u5bc6\u89e3\u5bc6\u51fd\u6570"},"content":{"rendered":"<h3>\u6982\u8981\u63cf\u8ff0<\/h3>\n<hr \/>\n<p>6.x\u4ee5\u4e0b\u7248\u672c\u7684inceptor\u4e2d\u6ca1\u6709\u81ea\u5e26\u52a0\u5bc6\u51fd\u6570\u548c\u89e3\u5bc6\u51fd\u6570\uff0c\u5982\u679cTDH\u7248\u672c\u4f4e\u4e8e6.0\uff0c\u5374\u8981\u4f7f\u7528\u52a0\u5bc6\u89e3\u5bc6\u51fd\u6570\uff0c\u53ef\u4ee5\u901a\u8fc7\u5982\u4e0bUDF\u7684\u65b9\u5f0f\u5b9e\u73b0aes\u7684\u52a0\u5bc6\u548c\u89e3\u5bc6<br \/>\n\u8bf4\u660e\uff1a\u52a0\u5bc6\u51fd\u6570\u89e3\u5bc6\u51fd\u6570\u7684\u4f7f\u7528\u65b9\u6cd5\u53c2\u8003\u661f\u73af\u5b98\u7f516.0\u7248\u672c\u7684 &quot;inceptor\u4f7f\u7528\u624b\u518c&quot; \u4e2d &quot;\u52a0\u5bc6\u89e3\u5bc6&quot; \u7ae0\u8282<\/p>\n<h3>\u8be6\u7ec6\u8bf4\u660e<\/h3>\n<hr \/>\n<h4>\u4e0a\u4f20jar\u5305\u5230hdfs\u4e0a<\/h4>\n<p>aes\u52a0\u5bc6\u89e3\u5bc6UDF\u4f7f\u7528jar\u5305\uff1a<a href=\"\/.\/wp-content\/uploads\/2020\/02\/AESudf\u5305.zip\" title=\"AESudf\u5305\">AESudf\u5305<\/a><\/p>\n<ul>\n<li>\u5728hdfs\u521b\u5efa\u5355\u72ec\u7684\u8def\u5f84<\/li>\n<\/ul>\n<pre><code class=\"language-shell\">hdfs dfs -mkdir \/udf<\/code><\/pre>\n<ul>\n<li>\u5c06\u672c\u5730jar\u4e0a\u4f20\u5230\u65b0\u5efa\u7684udf\u8def\u5f84\u4e0b<\/li>\n<\/ul>\n<pre><code class=\"language-shell\">hdfs dfs -put AESudf.jar \/udf<\/code><\/pre>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/02\/image-1580790384478.png\" alt=\"file\" \/><\/p>\n<h4>\u4f7f\u7528beeline\u521b\u5efa\u6c38\u4e45\u51fd\u6570<\/h4>\n<ul>\n<li>\u901a\u8fc7beeline\u767b\u5f55\u5230inceptor\uff0c\u672c\u6b21\u793a\u4f8b\u662f\u4ee5LDAP\u65b9\u5f0f\u767b\u5f55<\/li>\n<\/ul>\n<pre><code class=\"language-shell\"> beeline -u \"jdbc:hive2:\/\/172.22.17.1:10000\/default\" -n hive -p 123456<\/code><\/pre>\n<ul>\n<li>\u521b\u5efa\u6c38\u4e45\u52a0\u5bc6udf\u51fd\u6570<\/li>\n<\/ul>\n<pre><code class=\"language-sql\">drop permanent function aes_encryptfunc;\ncreate permanent function aes_encryptfunc as 'aes.GenericUDFAesEncrypt' using jar 'hdfs:\/\/\/udf\/AESudf.jar';<\/code><\/pre>\n<ul>\n<li>\u521b\u5efa\u6c38\u4e45\u89e3\u5bc6udf\u51fd\u6570<\/li>\n<\/ul>\n<pre><code class=\"language-sql\">drop permanent function aes_decryptfunc;\ncreate permanent function aes_decryptfunc as 'aes.GenericUDFAesDecrypt' using jar 'hdfs:\/\/\/udf\/AESudf.jar';<\/code><\/pre>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/02\/image-1580794169132.png\" alt=\"file\" \/><\/p>\n<h4>\u6d4b\u8bd5\u9a8c\u8bc1<\/h4>\n<ul>\n<li>beeline\u4e2d\u9a8c\u8bc1\u52a0\u5bc6\u51fd\u6570<\/li>\n<\/ul>\n<pre><code class=\"language-sql\">SELECT base64(aes_encryptfunc('ABC', '1234567890123456')) AS result FROM system.dual;<\/code><\/pre>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/02\/image-1580794513012.png\" alt=\"file\" \/><\/p>\n<ul>\n<li>beeline\u4e2d\u9a8c\u8bc1\u89e3\u5bc6\u51fd\u6570<\/li>\n<\/ul>\n<pre><code class=\"language-sql\">SELECT aes_decryptfunc(unbase64('y6Ss+zCYObpCbgfWfyNWTw=='), '1234567890123456') AS result FROM system.dual;<\/code><\/pre>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2020\/02\/image-1580794662843.png\" alt=\"file\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6982\u8981\u63cf\u8ff0 6.x\u4ee5\u4e0b\u7248\u672c\u7684inceptor\u4e2d\u6ca1\u6709\u81ea\u5e26\u52a0\u5bc6\u51fd\u6570\u548c\u89e3\u5bc6\u51fd\u6570\uff0c\u5982\u679cTDH\u7248\u672c\u4f4e\u4e8e6.0\uff0c\u5374\u8981\u4f7f\u7528\u52a0\u5bc6 ..<\/p>\n<div class=\"clear-fix\"><\/div>\n<p><a href=\"https:\/\/kbwp.transwarp.cn\/?p=2165\" 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":[1],"tags":[],"class_list":["post-2165","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\/2165","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=2165"}],"version-history":[{"count":2,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/2165\/revisions"}],"predecessor-version":[{"id":10102,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/2165\/revisions\/10102"}],"wp:attachment":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2165"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2165"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2165"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}