1,708 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
Best practices
1
vote
0
replies
43
views
Dictionary Encoding VS ENUM type
To meet certain data analysis requirements, I am migrating from a self-hosted local MySQL database to PolarDB. During the migration, I discovered that many data analysis tools offer a technique called ...
1
vote
0
answers
93
views
Filter a pivot table for multiple values
I have VBA code, coded by someone else, to filter an OLAP pivot table.
I want to filter for multiple trade dates rather than one.
I am aware that .CurrentPageName doesn't allow for multiple values. ...
0
votes
1
answer
65
views
When will clickhouse commit the consumed kafka offset in case of writing to distributed tables?
I am puzzled at this scenario, imagine I have two options: (I have M nodes all having the same tables)
kafka_table -> MV_1 -> local_table_1
-> MV_2 -> local_table_2
...
0
votes
1
answer
54
views
Power BI connection to DorisDB fails with "Character set 'utf8mb3' is not supported by .NET Framework"
I am trying to connect Power BI Desktop to our Apache Doris database (which is the VeloDB-Doris distribution). I am using the standard MySQL data source connector in Power BI, as Doris is compatible ...
0
votes
1
answer
70
views
Mondrian 10 ignores aggregate table
I have a fact table about sales figures (SALESSTATS table, in MYSCHEMA schema), and I created an aggregate table MYAGG (in MYSCHEMA as well), but when querying revenue per company, it ignores the ...
0
votes
1
answer
54
views
How can I immediately reclaim disk space after dropping a table (or quickly purge its tablets)?
I’m running an Apache Doris 2.1.7 cluster (3 FEs + 6 BEs) on CentOS 7.
After issuing DROP TABLE big_fact, the table disappears from the information_schema, but the underlying tablets remain on every ...
0
votes
0
answers
18
views
"Error starting FE or unit test locally Cannot find external parser table action_table.dat"
I encountered an error while setting up and using Doris during unit testing:
Error starting FE or unit test locally Cannot find external parser table action_table.dat
I searched the community and ...
1
vote
1
answer
144
views
Apache Doris FE Cluster: "Clock delta: xxxx ms between Feeder: xxxx and this Replica exceeds max permitted delta: xxxx ms" causes BDB
I encountered an issue while running an Apache Doris FE cluster, where the fe.log file shows the following error:
2024年01月09日 14:46:23,840 WARN (UNKNOWN fe_f78cf069_b094_4d9d_ac9c_ddc521dd494d(-1)|1) [...
0
votes
0
answers
34
views
Batch BE offline caused the collection of master FE metrics to get stuck
My Doris version is 2.1.7. The cluster has 25 BEs, and each BE has about 20,000 tablets. I took 5 BEs offline in batch. After running for a while, I found that accessing http://fe_ip:8030/metrics got ...
0
votes
2
answers
78
views
How to generate consecutive dates with specified time intervals between two dates in the Doris database
Example:
Given two dates, the start time and the end time
'2025-01-01' as start_date
'2025-06-08' as end_date
Then calculate the granularity given some time
days,weeks,months,years
Return some ...
0
votes
0
answers
57
views
Apache Doris query fails with error: [E-230]missed_versions is empty - How to diagnose and fix?
We are intermittently encountering a query failure on our Apache Doris cluster. The query fails completely with the following error message:
Query error: [E-230]missed_versions is empty
This error ...
0
votes
0
answers
46
views
Error: "Failed to create partition[p20240409000000].Timeout:30 seconds"
I used Doris's automatic partitioning function to create a table, and then inserted a large amount of data into this table. When importing the data, this error occurred:
[ERROR] 2025年06月05日 11:41:53....
0
votes
0
answers
97
views
Routine Load exception: fetch failed due to requested offset not available on the broker: Broker: Offset out of range
In Doris, I created a routine load import task:
CREATE ROUTINE LOAD demo.kafka_job02 ON routine_test02
COLUMNS TERMINATED BY ","
FROM KAFKA
(
"kafka_broker_list"...
0
votes
0
answers
72
views
Query error: "Failed to get scan range, no queryable replica found in tablet: xxxx"
During the process of setting up and using Doris, I encountered a query error:
Failed to get scan range, no queryable replica found in tablet: xxxx
This error seems to be a scanning error for the ...
0
votes
0
answers
56
views
Doris flink connector import error: get tableList write lock timeout
My doris version is 2.1.6, flink connector is 24.0.1
When writing to Doris using Flink, I often encounter the following error:
"Message": "[ANALYSIS_ERROR]TStatus: errCode = 2, ...