Vertica GET_COMPLIANCE_STATUS() discrepancy
We use Vertica Community Edition which allows us to store data up to 1 TB. Vertica is hosted on-premise and we have allocated 153 GB for it to use, out of which 57 GB (39%) is used so far.
When I run SELECT GET_COMPLIANCE_STATUS(), it shows I have used 0.91 TB (91%) of the allowed disk space. I have executed SELECT AUDIT_LICENSE_SIZE() to make sure we get the latest compliance data.
I am wondering why these numbers do not match.
The disk usage is the compressed/encoded ROS files.
For license calculation Vertica uses uncompressed files to sum over the total size. 1 TB for community edition is uncompressed size of the files.
Disk usage can vary depending upon how many projections you create.
Note: Additional Projections does not count to the license size. Only additional Tables and External tables do.
- Why do we use char/varchar instead of varbinary/binary?
- SQL query to track a sequence of sites visited by a user in a session
- Connect Vertica DB in SpringBoot App with multiple datasource
- sql round function throw error - Schema "pg_catalog" does not exist
- How can I connect vertica with JDBC?
- aggregate function to concatenate strings in Vertica
- Can I connect to Vertica and HDFS in the same project using dbt core?
- Concat GROUP BY in Vertica SQL
- SQL left outer join on multiple columns
- how to use COUNT(DISTINCT error_code) OVER () in vertica
- shorten the value by underscore in Vertica
- How to Group By a column without adding another column with aggregate function
- Transform 2 'number' columns to 'varchar' and 'number' columns depending on column names
- Vertica SQL query to find Hostnames,CPU and Timestamps for CPU >80 continously for 2 hrs
- How to get Notice and Hint logs of vertica cli into a file
- Duplicated and Missing Values in Vertica Time Series Analytics Query
- How to pivot resultset in vertica
- Vertica: Convert Bitstrint to integer
- Can I integrate a custom PDO wrapper in Laravel
- Time difference between rows based on condition
- Vertica: Input record 1 has been rejected (Too few columns found)
- Multi url hosts in JDBC connection
- SQL filter if ID doesn't have a value in another column
- Count district values based on another coulmn
- Vertica GET_COMPLIANCE_STATUS() discrepancy
- Vertica: ORDER BY ASC and DESC for date and time is giving same value
- How can we uniquely identify a each record in Vertica database in absence of a primary key?
- Convert comma separated string to a list
- DML operation performance for large table with multiple projections in vertica
- Is there a Regex to get 5th occurence in a following string?