I'm getting the following error when pulling data from amazon redshift table:
SQL##f - SqlState: 08S01, ErrorCode: 26, ErrorMsg: Communication error while getting a tuple; Communication error while getting a tuple rmp_output: SQL SELECT "contact_uuid
There are about 85M records in this table.
//////////////////////////////////////////////////////////////////////////////////
$(QVDatabaseTable):
SQL SELECT "contact_uuid",
"output_title_1"
FROM "$(DB)"."$(DBSchema)"."rmp_output" ;
store $(QVDatabaseTable) into $(vQVDFileName);
DROP table $(QVDatabaseTable);
//////////////////////////////////////////////////////////////////////////////////
How do I mitigate this ?
Thankx
Gerry.