Enterprise Features

Table of Contents

Feature List

The default distribution of CrateDB contains the following enterprise features:

  • User Management: manage multiple database users
  • Privileges: configure user privileges
  • Authentication: manage your database with authentication, and more
  • System information functions: CURRENT_USER, USER, SESSION_USER
  • Support for JavaScript in UDF: write user-defined functions in JavaScript
  • JMX Monitoring: monitor your query stats with JMX
  • MQTT Ingestion Source: ingest data using MQTT without any 3rd party tools
  • hyperloglog_distinct: distinct count aggregation using the HyperLoglog++ algorithm
  • first_value(arg): first_value window function
  • last_value(arg): last_value window function
  • nth_value(arg, number): nth_value window function
  • The CrateDB admin UI: shards browser, monitoring overview, privileges browser

Note

It is also possible to build a Community Edition which won’t contain these features but which can be used without licensing restrictions.

Trial

You may evaluate CrateDB including all enterprise features with a trial license. This trial license is active by default and is limited to 3 nodes. If you require more than 3 nodes you must request an enterprise license and configure CrateDB using the SET LICENSE statement.

Caution

If you exceed the 3 nodes limitation your cluster will stop accepting queries. The functionality will be limited to:

  • SET LICENSE
  • SELECT (information_schema and sys schemas only)
  • DECOMMISSION <nodeId | nodeName>

If you wish to use CrateDB without an enterprise license and without the 3 nodes limitation, you can switch to the Community Edition.