ClickHouse
Type: Columnar Database
Description: An open-source, columnar database management system designed for online analytical processing (OLAP). ClickHouse is optimized for fast analytics on large volumes of data and is suitable for real-time reporting.
How to send the query
Description
<clickhouse>
– the command which is responsible for sending the queries to ClickHouse DB in testing scenarios
Required parameters:
- comment
- alias - unique name of the DB you configured in your integration.xml file
- file - specifies the expected file name
- query - contains the ClickHouse DB query
Optional parameters :
- condition - condition according to which this test step will or won't be executed
- threshold - parameter, where the maximum execution time of the command is defined (milliseconds), if the execution time is exceeded, the step will be defined as failed
<clickhouse comment="Get all user's from system" alias="ALIAS" file="expected_1.json">
<query>SELECT * FROM t_user</query>
</clickhouse>