| Actor | Fragment | Worker | State |
|---|---|---|---|
| 96011 | 16020 | 26 | running |
| 98849 | 16018 | 26 | running |
| 98850 | 16018 | 26 | running |
| 98851 | 16019 | 26 | running |
| 98852 | 16021 | 26 | running |
| 98853 | 16021 | 26 | running |
CREATE TABLE olap.fixed_deposit_accounts_ft (
account_id VARCHAR,
fact_date DATE,
principal DECIMAL,
profit_rate DECIMAL,
profit_accrued DECIMAL,
auto_renewal_status VARCHAR,
disabled_at TIMESTAMPTZ,
PRIMARY KEY (account_id, fact_date),
WATERMARK FOR fact_date AS CAST((
fact_date - INTERVAL '5 YEARS'
) AS DATE) WITH TTL
) FROM olap.olap_source TABLE 'olap.fixed_deposit_accounts_ft'