Where to see query execution error detail
Hello,
I was trying to create tables from MC - Query Execution (Vertica 9.x). I imported a DDL sql to create multiple tables in one shot and clicked execute. It shows executing error. If I execute them one by one, it is getting executed without any error. Can I know where to find the log of this error ? Thanks.
0
Comments
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.