The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
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: [email protected]
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.