[c6f0d87b003d:21050] tpcds> select count(*) from inventory;
Query: select count(*) from inventory
Query submitted at: 2023-02-08 11:55:44 (Coordinator: http://c6f0d87b003d:25000)
Query progress can be monitored at: http://c6f0d87b003d:25000/query_plan?query_id=d949d1239eb092ac:0f6f408400000000
+----------+
| count(*) |
+----------+
| 11745000 |
+----------+
Fetched 1 row(s) in 0.41s

==================================== set trust_pk_fk_constraints=true;
[c6f0d87b003d:21050] tpcds> explain
select t.inv_date_sk,
t.inv_item_sk,
t.inv_warehouse_sk,
  t.inv_quantity_on_hand
from inventory t
left join inventory s
on t.inv_date_sk = s.inv_date_sk
and t.inv_item_sk = s.inv_item_sk
and t.inv_warehouse_sk = s.inv_warehouse_sk
order by 1 desc, 2 desc, 3 desc,4 desc limit 10;
Query: explain select t.inv_date_sk,
t.inv_item_sk,
t.inv_warehouse_sk,
  t.inv_quantity_on_hand
from inventory t
left join inventory s
on t.inv_date_sk = s.inv_date_sk
and t.inv_item_sk = s.inv_item_sk
and t.inv_warehouse_sk = s.inv_warehouse_sk
order by 1 desc, 2 desc, 3 desc,4 desc limit 10
+---------------------------------------------------------------------------------------------------+
| Explain String                                                                                    |
+---------------------------------------------------------------------------------------------------+
| Max Per-Host Resource Reservation: Memory=12.00MB Threads=3                                       |
| Per-Host Resource Estimates: Memory=268MB                                                         |
|                                                                                                   |
| PLAN-ROOT SINK                                                                                    |
| |                                                                                                 |
| 03:MERGING-EXCHANGE [UNPARTITIONED]                                                               |
| |  order by: inv_date_sk DESC, inv_item_sk DESC, inv_warehouse_sk DESC, inv_quantity_on_hand DESC |
| |  limit: 10                                                                                      |
| |                                                                                                 |
| 02:TOP-N [LIMIT=10]                                                                               |
| |  order by: inv_date_sk DESC, inv_item_sk DESC, inv_warehouse_sk DESC, inv_quantity_on_hand DESC |
| |  row-size=20B cardinality=10                                                                    |
| |                                                                                                 |
| 00:SCAN HDFS [tpcds.inventory t]                                                                  |
|    HDFS partitions=1/1 files=1 size=225.47MB                                                      |
|    row-size=20B cardinality=11.74M                                                                |
+---------------------------------------------------------------------------------------------------+
Fetched 16 row(s) in 0.01s

[c6f0d87b003d:21050] tpcds> select t.inv_date_sk,
t.inv_item_sk,
t.inv_warehouse_sk,
  t.inv_quantity_on_hand
from inventory t
left join inventory s
on t.inv_date_sk = s.inv_date_sk
and t.inv_item_sk = s.inv_item_sk
and t.inv_warehouse_sk = s.inv_warehouse_sk
order by 1 desc, 2 desc, 3 desc,4 desc limit 10;
Query: select t.inv_date_sk,
t.inv_item_sk,
t.inv_warehouse_sk,
  t.inv_quantity_on_hand
from inventory t
left join inventory s
on t.inv_date_sk = s.inv_date_sk
and t.inv_item_sk = s.inv_item_sk
and t.inv_warehouse_sk = s.inv_warehouse_sk
order by 1 desc, 2 desc, 3 desc,4 desc limit 10
Query submitted at: 2023-02-07 11:10:13 (Coordinator: http://c6f0d87b003d:25000)
Query progress can be monitored at: http://c6f0d87b003d:25000/query_plan?query_id=7644f0fe0446bc2d:ef8cb92e00000000
+-------------+-------------+------------------+----------------------+
| inv_date_sk | inv_item_sk | inv_warehouse_sk | inv_quantity_on_hand |
+-------------+-------------+------------------+----------------------+
| 2452635     | 18000       | 5                | 735                  |
| 2452635     | 18000       | 4                | 822                  |
| 2452635     | 18000       | 3                | 155                  |
| 2452635     | 18000       | 2                | 398                  |
| 2452635     | 18000       | 1                | 277                  |
| 2452635     | 17997       | 5                | 273                  |
| 2452635     | 17997       | 4                | 714                  |
| 2452635     | 17997       | 3                | 928                  |
| 2452635     | 17997       | 2                | 852                  |
| 2452635     | 17997       | 1                | 70                   |
+-------------+-------------+------------------+----------------------+
Fetched 10 row(s) in 0.91s



==================================== set trust_pk_fk_constraints=false;
[c6f0d87b003d:21050] tpcds> 
[c6f0d87b003d:21050] tpcds> explain
select t.inv_date_sk,
t.inv_item_sk,
t.inv_warehouse_sk,
  t.inv_quantity_on_hand
from inventory t
left join inventory s
on t.inv_date_sk = s.inv_date_sk
and t.inv_item_sk = s.inv_item_sk
and t.inv_warehouse_sk = s.inv_warehouse_sk
order by 1 desc, 2 desc, 3 desc,4 desc limit 10;
Query: explain select t.inv_date_sk,
t.inv_item_sk,
t.inv_warehouse_sk,
  t.inv_quantity_on_hand
from inventory t
left join inventory s
on t.inv_date_sk = s.inv_date_sk
and t.inv_item_sk = s.inv_item_sk
and t.inv_warehouse_sk = s.inv_warehouse_sk
order by 1 desc, 2 desc, 3 desc,4 desc limit 10
+---------------------------------------------------------------------------------------------------------------------------+
| Explain String                                                                                                            |
+---------------------------------------------------------------------------------------------------------------------------+
| Max Per-Host Resource Reservation: Memory=54.00MB Threads=5                                                               |
| Per-Host Resource Estimates: Memory=1.08GB                                                                                |
|                                                                                                                           |
| PLAN-ROOT SINK                                                                                                            |
| |                                                                                                                         |
| 05:MERGING-EXCHANGE [UNPARTITIONED]                                                                                       |
| |  order by: inv_date_sk DESC, inv_item_sk DESC, inv_warehouse_sk DESC, inv_quantity_on_hand DESC                         |
| |  limit: 10                                                                                                              |
| |                                                                                                                         |
| 03:TOP-N [LIMIT=10]                                                                                                       |
| |  order by: inv_date_sk DESC, inv_item_sk DESC, inv_warehouse_sk DESC, inv_quantity_on_hand DESC                         |
| |  row-size=20B cardinality=10                                                                                            |
| |                                                                                                                         |
| 02:HASH JOIN [LEFT OUTER JOIN, BROADCAST]                                                                                 |
| |  hash predicates: t.inv_date_sk = s.inv_date_sk, t.inv_item_sk = s.inv_item_sk, t.inv_warehouse_sk = s.inv_warehouse_sk |
| |  row-size=36B cardinality=11.74M                                                                                        |
| |                                                                                                                         |
| |--04:EXCHANGE [BROADCAST]                                                                                                |
| |  |                                                                                                                      |
| |  01:SCAN HDFS [tpcds.inventory s]                                                                                       |
| |     HDFS partitions=1/1 files=1 size=225.47MB                                                                           |
| |     row-size=16B cardinality=11.74M                                                                                     |
| |                                                                                                                         |
| 00:SCAN HDFS [tpcds.inventory t]                                                                                          |
|    HDFS partitions=1/1 files=1 size=225.47MB                                                                              |
|    row-size=20B cardinality=11.74M                                                                                        |
+---------------------------------------------------------------------------------------------------------------------------+
Fetched 26 row(s) in 0.01s


[c6f0d87b003d:21050] tpcds> select t.inv_date_sk,
t.inv_item_sk,
t.inv_warehouse_sk,
  t.inv_quantity_on_hand
from inventory t
left join inventory s
on t.inv_date_sk = s.inv_date_sk
and t.inv_item_sk = s.inv_item_sk
and t.inv_warehouse_sk = s.inv_warehouse_sk
order by 1 desc, 2 desc, 3 desc,4 desc limit 10;
Query: select t.inv_date_sk,
t.inv_item_sk,
t.inv_warehouse_sk,
  t.inv_quantity_on_hand
from inventory t
left join inventory s
on t.inv_date_sk = s.inv_date_sk
and t.inv_item_sk = s.inv_item_sk
and t.inv_warehouse_sk = s.inv_warehouse_sk
order by 1 desc, 2 desc, 3 desc,4 desc limit 10
Query submitted at: 2023-02-07 10:07:35 (Coordinator: http://c6f0d87b003d:25000)
Query progress can be monitored at: http://c6f0d87b003d:25000/query_plan?query_id=f449d26298e849cd:6dec403c00000000
+-------------+-------------+------------------+----------------------+                                  
| inv_date_sk | inv_item_sk | inv_warehouse_sk | inv_quantity_on_hand |
+-------------+-------------+------------------+----------------------+
| 2452635     | 18000       | 5                | 735                  |
| 2452635     | 18000       | 4                | 822                  |
| 2452635     | 18000       | 3                | 155                  |
| 2452635     | 18000       | 2                | 398                  |
| 2452635     | 18000       | 1                | 277                  |
| 2452635     | 17997       | 5                | 273                  |
| 2452635     | 17997       | 4                | 714                  |
| 2452635     | 17997       | 3                | 928                  |
| 2452635     | 17997       | 2                | 852                  |
| 2452635     | 17997       | 1                | 70                   |
+-------------+-------------+------------------+----------------------+
Fetched 10 row(s) in 3.63s