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!
Data Collector Tables (Are they tables or views)?
Moderator: NorbertKrupa
Data Collector Tables (Are they tables or views)?
Thanks,
Juliette
Juliette
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: Data Collector Tables (Are they tables or views)?
There are no data collector tables which are views. They are physical tables. You can find out which system tables are views with:
You're then able to pull the corresponding view from vs_system_views. Read my blog post for more info.
Code: Select all
SELECT * FROM v_internal.vs_system_tables WHERE is_view = 't' ORDER BY table_name;
Checkout vertica.tips for more Vertica resources.
Re: Data Collector Tables (Are they tables or views)?
If the DC tables are physical tables, I wonder how Vertica is limiting the result set.
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!
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)
Thanks,
Juliette
Juliette
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: Data Collector Tables (Are they tables or views)?
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.
Checkout vertica.tips for more Vertica resources.