We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


NULL Values do not Count Against Your Vertica License! — Vertica Forum

NULL Values do not Count Against Your Vertica License!

Jim_KnicelyJim_Knicely - Select Field - Administrator

I get asked a lot if NULL values stored in table columns are counted against the raw data size of a Vertica license. The answer is no.

Example:

dbadmin=> SELECT audit_length(123);
audit_length
--------------
            3
(1 row)

dbadmin=> SELECT audit_length(NULL);
audit_length
--------------
            0
(1 row)

dbadmin=> CREATE TABLE test (c1 INT);
CREATE TABLE

dbadmin=> INSERT INTO test SELECT 123;
OUTPUT
--------
      1
(1 row)

dbadmin=> SELECT audit('test');
audit
-------
3
(1 row)

dbadmin=> INSERT INTO test SELECT NULL;
OUTPUT
--------
      1
(1 row)

dbadmin=> SELECT audit('test');
audit
-------
3
(1 row)

Helpful Links:
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/Licensing/CalculatingTheDatabaseSize.htm

Have fun!

Sign In or Register to comment.