Limit of 1 TB to compressed or uncompressed storage

Engineer1111

We are using Vertica community edition which comes with 1 TB of free storage. Is this limit based on the compressed or uncompressed storage?

Also i think this gives me the compressed space utilized by a table, how to get the uncomressed storage?

SELECT anchor_table_schema,
anchor_table_name,
SUM(used_bytes) / ( 1024^3 ) AS used_compressed_gb
FROM v_monitor.column_storage
GROUP BY anchor_table_schema,
anchor_table_name
ORDER BY SUM(used_bytes) DESC;

Ben_Vandiver

Use the audit() function
https://my.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/SQLReferenceManual/Functions/VerticaFunctions/LicenseManagement/AUDIT.htm?Highlight=audit

Jim_Knicely

@Engineer1111 - The CE licence is based on uncompressed data size. As Ben pointed out, you can use the AUDIT function to get the raw data size (in bytes) of a database, schema, or table as it is counted in an audit of the database size.

Several other useful license functions include DISPLAY_LICENSE and GET_COMPLIANCE_STATUS.

Examples:

dbadmin=> SELECT display_license();
                         display_license
-----------------------------------------------------------------
 Vertica Community Edition
2011-11-22
Perpetual
1TB CE Nodes 3

(1 row)

dbadmin=> SELECT get_compliance_status();
                                                                                                                                      get_compliance_status                                            
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Raw Data Size: 0.02TB +/- 0.00TB
 License Size : 1.00TB
 Utilization  : 2%
 Audit Time   : 2018-08-17 08:13:22.141843-04
 Node count : 1
 License Node limit : 3
 Compliance Status : The database is in compliance with respect to raw data size.

 No expiration date for a Perpetual license

(1 row)

For a complete list of "License Management Functions", go here:

https://my.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/SQLReferenceManual/Functions/VerticaFunctions/LicenseManagement/LicenseManagementFunctions.htm