page107
89
USE WAREHOUSE IDENTIFIER ( $tpc_warehouse_xs );
SELECT *
FROM partsupp_baseline ps,
part_baseline p,
supplier_baseline s
WHERE ps.ps_partkey = p.p_partkey
AND ps.ps_suppkey = s.s_suppkey;
You do not need a poor-quality query to complete before viewing spills, which are
visible via the Profile Overview tab accessible by clicking the query ID. Spills to disk are
indicated by both Local Disk I/O and Remote Disk I/O, as shown in Figure 3-16.
Figure 3-16.
Spills to disk
Having identified a spill, let’s create a table to hold all the candidate query IDs for
later investigation. I leave it to you to add timestamps, etc.
CREATE OR REPLACE TABLE spill_and_OOM
(
query_id STRING,
warehouse_name STRING,
warehouse_size STRING,
ChapTer 3
The Query profiler