LakeSoul

LakeSoul

LakeSoul is an end-to-end, realtime and cloud native Lakehouse framework with fast data ingestion, concurrent update and incremental data analytics on cloud storages for both BI and AI applications.

Stars: 2364

Visit
 screenshot

LakeSoul is a cloud-native Lakehouse framework that supports scalable metadata management, ACID transactions, efficient and flexible upsert operation, schema evolution, and unified streaming & batch processing. It supports multiple computing engines like Spark, Flink, Presto, and PyTorch, and computing modes such as batch, stream, MPP, and AI. LakeSoul scales metadata management and achieves ACID control by using PostgreSQL. It provides features like automatic compaction, table lifecycle maintenance, redundant data cleaning, and permission isolation for metadata.

README:

LakeSoul

LF AI & Data Sandbox Project

OpenSSF Best Practices

Maven Test Flink CDC Test Build

中文介绍

LakeSoul is a cloud-native Lakehouse framework that supports scalable metadata management, ACID transactions, efficient and flexible upsert operation, schema evolution, and unified streaming & batch processing.

LakeSoul supports multiple computing engines to read and write lake warehouse table data, including Spark, Flink, Presto, and PyTorch, and supports multiple computing modes such as batch, stream, MPP, and AI. LakeSoul supports storage systems such as HDFS and S3.

LakeSoul Arch

LakeSoul was originally created by DMetaSoul company and was donated to Linux Foundation AI & Data as a sandbox project since May 2023.

LakeSoul implements incremental upserts for both row and column and allows concurrent updates.

LakeSoul uses LSM-Tree like structure to support updates on hash partitioning table with primary key, and achieves very high write throughput while providing optimized merge on read performance (refer to Performance Benchmarks). LakeSoul scales metadata management and achieves ACID control by using PostgreSQL.

LakeSoul uses Rust to implement the native metadata layer and IO layer, and provides C/Java/Python interfaces to support the connecting of multiple computing frameworks such as big data and AI.

LakeSoul supports concurrent batch or streaming read and write. Both read and write supports CDC semantics, and together with auto schema evolution and exacly-once guarantee, constructing realtime data warehouses is made easy.

LakeSoul supports multi-workspace and RBAC. LakeSoul uses Postgres's RBAC and row-level security policies to implement permission isolation for metadata. Together with Hadoop users and groups, physical data isolation can be achieved. LakeSoul's permission isolation is effective for SQL/Java/Python jobs.

LakeSoul supports automatic disaggregated compaction, automatic table life cycle maintenance, and automatic redundant data cleaning, reducing operation costs and improving usability.

More detailed features please refer to our doc page: Documentations

Quick Start

Follow the Quick Start to quickly set up a test env.

Tutorials

Please find tutorials in doc site:

Usage Documentations

Please find usage documentations in doc site: Usage Doc

快速开始

教程

使用文档

Feature Roadmap

  • Data Science and AI
    • [x] Native Python Reader (without PySpark)
    • [x] PyTorch Dataset and distributed training
  • Meta Management (#23)
    • [x] Multiple Level Partitioning: Multiple range partition and at most one hash partition
    • [x] Concurrent write with auto conflict resolution
    • [x] MVCC with read isolation
    • [x] Write transaction (two-stage commit) through Postgres Transaction
    • [x] Schema Evolution: Column add/delete supported
  • Table operations
    • [x] LSM-Tree style upsert for hash partitioned table
    • [x] Merge on read for hash partition with upsert delta file
    • [x] Copy on write update for non hash partitioned table
    • [x] Automatic Disaggregated Compaction Service
  • Data Warehousing
    • [x] CDC stream ingestion with auto ddl sync
    • [x] Incremental and Snapshot Query
      • [x] Snapshot Query (#103)
      • [x] Incremental Query (#103)
      • [x] Incremental Streaming Source (#130)
      • [x] Flink Stream/Batch Source
    • [x] Multi Workspaces and RBAC
  • Spark Integration
    • [x] Table/Dataframe API
    • [x] SQL support with catalog except upsert
    • [x] Query optimization
      • [x] Shuffle/Join elimination for operations on primary key
    • [x] Merge UDF (Merge operator)
    • [ ] Merge Into SQL support
      • [x] Merge Into SQL with match on Primary Key (Merge on read)
      • [ ] Merge Into SQL with match on non-pk
      • [ ] Merge Into SQL with match condition and complex expression (Merge on read when match on PK) (depends on #66)
  • Flink Integration and CDC Ingestion (#57)
    • [x] Table API
      • [x] Batch/Stream Sink
      • [x] Batch/Stream source
      • [x] Stream Source/Sink for ChangeLog Stream Semantics
      • [x] Exactly Once Source and Sink
    • [x] Flink CDC
      • [x] Auto Schema Change (DDL) Sync
      • [x] Auto Table Creation (depends on #78)
      • [x] Support sink multiple source tables with different schemas (#84)
  • Hive Integration
    • [x] Export to Hive partition after compaction
    • [x] Apache Kyuubi (Hive JDBC) Integration
  • Realtime Data Warehousing
    • [x] CDC ingestion
    • [x] Time Travel (Snapshot read)
    • [x] Snapshot rollback
    • [x] Automatic global compaction service
    • [ ] MPP Engine Integration (depends on #66)
      • [x] Presto
      • [ ] Trino
  • Cloud and Native IO (#66)
    • [x] Object storage IO optimization
    • [x] Native merge on read
    • [ ] Multi-layer storage classes support with data tiering

Community guidelines

Community guidelines

Feedback and Contribution

Please feel free to open an issue or dicussion if you have any questions.

Join our Discord server for discussions.

Contact Us

Email us at [email protected].

Opensource License

LakeSoul is opensourced under Apache License v2.0.

For Tasks:

Click tags to check more tools for each tasks

For Jobs:

Alternative AI tools for LakeSoul

Similar Open Source Tools

For similar tasks

For similar jobs