Apache Doris Common Technical Queries and Solutions
SQL Queries
Q1: Is MySQL's WITH ROLLUP syntax supported?
Apache Doris does not currently support the WITH ROLLUP clause. As an alteernative, use the GROUP BY ROLLUP construct:
SELECT a, b, c, SUM(d) FROM tab1 GROUP BY ROLLUP(a, b, c);
Q2: Why do decimal field queries truncate to six decimal places?
By default, decimal values retain six fractio ...
Posted on Sat, 05 Sep 2026 16:17:20 +0000 by lesmith
Apache Doris Weekly FAQ: Memory Limits, Import Errors, and More
SQL Execution and Memory Management
Q1: Why does a single SQL query's memory usage not respect the exec_mem_limit setting?
A1: The exec_mem_limit parameter governs the maximum memory allocated per query fragment instance within a query plan. A single query plan may involve multiple instances, each executed on one or more Backend (BE) nodes. As ...
Posted on Sun, 14 Jun 2026 17:43:38 +0000 by billmasters