Is it possible to define multiple key-value pairs ...
# questions-and-troubleshooting
s
Is it possible to define multiple key-value pairs within the "labels.location" property? I'm referring to the following documentation page which only illustrates a single key-value pair rack:rack1 https://docs.starrocks.io/docs/administration/management/resource_management/be_label/ It would be useful, if it was possible to define multiple kv pairs such as:
Copy code
SET ("labels.location" = "rack:rack1; tier:hot");
And then be able to constrain a table's data to a particular tier. Can this be done? Thanks!
to answer my own question: I looked at the source code and specifying multiple key-value pairs is not yet implemented on the BE node side. So one would have to encode all kv pairs into a single value. However, on the table side, only up to 10 labels are supported and asterisk pattern are only defined as the entire value part. This means that using labels not only for placement control but also to handle tiering is risky for larger clusters in which the table labels could exceed the maximum number of entries. In StarRocks 4.x, it seems that one could use warehouse labels for the tiering? Constraining a table to a warehouse?