VMware Tanzu Greenplum

  • Private Community
  • Private Community
 View Only
Back to discussions
Expand all | Collapse all

Requests to gpfdist not spread across cluster segments

  • 1.  Requests to gpfdist not spread across cluster segments

    Posted Jul 31, 2024 09:21 AM

    Hi, all!

    We found that in our Greenplum cluster all requests to gpfdist, instead of being spread across cluster segments, are executed only on the gpseg-0 segment. External table has approximately the following content:

    CREATE EXTERNAL TABLE stage.gpfdist_test_table (a text, b int)
    LOCATION ('gpfdist://ip-10-100-100-100.eu-west-1.compute.internal:7000/demo/demo.gz')
    FORMAT 'CSV' (delimiter ';');

    All requests to above table has been executed only on the host where gpseg-0 is located and not on any other segments, parameter gp_external_max_segs  is set to 64 by default, in the cluster there are 218 segments. Greenplum version is 6.26.3

    Does anybody faced similar issues before ?