[ip-10-2-31-24.ec2.internal:21000] > explain select * from caastle_bi.dim_customer a inner join caastle_bi.fact_customer_segments b on a.customer_key = b.customer_key inner join caastle_bi.dim_campaign_customer c on b.customer_key = c.user_key;
Query: explain select * from caastle_bi.dim_customer a inner join caastle_bi.fact_customer_segments b on a.customer_key = b.customer_key inner join caastle_bi.dim_campaign_customer 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: b.customer_key = a.customer_key                  |
| |  runtime filters: RF000 <- a.customer_key                          |
| |                                                                    |
| |--06:EXCHANGE [BROADCAST]                                           |
| |  |                                                                 |
| |  00:SCAN HDFS [caastle_bi.dim_customer a]                          |
| |     partitions=7/7 files=55 size=2.74GB                            |
| |                                                                    |
| 03:HASH JOIN [INNER JOIN, BROADCAST]                                 |
| |  hash predicates: b.customer_key = c.user_key                      |
| |  runtime filters: RF001 <- c.user_key                              |
| |                                                                    |
| |--05:EXCHANGE [BROADCAST]                                           |
| |  |                                                                 |
| |  02:SCAN HDFS [caastle_bi.dim_campaign_customer c]                 |
| |     partitions=1/1 files=3 size=216.34MB                           |
| |                                                                    |
| 01:SCAN HDFS [caastle_bi.fact_customer_segments b]                   |
|    partitions=58726/58866 files=58726 size=18.96GB                   |
|    runtime filters: RF000 -> b.customer_key, RF001 -> b.customer_key |
+----------------------------------------------------------------------+
Fetched 25 row(s) in 0.16s