Vertica Blog

HPBigData_BP

User Security Auditing in Vertica

HPBigData_BP
March 9, 2016

Are you a database administer who manages users and roles in your Vertica database? Do you need to keep track of who has permission to access certain database objects? If so, here's a quick guide to queries that help you review the users, roles, privileges, and permissions that you have configured in your database. These...
Programmer

Improving COUNT DISTINCT Performance with Live Aggregate Projections

HPBigData_BP
February 17, 2016

Today?s organizations need to be able to measure the effectiveness of online ads and marketing campaigns. In your particular organization, you may want to measure how effectively your ads drive unique visitors to your website. Or you may want to see if your ads drive repeat visits from the same user over a specific period...