Feedback
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 functionlast_value(arg):
last_value
window functionnth_value(arg, number):
nth_value
window functionThe 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:
SELECT (information_schema and sys schemas only)
If you wish to use CrateDB without an enterprise license and without the 3 nodes limitation, you can switch to the Community Edition.