{"rsdb":{"rid":"309128","subhead":"","postdate":"0","aid":"224290","fid":"117","uid":"1","topic":"1","content":"
\n
\n \n <\/use>\n <\/svg>\n \n \u7248\u6743\u58f0\u660e\uff1a\u672c\u6587\u4e3a\u535a\u4e3b\u539f\u521b\u6587\u7ae0\uff0c\u672a\u7ecf\u535a\u4e3b\u5141\u8bb8\u4e0d\u5f97\u8f6c\u8f7d\u3002 https:\/\/blog.csdn.net\/refuil\/article\/details\/52327632 <\/div>\n \n \n
\n \n

\nSparkSQL\u524d\u8eab\u662fShark\uff0cShark\u5f3a\u70c8\u4f9d\u8d56\u4e8eHive\u3002Spark\u539f\u6765\u6ca1\u6709\u505aSQL\u591a\u7ef4\u5ea6\u6570\u636e\u67e5\u8be2\u5de5\u5177\uff0c\u540e\u6765\u5f00\u53d1\u4e86Shark\uff0cShark\u4f9d\u8d56\u4e8eHive\u7684\u89e3\u91ca\u5f15\u64ce\uff0c\u90e8\u5206\u5728Spark\u4e2d\u8fd0\u884c\uff0c\u8fd8\u6709\u4e00\u90e8\u5206\u5728Hadoop\u4e2d\u8fd0\u884c\u3002\u6240\u4ee5\u8bb2SparkSQL\u5fc5\u987b\u8bb2Hive\u3002<\/p>\n

\n<\/div>\n

\n\u4e00\u3001spark on hive\u539f\u7406\u4e0e\u642d\u5efa<\/h2>\n
\n<\/div>\n

\n1. hive\u7684\u672c\u8d28<\/h3>\n

\n1\uff09Hive\u662f\u5206\u5e03\u5f0f\u6570\u636e\u4ed3\u5e93\uff0c\u540c\u65f6\u53c8\u662f\u67e5\u8be2\u5f15\u64ce\uff0c\u6240\u4ee5SparkSQL\u53d6\u4ee3\u7684\u53ea\u662fHives\u7684\u67e5\u8be2\u5f15\u64ce\uff0c\u5728\u4f01\u4e1a\u5b9e\u9645\u751f\u4ea7\u73af\u5883\u4e0b\uff0cHive+SparkSQL\u662f\u76ee\u524d\u6700\u4e3a\u7ecf\u5178\u7684\u6570\u636e\u5206\u6790\u7ec4\u5408\u3002<\/p>\n

\n2\uff09Hive\u672c\u8eab\u5c31\u662f\u4e00\u4e2a\u7b80\u5355\u5355\u673a\u7248\u672c\u7684\u8f6f\u4ef6\uff0c\u4e3b\u8981\u8d1f\u8d23\uff1a<\/p>\n

A\uff09 \u628aHQL\u7ffb\u8bd1\u6210Mapper(s)-Reducer-Mapper(s)\u7684\u4ee3\u7801\uff0c\u5e76\u4e14\u53ef\u80fd\u4ea7\u751f\u5f88\u591aMapReduce\u7684JOB\u3002\nB\uff09\u628a\u751f\u6210\u7684MapReduce\u4ee3\u7801\u53ca\u76f8\u5173\u8d44\u6e90\u6253\u5305\u6210jar\u5e76\u53d1\u5e03\u5230Hadoop\u96c6\u7fa4\u4e2d\u8fd0\u884c\uff08\u8fd9\u4e00\u5207\u90fd\u662f\u81ea\u52a8\u7684\uff09\n<\/code><\/pre>\n

\n3\uff09Hive\u672c\u8eab\u7684\u67b6\u6784\u5982\u4e0b\u6240\u793a\uff1a
hive\u67b6\u6784<\/a><\/p>\n

\n\u53ef\u4ee5\u901a\u8fc7CLI\uff08\u547d\u4ee4\u7ec8\u7aef\uff09\u3001JDBC\/ODBC\u3001Web GUI\u8bbf\u95eeHive\u3002
\nJavaEE\u6216.net\u7a0b\u5e8f\u53ef\u4ee5\u901a\u8fc7Hive\u5904\u7406\uff0c\u518d\u628a\u5904\u7406\u7684\u7ed3\u679c\u5c55\u793a\u7ed9\u7528\u6237\u3002
\n\u4e5f\u53ef\u4ee5\u76f4\u63a5\u901a\u8fc7Web\u9875\u9762\u64cd\u4f5cHive\u3002
\n\u203b Hive\u672c\u8eab\u53ea\u662f\u4e00\u4e2a\u5355\u673a\u7248\u672c\u7684\u7684\u8f6f\u4ef6\uff0c\u600e\u4e48\u8bbf\u95eeHDFS\u7684\u5462\uff1f
\n=> \u5728Hive\u7528Table\u7684\u65b9\u5f0f\u63d2\u5165\u6570\u636e\u3001\u68c0\u7d22\u6570\u636e\u7b49\uff0c\u8fd9\u5c31\u9700\u8981\u77e5\u9053\u6570\u636e\u653e\u5728HDFS\u7684\u4ec0\u4e48\u5730\u65b9\u4ee5\u53ca\u4ec0\u4e48\u5730\u65b9\u5c5e\u4e8e\u4ec0\u4e48\u6570\u636e\uff0cMetastore\u5c31\u662f\u4fdd\u5b58\u8fd9\u4e9b\u5143\u6570\u636e\u4fe1\u606f\u7684\u3002Hive\u901a\u8fc7\u8bbf\u95ee\u5143\u6570\u636e\u4fe1\u606f\u518d\u53bb\u8bbf\u95eeHDFS\u4e0a\u7684\u6570\u636e\u3002<\/p>\n

\n\u53ef\u4ee5\u770b\u51faHDFS\u4e0d\u662f\u4e00\u4e2a\u771f\u5b9e\u7684\u6587\u4ef6\u7cfb\u7edf\uff0c\u662f\u865a\u62df\u7684\uff0c\u662f\u903b\u8f91\u4e0a\u7684\uff0cHDFS\u53ea\u662f\u4e00\u5957\u8f6f\u4ef6\u800c\u5df2\uff0c\u5b83\u662f\u7ba1\u7406\u4e0d\u540c\u673a\u5668\u4e0a\u7684\u6570\u636e\u7684\uff0c\u6240\u4ee5\u9700\u8981NameNode\u53bb\u7ba1\u7406\u5143\u6570\u636e\u3002DataNode\u53bb\u7ba1\u7406\u6570\u636e\u3002
\nHive\u901a\u8fc7Metastore\u548cNameNode\u6253\u4ea4\u9053\u3002<\/p>\n

\n<\/div>\n

\n2. Hive\u5b89\u88c5\u548c\u914d\u7f6e\u5b9e\u6218<\/h3>\n

\nSpark1.6.1\u4e2dSparkSQL\u53ef\u4ee5\u6307\u5b9a\u5177\u4f53\u7684Hive\u7684\u7248\u672c\u3002
\n1\uff09 \u4eceapache\u5b98\u7f51\u4e0b\u8f7dhive-1.2.1\uff0c\u5e76\u89e3\u538b\u5230\/home\/richard\u76ee\u5f55\u3002
http:\/\/mirrors.cnnic.cn\/apache\/hive\/hive-1.2.1\/<\/a>
\n2\uff09 \u914d\u7f6e.bashrc\uff0c\u8ffd\u52a0\u4ee5\u4e0b\u5185\u5bb9\uff0c\u6216\u8005\/etc\/profile:<\/p>\n

\n<\/div>\n
<\/pre>
  1. export<\/span> HIVE_HOME<\/span>=<\/span>\/home\/<\/span>richard<\/span>\/<\/span>hive<\/span>-<\/span>1.2<\/span>.<\/span>1<\/span><\/code><\/li>
  2. export<\/span> HIVE_CONF_DIR<\/span>=<\/span>\/$HIVE_HOME\/<\/span>conf<\/span><\/code><\/li>
  3. export<\/span> PATH<\/span>=<\/span>$PATH<\/span>:<\/span>$HIVE_HOME<\/span>\/<\/span>bin<\/span><\/code><\/li><\/ol>\n

    \n3\uff09\u8fdb\u5165\/home\/richard\/hive-1.2.1\/conf\u76ee\u5f55\uff0c\u751f\u6210hive-env.sh:<\/p>\n

    \n<\/div>\n
    <\/pre>
    1. cp hive<\/span>-<\/span>default<\/span>.<\/span>xml<\/span>.<\/span>template<\/span> hive<\/span>-<\/span>site<\/span>.<\/span>xml<\/span><\/code><\/li><\/ol>\n

      \n\u914d\u7f6e\uff1a<\/p>\n

      \n<\/div>\n
      <\/pre>
      1. export<\/span> HADOOP_HOME<\/span>=<\/span>\/opt\/<\/span>hadoop<\/span>-<\/span>2.6<\/span>.<\/span>0<\/span><\/code><\/li>
      2. export<\/span> HIVE_HOME<\/span>=<\/span>\/opt\/<\/span>hive<\/span>-<\/span>1.2<\/span>.<\/span>1<\/span>\/<\/span><\/code><\/li>
      3. export<\/span> HIVE_CONF_DIR<\/span>=<\/span>\/opt\/<\/span>hive<\/span>-<\/span>1.2<\/span>.<\/span>1<\/span>\/<\/span>conf<\/span><\/code><\/li><\/ol>\n

        \nHive\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u653e\u5143\u6570\u636e\u7684\u6570\u636e\u5e93\u662fDerby\uff0c\u9057\u61be\u7684\u662fDerby\u662f\u5355\u7528\u6237\uff0c\u6240\u4ee5\u5728\u751f\u4ea7\u73af\u5883\u4e0b\u4e00\u822c\u4f1a\u91c7\u7528\u652f\u6301\u591a\u7528\u6237\u7684\u6570\u636e\u5e93\u6765\u8fdb\u884cMetaStore\uff0c\u4e14\u8fdb\u884cMaster-Slaves\u4e3b\u4ece\u8bfb\u5199\u5206\u79bb\u548c\u5907\u4efd\uff08\u4e00\u822cMaster\u8282\u70b9\u8d1f\u8d23\u5199\u6570\u636e\uff0cSlaves\u8282\u70b9\u8d1f\u8d23\u8bfb\u6570\u636e\uff09\u3002\u6700\u5e38\u7528\u7684\u662fMySQL\u3002<\/p>\n

        \ncp hive-env.sh.template hive-env.sh
        \n\u518d\u751f\u6210hive-site.xml\uff0c\u5e76\u914d\u7f6e\u5982\u4e0b\uff1a<\/p>\n

        \n<\/div>\n
        <\/pre>
        1. <configuration><\/span><\/code><\/li>
        2. <\/span><!-- WARNING!!! This file is auto generated for documentation purposes ONLY! --><\/span><\/code><\/li>
        3. <\/span><!-- WARNING!!! Any changes you make to this file will be ignored by Hive. --><\/span><\/code><\/li>
        4. <\/span><!-- WARNING!!! You must make your changes in hive-site.xml instead. --><\/span><\/code><\/li>
        5. <\/span><!-- Hive Execution Parameters --><\/span><\/code><\/li>
        6. <\/span><property><\/span><\/code><\/li>
        7. <\/span><name><\/span>java<\/a>x.jdo.option.ConnectionURL<\/span><\/name><\/span><\/code><\/li>
        8. <\/span><value><\/span>jdbc:mysql:\/\/master:3306\/hivecreateDatabaseIfNotExist=true<\/span><\/value><\/span><\/code><\/li>
        9. <\/span><description><\/span>JDBC connect string for a JDBC metastore<\/span><\/description><\/span><\/code><\/li>
        10. <\/span><\/property><\/span><\/code><\/li>
        11. <\/span><property><\/span><\/code><\/li>
        12. <\/span><name><\/span>java<\/a>x.jdo.option.ConnectionDriverName<\/span><\/name><\/span><\/code><\/li>
        13. <\/span><value><\/span>com.mysql.jdbc.Driver<\/span><\/value><\/span><\/code><\/li>
        14. <\/span><description><\/span>Driver class name for a JDBC metastore<\/span><\/description><\/span><\/code><\/li>
        15. <\/span><\/property><\/span><\/code><\/li>
        16. <\/span><property><\/span><\/code><\/li>
        17. <\/span><name><\/span>javax.jdo.option.ConnectionUserName<\/span><\/name><\/span><\/code><\/li>
        18. <\/span><value><\/span>root<\/span><\/value><\/span><\/code><\/li>
        19. <\/span><description><\/span>username to use against metastore database<\/span><\/description><\/span><\/code><\/li>
        20. <\/span><\/property><\/span><\/code><\/li>
        21. <\/span><property><\/span><\/code><\/li>
        22. <\/span><name><\/span>javax.jdo.option.ConnectionPassword<\/span><\/name><\/span><\/code><\/li>
        23. <\/span><value><\/span>778899..<\/span><\/value><\/span> <\/span><\/code><\/li>
        24. <\/span><description><\/span>password to use against metastore database<\/span><\/description><\/span><\/code><\/li>
        25. <\/span><\/property><\/span><\/code><\/li>
        26. <\/span><property><\/span><\/code><\/li>
        27. <\/span><name><\/span>hive.metastore.warehouse.dir<\/span><\/name><\/span><\/code><\/li>
        28. <\/span><value><\/span>\/user\/hive\/warehouse<\/span><\/value><\/span><\/code><\/li>
        29. <\/span><description><\/span>location of default database for the warehouse<\/span><\/description><\/span><\/code><\/li>
        30. <\/span><\/property><\/span><\/code><\/li>
        31. <\/configuration><\/span><\/code><\/li><\/ol>\n

          \nHive\u4e2d\u7684DataBase\u548c\u8868\u5176\u5b9e\u5c31\u662fHDFS\u4e0a\u7684\u76ee\u5f55\u548c\u7b80\u5355\u7684\u6587\u672c\u6587\u4ef6\u3002\u7b80\u5355\u7684\u6587\u672c\u6587\u4ef6\u4e2d\u6709\u51e0\u5217\u6570\u636e\uff0c\u6bcf\u5217\u6570\u636e\u7684\u7c7b\u578b\u65e0\u6cd5\u76f4\u63a5\u4ece\u6587\u672c\u6587\u4ef6\u4e2d\u5f97\u77e5\u3002\u4f46\u5f53\u6570\u636e\u653e\u5165Hive\u4e2d\uff0cHive\u5c31\u628a\u5143\u6570\u636e\u653e\u5165Mysql\u4e2d\u4e86\uff0c\u8fd9\u6837\u5c31\u53ef\u4ee5\u57fa\u4e8e\u6570\u636e\u7684\u8868\u8fdb\u884c\u67e5\u8be2\u4e86\u3002<\/p>\n

          \n4) MYSQL\u7684\u5b89\u88c5\u548c\u914d\u7f6e
          \nroot\u7528\u6237\u4e0b\u6267\u884cyum -y install mysql-server\u5373\u53ef\u81ea\u52a8\u5b89\u88c5
          \n\u6267\u884crpm -qa mysql-server\u53ef\u4ee5\u67e5\u770b\u662f\u5426\u5b89\u88c5\u6210\u529f\u53ca\u5b89\u88c5\u7684mysql\u7248\u672c\u3002
          \n\u53c2\u8003redhat4.4.7\u5982\u4f55\u5b89\u88c5mysql\uff08\u975eyum \u5b89\u88c5\uff09
          http:\/\/blog.csdn.net\/choice_jj\/article\/details\/8827649<\/a>
          http:\/\/jingyan.baidu.com\/article\/1974b289acebd0f4b0f77469.html<\/a>
          \n\u8bbe\u7f6e\u5bc6\u7801\u95ee\u9898\uff1a
          http:\/\/blog.csdn.net\/rogerzhanglijie\/article\/details\/9182125<\/a><\/p>\n

          \nhive\u6253\u5f00\u9519\u8bef\u53c2\u8003\uff1a<\/p>\n

          \n<\/div>\n
          <\/pre>
          1. \u4e3b\u8981\u662f\u6309\u7167\u300a<\/span>DT<\/span>-\u5927\u6570\u636e<\/span> hive1<\/span>.<\/span>2.1<\/span>\u7528<\/span>mysql<\/span>\u4f5c\u4e3a\u5143\u6570\u636e\u5e93\u642d\u5efa\u300b\u6587\u6863<\/span><\/code><\/li><\/ol>\n

            \n\u53e6\u5916\u8fd8\u9700\u8981\u4e0b\u8f7d\u9a71\u52a8\u5305(mysql-connector-java-5.1.35.tar.gz)\u5c06.jar\u6587\u4ef6\u653e\u5230\u8fd9\u4e2a\u76ee\u5f55\u4e0b\uff1a<\/p>\n

            \n<\/div>\n
            <\/pre>
            1. cd <\/span>\/<\/span>usr<\/span>\/<\/span>local<\/span>\/<\/span>hive<\/span>\/<\/span>apache<\/span>-<\/span>hive<\/span>-<\/span>1.2<\/span>.<\/span>1<\/span>\/<\/span>lib<\/span>\/<\/span><\/code><\/li><\/ol>\n
              \n<\/div>\n

              \n\u542f\u52a8hive\u62a5\u9519<\/h4>\n
              \n<\/div>\n
              <\/pre>
              1. Logging<\/span> initialized <\/span>using<\/span> configuration <\/span>in<\/span> jar<\/span>:<\/span>file<\/span>:<\/span>\/opt\/<\/span>hive<\/span>-<\/span>1.2<\/span>.<\/span>1<\/span>\/<\/span>lib<\/span>\/<\/span>hive<\/span>-<\/span>common<\/span>-<\/span>1.2<\/span>.<\/span>1.jar<\/span>!\/<\/span>hive<\/span>-<\/span>log4j<\/span>.<\/span>properties<\/span><\/code><\/li>
              2. Exception<\/span> <\/span>in<\/span> thread <\/span>\"main\"<\/span> java<\/span>.<\/span>lang<\/span>.<\/span>RuntimeException<\/span>:<\/span> java<\/span>.<\/span>lang<\/span>.<\/span>RuntimeException<\/span>:<\/span> <\/span>Unable<\/span> to instantiate org<\/span>.<\/span>apache<\/span>.<\/span>hadoop<\/span>.<\/span>hive<\/span>.<\/span>ql<\/span>.<\/span>metadata<\/span>.<\/span>SessionHiveMetaStoreClient<\/span><\/code><\/li>
              3. Caused<\/span> <\/span>by<\/span>:<\/span> java<\/span>.<\/span>lang<\/span>.<\/span>RuntimeException<\/span>:<\/span> <\/span>Unable<\/span> to instantiate org<\/span>.<\/span>apache<\/span>.<\/span>hadoop<\/span>.<\/span>hive<\/span>.<\/span>ql<\/span>.<\/span>metadata<\/span>.<\/span>SessionHiveMetaStoreClient<\/span><\/code><\/li>
              4. Caused<\/span> <\/span>by<\/span>:<\/span> java<\/span>.<\/span>lang<\/span>.<\/span>reflect<\/span>.<\/span>InvocationTargetException<\/span><\/code><\/li>
              5. Caused<\/span> <\/span>by<\/span>:<\/span> javax<\/span>.<\/span>jdo<\/span>.<\/span>JDOFatalDataStoreException<\/span>:<\/span> <\/span>Unable<\/span> to open a test connection to the given database<\/span>.<\/span> JDBC url <\/span>=<\/span> jdbc<\/span>:<\/span>mysql<\/span>:<\/span>\/\/master:3306\/hivecreateDatabaseIfNotExist=true, username = hive. Terminating connection pool (set lazyInit to true if you expect to start your database after <\/span><\/code><\/li>
              6. ...<\/span><\/code><\/li><\/ol>\n
                \n<\/div>\n
                <\/pre>
                1. root@master<\/span>:\/<\/span>opt<\/span># netstat -tnlp | grep 3306<\/span><\/code><\/li>
                2. tcp <\/span>0<\/span> <\/span>0<\/span> <\/span>127.0<\/span>.<\/span>0.1<\/span>:<\/span>3306<\/span> <\/span>0.0<\/span>.<\/span>0.0<\/span>:*<\/span> LISTEN <\/span>5090<\/span>\/<\/span>mysqld <\/span><\/code><\/li>
                3. \/\/mysql\u7684\u76d1\u542cIP\u5e94\u8be5\u662f0.0.0.0 <\/span><\/code><\/li>
                4. \/\/\u5728vi \/etc\/mysql\/my.cnf \u4e2d\u4fee\u6539<\/span><\/code><\/li>
                5. killall mysqld <\/span>\u540e\u5b88\u62a4\u8fdb\u7a0b\u8fd8\u4f1a\u542f\u52a8<\/span>mysql<\/span>\uff0c\u7b49\u4e8e\u91cd\u542f<\/span><\/code><\/li><\/ol>\n

                  \n\u53e6\u5916\u62a5\u9519\uff1a<\/p>\n

                  \n<\/div>\n
                  <\/pre>
                  1. SLF4J<\/span>:<\/span> <\/span>See<\/span> http<\/span>:<\/span>\/\/www.slf4j.org\/codes.html#multiple_bindings for an explanation.<\/span><\/code><\/li>
                  2. SLF4J<\/span>:<\/span> <\/span>Actual<\/span> binding <\/span>is<\/span> of type <\/span>[<\/span>org<\/span>.<\/span>slf4j<\/span>.<\/span>impl<\/span>.<\/span>Log4jLoggerFactory<\/span>]<\/span><\/code><\/li>
                  3. [<\/span>ERROR<\/span>]<\/span> <\/span>Terminal<\/span> initialization failed<\/span>;<\/span> falling back to unsupported<\/span><\/code><\/li><\/ol>\n

                    \n\u539f\u56e0\u662fhadoop\u76ee\u5f55\u4e0b\u5b58\u5728\u8001\u7248\u672cjline\uff1a
                    \n\/hadoop-2.5.2\/share\/hadoop\/yarn\/lib\uff1a
                    \n-rw-r--r-- 1 root root 87325 Mar 10 18:10 jline-0.9.94.jar<\/p>\n

                    \n\u89e3\u51b3\u65b9\u6cd5\u662f\uff1a<\/p>\n

                    \n<\/div>\n
                    <\/pre>
                    1. \u5c06<\/span>hive<\/span>\u4e0b\u7684\u65b0\u7248\u672c<\/span>jline<\/span>\u7684<\/span>JAR<\/span>\u5305\u62f7\u8d1d\u5230<\/span>hadoop<\/span>\u4e0b\uff1a<\/span><\/code><\/li>
                    2. cp <\/span>\/<\/span>hive<\/span>\/<\/span>apache<\/span>-<\/span>hive<\/span>-<\/span>1.1<\/span>.<\/span>0<\/span>-<\/span>bin<\/span>\/<\/span>lib<\/span>\/<\/span>jline<\/span>-<\/span>2.12<\/span>.<\/span>jar <\/span>.\/<\/span><\/code><\/li><\/ol>\n

                      \n5) Hive\u7684\u8868\u6709\u4e24\u79cd\u57fa\u672c\u7c7b\u578b\uff1a\u4e00\u79cd\u662f\u5185\u90e8\u8868\uff08\u8fd9\u79cd\u8868\u6570\u636e\u5c5e\u4e8eHive\u672c\u8eab\uff0c\u5373\u5982\u679c\u539f\u6765\u7684\u6570\u636e\u5728HDFS\u7684\u5176\u4ed6\u5730\u65b9\uff0c\u6b64\u65f6\u6570\u636e\u4f1a\u901a\u8fc7HDFS\u79fb\u52a8\u5230Hive\u6240\u5728\u76ee\u5f55\uff0c\u5982\u679c\u5220\u9664Hive\u4e2d\u7684\u8be5\u8868\u7684\u8bdd\u6570\u636e\u548c\u5143\u6570\u636e\u5747\u4f1a\u88ab\u5220\u9664\uff09\uff0c\u4e00\u79cd\u662f\u5916\u90e8\u8868\uff08\u8fd9\u79cd\u8868\u6570\u636e\u4e0d\u5c5e\u4e8eHive\u6570\u636e\u4ed3\u5e93\uff0c\u5143\u6570\u636e\u4e2d\u4f1a\u8868\u8fbe\u5177\u4f53\u6570\u636e\u5728\u54ea\u91cc\uff0c\u4f7f\u7528\u65f6\u548c\u5185\u90e8\u8868\u7684\u4f7f\u7528\u4e00\u6837\uff0c\u53ea\u662f\u5982\u679c\u901a\u8fc7Hive\u53bb\u5220\u9664\u7684\u8bdd\uff0c\u5220\u9664\u7684\u53ea\u662f\u5143\u6570\u636e\uff0c\u5e76\u6ca1\u6709\u5220\u9664\u6570\u636e\u672c\u8eab\uff09<\/p>\n

                      \n6\uff09Hive\u6269\u5c55\uff08Hive\u7684\u6570\u636e\u5b58\u50a8-\u8f6c\u8f7d\uff09<\/p>\n

                      \nHive\u662f\u57fa\u4e8eHadoop\u5206\u5e03\u5f0f\u6587\u4ef6\u7cfb\u7edf\u7684\uff0c\u5b83\u7684\u6570\u636e\u5b58\u50a8\u5728Hadoop\u5206\u5e03\u5f0f\u6587\u4ef6\u7cfb\u7edf\u4e2d\u3002Hive\u672c\u8eab\u662f\u6ca1\u6709\u4e13\u95e8\u7684\u6570\u636e\u5b58\u50a8\u683c\u5f0f\uff0c\u4e5f\u6ca1\u6709\u4e3a\u6570\u636e\u5efa\u7acb\u7d22\u5f15\uff0c\u53ea\u9700\u8981\u5728\u521b\u5efa\u8868\u7684\u65f6\u5019\u544a\u8bc9Hive\u6570\u636e\u4e2d\u7684\u5217\u5206\u9694\u7b26\u548c\u884c\u5206\u9694\u7b26\uff0cHive\u5c31\u53ef\u4ee5\u89e3\u6790\u6570\u636e\u3002\u6240\u4ee5\u5f80Hive\u8868\u91cc\u9762\u5bfc\u5165\u6570\u636e\u53ea\u662f\u7b80\u5355\u7684\u5c06\u6570\u636e\u79fb\u52a8\u5230\u8868\u6240\u5728\u7684\u76ee\u5f55\u4e2d(\u5982\u679c\u6570\u636e\u662f\u5728HDFS\u4e0a;\u4f46\u5982\u679c\u6570\u636e\u662f\u5728\u672c\u5730\u6587\u4ef6\u7cfb\u7edf\u4e2d\uff0c\u90a3\u4e48\u662f\u5c06\u6570\u636e\u590d\u5236\u5230\u8868\u6240\u5728\u7684\u76ee\u5f55\u4e2d)\u3002<\/p>\n

                      \nHive\u4e2d\u4e3b\u8981\u5305\u542b\u4ee5\u4e0b\u51e0\u79cd\u6570\u636e\u6a21\u578b\uff1aTable(\u8868)\uff0cExternal Table(\u5916\u90e8\u8868)\uff0cPartition(\u5206\u533a)\uff0cBucket(\u6876)(\u672c\u535a\u5ba2\u4f1a\u4e13\u95e8\u5199\u51e0\u7bc7\u535a\u6587\u6765\u4ecb\u7ecd\u5206\u533a\u548c\u6876)\u3002<\/p>\n

                      \n1\u3001\u8868\uff1aHive\u4e2d\u7684\u8868\u548c\u5173\u7cfb\u578b\u6570\u636e\u5e93\u4e2d\u7684\u8868\u5728\u6982\u5ff5\u4e0a\u5f88\u7c7b\u4f3c\uff0c\u6bcf\u4e2a\u8868\u5728HDFS\u4e2d\u90fd\u6709\u76f8\u5e94\u7684\u76ee\u5f55\u7528\u6765\u5b58\u50a8\u8868\u7684\u6570\u636e\uff0c\u8fd9\u4e2a\u76ee\u5f55\u53ef\u4ee5\u901a\u8fc7${HIVE_HOME}\/conf\/hive-site.xml\u914d\u7f6e\u6587\u4ef6\u4e2d\u7684 hive.metastore.warehouse.dir\u5c5e\u6027\u6765\u914d\u7f6e\uff0c\u8fd9\u4e2a\u5c5e\u6027\u9ed8\u8ba4\u7684\u503c\u662f\/user\/hive\/warehouse(\u8fd9\u4e2a\u76ee\u5f55\u5728 HDFS\u4e0a)\uff0c\u6211\u4eec\u53ef\u4ee5\u6839\u636e\u5b9e\u9645\u7684\u60c5\u51b5\u6765\u4fee\u6539\u8fd9\u4e2a\u914d\u7f6e\u3002\u5982\u679c\u6211\u6709\u4e00\u4e2a\u8868wyp\uff0c\u90a3\u4e48\u5728HDFS\u4e2d\u4f1a\u521b\u5efa\/user\/hive\/warehouse\/wyp \u76ee\u5f55(\u8fd9\u91cc\u5047\u5b9ahive.metastore.warehouse.dir\u914d\u7f6e\u4e3a\/user\/hive\/warehouse);wyp\u8868\u6240\u6709\u7684\u6570\u636e\u90fd\u5b58\u653e\u5728\u8fd9\u4e2a\u76ee\u5f55\u4e2d\u3002\u8fd9\u4e2a\u4f8b\u5916\u662f\u5916\u90e8\u8868\u3002<\/p>\n

                      \n2\u3001\u5916\u90e8\u8868\uff1a\u5916\u90e8\u8868\u6307\u5411\u5df2\u7ecf\u5728HDFS\u4e2d\u5b58\u5728\u7684\u6570\u636e\uff0c\u53ef\u4ee5\u521b\u5efaPartition\u3002\u5b83\u548c\u5185\u90e8\u8868\u5728\u5143\u6570\u636e\u7684\u7ec4\u7ec7\u4e0a\u662f\u76f8\u540c\u7684\uff0c\u800c\u5b9e\u9645\u6570\u636e\u7684\u5b58\u50a8\u5219\u6709\u8f83\u5927\u7684\u5dee\u5f02\u3002\u5185\u90e8\u8868\u7684\u521b\u5efa\u8fc7\u7a0b\u548c\u6570\u636e\u52a0\u8f7d\u8fc7\u7a0b\u8fd9\u4e24\u4e2a\u8fc7\u7a0b\u53ef\u4ee5\u5206\u522b\u72ec\u7acb\u5b8c\u6210\uff0c\u4e5f\u53ef\u4ee5\u5728\u540c\u4e00\u4e2a\u8bed\u53e5\u4e2d\u5b8c\u6210\uff0c\u5728\u52a0\u8f7d\u6570\u636e\u7684\u8fc7\u7a0b\u4e2d\uff0c\u5b9e\u9645\u6570\u636e\u4f1a\u88ab\u79fb\u52a8\u5230\u6570\u636e\u4ed3\u5e93\u76ee\u5f55\u4e2d\uff1b\u4e4b\u540e\u5bf9\u6570\u636e\u5bf9\u8bbf\u95ee\u5c06\u4f1a\u76f4\u63a5\u5728\u6570\u636e\u4ed3\u5e93\u76ee\u5f55\u4e2d\u5b8c\u6210\u3002\u5220\u9664\u8868\u65f6\uff0c\u8868\u4e2d\u7684\u6570\u636e\u548c\u5143\u6570\u636e\u5c06\u4f1a\u88ab\u540c\u65f6\u5220\u9664\u3002\u800c\u5916\u90e8\u8868\u53ea\u6709\u4e00\u4e2a\u8fc7\u7a0b\uff0c\u52a0\u8f7d\u6570\u636e\u548c\u521b\u5efa\u8868\u540c\u65f6\u5b8c\u6210\uff08CREATE EXTERNAL TABLE \u2026\u2026LOCATION\uff09\uff0c\u5b9e\u9645\u6570\u636e\u662f\u5b58\u50a8\u5728LOCATION\u540e\u9762\u6307\u5b9a\u7684\n HDFS \u8def\u5f84\u4e2d\uff0c\u5e76\u4e0d\u4f1a\u79fb\u52a8\u5230\u6570\u636e\u4ed3\u5e93\u76ee\u5f55\u4e2d\u3002\u5f53\u5220\u9664\u4e00\u4e2aExternal Table\u65f6\uff0c\u4ec5\u5220\u9664\u8be5\u94fe\u63a5\u3002<\/p>\n

                      \n3\u3001\u5206\u533a\uff1a\u5728Hive\u4e2d\uff0c\u8868\u7684\u6bcf\u4e00\u4e2a\u5206\u533a\u5bf9\u5e94\u8868\u4e0b\u7684\u76f8\u5e94\u76ee\u5f55\uff0c\u6240\u6709\u5206\u533a\u7684\u6570\u636e\u90fd\u662f\u5b58\u50a8\u5728\u5bf9\u5e94\u7684\u76ee\u5f55\u4e2d\u3002\u6bd4\u5982wyp \u8868\u6709dt\u548ccity\u4e24\u4e2a\u5206\u533a\uff0c\u5219\u5bf9\u5e94dt=20131218,city=BJ\u5bf9\u5e94\u8868\u7684\u76ee\u5f55\u4e3a\/user\/hive\/warehouse \/dt=20131218\/city=BJ\uff0c\u6240\u6709\u5c5e\u4e8e\u8fd9\u4e2a\u5206\u533a\u7684\u6570\u636e\u90fd\u5b58\u653e\u5728\u8fd9\u4e2a\u76ee\u5f55\u4e2d\u3002<\/p>\n

                      \n4\u3001\u6876\uff1a\u5bf9\u6307\u5b9a\u7684\u5217\u8ba1\u7b97\u5176hash\uff0c\u6839\u636ehash\u503c\u5207\u5206\u6570\u636e\uff0c\u76ee\u7684\u662f\u4e3a\u4e86\u5e76\u884c\uff0c\u6bcf\u4e00\u4e2a\u6876\u5bf9\u5e94\u4e00\u4e2a\u6587\u4ef6(\u6ce8\u610f\u548c\u5206\u533a\u7684\u533a\u522b)\u3002\u6bd4\u5982\u5c06wyp\u8868id\u5217\u5206\u6563\u81f316\u4e2a\u6876\u4e2d\uff0c\u9996\u5148\u5bf9id\u5217\u7684\u503c\u8ba1\u7b97hash\uff0c\u5bf9\u5e94hash\u503c\u4e3a0\u548c16\u7684\u6570\u636e\u5b58\u50a8\u7684HDFS\u76ee\u5f55\u4e3a\uff1a\/user \/hive\/warehouse\/wyp\/part-00000;\u800chash\u503c\u4e3a2\u7684\u6570\u636e\u5b58\u50a8\u7684HDFS \u76ee\u5f55\u4e3a\uff1a\/user\/hive\/warehouse\/wyp\/part-00002\u3002\u5982\u679c\u60f3\u5e94\u7528\u5f88\u591a\u7684Map\u4efb\u52a1\u8fd9\u6837\u662f\u4e0d\u9519\u7684\u9009\u62e9\u3002
                      Hive\u6570\u636e\u62bd\u8c61\u7ed3\u6784\u56fe<\/a><\/p>\n

                      \n<\/div>\n

                      \n3. \u4f7f\u7528Hive\u5206\u6790\u641c\u7d22\u6570\u636e<\/h3>\n

                      \n\u53c2\u8003\uff1a
                      http:\/\/lqding.blog.51cto.com\/9123978\/1751030<\/a><\/p>\n

                      \n\u542f\u52a8HDFS\/Yarn\u3002\u6ce8\u610f\u5982\u679c\u8981\u4f7f\u7528Hive\u8fdb\u884c\u67e5\u8be2\u5c31\u9700\u8981\u542f\u52a8Yarn\u3002
                      \n\u542f\u52a8Hive\u3002
                      \n\u901a\u8fc7show databases;\u53ef\u4ee5\u67e5\u770b\u6570\u636e\u5e93\u3002\u9ed8\u8ba4database\u53ea\u6709default\u3002
                      \n\u9009\u53d6\u641c\u72d7\u5b9e\u9a8c\u7684\u4e09\u4e2a\u6570\u636e\u6e90\uff1a
                      http:\/\/download.labs.sogou.com\/dl\/q.html<\/a><\/p>\n

                      \n<\/div>\n
                      <\/pre>
                      1. hadoop dfs <\/span>-<\/span>mkdir <\/span>\/<\/span>library<\/span>\/<\/span>sogou<\/span><\/code><\/li>
                      2. hadoop dfs <\/span>-<\/span>put <\/span>.\/<\/span>SogouQ1<\/span>.<\/span>txt <\/span>\/<\/span>library<\/span>\/<\/span>sogou<\/span><\/code><\/li>
                      3. hadoop dfs <\/span>-<\/span>put <\/span>.\/<\/span>SogouQ2<\/span>.<\/span>txt <\/span>\/<\/span>library<\/span>\/<\/span>sogou<\/span><\/code><\/li>
                      4. hadoop dfs <\/span>-<\/span>put <\/span>.\/<\/span>SogouQ3<\/span>.<\/span>txt <\/span>\/<\/span>library<\/span>\/<\/span>sogou<\/span><\/code><\/li><\/ol>\n
                        \n<\/div>\n
                        <\/pre>
                        1. create table <\/span>SogouQ3<\/span>(<\/span>ID STRING<\/span>,<\/span> WEBSESSION STRING<\/span>,<\/span> WORD STRING<\/span>,<\/span> S_SEQ INT<\/span>,<\/span> C_SEQ INT<\/span>,<\/span> WEBSITE STRING<\/span>)<\/span> ROW FORMAT DELIMITED FIELDS TERMINATED BY <\/span>'\\t'<\/span> LINES TERMINATED BY <\/span>'\\n'<\/span>;<\/span> <\/span>\/\/\u5efa\u8868<\/span><\/code><\/li>
                        2. LOAD DATA INPATH <\/span>'\/library\/sogou\/SogouQ3.txt'<\/span> OVERWRITE INTO TABLE <\/span>SogouQ3<\/span>;<\/span> <\/span>\/\/\u52a0\u8f7d\u6570\u636e<\/span><\/code><\/li><\/ol>\n

                          \n\u67e5\u8be2\u641c\u7d22\u6392\u540d\u7b2c\u4e00\uff0c\u70b9\u51fb\u6392\u540d\u4e3a\u7b2c\u4e00\u7684\u7ed3\u679c\uff1a
                          \nselect count(*) from sogouq1 where S_SEQ=1 and C_SEQ=1;<\/p>\n

                          \n\u641c\u7d22\u65e5\u5fd7\u4e2d\uff0c\u5173\u6ce8\u6392\u540d\u524d\u4e94\u7684\u5185\u5bb9\uff0c\u5e76\u4e14\u7ed9\u51fa\u5206\u522b\u4e3a\u591a\u5c11\u6b21\uff1a
                          \nselect WORD, count(WORD) as COUNTWord from SogouQ1 group by WORD order by COUNTWord desc limit 5<\/p>\n

                          \n<\/div>\n

                          \n\u67e5\u8be2\u4f8b\u5b50mysql<\/h2>\n

                          \nmysql -u root -p<\/p>\n

                          \n<\/div>\n
                          <\/pre>
                          1. creeate database hive<\/span>;<\/span><\/code><\/li>
                          2. use<\/span> hive<\/span>;<\/span><\/code><\/li>
                          3. <\/code><\/li>
                          4. create table person<\/span>(<\/span>name <\/span>String<\/span>,<\/span>age <\/span>int<\/span>);<\/span><\/code><\/li>
                          5. <\/code><\/li>
                          6. insert <\/span>into<\/span> person values<\/span>(\u2018<\/span>richard<\/span>\u2019,\u2019<\/span>34<\/span>\u2019);<\/span><\/code><\/li>
                          7. <\/code><\/li>
                          8. select<\/span> <\/span>*<\/span> <\/span>from<\/span> person<\/span>;\u5373\u53ef\u67e5\u8be2\u3002<\/span><\/code><\/li><\/ol>\n

                            \n\u5230\u6b64\u4e0d\u9700\u8981\u542f\u52a8spark\uff0c\u53ea\u9700\u8981\u542f\u52a8HDFS\u3002<\/p>\n

                            \n<\/div>\n

                            \n4. Spark SQL on Hive\u914d\u7f6e\u53ca\u5b9e\u6218<\/h3>\n
                            \n<\/div>\n

                            \n1\uff09spark on hive \u914d\u7f6e<\/h4>\n
                            1. \u5207\u6362\u5230spar\u7684conf\u76ee\u5f55\u4e0b\u4f7f\u7528vi hive-site.xml\u521b\u5efahive-site.xml.\u5e76\u586b\u5199\u5982\u4e0b\u5185\u5bb9<\/li><\/ol>
                              \n<\/div>\n
                              <\/pre>
                              1. <configuration><\/span><\/code><\/li>
                              2. <property><\/span><\/code><\/li>
                              3. <name><\/span>hive.metastore.uris<\/span><\/name><\/span><\/code><\/li>
                              4. <value><\/span>thrift:\/\/master:9083<\/span><\/value><\/span><\/code><\/li>
                              5. <description><\/span>thrift URI for the remote metastore.Used by metastore client to connect to remote metastore. <\/span><\/description><\/span><\/code><\/li>
                              6. <\/property><\/span><\/code><\/li>
                              7. <\/configuration><\/span><\/code><\/li><\/ol>\n

                                \n\u56e0\u4e3a\u7528sparksql\u64cd\u4f5chive\u5b9e\u9645\u4e0a\u662f\u628ahive \u5f53\u505a\u6570\u636e\u4ed3\u5e93\u3002\u6570\u636e\u4ed3\u5e93\u80af\u5b9a\u6709\u5143\u6570\u636e\u548c\u6570\u636e\u672c\u8eab\u3002\u8981\u8bbf\u95ee\u771f\u6b63\u7684\u6570\u636e\u5c31\u8981\u8bbf\u95ee\u4ed6\u7684\u5143\u6570\u636e\u3002\u6240\u4ee5\u53ea\u9700\u8981\u914d\u7f6ehive.metastore.uris\u5373\u53ef\u3002\uff08\u4e0d\u9700\u5728\u6bcf\u53f0\u673a\u5668\u4e0a\u914d\u7f6e\uff09<\/p>\n

                                \n<\/div>\n

                                \n2\uff09\u542f\u52a8\u96c6\u7fa4<\/h4>\n
                                1. \u542f\u52a8dfs \u670d\u52a1start-dfs.sh<\/li>
                                2. \u542f\u52a8hive \u6570\u636e\u4ed3\u5e93\u670d\u52a1 hive --service metastore >metastore.log 2>& 1&<\/li>
                                3. \u542f\u52a8spark\u670d\u52a1start-all.sh<\/li>
                                4. \u542f\u52a8sparkshell .\/spark-shell \u2013master spark:\/\/master:7077<\/li><\/ol>
                                  \n<\/div>\n

                                  \n3\uff09\u6848\u4f8b\u5b9e\u6218<\/h4>\n
                                  1. Spark on hive \u5b9e\u6218\u5728spark-shell \u6a21\u5f0f\u4e0b<\/li><\/ol>
                                    \n<\/div>\n
                                    <\/pre>
                                    1. val hiveContext<\/span>=<\/span> <\/span>new<\/span> org<\/span>.<\/span>apache<\/span>.<\/span>spark<\/span>.<\/span>sql<\/span>.<\/span>hive<\/span>.<\/span>HiveContext<\/span>(<\/span>sc<\/span>)<\/span><\/code><\/li>
                                    2. hiveContext<\/span>.<\/span>sql<\/span>(<\/span>\"use hive\"<\/span>)<\/span> <\/span>\/\/\u4f7f\u7528hive \u6570\u636e\u5e93<\/span><\/code><\/li>
                                    3. hiveContext<\/span>.<\/span>sql<\/span>(<\/span>\"show tables\"<\/span>).<\/span>collect<\/span>.<\/span>foreach<\/span>(<\/span>println<\/span>)<\/span> <\/span>\/\/ \u67e5\u8be2\u6570\u636e\u5e93\u4e2d\u7684\u8868<\/span><\/code><\/li>
                                    4. hiveContext<\/span>.<\/span>sql<\/span>(<\/span>\"select count(*) from sogouq1\"<\/span>).<\/span>collect<\/span>.<\/span>foreach<\/span>(<\/span>println<\/span>)<\/span>\/\/(\u6ce8\u610f\u6b64\u65f6\u4f7f\u7528\u7684\u662fspark\u7684\u5f15\u64ce)<\/span><\/code><\/li>
                                    5. hiveContext<\/span>.<\/span>sql<\/span>(\u201c<\/span>select<\/span> count<\/span>(*)<\/span> <\/span>from<\/span> sogouq2 <\/span>where<\/span> website like <\/span>'%baidu%'<\/span>\u201d).<\/span>collect<\/span>.<\/span>foreach<\/span>(<\/span>println<\/span>)<\/span><\/code><\/li>
                                    6. <\/code><\/li>
                                    7. hiveContext<\/span>.<\/span>sql<\/span>(\u201c<\/span>select<\/span> count<\/span>(*)<\/span> <\/span>from<\/span> sogouq2 <\/span>where<\/span> s_seq<\/span>=<\/span>1<\/span> <\/span>and<\/span> c_seq<\/span>=<\/span>1<\/span> <\/span>and<\/span> website like <\/span>'%baidu%'<\/span>\u201d).<\/span>collect<\/span>.<\/span>foreach<\/span>(<\/span>println<\/span>)<\/span><\/code><\/li><\/ol>\n
                                      1. \u4e0d\u57fa\u4e8ehive \u7684\u5b9e\u6218\u4ee3\u7801\uff0c\u5728spark-shell \u6a21\u5f0f\u4e0b<\/li><\/ol>
                                        \n<\/div>\n
                                        <\/pre>
                                        1. scala<\/span>><\/span> sqlContext<\/span><\/code><\/li>
                                        2. res8<\/span>:<\/span> org<\/span>.<\/span>apache<\/span>.<\/span>spark<\/span>.<\/span>sql<\/span>.<\/span>SQLContext<\/span> <\/span>=<\/span> org<\/span>.<\/span>apache<\/span>.<\/span>spark<\/span>.<\/span>sql<\/span>.<\/span>hive<\/span>.<\/span>HiveContext@35920655<\/span>\uff08\u53ef\u4ee5\u521b\u5efa\u5f88\u591a<\/span>hiveContext<\/span>\uff0c<\/span>hivecongtext<\/span>\u8fde\u63a5\u7684\u662f\u6570\u636e\u4ed3\u5e93\uff0c\u7a0b\u5e8f\u672c\u8eab\uff08<\/span>spark<\/span>\u4e2d\u7684<\/span>job<\/span>\uff09\uff0c<\/span>job<\/span>\u5728\u7a0b\u5e8f\u4e2d\u5e76\u884c\u8fd0\u884c\uff0c\u5982\u679c\u90fd<\/span>hive<\/span>\u7684\u6570\u636e\uff0c\u5982\u679c\u7528\u53e5\u67c4\uff0c\u5bf9\u53e5\u67c4\u7684\u5360\u7528\u6bd4\u8f83\u9ebb\u70e6\uff0c\u6240\u6709\u7528\u591a\u4e2a\u5b9e\u4f8b\u3002\u4ece\u67e5\u8be2\u7684\u89d2\u5ea6\u6765\u8bf4\uff0c\u6709\u591a\u4e2a\u5b9e\u4f8b\u4e5f\u5f88\u6b63\u5e38\uff09<\/span><\/code><\/li>
                                        3. <\/code><\/li>
                                        4. val df <\/span>=<\/span>sqlcontext<\/span>.<\/span>read<\/span>.<\/span>json<\/span>(\u201c<\/span>library<\/span>\/<\/span>examples<\/span>\/<\/span>src<\/span>\/<\/span>main<\/span>\/<\/span>resources<\/span>\/<\/span>people<\/span>.<\/span>json<\/span>\u201d)<\/span> <\/span>\/\/\u8bfb\u53d6json \u6570\u636e<\/span><\/code><\/li>
                                        5. df<\/span>.<\/span>show<\/span>()<\/span><\/code><\/li>
                                        6. df<\/span>.<\/span>printSchema<\/span><\/code><\/li>
                                        7. df<\/span>.<\/span>select<\/span>(\u201c<\/span>name<\/span>\u201d).<\/span>show<\/span>()<\/span><\/code><\/li>
                                        8. df<\/span>.<\/span>select<\/span>(<\/span>df<\/span>(\u201c<\/span>name<\/span>\u201d),<\/span>df<\/span>(\u201c<\/span>age<\/span>\u201d)+<\/span>1<\/span>).<\/span>show<\/span>()<\/span><\/code><\/li><\/ol>\n <\/div>\n <\/div>","orderid":"0","title":"spark on hive\u539f\u7406\u4e0e\u73af\u5883\u642d\u5efa   spark\u7814\u4e60\u7b2c\u4e09\u5b63","smalltitle":"","mid":"0","fname":"Hive","special_id":"0","bak_id":"0","info":"0","hits":"482","pages":"1","comments":"0","posttime":"2019-05-16 00:58:04","list":"1557939484","username":"admin","author":"","copyfrom":"","copyfromurl":"","titlecolor":"","fonttype":"0","titleicon":"0","picurl":"http:\/\/ww4.sinaimg.cn\/large\/b79117d3gw1f1vkr2sce2j208x05gdgb.jpg","ispic":"1","yz":"1","yzer":"","yztime":"0","levels":"0","levelstime":"0","keywords":"spark<\/A> hive<\/A> \u539f\u7406<\/A> \u73af\u5883<\/A> \u642d\u5efa<\/A>  <\/A> \u7814\u4e60<\/A> \u7b2c\u4e09<\/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":" \u7248\u6743\u58f0\u660e\uff1a\u672c\u6587\u4e3a\u535a\u4e3b\u539f\u521b\u6587\u7ae0\uff0c\u672a\u7ecf\u535a\u4e3b\u5141\u8bb8\u4e0d\u5f97\u8f6c\u8f7d\u3002 https:\/\/blog.csdn.net\/refuil\/article\/details\/52327632 ..","lastview":"1719085493","digg_num":"0","digg_time":"0","forbidcomment":"0","ifvote":"0","heart":"","htmlname":"","city_id":"0"},"page":"1"}

            \nhttp:\/\/www.aboutyun.com\/thread-11131-1-1.html<\/a><\/p>\n