News for hackers. Stuff that matters.
Re:Pg_lakehouse: Query Any Data Lake from Postgres by kiwicopple on Monday May 13, 2024 @03:38PM (#40347415)
Neat that you plan to support both Delta Lake and Apache Iceberg

I'm curious about HN's position between these two formats? I'm having a hard time deciphering which might be the industry winner (or perhaps they both have a place, no "winner" necessary)

Re:Pg_lakehouse: Query Any Data Lake from Postgres by retakeming on Monday May 13, 2024 @03:57PM (#40347629)
This is anecdotal, but I feel that we (ParadeDB) have received more requests for Iceberg integration vs. Delta Lake. We were actually hesitant to launch pg_lakehouse without Iceberg support, but pulled the trigger on it because the iceberg-rust crate is still in its early days. We will probably be contributing to iceberg-rust to make it work with pg_lakehouse.
Re:Pg_lakehouse: Query Any Data Lake from Postgres by lukekim on Monday May 13, 2024 @04:43PM (#40348180)
Also anecdotal, but we (Spice AI) see more requests for Iceberg, but in practice more deployments of Delta Lake.
Re:Pg_lakehouse: Query Any Data Lake from Postgres by FridgeSeal on Monday May 13, 2024 @06:52PM (#40349508)
My theory is that everyone would _prefer_ to use Iceberg, but isn’t as widely supported _yet_, so they’re stuck with Delta in the interim.
Re:Pg_lakehouse: Query Any Data Lake from Postgres by philippemnoel on Tuesday May 14, 2024 @12:58PM (#40357309)
I think you're spot on
Re:Pg_lakehouse: Query Any Data Lake from Postgres by kiwicopple on Monday May 13, 2024 @04:00PM (#40347656)
> We will probably be contributing to iceberg-rust to make it work with pg_lakehouse

That's great news, thanks for your contributions to open source (here, and all the other extensions)

Re:Pg_lakehouse: Query Any Data Lake from Postgres by kcirerick on Monday May 13, 2024 @04:09PM (#40347786)
I'm also building in the lakehouse space and anecdotally have seen more excitement around Iceberg over delta lake just because of its completely open source origins. Iceberg has evolved faster and has had more contributions from a more diverse set of contributors than Delta Lake. Not sure if this will change with a Snowflake <> Tabular acquisition but I'd easily bet on Iceberg if current trends continue.
Re:Pg_lakehouse: Query Any Data Lake from Postgres by philippemnoel on Monday May 13, 2024 @04:39PM (#40348129)
We agree. We plan to bring Iceberg support as a first-class citizen as soon as we can, but unfortunately the support in Rust these days is still limited. We and the community are working on it
Re:Pg_lakehouse: Query Any Data Lake from Postgres by slap_shot on Monday May 13, 2024 @04:05PM (#40347727)
There isn't a winner and there likely won't be one (at least not for a long time). Tabular will likely be acquired by Snowflake and the two industry behemoths now back their own formats, and each will treat their own as a first class citizen.
Re:Pg_lakehouse: Query Any Data Lake from Postgres by philippemnoel on Monday May 13, 2024 @05:09PM (#40348455)
Agreed, this is why we want to support both. Maybe even Apache Hudi down the line. But I hope the industry converges to a main standard rather than Snowflake/Databricks fighting for their own formats. They can differentiate on much more meaningful features
Re:Pg_lakehouse: Query Any Data Lake from Postgres by jaychia on Tuesday May 14, 2024 @12:12AM (#40351543)
There’s a lot of interesting work happening in this area (see: XTable).

We are building a Python distributed query engine, and share a lot of the same frustrations… in fact until quite recently most of the table formats only had JVM client libraries and so integrating it purely natively with Daft was really difficult.

We finally managed to get read integrations across Iceberg/DeltaLake/Hudi recently as all 3 now have Python/Rust-facing APIs. Funny enough, the only non-JVM implementation of Hudi was contributed by the Hudi team and currently still lives in our repo :D (https://github.com/Eventual-Inc/Daft/tree/main/daft/hudi/pyh...)

It’s still the case that these libraries still lag behind their JVM counterparts though, so it’s going to be a while before we see full support across the full featureset of each table format. But we’re definitely seeing a large appetite for working with table formats outside of the JVM ecosystem (e.g. in Python and Rust)

Re:Pg_lakehouse: Query Any Data Lake from Postgres by philippemnoel on Tuesday May 14, 2024 @12:21AM (#40351585)
Are you using the iceberg-rust crate for Rust? It's a rather young project, have you found it sufficient for your needs (if using)?
Re:Pg_lakehouse: Query Any Data Lake from Postgres by sammysidhu on Tuesday May 14, 2024 @05:03PM (#40360147)
We're actually using pyiceberg to retrieve metadata! All our IO and decoding happens in the rust side once the data has been passthrough.

We expose something called a ScanOperator which allows integration into various catalogs through a thin layer that exposes ScanTasks.

Iceberg's impl: https://github.com/Eventual-Inc/Daft/blob/416009138359a9d410...