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?
Code: Select all
dbadmin=> \x
Expanded display is on.
dbadmin=> select * from load_streams;
-[ RECORD 1 ]----------+------------------------------
session_id | vertica03-17212:0x94f31
transaction_id | 45035994273826186
statement_id | 2
stream_name |
schema_name | METRICS_DIV
table_id | 45035396274828884
table_name | DATA1COMPLETE
load_start | 2014-09-22 10:43:04.995783-04
load_duration_ms | 645345
is_executing | f
accepted_row_count | 0
rejected_row_count | 0
read_bytes | 0
input_file_size_bytes | 0
parse_complete_percent |
unsorted_row_count | 16525529
sorted_row_count | 16525529
sort_complete_percent | 100