Differences

This shows you the differences between two versions of the page.

--- en:dpi:dpi_components:qoestor:dictionaries:config:start [2021/09/01 09:47] – created arusnak
+++ en:dpi:dpi_components:qoestor:dictionaries:config:start [Unknown date] (current) – removed - external edit (Unknown date) 127.0.0.1
@@ Line 1: / Line 1: @@
-===== 1 Dictionaries configuration  =====
-{{indexmenu_n>1}}
-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 <code>clickhouse-client --database=qoestor --query="system reload dictionaries"</code>
-  * Check if there are errors in dictionaries <code>clickhouse-client --database=qoestor --query="select * from system.dictionaries"</code>
-  * Check if there is data in the dictionary, for example for subnets_local_dic <code>clickhouse-client --database=qoestor --query="select * from subnets_local_dic"</code>
-Also in dpiui2 in the section QoE Analytics / Administrator / Information about dictionaries you can see the list of references, errors and contents. See section [[dpi:dpi_components:dpiui:uгser_guide:qoe_analytics:admin:dics:start|Information about dictionaries]].

Profile

Settings

Differences