{"rsdb":{"rid":"309129","subhead":"","postdate":"0","aid":"224291","fid":"117","uid":"1","topic":"1","content":"<div id=\"article_content\" class=\"article_content clearfix csdn-tracking-statistics\" data-pid=\"blog\" data-mod=\"popu_307\" data-dsm=\"post\">\n            <link rel=\"stylesheet\" href=\"https:\/\/csdnimg.cn\/release\/phoenix\/template\/css\/ck_htmledit_views-f57960eb32.css\">\n                              <div id=\"content_views\" class=\"markdown_views prism-atom-one-dark\">\n            <!-- flowchart \u7bad\u5934\u56fe\u6807 \u52ff\u5220 -->\n            <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"display: none;\">\n              <path stroke-linecap=\"round\" d=\"M5,0 0,2.5 5,5z\" id=\"raphael-marker-block\" style=\"-webkit-tap-highlight-color: rgba(0, 0, 0, 0);\"><\/path>\n            <\/svg>\n            <p><strong>\u73af\u5883<\/strong>\uff1a <br>\nspark 2.2.0 hive 2.3.3 <br>\n<strong>\u95ee\u9898<\/strong>\uff1a <br>\n\u7528spark\u5e94\u7528\u521b\u5efa\u4e00\u5f20hive\u8868\u540e\uff0c\u5728\u901a\u8fc7hive shell\u6765\u64cd\u4f5chive\u65f6\u62a5\u5982\u4e0b\u9519\uff1b<\/p>\n\n\n\n<pre class=\"prettyprint\"><code class=\" hljs applescript\">MetaException(message:Hive Schema <span class=\"hljs-property\">version<\/span> <span class=\"hljs-number\">2.3<\/span><span class=\"hljs-number\">.0<\/span> <span class=\"hljs-keyword\">does<\/span> <span class=\"hljs-keyword\">not<\/span> match metastore's schema <span class=\"hljs-property\">version<\/span> <span class=\"hljs-number\">1.2<\/span><span class=\"hljs-number\">.0<\/span><\/code><\/pre>\n\n<p><strong>\u539f\u56e0<\/strong>\uff1a <br>\nspark\u5e94\u7528\u521b\u5efa\u8868\u65f6\uff0c\u6307\u5b9a\u7684schema\u7248\u672c\u4e3a1.2.0\uff0c\u800chive\u7684schema\u7248\u672c\u4e3a2.3.0\uff0c\u7248\u672c\u4e0d\u517c\u5bb9\u5bfc\u81f4 <br>\n<strong>\u89e3\u51b3\u529e\u6cd5<\/strong>\uff1a <br>\n\u4e34\u65f6\u89e3\u51b3\uff1a <br>\n\u5728mysql\uff08\u5047\u5b9ametastore\u7684\u6570\u636e\u5e93\u4e3amysql\uff09\u4e2d\uff0c\u5207\u6362\u5230hive\u5e93\uff0c\u6267\u884c\u5982\u4e0b\u547d\u4ee4<\/p>\n\n<pre class=\"prettyprint\"><code class=\" hljs sql\">    <span class=\"hljs-operator\"><span class=\"hljs-keyword\">UPDATE<\/span> VERSION <span class=\"hljs-keyword\">SET<\/span> SCHEMA_VERSION=<span class=\"hljs-string\">'2.3.0'<\/span>, VERSION_COMMENT=<span class=\"hljs-string\">'fix conflict'<\/span> <span class=\"hljs-keyword\">where<\/span> VER_ID=<span class=\"hljs-number\">1<\/span>;<\/span><\/code><\/pre>\n\n<p>\u8fd9\u6837\u89e3\u51b3\u540e\uff0c\u5f53\u901a\u8fc7spark\u5e94\u7528\u518d\u521b\u5efa\u65b0\u8868\u65f6\u4ecd\u4f1a\u62a5\u9519\u3002 <br>\n\u66f4\u597d\u7684\u89e3\u51b3\uff1a <br>\n    1. metastore\u6a21\u5f0f\u4f7f\u7528remote\u65b9\u5f0f <br>\n    2. \u901a\u8fc7cdh\u6765\u89e3\u51b3\u7248\u672c\u95ee\u9898<\/p>          <\/div>\n          <link href=\"https:\/\/csdnimg.cn\/release\/phoenix\/mdeditor\/markdown_views-258a4616f7.css\" rel=\"stylesheet\">\n                  <\/div>","orderid":"0","title":"MetaException(message:Hive Schema version 2.3.0 does not match metastore&#39;s schema version 1.2.0","smalltitle":"","mid":"0","fname":"Hive","special_id":"0","bak_id":"0","info":"0","hits":"469","pages":"1","comments":"0","posttime":"2019-05-16 00:58:17","list":"1557939497","username":"admin","author":"","copyfrom":"","copyfromurl":"","titlecolor":"","fonttype":"0","titleicon":"0","picurl":"https:\/\/www.cppentry.com\/upload_files\/","ispic":"0","yz":"1","yzer":"","yztime":"0","levels":"0","levelstime":"0","keywords":"<A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=MetaException' target=_blank>MetaException<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=message%3AHive' target=_blank>message:Hive<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=Schema' target=_blank>Schema<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=version' target=_blank>version<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=2.3.0' target=_blank>2.3.0<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=does' target=_blank>does<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=not' target=_blank>not<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=match' target=_blank>match<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=metastore%26%2339' target=_blank>metastore&#39<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=schema' target=_blank>schema<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=1.2.0' target=_blank>1.2.0<\/A>","jumpurl":"","iframeurl":"","style":"","template":"a:3:{s:4:\"foot\";s:0:\"\";s:8:\"bencandy\";s:0:\"\";s:4:\"head\";s:0:\"\";}","target":"0","ip":"47.106.78.186","lastfid":"0","money":"0","buyuser":"","passwd":"","allowdown":"","allowview":"","editer":"","edittime":"0","begintime":"0","endtime":"0","description":"                                                                                                        \u73af\u5883\uff1a spark 2.2.0 hive 2.3.3 \u95ee\u9898\uff1a \u7528spark\u5e94\u7528\u521b\u5efa\u4e00\u5f20hive\u8868\u540e\uff0c\u5728\u901a\u8fc7hive shell\u6765\u64cd\u4f5chive\u65f6\u62a5\u5982\u4e0b\u9519\uff1bMetaException(message:Hive Schema versi..","lastview":"1713916475","digg_num":"0","digg_time":"0","forbidcomment":"0","ifvote":"0","heart":"","htmlname":"","city_id":"0"},"page":"1"}