Do NULL values count against my license?

Moderator: NorbertKrupa

Post Reply
User avatar
Jbaskin
Intermediate
Intermediate
Posts: 61
Joined: Sat Jan 28, 2012 1:21 pm

Do NULL values count against my license?

Post by Jbaskin » Mon Jul 27, 2015 3:36 pm

Hi all,

Anyone know if NULL values in tables count against the Vertica license's raw data size?

Thank you


User avatar
Jbaskin
Intermediate
Intermediate
Posts: 61
Joined: Sat Jan 28, 2012 1:21 pm

Re: Do NULL values count against my license?

Post by Jbaskin » Mon Jul 27, 2015 4:58 pm

Awesome, thanks!

BTW, I did t his simple test to confirm:

Code: Select all

dbadmin=> select audit('test');
 audit
-------
 0
(1 row)

dbadmin=> insert into test select null;
 OUTPUT
--------
      1
(1 row)

dbadmin=> select audit('test');
 audit
-------
 0
(1 row)

dbadmin=> insert into test select 1;
 OUTPUT
--------
      1
(1 row)

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

dbadmin=> select version();
              version
------------------------------------
 Vertica Analytic Database v7.1.2-2
(1 row)

Post Reply

Return to “New to Vertica Database Administration”