Why this error is coming many times?
set session autocommit to off 0 ERROR Syntax error at or near ")"
Anyone, please suggest.
Given that the SET command syntax is accurate, try to track the command with the syntax error before.
\! rm -f suspected_queries.txt
select distinct(request) from dc_requests_issued
where transaction_id in ( SELECT transaction_id FROM error_messages WHERE message ilike '%Syntax error%' );
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.