为了更快的定位您的问题,请提供以下信息,谢谢
【详述】问题详细描述
【背景】做过哪些操作?
【业务影响】查询一个主键,出现了两条数据
【是否存算分离】是
【StarRocks版本】3.3.2
表信息: 分区是较长的中文
ENGINE=OLAP
PRIMARY KEY(category_type
, platform
, content_id
)
COMMENT “OLAP”
PARTITION BY (category_type
,platform
)
DISTRIBUTED BY HASH(category_type
, content_id
)
PROPERTIES (
“compression” = “LZ4”,
“datacache.enable” = “true”,
“enable_async_write_back” = “false”,
“enable_persistent_index” = “true”,
“persistent_index_type” = “CLOUD_NATIVE”,
“replication_num” = “1”,
“storage_volume” = “builtin_storage_volume”
);
SELECT PARTITION_VALUE,COUNT(*) FROM information_schema.partitions_meta WHERE DB_NAME = ‘social’ and TABLE_NAME = ‘dwt_social_content_tag’ GROUP BY 1 order by 2 desc ;