Hi all,
Anyone know if NULL values in tables count against the Vertica license's raw data size?
Thank you
Do NULL values count against my license?
Moderator: NorbertKrupa
-
- Beginner
- Posts: 36
- Joined: Fri Feb 17, 2012 6:09 pm
- Contact:
Re: Do NULL values count against my license?
No, assuming you're using Vertica v7.1.2
Reference:
http://vertica.tips/2015/07/27/license- ... -in-7-1-2/
https://community.dev.hp.com/t5/Vertica ... a-p/231099
Reference:
http://vertica.tips/2015/07/27/license- ... -in-7-1-2/
https://community.dev.hp.com/t5/Vertica ... a-p/231099
Re: Do NULL values count against my license?
Awesome, thanks!
BTW, I did t his simple test to confirm:
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)