Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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 ?



Comments

  • Make sure that the queries are not throwing any errors ( syntax error) before feeding them in Designer.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.