实战大数据项目 - wpsshop博客

查看

编辑修改

首页
UNITY
NODEJS
PYTHON
AI
GIT
PHP
GO
CEF3
JAVA
HTML
CSS

Gausst松鼠会

这个屌丝很懒，什么也没留下！

热门标签

jquery
HTML
CSS
PHP
ASP
PYTHON
GO
AI
C
C++
C#
PHOTOSHOP
UNITY
iOS
android
vue
xml
爬虫
SEO
LINUX
WINDOWS
JAVA
MFC
CEF3
CAD
NODEJS
GIT
Pyppeteer
article

热门文章

1手把手系列！使用 Zilliz Cloud 和 AWS Bedrock 搭建 RAG 应用
2kafka-消费者组-点对点测试
3华为OD机试 - 生成哈夫曼树（Java & JS & Python & C & C++）_生成哈夫曼树华为od
4计算机专业近几年的参考文献,近几年计算机专业发参考文献计算机专业发专著类参考文献哪里找...
5人工智能轨道交通行业周刊-第29期（2023.1.2-1.8）_昆明南站小红车机器人
6清览云题库--数据可视化
7消息队列:RabbitMQ_消息队列rabbitmq
8小华最多能得到多少克黄金【华为OD机试】(JAVA&Python&C++&JS题解)_小华按照地图去寻宝
9Makefile入门_makefile学习
10html标签“”中文本对齐实现，让人蛋疼的知识_html textarea跟前两行数据对齐</a></li></ul></div></div></div><link rel="stylesheet" href="https://cdn.wpsshop.cn/public/blog/css/mid_detail.css?v=890" type="text/css"><link rel="stylesheet" href="https://cdn.wpsshop.cn/public/blog/css/mid_clk.css?v=890" type="text/css"><script type="text/javascript" src="https://cdn.wpsshop.cn/public/blog/js/mid_.js?v=890"></script><link rel="stylesheet" href="https://cdn.wpsshop.cn/public/study/js/j/vs.css?v=890" type="text/css"><script type="text/javascript" src="https://cdn.wpsshop.cn/public/study/js/j/highlight.pack.js?v=890" ></script><link rel="stylesheet" href="https://cdn.wpsshop.cn/public/blog/css/index_contenthljs.css?v=890" type="text/css"><script type="text/javascript" src="https://cdn.wpsshop.cn/public/wpsshopindex/js/detail01tj.js?v=531890" ></script><link rel="stylesheet" href="https://cdn.wpsshop.cn/public/wpsshopindex/css/mid_detail_last.css?v=3890" type="text/css"><script type="text/javascript" src="https://cdn.wpsshop.cn/public/wpsshopindex/js/mid_detail_last.js?v=33890"></script><style type="text/css"></style><script type="text/javascript"></script><div class="interactive_info" id="body-data-0098" attrv="50718"></div><div class="article_box" style="overflow: hidden;"><div class="article_channel"><div class="channel_top_line"><div class="cn_t_l"></div><div class="cn_t_r"></div></div><div class="article_channel_info">当前位置: <a href="/article/list/1">article</a> > 正文 </div></div><div class="article_title"><h1>实战大数据项目</h1></div><div class="article_info"><div class="article_c_info"> 作者：Gausst松鼠会 | 2024-05-31 06:01:01</div><div class="article_click" style="width: 140px;"><p class="operation-b-img operation-b-img-active"><i class="img-up txclick" attc="upclick" attn="0"></i><span class="num"> 赞</span></p><p class="operation-b-img operation-b-img-active"><i class="img-down txclick" attc="downclick" attn="0"></i><span class="num">踩</span></p></div></div><div class="article_intro">大数据项目</div><div class="article_content article_contentheight"> <link rel="stylesheet" href="https://csdnimg.cn/release/blogv2/dist/mdeditor/css/editerView/kdoc_html_views-1a98987dfd.css"> <link rel="stylesheet" href="https://csdnimg.cn/release/blogv2/dist/mdeditor/css/editerView/ck_htmledit_views-044f2cf1dc.css"> <div id="content_views" class="htmledit_views"> <p>存储日志数据集（<a href="https://so.csdn.net/so/search?q=HDFS&spm=1001.2101.3001.7020" target="_blank" class="hl hl-1" data-report-click="{"spm":"1001.2101.3001.7020","dest":"https://so.csdn.net/so/search?q=HDFS&spm=1001.2101.3001.7020","extra":"{\"searchword\":\"HDFS\"}"}" data-tit="HDFS" data-pretit="hdfs">HDFS</a>）</p> <p><a href="https://so.csdn.net/so/search?q=%E6%95%B0%E6%8D%AE%E4%BB%93%E5%BA%93&spm=1001.2101.3001.7020" target="_blank" class="hl hl-1" data-report-click="{"spm":"1001.2101.3001.7020","dest":"https://so.csdn.net/so/search?q=%E6%95%B0%E6%8D%AE%E4%BB%93%E5%BA%93&spm=1001.2101.3001.7020","extra":"{\"searchword\":\"数据仓库\"}"}" data-tit="数据仓库" data-pretit="数据仓库">数据仓库</a>构建（Hive）</p> <p>数据分区表构建</p> <p>数据预处理（Spark计算引擎）-使用Zeppelin进行写SQL</p> <p>订单指标分析</p> <p>Sqoop数据导出到传统数据库（Mysql）</p> <p>Superset数据可视化</p> <p>项目架构</p> <p>架构方案：</p> <p>1、基于Hadoop的HDFS（数据存储）文件系统来存储数据</p> <p>2、为了方便进行数据分析，将这些日志文件的数据映射为一张一张的表，所以，我们基于<a href="https://so.csdn.net/so/search?q=Hive&spm=1001.2101.3001.7020" target="_blank" class="hl hl-1" data-report-view="{"spm":"1001.2101.3001.7020","dest":"https://so.csdn.net/so/search?q=Hive&spm=1001.2101.3001.7020","extra":"{\"searchword\":\"Hive\"}"}" data-report-click="{"spm":"1001.2101.3001.7020","dest":"https://so.csdn.net/so/search?q=Hive&spm=1001.2101.3001.7020","extra":"{\"searchword\":\"Hive\"}"}" data-tit="Hive" data-pretit="hive">Hive</a>（数据仓库工具）来构建数据仓库，所有的数据，都会在Hive下进行管理，提高数据处理的性能。</p> <p>3、基于Spark（计算引擎）来进行数据开发，所有的应用程序都将运行在Spark集群上，这样可以保证数据被高性能的处理。</p> <p>4、使用Zeppelin（在Zeppelin写SQL效率高，直接在终端写效率低）来快速将数据进行SQL指令交互。</p> <p>5、使用Sqoop导出分析后的数据到传统型数据库（Mysql），便于后期应用</p> <p>6、使用Superset（数据可视化工具）来实现数据可视化展示</p> <p>架构图</p> <p><img alt="" height="516" src="https://img-blog.csdnimg.cn/be2b2978bd474ce495183c215d833e0e.png" width="991"></p> <h3><a name="t0"></a> 一、数据仓库构建-数仓分层</h3> <p>首先将日志数据上传到HDFS保存下来，每天都可以上传，HDFS可以保存海量的数据，然后使用Hive，将HDFS中的数据文件，对应到Hive的表中。但是一般情况下日志数据是不能够直接进行分析的。所以需要我们对日志文件的原始数据进行预处理，才能进行分析。</p> <p>我们会有这么几类数据考虑：</p> <p>1、原始日志数据（业务系统中保存的日志文件数据）</p> <p>2、预处理后的数据</p> <p>3、分析结果数据</p> <p>这些数据都通过Hive进行处理，因为Hive将数据映射为一张张的表，然后可以通过编写SQL来处理数据，简单、快捷、高效，为了区分以上这些数据，我们将这些数据对应的表分别保存在不同的数据库中。</p> <p>为了方便组织、管理上面的三类数据，我们将数仓分为不同的层，简单来说，就是分别将三类不同的数据保存在Hive的不同数据中。</p> <p><img alt="" height="310" src="https://img-blog.csdnimg.cn/aa2c3270240147eab07f302428d67ee5.png" width="749"></p> <p> 第一层临时存储层ODS，就是存储原始日志数据</p> <p>第二层数据仓库层DW，就是存储预处理后的数据，就是分析的数据</p> <p>第三层应用层APP。</p> <p>根据数仓架构的三层，创建三个数据库，分别用来管理每一层的表数据。</p> <pre data-index="0" class="set-code-show" name="code"><code class="hljs language-sql"><ol class="hljs-ln" style="width:100%"><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="1"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-comment">-- 创建ods库</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="2"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-keyword">create</span> database if <span class="hljs-keyword">not</span> <span class="hljs-keyword">exists</span> ods_d;</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="3"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-comment">-- 创建dw库</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="4"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-keyword">create</span> database if <span class="hljs-keyword">not</span> <span class="hljs-keyword">exists</span> dw_d;</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="5"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-comment">-- 创建app库</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="6"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-keyword">create</span> database if <span class="hljs-keyword">not</span> <span class="hljs-keyword">exists</span> app_d;</div></div></li></ol></code><div class="hljs-button signin active" data-title="登录复制" data-report-click="{"spm":"1001.2101.3001.4334"}" onclick="hljs.signin(event)"></div></pre> <h3><a name="t1"></a>二、数据分区表构建</h3> <p>1）、ods创建用户打车订单表</p> <p>根据用户打车订单数据，创建按照日期分区的表：</p> <p></p> <p>2）、ods创建取消订单表</p> <p>根据用户取消订单数据，创建按照日期分区的表</p> <p></p> <p>3）、ods创建订单表支付表</p> <p>根据用户订单支付数据，创建按照日期分区的表</p> <p></p> <p>4）、ods创建用户评价表</p> <p>根据用户评价数据，创建按照日期分区的表</p> <p></p> <p>5）、基于T+1的日期分区</p> <p>大规模数据处理，必须要构建分区，每天都会进行分析，采用的是T+1模式。今天数据，第二天才能看到分析结果。</p> <pre data-index="1" class="set-code-show" name="code"><code class="hljs language-cobol"><ol class="hljs-ln" style="width:875px"><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="1"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-number">1</span>、创建本地路径，上传日志文件</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="2"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">mkdir -p <span class="hljs-operator">/</span>export<span class="hljs-operator">/</span><span class="hljs-keyword">data</span><span class="hljs-operator">/</span><span class="hljs-keyword">test</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="3"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-number">2</span>、通过load命令给表加载数据，并指定分区</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="4"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">load <span class="hljs-keyword">data</span> local inpath <span class="hljs-string">'/export/data/test/order.csv'</span> <span class="hljs-keyword">into</span> <span class="hljs-keyword">table</span> t_user_<span class="hljs-keyword">order</span> partition(dt<span class="hljs-operator">=</span><span class="hljs-string">'2020-04-12'</span>);</div></div></li></ol></code><div class="hljs-button signin active" data-title="登录复制" data-report-click="{"spm":"1001.2101.3001.4334"}" onclick="hljs.signin(event)"></div></pre> <h3><a name="t2"></a>三、数据预处理</h3> <p>数据预处理-用户订单处理</p> <p>数据有了之后，需要对ods层中的数据进行预处理，数据预处理是数据仓库开发中的一个重要环节，主要目的是让预处理的数据更容易进行数据分析，并且能够将一些非法的数据处理掉，避免影响实际的统计结果。</p> <p>预处理内容：</p> <p>1、过滤掉order_time长度小于8的数据，如果小于8，表示这条数据不合法，不应该参加统计</p> <p>2、将一些0，1表示的字段，处理为更容易理解的字段，例如：subscribe字段，0表示非预约，1表示预约，我们需要添加一个额外的字段，用来展示非预约和预约，这样分析的时候，便于看懂数据。</p> <p>3、order_time字段为2020-4-12 1:15，为了将来更方便处理，统一使用类似2020-04-12 01:15来表示，这样所有的order_time字段长度是一样的，并且将日期获取出来。</p> <p>4、为了方便将来按照年、月、日，小时统计，我们需要新增这些字段。</p> <p>5、后续要分析一天内，不同时段的订单量，需要在预处理过程中将订单对应的时间段提前计算出来，例如：1:00-5:00为凌晨。</p> <p><strong>数据预处理-用户订单处理</strong></p> <p>1）、一天各个时段对应关系</p> <p>2）、dw层创建宽表（宽表含义，要比ods层的表字段多）</p> <p>在进行预处理之前，先把预处理之后保存数据的表创建出来。</p> <p>3）、建宽表语句</p> <pre data-index="2" class="set-code-show" name="code"><code class="hljs language-sql"><span class="hljs-keyword">create</span> <span class="hljs-keyword">table</span> if <span class="hljs-keyword">not</span> <span class="hljs-keyword">exists</span> dw_test_user_order_wide</code><div class="hljs-button signin active" data-title="登录复制" data-report-click="{"spm":"1001.2101.3001.4334"}" onclick="hljs.signin(event)"></div></pre> <p>4）、预处理SQL语句</p> <p>5）、HQL编好后，方便分析，需要将预处理的数据写入到之前创建的宽表中，注意：宽表也是一个分区表，所以，写入的时候要指定对应的分区。</p> <h4><a name="t3"></a>四、订单指标分析-总订单笔数分析</h4> <p>数据处理好后，进行分析</p> <p>1）、编写HQL语句</p> <pre data-index="3" class="set-code-show" name="code"><code class="hljs language-cobol"><ol class="hljs-ln" style="width:100%"><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="1"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">-- 计算<span class="hljs-number">4</span>月<span class="hljs-number">12</span>日总订单笔数</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="2"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-keyword">select</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="3"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> <span class="hljs-keyword">count</span>(orderid) <span class="hljs-keyword">as</span> total_cnt </div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="4"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-keyword">from</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="5"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> dw_didi.t_user_<span class="hljs-keyword">order</span>_wide </div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="6"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">where </div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="7"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> dt <span class="hljs-operator">=</span> <span class="hljs-string"><span class="hljs-string">'2020-04-12’</span></span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="8"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-string"> ;</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="9"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-string"></span></div></div></li></ol></code><div class="hljs-button signin active" data-title="登录复制" data-report-click="{"spm":"1001.2101.3001.4334"}" onclick="hljs.signin(event)"></div></pre> <p>订单指标分析-总订单笔数分析</p> <p>2）、app层建表</p> <p>数据分析后，每次都要处理大规模数据，每次处理都需要占用较长时间，所以，我们可以将计算好的数据，直接保存下来。将来，可以快速查询数据结果，所以需要在app层创建表，保存的数据为某天的总订单数，保存一下几个字段：</p> <p>1、时间（哪天的订单总数）</p> <p>2、订单总数</p> <pre data-index="4" class="set-code-show" name="code"><code class="hljs language-cobol"><ol class="hljs-ln" style="width:100%"><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="1"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">-- 创建保存日期对应订单笔数的app表</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="2"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">create <span class="hljs-keyword">table</span> <span class="hljs-keyword">if</span> <span class="hljs-keyword">not</span> exists app_didi.t_<span class="hljs-keyword">order</span>_total(</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="3"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> <span class="hljs-keyword">date</span> <span class="hljs-keyword">string</span> comment <span class="hljs-string">'日期（年月日)'</span>,</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="4"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> <span class="hljs-keyword">count</span> integer comment <span class="hljs-string">'订单笔数'</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="5"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">)</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="6"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">partitioned <span class="hljs-keyword">by</span> (month <span class="hljs-keyword">string</span> comment <span class="hljs-string">'年月，yyyy-MM'</span>)</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="7"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">row <span class="hljs-keyword">format</span> <span class="hljs-keyword">delimited</span> fields terminated <span class="hljs-keyword">by</span> <span class="hljs-string">','</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="8"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">;</div></div></li></ol></code><div class="hljs-button signin active" data-title="登录复制" data-report-click="{"spm":"1001.2101.3001.4334"}" onclick="hljs.signin(event)"></div></pre> <h4><a name="t4"></a></h4> <p>3）、加载数据到app层，</p> <p>此处因为结果的数据不会很多，所以只需要基于年月来分区</p> <pre data-index="5" class="set-code-show" name="code"><code class="hljs language-cobol"><ol class="hljs-ln" style="width:100%"><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="1"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">insert overwrite <span class="hljs-keyword">table</span> app_didi.t_<span class="hljs-keyword">order</span>_total partition(month<span class="hljs-operator">=</span><span class="hljs-string">'2020-04'</span>)</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="2"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-keyword">select</span> </div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="3"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> <span class="hljs-string">'2020-04-12'</span>,<span class="hljs-keyword">count</span>(orderid) <span class="hljs-keyword">as</span> total_cnt</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="4"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-keyword">From</span> dw_didi.t_user_<span class="hljs-keyword">order</span>_wide</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="5"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">Where dt <span class="hljs-operator">=</span> <span class="hljs-string">'2020-04-12'</span>;</div></div></li></ol></code><div class="hljs-button signin active" data-title="登录复制" data-report-click="{"spm":"1001.2101.3001.4334"}" onclick="hljs.signin(event)"></div></pre> <h4><a name="t5"></a></h4> <p>查询的结果，后面就可以做为可视化使用。</p> <p></p> <p><strong>订单指标分析-预约订单/非预约订单占比分析</strong></p> <h4><a name="t6"></a></h4> <p>数据处理好后，就可以进行分析了。</p> <p>1、编写HQL语句</p> <pre data-index="6" class="set-code-show" name="code"><code class="hljs language-cobol"><ol class="hljs-ln" style="width:100%"><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="1"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-keyword">select</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="2"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> subscribe_name,</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="3"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> <span class="hljs-keyword">count</span>(<span class="hljs-operator">*</span>) <span class="hljs-keyword">as</span> <span class="hljs-keyword">order</span>_cnt</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="4"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-keyword">from</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="5"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> dw_didi.t_user_<span class="hljs-keyword">order</span>_wide</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="6"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">where</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="7"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> dt <span class="hljs-operator">=</span> <span class="hljs-string">'2020-04-12'</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="8"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-keyword">group</span> <span class="hljs-keyword">by</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="9"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> subscribe_name</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="10"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">;</div></div></li></ol></code><div class="hljs-button signin active" data-title="登录复制" data-report-click="{"spm":"1001.2101.3001.4334"}" onclick="hljs.signin(event)"></div></pre> <p>2、app层建表</p> <p>包含几个字段：</p> <p>日期、是否预约、订单数量</p> <pre data-index="7" class="set-code-show" name="code"><code class="hljs language-cobol"><ol class="hljs-ln" style="width:100%"><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="1"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">create <span class="hljs-keyword">table</span> <span class="hljs-keyword">if</span> <span class="hljs-keyword">not</span> exists app_didi.t_<span class="hljs-keyword">order</span>_subscribe_total(</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="2"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> <span class="hljs-keyword">date</span> <span class="hljs-keyword">string</span> comment <span class="hljs-string">'日期'</span>,</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="3"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> subscribe_name <span class="hljs-keyword">string</span> comment <span class="hljs-string">'是否预约'</span>,</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="4"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> <span class="hljs-keyword">count</span> integer comment <span class="hljs-string">'订单数量'</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="5"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">)</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="6"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">partitioned <span class="hljs-keyword">by</span> (month <span class="hljs-keyword">string</span> comment <span class="hljs-string">'年月，yyyy-MM'</span>)</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="7"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">row <span class="hljs-keyword">format</span> <span class="hljs-keyword">delimited</span> fields terminated <span class="hljs-keyword">by</span> <span class="hljs-string">','</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="8"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">;</div></div></li></ol></code><div class="hljs-button signin active" data-title="登录复制" data-report-click="{"spm":"1001.2101.3001.4334"}" onclick="hljs.signin(event)"></div></pre> <p>3、加载数据到app表</p> <pre data-index="8" class="set-code-show" name="code"><code class="hljs language-cobol"><ol class="hljs-ln" style="width:721px"><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="1"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">insert overwrite <span class="hljs-keyword">table</span> app_didi.t_<span class="hljs-keyword">order</span>_subscribe_total partition(month <span class="hljs-operator">=</span> <span class="hljs-string">'2020-04'</span>)</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="2"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-keyword">select</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="3"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> <span class="hljs-string">'2020-04-12'</span>,</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="4"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> subscribe_name,</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="5"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> <span class="hljs-keyword">count</span>(<span class="hljs-operator">*</span>) <span class="hljs-keyword">as</span> <span class="hljs-keyword">order</span>_cnt</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="6"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-keyword">from</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="7"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> dw_didi.t_user_<span class="hljs-keyword">order</span>_wide</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="8"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">where</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="9"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> dt <span class="hljs-operator">=</span> <span class="hljs-string">'2020-04-12'</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="10"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-keyword">group</span> <span class="hljs-keyword">by</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="11"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> subscribe_name</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="12"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">;</div></div></li></ol></code><div class="hljs-button signin active" data-title="登录复制" data-report-click="{"spm":"1001.2101.3001.4334"}" onclick="hljs.signin(event)"></div></pre> <h4><a name="t7"></a>订单指标分析-不同时段订单占比分析</h4> <p>1）、编写HQL语句</p> <pre data-index="9" class="set-code-show" name="code"><code class="hljs language-cobol"><ol class="hljs-ln" style="width:100%"><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="1"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-keyword">select</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="2"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> <span class="hljs-keyword">order</span>_<span class="hljs-keyword">time</span>_range,</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="3"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> <span class="hljs-keyword">count</span>(<span class="hljs-operator">*</span>) <span class="hljs-keyword">as</span> <span class="hljs-keyword">order</span>_cnt</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="4"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-keyword">from</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="5"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> dw_didi.t_user_<span class="hljs-keyword">order</span>_wide</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="6"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">where</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="7"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> dt <span class="hljs-operator">=</span> <span class="hljs-string">'2020-04-12'</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="8"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-keyword">group</span> <span class="hljs-keyword">by</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="9"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> <span class="hljs-keyword">order</span>_<span class="hljs-keyword">time</span>_range</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="10"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">;</div></div></li></ol></code><div class="hljs-button signin active" data-title="登录复制" data-report-click="{"spm":"1001.2101.3001.4334"}" onclick="hljs.signin(event)"></div></pre> <p>2）、app层建表</p> <pre data-index="10" class="set-code-show" name="code"><code class="hljs language-cobol"><ol class="hljs-ln" style="width:100%"><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="1"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">create <span class="hljs-keyword">table</span> <span class="hljs-keyword">if</span> <span class="hljs-keyword">not</span> exists app_didi.t_<span class="hljs-keyword">order</span>_timerange_total(</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="2"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> <span class="hljs-keyword">date</span> <span class="hljs-keyword">string</span> comment <span class="hljs-string">'日期'</span>,</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="3"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> timerange <span class="hljs-keyword">string</span> comment <span class="hljs-string">'时间段'</span>,</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="4"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> <span class="hljs-keyword">count</span> integer comment <span class="hljs-string">'订单数量'</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="5"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">)</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="6"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">partitioned <span class="hljs-keyword">by</span> (month <span class="hljs-keyword">string</span> comment <span class="hljs-string">'年月，yyyy-MM'</span>)</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="7"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">row <span class="hljs-keyword">format</span> <span class="hljs-keyword">delimited</span> fields terminated <span class="hljs-keyword">by</span> <span class="hljs-string">','</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="8"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">;</div></div></li></ol></code><div class="hljs-button signin active" data-title="登录复制" data-report-click="{"spm":"1001.2101.3001.4334"}" onclick="hljs.signin(event)"></div></pre> <h4><a name="t8"></a></h4> <p>3）、加载数据到app表</p> <pre data-index="11" class="set-code-show" name="code"><code class="hljs language-cobol"><ol class="hljs-ln" style="width:721px"><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="1"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">insert overwrite <span class="hljs-keyword">table</span> app_didi.t_<span class="hljs-keyword">order</span>_timerange_total partition(month <span class="hljs-operator">=</span> <span class="hljs-string">'2020-04'</span>)</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="2"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-keyword">select</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="3"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> <span class="hljs-string">'2020-04-12'</span>,</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="4"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> <span class="hljs-keyword">order</span>_<span class="hljs-keyword">time</span>_range,</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="5"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> <span class="hljs-keyword">count</span>(<span class="hljs-operator">*</span>) <span class="hljs-keyword">as</span> <span class="hljs-keyword">order</span>_cnt</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="6"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-keyword">from</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="7"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> dw_didi.t_user_<span class="hljs-keyword">order</span>_wide</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="8"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">where</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="9"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> dt <span class="hljs-operator">=</span> <span class="hljs-string">'2020-04-12'</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="10"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-keyword">group</span> <span class="hljs-keyword">by</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="11"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> <span class="hljs-keyword">order</span>_<span class="hljs-keyword">time</span>_range</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="12"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">;</div></div></li></ol></code><div class="hljs-button signin active" data-title="登录复制" data-report-click="{"spm":"1001.2101.3001.4334"}" onclick="hljs.signin(event)"></div></pre> <h4><a name="t9"></a>订单指标分析-不同地域订单对比</h4> <p>1）、编写HQL语句</p> <pre data-index="12" class="set-code-show" name="code"><code class="hljs language-cobol"><ol class="hljs-ln" style="width:100%"><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="1"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-keyword">select</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="2"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> province,</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="3"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> <span class="hljs-keyword">count</span>(<span class="hljs-operator">*</span>) <span class="hljs-keyword">as</span> <span class="hljs-keyword">order</span>_cnt</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="4"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-keyword">from</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="5"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> dw_didi.t_user_<span class="hljs-keyword">order</span>_wide</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="6"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">where</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="7"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> dt <span class="hljs-operator">=</span> <span class="hljs-string">'2020-04-12'</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="8"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-keyword">group</span> <span class="hljs-keyword">by</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="9"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> province</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="10"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">;</div></div></li></ol></code><div class="hljs-button signin active" data-title="登录复制" data-report-click="{"spm":"1001.2101.3001.4334"}" onclick="hljs.signin(event)"></div></pre> <h4><a name="t10"></a></h4> <p>2）、app层建表</p> <pre data-index="13" class="set-code-show" name="code"><code class="hljs language-cobol"><ol class="hljs-ln" style="width:100%"><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="1"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">create <span class="hljs-keyword">table</span> <span class="hljs-keyword">if</span> <span class="hljs-keyword">not</span> exists app_didi.t_<span class="hljs-keyword">order</span>_province_total(</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="2"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> <span class="hljs-keyword">date</span> <span class="hljs-keyword">string</span> comment <span class="hljs-string">'日期'</span>,</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="3"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> province <span class="hljs-keyword">string</span> comment <span class="hljs-string">'省份'</span>,</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="4"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> <span class="hljs-keyword">count</span> integer comment <span class="hljs-string">'订单数量'</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="5"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">)</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="6"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">partitioned <span class="hljs-keyword">by</span> (month <span class="hljs-keyword">string</span> comment <span class="hljs-string">'年月，yyyy-MM'</span>)</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="7"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">row <span class="hljs-keyword">format</span> <span class="hljs-keyword">delimited</span> fields terminated <span class="hljs-keyword">by</span> <span class="hljs-string">','</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="8"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">;</div></div></li></ol></code><div class="hljs-button signin active" data-title="登录复制" data-report-click="{"spm":"1001.2101.3001.4334"}" onclick="hljs.signin(event)"></div></pre> <h4><a name="t11"></a></h4> <p>3）、加载数据到app表</p> <pre data-index="14" class="set-code-show" name="code"><code class="hljs language-cobol"><ol class="hljs-ln" style="width:713px"><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="1"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">insert overwrite <span class="hljs-keyword">table</span> app_didi.t_<span class="hljs-keyword">order</span>_province_total partition(month <span class="hljs-operator">=</span> <span class="hljs-string">'2020-04'</span>)</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="2"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-keyword">select</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="3"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> <span class="hljs-string">'2020-04-12'</span>,</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="4"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> province,</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="5"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> <span class="hljs-keyword">count</span>(<span class="hljs-operator">*</span>) <span class="hljs-keyword">as</span> <span class="hljs-keyword">order</span>_cnt</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="6"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-keyword">from</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="7"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> dw_didi.t_user_<span class="hljs-keyword">order</span>_wide</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="8"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">where</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="9"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> dt <span class="hljs-operator">=</span> <span class="hljs-string">'2020-04-12'</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="10"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-keyword">group</span> <span class="hljs-keyword">by</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="11"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> province</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="12"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">;</div></div></li></ol></code><div class="hljs-button signin active" data-title="登录复制" data-report-click="{"spm":"1001.2101.3001.4334"}" onclick="hljs.signin(event)"></div></pre> <p><strong>订单指标分析-不同年龄段/时段订单占比</strong></p> <p>1）、编写HQL语句</p> <pre data-index="15" class="set-code-show" name="code"><code class="hljs language-cobol"><ol class="hljs-ln" style="width:100%"><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="1"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-keyword">select</span> </div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="2"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> age_range, </div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="3"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> <span class="hljs-keyword">order</span>_<span class="hljs-keyword">time</span>_range, </div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="4"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> <span class="hljs-keyword">count</span>(<span class="hljs-operator">*</span>) <span class="hljs-keyword">as</span> <span class="hljs-keyword">order</span>_cnt </div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="5"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-keyword">from</span> </div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="6"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> dw_didi.t_user_<span class="hljs-keyword">order</span>_wide </div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="7"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">where </div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="8"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> dt <span class="hljs-operator">=</span> <span class="hljs-string"><span class="hljs-string">'2020-04-12’ </span></span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="9"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-string">group by </span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="10"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-string"> age_range, </span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="11"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-string"> order_time_range </span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="12"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-string">;</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="13"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-string"></span></div></div></li></ol></code><div class="hljs-button signin active" data-title="登录复制" data-report-click="{"spm":"1001.2101.3001.4334"}" onclick="hljs.signin(event)"></div></pre> <p>2）、app层建表</p> <pre data-index="16" class="set-code-show" name="code"><code class="hljs language-vbnet"><ol class="hljs-ln" style="width:100%"><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="1"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">create table <span class="hljs-keyword">if</span> <span class="hljs-built_in">not</span> exists app_didi. t_order_age_and_time_range_total ( </div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="2"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-type">date</span> <span class="hljs-type">string</span> comment <span class="hljs-comment">'日期’, </span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="3"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">age_range <span class="hljs-type">string</span> comment <span class="hljs-comment">'年龄段’, </span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="4"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">order_time_range <span class="hljs-type">string</span> comment <span class="hljs-comment">'时段’, </span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="5"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">count <span class="hljs-type">integer</span> comment <span class="hljs-comment">'订单数量’ </span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="6"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">) </div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="7"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">partitioned <span class="hljs-keyword">by</span> (month <span class="hljs-type">string</span> comment <span class="hljs-comment">'年月，yyyy-MM’) </span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="8"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">row format delimited fields terminated <span class="hljs-keyword">by</span> <span class="hljs-comment">',' ;</span></div></div></li></ol></code><div class="hljs-button signin active" data-title="登录复制" data-report-click="{"spm":"1001.2101.3001.4334"}" onclick="hljs.signin(event)"></div></pre> <p>3）、加载数据到app表</p> <pre data-index="17" class="set-code-show" name="code"><code class="hljs language-cobol"><ol class="hljs-ln" style="width:798px"><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="1"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">insert overwrite <span class="hljs-keyword">table</span> app_didi.t_<span class="hljs-keyword">order</span>_age_<span class="hljs-keyword">and</span>_<span class="hljs-keyword">time</span>_range_total partition(month <span class="hljs-operator">=</span> <span class="hljs-string"><span class="hljs-string">'2020-04’) </span></span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="2"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-string">select </span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="3"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-string"> ‘2020-04-12’,</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="4"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-string"> age_range, </span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="5"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-string"> order_time_range, </span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="6"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-string"> count(*) as order_cnt </span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="7"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-string">from </span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="8"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-string"> dw_didi.t_user_order_wide </span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="9"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-string">where </span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="10"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-string"> dt = '</span><span class="hljs-number">2020</span>-<span class="hljs-number">04</span>-<span class="hljs-number">12</span>’ </div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="11"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"><span class="hljs-keyword">group</span> <span class="hljs-keyword">by</span> age_range, <span class="hljs-keyword">order</span>_<span class="hljs-keyword">time</span>_range ;</div></div></li></ol></code><div class="hljs-button signin active" data-title="登录复制" data-report-click="{"spm":"1001.2101.3001.4334"}" onclick="hljs.signin(event)"></div></pre> <p>select * from app_didi.t_order_age_and_time_range_total</p> <p></p> <h3><a name="t12"></a>五、Sqoop数据导出</h3> <h4><a name="t13"></a></h4> <p>在分析完核心指标后，需要将指标数据导出到mysql数据库中，便于后续的应用，例如指标的可视化。</p> <p>Apache Sqoop是在Hadoop生态体系和RDBMS体系之间传送数据的一个工具，来自于Apache</p> <p>Hadoop生态系统包含：HDFS、Hive、Hbase等等</p> <p>RDBMS体系包含：Mysql、Oracle、DB2等</p> <p>Sqoop可以理解：“SQL到Hadoop 和Hadoop 到SQL”</p> <p><img alt="" height="439" src="https://img-blog.csdnimg.cn/7c8f95eac8fd45f086112e01dc75e14e.png" width="1050"></p> <p> 安装Sqoop 1.4.7启动</p> <pre data-index="18" class="set-code-show" name="code"><code class="hljs language-cobol"><ol class="hljs-ln" style="width:100%"><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="1"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">#进入Sqoop安装目录</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="2"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">cd <span class="hljs-operator">/</span>export<span class="hljs-operator">/</span>server<span class="hljs-operator">/</span>sqoop-<span class="hljs-number">1.4.7</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="3"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">#验证sqoop是否工作</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="4"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">bin<span class="hljs-operator">/</span>sqoop list-databases \</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="5"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">--connect jdbc:mysql:<span class="hljs-operator">/</span><span class="hljs-operator">/</span><span class="hljs-number">192.168.88.100</span>:<span class="hljs-number">3306</span><span class="hljs-operator">/</span> \</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="6"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">--username root \</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="7"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">--password <span class="hljs-number">123456</span></div></div></li></ol></code><div class="hljs-button signin active" data-title="登录复制" data-report-click="{"spm":"1001.2101.3001.4334"}" onclick="hljs.signin(event)"></div></pre> <p>显示Mysql中所有的数据库</p> <pre data-index="19" class="set-code-show" name="code"><code class="hljs language-undefined"><ol class="hljs-ln" style="width:100%"><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="1"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">information_schema</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="2"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">hive</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="3"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">mysql</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="4"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">performance_schema</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="5"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">sys</div></div></li></ol></code><div class="hljs-button signin active" data-title="登录复制" data-report-click="{"spm":"1001.2101.3001.4334"}" onclick="hljs.signin(event)"></div></pre> <p><strong>Mysql创建目标表</strong></p> <p>1）、将数据从Hadoop生态体系导出到RDBMS数据库导出前，目标表必须存在于目标数据库中，所以我们必须先在Mysql中创建对应的目标数据库app_test</p> <pre data-index="20" class="set-code-show" name="code"><code class="hljs language-cobol"><ol class="hljs-ln" style="width:100%"><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="1"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> #创建目标数据库</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="2"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> create database <span class="hljs-keyword">if</span> <span class="hljs-keyword">not</span> exists app_didi;</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="3"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> </div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="4"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> #创建订单总笔数目标表</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="5"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> create <span class="hljs-keyword">table</span> <span class="hljs-keyword">if</span> <span class="hljs-keyword">not</span> exists app_didi.t_<span class="hljs-keyword">order</span>_total(</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="6"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> <span class="hljs-keyword">order</span>_<span class="hljs-keyword">date</span> <span class="hljs-keyword">date</span>,</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="7"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> <span class="hljs-keyword">count</span> int</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="8"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> );</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="9"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> </div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="10"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> #创建预约订单<span class="hljs-operator">/</span>非预约订单统计目标表</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="11"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> create <span class="hljs-keyword">table</span> <span class="hljs-keyword">if</span> <span class="hljs-keyword">not</span> exists app_didi.t_<span class="hljs-keyword">order</span>_subscribe_total(</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="12"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> <span class="hljs-keyword">order</span>_<span class="hljs-keyword">date</span> <span class="hljs-keyword">date</span> ,</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="13"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> subscribe_name varchar(<span class="hljs-number">20</span>) ,</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="14"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> <span class="hljs-keyword">count</span> int</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="15"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">); </div></div></li></ol></code><div class="hljs-button signin active" data-title="登录复制" data-report-click="{"spm":"1001.2101.3001.4334"}" onclick="hljs.signin(event)"></div></pre> <p>2）、在mysql中创建数据库和目标表</p> <pre data-index="21" class="set-code-hide" name="code"><code class="hljs language-cobol"><ol class="hljs-ln" style="width:100%"><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="1"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> #创建不同时段订单统计目标表</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="2"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">create <span class="hljs-keyword">table</span> <span class="hljs-keyword">if</span> <span class="hljs-keyword">not</span> exists app_didi.t_<span class="hljs-keyword">order</span>_timerange_total(</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="3"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> <span class="hljs-keyword">order</span>_<span class="hljs-keyword">date</span> <span class="hljs-keyword">date</span> ,</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="4"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> timerange varchar(<span class="hljs-number">20</span>) ,</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="5"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> <span class="hljs-keyword">count</span> int </div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="6"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> );</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="7"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> </div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="8"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> #创建不同地域订单统计目标表</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="9"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> create <span class="hljs-keyword">table</span> <span class="hljs-keyword">if</span> <span class="hljs-keyword">not</span> exists app_didi.t_<span class="hljs-keyword">order</span>_province_total(</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="10"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> <span class="hljs-keyword">order</span>_<span class="hljs-keyword">date</span> <span class="hljs-keyword">date</span> ,</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="11"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> province varchar(<span class="hljs-number">20</span>) ,</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="12"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> <span class="hljs-keyword">count</span> int </div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="13"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> );</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="14"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> </div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="15"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> #创建不同年龄段，不同时段订单目标表</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="16"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> create <span class="hljs-keyword">table</span> <span class="hljs-keyword">if</span> <span class="hljs-keyword">not</span> exists app_didi.t_<span class="hljs-keyword">order</span>_age_<span class="hljs-keyword">and</span>_<span class="hljs-keyword">time</span>_range_total(</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="17"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> <span class="hljs-keyword">order</span>_<span class="hljs-keyword">date</span> <span class="hljs-keyword">date</span> ,</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="18"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> age_range varchar(<span class="hljs-number">20</span>) ,</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="19"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> <span class="hljs-keyword">order</span>_<span class="hljs-keyword">time</span>_range varchar(<span class="hljs-number">20</span>) ,</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="20"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> <span class="hljs-keyword">count</span> int </div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="21"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> );</div></div></li></ol></code><div class="hide-preCode-box"><span class="hide-preCode-bt" data-report-view="{"spm":"1001.2101.3001.7365"}"><img class="look-more-preCode contentImg-no-view" src="https://csdnimg.cn/release/blogv2/dist/pc/img/newCodeMoreWhite.png" alt="" title=""></span></div><div class="hljs-button signin active" data-title="登录复制" data-report-click="{"spm":"1001.2101.3001.4334"}" onclick="hljs.signin(event)"></div></pre> <p><strong>Sqoop数据导出</strong></p> <p>1）、将Hive中的结果表导出到mysql中</p> <pre data-index="22" class="set-code-hide" name="code"><code class="hljs language-cobol"><ol class="hljs-ln" style="width:744px"><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="1"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> #导出订单总笔数表数据</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="2"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> bin<span class="hljs-operator">/</span>sqoop export \</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="3"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> --connect jdbc:mysql:<span class="hljs-operator">/</span><span class="hljs-operator">/</span><span class="hljs-number">192.168.88.100</span>:<span class="hljs-number">3306</span><span class="hljs-operator">/</span>app_didi \</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="4"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> --username root \</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="5"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> --password <span class="hljs-number">123456</span> \</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="6"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"># 导入到这个mysql中的表</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="7"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> --<span class="hljs-keyword">table</span> t_<span class="hljs-keyword">order</span>_total \</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="8"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"># 将HDFS中的表</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="9"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> --export-dir <span class="hljs-operator">/</span>user<span class="hljs-operator">/</span>hive<span class="hljs-operator">/</span>warehouse<span class="hljs-operator">/</span>app_didi.db<span class="hljs-operator">/</span>t_<span class="hljs-keyword">order</span>_total<span class="hljs-operator">/</span>month<span class="hljs-operator">=</span><span class="hljs-number">2020</span>-<span class="hljs-number">04</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="10"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> </div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="11"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> #导出预约和非预约订单统计数据</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="12"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> bin<span class="hljs-operator">/</span>sqoop export \</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="13"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> --connect jdbc:mysql:<span class="hljs-operator">/</span><span class="hljs-operator">/</span><span class="hljs-number">192.168.88.100</span>:<span class="hljs-number">3306</span><span class="hljs-operator">/</span>app_didi \</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="14"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> --username root \</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="15"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> --password <span class="hljs-number">123456</span> \</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="16"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"># 导入到这个mysql中的表</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="17"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> --<span class="hljs-keyword">table</span> t_<span class="hljs-keyword">order</span>_subscribe_total \</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="18"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"># 将HDFS中的表</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="19"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> --export-dir <span class="hljs-operator">/</span>user<span class="hljs-operator">/</span>hive<span class="hljs-operator">/</span>warehouse<span class="hljs-operator">/</span>app_didi.db<span class="hljs-operator">/</span>t_<span class="hljs-keyword">order</span>_subscribe_total<span class="hljs-operator">/</span>month<span class="hljs-operator">=</span><span class="hljs-number">2020</span>-<span class="hljs-number">04</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="20"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> </div></div></li></ol></code><div class="hide-preCode-box"><span class="hide-preCode-bt" data-report-view="{"spm":"1001.2101.3001.7365"}"><img class="look-more-preCode contentImg-no-view" src="https://csdnimg.cn/release/blogv2/dist/pc/img/newCodeMoreWhite.png" alt="" title=""></span></div><div class="hljs-button signin active" data-title="登录复制" data-report-click="{"spm":"1001.2101.3001.4334"}" onclick="hljs.signin(event)"></div></pre> <p>Sqoop导出Hive结果表数据到Mysql</p> <pre data-index="23" class="set-code-hide" name="code"><code class="hljs language-cobol"><ol class="hljs-ln" style="width:744px"><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="1"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">#导出不同时段订单统计表</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="2"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> </div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="3"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> bin<span class="hljs-operator">/</span>sqoop export \</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="4"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> --connect jdbc:mysql:<span class="hljs-operator">/</span><span class="hljs-operator">/</span><span class="hljs-number">192.168.88.100</span>:<span class="hljs-number">3306</span><span class="hljs-operator">/</span>app_didi \</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="5"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> --username root \</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="6"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> --password <span class="hljs-number">123456</span> \</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="7"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> --<span class="hljs-keyword">table</span> t_<span class="hljs-keyword">order</span>_timerange_total \</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="8"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> --export-dir <span class="hljs-operator">/</span>user<span class="hljs-operator">/</span>hive<span class="hljs-operator">/</span>warehouse<span class="hljs-operator">/</span>app_didi.db<span class="hljs-operator">/</span>t_<span class="hljs-keyword">order</span>_timerange_total<span class="hljs-operator">/</span>month<span class="hljs-operator">=</span><span class="hljs-number">2020</span>-<span class="hljs-number">04</span></div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="9"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> </div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="10"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> </div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="11"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> #导出不同地域订单统计表</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="12"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> </div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="13"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> bin<span class="hljs-operator">/</span>sqoop export \</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="14"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> --connect jdbc:mysql:<span class="hljs-operator">/</span><span class="hljs-operator">/</span><span class="hljs-number">192.168.88.100</span>:<span class="hljs-number">3306</span><span class="hljs-operator">/</span>app_didi \</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="15"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> --username root \</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="16"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> --password <span class="hljs-number">123456</span> \</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="17"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"># 导入到这个mysql中的表</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="18"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> --<span class="hljs-keyword">table</span> t_<span class="hljs-keyword">order</span>_province_total \</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="19"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"># 将HDFS中的表</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="20"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> --export-dir <span class="hljs-operator">/</span>user<span class="hljs-operator">/</span>hive<span class="hljs-operator">/</span>warehouse<span class="hljs-operator">/</span>app_didi.db<span class="hljs-operator">/</span>t_<span class="hljs-keyword">order</span>_province_total<span class="hljs-operator">/</span>month<span class="hljs-operator">=</span><span class="hljs-number">2020</span>-<span class="hljs-number">04</span></div></div></li></ol></code><div class="hide-preCode-box"><span class="hide-preCode-bt" data-report-view="{"spm":"1001.2101.3001.7365"}"><img class="look-more-preCode contentImg-no-view" src="https://csdnimg.cn/release/blogv2/dist/pc/img/newCodeMoreWhite.png" alt="" title=""></span></div><div class="hljs-button signin active" data-title="登录复制" data-report-click="{"spm":"1001.2101.3001.4334"}" onclick="hljs.signin(event)"></div></pre> <pre data-index="24" class="set-code-show" name="code"><code class="hljs language-cobol"><ol class="hljs-ln" style="width:813px"><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="1"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line">#导出不同年龄段，不同时段订单目标表</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="2"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> bin<span class="hljs-operator">/</span>sqoop export \</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="3"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> --connect jdbc:mysql:<span class="hljs-operator">/</span><span class="hljs-operator">/</span><span class="hljs-number">192.168.88.100</span>:<span class="hljs-number">3306</span><span class="hljs-operator">/</span>app_didi \</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="4"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> --username root \</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="5"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> --password <span class="hljs-number">123456</span> \</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="6"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"># 导入到这个mysql中的表</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="7"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> --<span class="hljs-keyword">table</span> t_<span class="hljs-keyword">order</span>_age_<span class="hljs-keyword">and</span>_<span class="hljs-keyword">time</span>_range_total \</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="8"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"># 将HDFS中的表</div></div></li><li><div class="hljs-ln-numbers"><div class="hljs-ln-line hljs-ln-n" data-line-number="9"></div></div><div class="hljs-ln-code"><div class="hljs-ln-line"> --export-dir <span class="hljs-operator">/</span>user<span class="hljs-operator">/</span>hive<span class="hljs-operator">/</span>warehouse<span class="hljs-operator">/</span>app_didi.db<span class="hljs-operator">/</span>t_<span class="hljs-keyword">order</span>_age_<span class="hljs-keyword">and</span>_<span class="hljs-keyword">time</span>_range_total<span class="hljs-operator">/</span>month<span class="hljs-operator">=</span><span class="hljs-number">2020</span>-<span class="hljs-number">04</span></div></div></li></ol></code><div class="hljs-button signin active" data-title="登录复制" data-report-click="{"spm":"1001.2101.3001.4334"}" onclick="hljs.signin(event)"></div></pre> <h3><a name="t14"></a>六、Suerpset数据可视化</h3> <p>1）、Superset介绍</p> <p>Superset是一个开源的企业级BI，它是目前开源的数据分析和可视化工具中比较好用的，功能简单，支持多种数据源、图标类型多、易维护、易二次开发。</p> <p>2）、特点</p> <p>1、丰富的数据可视化集</p> <p>2、易于使用的界面，用于浏览和可视化数据</p> <p>3、可提供身份验证。</p> <p><strong>Superset安装和启动</strong></p> <p></p> <p>启动</p> <pre data-index="25" class="set-code-show" name="code"><code class="hljs language-css">superset run -h <span class="hljs-number">192.168</span>.<span class="hljs-number">88.100</span> -<span class="hljs-selector-tag">p</span> <span class="hljs-number">8099</span> <span class="hljs-attr">--with-threads</span> <span class="hljs-attr">--reload</span> <span class="hljs-attr">--debugger</span> </code><div class="hljs-button signin active" data-title="登录复制" data-report-click="{"spm":"1001.2101.3001.4334"}" onclick="hljs.signin(event)"></div></pre> <p><strong>Superset建立数据源</strong></p> <p>1）、介绍</p> <p>在启动完Superset之后，可以连接Mysql数据库</p> <p>2）、连接</p> <pre data-index="26" class="set-code-show" name="code"><code class="hljs language-cobol">mysql的url地:mysql<span class="hljs-operator">+</span>pymysql:<span class="hljs-operator">/</span><span class="hljs-operator">/</span>root:<span class="hljs-number">123456</span>@<span class="hljs-number">192.168.88.100</span><span class="hljs-operator">/</span>app_didi?charset<span class="hljs-operator">=</span>utf<span class="hljs-number">8</span> </code><div class="hljs-button signin active" data-title="登录复制" data-report-click="{"spm":"1001.2101.3001.4334"}" onclick="hljs.signin(event)"></div></pre> <p><strong>分析指标可视化-订单总笔数可视化</strong></p> <p>1)、选择表数据源</p> <p><img alt="" height="230" src="https://img-blog.csdnimg.cn/690e15810cec46da8f5ea9d16de40329.png" width="837"> </p> <p>2）、添加表连接</p> <p><img alt="" height="132" src="https://img-blog.csdnimg.cn/0ab7218eb4aa4730a39932c07c1176b8.png" width="745"></p> <p>3）、设置表连接相关参数</p> <p>4）、设置图标参数</p> <p><img alt="" height="725" src="https://img-blog.csdnimg.cn/3e783fbce70d48b78ca515d15561b9a8.png" width="1200"></p> <p><strong> 分析指标可视化-DashBoard看板开发</strong></p> <p></p> <p>1）、实现步骤</p> <p>1、创建看板</p> <p>2、设置看板名字</p> <p>3、进入看板</p> <p>4、编辑看板</p> <p>5、选择自定义看板</p> <p>6、制作看板</p> <p>7、调整看板</p> <p>最终效果</p> <p><img alt="" height="561" src="https://img-blog.csdnimg.cn/14c4cc31ac7c4ca7abf8fd7a8b40f67e.png" width="1200"></p> <p></p> </div><div data-report-view="{"mod":"1585297308_001","spm":"1001.2101.3001.6548","dest":"https://blog.csdn.net/qq_30353203/article/details/130094992","extend1":"pc","ab":"new"}"><div></div></div> <div><div><span>声明：</span>本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：<a href="https://www.wpsshop.cn/w/Gausst松鼠会/article/detail/650718">https://www.wpsshop.cn/w/Gausst松鼠会/article/detail/650718</a></div></div></div><div class="article_recommend"><div class="list_top">推荐阅读</div><div class="ListItems"><ul class="NewsList"><li><div class="NewTitle"><a title="article" class="cat" href="/article/list/1" target="_blank">article<i></i></a><a title="“华为杯”研究生数学建模竞赛2006年-【华为杯】D题：学生面试中教师安排的优化与算法（附获奖论文）" href="/w/weixin_40725706/article/detail/650077" target="_blank">“华为杯”研究生数学建模竞赛2006年-【华为杯】D题：<em>学生</em><em>面试</em><em>中</em>教师安排<em>的</em>优化与算法（附获奖论文）...</a></div><div class="NewsInfo"><div class="NewsDesc" style=""><a title="“华为杯”研究生数学建模竞赛2006年-【华为杯】D题：学生面试中教师安排的优化与算法（附获奖论文）" href="/w/weixin_40725706/article/detail/650077" target="_blank">高校<em>自主</em><em>招生</em>是高考改革<em>中</em><em>的</em>一项新生事物，现在仍处于探索阶段<em>。</em>某高校拟在全面衡量<em>考生</em><em>的</em>高<em>中</em>学习成绩及综合表现后再采用专家面... </a><div class="article_click rice1" style="width: 240px;float: left;"><p class="operation-b-img operation-b-img-active"><i class="img-up txclick" attc="upclick" attn="0"></i><span class="num"> 赞</span></p><p class="operation-b-img operation-b-img-active"><i class="img-down txclick" attc="downclick" attn="0"></i><span class="num">踩</span></p></div></div><div style="clear: both;"></div></div></li><li><div class="NewTitle"><a title="article" class="cat" href="/article/list/1" target="_blank">article<i></i></a><a title="Java 实现线程安全的三种方式及如何保证线程安全_java substring线程安全" href="/w/花生_TL007/article/detail/650148" target="_blank"><em>Java</em> <em>实现</em><em>线程</em><em>安全</em>的三种方式及如何保证<em>线程</em><em>安全</em>_<em>java</em> <em>substring</em><em>线程</em><em>安全</em>...</a></div><div class="NewsInfo"><div class="NewsDesc" style=""><a title="Java 实现线程安全的三种方式及如何保证线程安全_java substring线程安全" href="/w/花生_TL007/article/detail/650148" target="_blank">前言一个程序在运行起来的时候会转换成进程，通常含有多个<em>线程</em>。通常情况下，一个进程中的比较耗时的操作（如长循环、文件上传下... </a><div class="article_click rice1" style="width: 240px;float: left;"><p class="operation-b-img operation-b-img-active"><i class="img-up txclick" attc="upclick" attn="0"></i><span class="num"> 赞</span></p><p class="operation-b-img operation-b-img-active"><i class="img-down txclick" attc="downclick" attn="0"></i><span class="num">踩</span></p></div></div><div style="clear: both;"></div></div></li><li><div class="NewTitle"><a title="article" class="cat" href="/article/list/1" target="_blank">article<i></i></a><a title="自动生成代码插件：Lombok_lombok插件下载" href="/w/小蓝xlanll/article/detail/650726" target="_blank">自动生成代码<em>插件</em>：<em>Lombok</em>_<em>lombok</em><em>插件</em><em>下载</em>...</a></div><div class="NewsInfo"><div class="NewsDesc" style=""><a title="自动生成代码插件：Lombok_lombok插件下载" href="/w/小蓝xlanll/article/detail/650726" target="_blank">Data 上去的3个注解的和，会创建getter、setter、equals、hashCode 和 toString。*... </a><div class="article_click rice1" style="width: 240px;float: left;"><p class="operation-b-img operation-b-img-active"><i class="img-up txclick" attc="upclick" attn="0"></i><span class="num"> 赞</span></p><p class="operation-b-img operation-b-img-active"><i class="img-down txclick" attc="downclick" attn="0"></i><span class="num">踩</span></p></div></div><div style="clear: both;"></div></div></li><li><div class="NewTitle"><a title="article" class="cat" href="/article/list/1" target="_blank">article<i></i></a><a title="深度学习入门利器：TensorFlow教程项目详解" href="/w/小蓝xlanll/article/detail/649984" target="_blank"><em>深度</em><em>学习</em>入门利器：<em>TensorFlow</em>教程<em>项目</em>详解...</a></div><div class="NewsInfo"><div class="NewsDesc" style=""><a title="深度学习入门利器：TensorFlow教程项目详解" href="/w/小蓝xlanll/article/detail/649984" target="_blank"><em>深度</em><em>学习</em>入门利器：<em>TensorFlow</em>教程<em>项目</em>详解<em>项目</em>地址:https://gitcode.com/yongyehuan... </a><div class="article_click rice1" style="width: 240px;float: left;"><p class="operation-b-img operation-b-img-active"><i class="img-up txclick" attc="upclick" attn="0"></i><span class="num"> 赞</span></p><p class="operation-b-img operation-b-img-active"><i class="img-down txclick" attc="downclick" attn="0"></i><span class="num">踩</span></p></div></div><div style="clear: both;"></div></div></li><li><div class="NewTitle"><a title="article" class="cat" href="/article/list/1" target="_blank">article<i></i></a><a title="linux zip分卷压缩和解压缩_linux解压分卷压缩包" href="/w/IT小白/article/detail/650170" target="_blank"><em>linux</em> <em>zip</em><em>分卷压缩</em>和<em>解压</em>缩_<em>linux</em><em>解压</em><em>分卷压缩</em>包...</a></div><div class="NewsInfo"><div class="NewsDesc" style=""><a title="linux zip分卷压缩和解压缩_linux解压分卷压缩包" href="/w/IT小白/article/detail/650170" target="_blank">假设待压缩的是data/目录。_<em>linux</em><em>解压</em><em>分卷压缩</em>包<em>linux</em><em>解压</em><em>分卷压缩</em>包假设待压缩的是... </a><div class="article_click rice1" style="width: 240px;float: left;"><p class="operation-b-img operation-b-img-active"><i class="img-up txclick" attc="upclick" attn="0"></i><span class="num"> 赞</span></p><p class="operation-b-img operation-b-img-active"><i class="img-down txclick" attc="downclick" attn="0"></i><span class="num">踩</span></p></div></div><div style="clear: both;"></div></div></li><li><div class="NewTitle"><a title="article" class="cat" href="/article/list/1" target="_blank">article<i></i></a><a title="【Python入门】超详细Python+Pycharm安装保姆级教程，Python环境配置和使用指南" href="/w/小小林熬夜学编程/article/detail/649863" target="_blank">【<em>Python</em>入门】超详细<em>Python</em>+<em>Pycharm</em><em>安装</em>保姆级教程<em>，</em><em>Python</em>环境配置和<em>使用指南</em>...</a></div><div class="NewsInfo"><div class="NewsDesc" style=""><a title="【Python入门】超详细Python+Pycharm安装保姆级教程，Python环境配置和使用指南" href="/w/小小林熬夜学编程/article/detail/649863" target="_blank"><em>这</em>两年被<em>Python</em>初学小白问到最多的问题就是<em>，</em>该用什么代码编辑工具？说实话<em>，</em>我个人是用Jupyter Notebook... </a><div class="article_click rice1" style="width: 240px;float: left;"><p class="operation-b-img operation-b-img-active"><i class="img-up txclick" attc="upclick" attn="0"></i><span class="num"> 赞</span></p><p class="operation-b-img operation-b-img-active"><i class="img-down txclick" attc="downclick" attn="0"></i><span class="num">踩</span></p></div></div><div style="clear: both;"></div></div></li><li><div class="NewTitle"><a title="article" class="cat" href="/article/list/1" target="_blank">article<i></i></a><a title="大数据毕业设计hadoop+spark+hive知识图谱酒店推荐系统_hadoop国内外研究现状" href="/w/Cpp五条/article/detail/649953" target="_blank">大<em>数据</em><em>毕业设计</em><em>hadoop</em>+<em>spark</em>+hive知识图谱酒店推荐系统_<em>hadoop</em>国内外<em>研究</em>现状...</a></div><div class="NewsInfo"><div class="NewsDesc" style=""><a title="大数据毕业设计hadoop+spark+hive知识图谱酒店推荐系统_hadoop国内外研究现状" href="/w/Cpp五条/article/detail/649953" target="_blank">本<em>研究</em>旨在基于大<em>数据</em>技术设计并实现一个民宿<em>数据</em>可视化分析系统，以提供全面的<em>数据</em>分析和决策支持，让民宿的各个维度的<em>数据</em>指标... </a><div class="article_click rice1" style="width: 240px;float: left;"><p class="operation-b-img operation-b-img-active"><i class="img-up txclick" attc="upclick" attn="0"></i><span class="num"> 赞</span></p><p class="operation-b-img operation-b-img-active"><i class="img-down txclick" attc="downclick" attn="0"></i><span class="num">踩</span></p></div></div><div style="clear: both;"></div></div></li><li><div class="NewTitle"><a title="article" class="cat" href="/article/list/1" target="_blank">article<i></i></a><a title="Web（数字媒体）期末作业" href="/w/知新_RL/article/detail/650050" target="_blank"><em>Web</em>（<em>数字</em><em>媒体</em>）期末<em>作业</em>...</a></div><div class="NewsInfo"><div class="NewsDesc" style=""><a title="Web（数字媒体）期末作业" href="/w/知新_RL/article/detail/650050" target="_blank">1.本资源为类似于打飞机的网页游戏2.链接如下：【免费】前端web或者<em>数字</em><em>媒体</em>的期末<em>作业</em>（类似于打飞机的2D网页小游戏）... </a><div class="article_click rice1" style="width: 240px;float: left;"><p class="operation-b-img operation-b-img-active"><i class="img-up txclick" attc="upclick" attn="0"></i><span class="num"> 赞</span></p><p class="operation-b-img operation-b-img-active"><i class="img-down txclick" attc="downclick" attn="0"></i><span class="num">踩</span></p></div></div><div style="clear: both;"></div></div></li><li><div class="NewTitle"><a title="article" class="cat" href="/article/list/1" target="_blank">article<i></i></a><a title="配置PyCharm环境_pycharm安装好之后怎么设置环境" href="/w/Cpp五条/article/detail/649909" target="_blank">配置<em>PyCharm</em><em>环境</em><em>_</em><em>pycharm</em>安装好之后怎么<em>设置</em><em>环境</em>...</a></div><div class="NewsInfo"><div class="NewsDesc" style=""><a title="配置PyCharm环境_pycharm安装好之后怎么设置环境" href="/w/Cpp五条/article/detail/649909" target="_blank">4.点击新建，将<em>pycharm</em>程序路径（桌面右键图标选择打开文件的所在位置）复制，然后点击确定。3.找到系统变量里面的p... </a><div class="article_click rice1" style="width: 240px;float: left;"><p class="operation-b-img operation-b-img-active"><i class="img-up txclick" attc="upclick" attn="0"></i><span class="num"> 赞</span></p><p class="operation-b-img operation-b-img-active"><i class="img-down txclick" attc="downclick" attn="0"></i><span class="num">踩</span></p></div></div><div style="clear: both;"></div></div></li><li><div class="NewTitle"><a title="article" class="cat" href="/article/list/1" target="_blank">article<i></i></a><a title="tensorflow+入门笔记︱基本张量tensor理解与tensorflow运行结构与相关报错_t" href="/w/不正经/article/detail/649993" target="_blank"><em><em>tensor</em>flow</em>+入门笔记︱基本<em>张量</em><em>tensor</em>理解与<em><em>tensor</em>flow</em>运行<em>结构</em>与相关报错_t...</a></div><div class="NewsInfo"><div class="NewsDesc" style=""><a title="tensorflow+入门笔记︱基本张量tensor理解与tensorflow运行结构与相关报错_t" href="/w/不正经/article/detail/649993" target="_blank">Gokula Krishnan Santhanam认为，大部分深度学习框架都包含以下五个核心组件： <em>张量</em>（Tensor... </a><div class="article_click rice1" style="width: 240px;float: left;"><p class="operation-b-img operation-b-img-active"><i class="img-up txclick" attc="upclick" attn="0"></i><span class="num"> 赞</span></p><p class="operation-b-img operation-b-img-active"><i class="img-down txclick" attc="downclick" attn="0"></i><span class="num">踩</span></p></div></div><div style="clear: both;"></div></div></li><li><div class="NewTitle"><a title="article" class="cat" href="/article/list/1" target="_blank">article<i></i></a><a title="堆载预压弹性变形怎样计算公式_机器人手爪受力变形分析，挠度计算方法，有限元分析应力及应变..." href="/w/2023面试高手/article/detail/650326" target="_blank">堆载预压弹性<em>变形</em>怎样<em>计算公式</em>_<em>机器人</em>手爪受力<em>变形</em><em>分析</em>，挠度<em>计算方法</em>，<em>有限元</em><em>分析</em>应力及应变......</a></div><div class="NewsInfo"><div class="NewsDesc" style=""><a title="堆载预压弹性变形怎样计算公式_机器人手爪受力变形分析，挠度计算方法，有限元分析应力及应变..." href="/w/2023面试高手/article/detail/650326" target="_blank"><em>机器人</em>手爪通常由气缸和手指组成，其中如何确定手指尺寸是关键，下面通过SolidWorks<em>有限元</em><em>分析</em>和理论计算两种方式，分... </a><div class="article_click rice1" style="width: 240px;float: left;"><p class="operation-b-img operation-b-img-active"><i class="img-up txclick" attc="upclick" attn="0"></i><span class="num"> 赞</span></p><p class="operation-b-img operation-b-img-active"><i class="img-down txclick" attc="downclick" attn="0"></i><span class="num">踩</span></p></div></div><div style="clear: both;"></div></div></li><li><div class="NewTitle"><a title="article" class="cat" href="/article/list/1" target="_blank">article<i></i></a><a title="【Hive】（十四）Hive 项目实战之电子商务消费行为分析_hive项目实战_hive大数据案例实" href="/w/凡人多烦事01/article/detail/650725" target="_blank">【<em>Hive</em>】（十四）<em>Hive</em> <em>项目</em>实战之<em>电子商务</em><em>消费行为</em>分析_<em>hive</em><em>项目</em>实战_<em>hive</em>大<em>数据</em>案例实...</a></div><div class="NewsInfo"><div class="NewsDesc" style=""><a title="【Hive】（十四）Hive 项目实战之电子商务消费行为分析_hive项目实战_hive大数据案例实" href="/w/凡人多烦事01/article/detail/650725" target="_blank"><em>Hive</em> 学习过程中的一个练习<em>项目</em>，如果不妥的地方或者更好的建议，欢迎指出！<em>hive</em>大<em>数据</em>案例实践 ... </a><div class="article_click rice1" style="width: 240px;float: left;"><p class="operation-b-img operation-b-img-active"><i class="img-up txclick" attc="upclick" attn="0"></i><span class="num"> 赞</span></p><p class="operation-b-img operation-b-img-active"><i class="img-down txclick" attc="downclick" attn="0"></i><span class="num">踩</span></p></div></div><div style="clear: both;"></div></div></li><li><div class="NewTitle"><a title="article" class="cat" href="/article/list/1" target="_blank">article<i></i></a><a title="大数据毕设分享(含算法) 基于Python实现的新闻搜索引擎(源码+论文)_毕设查询系统算法" href="/w/知新_RL/article/detail/650033" target="_blank">大<em>数据</em><em>毕设</em>分享(含<em>算法</em>) 基于<em>Python</em><em>实现</em>的<em>新闻</em><em>搜索引擎</em>(源码+论文)_<em>毕设</em>查询系统 <em>算法</em>...</a></div><div class="NewsInfo"><div class="NewsDesc" style=""><a title="大数据毕设分享(含算法) 基于Python实现的新闻搜索引擎(源码+论文)_毕设查询系统算法" href="/w/知新_RL/article/detail/650033" target="_blank">0 简介。_<em>毕设</em>查询系统 <em>算法</em><em>毕设</em>查询系统 <em>算法</em> # 0 简介 ... </a><div class="article_click rice1" style="width: 240px;float: left;"><p class="operation-b-img operation-b-img-active"><i class="img-up txclick" attc="upclick" attn="0"></i><span class="num"> 赞</span></p><p class="operation-b-img operation-b-img-active"><i class="img-down txclick" attc="downclick" attn="0"></i><span class="num">踩</span></p></div></div><div style="clear: both;"></div></div></li><li><div class="NewTitle"><a title="article" class="cat" href="/article/list/1" target="_blank">article<i></i></a><a title="基于PHP后台微信理发店预约小程序系统设计与实现" href="/w/IT小白/article/detail/650599" target="_blank">基于<em>PHP</em>后台微信<em>理发店</em><em>预约</em><em>小</em><em>程序</em>系统<em>设计</em>与实现...</a></div><div class="NewsInfo"><div class="NewsImg"><a title="基于PHP后台微信理发店预约小程序系统设计与实现" href="/w/IT小白/article/detail/650599" target="_blank"><img width="120" height="70" alt="基于PHP后台微信理发店预约小程序系统设计与实现" src="https://img-blog.csdnimg.cn/direct/44be434888424d12a3e261eb9218e08a.png?x-oss-process=image/resize,m_fixed,h_300,image/format,png"></a></div><div class="NewsDesc" style=""><a title="基于PHP后台微信理发店预约小程序系统设计与实现" href="/w/IT小白/article/detail/650599" target="_blank">基于<em>PHP</em>后台微信<em>理发店</em><em>预约</em><em>小</em><em>程序</em>系统<em>设计</em>与实现毕业<em>设计</em>源码，黄菊华老师《Vue.js入门与商城开发实战》《微信<em>小</em><em>程序</em>商... </a><div class="article_click rice1" style="width: 240px;float: left;"><p class="operation-b-img operation-b-img-active"><i class="img-up txclick" attc="upclick" attn="0"></i><span class="num"> 赞</span></p><p class="operation-b-img operation-b-img-active"><i class="img-down txclick" attc="downclick" attn="0"></i><span class="num">踩</span></p></div></div><div style="clear: both;"></div></div></li><li><div class="NewTitle"><a title="article" class="cat" href="/article/list/1" target="_blank">article<i></i></a><a title="Pycharm下载与安装_pycharm官方下载地址" href="/w/IT小白/article/detail/649996" target="_blank"><em>Pycharm</em><em>下载</em>与<em>安装</em>_<em>pycharm</em>官方<em>下载</em>地址...</a></div><div class="NewsInfo"><div class="NewsDesc" style=""><a title="Pycharm下载与安装_pycharm官方下载地址" href="/w/IT小白/article/detail/649996" target="_blank">执行以上操作后，Python 会<em>安装</em>在 /usr/local/bin 目录中，Python 库<em>安装</em>在 /usr/loca... </a><div class="article_click rice1" style="width: 240px;float: left;"><p class="operation-b-img operation-b-img-active"><i class="img-up txclick" attc="upclick" attn="0"></i><span class="num"> 赞</span></p><p class="operation-b-img operation-b-img-active"><i class="img-down txclick" attc="downclick" attn="0"></i><span class="num">踩</span></p></div></div><div style="clear: both;"></div></div></li><li><div class="NewTitle"><a title="article" class="cat" href="/article/list/1" target="_blank">article<i></i></a><a title="使用nn.init自定义权重，总是报错RuntimeError: Expected object o" href="/w/AllinToyou/article/detail/649866" target="_blank">使用<em>nn</em>.<em>init</em>自定义权重，总是报错<em>RuntimeError</em>: <em>Expected</em> <em>object</em> o...</a></div><div class="NewsInfo"><div class="NewsDesc" style=""><a title="使用nn.init自定义权重，总是报错RuntimeError: Expected object o" href="/w/AllinToyou/article/detail/649866" target="_blank">编程小白求大佬拯救！最近为了毕设在做MobileNet的实验，在训练网络的时候通过<em>nn</em>.<em>init</em>自定义了权重，代码如下：... </a><div class="article_click rice1" style="width: 240px;float: left;"><p class="operation-b-img operation-b-img-active"><i class="img-up txclick" attc="upclick" attn="0"></i><span class="num"> 赞</span></p><p class="operation-b-img operation-b-img-active"><i class="img-down txclick" attc="downclick" attn="0"></i><span class="num">踩</span></p></div></div><div style="clear: both;"></div></div></li><li><div class="NewTitle"><a title="article" class="cat" href="/article/list/1" target="_blank">article<i></i></a><a title="使用 Terraform 在 GCP 上一键部署 EMQX MQTT Broker_terrafor" href="/w/小丑西瓜9/article/detail/649732" target="_blank">使用 <em>Terraform</em> 在 GCP 上一键部署 <em>EMQX</em> <em>MQTT</em> <em>Broker</em>_terrafor...</a></div><div class="NewsInfo"><div class="NewsDesc" style=""><a title="使用 Terraform 在 GCP 上一键部署 EMQX MQTT Broker_terrafor" href="/w/小丑西瓜9/article/detail/649732" target="_blank"><em>MQTT</em> 是一种轻量级的消息传递协议，适用于物联网应用实现设备间通信。作为一款主流的开源 <em>MQTT</em> <em>Broker</em>，EMQ... </a><div class="article_click rice1" style="width: 240px;float: left;"><p class="operation-b-img operation-b-img-active"><i class="img-up txclick" attc="upclick" attn="0"></i><span class="num"> 赞</span></p><p class="operation-b-img operation-b-img-active"><i class="img-down txclick" attc="downclick" attn="0"></i><span class="num">踩</span></p></div></div><div style="clear: both;"></div></div></li><li><div class="NewTitle"><a title="article" class="cat" href="/article/list/1" target="_blank">article<i></i></a><a title="吊炸天的网页版 Xshell 你没用过吧？支持 FTP 和 SFTP，有点牛逼！" href="/w/羊村懒王/article/detail/650707" target="_blank">吊炸天<em>的</em><em>网页</em>版 <em>Xshell</em> 你没用过吧？<em>支持</em> <em>FTP</em> 和 S<em>FTP</em>，有点牛逼！...</a></div><div class="NewsInfo"><div class="NewsDesc" style=""><a title="吊炸天的网页版 Xshell 你没用过吧？支持 FTP 和 SFTP，有点牛逼！" href="/w/羊村懒王/article/detail/650707" target="_blank">点关注公众号，回复“1024”获取2TB学习资源！项目介绍该平台类似于<em>网页</em>版<em>的</em> <em>Xshell</em>，基于 cookie 和 j... </a><div class="article_click rice1" style="width: 240px;float: left;"><p class="operation-b-img operation-b-img-active"><i class="img-up txclick" attc="upclick" attn="0"></i><span class="num"> 赞</span></p><p class="operation-b-img operation-b-img-active"><i class="img-down txclick" attc="downclick" attn="0"></i><span class="num">踩</span></p></div></div><div style="clear: both;"></div></div></li><li><div class="NewTitle"><a title="article" class="cat" href="/article/list/1" target="_blank">article<i></i></a><a title="动手强化学习——简述_价值函数是用于评估给定策略下的好坏。" href="/w/笔触狂放9/article/detail/650099" target="_blank">动手<em>强化</em><em>学习</em>——简述_<em>价值</em><em>函数</em>是用于评估给定<em>策略</em>下 <em>的</em>好坏。...</a></div><div class="NewsInfo"><div class="NewsDesc" style=""><a title="动手强化学习——简述_价值函数是用于评估给定策略下的好坏。" href="/w/笔触狂放9/article/detail/650099" target="_blank">动手<em>强化</em><em>学习</em>——简述：介绍了<em>强化</em><em>学习</em><em>的</em>基本概念和智能体<em>的</em>分类，包括基于模型<em>的</em>分类和其他方式。以及强调了在计算机视觉领域中... </a><div class="article_click rice1" style="width: 240px;float: left;"><p class="operation-b-img operation-b-img-active"><i class="img-up txclick" attc="upclick" attn="0"></i><span class="num"> 赞</span></p><p class="operation-b-img operation-b-img-active"><i class="img-down txclick" attc="downclick" attn="0"></i><span class="num">踩</span></p></div></div><div style="clear: both;"></div></div></li><li><div class="NewTitle"><a title="article" class="cat" href="/article/list/1" target="_blank">article<i></i></a><a title="java这个学习路线有点意思" href="/w/我家小花儿/article/detail/650482" target="_blank"><em>java</em>这个<em>学习</em>路线<em>有点</em>意思...</a></div><div class="NewsInfo"><div class="NewsDesc" style=""><a title="java这个学习路线有点意思" href="/w/我家小花儿/article/detail/650482" target="_blank">Java是一个通用的编程语言，其实可以干很多事，怎么学Java就看怎么用了，但有一些一般的步骤：熟悉一种文本编辑器，比如... </a><div class="article_click rice1" style="width: 240px;float: left;"><p class="operation-b-img operation-b-img-active"><i class="img-up txclick" attc="upclick" attn="0"></i><span class="num"> 赞</span></p><p class="operation-b-img operation-b-img-active"><i class="img-down txclick" attc="downclick" attn="0"></i><span class="num">踩</span></p></div></div><div style="clear: both;"></div></div></li></ul><div class="list_tools_top">相关标签</div><div class="list_tools_box"><ul><li><a title="面试" rel="nofollow" href="/s?w=面试" target="_self">面试</a></li><li><a title="java" rel="nofollow" href="/s?w=java" target="_self">java</a></li><li><a title="职场和发展" rel="nofollow" href="/s?w=职场和发展" target="_self">职场和发展</a></li><li><a title="多线程" rel="nofollow" href="/s?w=多线程" target="_self">多线程</a></li><li><a title="并发编程" rel="nofollow" href="/s?w=并发编程" target="_self">并发编程</a></li><li><a title="自动化" rel="nofollow" href="/s?w=自动化" target="_self">自动化</a></li><li><a title="linux" rel="nofollow" href="/s?w=linux" target="_self">linux</a></li><li><a title="bash" rel="nofollow" href="/s?w=bash" target="_self">bash</a></li><li><a title="python" rel="nofollow" href="/s?w=python" target="_self">python</a></li><li><a title="pycharm" rel="nofollow" href="/s?w=pycharm" target="_self">pycharm</a></li><li><a title="开发语言" rel="nofollow" href="/s?w=开发语言" target="_self">开发语言</a></li><li><a title="大数据" rel="nofollow" href="/s?w=大数据" target="_self">大数据</a></li><li><a title="hadoop" rel="nofollow" href="/s?w=hadoop" target="_self">hadoop</a></li><li><a title="课程设计" rel="nofollow" href="/s?w=课程设计" target="_self">课程设计</a></li><li><a title="媒体" rel="nofollow" href="/s?w=媒体" target="_self">媒体</a></li><li><a title="前端" rel="nofollow" href="/s?w=前端" target="_self">前端</a></li><li><a title="web" rel="nofollow" href="/s?w=web" target="_self">web</a></li><li><a title="大作业" rel="nofollow" href="/s?w=大作业" target="_self">大作业</a></li><li><a title="深度学习" rel="nofollow" href="/s?w=深度学习" target="_self">深度学习</a></li><li><a title="tensorflow" rel="nofollow" href="/s?w=tensorflow" target="_self">tensorflow</a></li><li><a title="入门" rel="nofollow" href="/s?w=入门" target="_self">入门</a></li><li><a title="笔记" rel="nofollow" href="/s?w=笔记" target="_self">笔记</a></li><li><a title="张量" rel="nofollow" href="/s?w=张量" target="_self">张量</a></li><li><a title="堆载预压弹性变形怎样计算公式" rel="nofollow" href="/s?w=堆载预压弹性变形怎样计算公式" target="_self">堆载预压弹性变形怎样计算公式</a></li><div style="clear: both;"></div></ul></div><div class="list_tools_top"></div></div></div></div><style type="text/css"></style><link rel="stylesheet" href="https://cdn.wpsshop.cn/public/blog/css/phone.css?v=17352890" type="text/css"><script type="text/javascript"></script></div></div></div></div></div></div><style type="text/css"> /* footer css */ .index006-cover-page-foot { background-color: #F7F7F7; } </style><div class="cppui-row-1_100 cppui-row-view-1 row_1_100 ui-draggable" style="display: block;"><div class="cppui-column-1_100-0-1 column-view-com cppui-column-1_100-0-view-1 ui-sortable"><div class="drag-item-show-view-1 footermsg_view_pic ui-draggable" style="display: block;"><div class="index006-cover-page-foot drag-item-hide-view-1"><p class="copyright">Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。 </p><div style="background-color:#F7F7F7; text-align:center; height:20px;padding-top:5px;"><a target="_blank" href="#" style="display:inline-block;text-decoration:none;height:20px;line-height:20px;"><img src="https://cdnimages.wpsshop.cn/57public/skin/index/default/ui/images/beian_ghs.png" style="float:left;"> <p style="float:left;height:20px;line-height:20px;margin: 0px 0px 0px 5px; color:#939393;">闽ICP备14008679号</p></a> <a href="https://www.wpsshop.cn/xml/w/Gausst%E6%9D%BE%E9%BC%A0%E4%BC%9A/article/detail/650718.xml" target="_blank" style="display:inline-block;text-decoration:none;height:20px;line-height:20px;"><img src="https://cdn.wpsshop.cn/public/blog/images/site.png" style="float:left;"></a> <a href="/xml/w/g007/article/detail/new.xml" target="_blank" style="display:inline-block;text-decoration:none;height:20px;line-height:20px;"><img src="https://cdn.wpsshop.cn/public/blog/images/site.png" style="float:left;"></a> <a href="/site.xml" target="_blank" style="display:inline-block;text-decoration:none;height:20px;line-height:20px;"><img src="https://cdn.wpsshop.cn/public/blog/images/site.png" style="float:left;"></a></div></div></div></div></div><script type="text/javascript">var domain = document.domain;var hr=encodeURIComponent(window.location.href+'=='+document.referrer); document.write('<script src="https://ad.wpsshop.cn/admin.appflux?s=ad_flu_ind&fluxuserauto=yes&hr='+hr+'&p57weburl='+domain+'&p57usercode1='+domain+'&u=Vy1RJQhqAXUEMQNnAm0HaVVu&i='+p57ref("id")+'&r='+escape(document.referrer)+'" language="JavaScript"><\/script>');function p57ref(id){var reg=new RegExp("(^|&)"+id+"=([^&]*)(&|$)");var ref=window.location.search.substr(1).match(reg);if(ref!=null)return unescape(ref[2]);return null;} </script></body></html>