Dictionaries configuration [Документация VAS Experts]
Документация VAS Experts Документация VAS Experts-mobile
in

Settings

  • Show page
  • Old revisions
  • Export to PDF
  • Backlinks
  • Show page
  • Old revisions
  • Export to PDF
  • Backlinks

    • Differences

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

    Link to this comparison view

    Both sides previous revisionPrevious revision
    en:dpi:dpi_components:qoestor:dictionaries:config:start [2023/08/29 07:46] – edrudichgmailcomen:dpi:dpi_components:qoestor:dictionaries:config:start [Unknown date] (current) – removed - external edit (Unknown date) 127.0.0.1
    Line 1: Line 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 [[en:dpi:dpi_components:dpiui:user_guide:qoe_analytics:admin:dics:start|Information about dictionaries]]. 
    -