text: alter session set `store.hive.optimize_scan_with_native_readers` = true;
  -- start query 3 in stream 0 using template query3.tpl
  SELECT dt.d_year,
  item.i_brand_id          brand_id,
  item.i_brand             brand,
  Sum(ss_ext_discount_amt) sum_agg
  FROM   date_dim dt,
  store_sales,
  item
  WHERE  dt.d_date_sk = store_sales.ss_sold_date_sk
  AND store_sales.ss_item_sk = item.i_item_sk
  AND item.i_manufact_id = 427
  AND dt.d_moy = 11
  GROUP  BY dt.d_year,
  item.i_brand,
  item.i_brand_id
  ORDER  BY dt.d_year,
  sum_agg DESC,
  brand_id
  LIMIT 100;
  alter session set `store.hive.optimize_scan_with_native_readers` = false;
  