建表语句
CREATE TABLE metric_table (
datekey INT NULL,
hour INT NULL,
tt INT NULL,
device_id BITMAP NOT NULL
) ENGINE=OLAP
DUPLICATE KEY(datekey, hour, tt)
DISTRIBUTED BY RANDOM BUCKETS AUTO
PROPERTIES (
"replication_allocation" = "tag.location.default: 3",
"min_load_replica_num" = "-1",
"is_being_synced" = "false",
"storage_medium" = "hdd",
"storage_format" = "V2",
"inverted_index_storage_format" = "V1",
"light_schema_change" = "true",
"disable_auto_compaction" = "false",
"enable_single_replica_compaction" = "false",
"group_commit_interval_ms" = "10000",
"group_commit_data_bytes" = "134217728"
)
报错ERROR 1105 (HY000): errCode = 2, detailMessage = column:device_id must be used in AGG_KEYS or UNIQUE_KEYS.
但是在2.1版本是可以的。想请教一下是2.0版本明细表不支持bitmap类型嘛
