Open
Description
CREATE TABLE test_timestamp (
created TIMESTAMP COMMENT '创建时间'
) PARTITIONED BY (dt STRING) STORED AS ORC;
insert overwrite table test_timestamp partition(dt='2025-05-12')
values('2025-05-12 12:32:00');
2.
insert overwrite table test_timestamp partition(dt='2025-05-13')
select
created
from test_timestamp
where dt='2025-05-12';
3. select dt,created from test_timestamp where dt>='2025-05-12';
dt created
2025-05-12 2025-05-12 12:32:00
2025-05-13 2025-05-12 20:32:00