OSX 10.10. Getting an error when running the vsql process from Python in both 7.X and 6.X client tools:
vsql: unsupported locale character encoding. Use a utf8 locale, not a US-ASCII locale
Here's the command I'm running:
/opt/vertica/bin/vsql -h ## -p ## -U ## -w # -d # -At -c "SELECT * FROM MY_SCHEMA.MY_TABLE"
This command works perfectly when executed from the Terminal, just fails with that error when ran via Python. It even fails when the command is simply to run the vsql executable with no params:
CMDstr = '/opt/vertica7/bin/vsql' result,error = Popen(CMDstr, shell=True, stdout=PIPE, stderr=PIPE).communicate() print(error) # yields above err
Anyone seen this error before?
