All 151 articles, sorted alphabetically
Cloudera Data Warehouse (CDW)
Impala as managed service on Cloudera.
Read article →Hive 3 ACID Improvements
Default managed = ACID.
Read article →Hive 4 Key Features
Iceberg + storage handler + SQL compliance.
Read article →Hive ACID Transactions
How Hive supports ACID transactions with delta files and lock manager, enabling INSERT, UPDATE, DELETE, and MERGE.
Read article →Hive ACID architecture
Deep-dive on Hive ACID transactions: write IDs and snapshot isolation, delta and delete-delta layout with hidden row IDs, MERGE mechanics, lock manage…
Read article →Hive Architecture Deep Dive
The internal architecture of Hive: how HiveServer2, the driver, compiler stages, and metastore cooperate to run SQL over HDFS.
Read article →Hive Authorization
How Hive authorization works: legacy storage-based vs SQL standard vs Ranger integration.
Read article →Hive Backup + Restore Strategies
How to back up Hive tables + metastore + restore.
Read article →Beeline vs Hive CLI
Modern (JDBC) vs legacy client.
Read article →Hive Bucketing
How Hive bucketing hashes rows into a fixed number of files, and when it enables sort-merge bucket joins for big-to-big joins.
Read article →Hive bucketing
Deep-dive on Hive bucketing: CLUSTERED BY hashing into fixed bucket files, bucket map and sort-merge-bucket joins without shuffle, TABLESAMPLE samplin…
Read article →Hive Bucketing for Efficient Joins
SMB — sort-merge-bucket.
Read article →Hive Table Buckets
Hash-based sub-partition. Efficient joins + sampling.
Read article →Hive Cost-Based Optimizer (Calcite)
Choose plan based on stats.
Read article →Hive CBO architecture
Deep-dive on Hive's cost-based optimizer: Calcite RelNode pipeline, predicate pushdown and partition pruning, NDV-based cardi…
Read article →Columnar Advantages for Hive
Projection + compression + vectorized reads.
Read article →Hive ACID Compaction
How the ACID compactor merges delta files into base files, why it's a separate service from HDFS compaction, and how to tune it.
Read article →Hive Complex Types
Nested data support.
Read article →Hive Compression Options
Snappy, GZ, Zstd, LZ4 codecs.
Read article →Hive Deprecated Features
Indexes, MR engine, some SerDes.
Read article →Hive dynamic partitioning
Deep-dive on Hive dynamic partitioning: static vs dynamic keys and trailing-column binding, DISTRIBUTE BY for file-count control, max-partition guardr…
Read article →Hive Execution Engines
MR, Tez, Spark. Choose per workload.
Read article →Hive File Formats
The file formats Hive supports and their trade-offs: row-based vs columnar, compression, schema evolution, splittability.
Read article →Hive Future
Hive's role shifting.
Read article →HiveServer2 architecture
Deep-dive on HiveServer2: Thrift transports and session/operation managers, async execution over Tez session pools and LLAP, result fetch and spooling…
Read article →Apache Iceberg -- the open table format for the lakehouse
Deep-dive on Apache Iceberg: layered metadata (catalog/manifest/data files), immutable snapshots, ACID via atomic pointer swaps, time travel, hidden p…
Read article →Hive → Iceberg Migration
Convert existing tables. Metadata rewrite.
Read article →Hive + Iceberg Tables
Modern table format on Hive.
Read article →Hive vs Impala
Direct comparison of Hive vs Impala for different workloads.
Read article →Hive Indexes (Deprecated)
Legacy. Use partitioning + bucketing.
Read article →Hive Join Strategy Selection
Auto-select + hints for control.
Read article →Hive Joins
Join strategies + hints.
Read article →Hive with JSON + Avro Data
SerDes + complex types.
Read article →Hive JVM Tuning
HS2 + metastore + Tez AM.
Read article →Hive LLAP
How LLAP (Live Long And Process) makes Hive interactive by running long-lived daemons that cache data and skip container startup entirely.
Read article →Hive LLAP architecture
Deep-dive on Hive LLAP: HiveServer2 planning, Tez AM coordination, daemon executor slots, async IO elevator, off-heap columnar cache with SSD tier, Zo…
Read article →Hive LLAP Deep Dive
How Hive LLAP daemons work: shared in-memory cache, query execution, integration with Tez.
Read article →Hive LLAP Performance Deep
Cached daemons + fragment scheduling.
Read article →Hive Materialized Views
Precomputed aggregates + auto-rewrite.
Read article →Hive Metastore
How the Hive Metastore stores tables, partitions, and statistics, and why it has become the de facto schema registry for Spark, Presto, Impala, and Tr…
Read article →Hive Metastore architecture
Deep-dive on the Hive Metastore: Thrift API over MySQL/Postgres, partition pruning paths, column statistics for CBOs, ACID transaction state, event no…
Read article →Hive Metastore Backup
Backing DB regular backups.
Read article →Hive Metastore HA
How to run Hive Metastore in HA configuration.
Read article →Hive Monitoring
HS2 metrics + query logs.
Read article →Hive on Spark
Spark as engine. Alternative to Tez.
Read article →Hive on Tez Deep Dive
DAG execution + optimizations.
Read article →Hive Cost-Based Optimizer
How Hive's cost-based optimizer chooses join orders, join strategies, and plan alternatives based on table and column statistics.
Read article →ORC format architecture
Deep-dive on ORC internals: file/stripe/stream layout, RLEv2 and dictionary encodings, row-group indexes with seek positions, min/max stats and bloom …
Read article →Hive ORC Format Deep Dive
How ORC (Optimized Row Columnar) format works internally.
Read article →ORC Format
The internal structure of ORC files: stripes, row groups, indexes, and how column pruning + predicate pushdown work together.
Read article →Apache Hive Overview
What Hive is, why SQL over HDFS mattered, and where Hive fits in modern data platforms alongside Spark, Presto, and Impala.
Read article →Hive Parquet Format Deep Dive
How Parquet compares to ORC and its internal structure.
Read article →Parquet Format
The internal structure of Parquet: row groups, column chunks, page indexes, dictionary encoding, and cross-engine compatibility.
Read article →Hive Partition Evolution
Add + drop partitions. Repair.
Read article →Hive Partition Pruning
Query planner drops non-matching partitions.
Read article →Hive Partitioning
How Hive partitioning works via HDFS directory layout, why it drives query performance, and how to design partitions right.
Read article →Hive Table Partitions
Directory-based partitioning. Prune scans.
Read article →Hive Predicate Pushdown
Filter at storage layer. ORC/Parquet stats.
Read article →Hive Query Execution
How Hive queries execute end-to-end: parse, plan, optimize, generate DAG, execute on Tez/Spark, and stream results.
Read article →Hive replication architecture
Deep-dive on Hive replication: event-driven incremental replication over the notification log, bootstrap and checkpointed cycles, DistCp data movement…
Read article →Hive Security
How Hive integrates with Kerberos + LDAP for auth, and encryption at rest + in transit.
Read article →Hive Security
Auth + authz.
Read article →Hive SerDes
Row format for different sources.
Read article →Hive small-file problem
Deep-dive on the small-file problem: sources (streaming, dynamic partitioning, appends), the three-layer cost (metadata, task overhead, read amplifica…
Read article →Hive on Spark Engine
How Hive can run on Spark instead of Tez.
Read article →Hive Storage Handlers
Query non-HDFS data — HBase, JDBC, ES.
Read article →Hive Streaming Ingestion
Real-time inserts to Hive.
Read article →Hive Subqueries + CTEs
Common patterns + limits.
Read article →Hive Table Statistics
ANALYZE TABLE. CBO uses stats.
Read article →Hive Tables
CREATE TABLE. Storage lifecycle differs.
Read article →Hive Table Types Summary
Managed, external, ACID, temporary, materialized view.
Read article →Hive on Tez
Why Tez replaced MapReduce as Hive's execution engine, how it uses DAGs instead of MR sequences, and how container reuse cuts que…
Read article →Hive on Tez architecture
Deep-dive on Tez execution for Hive: vertices and typed edges vs MapReduce chains, the per-session application master, YARN container reuse, runtime a…
Read article →Hive Tez Optimization
DAG execution. Container reuse.
Read article →Tez UI + Application Timeline Server
Query DAG visualization.
Read article →Hive Transactional (ACID) Tables
Row-level UPDATE/DELETE. Delta files.
Read article →Hive ACID Transactions Deep Dive
How Hive ACID transactions work: managed tables, delta files, compaction, isolation.
Read article →Hive TRANSFORM with Python
Streaming rows through script.
Read article →Hive Query Tuning Playbook
EXPLAIN + partition + join + engine.
Read article →Hive UDAF (User-Defined Aggregate)
Custom aggregation logic.
Read article →Hive UDFs and UDAFs
Deep-dive on Hive user-defined functions: UDF/GenericUDF/UDAF/UDTF types, ObjectInspectors, vectorized implementations vs row-mode fallback, UDAF part…
Read article →Hive UDFs
How to write Hive UDFs, UDAFs, and UDTFs, when to use them, and the performance and safety implications.
Read article →Hive UDTF (User-Defined Table Function)
Row → many rows. EXPLODE built-in.
Read article →Hive Upgrade Path
Version compat + metastore schema migration.
Read article →Hive Vectorization
Process batches of rows. Massive perf.
Read article →Hive vectorized execution
Deep-dive on Hive's vectorized engine: VectorizedRowBatch and ColumnVector anatomy, expression templates and monomorphic loop…
Read article →Hive View Types
The main Hive view types: virtual (logical), materialized (physical), and their trade-offs.
Read article →Hive Views and Materialized Views
How Hive views work (query rewriting on-the-fly), how materialized views cache results, and when each is the right choice.
Read article →Hive vs Presto/Trino
Batch vs interactive.
Read article →Hive Window Functions
ROW_NUMBER, RANK, LAG, LEAD.
Read article →Hive window functions
Deep-dive on Hive window functions: the OVER clause with PARTITION BY, ORDER BY, and frames, ranking/aggregate/positional function families, ROWS-vs-R…
Read article →HiveQL Syntax Essentials
SQL-like with big-data extensions.
Read article →HiveServer2 (HS2)
Thrift server. Multi-session.
Read article →HiveServer2 Clustering
Multiple HS2 + ZK URI.
Read article →Impala 4 Key Features
Iceberg + Kudu + admission improvements.
Read article →Impala Administration
Impala admin tasks: rolling restart, log analysis, tuning.
Read article →Impala Admission Control
How Impala admission control queues queries when resources are constrained, and how to configure per-pool limits.
Read article →Impala admission control architecture
Deep-dive on Impala admission control: resource pools, per-host memory estimates vs MEM_LIMIT, statestore-gossiped local decisions, the admissiond cen…
Read article →Impala Analytic Functions
How Impala's window functions (RANK, LAG, LEAD, SUM OVER) enable analytic queries.
Read article →Impala Architecture
The three daemon types in Impala, how they cooperate, and what each is responsible for.
Read article →Impala catalog and statestore architecture
Deep-dive on Impala metadata: catalogd as single writer over the Hive Metastore, statestored pub/sub fan-out, coordinator caches and versions, REFRESH…
Read article →Impala Cost-Based Optimizer
Uses table stats. Choose plan.
Read article →Impala Cluster Sizing
Memory + concurrent queries + workload.
Read article →Impala Complex Types
Nested Parquet reads.
Read article →Impala COMPUTE STATS
Table + column + incremental stats.
Read article →Impala Configuration + Admin
Common tuning knobs.
Read article →Impala Coordinator + Executor Roles
Split roles for scale.
Read article →Impala Cost Management
Right-sizing + auto-scale + admission.
Read article →Impala Cost Optimization
How to reduce Impala compute + storage costs.
Read article →Impala Daemons Deep Dive
How the Statestore's pub/sub topics work, how the Catalog syncs with the Hive Metastore, and how metadata invalidation propagates…
Read article →Impala DML Support
INSERT, UPDATE, DELETE (Kudu).
Read article →Impala Execution Model
How Impala executes queries: vectorized operators, LLVM code generation, streaming data flow between fragments.
Read article →Impala Future
Where Impala fits in modern stack.
Read article →Impala on HDFS + S3
Native readers for both.
Read article →Migrate from Hive to Impala
Query rewrite + perf gains.
Read article →Impala + Iceberg Tables
Modern table format support.
Read article →Impala + Iceberg Migration Path
Modernize table format.
Read article →Impala Daemons
Distributed roles.
Read article →Impala In-Memory Execution
Everything in RAM. Spill on OOM.
Read article →Impala INVALIDATE vs REFRESH
Metadata cache management.
Read article →Impala Join Strategies
Broadcast vs partitioned.
Read article →Impala + Kudu Deep Dive
How Impala integrates with Kudu for real-time analytical + operational.
Read article →Impala + Kudu
How Impala works with Apache Kudu to give both fast scans and low-latency updates, and when to choose Kudu over HDFS.
Read article →Impala LLVM Code Generation
Query-specific compiled operators.
Read article →Impala Memory Limits
Per-query + per-node caps.
Read article →Impala Metadata Deep Dive
How Impala's catalog service + Impalad local metadata cache work together.
Read article →Impala Monitoring
Query profile + web UI + Prometheus.
Read article →Impala MPP Architecture
Shared-nothing distributed execution.
Read article →Impala Node Types
Coordinator-only + executor-only.
Read article →Impala ORC Support
Growing but historically Parquet-first.
Read article →Apache Impala Overview
What Impala is, how MPP execution makes it interactive, and where it fits versus Hive, Presto, and Spark SQL.
Read article →Impala Parquet Native Reader
Optimized columnar. Predicate pushdown.
Read article →Impala Partition Pruning
Skip non-matching partitions.
Read article →Impala query execution architecture
Deep-dive on Impala's MPP execution: coordinator planning, statestore and catalog daemons, admission control pools, pipelined…
Read article →Impala Query Hints
Override planner decisions.
Read article →Impala Query Planning
How Impala plans queries: parse, analyze, single-node plan, distributed plan, fragment scheduling.
Read article →Impala Query Plans
How to read Impala's EXPLAIN output to understand and optimize queries.
Read article →Impala Query Queue
Admission control per resource pool.
Read article →Impala + Ranger + Kerberos
Enterprise security integration.
Read article →Impala + Ranger Integration
How Impala integrates with Ranger for centralized authorization.
Read article →Impala Runtime Filters
Dynamic filter propagation.
Read article →Impala Scale
How Impala scales to hundreds of nodes: coordinators, statestore, workload management.
Read article →Impala Shell + Web UI
Interactive + monitoring.
Read article →Impala Spill to Disk
OOM protection via disk spill.
Read article →Impala Table Statistics
How Impala uses table and column statistics for the cost-based optimizer, and how to keep stats fresh.
Read article →Impala Text + CSV Support
Basic external data.
Read article →Impala Troubleshooting
The common Impala issues (slow queries, OOM, metadata staleness) and how to fix.
Read article →Impala Upgrade Path
Rolling + version compat.
Read article →Impala vs Hive
The trade-offs between Impala and Hive: latency, concurrency, workload compatibility, ecosystem fit.
Read article →Impala vs Presto/Trino
Feature + perf comparison.
Read article →Impala vs Snowflake
Self-managed vs cloud SaaS.
Read article →