Redshift Observatory

System Table Tracker

System view pg_catalog.svl_spectrum_scan_error version 1.0.46806 / 2023-02-21

View Text

SELECT stl_spectrum_scan_error.userid,
       stl_spectrum_scan_error.query,
       stl_spectrum_scan_error.location,
       stl_spectrum_scan_error.rowid,
       stl_spectrum_scan_error.colname,
       stl_spectrum_scan_error.original_value,
       stl_spectrum_scan_error.modified_value,
       CASE
         WHEN stl_spectrum_scan_error.trigger = 0
           THEN CAST('UNSPECIFIED' AS text)
         WHEN stl_spectrum_scan_error.trigger = 1
           THEN CAST('INVALID_CHARS' AS text)
         WHEN stl_spectrum_scan_error.trigger = 2
           THEN CAST('SURPLUS_CHARS' AS text)
         WHEN stl_spectrum_scan_error.trigger = 3
           THEN CAST('NUMERIC_OVERFLOW' AS text)
         WHEN stl_spectrum_scan_error.trigger = 4
           THEN CAST('TYPE_COERCION_FAILURE' AS text)
         WHEN stl_spectrum_scan_error.trigger = 5
           THEN CAST('COLUMN_COUNT_MISMATCH' AS text)
         ELSE CAST(NULL AS text)
       END AS trigger,
       CASE
         WHEN stl_spectrum_scan_error.action = 0
           THEN CAST('NONE' AS text)
         WHEN stl_spectrum_scan_error.action = 1
           THEN CAST('FAIL' AS text)
         WHEN stl_spectrum_scan_error.action = 2
           THEN CAST('DROP_ROW' AS text)
         WHEN stl_spectrum_scan_error.action = 3
           THEN CAST('SET_TO_NULL' AS text)
         WHEN stl_spectrum_scan_error.action = 4
           THEN CAST('REPLACE' AS text)
         WHEN stl_spectrum_scan_error.action = 5
           THEN CAST('TRUNCATE' AS text)
         WHEN stl_spectrum_scan_error.action = 6
           THEN CAST('OVERFLOW_VALUE' AS text)
         ELSE CAST(NULL AS text)
       END AS action,
       stl_spectrum_scan_error.action_value,
       stl_spectrum_scan_error.error_code
FROM stl_spectrum_scan_error

Home 3D Друк Blog Bring-Up Times Consultancy Cross-Region Benchmarks Email Forums IRC Mailing Lists Reddit Redshift Price Tracker Redshift Version Tracker Redshift Workbench System Table Tracker The Known Universe Twitter White Papers