| -- exec_mem_limit=16G时跑不出来,报 Memory exceed limit |
| |
| SELECT |
| i_item_id |
| , i_item_desc |
| , i_current_price |
| FROM |
| item |
| , inventory |
| , date_dim |
| , store_sales |
| WHERE (i_current_price BETWEEN 62 AND (62 + 30)) |
| AND (inv_item_sk = i_item_sk) |
| AND (d_date_sk = inv_date_sk) |
| AND (CAST(d_date AS DATE) BETWEEN CAST('2000-05-25' AS DATE) AND (CAST('2000-05-25' AS DATE) + INTERVAL '60' DAY)) |
| AND (i_manufact_id IN (129, 270, 821, 423)) |
| AND (inv_quantity_on_hand BETWEEN 100 AND 500) |
| AND (ss_item_sk = i_item_sk) |
| GROUP BY i_item_id, i_item_desc, i_current_price |
| ORDER BY i_item_id ASC |
| LIMIT 100; |