Dictionaries

Dictionary configuration

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.

List of dictionaries

Dictionary	Description	Columns	Example	Notes
asnum_dic	Network AS dictionary. Cloud-based, loaded on schedule. Not editable.	1. AS number 2. AS name	0 -Reserved AS-, ZZ 1 LVLT-1, US 2 UDEL-DCN, US 3 MIT-GATEWAYS, US 4 ISI-AS, US 5 SYMBOLICS, US 6 BULL-HN, US 7 DSTL, GB 8 RICE-AS, US ...