Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Identify Queries failed with syntax errors and it's failure reason.
Where could I see the queries and it's respective error which failed with syntax error.
error_messages and dc_errors doesn't have the queries.
Query_requests and dc_requests_issued doesn't stores the queries failed with syntax errors.
Could anyone please help me with this.
Regards
0
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
Comments
Do you need to find this from a SQL query? It's in vertica.log:
2019-06-19 14:06:48.920 Init Session:0x7f03da40b700 [Session] [Query] TX:0(v_docker_node0001-17861:0x9d98d) seledt * from foo;
2019-06-19 14:06:48.920 Init Session:0x7f03da40b700 @v_docker_node0001: 42601/4856: Syntax error at or near "seledt" at character 1
Thanks for responding.
I don't have access to check the vertica logs.
So dependent on system logs
The ERROR_MESSAGES system table has the error:
Queries that fail becuase of a syntax error are not stored in any system table.
Maybe create an external table that reads the vertica.log info?
Simple example:
Note, if queries fail becuase an error that is not caused by a syntax error, you can do the following to see the error and query: