Script to Find rejected loads in Vertica

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