How GoTerra Cut Costs and Boost Speed: BigQuery‑to‑MaxCompute Performance Secrets

This article details the real‑world migration of a leading Southeast Asian tech group from BigQuery to MaxCompute, exposing the three major challenges, the data‑driven performance‑optimization methodology, and the concrete techniques—Auto Partition, UNNEST redesign, large‑query graph optimizations, and intelligent tuning—that delivered dramatic cost reductions and query‑speed gains.

Auto PartitionBig DataData Warehouse Migration

0 likes · 17 min read

How GoTerra Cut Costs and Boost Speed: BigQuery‑to‑MaxCompute Performance Secrets

StarRocks

Sep 30, 2021 · Databases

Master StarRocks Lateral Join & Unnest for Efficient Row‑to‑Column Transformations

StarRocks 1.18 introduces Lateral Join + Unnest for elegant row‑to‑multiple‑row conversion, Fast Decimal with up to 38‑digit precision and 4× faster arithmetic, extensive Bitmap function enhancements, and a suite of import, storage, operator, and ecosystem optimizations that dramatically boost query performance and scalability.

Bitmap OptimizationFast DecimalLATERAL JOIN

0 likes · 7 min read

Master StarRocks Lateral Join & Unnest for Efficient Row‑to‑Column Transformations

Qunar Tech Salon

Apr 27, 2015 · Databases

Using PostgreSQL unnest to Filter Travel Island Destinations from a Comma‑Separated Field

This article explains how to leverage PostgreSQL's unnest and string_to_array functions to split a comma‑separated 'arrive' column and efficiently query for popular island destinations such as Maldives, Phuket, Bali, and others without writing complex regular expressions.

Database QueryUnnestpostgresql

0 likes · 4 min read

Using PostgreSQL unnest to Filter Travel Island Destinations from a Comma‑Separated Field