CREATE TABLE `feature_importance` (
  `modelUuid` varchar(100) NOT NULL,
  `targetMetric` varchar(100) NULL,
  `entityType` varchar(100) NULL,
  `entityId` varchar(100) NULL,
  `encoder` varchar(100) NULL,
  `group` varchar(100) NULL,
  `featureName` varchar(100) NULL,
  `importanceScore` float NULL,
  `lastUpdatedDateTime` datetime NULL,
  `creationDateTime` datetime NULL,
  INDEX feature_importance_modelUuid_idx (`modelUuid`) USING INVERTED
) ENGINE=OLAP
UNIQUE KEY(`modelUuid`, `targetMetric`, `entityType`, `entityId`, `encoder`, `group`, `featureName`)
COMMENT 'OLAP'
DISTRIBUTED BY HASH(`modelUuid`) BUCKETS 8
PROPERTIES (
"replication_allocation" = "tag.location.default: 1",
"min_load_replica_num" = "-1",
"is_being_synced" = "false",
"storage_medium" = "hdd",
"storage_format" = "V2",
"inverted_index_storage_format" = "V1",
"enable_unique_key_merge_on_write" = "false",
"light_schema_change" = "true",
"disable_auto_compaction" = "false",
"enable_single_replica_compaction" = "false",
"group_commit_interval_ms" = "10000",
"group_commit_data_bytes" = "134217728"
);

CREATE TABLE `attention_plot` (
  `modelUuid` varchar(100) NOT NULL,
  `targetMetric` varchar(100) NULL,
  `entityType` varchar(100) NULL,
  `entityId` varchar(100) NULL,
  `timeIndex` datetime NULL,
  `horizon` varchar(100) NULL,
  `attentionScore` float NULL,
  `lastUpdatedDateTime` datetime NULL,
  `creationDateTime` datetime NULL,
  INDEX timeIndex (`timeIndex`) USING INVERTED
) ENGINE=OLAP
UNIQUE KEY(`modelUuid`, `targetMetric`, `entityType`, `entityId`, `timeIndex`, `horizon`)
COMMENT 'OLAP'
PARTITION BY RANGE(`timeIndex`)()
DISTRIBUTED BY HASH(`modelUuid`, `timeIndex`) BUCKETS 8
PROPERTIES (
"replication_allocation" = "tag.location.default: 1",
"min_load_replica_num" = "-1",
"is_being_synced" = "false",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "MONTH",
"dynamic_partition.time_zone" = "Etc/UTC",
"dynamic_partition.start" = "-2147483648",
"dynamic_partition.end" = "1",
"dynamic_partition.prefix" = "p",
"dynamic_partition.replication_allocation" = "tag.location.default: 2, tag.location.offline: 1",
"dynamic_partition.buckets" = "4",
"dynamic_partition.create_history_partition" = "true",
"dynamic_partition.history_partition_num" = "18",
"dynamic_partition.hot_partition_num" = "0",
"dynamic_partition.reserved_history_periods" = "NULL",
"dynamic_partition.storage_policy" = "",
"dynamic_partition.storage_medium" = "HDD",
"dynamic_partition.start_day_of_month" = "1",
"storage_medium" = "hdd",
"storage_format" = "V2",
"inverted_index_storage_format" = "V1",
"enable_unique_key_merge_on_write" = "false",
"light_schema_change" = "true",
"disable_auto_compaction" = "false",
"enable_single_replica_compaction" = "false",
"group_commit_interval_ms" = "10000",
"group_commit_data_bytes" = "134217728"
);