Enterprise Features

Table of Contents

• Feature List
• Trial

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.