Database, Data Engineering, Data Analytics, Open Source.
what we could be looking at: Data volume: 360 million rows of fact table data per year, approximately 1 million rows/day; Typical query scenario: Joining a month’s fact table data (30 million rows) with a small dimension table (tens of thousands of rows), then performing aggregation calculations