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;
+2@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:
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
