hive/doris查询表的创建和更新时间

hive查询表的创建和更新时间：
SELECT
d.NAME AS database_name,
t.TBL_NAME AS table_name,
FROM_UNIXTIME(t.CREATE_TIME) AS create_time,
FROM_UNIXTIME(tp.PARAM_VALUE) AS last_ddl_time
FROM
metastore.TBLS t
JOIN metastore.DBS d ON t.DB_ID = d.DB_ID
JOIN metastore.TABLE_PARAMS tp ON t.TBL_ID = tp.TBL_ID
WHERE
tp.PARAM_KEY = ‘transient_lastDdlTime’
and LENGTH(t.TBL_NAME)!=32
and t.TBL_NAME like ‘%\_%’ ;

doris查询表的创建和更新时间
select TABLE_SCHEMA,TABLE_NAME,CREATE_TIME,UPDATE_TIME from information_schema.tables;

hive查询表最近7天创建：
SELECT
d.NAME AS database_name,
t.TBL_NAME AS table_name,
FROM_UNIXTIME(t.CREATE_TIME) AS create_time
FROM
metastore.TBLS t
JOIN metastore.DBS d ON t.DB_ID = d.DB_ID
WHERE
from_unixtime(t.CREATE_TIME, ‘%Y-%m-%d’) > date_sub(curdate(), interval 7 day)
and LENGTH(t.TBL_NAME)!=32
and t.TBL_NAME like ‘%\_%’ ;

doris查询表最近7天创建：
select TABLE_SCHEMA,TABLE_NAME,CREATE_TIME from information_schema.tables where CREATE_TIME >= NOW() - INTERVAL 7 DAY;