为了更快的定位您的问题，请提供以下信息，谢谢
【详述】问题详细描述
select chr_id,
ip,
date_time,
chr_level,
chr_level_vip,
career,
pet_animal_id,
pet_animal_name,
pet_animal_level,
before_operation,
after_operation,
event_type,
event,
info,
ext
from chxo.dwd_pet_animal
where (product_name = ‘xfhd’)
and (date_time >= ‘2023-06-02T00:00’)
and (date_time < ‘2023-07-02T00:00’) limit 10; sql执行不能出结果
但是这样可以出结果
select chr_id,
ip,
date_time,
chr_level,
chr_level_vip,
career,
pet_animal_id,
pet_animal_name,
pet_animal_level,
before_operation,
after_operation,
event_type,
event,
info,
ext
from chxo.dwd_pet_animal
where (product_name = ‘xfhd’)
and (date_time >= ‘2023-06-02T00:00’)
limit 10;
问题：FLINK不支持 (date_time >= ‘2023-06-02T00:00’)
and (date_time < ‘2023-07-02T00:00’) 这种时间查询格式吗？
当前进展：已经确认按照：(date_time >= ‘2023-06-02T00:00’) 查询的时间区间是在 (date_time >= ‘2023-06-02T00:00’)
and (date_time < ‘2023-07-02T00:00’) 范围内。
【背景】做过哪些操作？
无
【业务影响】
【StarRocks版本】2.5.3
【集群规模】例如：3fe+3be
【机器信息】
【联系方式】18317302133
【附件】
建表语句:
CREATE TABLE tets.qingxi_pet_animal (
product_name varchar(32) NULL COMMENT “”,
chr_id varchar(64) NULL COMMENT “”,
event_type varchar(128) NULL COMMENT “”,
event varchar(128) NULL COMMENT “”,
pet_animal_name varchar(128) NULL COMMENT “”,
pet_animal_id int(11) NULL COMMENT “”,
platform_name varchar(32) NULL COMMENT “”,
channel_name varchar(32) NULL COMMENT “”,
gameserver_no int(11) NULL COMMENT “”,
ip varchar(15) NULL COMMENT “”,
date_time datetime NULL COMMENT “”,
account_id varchar(64) NULL COMMENT “”,
account_name varchar(64) NULL COMMENT “”,
chr_name varchar(128) NULL COMMENT “”,
chr_level int(11) NULL COMMENT “”,
chr_level_vip int(11) NULL COMMENT “”,
career varchar(16) NULL COMMENT “”,
gender varchar(16) NULL COMMENT “”,
log_id varchar(65533) NULL COMMENT “”,
pet_animal_level int(11) NULL COMMENT “”,
info varchar(255) NULL COMMENT “”,
before_operation varchar(65533) NULL COMMENT “”,
after_operation varchar(65533) NULL COMMENT “”,
ext varchar(65533) NULL COMMENT “”,
version varchar(32) NULL COMMENT “”
) ENGINE=OLAP
DUPLICATE KEY(product_name, chr_id, event_type)
COMMENT “OLAP”
PARTITION BY RANGE(date_time)
(
PARTITION p20230513 VALUES [(“2023-05-13 00:00:00”), (“2023-05-14 00:00:00”))(“replication_num” = “2”),
PARTITION p20230514 VALUES [(“2023-05-14 00:00:00”), (“2023-05-15 00:00:00”))(“replication_num” = “2”),
PARTITION p20230515 VALUES [(“2023-05-15 00:00:00”), (“2023-05-16 00:00:00”))(“replication_num” = “2”),
PARTITION p20230516 VALUES [(“2023-05-16 00:00:00”), (“2023-05-17 00:00:00”))(“replication_num” = “2”),
PARTITION p20230517 VALUES [(“2023-05-17 00:00:00”), (“2023-05-18 00:00:00”))(“replication_num” = “2”),
PARTITION p20230518 VALUES [(“2023-05-18 00:00:00”), (“2023-05-19 00:00:00”))(“replication_num” = “2”),
PARTITION p20230519 VALUES [(“2023-05-19 00:00:00”), (“2023-05-20 00:00:00”))(“replication_num” = “2”),
PARTITION p20230520 VALUES [(“2023-05-20 00:00:00”), (“2023-05-21 00:00:00”))(“replication_num” = “2”),
PARTITION p20230521 VALUES [(“2023-05-21 00:00:00”), (“2023-05-22 00:00:00”))(“replication_num” = “2”),
PARTITION p20230522 VALUES [(“2023-05-22 00:00:00”), (“2023-05-23 00:00:00”))(“replication_num” = “2”),
PARTITION p20230523 VALUES [(“2023-05-23 00:00:00”), (“2023-05-24 00:00:00”))(“replication_num” = “2”),
PARTITION p20230524 VALUES [(“2023-05-24 00:00:00”), (“2023-05-25 00:00:00”))(“replication_num” = “2”),
PARTITION p20230525 VALUES [(“2023-05-25 00:00:00”), (“2023-05-26 00:00:00”))(“replication_num” = “2”),
PARTITION p20230526 VALUES [(“2023-05-26 00:00:00”), (“2023-05-27 00:00:00”))(“replication_num” = “2”),
PARTITION p20230527 VALUES [(“2023-05-27 00:00:00”), (“2023-05-28 00:00:00”))(“replication_num” = “2”),
PARTITION p20230528 VALUES [(“2023-05-28 00:00:00”), (“2023-05-29 00:00:00”))(“replication_num” = “2”),
PARTITION p20230529 VALUES [(“2023-05-29 00:00:00”), (“2023-05-30 00:00:00”))(“replication_num” = “2”),
PARTITION p20230530 VALUES [(“2023-05-30 00:00:00”), (“2023-05-31 00:00:00”))(“replication_num” = “2”),
PARTITION p20230531 VALUES [(“2023-05-31 00:00:00”), (“2023-06-01 00:00:00”))(“replication_num” = “2”),
PARTITION p20230601 VALUES [(“2023-06-01 00:00:00”), (“2023-06-02 00:00:00”))(“replication_num” = “2”),
PARTITION p20230602 VALUES [(“2023-06-02 00:00:00”), (“2023-06-03 00:00:00”))(“replication_num” = “2”),
PARTITION p20230603 VALUES [(“2023-06-03 00:00:00”), (“2023-06-04 00:00:00”))(“replication_num” = “2”),
PARTITION p20230604 VALUES [(“2023-06-04 00:00:00”), (“2023-06-05 00:00:00”))(“replication_num” = “2”),
PARTITION p20230605 VALUES [(“2023-06-05 00:00:00”), (“2023-06-06 00:00:00”))(“replication_num” = “2”),
PARTITION p20230606 VALUES [(“2023-06-06 00:00:00”), (“2023-06-07 00:00:00”))(“replication_num” = “2”),
PARTITION p20230607 VALUES [(“2023-06-07 00:00:00”), (“2023-06-08 00:00:00”))(“replication_num” = “2”),
PARTITION p20230608 VALUES [(“2023-06-08 00:00:00”), (“2023-06-09 00:00:00”))(“replication_num” = “2”),
PARTITION p20230609 VALUES [(“2023-06-09 00:00:00”), (“2023-06-10 00:00:00”))(“replication_num” = “2”),
PARTITION p20230610 VALUES [(“2023-06-10 00:00:00”), (“2023-06-11 00:00:00”))(“replication_num” = “2”),
PARTITION p20230611 VALUES [(“2023-06-11 00:00:00”), (“2023-06-12 00:00:00”))(“replication_num” = “2”),
PARTITION p20230612 VALUES [(“2023-06-12 00:00:00”), (“2023-06-13 00:00:00”))(“replication_num” = “2”),
PARTITION p20230613 VALUES [(“2023-06-13 00:00:00”), (“2023-06-14 00:00:00”))(“replication_num” = “2”),
PARTITION p20230614 VALUES [(“2023-06-14 00:00:00”), (“2023-06-15 00:00:00”))(“replication_num” = “2”),
PARTITION p20230615 VALUES [(“2023-06-15 00:00:00”), (“2023-06-16 00:00:00”))(“replication_num” = “2”),
PARTITION p20230616 VALUES [(“2023-06-16 00:00:00”), (“2023-06-17 00:00:00”))(“replication_num” = “2”),
PARTITION p20230617 VALUES [(“2023-06-17 00:00:00”), (“2023-06-18 00:00:00”))(“replication_num” = “2”),
PARTITION p20230618 VALUES [(“2023-06-18 00:00:00”), (“2023-06-19 00:00:00”))(“replication_num” = “2”),
PARTITION p20230619 VALUES [(“2023-06-19 00:00:00”), (“2023-06-20 00:00:00”))(“replication_num” = “2”),
PARTITION p20230620 VALUES [(“2023-06-20 00:00:00”), (“2023-06-21 00:00:00”))(“replication_num” = “2”),
PARTITION p20230621 VALUES [(“2023-06-21 00:00:00”), (“2023-06-22 00:00:00”))(“replication_num” = “2”),
PARTITION p20230622 VALUES [(“2023-06-22 00:00:00”), (“2023-06-23 00:00:00”))(“replication_num” = “2”),
PARTITION p20230623 VALUES [(“2023-06-23 00:00:00”), (“2023-06-24 00:00:00”))(“replication_num” = “2”),
PARTITION p20230624 VALUES [(“2023-06-24 00:00:00”), (“2023-06-25 00:00:00”))(“replication_num” = “2”),
PARTITION p20230625 VALUES [(“2023-06-25 00:00:00”), (“2023-06-26 00:00:00”))(“replication_num” = “2”),
PARTITION p20230626 VALUES [(“2023-06-26 00:00:00”), (“2023-06-27 00:00:00”))(“replication_num” = “2”),
PARTITION p20230627 VALUES [(“2023-06-27 00:00:00”), (“2023-06-28 00:00:00”))(“replication_num” = “2”),
PARTITION p20230628 VALUES [(“2023-06-28 00:00:00”), (“2023-06-29 00:00:00”))(“replication_num” = “2”),
PARTITION p20230629 VALUES [(“2023-06-29 00:00:00”), (“2023-06-30 00:00:00”))(“replication_num” = “2”),
PARTITION p20230630 VALUES [(“2023-06-30 00:00:00”), (“2023-07-01 00:00:00”))(“replication_num” = “2”),
PARTITION p20230701 VALUES [(“2023-07-01 00:00:00”), (“2023-07-02 00:00:00”))(“replication_num” = “2”),
PARTITION p20230702 VALUES [(“2023-07-02 00:00:00”), (“2023-07-03 00:00:00”))(“replication_num” = “2”),
PARTITION p20230703 VALUES [(“2023-07-03 00:00:00”), (“2023-07-04 00:00:00”))(“replication_num” = “2”),
PARTITION p20230704 VALUES [(“2023-07-04 00:00:00”), (“2023-07-05 00:00:00”))(“replication_num” = “2”),
PARTITION p20230705 VALUES [(“2023-07-05 00:00:00”), (“2023-07-06 00:00:00”))(“replication_num” = “2”),
PARTITION p20230706 VALUES [(“2023-07-06 00:00:00”), (“2023-07-07 00:00:00”))(“replication_num” = “2”),
PARTITION p20230707 VALUES [(“2023-07-07 00:00:00”), (“2023-07-08 00:00:00”))(“replication_num” = “2”),
PARTITION p20230708 VALUES [(“2023-07-08 00:00:00”), (“2023-07-09 00:00:00”))(“replication_num” = “2”),
PARTITION p20230709 VALUES [(“2023-07-09 00:00:00”), (“2023-07-10 00:00:00”))(“replication_num” = “2”),
PARTITION p20230710 VALUES [(“2023-07-10 00:00:00”), (“2023-07-11 00:00:00”))(“replication_num” = “2”),
PARTITION p20230711 VALUES [(“2023-07-11 00:00:00”), (“2023-07-12 00:00:00”))(“replication_num” = “2”),
PARTITION p20230712 VALUES [(“2023-07-12 00:00:00”), (“2023-07-13 00:00:00”))(“replication_num” = “2”),
PARTITION p20230713 VALUES [(“2023-07-13 00:00:00”), (“2023-07-14 00:00:00”))(“replication_num” = “2”),
PARTITION p20230714 VALUES [(“2023-07-14 00:00:00”), (“2023-07-15 00:00:00”))(“replication_num” = “2”),
PARTITION p20230715 VALUES [(“2023-07-15 00:00:00”), (“2023-07-16 00:00:00”))(“replication_num” = “2”),
PARTITION p20230716 VALUES [(“2023-07-16 00:00:00”), (“2023-07-17 00:00:00”))(“replication_num” = “2”),
PARTITION p20230717 VALUES [(“2023-07-17 00:00:00”), (“2023-07-18 00:00:00”))(“replication_num” = “2”),
PARTITION p20230718 VALUES [(“2023-07-18 00:00:00”), (“2023-07-19 00:00:00”))(“replication_num” = “2”),
PARTITION p20230719 VALUES [(“2023-07-19 00:00:00”), (“2023-07-20 00:00:00”))(“replication_num” = “2”),
PARTITION p20230720 VALUES [(“2023-07-20 00:00:00”), (“2023-07-21 00:00:00”))(“replication_num” = “2”),
PARTITION p20230721 VALUES [(“2023-07-21 00:00:00”), (“2023-07-22 00:00:00”))(“replication_num” = “2”),
PARTITION p20230722 VALUES [(“2023-07-22 00:00:00”), (“2023-07-23 00:00:00”))(“replication_num” = “2”),
PARTITION p20230723 VALUES [(“2023-07-23 00:00:00”), (“2023-07-24 00:00:00”))(“replication_num” = “2”),
PARTITION p20230724 VALUES [(“2023-07-24 00:00:00”), (“2023-07-25 00:00:00”))(“replication_num” = “2”),
PARTITION p20230725 VALUES [(“2023-07-25 00:00:00”), (“2023-07-26 00:00:00”))(“replication_num” = “2”),
PARTITION p20230726 VALUES [(“2023-07-26 00:00:00”), (“2023-07-27 00:00:00”))(“replication_num” = “2”),
PARTITION p20230727 VALUES [(“2023-07-27 00:00:00”), (“2023-07-28 00:00:00”))(“replication_num” = “2”),
PARTITION p20230728 VALUES [(“2023-07-28 00:00:00”), (“2023-07-29 00:00:00”))(“replication_num” = “2”),
PARTITION p20230729 VALUES [(“2023-07-29 00:00:00”), (“2023-07-30 00:00:00”))(“replication_num” = “2”),
PARTITION p20230730 VALUES [(“2023-07-30 00:00:00”), (“2023-07-31 00:00:00”))(“replication_num” = “2”),
PARTITION p20230731 VALUES [(“2023-07-31 00:00:00”), (“2023-08-01 00:00:00”))(“replication_num” = “2”),
PARTITION p20230801 VALUES [(“2023-08-01 00:00:00”), (“2023-08-02 00:00:00”))(“replication_num” = “2”),
PARTITION p20230802 VALUES [(“2023-08-02 00:00:00”), (“2023-08-03 00:00:00”))(“replication_num” = “2”),
PARTITION p20230803 VALUES [(“2023-08-03 00:00:00”), (“2023-08-04 00:00:00”))(“replication_num” = “2”),
PARTITION p20230804 VALUES [(“2023-08-04 00:00:00”), (“2023-08-05 00:00:00”))(“replication_num” = “2”),
PARTITION p20230805 VALUES [(“2023-08-05 00:00:00”), (“2023-08-06 00:00:00”))(“replication_num” = “2”),
PARTITION p20230806 VALUES [(“2023-08-06 00:00:00”), (“2023-08-07 00:00:00”))(“replication_num” = “2”),
PARTITION p20230807 VALUES [(“2023-08-07 00:00:00”), (“2023-08-08 00:00:00”))(“replication_num” = “2”),
PARTITION p20230808 VALUES [(“2023-08-08 00:00:00”), (“2023-08-09 00:00:00”))(“replication_num” = “2”),
PARTITION p20230809 VALUES [(“2023-08-09 00:00:00”), (“2023-08-10 00:00:00”))(“replication_num” = “2”),
PARTITION p20230810 VALUES [(“2023-08-10 00:00:00”), (“2023-08-11 00:00:00”))(“replication_num” = “2”),
PARTITION p20230811 VALUES [(“2023-08-11 00:00:00”), (“2023-08-12 00:00:00”))(“replication_num” = “2”),
PARTITION p20230812 VALUES [(“2023-08-12 00:00:00”), (“2023-08-13 00:00:00”))(“replication_num” = “2”),
PARTITION p20230813 VALUES [(“2023-08-13 00:00:00”), (“2023-08-14 00:00:00”))(“replication_num” = “2”),
PARTITION p20230814 VALUES [(“2023-08-14 00:00:00”), (“2023-08-15 00:00:00”))(“replication_num” = “2”),
PARTITION p20230815 VALUES [(“2023-08-15 00:00:00”), (“2023-08-16 00:00:00”))(“replication_num” = “2”),
PARTITION p20230816 VALUES [(“2023-08-16 00:00:00”), (“2023-08-17 00:00:00”))(“replication_num” = “2”),
PARTITION p20230817 VALUES [(“2023-08-17 00:00:00”), (“2023-08-18 00:00:00”))(“replication_num” = “2”),
PARTITION p20230818 VALUES [(“2023-08-18 00:00:00”), (“2023-08-19 00:00:00”))(“replication_num” = “2”),
PARTITION p20230819 VALUES [(“2023-08-19 00:00:00”), (“2023-08-20 00:00:00”))(“replication_num” = “2”),
PARTITION p20230820 VALUES [(“2023-08-20 00:00:00”), (“2023-08-21 00:00:00”))(“replication_num” = “2”),
PARTITION p20230821 VALUES [(“2023-08-21 00:00:00”), (“2023-08-22 00:00:00”))(“replication_num” = “2”),
PARTITION p20230822 VALUES [(“2023-08-22 00:00:00”), (“2023-08-23 00:00:00”))(“replication_num” = “2”),
PARTITION p20230823 VALUES [(“2023-08-23 00:00:00”), (“2023-08-24 00:00:00”))(“replication_num” = “2”),
PARTITION p20230824 VALUES [(“2023-08-24 00:00:00”), (“2023-08-25 00:00:00”))(“replication_num” = “2”),
PARTITION p20230825 VALUES [(“2023-08-25 00:00:00”), (“2023-08-26 00:00:00”))(“replication_num” = “2”),
PARTITION p20230826 VALUES [(“2023-08-26 00:00:00”), (“2023-08-27 00:00:00”))(“replication_num” = “2”),
PARTITION p20230827 VALUES [(“2023-08-27 00:00:00”), (“2023-08-28 00:00:00”))(“replication_num” = “2”),
PARTITION p20230828 VALUES [(“2023-08-28 00:00:00”), (“2023-08-29 00:00:00”))(“replication_num” = “2”),
PARTITION p20230829 VALUES [(“2023-08-29 00:00:00”), (“2023-08-30 00:00:00”))(“replication_num” = “2”),
PARTITION p20230830 VALUES [(“2023-08-30 00:00:00”), (“2023-08-31 00:00:00”))(“replication_num” = “2”),
PARTITION p20230831 VALUES [(“2023-08-31 00:00:00”), (“2023-09-01 00:00:00”))(“replication_num” = “2”),
PARTITION p20230901 VALUES [(“2023-09-01 00:00:00”), (“2023-09-02 00:00:00”))(“replication_num” = “2”),
PARTITION p20230902 VALUES [(“2023-09-02 00:00:00”), (“2023-09-03 00:00:00”))(“replication_num” = “2”),
PARTITION p20230903 VALUES [(“2023-09-03 00:00:00”), (“2023-09-04 00:00:00”))(“replication_num” = “2”),
PARTITION p20230904 VALUES [(“2023-09-04 00:00:00”), (“2023-09-05 00:00:00”))(“replication_num” = “2”),
PARTITION p20230905 VALUES [(“2023-09-05 00:00:00”), (“2023-09-06 00:00:00”))(“replication_num” = “2”),
PARTITION p20230906 VALUES [(“2023-09-06 00:00:00”), (“2023-09-07 00:00:00”))(“replication_num” = “2”),
PARTITION p20230907 VALUES [(“2023-09-07 00:00:00”), (“2023-09-08 00:00:00”))(“replication_num” = “2”),
PARTITION p20230908 VALUES [(“2023-09-08 00:00:00”), (“2023-09-09 00:00:00”))(“replication_num” = “2”),
PARTITION p20230909 VALUES [(“2023-09-09 00:00:00”), (“2023-09-10 00:00:00”))(“replication_num” = “2”),
PARTITION p20230910 VALUES [(“2023-09-10 00:00:00”), (“2023-09-11 00:00:00”))(“replication_num” = “2”),
PARTITION p20230911 VALUES [(“2023-09-11 00:00:00”), (“2023-09-12 00:00:00”))(“replication_num” = “2”),
PARTITION p20230912 VALUES [(“2023-09-12 00:00:00”), (“2023-09-13 00:00:00”))(“replication_num” = “2”),
PARTITION p20230913 VALUES [(“2023-09-13 00:00:00”), (“2023-09-14 00:00:00”))(“replication_num” = “2”),
PARTITION p20230914 VALUES [(“2023-09-14 00:00:00”), (“2023-09-15 00:00:00”))(“replication_num” = “2”),
PARTITION p20230915 VALUES [(“2023-09-15 00:00:00”), (“2023-09-16 00:00:00”))(“replication_num” = “2”),
PARTITION p20230916 VALUES [(“2023-09-16 00:00:00”), (“2023-09-17 00:00:00”))(“replication_num” = “2”),
PARTITION p20230917 VALUES [(“2023-09-17 00:00:00”), (“2023-09-18 00:00:00”))(“replication_num” = “2”),
PARTITION p20230918 VALUES [(“2023-09-18 00:00:00”), (“2023-09-19 00:00:00”))(“replication_num” = “2”),
PARTITION p20230919 VALUES [(“2023-09-19 00:00:00”), (“2023-09-20 00:00:00”))(“replication_num” = “2”),
PARTITION p20230920 VALUES [(“2023-09-20 00:00:00”), (“2023-09-21 00:00:00”))(“replication_num” = “2”),
PARTITION p20230921 VALUES [(“2023-09-21 00:00:00”), (“2023-09-22 00:00:00”))(“replication_num” = “2”),
PARTITION p20230922 VALUES [(“2023-09-22 00:00:00”), (“2023-09-23 00:00:00”))(“replication_num” = “2”),
PARTITION p20230923 VALUES [(“2023-09-23 00:00:00”), (“2023-09-24 00:00:00”))(“replication_num” = “2”),
PARTITION p20230924 VALUES [(“2023-09-24 00:00:00”), (“2023-09-25 00:00:00”))(“replication_num” = “2”),
PARTITION p20230925 VALUES [(“2023-09-25 00:00:00”), (“2023-09-26 00:00:00”))(“replication_num” = “2”),
PARTITION p20230926 VALUES [(“2023-09-26 00:00:00”), (“2023-09-27 00:00:00”))(“replication_num” = “2”),
PARTITION p20230927 VALUES [(“2023-09-27 00:00:00”), (“2023-09-28 00:00:00”))(“replication_num” = “2”),
PARTITION p20230928 VALUES [(“2023-09-28 00:00:00”), (“2023-09-29 00:00:00”))(“replication_num” = “2”),
PARTITION p20230929 VALUES [(“2023-09-29 00:00:00”), (“2023-09-30 00:00:00”))(“replication_num” = “2”),
PARTITION p20230930 VALUES [(“2023-09-30 00:00:00”), (“2023-10-01 00:00:00”))(“replication_num” = “2”),
PARTITION p20231001 VALUES [(“2023-10-01 00:00:00”), (“2023-10-02 00:00:00”))(“replication_num” = “2”),
PARTITION p20231002 VALUES [(“2023-10-02 00:00:00”), (“2023-10-03 00:00:00”))(“replication_num” = “2”),
PARTITION p20231003 VALUES [(“2023-10-03 00:00:00”), (“2023-10-04 00:00:00”))(“replication_num” = “2”),
PARTITION p20231004 VALUES [(“2023-10-04 00:00:00”), (“2023-10-05 00:00:00”))(“replication_num” = “2”),
PARTITION p20231005 VALUES [(“2023-10-05 00:00:00”), (“2023-10-06 00:00:00”))(“replication_num” = “2”),
PARTITION p20231006 VALUES [(“2023-10-06 00:00:00”), (“2023-10-07 00:00:00”))(“replication_num” = “2”),
PARTITION p20231007 VALUES [(“2023-10-07 00:00:00”), (“2023-10-08 00:00:00”))(“replication_num” = “2”),
PARTITION p20231008 VALUES [(“2023-10-08 00:00:00”), (“2023-10-09 00:00:00”))(“replication_num” = “2”),
PARTITION p20231009 VALUES [(“2023-10-09 00:00:00”), (“2023-10-10 00:00:00”))(“replication_num” = “2”),
PARTITION p20231010 VALUES [(“2023-10-10 00:00:00”), (“2023-10-11 00:00:00”))(“replication_num” = “2”),
PARTITION p20231011 VALUES [(“2023-10-11 00:00:00”), (“2023-10-12 00:00:00”))(“replication_num” = “2”),
PARTITION p20231012 VALUES [(“2023-10-12 00:00:00”), (“2023-10-13 00:00:00”))(“replication_num” = “2”),
PARTITION p20231013 VALUES [(“2023-10-13 00:00:00”), (“2023-10-14 00:00:00”))(“replication_num” = “2”),
PARTITION p20231014 VALUES [(“2023-10-14 00:00:00”), (“2023-10-15 00:00:00”))(“replication_num” = “2”),
PARTITION p20231015 VALUES [(“2023-10-15 00:00:00”), (“2023-10-16 00:00:00”))(“replication_num” = “2”),
PARTITION p20231016 VALUES [(“2023-10-16 00:00:00”), (“2023-10-17 00:00:00”))(“replication_num” = “2”),
PARTITION p20231017 VALUES [(“2023-10-17 00:00:00”), (“2023-10-18 00:00:00”))(“replication_num” = “2”),
PARTITION p20231018 VALUES [(“2023-10-18 00:00:00”), (“2023-10-19 00:00:00”))(“replication_num” = “2”),
PARTITION p20231019 VALUES [(“2023-10-19 00:00:00”), (“2023-10-20 00:00:00”))(“replication_num” = “2”),
PARTITION p20231020 VALUES [(“2023-10-20 00:00:00”), (“2023-10-21 00:00:00”))(“replication_num” = “2”),
PARTITION p20231021 VALUES [(“2023-10-21 00:00:00”), (“2023-10-22 00:00:00”))(“replication_num” = “2”),
PARTITION p20231022 VALUES [(“2023-10-22 00:00:00”), (“2023-10-23 00:00:00”))(“replication_num” = “2”),
PARTITION p20231023 VALUES [(“2023-10-23 00:00:00”), (“2023-10-24 00:00:00”))(“replication_num” = “2”),
PARTITION p20231024 VALUES [(“2023-10-24 00:00:00”), (“2023-10-25 00:00:00”))(“replication_num” = “2”),
PARTITION p20231025 VALUES [(“2023-10-25 00:00:00”), (“2023-10-26 00:00:00”))(“replication_num” = “2”),
PARTITION p20231026 VALUES [(“2023-10-26 00:00:00”), (“2023-10-27 00:00:00”))(“replication_num” = “2”),
PARTITION p20231027 VALUES [(“2023-10-27 00:00:00”), (“2023-10-28 00:00:00”))(“replication_num” = “2”),
PARTITION p20231028 VALUES [(“2023-10-28 00:00:00”), (“2023-10-29 00:00:00”))(“replication_num” = “2”),
PARTITION p20231029 VALUES [(“2023-10-29 00:00:00”), (“2023-10-30 00:00:00”))(“replication_num” = “2”),
PARTITION p20231030 VALUES [(“2023-10-30 00:00:00”), (“2023-10-31 00:00:00”))(“replication_num” = “2”),
PARTITION p20231031 VALUES [(“2023-10-31 00:00:00”), (“2023-11-01 00:00:00”))(“replication_num” = “2”),
PARTITION p20231101 VALUES [(“2023-11-01 00:00:00”), (“2023-11-02 00:00:00”))(“replication_num” = “2”),
PARTITION p20231102 VALUES [(“2023-11-02 00:00:00”), (“2023-11-03 00:00:00”))(“replication_num” = “2”),
PARTITION p20231103 VALUES [(“2023-11-03 00:00:00”), (“2023-11-04 00:00:00”))(“replication_num” = “2”),
PARTITION p20231104 VALUES [(“2023-11-04 00:00:00”), (“2023-11-05 00:00:00”))(“replication_num” = “2”),
PARTITION p20231105 VALUES [(“2023-11-05 00:00:00”), (“2023-11-06 00:00:00”))(“replication_num” = “2”),
PARTITION p20231106 VALUES [(“2023-11-06 00:00:00”), (“2023-11-07 00:00:00”))(“replication_num” = “2”),
PARTITION p20231107 VALUES [(“2023-11-07 00:00:00”), (“2023-11-08 00:00:00”))(“replication_num” = “2”),
PARTITION p20231108 VALUES [(“2023-11-08 00:00:00”), (“2023-11-09 00:00:00”))(“replication_num” = “2”),
PARTITION p20231109 VALUES [(“2023-11-09 00:00:00”), (“2023-11-10 00:00:00”))(“replication_num” = “2”),
PARTITION p20231110 VALUES [(“2023-11-10 00:00:00”), (“2023-11-11 00:00:00”))(“replication_num” = “2”),
PARTITION p20231111 VALUES [(“2023-11-11 00:00:00”), (“2023-11-12 00:00:00”))(“replication_num” = “2”),
PARTITION p20231112 VALUES [(“2023-11-12 00:00:00”), (“2023-11-13 00:00:00”))(“replication_num” = “2”),
PARTITION p20231113 VALUES [(“2023-11-13 00:00:00”), (“2023-11-14 00:00:00”))(“replication_num” = “2”),
PARTITION p20231114 VALUES [(“2023-11-14 00:00:00”), (“2023-11-15 00:00:00”))(“replication_num” = “2”),
PARTITION p20231115 VALUES [(“2023-11-15 00:00:00”), (“2023-11-16 00:00:00”))(“replication_num” = “2”),
PARTITION p20231116 VALUES [(“2023-11-16 00:00:00”), (“2023-11-17 00:00:00”))(“replication_num” = “2”),
PARTITION p20231117 VALUES [(“2023-11-17 00:00:00”), (“2023-11-18 00:00:00”))(“replication_num” = “2”),
PARTITION p20231118 VALUES [(“2023-11-18 00:00:00”), (“2023-11-19 00:00:00”))(“replication_num” = “2”),
PARTITION p20231119 VALUES [(“2023-11-19 00:00:00”), (“2023-11-20 00:00:00”))(“replication_num” = “2”),
PARTITION p20231120 VALUES [(“2023-11-20 00:00:00”), (“2023-11-21 00:00:00”))(“replication_num” = “2”),
PARTITION p20231121 VALUES [(“2023-11-21 00:00:00”), (“2023-11-22 00:00:00”))(“replication_num” = “2”),
PARTITION p20231122 VALUES [(“2023-11-22 00:00:00”), (“2023-11-23 00:00:00”))(“replication_num” = “2”),
PARTITION p20231123 VALUES [(“2023-11-23 00:00:00”), (“2023-11-24 00:00:00”))(“replication_num” = “2”),
PARTITION p20231124 VALUES [(“2023-11-24 00:00:00”), (“2023-11-25 00:00:00”))(“replication_num” = “2”),
PARTITION p20231125 VALUES [(“2023-11-25 00:00:00”), (“2023-11-26 00:00:00”))(“replication_num” = “2”),
PARTITION p20231126 VALUES [(“2023-11-26 00:00:00”), (“2023-11-27 00:00:00”))(“replication_num” = “2”),
PARTITION p20231127 VALUES [(“2023-11-27 00:00:00”), (“2023-11-28 00:00:00”))(“replication_num” = “2”),
PARTITION p20231128 VALUES [(“2023-11-28 00:00:00”), (“2023-11-29 00:00:00”))(“replication_num” = “2”),
PARTITION p20231129 VALUES [(“2023-11-29 00:00:00”), (“2023-11-30 00:00:00”))(“replication_num” = “2”),
PARTITION p20231130 VALUES [(“2023-11-30 00:00:00”), (“2023-12-01 00:00:00”))(“replication_num” = “2”),
PARTITION p20231201 VALUES [(“2023-12-01 00:00:00”), (“2023-12-02 00:00:00”))(“replication_num” = “2”),
PARTITION p20231202 VALUES [(“2023-12-02 00:00:00”), (“2023-12-03 00:00:00”))(“replication_num” = “2”),
PARTITION p20231203 VALUES [(“2023-12-03 00:00:00”), (“2023-12-04 00:00:00”))(“replication_num” = “2”))
DISTRIBUTED BY HASH(product_name, chr_id) BUCKETS 12
PROPERTIES (
“replication_num” = “2”,
“in_memory” = “false”,
“storage_format” = “DEFAULT”,
“enable_persistent_index” = “false”,
“compression” = “LZ4”
);
如果没有拿 date_time去做分区条件，这个条件就可以生效
