查询fe.log也是被截断的
2025-06-05 15:34:22,921 [query] |Client=192.168.1.130:58289|User=shaojun|Ctl=internal|Db=dim|State=ERR|ErrorCode=1105|ErrorMessage=Unexpected exception: errCode = 2, detailMessage = errCode = 2, detailMessage = Unable to find a suitable base table for partitioning, the fail reason is can't not find valid partition track column, because |Time(ms)=23|ScanBytes=0|ScanRows=0|ReturnRows=0|StmtId=10179376|QueryId=2e6e96ebefbc4eb2-b139f0e427ae0d2c|IsQuery=false|isNereids=true|feIp=192.168.1.34|Stmt=CRE
CREATE MATERIALIZED VIEW dim.dim_quna_new_machine_sku_limit
(
dt comment '',
city_id comment '',
city_name comment '',
warehousecode comment '',
warehouse comment '',
machine_type comment '',
machine_name comment '',
new_machine_type comment '',
point_tag_id comment '',
point_tag_name comment '',
sku_class_one comment '',
sku_limit comment '',
creator comment '',
ct comment '',
modifier comment '',
mt comment '',
status comment ''
)
REFRESH AUTO ON SCHEDULE EVERY 1 minute
COMMENT ''
PARTITION BY (dt)
DISTRIBUTED BY HASH(dt) BUCKETS auto
PROPERTIES (
"enable_nondeterministic_function" = "true",
"replication_num" = "3"
)
AS
select
curdate() as dt,
*
from
mysql144.zs_visual.zs_visual_new_recommend_alert_config
where is_del = 0 and status =0;
我知道现在不支持函数形成的字段作为分区字段，我的关注点是为什么报错不完整
