from Hacker News

Lakehouse: New Open Platforms That Unify Data Warehousing and Advanced Analytics [pdf]

by solidangle on 12/22/20, 5:57 PM with 9 comments

• by georgewfraser on 12/22/20, 6:42 PM

  What is not said in this article is that you can use modern data warehouses, like Snowflake and BigQuery, in the exact same way: a single system that serves as both your data lake and your data warehouse. Databricks and the cloud data warehouses are rapidly converging. Databricks has enough SQL functionality that it can be reasonably be called an RDBMS, and Snowflake has demonstrated that you can incorporate the benefits of a data lake into a data warehouse by separating compute from storage. At this point, the main difference is that with Databricks you can directly access the underlying Parquet files in S3. Does that matter? For some users, yes.

• by MrPowers on 12/22/20, 6:56 PM

  Some additional context:

  * Companies are querying thousands / tens of thousands of Parquet files stored in the cloud via Spark

  * Parquet lakes can be partitioned which works well for queries that filter on the partitioned key (and slows down queries that don't filter on the partition key)

  * Parquet files contain min/max metadata for all columns. When possible, entire files are skipped, but this is relatively rare. This is called predicate pushdown filtering.

  * Parquet files allow for the addition of custom metadata, but Spark doesn't let users use the custom metadata when filtering

  * Spark is generally bad at joining two big tables (it's good at broadcast joins, generally when one of the tables is 2GB or less)

  * Companies like Snowflake & Memsql have Spark connectors that let certain parts of queries get pushed down.

  There is a huge opportunity to build a massive company on data lakes optimized for Spark. The amount of wasted compute cycles filtering over files that don't have any data relevant to the query is staggering.

• by Zaheer on 12/22/20, 7:25 PM

  I thought this was a good article on building a Lakehouse on AWS: https://aws.amazon.com/blogs/big-data/harness-the-power-of-y...

  It's high level and focuses on some of the business needs for requiring this sort of architecture.