search

StarRocks / starrocks

StarRocks, a Linux Foundation project, is a next-generation sub-second MPP OLAP database for full analytics scenarios, including multi-dimensional analytics, real-time analytics, and ad-hoc queries.
https://starrocks.io
Apache License 2.0
8.61k stars 1.74k forks source link

Unable to get TTL information for partitioned tables created by time function expressions #34779

Closed moody1117 closed 2 months ago

moody1117 commented 9 months ago

Steps to reproduce the behavior (Required)

CREATE TABLE realtime.dwd_bolean_sa_event_standard_detail_ri_new ( event_ts datetime NOT NULL COMMENT "事件发生时间", id BIGINT NOT NULL COMMENT "雪花id" ) ENGINE=OLAP DUPLICATE KEY(event_ts,id) COMMENT "DWD事件明细表" PARTITION BY date_trunc('day', event_ts) DISTRIBUTED BY HASH(event_ts) PROPERTIES ( "replication_num" = "1", "partition_live_number" = "30", "in_memory" = "false", "storage_format" = "DEFAULT" );

Expected behavior (Required)

1.Get Start field information by SHOW DYNAMIC PARTITION TABLES.

image
  1. information_schema.tables_config image

Real behavior (Required)

1.SHOW DYNAMIC PARTITION TABLES; Cannot get the table created by the time function. 2.No partition_live_number field in information_schema.tables_config

image

StarRocks version (Required)

github-actions[bot] commented 3 months ago

We have marked this issue as stale because it has been inactive for 6 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to StarRocks!