Search found 221 matches
- Tue Oct 07, 2014 1:05 pm
- Forum: Vertica Database Administration
- Topic: Data Collector Tables (Are they tables or views)?
- Replies: 3
- Views: 7767
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. 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_no...
- Mon Oct 06, 2014 5:02 pm
- Forum: Vertica Database Administration
- Topic: Data Collector Tables (Are they tables or views)?
- Replies: 3
- Views: 7767
Data Collector Tables (Are they tables or views)?
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!
Anyone know if the DC_ tables are actual tables, or are they views? If they are views, can we see the code anywhere?
Thanks!
- Tue Sep 23, 2014 1:49 pm
- Forum: Vertica Data Load
- Topic: LOAD_STREAMS table sorted = unsorted ?
- Replies: 6
- Views: 22529
Re: LOAD_STREAMS table sorted = unsorted ?
Here is a simple example... dbadmin=> CREATE TABLE test_dim dbadmin-> ( dbadmin(> test_ID int NOT NULL, dbadmin(> test_PROFILE_DIM_ID int NOT NULL, dbadmin(> test_KEY varchar(14) NOT NULL, dbadmin(> INC_NAME varchar(100) NOT NULL, dbadmin(> AGE_NAME varchar(100) NOT NULL, dbadmin(> MAR_NAME varchar(...
- Mon Sep 22, 2014 7:43 pm
- Forum: Vertica Data Load
- Topic: LOAD_STREAMS table sorted = unsorted ?
- Replies: 6
- Views: 22529
Re: LOAD_STREAMS table sorted = unsorted ?
That doesn't explain why in my example, unsorted_row_count = sorted_row_count ...
- Mon Sep 22, 2014 6:58 pm
- Forum: Vertica Data Load
- Topic: LOAD_STREAMS table sorted = unsorted ?
- Replies: 6
- Views: 22529
LOAD_STREAMS table sorted = unsorted ?
Hi all, Does it seem to you that the output from the load streams table below is correct? Look at the last there columns. How can the unsorted row count equal the sorted row count? dbadmin=> \x Expanded display is on. dbadmin=> select * from load_streams; -[ RECORD 1 ]----------+--------------------...
- Wed Aug 27, 2014 11:25 am
- Forum: Vertica Database Administration
- Topic: Is there a System Table that Stores Failed SQL?
- Replies: 5
- Views: 14089
Re: Is there a System Table that Stores Failed SQL?
The query I proposed does that, provided that you have the corresponding query data for the error. Sorry, but I do not understand what you mean by this? I don't have the original query. It's what I am looking to find :) If I go directly to the DC_ERRORS table and see that I am getting a bunch of SQ...
- Tue Aug 26, 2014 4:52 pm
- Forum: Vertica Database Administration
- Topic: Is there a System Table that Stores Failed SQL?
- Replies: 5
- Views: 14089
Re: Is there a System Table that Stores Failed SQL?
Hi norbertk, Thanks for the response. I'm looking to find the actual SQL statement that failed. Like below, the "select 'a'::int;" statement I run is not in the v_monitor.error_messages table per your query: dbadmin=> select 'a'::int; ERROR 3681: Invalid input syntax for integer: "a" dbadmin=> SELEC...