Limit of 1 TB to compressed or uncompressed storage
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;
0
Comments
Use the audit() function
https://my.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/SQLReferenceManual/Functions/VerticaFunctions/LicenseManagement/AUDIT.htm?Highlight=audit
@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