Long run job on dremio HDFS sources

Hi Team,

Could you help to advice why this job need long time to run?

From the profile, seems some threads are using long time. It indicates “Blocked On Downstream”. Does it mean it is due to resources limitation?



fc505abd-0356-4b9a-87b7-70e5d5acfbe6.zip (361.7 KB)

@popejune See below 2 screenshots, the input to the HASH_JOIN 02-xx-03 is 950K while the output is 87 Billion, It seems like a huge massive expanding join