issue with extract from RedShift

gerrycastellino — Fri, 22 Jul 2016 20:49:01 GMT

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.

topic issue with extract from RedShift in QlikView

issue with extract from RedShift