JOKERWING commented on issue #29826:
URL: https://github.com/apache/doris/issues/29826#issuecomment-1892948551
> 可以贴一下create sql么，最好再加些样本数据，确保其他人能复现
好的。下面是我的sql。
建表DDL：
`-- test_date definition
CREATE TABLE `test_date` (
`id` varchar(10) NULL,
`date` date NULL COMMENT '日期'
) ENGINE=OLAP
UNIQUE KEY(`id`, `date`)
COMMENT 'OLAP'
PARTITION BY RANGE(`date`)
(PARTITION p00000101 VALUES [('0000-01-01'), ('2023-01-01')),
PARTITION p20230101 VALUES [('2023-01-01'), ('2023-07-01')),
PARTITION p20230701 VALUES [('2023-07-01'), ('2024-01-01')),
PARTITION p20240101 VALUES [('2024-01-01'), ('2024-07-01')),
PARTITION p20240701 VALUES [('2024-07-01'), ('2025-01-01')),
PARTITION p20250101 VALUES [('2025-01-01'), ('2025-07-01')),
PARTITION p20250701 VALUES [('2025-07-01'), ('2026-01-01')),
PARTITION p20260101 VALUES [('2026-01-01'), ('2026-07-01')),
PARTITION p20260701 VALUES [('2026-07-01'), ('2027-01-01')),
PARTITION p20270101 VALUES [('2027-01-01'), ('2027-07-01')),
PARTITION p20270701 VALUES [('2027-07-01'), ('2028-01-01')),
PARTITION p20280101 VALUES [('2028-01-01'), ('2028-07-01')),
PARTITION p20280701 VALUES [('2028-07-01'), ('2029-01-01')),
PARTITION p20290101 VALUES [('2029-01-01'), ('2029-07-01')),
PARTITION p20290701 VALUES [('2029-07-01'), ('2030-01-01')),
PARTITION p20300101 VALUES [('2030-01-01'), ('2100-01-01')))
DISTRIBUTED BY HASH(`id`) BUCKETS 10
PROPERTIES (
"replication_allocation" = "tag.location.default: 3",
"is_being_synced" = "false",
"storage_format" = "V2",
"disable_auto_compaction" = "false",
"enable_single_replica_compaction" = "false"
);`
部分模拟数据：
`INSERT INTO test_date (id, `date`) VALUES('01', '2022-10-01');
INSERT INTO test_date (id, `date`) VALUES('02', '2022-10-01');
INSERT INTO test_date (id, `date`) VALUES('01', '2022-11-01');
INSERT INTO test_date (id, `date`) VALUES('02', '2022-11-01');
INSERT INTO test_date (id, `date`) VALUES('01', '2022-12-01');
INSERT INTO test_date (id, `date`) VALUES('02', '2022-12-01');
INSERT INTO test_date (id, `date`) VALUES('03', '2023-01-01');
INSERT INTO test_date (id, `date`) VALUES('01', '2023-02-01');
INSERT INTO test_date (id, `date`) VALUES('03', '2023-03-01');
INSERT INTO test_date (id, `date`) VALUES('03', '2023-04-01');
INSERT INTO test_date (id, `date`) VALUES('03', '2023-05-01');
INSERT INTO test_date (id, `date`) VALUES('03', '2023-06-01');
INSERT INTO test_date (id, `date`) VALUES('04', '2023-06-01');
INSERT INTO test_date (id, `date`) VALUES('03', '2023-07-01');
INSERT INTO test_date (id, `date`) VALUES('04', '2023-07-01');
INSERT INTO test_date (id, `date`) VALUES('03', '2023-08-01');
INSERT INTO test_date (id, `date`) VALUES('04', '2023-08-01');
INSERT INTO test_date (id, `date`) VALUES('03', '2023-09-01');
INSERT INTO test_date (id, `date`) VALUES('04', '2023-09-01');
INSERT INTO test_date (id, `date`) VALUES('03', '2023-10-01');
INSERT INTO test_date (id, `date`) VALUES('04', '2023-10-01');
INSERT INTO test_date (id, `date`) VALUES('01', '2023-11-01');
INSERT INTO test_date (id, `date`) VALUES('02', '2023-11-01');
INSERT INTO test_date (id, `date`) VALUES('03', '2023-11-01');
INSERT INTO test_date (id, `date`) VALUES('03', '2023-12-01');
INSERT INTO test_date (id, `date`) VALUES('04', '2023-12-01');
INSERT INTO test_date (id, `date`) VALUES('0A', '2023-12-01');
INSERT INTO test_date (id, `date`) VALUES('06', '2024-01-01');
INSERT INTO test_date (id, `date`) VALUES('07', '2024-01-01');`
执行查询结果的sql：
` SELECT distinct date
FROM test_date
WHERE date = '2024-00-01' `
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
