[ip-10-2-31-24.ec2.internal:21000] > explain select * from dc a inner join fcs b on a.customer_key = b.customer_key inner join dcc c on b.customer_key = c.user_key;
Query: explain select * from dc a inner join fcs b on a.customer_key = b.customer_key inner join dcc c on b.customer_key = c.user_key
+--------------------------------------------------------------------------------------------------------------------------------------+
| Explain String                                                                                                                       |
+--------------------------------------------------------------------------------------------------------------------------------------+
| Estimated Per-Host Requirements: Memory=17.12GB VCores=3                                                                             |
|                                                                                                                                      |
| 07:EXCHANGE [UNPARTITIONED]                                                                                                          |
| |                                                                                                                                    |
| 04:HASH JOIN [INNER JOIN, BROADCAST]                                                                                                 |
| |  hash predicates: caastle_bi.fact_customer_segments.customer_key = caastle_bi.dim_customer.customer_key                            |
| |  runtime filters: RF000 <- caastle_bi.dim_customer.customer_key                                                                    |
| |                                                                                                                                    |
| |--06:EXCHANGE [BROADCAST]                                                                                                           |
| |  |                                                                                                                                 |
| |  00:SCAN HDFS [caastle_bi.dim_customer]                                                                                            |
| |     partitions=7/7 files=55 size=2.74GB                                                                                            |
| |                                                                                                                                    |
| 03:HASH JOIN [INNER JOIN, BROADCAST]                                                                                                 |
| |  hash predicates: caastle_bi.fact_customer_segments.customer_key = caastle_bi.dim_campaign_customer.user_key                       |
| |  runtime filters: RF001 <- caastle_bi.dim_campaign_customer.user_key                                                               |
| |                                                                                                                                    |
| |--05:EXCHANGE [BROADCAST]                                                                                                           |
| |  |                                                                                                                                 |
| |  02:SCAN HDFS [caastle_bi.dim_campaign_customer]                                                                                   |
| |     partitions=1/1 files=3 size=216.34MB                                                                                           |
| |                                                                                                                                    |
| 01:SCAN HDFS [caastle_bi.fact_customer_segments]                                                                                     |
|    partitions=58726/58866 files=58726 size=18.96GB                                                                                   |
|    runtime filters: RF000 -> caastle_bi.fact_customer_segments.customer_key, RF001 -> caastle_bi.fact_customer_segments.customer_key