queryda

Queryda loves your data as much as you do! Designed for lightweight, intelligent alarming, it will execute and "watch" Elasticsearch and Cassandra queries via workers, comparing their results to one or more given expectations via a pipeline of validators. When query results does not match the expectations, a reporter is notified and can perform any kind of action (e.g. heat up the coffeemaker via IFTTT before sending an email to your dev team).

For a natively ELK/Elassandra UI integrated and advanced alerting plarform, check out our Kibana App SENTINL

Getting started

npm

Install globally using npm

npm install -g queryda

Manual

or clone the git repository and install the dependencies locally

git clone https://github.com/lmangani/queryda.git
cd queryda
npm install

Usage

Quick Examples

Elasticsearch

To see an Elasticsearch example, see examples/elasticsearch

Cassandra

To see a Cassandra example, see examples/cassandra


Set Alert from Command-Line

Let's run queryda with the following commandline (or using the example.json from the jobs dir).

bin/queryda \
--elasticsearch='{"host":"localhost","port":9200,"index":"monitoring","type":"rum"}' \
--query='{"range":{"timestamp":{"gt":"2018-01-01T00:00:01","lt":"2018-01-01T23:59:59"}}}' \
--aggs='{}' \
--validators='{"range":{"fieldName":"renderTime","min":0,"max":500,"tolerance":4}}' \
--reporters='{"console":{}}' --debug --name test

Set Alert from Config

queryda can also be executed using a self-contained configuration file (see example.json)

bin/queryda --configfile /path/to/watcherjob.json

Configuration

queryda can be configured either via commandline or using a JSON file (suggested method via --configfile parameter). Both ways require to specify option groups with individual settings (e.g. for elasticsearch, for the reporters, for the validator, ..). A set of example JSON files for Cassandra and Elasticsearch can be found in the jobsdir.

The following options are currently available:

name (required)

A name of your choice to identify this job. This will be used by the reporters to identitfy this individual call.

Elasticsearch

elasticsearch (elasticsearch only, required)

Settings for elasticsearch, expects the following madatory fields:

  • host: where to find the elasticsearch host
  • port: which port elasticsearch is running on
  • index: the index name to send youe query to
  • type: the document type to query

query (required)

An elasticsearch query statement. Refer to the elasticsearch documentation for details about syntax and features. Should return a result set that contains the supplied fieldName to match against.

aggs (elasticsearch only, required)

An elasticsearch aggregation statement. Refer to the elasticsearch documentation for details about syntax and features. Should return a result set that contains the supplied aggName to match against.

Cassandra

cassandra (cassandra only, required)

Settings for elasticsearch, expects the following madatory fields:

  • host: where to find the cassandra host
  • keyspace: which to use for queries

cqlquery (required)

A Cassandra query statement. Refer to the cassandra documentation for details about syntax and features. Should return a result set that contains the supplied fieldName to match against.

params (cassandra only, required)

A set of Parameters/Variable to be used by the CQL Query.

validators (required)

Validator(s) to compare the query results against. Expects an object with key/value pairs where key ist the name of the validator and value is the validator-specific configuration. See Validators for more details.

reporters (required)

Reporter(s) to notify about alarms. Expects an object with key/value pairs where key ist the name of the reporter and value is the reporter-specific configuration. See Reporters for more details.

configfile

Name of JSON file to read config from. Expects main options as top-level properties (see example.json for a live example).

Validators

A Validator takes a query result received from elasticsearch and compares it against a given expectation. This can be as easy as checking if a value equals a given constant or as complex as checking the average of a series of values against an allowed range with an explicit threshold.

Available Validators

Range

The Range Validator checks a given Field for mix/max boundaries with tolerance factor.

Expects the following mandatory fields:

  • fieldName: The name of the field in the result set, that is compared against the defined expectation.
  • min: The minimum allowed value for all values within the query. If a series of values (as defined through the tolerance property) in the result is lower than this minimum an alarm is raised and reported.
  • max: The maxmimum allowed value for all values within the query. If a series of values (as defined through the tolerance property) in the result exceed this maximum an alarm is raised and reported.
  • tolerance: If a queried series of values exceeds either min or max for tolerance+1 times an alarm is raised.
Range Example
 "validators": {
    "range": {
        "fieldName": "value",
        "min": 0,
        "max": 500,
        "tolerance": 4
    }
  },

Anomalies

The Anomalies Validator can determine clusters of data and then also identify values which do not identify with any derived cluster and delcare them outliers.

Expects the following mandatory field:

  • fieldName: The name of the field in the result set, that is tested for series anomalies.
Anomalies Example
 "validators": {
    "anomalies": {
        "fieldName": "value",
        "tolerance": 0

    }
  },

Custom validators

You can create custom validators by creating a new class that extends the Validator class (see RangeValidator for an example).

Reporters

By default queryda does nothing more than executing its configured jobs, raising alarms if expectations aren't met. If you want to perform any action in such an alarm case, you have to define a reporter.

To put it simple - reporters are notified about alarms, which means a configured expectation isn't met for a given number of times. They can then do helpful things depending on their type like sending an email, creating a ticket in your ticket system, etc.

Reporters are defined inside a job's config, you can set either one or multiple of them. Most reporters need a specific configuration that is based on the reporter type.

Available reporters

ConsoleReporter

The ConsoleReporter is just meant for demonstration purpose and simply logs a message to the console and has no configuration options.

MailReporter

The MailReporter sends an email to one (or multiple) given e-mail address(es). It offers the following configuration:

"reporters": {
  "mail": {
    // comma-separated list of target addresses for notification
    "targetAddress": "[email protected],[email protected]"
    // number of retry attempts if sending mail fails (defaults to 3)
    "maxRetries": 3
  }
}

Custom reporters

You can create custom reporters by creating a new class that extends the Reporter class (see ConsoleReporter for an example).

TODO

There's plenty of work to be done in order to make this tool powerful - any help and contribution is appreciated!

  • Cleanup, Revamp output for usefulness.
  • Port transform, validate, actions from SENTINL
  • Properly modularize input Workers
  • Implement Cassandra Support
  • Implement Clickhouse Support
  • Implement InfluxDB Support
  • Implement GunDB Support
    • Integrate SENTINL Clustering
  • Implement pseudo-cascading programming as in Kapacitor

Credits and Acknowledgements

All rights reserved by their respective owners.

Original Fork based on Elasticwatch-JS by QXIP, and its Coffeescript parent.

Apache Cassandra, Apache Lucene, Apache, Lucene, Solr, TinkerPop, and Cassandra are trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries.

Elasticsearch and Kibana are trademarks of Elasticsearch BV, registered in the U.S. and in other countries.

Elassandra is a trademark of Strapdata SAS.

Sentinl is a trademark of QXIP BV and Siren Solutions.

Queryda

Lightweight, Extensible Query Watcher for Elasticsearch / Elassandra / Cassandra

Queryda Info

⭐ Stars 12
🔗 Homepage qxip.net
🔗 Source Code github.com
🕒 Last Update a year ago
🕒 Created 6 years ago
🐞 Open Issues 0
➗ Star-Issue Ratio Infinity
😎 Author QXIP