Skip to content

Instantly share code, notes, and snippets.

@a-b
Last active August 29, 2015 14:13
Show Gist options
  • Save a-b/8dc510f5ddde60099a45 to your computer and use it in GitHub Desktop.
Save a-b/8dc510f5ddde60099a45 to your computer and use it in GitHub Desktop.
SELECT
trim(line_number) AS line_number,
trim(colname) AS colname,
trim(type) AS type,
trim(col_length) AS col_length,
trim(position) AS position,
trim(raw_field_value) AS raw_field_value,
trim(err_code) AS err_code,
trim(err_reason) AS err_reason
FROM stl_load_errors sl, stv_tbl_perm sp
WHERE sl.tbl = sp.id
AND sl.query = (SELECT query FROM stl_load_errors ORDER BY query DESC LIMIT 1);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment