Data Collector Tables (Are they tables or views)?

[Julie]

Hi,

Anyone know if the DC_ tables are actual tables, or are they views? If they are views, can we see the code anywhere?

Thanks!

[NorbertKrupa]

There are no data collector tables which are views. They are physical tables. You can find out which system tables are views with:

Code: Select all

SELECT * FROM v_internal.vs_system_tables WHERE is_view = 't' ORDER BY table_name;

You're then able to pull the corresponding view from vs_system_views. Read my blog post for more info.

[Julie]

If the DC tables are physical tables, I wonder how Vertica is limiting the result set.

Code: Select all

dbadmin=> select distinct user_name from dc_requests_issued;
 user_name
-----------
 dbadmin
 julie
 tableau
(3 rows)

dbadmin=> \c my_1_node julie
You are now connected to database "my_1_node" as user "julie".
my_1_node=> select distinct user_name from dc_requests_issued;
 user_name
-----------
 julie
(1 row)

Is there something built into the execution engine that limits the records based on a user running the query? Sounds like fine-grained access control in Oracle!

[NorbertKrupa]

Depending on which collector you're looking at, you'll only have permissions to records that apply to the granted privileges. The physical data is stored in your catalog directory under DataCollector. Additionally, they each have predefined collection policies.