Differences

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

--- en:dpi:dpi_components:qoestor:data_export:start [2021/09/02 09:33] – created arusnak
+++ en:dpi:dpi_components:qoestor:data_export:start [Unknown date] (current) – removed - external edit (Unknown date) 127.0.0.1
@@ Line 1: / Line 1: @@
-===== 5 Data export =====
-{{indexmenu_n>5}}
-If necessary, you can independently generate your own reports without additional tools and upload data in any CSV, JSON, TabSeparated format.
-Data is stored in 4 main logs
-  * qoestor.fullflow – full netflow log, storage period - 2 hours by default
-  * qoestor.clicksteam – full clickstream log, storage period - 2 hours by default
-  * qoestor.fullflow_agg – pre-aggregated netflow log, storage period - 14 days by default
-  * qoestor.clicksteam_agg – pre-aggregated clickstream log, storage period - 14 days by default
-The command format is as follows <code>clickhouse-client --database=qoestor  --query="Your sql is here"</code>
-By default data is uploaded in TabSeparated format.
-**Пример**. The client asked for a log of connections to a specific host in CSV format
-<code>clickhouse-client --database=qoestor --query="select * from fullflow prewhere flow_start_date = '2018-10-04' where (source_ipv4 = '10.64.66.100' or destination_ipv4 = '10.64.66.100') and host = 'google.com' ORDER BY flow_start_time limit 10 format CSV"</code>
-For detailed information on SQL ClickHouse, see the link [[https://clickhouse.yandex/docs/ru/query_language/select/]]

Profile