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...

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!

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(...

That doesn't explain why in my example, unsorted_row_count = sorted_row_count ...

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 ]----------+--------------------...

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...

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...