All dictionaries are located in the folder /var/qoestor/backend/etc/db/ and have the .txt extension.

Each dictionary has a sample.txt example file that can be used as a template.

All columns in the dictionaries are separated by a tab character (\t). The number of \t characters must be one less than the number of columns in the dictionary. Pay close attention to this.

When files are modified, the data is automatically reloaded into the database.

Some useful commands for working with dictionaries:

• Speed up dictionary data refresh

  clickhouse-client --database=qoestor --query="system reload dictionaries"

• Check if there are errors in dictionaries

  clickhouse-client --database=qoestor --query="select * from system.dictionaries"

• Check if a dictionary contains data, for example, for subnets_local_dic

  clickhouse-client --database=qoestor --query="select * from subnets_local_dic"

In dpiui2, in the QoE Analytics / Administrator / Dictionary Information section, you can view a list of dictionaries, errors, and contents. See Dictionary Information.