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

There is a sample sample.txt for each dictionary. Can be used as a template.

All columns in dictionaries are separated by a tab (\t) character. The number of \t must be one less than the number of columns in the lookup. Watch this carefully.

When changing files, the data is loaded into the database automatically.

Some useful commands when working with dictionaries:

• Speed up updating data in directories

  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 there is data in the dictionary, for example for subnets_local_dic

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

Also in dpiui2 in the section QoE Analytics / Administrator / Information about dictionaries you can see the list of references, errors and contents. See section Information about dictionaries.