Tagged articles

Routine Load

3 articles · Page 1 of 1

Jul 7, 2025 · Databases

StarRocks Routine Load: Import Kafka JSON & CSV Data with Real-World Troubleshooting

This guide demonstrates using StarRocks Routine Load to ingest JSON and CSV data from Kafka, covering environment setup, table creation, load job configuration with critical parameters like jsonpaths, troubleshooting null-field errors, task management commands, and performance optimization tips for real-time analytics.

CSVData IngestionJSON

0 likes · 14 min read

StarRocks Routine Load: Import Kafka JSON & CSV Data with Real-World Troubleshooting

ITPUB

Sep 15, 2023 · Databases

Importing Billions of Kafka Rows into Doris and Benchmarking Against ClickHouse

This article explains Doris's various data import methods, focuses on the routine load approach for Kafka streams, describes how to handle mixed‑schema topics using the max_error_number parameter, and compares query performance of a 130 million‑row dataset against ClickHouse, highlighting each system's strengths and limitations.

ClickHouseDorisKafka

0 likes · 10 min read

Importing Billions of Kafka Rows into Doris and Benchmarking Against ClickHouse

dbaplus Community

Aug 23, 2023 · Databases

How to Load Billion-Row Kafka Data into Doris and Compare Performance with ClickHouse

This article demonstrates how to ingest billions of Kafka records into Doris using Routine Load, compares the import process and query performance with ClickHouse’s Kafka engine tables, discusses configuration challenges such as field‑count filtering, and presents practical workarounds and benchmark results.

ClickHouseDorisPerformance Comparison

0 likes · 9 min read

How to Load Billion-Row Kafka Data into Doris and Compare Performance with ClickHouse