Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
gerrycastellino
Creator III
Creator III

issue with extract from RedShift

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.

0 Replies