Where to see query execution error detail

Hi,

Which version of Vertica MC are you running? I did a quick test on Vertica MC 9.1.0-1 of running multiple DDL statements and did not have a problem.

You can check the MC log for errors:

See:
https://my.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/ManagementConsole/TroubleshootingMC/ViewingTheMCLog.htm

I'm not sure if "Execution Errors" from MC show up in the DC_ERRORS Data Collector table, but maybe take a peek there too.

If you want, you can email your code and I can test it locally to see if I figure out the issue

My email: james.knicely@microfocus.com

Hi Jim,

It's vertica_community_edition-9.0.1_vmx.zip

Later I used vsql to run the sql commands successfully like this -

vsql -U dbadmin -w password -f ddl_file.sql

Thanks.