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.
- ERROR: Insufficient resources to execute plan on pool general on running schema Update for Vertica database using portainer in WSL
- Remove double quotes from COPY vertica command
- SQL VERTICA group by intervals
- Convert a date to timestamp in a join with interpolation
- Spring, Hibernate issue with applying/using another SQL Dialect
- Can I integrate a custom PDO wrapper in Laravel
- 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
- 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