Feedback

  Suggest improvement

  Edit page

  View page source

3.3

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.