I'm trying to use hawq_toolkit to find out more about our installation and usage: # select * from hawq_toolkit.hawq_log_master_concise;
ERROR: invalid byte sequence for encoding "UTF8": 0x88
HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".
CONTEXT: External table __hawq_log_master_ext, line 664 of file execute:cat $GP_SEG_DATADIR/pg_log/*.csv
ERROR: external table __hawq_log_master_ext command ended with SHELL TERMINATED by signal SIGPIPE (13)
DETAIL: Command: execute:cat $GP_SEG_DATADIR/pg_log/*.csv
$ file hawq-2016-08-08_160737.csv
hawq-2016-08-08_160737.csv: ASCII Pascal program text, with very long lines
I found this article on the error: https://community.pivotal.io/s/article/Command-Center-Error-External-Table-XXX-Command-Ended-with-SHELL-TERMINATED-by-Signal-SIGPIPE-13 I need some assistance with getting around this error, figuring out why the files are not in UTF-8 and how to prevent this from happening in the first place.
... View more
I've run into this problem a couple of times now. We have a testing our Hortonworks install of the database on our cluster where we are trying to alter databases to suit our pipelines but we get stuck with "ERROR: Cannot support rename database statement yet". I also get the same error for "alter database owner". We are running postgresql server 8.2. Do we need to upgrade our postgresql server? Am I doing something incorrectly? What is the solution for this? Edit: I just found that create database with template gives "ERROR: copy non template database is not supported"
... View more