0 Replies Latest reply: Jul 22, 2016 4:49 PM by gerry castellino RSS

    issue with extract from RedShift

    gerry castellino

      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.