By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| partition_name | timestamp |
|---|---|
| p0 | 1581724800 |
| p1 | 1581708508 |
| p1 | 1581708807 |
| MAX(id) |
|---|
| 2 |
| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | PARTITION_NAME | SUBPARTITION_NAME | PARTITION_ORDINAL_POSITION | SUBPARTITION_ORDINAL_POSITION | PARTITION_METHOD | SUBPARTITION_METHOD | PARTITION_EXPRESSION | SUBPARTITION_EXPRESSION | PARTITION_DESCRIPTION | TABLE_ROWS | AVG_ROW_LENGTH | DATA_LENGTH | MAX_DATA_LENGTH | INDEX_LENGTH | DATA_FREE | CREATE_TIME | UPDATE_TIME | CHECK_TIME | CHECKSUM | PARTITION_COMMENT | NODEGROUP | TABLESPACE_NAME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| def | db_60809827 | messages | p0 | null | 1 | null | HASH | null | `timestamp` DIV 43200 | null | null | 1 | 16384 | 16384 | null | 0 | 0 | 2021-04-17 05:07:23 | 2021-04-17 05:07:23 | null | null | default | null | |
| def | db_60809827 | messages | p1 | null | 2 | null | HASH | null | `timestamp` DIV 43200 | null | null | 2 | 8192 | 16384 | null | 0 | 0 | 2021-04-17 05:07:23 | 2021-04-17 05:07:23 | null | null | default | null |