Script will list all load events that have rejected data SELECT le.time, le.node_name, le.event_description, le.event_type, le.rows_accepted, le.rows_rejected, le.session_id, le.user_name, ss.client_hostname, ss.session_type, ss.is_internal FROM v_internal.dc_load_events le LEFT JOIN v_internal.dc_session_starts ss ON ss.session_id = le.session_id WHERE le.rows_rejected <> 0 ORDER BY le.time DESC; The script was created by NORBERT KRUPA
SELECT le.time, le.node_name, le.event_description, le.event_type, le.rows_accepted, le.rows_rejected, le.session_id, le.user_name, ss.client_hostname, ss.session_type, ss.is_internal FROM v_internal.dc_load_events le LEFT JOIN v_internal.dc_session_starts ss ON ss.session_id = le.session_id WHERE le.rows_rejected <> 0 ORDER BY le.time DESC;