horaedb
horaedb copied to clipboard
Inconsistent query results of partitioned table when loading data multiple times
Describe this problem
I want to introduce tsbs to integration test of partitioned table. Howerver, I found Inconsistent query results when loading data multiple times(will drop table after new loading).
Server version
CeresDB Server Version: 1.2.6-alpha Git commit: b0d7c2ca Git branch: main Opt level: 0 Rustc version: 1.74.0-nightly Target: aarch64-apple-darwin Build date: 2023-09-06T03:13:57.949975000Z
Steps to reproduce
- pull the branch in my pr #1195
- start cluster and load data
cd integration_tests
make run-dist-query
- query data using following sql:
SELECT
time_bucket(timestamp, 'PT60S') as minute,
max(usage_user) AS max_usage_user, max(usage_system) AS max_usage_system, max(usage_idle) AS max_usage_idle, max(usage_nice) AS max_usage_nice, max(usage_iowait) AS max_usage_iowait
FROM cpu
WHERE (hostname = 'host_2987' OR hostname = 'host_2302' OR hostname = 'host_3182' OR hostname = 'host_3215' OR hostname = 'host_248' OR hostname = 'host_3701' OR hostname = 'host_1103' OR hostname = 'host_3837') AND (timestamp >= '2022-09-05T00:00:00Z') AND (timestamp < '2022-09-05T01:00:00Z')
GROUP BY minute
ORDER BY minute ASC
- drop table and load data again
cd dist_query
NO_INIT=true ./run.sh
- query data again using above sql
- you may found the inconsistent query results ...
Expected behavior
No response
Additional Information
No response