How to capture all warning and detail errors on DESIGNER_ADD_DESIGN_QUERIES_FROM_RESULTS
I am running V7.0 Database Designer Programmatically - i.e. http://my.vertica.com/docs/7.0.x/HTML/index.htm#Authoring/ProgrammersGuide/DBDAPI/AboutRunningDataba...
where I am loading 1,000's of queries ...
when I run SELECT DESIGNER_ADD_DESIGN_QUERIES_FROM_RESULTS ( 'jim091814', 'select q.request as QUERY_TEXT, 1 as QUERY_WEIGHT from PERFORMANCE_ANALYSIS.query_requests_091814_100_LVL q');
I get 1,000's of error and warning messages i..e.
DETAIL: Relation "RM_G2_DIAG_PMPM_NORM" does not existWARNING 2454: Cannot load invalid query: SELECT * FROM (SELECT A.CATEGORY CATEGORY, COUNT(A.CATEGORY) ... long SQL that contains a TABLE not in this schema
DETAIL: Relation "RM_G2_DIAG_PMPM_NORM" does not exist
WARNING 3628: Invalid character in hint at or near "(1" at character 24
WARNING 3628: Invalid character in hint at or near "(10" at character 24
WARNING 3628: Invalid character in hint at or near "(100" at character 24
WARNING 4857: Syntax error in HINT at or near ")" at character 28
I query vs_output_event_history - but this does not have the detail and warnings
SELECT stage_type, iteration_number, total_query_count, remaining_query_count, max_step_number, current_step_number, current_step_description, table_id
FROM dw_test_1.v_dbd_jim091814_jim091814.vs_output_event_history
Any suggestions on where I can collect these DETAIL/WARNING ?
where I am loading 1,000's of queries ...
when I run SELECT DESIGNER_ADD_DESIGN_QUERIES_FROM_RESULTS ( 'jim091814', 'select q.request as QUERY_TEXT, 1 as QUERY_WEIGHT from PERFORMANCE_ANALYSIS.query_requests_091814_100_LVL q');
I get 1,000's of error and warning messages i..e.
DETAIL: Relation "RM_G2_DIAG_PMPM_NORM" does not existWARNING 2454: Cannot load invalid query: SELECT * FROM (SELECT A.CATEGORY CATEGORY, COUNT(A.CATEGORY) ... long SQL that contains a TABLE not in this schema
DETAIL: Relation "RM_G2_DIAG_PMPM_NORM" does not exist
WARNING 3628: Invalid character in hint at or near "(1" at character 24
WARNING 3628: Invalid character in hint at or near "(10" at character 24
WARNING 3628: Invalid character in hint at or near "(100" at character 24
WARNING 4857: Syntax error in HINT at or near ")" at character 28
I query vs_output_event_history - but this does not have the detail and warnings
SELECT stage_type, iteration_number, total_query_count, remaining_query_count, max_step_number, current_step_number, current_step_description, table_id
FROM dw_test_1.v_dbd_jim091814_jim091814.vs_output_event_history
Any suggestions on where I can collect these DETAIL/WARNING ?
0
Comments