新一代数据湖存储技术Apache Paimon入门Demo,【原理+实战+视频+源码

先自我介绍一下,小编浙江大学毕业,去过华为、字节跳动等大厂,目前阿里P7

深知大多数程序员,想要提升技能,往往是自己摸索成长,但自己不成体系的自学效果低效又漫长,而且极易碰到天花板技术停滞不前!

因此收集整理了一份《2024年最新大数据全套学习资料》,初衷也很简单,就是希望能够帮助到想自学提升又不知道该从何学起的朋友。
img
img
img
img
img

既有适合小白学习的零基础资料,也有适合3年以上经验的小伙伴深入学习提升的进阶课程,涵盖了95%以上大数据知识点,真正体系化!

由于文件比较多,这里只是将部分目录截图出来,全套包含大厂面经、学习笔记、源码讲义、实战项目、大纲路线、讲解视频,并且后续会持续更新

如果你需要这些资料,可以添加V获取:vip204888 (备注大数据)
img

正文

    tableEnv.executeSql("CREATE TEMPORARY TABLE IF NOT EXISTS word_table_api (\n" +
            "    word STRING\n" +
            ") WITH (\n" +
            "    'connector' = 'datagen',\n" +
            "    'fields.word.length' = '1'\n" +
            ")");

    // tableEnv.executeSql("SET 'execution.checkpointing.interval' = '10 s'");

    tableEnv.executeSql("INSERT INTO word_count_api SELECT word, COUNT(*) FROM word_table_api GROUP BY word");

    env.execute();
}

}


#### 2.2 IDEA中成功运行


![](https://img-blog.csdnimg.cn/c8fdab5d232f4e06bce0dd4c5b2af0ab.png)


### 3、IDEA中Stream读写


#### 3.1 流写


代码:



package com.study.flink.table.paimon.demo;

import org.apache.flink.streaming.api.environment.StreamExecutionEnvironment;
import org.apache.flink.table.api.StatementSet;
import org.apache.flink.table.api.TableEnvironment;
import org.apache.flink.table.api.bridge.java.StreamTableEnvironment;

/**

  • @Author: YK.Leo
  • @Date: 2023-05-17 11:11
  • @Version: 1.0
    */

// succeed at local !!!
public class OfficeStreamsWriteV2 {
public static void main(String[] args) throws Exception {
StreamExecutionEnvironment env = StreamExecutionEnvironment.getExecutionEnvironment();

    env.setParallelism(1);
    env.enableCheckpointing(10000L);
    env.getCheckpointConfig().setCheckpointStorage("file:/D:/tmp/paimon/");

    TableEnvironment tableEnv = StreamTableEnvironment.create(env);


    // 0. Create a Catalog and a Table
    tableEnv.executeSql("CREATE CATALOG my_catalog_local WITH (\n" +
            "    'type'='paimon',\n" +                           // todo: !!!
            "    'warehouse'='file:///D:/tmp/paimon'\n" +
            ")");

    tableEnv.executeSql("USE CATALOG my_catalog_local");

    tableEnv.executeSql("CREATE DATABASE IF NOT EXISTS my_catalog_local.local_db");
    tableEnv.executeSql("USE local_db");

    // drop tbl
    tableEnv.executeSql("DROP TABLE IF EXISTS paimon_tbl_streams");
    tableEnv.executeSql("CREATE TABLE IF NOT EXISTS paimon_tbl_streams(\n"
            + " uuid bigint,\n"
            + " name VARCHAR(3),\n"
            + " age int,\n"
            + " ts TIMESTAMP(3),\n"
            + " dt VARCHAR(10), \n"
            + " PRIMARY KEY (dt, uuid) NOT ENFORCED \n"
            + ") PARTITIONED BY (dt) \n"
            + " WITH (\n" +
            "    'merge-engine' = 'partial-update',\n" +
            "    'changelog-producer' = 'full-compaction', \n" +
            "    'file.format' = 'orc', \n" +
            "    'scan.mode' = 'compacted-full', \n" +
            "    'bucket' = '5', \n" +
            "    'sink.parallelism' = '5', \n" +
            "    'sequence.field' = 'ts' \n" +   // todo, to check
            ")"
    );

    // datagen ====================================================================
    tableEnv.executeSql("CREATE TEMPORARY TABLE IF NOT EXISTS source_A (\n" +
            " uuid bigint PRIMARY KEY NOT ENFORCED,\n" +
            " `name` VARCHAR(3)," +
            " _ts1 TIMESTAMP(3)\n" +
            ") WITH (\n" +
            " 'connector' = 'datagen', \n" +
            " 'fields.uuid.kind'='sequence',\n" +
            " 'fields.uuid.start'='0', \n" +
            " 'fields.uuid.end'='1000000', \n" +
            " 'rows-per-second' = '1' \n" +
            ")");
    tableEnv.executeSql("CREATE TEMPORARY TABLE IF NOT EXISTS source_B (\n" +
            " uuid bigint PRIMARY KEY NOT ENFORCED,\n" +
            " `age` int," +
            " _ts2 TIMESTAMP(3)\n" +
            ") WITH (\n" +
            " 'connector' = 'datagen', \n" +
            " 'fields.uuid.kind'='sequence',\n" +
            " 'fields.uuid.start'='0', \n" +
            " 'fields.uuid.end'='1000000', \n" +
            " 'rows-per-second' = '1' \n" +
            ")");

    //
    //tableEnv.executeSql("insert into paimon_tbl_streams(uuid, name, _ts1) select uuid, concat(name,'_A') as name, _ts1 from source_A");
    //tableEnv.executeSql("insert into paimon_tbl_streams(uuid, age, _ts1) select uuid, concat(age,'_B') as age, _ts1 from source_B");
    StatementSet statementSet = tableEnv.createStatementSet();
    statementSet
            .addInsertSql("insert into paimon_tbl_streams(uuid, name, ts, dt) select uuid, name, _ts1 as ts, date_format(_ts1,'yyyy-MM-dd') as dt from source_A")
            .addInsertSql("insert into paimon_tbl_streams(uuid, age, dt) select uuid, age, date_format(_ts2,'yyyy-MM-dd') as dt from source_B")
            ;

    statementSet.execute();
    // env.execute();
}

}


结果:


![](https://img-blog.csdnimg.cn/56d9290f711c47e7bf18c2ee69e15644.png)


       如果只有一个流,上述代码完全没有问题【仅作为write demo一个流即可】,两个流会出现“写冲突”问题!


如下:


![](https://img-blog.csdnimg.cn/2cd69062d45f4510b34a85ff71a3d3d5.png)


        使用了官网的方法:[Dedicated Compaction Job]( ),似乎并没有奏效,至于解决方法请看下文 “**二、进阶:本地(IDEA)多流拼接测试**”; 


#### 3.2 流读(toChangeLogStream)


代码:



package com.study.flink.table.paimon.demo;

import org.apache.flink.api.common.functions.FilterFunction;
import org.apache.flink.streaming.api.datastream.DataStream;
import org.apache.flink.streaming.api.environment.StreamExecutionEnvironment;
import org.apache.flink.table.api.Schema;
import org.apache.flink.table.api.Table;
import org.apache.flink.table.api.TableEnvironment;
import org.apache.flink.table.api.bridge.java.StreamTableEnvironment;
import org.apache.flink.table.connector.ChangelogMode;
import org.apache.flink.types.Row;
import org.apache.flink.types.RowKind;
import org.apache.logging.log4j.LogManager;
import org.apache.logging.log4j.Logger;

/**

  • @Author: YK.Leo
  • @Date: 2023-05-15 18:50
  • @Version: 1.0
    */

// 流读单表OK!
public class OfficeStreamReadV1 {

public static final Logger LOGGER = LogManager.getLogger(OfficeStreamReadV1.class);

public static void main(String[] args) throws Exception {
    StreamExecutionEnvironment env = StreamExecutionEnvironment.getExecutionEnvironment();

    env.setParallelism(1);
    env.enableCheckpointing(10000L);
    env.getCheckpointConfig().setCheckpointStorage("file:/D:/tmp/paimon/");

    TableEnvironment tableEnv = StreamTableEnvironment.create(env);


    // 0. Create a Catalog and a Table
    tableEnv.executeSql("CREATE CATALOG my_catalog_local WITH (\n" +
            "    'type'='paimon',\n" +                           // todo: !!!
            "    'warehouse'='file:///D:/tmp/paimon'\n" +
            ")");

    tableEnv.executeSql("USE CATALOG my_catalog_local");

    tableEnv.executeSql("CREATE DATABASE IF NOT EXISTS my_catalog_local.local_db");
    tableEnv.executeSql("USE local_db");

    // 不需要再次创建表

    // convert to DataStream
    // Table table = tableEnv.sqlQuery("SELECT * FROM paimon_tbl_streams");
    Table table = tableEnv.sqlQuery("SELECT * FROM paimon_tbl_streams WHERE name is not null and age is not null");
    // DataStream<Row> dataStream = ((StreamTableEnvironment) tableEnv).toChangelogStream(table);
    // todo : doesn't support consuming update and delete changes which is produced by node TableSourceScan
    // DataStream<Row> dataStream = ((StreamTableEnvironment) tableEnv).toDataStream(table);
    // 剔除 -U 数据(即:更新前的数据不需要重新发送,剔除)!!!
    DataStream<Row> dataStream = ((StreamTableEnvironment) tableEnv)
            .toChangelogStream(table, Schema.newBuilder().primaryKey("dt","uuid").build(), ChangelogMode.upsert())
            .filter(new FilterFunction<Row>() {
                @Override
                public boolean filter(Row row) throws Exception {
                    boolean isNoteUpdateBefore = !(row.getKind().equals(RowKind.UPDATE_BEFORE));
                    if (!isNoteUpdateBefore) {
                        LOGGER.info("UPDATE_BEFORE: " + row.toString());
                    }
                    return isNoteUpdateBefore;
                }
            })
            ;

    // use this datastream
    dataStream.executeAndCollect().forEachRemaining(System.out::println);

    env.execute();
}

}


结果:


![](https://img-blog.csdnimg.cn/69fb1657b5c744189a57725f10513310.png)


## 


## 二、进阶:本地(IDEA)多流拼接测试


#### 要解决的问题:


        多个流拥有相同的主键,每个流更新除主键外的部分字段,通过主键完成多流拼接。


#### note:


        如果是两个Flink Job 或者 两个 pipeline 写同一个paimon表,则直接会产生conflict,其中一条流不断exception、重启;


        可以使用 “UNION ALL” 将多个流合并为一个流,最终一个Flink job写paimon表;


        使用主键表,'merge-engine' = 'partial-update' ;


### 1、'changelog-producer' = 'full-compaction'


#### (1)multiWrite代码



package com.study.flink.table.paimon.multi;

import org.apache.flink.streaming.api.environment.StreamExecutionEnvironment;
import org.apache.flink.table.api.StatementSet;
import org.apache.flink.table.api.TableEnvironment;
import org.apache.flink.table.api.bridge.java.StreamTableEnvironment;

/**

  • @Author: YK.Leo
  • @Date: 2023-05-18 10:17
  • @Version: 1.0
    */

// Succeed as local !!!
// 而且不会产生conflict,跑5分钟没有任何异常(公司跑几天无异常)! 数据也可以在另一个job流读!
public class MultiStreamsUnionWriteV1 {
public static void main(String[] args) throws Exception {
StreamExecutionEnvironment env = StreamExecutionEnvironment.getExecutionEnvironment();
env.setParallelism(1);
env.enableCheckpointing(10*1000L);
env.getCheckpointConfig().setCheckpointStorage(“file:/D:/tmp/paimon/”);
TableEnvironment tableEnv = StreamTableEnvironment.create(env);

    // 0. Create a Catalog and a Table
    tableEnv.executeSql("CREATE CATALOG my_catalog_local WITH (\n" +
            "    'type'='paimon',\n" +                           // todo: !!!
            "    'warehouse'='file:///D:/tmp/paimon'\n" +
            ")");
    tableEnv.executeSql("USE CATALOG my_catalog_local");

    tableEnv.executeSql("CREATE DATABASE IF NOT EXISTS my_catalog_local.local_db");
    tableEnv.executeSql("USE local_db");

    // drop & create tbl
    tableEnv.executeSql("DROP TABLE IF EXISTS paimon_tbl_streams");
    tableEnv.executeSql("CREATE TABLE IF NOT EXISTS paimon_tbl_streams(\n"
            + " uuid bigint,\n"
            + " name VARCHAR(3),\n"
            + " age int,\n"
            + " ts TIMESTAMP(3),\n"
            + " dt VARCHAR(10), \n"
            + " PRIMARY KEY (dt, uuid) NOT ENFORCED \n"
            + ") PARTITIONED BY (dt) \n"
            + " WITH (\n" +
            "    'merge-engine' = 'partial-update',\n" +
            "    'changelog-producer' = 'full-compaction', \n" +
            "    'file.format' = 'orc', \n" +
            "    'scan.mode' = 'compacted-full', \n" +
            "    'bucket' = '5', \n" +
            "    'sink.parallelism' = '5', \n" +
            // "    'write_only' = 'true', \n" +
            "    'sequence.field' = 'ts' \n" +   // todo, to check
            ")"
    );

    // datagen ====================================================================
    tableEnv.executeSql("CREATE TEMPORARY TABLE IF NOT EXISTS source_A (\n" +
            " uuid bigint PRIMARY KEY NOT ENFORCED,\n" +
            " `name` VARCHAR(3)," +
            " _ts1 TIMESTAMP(3)\n" +
            ") WITH (\n" +
            " 'connector' = 'datagen', \n" +
            " 'fields.uuid.kind'='sequence',\n" +
            " 'fields.uuid.start'='0', \n" +
            " 'fields.uuid.end'='1000000', \n" +
            " 'rows-per-second' = '1' \n" +
            ")");
    tableEnv.executeSql("CREATE TEMPORARY TABLE IF NOT EXISTS source_B (\n" +
            " uuid bigint PRIMARY KEY NOT ENFORCED,\n" +
            " `age` int," +
            " _ts2 TIMESTAMP(3)\n" +
            ") WITH (\n" +
            " 'connector' = 'datagen', \n" +
            " 'fields.uuid.kind'='sequence',\n" +
            " 'fields.uuid.start'='0', \n" +
            " 'fields.uuid.end'='1000000', \n" +
            " 'rows-per-second' = '1' \n" +
            ")");

    //
    StatementSet statementSet = tableEnv.createStatementSet();
    String sqlText = "INSERT INTO paimon_tbl_streams(uuid, name, age, ts, dt) \n" +
            "select uuid, name, cast(null as int) as age, _ts1 as ts, date_format(_ts1,'yyyy-MM-dd') as dt from source_A \n" +
            "UNION ALL \n" +
            "select uuid, cast(null as string) as name, age, _ts2 as ts, date_format(_ts2,'yyyy-MM-dd') as dt from source_B"
            ;
    statementSet.addInsertSql(sqlText);

    statementSet.execute();
}

}


读代码同上。


#### (2)读延迟


        即:从client数据落到paimon,完成与server的join,再到被Flink-paimon流读到的时间延迟;


       **分钟级别延迟**!


### 2、'changelog-producer' = 'lookup'


读写同上,建表时修改参数即可: changelog-producer='lookup',与此匹配的scan-mode需要分别配置为 'latest' ;


lookup延迟性可能会更低,但是数据质量有待验证。



**note:**


经测试,在企业生产环境中full-compaction模式目前一切稳定(两条join的流QPS约3K左右,延迟2-3分钟)。


         99.9%的数据延迟在2-3分钟;


        (multiWrite的checkpoint间隔为60s时)


![](https://img-blog.csdnimg.cn/96b644ab0d2f40a0921f9b8cbb268752.png)



## 三、可能遇到的问题


1. Caused by: java.lang.ClassCastException: org.codehaus.janino.CompilerFactory cannot be cast to org.codehaus.commons.compiler.ICompilerFactory


原因:org.codehaus.janino 依赖冲突,


办法:全部exclude掉


<exclude>org.codehaus.janino:\*</exclude>


**网上学习资料一大堆,但如果学到的知识不成体系,遇到问题时只是浅尝辄止,不再深入研究,那么很难做到真正的技术提升。**

**需要这份系统化的资料的朋友,可以添加V获取:vip204888 (备注大数据)**
![img](https://img-blog.csdnimg.cn/img_convert/c63eefb35c0eb3640e7013777e5675f4.png)

**一个人可以走的很快,但一群人才能走的更远!不论你是正从事IT行业的老鸟或是对IT行业感兴趣的新人,都欢迎加入我们的的圈子(技术交流、学习资源、职场吐槽、大厂内推、面试辅导),让我们一起学习成长!**

.CompilerFactory cannot be cast to org.codehaus.commons.compiler.ICompilerFactory


原因:org.codehaus.janino 依赖冲突,


办法:全部exclude掉


<exclude>org.codehaus.janino:\*</exclude>


**网上学习资料一大堆,但如果学到的知识不成体系,遇到问题时只是浅尝辄止,不再深入研究,那么很难做到真正的技术提升。**

**需要这份系统化的资料的朋友,可以添加V获取:vip204888 (备注大数据)**
[外链图片转存中...(img-X1zQ3qTz-1713410309693)]

**一个人可以走的很快,但一群人才能走的更远!不论你是正从事IT行业的老鸟或是对IT行业感兴趣的新人,都欢迎加入我们的的圈子(技术交流、学习资源、职场吐槽、大厂内推、面试辅导),让我们一起学习成长!**

  • 3
    点赞
  • 5
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
为什么要学习这门课程?·新一代流式数据湖技术组件深入讲解,帮助你快速构造数据湖知识体系。·为构建湖仓一体架构提供底层技术支撑。本课程将从原理、架构、底层存储细节、性能优化、管理等层面对Paimon流式数据湖组件进行详细讲解,原理+实战,帮助你快速上手使用数据湖技术。讲师介绍华为HCIP认证大数据高级工程师北京猎豹移动大数据技术专家中科院大数据研究院大数据技术专家51CTO企业IT学院优秀讲师电子工业出版社2022年度优秀作者出版书籍:《Flink入门实战》、《大数据技术及架构图解实战派》。本课程提供配套课件、软件、试题、以及源码。课程内容介绍:1、什么是Apache Paimon2、Paimon的整体架构3、Paimon的核心特点4、Paimon支持的生态5、基于Flink SQL操作Paimon6、基于Flink DataStream API 操作Paimon7、Paimon中的内部表和外部表8、Paimon中的分区表和临时表9、Paimon中的Primary Key表(主键表)10、Paimon中的Append Only表(仅追加表)11、Changelog Producers原理及案例实战12、Merge Engines原理及案例实战13、Paimon中的Catalog详解14、Paimon中的Table详解15、Paimon之Hive Catalog的使用16、动态修改Paimon表属性17、查询Paimon系统表18、批量读取Paimon表19、流式读取Paimon表20、流式读取高级特性Consumer ID21、Paimon CDC数据摄取功能22、CDC之MySQL数据同步到Paimon23、CDC之Kafka数据同步到Paimon24、CDC高级特性之Schema模式演变25、CDC高级特性之计算列26、CDC高级特性之特殊的数据类型映射27、CDC高级特性之中文乱码28、Hive引擎集成Paimon29、在Hive中配置Paimon依赖30、在Hive中读写Paimon表31、在Hive中创建Paimon表32、Hive和Paimon数据类型映射关系33、Paimon底层文件基本概念34、Paimon底层文件布局35、Paimon底层文件操作详解36、Flink流式写入Paimon表过程分析37、读写性能优化详细分析38、Paimon中快照、分区、小文件的管理39、管理标签(自动管理+手工管理)40、管理Bucket(创建+删除+回滚)

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值