CREATE DATABASE mydb WITH (ttl = '1h');

SHOW DATABASES;

SHOW FULL DATABASES;

SHOW CREATE DATABASE mydb;

USE mydb;

CREATE TABLE test(host STRING, cpu DOUBLE, ts TIMESTAMP TIME INDEX);

SHOW CREATE TABLE test;

USE public;

DROP DATABASE mydb;

SHOW DATABASES;