Licenses

This section describes the licensing models in Exasol.

Exasol provides a Raw Data license based on your contract with Exasol and your business requirements. The license specifies the maximum size of raw data that you can store across all databases in the cluster. This is the default license type.

The raw data volume corresponds to the data volume that is comparable to the size the data would have if stored as CSV files. If you exceed the licensed capacity, you cannot import any additional data unless you delete the data inside the database.

Audit data is not counted towards the raw data license limit.

For more details about how raw data size is determined, see Sizing for Data Types and Object Types.

For more information about licensing, contact your account manager or Exasol support.

Exasol previously offered a license type that specified the total amount of RAM that could be assigned to the databases in the cluster. This license type is now deprecated.

License limits

For licenses based on data size, a periodic check is done by Exasol on the size of the data. If the size limit exceeds the value specified in the license, the database does not permit any further data insertion until the usage drops below the specified value.

Audit data is not counted towards the license limit.

Enforced limits

As mentioned above, when storage limits are exceeded, all databases will enter a restricted mode, affecting the following statements:

  • IMPORT
  • INSERT
  • CREATE TABLE AS
  • MERGE
  • SELECT INTO

In this mode, any attempt to execute one of these statement types will result in an SQL exception as shown below: 

[R0010] Statement currently not allowed because latest cumulative database 
raw sizes of 10.6 GiB exceeded raw size license limit of 10.0 GiB (106.2%).
Please increase your license or delete some data and FLUSH STATISTICS.

When the system is above the license threshold, ALL of the above statements are locked, even if they would not result in an actual insertion of data (for example, the MERGE command).

Technical limits

If an Exasol system exceeds any of the defined technical limits, the database will fail to start. For more information about these limits, see System Limitations.

Recommended actions

To resolve the limit exceeded on your license, clear some large data (DROP or DELETE database tables) and perform FLUSH STATISTICS to update the current database sizes.

Clear sufficient data so that the license limit is below 100%. The checking of license limits is a periodic process, and it may take a few minutes for a database to recognize the uploaded sizes and leave the restricted mode.

Additionally, you can check the EXA_DB_SIZE_LAST_DAY table to view information on database sizes. You also can check EXA_SYSTEM_EVENTS table to view information on license events.