Sqoop的基础应用

╰+攻爆jí腚メ 2022-01-12 15:33 295阅读 0赞

# **实验目的要求** #

1.  了解ET了工具Sqoop；
2.  学会安装配置Sqoop；
3.  学会使用数据迁移框架Sqoop；
4.  使用Sqoop导入MySQL到HDFS和Hive；
5.  使用Sqoop导出HDFS数据到MySQL；

# 实验环境 #

1.  Java jdk 1.7；
2.  apache-maven-3.6.0；
3.  Myeclipse C10；
4.  CDH Hadoop集群；
5.  已配置MySQL数据库；
6.  已配置Sqoop工具；
7.  具体规划：

<table style="margin-left:6.75pt;width:519px;"> 
 <tbody> 
 <tr> 
 <td style="border-color:#4472c4;width:102.05pt;"> 主机名 </td> 
 <td style="width:129pt;"> IP地址 </td> 
 <td style="border-color:#4472c4;width:158.3pt;"> 服务描述 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#8eaadb;width:102.05pt;"> Cmaster </td> 
 <td style="width:129pt;"> 192.168.159.170 </td> 
 <td style="width:158.3pt;"> 主控节点 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#8eaadb;width:102.05pt;"> Cslaver1 </td> 
 <td style="width:129pt;"> 192.168.159.171 </td> 
 <td style="width:158.3pt;"> 数据节点 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#8eaadb;width:102.05pt;"> Cslaver2 </td> 
 <td style="width:129pt;"> 192.168.159.172 </td> 
 <td style="width:158.3pt;"> 数据服务 </td> 
 </tr> 
 </tbody> 
</table>

# 实验内容 #

## **任务一：** **启动CDH\_Hadoop集群，并检查sqoop工具；** ##

### 1、进入控制台页面； ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70][]

### 2、启动相关组件； ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 1][]

## **任务二：使用Sqoop；** ##

### 1、准备MySQL数据库数据； ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 2][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 3][]

### 2、使用Sqoop测试与MySQL的连通； ###

命令：

sqoop import \\

\--connect jdbc:mysql://192.168.159.170:3306/sqoop \\

\--username root \\

\--password 123456 \\

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 4][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 3][]

### 3、使用Sqoop导入MySQL数据到HDFS； ###

命令：

sqoop import \\

\--connect jdbc:mysql://192.168.159.170:3306/sqoop \\

\--username root \\

\--password 123456 \\

\--table emp -m 1 \\

\--columns "empno,ename,job,sal,comm" \\

\--target-dir emp\_column \\

\--delete-target-dir

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 5][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 6][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 7][]

### 4、使用指定压缩格式及存储格式； ###

命令：

sqoop import \\

> --connect jdbc:mysql://192.168.159.170:3306/sqoop \\

> --username root \\

> --password 123456 \\

> --table emp \\

> -m 1 \\

> --columns "empno,ename,job,sal,comm" \\

> --target-dir emp\_parquet \\

> --delete-target-dir \\

> --as-parquetfile \\

> --compression-codec org.apache.hadoop.io.compress.SnappyCodec

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 8][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 9][]

### 5、使用指定分隔符； ###

命令：

sqoop import \\

\--connect jdbc:mysql://192.168.159.170:3306/sqoop \\

\--username root \\

\--password 123456 \\

\--table emp -m 1 \\

\--columns "EMPNO,ENAME,JOB,SAL,COMM" \\

\--target-dir emp\_colimn\_split \\

\--delete-target-dir \\

\--fields-terminated-by '\\t' \\

\--lines-terminated-by '\\n'

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 10][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 11][]

### 6、导入指定条件的数据； ###

命令：

sqoop import  \\

\--connect jdbc:mysql://192.168.159.170:3306/sqoop \\

\--username root \\

\--password 123456 \\

\--table emp -m 1 \\

\--columns "EMPNO,ENAME,JOB,SAL,COMM" \\

\--target-dir emp\_colimn\_where \\

\--delete-target-dir \\

\--where 'SAL>2000'

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 12][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 13][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 14][]

### 7、导入指定查询语句的数据； ###

命令：

sqoop import \\

\--connect jdbc:mysql://192.168.159.170:3306/sqoop \\

\--username root \\

\--passw 123456 \\

\--target-dir emp\_column\_query \\

\--delete-target-dir \\

\--query 'select \* from emp where EMPNO>=7900 and $CONIONS' \\

\--fields-terminated-by '\\t' \\

\--lines-terminated-by '\\n' -m 1 \\

\--split-by 'emp'

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 15][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 16][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 17][]

### 8、使用Sqoop导出HDFS数据到MySQL； ###

命令：

>create table emp\_demo as select \* from emp where 1=2;

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 18][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 19][]

命令：

$hdfs dfs -mkdir -p /usr/hadoop/emp

![20190618083317906.jpeg][]

命令：

sqoop export \\

\--connect jdbc:mysql://192.168.159.170:3306/sqoop \\

\--username root \\

\--password 123456 \\

\--table emp\_demo \\

\--export-dir /usr/hadoop/emp -m 1

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 20][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 21][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 22][]

### 9、导出指定字段 ###

命令：

hdfs dfs -mkdir -p /usr/hadoop/emp\_colum

hdfs dfs -ls /usr/hadoop/

![20190618083317968.jpeg][]

命令：

sqoop export \\

> --connect jdbc:mysql://192.168.159.170:3306/sqoop \\

> --username root \\

> --password 123456 \\

> --table emp\_demo \\

> --columns "EMPNO,ENAME,JOB,SAL,COMM" \\

> --export-dir /usr/hadoop/emp\_colum -m 1

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 23][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 24][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 25][]

### 10、导出表示指定分隔符 ###

命令：

hdfs dfs -mkdir -p /usr/hadoop/emp\_column\_split

hdfs dfs -ls /usr/hadoop/

![2019061808331869.jpeg][]

命令：

sqoop export \\

> --connect jdbc:mysql://192.168.159.170:3306/sqoop \\

> --username root \\

> --password 123456 \\

> --table emp\_demo \\

> --columns "EMPNO,ENAME,JOB,SAL,COMM" \\

> --export-dir /usr/hadoop/emp\_column\_split \\

> --fields-terminated-by '\\t' \\

> --lines-terminated-by '\\n' -m 1

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 26][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 27][]

### 11、批量导出 ###

命令：

sqoop export \\

> -Dsqoop.export.records.pre.statement=10 \\

> --connect jdbc:mysql://192.168.159.170:3306/sqoop \\

> --username root \\

> --password 123456 \\

> --table emp\_demo \\

> --export-dir /usr/hadoop/emp -m 1

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 28][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 29][]

### 12、使用Sqoop导入MySQL数据到Hive中 ###

命令：

sqoop create-hive-table \\

\--connect jdbc:mysql://192.168.159.170:3306/sqoop \\

\--username root \\

\--password 123456 \\

\--table emp \\

\--hive-table emp\_import

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 30][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 31][]

### 13、导入表的指定字段到Hive中 ###

命令：

create table emp\_column(empno int,ename string,job string,mgr int,hiredate string,sal double,comm double,deptno int) row format delimited fields terminated by '\\t' lines terminated by '\\n';

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 32][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 33][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 34][]

## **任务三：将常用的Sqoop脚本定义成作业，方便其他人调用(因为版本问题，此处使用sqoop2)** ##

### 1、进入sqoop-shell，创建MySQL数据库连接； ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 35][]

### 2、查看连接信息； ###

![20190618083353656.png][]

### 3、创建HDFS文件系统连接； ###

命令：

>create link -connector hdfs-connector

![20190618083353655.png][]

### 4、创建数据传输服务（从MySQL到hdfs）； ###

命令：

>create job f sqoop -t hdfs

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 36][]

### 5、启动job任务； ###

命令：

>start job -n jobsqoop

![20190618083353654.png][]

### 6、查看job任务状态； ###

命令：

>status job -n jobsqoop

![20190618083353657.png][]

# 出现的问题与解决方案 #

## **排错一**： ##

**错误：**导入指定查询语句的数据失败

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 37][]

**排错思路：**

1.  查看日志分析原因；
2.  根据报错提示分析

**原因分析：**参数query和table不能同时使用

**解决方案：**

命令：

sqoop import \\

\--connect jdbc:mysql://192.168.159.170:3306/sqoop \\

\--username root \\

\--passw 123456 \\

\--target-dir emp\_column\_query \\

\--delete-target-dir \\

\--query 'select \* from emp where EMPNO>=7900 and $CONIONS' \\

\--fields-terminated-by '\\t' \\

\--lines-terminated-by '\\n' -m 1 \\

\--split-by 'emp'

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 38][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 39][]

## **排错二：** ##

**错误**：测试sqoop1版本与mysql是否互通出错；

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 40][]

**排错思路：**

1.  分析日志及错误原因；
2.  分析错误提示

**原因分析：**缺少jar包；

**解决方案：**在sqoop的lib目录下加入所缺jar包，添加后正常；

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 41][]

# **知识拓展** #

sqoop 是 apache 旗下一款“Hadoop 和关系数据库服务器之间传送数据”的工具。

核心的功能有两个：

导入、迁入

导出、迁出

导入数据：MySQL，Oracle 导入数据到 Hadoop 的 HDFS、HIVE、HBASE 等数据存储系统

导出数据：从 Hadoop 的文件系统中导出数据到关系数据库 mysql 等 Sqoop 的本质还是一个命令行工具，和 HDFS，Hive 相比，并没有什么高深的理论。

sqoop：工具：本质就是迁移数据， 迁移的方式：就是把sqoop的迁移命令转换成MR程序

hive工具，本质就是执行计算，依赖于HDFS存储数据，把SQL转换成MR程序

2. 工作机制

将导入或导出命令翻译成 MapReduce 程序来实现 在翻译出的 MapReduce 中主要是对 InputFormat 和 OutputFormat 进行定制

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70]: /images/20220112/21835a836f094980a546b2d6bf282698.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 1]: /images/20220112/3287606265ab4f78b4fa5c7299877ea4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 2]: /images/20220112/3a6deff820f74703a3e12da3e5747b07.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 3]: /images/20220112/c2a4e214991d49caa30bc58c087c8e12.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 4]: /images/20220112/0ce02f5d3e1d4559aff4f527bf8547fa.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 5]: /images/20220112/7b55c62ebf9a4cf386ad16ffe8f71394.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 6]: https://img-blog.csdnimg.cn/20190618083232716.jpeg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 7]: /images/20220112/beab21ec4c004a7f895e38eaffdf0455.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 8]: https://img-blog.csdnimg.cn/20190618083232853.jpeg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 9]: /images/20220112/ee6f2a7b56184409af7036ba0ded95f6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 10]: https://img-blog.csdnimg.cn/20190618083232857.jpeg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 11]: /images/20220112/31af9e89f4a844c78066df19bbf41a71.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 12]: https://img-blog.csdnimg.cn/20190618083232837.jpeg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 13]: https://img-blog.csdnimg.cn/20190618083232750.jpeg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 14]: /images/20220112/49b16c5f177b4910abb45bf3188c3555.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 15]: https://img-blog.csdnimg.cn/20190618083318267.jpeg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 16]: https://img-blog.csdnimg.cn/20190618083318379.jpeg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 17]: /images/20220112/711586fc032a4fa9966277d396183756.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 18]: https://img-blog.csdnimg.cn/20190618083318231.jpeg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 19]: /images/20220112/31040cc5ab00433d92c4cd45d8d89b23.png
[20190618083317906.jpeg]: /images/20220112/5bd7e951717d49e58db471b72f42bef7.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 20]: https://img-blog.csdnimg.cn/20190618083318442.jpeg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 21]: https://img-blog.csdnimg.cn/20190618083318357.jpeg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 22]: /images/20220112/c000e913766845b8b0a6684b7123341a.png
[20190618083317968.jpeg]: /images/20220112/5532095b22b74514ba9ceef038dbedb9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 23]: https://img-blog.csdnimg.cn/20190618083318456.jpeg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 24]: https://img-blog.csdnimg.cn/20190618083318404.jpeg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 25]: /images/20220112/db3d87e7869f4cf2ac2fa4807917b42f.png
[2019061808331869.jpeg]: /images/20220112/f8825bea66d64793889b57408cc7fa5c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 26]: https://img-blog.csdnimg.cn/20190618083318469.jpeg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 27]: /images/20220112/d670eb7d64dd4e2aa600a197dcd055d0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 28]: https://img-blog.csdnimg.cn/20190618083318494.jpeg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 29]: /images/20220112/a4d83e5def2a4ab1b9e831606fac3c49.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 30]: https://img-blog.csdnimg.cn/20190618083318582.jpeg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 31]: /images/20220112/30a3796619f94beca43b30328c3ca136.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 32]: https://img-blog.csdnimg.cn/20190618083318361.jpeg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 33]: https://img-blog.csdnimg.cn/20190618083318600.jpeg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 34]: /images/20220112/2504caa339904eda9697a71d087a1b8c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 35]: /images/20220112/11e967d4aca2431296d87a00f377eeae.png
[20190618083353656.png]: /images/20220112/690a3150e29f4080a3bd83ae6c849e41.png
[20190618083353655.png]: /images/20220112/1987695c175f49a4afa2969444a56faf.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 36]: /images/20220112/70f1ec7d0e124e9484fbb914df3d83c2.png
[20190618083353654.png]: /images/20220112/27453dbf4c4143c395d4eaa1075ab7f6.png
[20190618083353657.png]: /images/20220112/2d3b61cf5c454c42a21050b1242a5406.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 37]: /images/20220112/19beccd0d40b47ec9ee82bfedb14702c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 38]: https://img-blog.csdnimg.cn/20190618083547858.jpeg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 39]: /images/20220112/812a510098ad4a2b854f33fd51eda992.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 40]: /images/20220112/f9c0d3658a824703912a103a986f3e17.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3ODIzNjA1_size_16_color_FFFFFF_t_70 41]: /images/20220112/b3052436751d4e7eb4ba0953c86ea32f.png