Jun 5 20:53:42 um1 ExeMgr[20561]: 42.528755 |27|0|0| D 16 CAL0041: Start SQL statement: select c_last_name ,c_first_name ,c_salutation ,c_preferred_cust_flag ,ss_ticket_number ,cnt from (select ss_ticket_number ,ss_customer_sk ,count(*) cnt from store_sales,date_dim,store,household_demographics where store_sales.ss_sold_date_sk = date_dim.d_date_sk and store_sales.ss_store_sk = store.s_store_sk and store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk and (date_dim.d_dom between 1 and 3 or date_dim.d_dom between 25 and 28) and (household_demographics.hd_buy_potential = '>10000' or household_demographics.hd_buy_potential = '5001-10000') and household_demographics.hd_vehicle_count > 0 and (case when household_demographics.hd_vehicle_count > 0 then household_demographics.hd_dep_count/ household_demographics.hd_vehicle_count else null end) > 1.2 and date_dim.d_year in (1998,1998+1,1998+2) and store.s_county in ('Jefferson Davis Parish','Marshall County','Gogebic County','Fairfield County', 'Ziebach County','Raleigh County','Gage County','Pennington County') group by ss_ticket_number,ss_customer_sk) dn,customer where ss_customer_sk = c_customer_sk and cnt between 15 and 20 order by c_last_name,c_first_name,c_salutation,c_preferred_cust_flag desc, ss_ticket_number; |tpcds_1000| Jun 5 20:55:53 um1 ExeMgr[20561]: 53.214146 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 20:55:53 um1 ExeMgr[20561]: 53.440865 |2147483675|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='item' --columnRIDs/FE; || Jun 5 20:55:53 um1 ExeMgr[20561]: 53.543964 |2147483675|0|0| D 16 CAL0042: End SQL statement Jun 5 20:55:53 um1 ExeMgr[20561]: 53.545795 |2147483675|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='inventory' --columnRIDs/FE; || Jun 5 20:55:53 um1 ExeMgr[20561]: 53.570524 |2147483675|0|0| D 16 CAL0042: End SQL statement Jun 5 20:55:53 um1 ExeMgr[20561]: 53.573456 |2147483675|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='catalog_sales' --columnRIDs/FE; || Jun 5 20:55:53 um1 ExeMgr[20561]: 53.605930 |2147483675|0|0| D 16 CAL0042: End SQL statement Jun 5 20:55:53 um1 ExeMgr[20561]: 53.616158 |27|0|0| D 16 CAL0041: Start SQL statement: select i_item_id ,i_item_desc ,i_current_price from item, inventory, date_dim, catalog_sales where i_current_price between 59 and 59 + 30 and inv_item_sk = i_item_sk and d_date_sk=inv_date_sk and d_date between cast('1999-01-29' as date) and ADDDATE(cast('1999-01-29' as date),60) and i_manufact_id in (858,824,762,837) and inv_quantity_on_hand between 100 and 500 and cs_item_sk = i_item_sk group by i_item_id,i_item_desc,i_current_price order by i_item_id limit 100; |tpcds_1000| Jun 5 20:56:36 um1 ExeMgr[20561]: 36.034261 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 20:56:36 um1 ExeMgr[20561]: 36.050157 |2147483675|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='web_sales' --columnRIDs/FE; || Jun 5 20:56:36 um1 ExeMgr[20561]: 36.079150 |2147483675|0|0| D 16 CAL0042: End SQL statement Jun 5 20:56:36 um1 ExeMgr[20561]: 36.081753 |2147483675|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='time_dim' --columnRIDs/FE; || Jun 5 20:56:36 um1 ExeMgr[20561]: 36.115951 |2147483675|0|0| D 16 CAL0042: End SQL statement Jun 5 20:56:36 um1 ExeMgr[20561]: 36.117309 |2147483675|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='web_page' --columnRIDs/FE; || Jun 5 20:56:36 um1 ExeMgr[20561]: 36.151903 |2147483675|0|0| D 16 CAL0042: End SQL statement Jun 5 20:56:43 um1 ExeMgr[20561]: 43.001686 |27|0|0| D 16 CAL0041: Start SQL statement: select cast(amc as decimal(15,4))/cast(pmc as decimal(15,4)) am_pm_ratio from ( select count(*) amc,"a" as j from web_sales, household_demographics , time_dim, web_page where ws_sold_time_sk = time_dim.t_time_sk and ws_ship_hdemo_sk = household_demographics.hd_demo_sk and ws_web_page_sk = web_page.wp_web_page_sk and time_dim.t_hour between 12 and 12+1 and household_demographics.hd_dep_count = 6 and web_page.wp_char_count between 5000 and 5200) at, ( select count(*) pmc,"a" as j from web_sales, household_demographics , time_dim, web_page where ws_sold_time_sk = time_dim.t_time_sk and ws_ship_hdemo_sk = household_demographics.hd_demo_sk and ws_web_page_sk = web_page.wp_web_page_sk and time_dim.t_hour between 21 and 21+1 and household_demographics.hd_dep_count = 6 and web_page.wp_char_count between 5000 and 5200) pt where at.j=pt.j order by am_pm_ratio limit 100; |tpcds_1000| Jun 5 20:57:39 um1 ExeMgr[20561]: 39.469784 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 20:57:39 um1 ExeMgr[20561]: 39.487185 |2147483675|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store_returns' --columnRIDs/FE; || Jun 5 20:57:39 um1 ExeMgr[20561]: 39.517154 |2147483675|0|0| D 16 CAL0042: End SQL statement Jun 5 20:57:39 um1 ExeMgr[20561]: 39.679657 |27|0|0| D 16 CAL0041: Start SQL statement: select s_store_name ,s_company_id ,s_street_number ,s_street_name ,s_street_type ,s_suite_number ,s_city ,s_county ,s_state ,s_zip ,sum(case when (sr_returned_date_sk - ss_sold_date_sk <= 30 ) then 1 else 0 end) as "30 days" ,sum(case when (sr_returned_date_sk - ss_sold_date_sk > 30) and (sr_returned_date_sk - ss_sold_date_sk <= 60) then 1 else 0 end ) as "31-60 days" ,sum(case when (sr_returned_date_sk - ss_sold_date_sk > 60) and (sr_returned_date_sk - ss_sold_date_sk <= 90) then 1 else 0 end) as "61-90 days" ,sum(case when (sr_returned_date_sk - ss_sold_date_sk > 90) and (sr_returned_date_sk - ss_sold_date_sk <= 120) then 1 else 0 end) as "91-120 days" ,sum(case when (sr_returned_date_sk - ss_sold_date_sk > 120) then 1 else 0 end) as ">120 days" from store_sales ,store_returns ,store ,date_dim d1 ,date_dim d2 where d2.d_year = 1999 and d2.d_moy = 8 and ss_ticket_number = sr_ticket_number and ss_item_sk = sr_item_sk and ss_sold_date_sk = d1.d_date_sk and sr_returned_date_sk = d2.d_date_sk and ss_customer_sk = sr_customer_sk and ss_store_sk = s_store_sk group by s_store_name ,s_company_id ,s_street_number ,s_street_name ,s_street_type ,s_suite_number ,s_city ,s_county ,s_state ,s_zip order by s_store_name ,s_company_id ,s_street_number ,s_street_name ,s_street_type ,s_suite_number ,s_city ,s_county ,s_state ,s_zip limit 100; |tpcds_1000| Jun 5 21:05:19 um1 ExeMgr[20561]: 19.076026 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 21:05:21 um1 ExeMgr[20561]: 21.459672 |27|0|0| D 16 CAL0041: Start SQL statement: select count(*) from store_sales ,household_demographics ,time_dim, store where ss_sold_time_sk = time_dim.t_time_sk and ss_hdemo_sk = household_demographics.hd_demo_sk and ss_store_sk = s_store_sk and time_dim.t_hour = 8 and time_dim.t_minute >= 30 and household_demographics.hd_dep_count = 7 and store.s_store_name = 'ese' order by count(*) limit 100; |tpcds_1000| Jun 5 21:07:12 um1 ExeMgr[20561]: 12.236290 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 21:07:12 um1 ExeMgr[20561]: 12.450284 |27|0|0| D 16 CAL0041: Start SQL statement: select * from (select i_manufact_id, sum(ss_sales_price) sum_sales, avg(sum(ss_sales_price)) over (partition by i_manufact_id) avg_quarterly_sales from item, store_sales, date_dim, store where ss_item_sk = i_item_sk and ss_sold_date_sk = d_date_sk and ss_store_sk = s_store_sk and d_month_seq in (1216,1216+1,1216+2,1216+3,1216+4,1216+5,1216+6,1216+7,1216+8,1216+9,1216+10,1216+11) and ((i_category in ('Books','Children','Electronics') and i_class in ('personal','portable','reference','self-help') and i_brand in ('scholaramalgamalg #14','scholaramalgamalg #7', 'exportiunivamalg #9','scholaramalgamalg #9')) or(i_category in ('Women','Music','Men') and i_class in ('accessories','classical','fragrances','pants') and i_brand in ('amalgimporto #1','edu packscholar #1','exportiimporto #1', 'importoamalg #1'))) group by i_manufact_id, d_qoy ) tmp1 where case when avg_quarterly_sales > 0 then abs (sum_sales - avg_quarterly_sales)/ avg_quarterly_sales else null end > 0.1 order by avg_quarterly_sales, sum_sales, i_manufact_id limit 100; |tpcds_1000| Jun 5 21:10:12 um1 ExeMgr[20561]: 12.317189 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 21:10:12 um1 ExeMgr[20561]: 12.532957 |27|0|0| D 16 CAL0041: Start SQL statement: select * from (select i_manager_id ,sum(ss_sales_price) sum_sales ,avg(sum(ss_sales_price)) over (partition by i_manager_id) avg_monthly_sales from item ,store_sales ,date_dim ,store where ss_item_sk = i_item_sk and ss_sold_date_sk = d_date_sk and ss_store_sk = s_store_sk and d_month_seq in (1220,1220+1,1220+2,1220+3,1220+4,1220+5,1220+6,1220+7,1220+8,1220+9,1220+10,1220+11) and (( i_category in ('Books','Children','Electronics') and i_class in ('personal','portable','reference','self-help') and i_brand in ('scholaramalgamalg #14','scholaramalgamalg #7', 'exportiunivamalg #9','scholaramalgamalg #9')) or( i_category in ('Women','Music','Men') and i_class in ('accessories','classical','fragrances','pants') and i_brand in ('amalgimporto #1','edu packscholar #1','exportiimporto #1', 'importoamalg #1'))) group by i_manager_id, d_moy) tmp1 where case when avg_monthly_sales > 0 then abs (sum_sales - avg_monthly_sales) / avg_monthly_sales else null end > 0.1 order by i_manager_id ,avg_monthly_sales ,sum_sales limit 100; |tpcds_1000| Jun 5 21:13:18 um1 ExeMgr[20561]: 18.467075 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 21:13:18 um1 ExeMgr[20561]: 18.692826 |27|0|0| D 16 CAL0041: Start SQL statement: select dt.d_year ,item.i_brand_id brand_id ,item.i_brand brand ,sum(ss_ext_sales_price) ext_price 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_manager_id = 1 and dt.d_moy=12 and dt.d_year=2002 group by dt.d_year ,item.i_brand ,item.i_brand_id order by dt.d_year ,ext_price desc ,brand_id limit 100; |tpcds_1000| Jun 5 21:14:57 um1 ExeMgr[20561]: 57.816009 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 21:14:57 um1 ExeMgr[20561]: 57.825261 |2147483675|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='customer_address' --columnRIDs/FE; || Jun 5 21:14:57 um1 ExeMgr[20561]: 57.941749 |2147483675|0|0| D 16 CAL0042: End SQL statement Jun 5 21:14:58 um1 ExeMgr[20561]: 58.038166 |27|0|0| D 16 CAL0041: Start SQL statement: select c_last_name ,c_first_name ,ca_city ,bought_city ,ss_ticket_number ,extended_price ,extended_tax ,list_price from (select ss_ticket_number ,ss_customer_sk ,ca_city bought_city ,sum(ss_ext_sales_price) extended_price ,sum(ss_ext_list_price) list_price ,sum(ss_ext_tax) extended_tax from store_sales ,date_dim ,store ,household_demographics ,customer_address where store_sales.ss_sold_date_sk = date_dim.d_date_sk and store_sales.ss_store_sk = store.s_store_sk and store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk and store_sales.ss_addr_sk = customer_address.ca_address_sk and date_dim.d_dom between 1 and 2 and (household_demographics.hd_dep_count = 9 or household_demographics.hd_vehicle_count= 0) and date_dim.d_year in (2000,2000+1,2000+2) and store.s_city in ('Mount Zion','Georgetown') group by ss_ticket_number ,ss_customer_sk ,ss_addr_sk,ca_city) dn ,customer ,customer_address current_addr where ss_customer_sk = c_customer_sk and customer.c_current_addr_sk = current_addr.ca_address_sk and current_addr.ca_city <> bought_city order by c_last_name ,ss_ticket_number limit 100; |tpcds_1000| Jun 5 21:20:13 um1 ExeMgr[20561]: 13.122977 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 21:20:19 um1 ExeMgr[20561]: 19.922962 |27|0|0| D 16 CAL0041: Start SQL statement: select h8_30_to_9,h9_to_9_30,h9_30_to_10,h10_to_10_30,h10_30_to_11,h11_to_11_30,h11_30_to_12,h12_to_12_30 from (select count(*) h8_30_to_9,"a" as j from store_sales, household_demographics , time_dim, store where ss_sold_time_sk = time_dim.t_time_sk and ss_hdemo_sk = household_demographics.hd_demo_sk and ss_store_sk = s_store_sk and time_dim.t_hour = 8 and time_dim.t_minute >= 30 and ((household_demographics.hd_dep_count = 1 and household_demographics.hd_vehicle_count<=1+2) or (household_demographics.hd_dep_count = -1 and household_demographics.hd_vehicle_count<=-1+2) or (household_demographics.hd_dep_count = 4 and household_demographics.hd_vehicle_count<=4+2)) and store.s_store_name = 'ese') s1, (select count(*) h9_to_9_30,"a" as j from store_sales, household_demographics , time_dim, store where ss_sold_time_sk = time_dim.t_time_sk and ss_hdemo_sk = household_demographics.hd_demo_sk and ss_store_sk = s_store_sk and time_dim.t_hour = 9 and time_dim.t_minute < 30 and ((household_demographics.hd_dep_count = 1 and household_demographics.hd_vehicle_count<=1+2) or (household_demographics.hd_dep_count = -1 and household_demographics.hd_vehicle_count<=-1+2) or (household_demographics.hd_dep_count = 4 and household_demographics.hd_vehicle_count<=4+2)) and store.s_store_name = 'ese') s2, (select count(*) h9_30_to_10,"a" as j from store_sales, household_demographics , time_dim, store where ss_sold_time_sk = time_dim.t_time_sk and ss_hdemo_sk = household_demographics.hd_demo_sk and ss_store_sk = s_store_sk and time_dim.t_hour = 9 and time_dim.t_minute >= 30 and ((household_demographics.hd_dep_count = 1 and household_demographics.hd_vehicle_count<=1+2) or (household_demographics.hd_dep_count = -1 and household_demographics.hd_vehicle_count<=-1+2) or (household_demographics.hd_dep_count = 4 and household_demographics.hd_vehicle_count<=4+2)) and store.s_store_name = 'ese') s3, (select count(*) h10_to_10_30,"a" as j from store_sales, household_demographics , time_dim, store where ss_sold_time_sk = time_dim.t_time_sk and ss_hdemo_sk = household_demographics.hd_demo_sk and ss_store_sk = s_store_sk and time_dim.t_hour = 10 and time_dim.t_minute < 30 and ((household_demographics.hd_dep_count = 1 and household_demographics.hd_vehicle_count<=1+2) or (household_demographics.hd_dep_count = -1 and household_demographics.hd_vehicle_count<=-1+2) or (household_demographics.hd_dep_count = 4 and household_demographics.hd_vehicle_count<=4+2)) and store.s_store_name = 'ese') s4, (select count(*) h10_30_to_11,"a" as j from store_sales, household_demographics , time_dim, store where ss_sold_time_sk = time_dim.t_time_sk and ss_hdemo_sk = household_demographics.hd_demo_sk and ss_store_sk = s_store_sk and time_dim.t_hour = 10 and time_dim.t_minute >= 30 and ((household_demographics.hd_dep_count = 1 and household_demographics.hd_vehicle_count<=1+2) or (household_demographics.hd_dep_count = -1 and household_demographics.hd_vehicle_count<=-1+2) or (household_demographics.hd_dep_count = 4 and household_demographics.hd_vehicle_count<=4+2)) and store.s_store_name = 'ese') s5, (select count(*) h11_to_11_30,"a" as j from store_sales, household_demographics , time_dim, store where ss_sold_time_sk = time_dim.t_time_sk and ss_hdemo_sk = household_demographics.hd_demo_sk and ss_store_sk = s_store_sk and time_dim.t_hour = 11 and time_dim.t_minute < 30 and ((household_demographics.hd_dep_count = 1 and household_demographics.hd_vehicle_count<=1+2) or (household_demographics.hd_dep_count = -1 and household_demographics.hd_vehicle_count<=-1+2) or (household_demographics.hd_dep_count = 4 and household_demographics.hd_vehicle_count<=4+2)) and store.s_store_name = 'ese') s6, (select count(*) h11_30_to_12,"a" as j from store_sales, household_demographics , time_dim, store where ss_sold_time_sk = time_dim.t_time_sk and ss_hdemo_sk = household_demographics.hd_demo_sk and ss_store_sk = s_store_sk and time_dim.t_hour = 11 and time_dim.t_minute >= 30 and ((household_demographics.hd_dep_count = 1 and household_demographics.hd_vehicle_count<=1+2) or (household_demographics.hd_dep_count = -1 and household_demographics.hd_vehicle_count<=-1+2) or (household_demographics.hd_dep_count = 4 and household_demographics.hd_vehicle_count<=4+2)) and store.s_store_name = 'ese') s7, (select count(*) h12_to_12_30,"a" as j from store_sales, household_demographics , time_dim, store where ss_sold_time_sk = time_dim.t_time_sk and ss_hdemo_sk = household_demographics.hd_demo_sk and ss_store_sk = s_store_sk and time_dim.t_hour = 12 and time_dim.t_minute < 30 and ((household_demographics.hd_dep_count = 1 and household_demographics.hd_vehicle_count<=1+2) or (household_demographics.hd_dep_count = -1 and household_demographics.hd_vehicle_count<=-1+2) or (household_demographics.hd_dep_count = 4 and household_demographics.hd_vehicle_count<=4+2)) and store.s_store_name = 'ese') s8 where s1.j = s2.j and s2.j = s3.j and s3.j = s4.j and s4.j = s5.j and s5.j = s6.j and s6.j = s7.j and s7.j = s8.j; |tpcds_1000| Jun 5 21:32:23 um1 ExeMgr[20561]: 23.602085 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 21:32:23 um1 ExeMgr[20561]: 23.862086 |27|0|0| D 16 CAL0041: Start SQL statement: select channel, col_name, d_year, d_qoy, i_category, COUNT(*) sales_cnt, SUM(ext_sales_price) sales_amt FROM ( SELECT 'store' as channel, 'ss_hdemo_sk' col_name, d_year, d_qoy, i_category, ss_ext_sales_price ext_sales_price FROM store_sales, item, date_dim WHERE ss_hdemo_sk IS NULL AND ss_sold_date_sk=d_date_sk AND ss_item_sk=i_item_sk UNION ALL SELECT 'web' as channel, 'ws_warehouse_sk' col_name, d_year, d_qoy, i_category, ws_ext_sales_price ext_sales_price FROM web_sales, item, date_dim WHERE ws_warehouse_sk IS NULL AND ws_sold_date_sk=d_date_sk AND ws_item_sk=i_item_sk UNION ALL SELECT 'catalog' as channel, 'cs_bill_customer_sk' col_name, d_year, d_qoy, i_category, cs_ext_sales_price ext_sales_price FROM catalog_sales, item, date_dim WHERE cs_bill_customer_sk IS NULL AND cs_sold_date_sk=d_date_sk AND cs_item_sk=i_item_sk) foo GROUP BY channel, col_name, d_year, d_qoy, i_category ORDER BY channel, col_name, d_year, d_qoy, i_category limit 100; |tpcds_1000| Jun 5 21:37:38 um1 ExeMgr[20561]: 38.010004 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 21:37:43 um1 ExeMgr[20561]: 43.810879 |27|0|0| D 16 CAL0041: Start SQL statement: select a.ca_state state, count(*) cnt from customer_address a ,customer c ,store_sales s ,date_dim d ,item i where a.ca_address_sk = c.c_current_addr_sk and c.c_customer_sk = s.ss_customer_sk and s.ss_sold_date_sk = d.d_date_sk and s.ss_item_sk = i.i_item_sk and d.d_month_seq = (select distinct (d_month_seq) from date_dim where d_year = 2001 and d_moy = 4 ) and i.i_current_price > (select 1.2*avg(j.i_current_price) from item j where j.i_category = i.i_category) group by a.ca_state having count(*) >= 10 order by cnt, a.ca_state limit 100; |tpcds_1000| Jun 5 21:39:39 um1 ExeMgr[20561]: 39.980729 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 21:39:53 um1 ExeMgr[20561]: 53.627044 |27|0|0| D 16 CAL0041: Start SQL statement: select asceding.rnk, i1.i_product_name best_performing, i2.i_product_name worst_performing from(select * from (select item_sk,rank() over (order by rank_col asc) rnk from (select ss_item_sk item_sk,avg(ss_net_profit) rank_col from store_sales ss1 where ss_store_sk = 76 group by ss_item_sk having avg(ss_net_profit) > (select 0.9*avg(ss_net_profit) rank_col from store_sales where ss_store_sk = 76 and ss_cdemo_sk is null group by ss_store_sk))V1)V11 where rnk < 11) asceding, (select * from (select item_sk,rank() over (order by rank_col desc) rnk from (select ss_item_sk item_sk,avg(ss_net_profit) rank_col from store_sales ss1 where ss_store_sk = 76 group by ss_item_sk having avg(ss_net_profit) > (select 0.9*avg(ss_net_profit) rank_col from store_sales where ss_store_sk = 76 and ss_cdemo_sk is null group by ss_store_sk))V2)V21 where rnk < 11) descending, item i1, item i2 where asceding.rnk = descending.rnk and i1.i_item_sk=asceding.item_sk and i2.i_item_sk=descending.item_sk order by asceding.rnk limit 100; |tpcds_1000| Jun 5 21:43:28 um1 ExeMgr[20561]: 28.851237 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 21:43:29 um1 ExeMgr[20561]: 29.100547 |27|0|0| D 16 CAL0041: Start SQL statement: select s_store_name, s_store_id, sum(case when (d_day_name='Sunday') then ss_sales_price else null end) sun_sales, sum(case when (d_day_name='Monday') then ss_sales_price else null end) mon_sales, sum(case when (d_day_name='Tuesday') then ss_sales_price else null end) tue_sales, sum(case when (d_day_name='Wednesday') then ss_sales_price else null end) wed_sales, sum(case when (d_day_name='Thursday') then ss_sales_price else null end) thu_sales, sum(case when (d_day_name='Friday') then ss_sales_price else null end) fri_sales, sum(case when (d_day_name='Saturday') then ss_sales_price else null end) sat_sales from date_dim, store_sales, store where d_date_sk = ss_sold_date_sk and s_store_sk = ss_store_sk and s_gmt_offset = -5 and d_year = 2002 group by s_store_name, s_store_id order by s_store_name, s_store_id,sun_sales,mon_sales,tue_sales,wed_sales,thu_sales,fri_sales,sat_sales limit 100; |tpcds_1000| Jun 5 21:47:31 um1 ExeMgr[20561]: 31.054636 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 21:47:31 um1 ExeMgr[20561]: 31.353363 |27|0|0| D 16 CAL0041: Start SQL statement: select c_last_name ,c_first_name ,c_salutation ,c_preferred_cust_flag ,ss_ticket_number ,cnt from (select ss_ticket_number ,ss_customer_sk ,count(*) cnt from store_sales,date_dim,store,household_demographics where store_sales.ss_sold_date_sk = date_dim.d_date_sk and store_sales.ss_store_sk = store.s_store_sk and store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk and date_dim.d_dom between 1 and 2 and (household_demographics.hd_buy_potential = '501-1000' or household_demographics.hd_buy_potential = 'Unknown') and household_demographics.hd_vehicle_count > 0 and case when household_demographics.hd_vehicle_count > 0 then household_demographics.hd_dep_count/ household_demographics.hd_vehicle_count else null end > 1 and date_dim.d_year in (1999,1999+1,1999+2) and store.s_county in ('Huron County','Barrow County','Williamson County','Fairfield County') group by ss_ticket_number,ss_customer_sk) dj,customer where ss_customer_sk = c_customer_sk and cnt between 1 and 5 order by cnt desc, c_last_name asc; |tpcds_1000| Jun 5 21:49:39 um1 ExeMgr[20561]: 39.283946 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 21:49:39 um1 ExeMgr[20561]: 39.512166 |27|0|0| D 16 CAL0041: Start SQL statement: select i_item_id ,i_item_desc ,s_store_id ,s_store_name ,stddev_samp(ss_net_profit) as store_sales_profit ,stddev_samp(sr_net_loss) as store_returns_loss ,stddev_samp(cs_net_profit) as catalog_sales_profit from store_sales ,store_returns ,catalog_sales ,date_dim d1 ,date_dim d2 ,date_dim d3 ,store ,item where d1.d_moy = 4 and d1.d_year = 1998 and d1.d_date_sk = ss_sold_date_sk and i_item_sk = ss_item_sk and s_store_sk = ss_store_sk and ss_customer_sk = sr_customer_sk and ss_item_sk = sr_item_sk and ss_ticket_number = sr_ticket_number and sr_returned_date_sk = d2.d_date_sk and d2.d_moy between 4 and 10 and d2.d_year = 1998 and sr_customer_sk = cs_bill_customer_sk and sr_item_sk = cs_item_sk and cs_sold_date_sk = d3.d_date_sk and d3.d_moy between 4 and 10 and d3.d_year = 1998 group by i_item_id ,i_item_desc ,s_store_id ,s_store_name order by i_item_id ,i_item_desc ,s_store_id ,s_store_name limit 100; |tpcds_1000| Jun 5 21:56:41 um1 ExeMgr[20561]: 41.071061 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 21:56:41 um1 ExeMgr[20561]: 41.087025 |2147483675|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='customer_demographics' --columnRIDs/FE; || Jun 5 21:56:41 um1 ExeMgr[20561]: 41.200300 |2147483675|0|0| D 16 CAL0042: End SQL statement Jun 5 21:59:51 um1 ExeMgr[20561]: 51.750021 |27|0|0| D 16 CAL0041: Start SQL statement: select avg(ss_quantity) ,avg(ss_ext_sales_price) ,avg(ss_ext_wholesale_cost) ,sum(ss_ext_wholesale_cost) from store_sales ,store ,customer_demographics ,household_demographics ,customer_address ,date_dim where s_store_sk = ss_store_sk and ss_hdemo_sk=hd_demo_sk and cd_demo_sk = ss_cdemo_sk and ss_addr_sk = ca_address_sk and ss_sold_date_sk = d_date_sk and d_year = 2001 and(( cd_marital_status = 'S' and cd_education_status = '4 yr Degree' and ss_sales_price between 100.00 and 150.00 and hd_dep_count = 3 )or ( cd_marital_status = 'U' and cd_education_status = 'Unknown' and ss_sales_price between 50.00 and 100.00 and hd_dep_count = 1 ) or ( cd_marital_status = 'W' and cd_education_status = 'Primary' and ss_sales_price between 150.00 and 200.00 and hd_dep_count = 1 )) and(( ca_country = 'United States' and ca_state in ('OK', 'LA', 'TX') and ss_net_profit between 100 and 200 ) or ( ca_country = 'United States' and ca_state in ('CT', 'PA', 'CO') and ss_net_profit between 150 and 300 ) or ( ca_country = 'United States' and ca_state in ('KS', 'KY', 'TN') and ss_net_profit between 50 and 250 )); |tpcds_1000| Jun 5 22:07:01 um1 ExeMgr[20561]: 01.043588 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 22:07:05 um1 ExeMgr[20561]: 05.968007 |27|0|0| D 16 CAL0041: Start SQL statement: select i_item_id ,i_item_desc ,s_state ,count(ss_quantity) as store_sales_quantitycount ,avg(ss_quantity) as store_sales_quantityave ,stddev_samp(ss_quantity) as store_sales_quantitystdev ,stddev_samp(ss_quantity)/avg(ss_quantity) as store_sales_quantitycov ,count(sr_return_quantity) as store_returns_quantitycount ,avg(sr_return_quantity) as store_returns_quantityave ,stddev_samp(sr_return_quantity) as store_returns_quantitystdev ,stddev_samp(sr_return_quantity)/avg(sr_return_quantity) as store_returns_quantitycov ,count(cs_quantity) as catalog_sales_quantitycount ,avg(cs_quantity) as catalog_sales_quantityave ,stddev_samp(cs_quantity) as catalog_sales_quantitystdev ,stddev_samp(cs_quantity)/avg(cs_quantity) as catalog_sales_quantitycov from store_sales ,store_returns ,catalog_sales ,date_dim d1 ,date_dim d2 ,date_dim d3 ,store ,item where d1.d_quarter_name = '2000Q1' and d1.d_date_sk = ss_sold_date_sk and i_item_sk = ss_item_sk and s_store_sk = ss_store_sk and ss_customer_sk = sr_customer_sk and ss_item_sk = sr_item_sk and ss_ticket_number = sr_ticket_number and sr_returned_date_sk = d2.d_date_sk and d2.d_quarter_name in ('2000Q1','2000Q2','2000Q3') and sr_customer_sk = cs_bill_customer_sk and sr_item_sk = cs_item_sk and cs_sold_date_sk = d3.d_date_sk and d3.d_quarter_name in ('2000Q1','2000Q2','2000Q3') group by i_item_id ,i_item_desc ,s_state order by i_item_id ,i_item_desc ,s_state limit 100; |tpcds_1000| Jun 5 22:15:43 um1 ExeMgr[20561]: 43.205138 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 22:15:43 um1 ExeMgr[20561]: 43.218196 |2147483675|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='promotion' --columnRIDs/FE; || Jun 5 22:15:43 um1 ExeMgr[20561]: 43.344230 |2147483675|0|0| D 16 CAL0042: End SQL statement Jun 5 22:19:11 um1 ExeMgr[20561]: 11.020244 |27|0|0| D 16 CAL0041: Start SQL statement: select promotions,total,cast(promotions as decimal(15,4))/cast(total as decimal(15,4))*100 from (select sum(ss_ext_sales_price) promotions,"a" as j from store_sales ,store ,promotion ,date_dim ,customer ,customer_address ,item where ss_sold_date_sk = d_date_sk and ss_store_sk = s_store_sk and ss_promo_sk = p_promo_sk and ss_customer_sk= c_customer_sk and ca_address_sk = c_current_addr_sk and ss_item_sk = i_item_sk and ca_gmt_offset = -7 and i_category = 'Sports' and (p_channel_dmail = 'Y' or p_channel_email = 'Y' or p_channel_tv = 'Y') and s_gmt_offset = -7 and d_year = 1998 and d_moy = 12) promotional_sales, (select sum(ss_ext_sales_price) total,"a" as j from store_sales ,store ,date_dim ,customer ,customer_address ,item where ss_sold_date_sk = d_date_sk and ss_store_sk = s_store_sk and ss_customer_sk= c_customer_sk and ca_address_sk = c_current_addr_sk and ss_item_sk = i_item_sk and ca_gmt_offset = -7 and i_category = 'Sports' and s_gmt_offset = -7 and d_year = 1998 and d_moy = 12) all_sales where promotional_sales.j = all_sales.j order by promotions, total limit 100; |tpcds_1000| Jun 5 22:24:52 um1 ExeMgr[20561]: 52.053856 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 22:24:52 um1 ExeMgr[20561]: 52.291962 |27|0|0| D 16 CAL0041: Start SQL statement: select B1_LP,B1_CNT, B1_CNTD, B2_LP,B2_CNT, B2_CNTD, B3_LP,B3_CNT, B3_CNTD, B4_LP,B4_CNT, B4_CNTD, B5_LP,B5_CNT, B5_CNTD, B6_LP,B6_CNT, B6_CNTD from (select avg(ss_list_price) B1_LP,"a" as j ,count(ss_list_price) B1_CNT ,count(distinct ss_list_price) B1_CNTD from store_sales where ss_quantity between 0 and 5 and (ss_list_price between 57 and 57+10 or ss_coupon_amt between 2334 and 2334+1000 or ss_wholesale_cost between 21 and 21+20)) B1, (select avg(ss_list_price) B2_LP,"a" as j ,count(ss_list_price) B2_CNT ,count(distinct ss_list_price) B2_CNTD from store_sales where ss_quantity between 6 and 10 and (ss_list_price between 12 and 12+10 or ss_coupon_amt between 11222 and 11222+1000 or ss_wholesale_cost between 44 and 44+20)) B2, (select avg(ss_list_price) B3_LP,"a" as j ,count(ss_list_price) B3_CNT ,count(distinct ss_list_price) B3_CNTD from store_sales where ss_quantity between 11 and 15 and (ss_list_price between 121 and 121+10 or ss_coupon_amt between 4026 and 4026+1000 or ss_wholesale_cost between 62 and 62+20)) B3, (select avg(ss_list_price) B4_LP,"a" as j ,count(ss_list_price) B4_CNT ,count(distinct ss_list_price) B4_CNTD from store_sales where ss_quantity between 16 and 20 and (ss_list_price between 47 and 47+10 or ss_coupon_amt between 3379 and 3379+1000 or ss_wholesale_cost between 3 and 3+20)) B4, (select avg(ss_list_price) B5_LP,"a" as j ,count(ss_list_price) B5_CNT ,count(distinct ss_list_price) B5_CNTD from store_sales where ss_quantity between 21 and 25 and (ss_list_price between 60 and 60+10 or ss_coupon_amt between 5127 and 5127+1000 or ss_wholesale_cost between 58 and 58+20)) B5, (select avg(ss_list_price) B6_LP,"a" as j ,count(ss_list_price) B6_CNT ,count(distinct ss_list_price) B6_CNTD from store_sales where ss_quantity between 26 and 30 and (ss_list_price between 30 and 30+10 or ss_coupon_amt between 12125 and 12125+1000 or ss_wholesale_cost between 29 and 29+20)) B6 where B1.j = B2.j and B2.j = B3.j and B3.j = B4.j and B4.j = B5.j and B5.j = B6.j limit 100; |tpcds_1000| Jun 5 22:32:12 um1 ExeMgr[20561]: 12.128668 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 22:32:12 um1 ExeMgr[20561]: 12.341926 |27|0|0| D 16 CAL0041: Start SQL statement: select dt.d_year ,item.i_category_id ,item.i_category ,sum(ss_ext_sales_price) 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_manager_id = 1 and dt.d_moy=12 and dt.d_year=1999 group by dt.d_year ,item.i_category_id ,item.i_category order by sum(ss_ext_sales_price) desc,dt.d_year ,item.i_category_id ,item.i_category limit 100; |tpcds_1000| Jun 5 22:35:00 um1 ExeMgr[20561]: 00.325535 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 22:35:00 um1 ExeMgr[20561]: 00.640376 |27|0|0| D 16 CAL0041: Start SQL statement: select i_item_id ,i_item_desc ,i_category ,i_class ,i_current_price ,sum(ws_ext_sales_price) as itemrevenue ,sum(ws_ext_sales_price)*100/sum(sum(ws_ext_sales_price)) over (partition by i_class) as revenueratio from web_sales ,item ,date_dim where ws_item_sk = i_item_sk and i_category in ('Jewelry', 'Shoes', 'Men') and ws_sold_date_sk = d_date_sk and d_date between cast('1998-01-29' as date) and ADDDATE(cast('1998-01-29' as date),30) group by i_item_id ,i_item_desc ,i_category ,i_class ,i_current_price order by i_category ,i_class ,i_item_id ,i_item_desc ,revenueratio limit 100; |tpcds_1000| Jun 5 22:35:44 um1 ExeMgr[20561]: 44.079834 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 22:35:44 um1 ExeMgr[20561]: 44.084715 |2147483675|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='web_returns' --columnRIDs/FE; || Jun 5 22:35:44 um1 ExeMgr[20561]: 44.210787 |2147483675|0|0| D 16 CAL0042: End SQL statement Jun 5 22:35:44 um1 ExeMgr[20561]: 44.214625 |2147483675|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='reason' --columnRIDs/FE; || Jun 5 22:35:44 um1 ExeMgr[20561]: 44.244769 |2147483675|0|0| D 16 CAL0042: End SQL statement Jun 5 22:35:44 um1 ExeMgr[20561]: 44.326517 |27|0|0| D 16 CAL0041: Start SQL statement: select substr(r_reason_desc,1,20) ,avg(ws_quantity) ,avg(wr_refunded_cash) ,avg(wr_fee) from web_sales, web_returns, web_page, customer_demographics cd1, customer_demographics cd2, customer_address, date_dim, reason where ws_web_page_sk = wp_web_page_sk and ws_item_sk = wr_item_sk and ws_order_number = wr_order_number and ws_sold_date_sk = d_date_sk and d_year = 2000 and cd1.cd_demo_sk = wr_refunded_cdemo_sk and cd2.cd_demo_sk = wr_returning_cdemo_sk and ca_address_sk = wr_refunded_addr_sk and r_reason_sk = wr_reason_sk and ( ( cd1.cd_marital_status = 'S' and cd1.cd_marital_status = cd2.cd_marital_status and cd1.cd_education_status = '4 yr Degree' and cd1.cd_education_status = cd2.cd_education_status and ws_sales_price between 100.00 and 150.00 ) or ( cd1.cd_marital_status = 'D' and cd1.cd_marital_status = cd2.cd_marital_status and cd1.cd_education_status = 'Unknown' and cd1.cd_education_status = cd2.cd_education_status and ws_sales_price between 50.00 and 100.00 ) or ( cd1.cd_marital_status = 'U' and cd1.cd_marital_status = cd2.cd_marital_status and cd1.cd_education_status = 'Primary' and cd1.cd_education_status = cd2.cd_education_status and ws_sales_price between 150.00 and 200.00 ) ) and ( ( ca_country = 'United States' and ca_state in ('AL', 'OR', 'KY') and ws_net_profit between 100 and 200 ) or ( ca_country = 'United States' and ca_state in ('OH', 'KS', 'MO') and ws_net_profit between 150 and 300 ) or ( ca_country = 'United States' and ca_state in ('VA', 'IA', 'MT') and ws_net_profit between 50 and 250 ) ) group by r_reason_desc,substr(r_reason_desc,1,20) order by substr(r_reason_desc,1,20) ,avg(ws_quantity) ,avg(wr_refunded_cash) ,avg(wr_fee) limit 100; |tpcds_1000| Jun 5 22:38:54 um1 ExeMgr[20561]: 54.727670 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 22:40:12 um1 ExeMgr[20561]: 12.940178 |27|0|0| D 16 CAL0041: Start SQL statement: select ss_customer_sk ,sum(act_sales) sumsales from (select ss_item_sk ,ss_ticket_number ,ss_customer_sk ,case when sr_return_quantity is not null then (ss_quantity-sr_return_quantity)*ss_sales_price else (ss_quantity*ss_sales_price) end act_sales from store_sales left outer join store_returns on (sr_item_sk = ss_item_sk and sr_ticket_number = ss_ticket_number) ,reason where sr_reason_sk = r_reason_sk and r_reason_desc = 'Found a better price in a store') t group by ss_customer_sk order by sumsales, ss_customer_sk limit 100; |tpcds_1000| Jun 5 22:47:36 um1 ExeMgr[20561]: 36.830223 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 22:47:40 um1 ExeMgr[20561]: 40.418537 |27|0|0| D 16 CAL0041: Start SQL statement: select i_item_id ,i_item_desc ,i_category ,i_class ,i_current_price ,sum(cs_ext_sales_price) as itemrevenue ,sum(cs_ext_sales_price)*100/sum(sum(cs_ext_sales_price)) over (partition by i_class) as revenueratio from catalog_sales ,item ,date_dim where cs_item_sk = i_item_sk and i_category in ('Children', 'Sports', 'Men') and cs_sold_date_sk = d_date_sk and d_date between cast('1999-04-24' as date) and ADDDATE(cast('1999-04-24' as date),30) group by i_item_id ,i_item_desc ,i_category ,i_class ,i_current_price order by i_category ,i_class ,i_item_id ,i_item_desc ,revenueratio limit 100; |tpcds_1000| Jun 5 22:47:45 um1 ExeMgr[20561]: 45.793078 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 22:47:46 um1 ExeMgr[20561]: 46.009384 |27|0|0| D 16 CAL0041: Start SQL statement: select c_last_name ,c_first_name ,ca_city ,bought_city ,ss_ticket_number ,amt,profit from (select ss_ticket_number ,ss_customer_sk ,ca_city bought_city ,sum(ss_coupon_amt) amt ,sum(ss_net_profit) profit from store_sales,date_dim,store,household_demographics,customer_address where store_sales.ss_sold_date_sk = date_dim.d_date_sk and store_sales.ss_store_sk = store.s_store_sk and store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk and store_sales.ss_addr_sk = customer_address.ca_address_sk and (household_demographics.hd_dep_count = 3 or household_demographics.hd_vehicle_count= 0) and date_dim.d_dow in (6,0) and date_dim.d_year in (1999,1999+1,1999+2) and store.s_city in ('Riverview','Mount Pleasant','Glendale','Greenwood','New Hope') group by ss_ticket_number,ss_customer_sk,ss_addr_sk,ca_city) dn,customer,customer_address current_addr where ss_customer_sk = c_customer_sk and customer.c_current_addr_sk = current_addr.ca_address_sk and current_addr.ca_city <> bought_city order by c_last_name ,c_first_name ,ca_city ,bought_city ,ss_ticket_number limit 100; |tpcds_1000| Jun 5 22:51:42 um1 ExeMgr[20561]: 42.241268 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 22:51:42 um1 ExeMgr[20561]: 42.248575 |2147483675|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='catalog_returns' --columnRIDs/FE; || Jun 5 22:51:42 um1 ExeMgr[20561]: 42.360532 |2147483675|0|0| D 16 CAL0042: End SQL statement Jun 5 22:51:42 um1 ExeMgr[20561]: 42.363148 |2147483675|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='warehouse' --columnRIDs/FE; || Jun 5 22:51:42 um1 ExeMgr[20561]: 42.395702 |2147483675|0|0| D 16 CAL0042: End SQL statement Jun 5 22:51:49 um1 ExeMgr[20561]: 49.531152 |27|0|0| D 16 CAL0041: Start SQL statement: select w_state ,i_item_id ,sum(case when (cast(d_date as date) < cast('1999-02-07' as date)) then cs_sales_price - coalesce(cr_refunded_cash,0) else 0 end) as sales_before ,sum(case when (cast(d_date as date) >= cast('1999-02-07' as date)) then cs_sales_price - coalesce(cr_refunded_cash,0) else 0 end) as sales_after from catalog_sales left outer join catalog_returns on (cs_order_number = cr_order_number and cs_item_sk = cr_item_sk) ,warehouse ,item ,date_dim where i_current_price between 0.99 and 1.49 and i_item_sk = cs_item_sk and cs_warehouse_sk = w_warehouse_sk and cs_sold_date_sk = d_date_sk and d_date between DATE_SUB(cast('1999-02-07' as date),INTERVAL 30 day) and ADDDATE(cast('1999-02-07' as date),30) group by w_state,i_item_id order by w_state,i_item_id limit 100; |tpcds_1000| Jun 5 22:55:09 um1 ExeMgr[20561]: 09.162834 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 22:58:13 um1 ExeMgr[20561]: 13.149678 |27|0|0| D 16 CAL0041: Start SQL statement: select * from(select w_warehouse_name ,i_item_id ,sum(case when (cast(d_date as date) < cast('2002-02-27' as date)) then inv_quantity_on_hand else 0 end) as inv_before ,sum(case when (cast(d_date as date) >= cast('2002-02-27' as date)) then inv_quantity_on_hand else 0 end) as inv_after from inventory ,warehouse ,item ,date_dim where i_current_price between 0.99 and 1.49 and i_item_sk = inv_item_sk and inv_warehouse_sk = w_warehouse_sk and inv_date_sk = d_date_sk and d_date between DATE_SUB(cast('2002-02-27' as date),INTERVAL 30 day) and ADDDATE(cast('2002-02-27' as date),30) group by w_warehouse_name, i_item_id) x where (case when inv_before > 0 then inv_after / inv_before else null end) between 2.0/3.0 and 3.0/2.0 order by w_warehouse_name ,i_item_id limit 100; |tpcds_1000| Jun 5 22:58:16 um1 ExeMgr[20561]: 16.553615 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 22:58:16 um1 ExeMgr[20561]: 16.865419 |27|0|0| D 16 CAL0041: Start SQL statement: select i_item_id, avg(cs_quantity) agg1, avg(cs_list_price) agg2, avg(cs_coupon_amt) agg3, avg(cs_sales_price) agg4 from catalog_sales, customer_demographics, date_dim, item, promotion where cs_sold_date_sk = d_date_sk and cs_item_sk = i_item_sk and cs_bill_cdemo_sk = cd_demo_sk and cs_promo_sk = p_promo_sk and cd_gender = 'F' and cd_marital_status = 'W' and cd_education_status = 'Advanced Degree' and (p_channel_email = 'N' or p_channel_event = 'N') and d_year = 1999 group by i_item_id order by i_item_id limit 100; |tpcds_1000| Jun 5 22:58:54 um1 ExeMgr[20561]: 54.789118 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 22:58:55 um1 ExeMgr[20561]: 55.004537 |27|0|0| D 16 CAL0041: Start SQL statement: select i_brand_id brand_id, i_brand brand,t_hour,t_minute, sum(ext_price) ext_price from item, (select ws_ext_sales_price as ext_price, ws_sold_date_sk as sold_date_sk, ws_item_sk as sold_item_sk, ws_sold_time_sk as time_sk from web_sales,date_dim where d_date_sk = ws_sold_date_sk and d_moy=11 and d_year=2001 union all select cs_ext_sales_price as ext_price, cs_sold_date_sk as sold_date_sk, cs_item_sk as sold_item_sk, cs_sold_time_sk as time_sk from catalog_sales,date_dim where d_date_sk = cs_sold_date_sk and d_moy=11 and d_year=2001 union all select ss_ext_sales_price as ext_price, ss_sold_date_sk as sold_date_sk, ss_item_sk as sold_item_sk, ss_sold_time_sk as time_sk from store_sales,date_dim where d_date_sk = ss_sold_date_sk and d_moy=11 and d_year=2001 ) tmp,time_dim where sold_item_sk = i_item_sk and i_manager_id=1 and time_sk = t_time_sk and (t_meal_time = 'breakfast' or t_meal_time = 'dinner') group by i_brand, i_brand_id,t_hour,t_minute order by ext_price desc, i_brand_id; |tpcds_1000| Jun 5 23:03:32 um1 ExeMgr[20561]: 32.163034 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 23:06:13 um1 ExeMgr[20561]: 13.099298 |27|0|0| D 16 CAL0041: Start SQL statement: select cd_gender, cd_marital_status, cd_education_status, count(*) cnt1, cd_purchase_estimate, count(*) cnt2, cd_credit_rating, count(*) cnt3 from customer c,customer_address ca,customer_demographics where c.c_current_addr_sk = ca.ca_address_sk and ca_state in ('CA','IL','AR') and cd_demo_sk = c.c_current_cdemo_sk and exists (select * from store_sales,date_dim where c.c_customer_sk = ss_customer_sk and ss_sold_date_sk = d_date_sk and d_year = 2004 and d_moy between 4 and 4+2) and (not exists (select * from web_sales,date_dim where c.c_customer_sk = ws_bill_customer_sk and ws_sold_date_sk = d_date_sk and d_year = 2004 and d_moy between 4 and 4+2) and not exists (select * from catalog_sales,date_dim where c.c_customer_sk = cs_ship_customer_sk and cs_sold_date_sk = d_date_sk and d_year = 2004 and d_moy between 4 and 4+2)) group by cd_gender, cd_marital_status, cd_education_status, cd_purchase_estimate, cd_credit_rating order by cd_gender, cd_marital_status, cd_education_status, cd_purchase_estimate, cd_credit_rating limit 100; |tpcds_1000| Jun 5 23:06:15 um1 ExeMgr[20561]: 15.003157 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 23:06:15 um1 ExeMgr[20561]: 15.007207 |2147483675|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='ship_mode' --columnRIDs/FE; || Jun 5 23:06:15 um1 ExeMgr[20561]: 15.135002 |2147483675|0|0| D 16 CAL0042: End SQL statement Jun 5 23:06:15 um1 ExeMgr[20561]: 15.137489 |2147483675|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='call_center' --columnRIDs/FE; || Jun 5 23:06:15 um1 ExeMgr[20561]: 15.172978 |2147483675|0|0| D 16 CAL0042: End SQL statement Jun 5 23:06:16 um1 ExeMgr[20561]: 16.251083 |27|0|0| D 16 CAL0041: Start SQL statement: select substr(w_warehouse_name,1,20) ,sm_type ,cc_name ,sum(case when (cs_ship_date_sk - cs_sold_date_sk <= 30 ) then 1 else 0 end) as "30 days" ,sum(case when (cs_ship_date_sk - cs_sold_date_sk > 30) and (cs_ship_date_sk - cs_sold_date_sk <= 60) then 1 else 0 end ) as "31-60 days" ,sum(case when (cs_ship_date_sk - cs_sold_date_sk > 60) and (cs_ship_date_sk - cs_sold_date_sk <= 90) then 1 else 0 end) as "61-90 days" ,sum(case when (cs_ship_date_sk - cs_sold_date_sk > 90) and (cs_ship_date_sk - cs_sold_date_sk <= 120) then 1 else 0 end) as "91-120 days" ,sum(case when (cs_ship_date_sk - cs_sold_date_sk > 120) then 1 else 0 end) as ">120 days" from catalog_sales ,warehouse ,ship_mode ,call_center ,date_dim where d_month_seq between 1190 and 1190 + 11 and cs_ship_date_sk = d_date_sk and cs_warehouse_sk = w_warehouse_sk and cs_ship_mode_sk = sm_ship_mode_sk and cs_call_center_sk = cc_call_center_sk group by substr(w_warehouse_name,1,20) ,sm_type ,cc_name order by substr(w_warehouse_name,1,20) ,sm_type ,cc_name limit 100; |tpcds_1000| Jun 5 23:09:52 um1 ExeMgr[20561]: 52.992280 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 23:09:53 um1 ExeMgr[20561]: 53.304960 |27|0|0| D 16 CAL0041: Start SQL statement: select i_item_id ,i_item_desc ,i_category ,i_class ,i_current_price ,sum(ss_ext_sales_price) as itemrevenue ,sum(ss_ext_sales_price)*100/sum(sum(ss_ext_sales_price)) over (partition by i_class) as revenueratio from store_sales ,item ,date_dim where ss_item_sk = i_item_sk and i_category in ('Women', 'Shoes', 'Children') and ss_sold_date_sk = d_date_sk and (d_date between cast('2000-01-03' as date) and ADDDATE(cast('2000-01-03' as date),30)) group by i_item_id ,i_item_desc ,i_category ,i_class ,i_current_price order by i_category ,i_class ,i_item_id ,i_item_desc ,revenueratio; |tpcds_1000| Jun 5 23:12:27 um1 ExeMgr[20561]: 27.794879 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 23:12:28 um1 ExeMgr[20561]: 28.017094 |27|0|0| D 16 CAL0041: Start SQL statement: select i_brand_id brand_id, i_brand brand, i_manufact_id, i_manufact, sum(ss_ext_sales_price) ext_price from date_dim, store_sales, item,customer,customer_address,store where d_date_sk = ss_sold_date_sk and ss_item_sk = i_item_sk and i_manager_id=42 and d_moy=11 and d_year=1999 and ss_customer_sk = c_customer_sk and c_current_addr_sk = ca_address_sk and substr(ca_zip,1,5) <> substr(s_zip,1,5) and ss_store_sk = s_store_sk group by i_brand ,i_brand_id ,i_manufact_id ,i_manufact order by ext_price desc ,i_brand ,i_brand_id ,i_manufact_id ,i_manufact limit 100; |tpcds_1000| Jun 5 23:15:23 um1 ExeMgr[20561]: 23.596940 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 23:15:36 um1 ExeMgr[20561]: 36.506500 |27|0|0| D 16 CAL0041: Start SQL statement: select ca_zip ,sum(cs_sales_price) from catalog_sales ,customer ,customer_address ,date_dim where cs_bill_customer_sk = c_customer_sk and c_current_addr_sk = ca_address_sk and ( substr(ca_zip,1,5) in ('85669', '86197','88274','83405','86475', '85392', '85460', '80348', '81792') or ca_state in ('CA','WA','GA') or cs_sales_price > 500) and cs_sold_date_sk = d_date_sk and d_qoy = 1 and d_year = 2002 group by ca_zip order by ca_zip limit 100; |tpcds_1000| Jun 5 23:16:06 um1 ExeMgr[20561]: 06.388060 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 23:16:06 um1 ExeMgr[20561]: 06.394364 |2147483675|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='web_site' --columnRIDs/FE; || Jun 5 23:16:06 um1 ExeMgr[20561]: 06.509735 |2147483675|0|0| D 16 CAL0042: End SQL statement Jun 5 23:16:20 um1 ExeMgr[20561]: 20.005333 |27|0|0| D 16 CAL0041: Start SQL statement: select substr(w_warehouse_name,1,20) ,sm_type ,web_name ,sum(case when (ws_ship_date_sk - ws_sold_date_sk <= 30 ) then 1 else 0 end) as "30 days" ,sum(case when (ws_ship_date_sk - ws_sold_date_sk > 30) and (ws_ship_date_sk - ws_sold_date_sk <= 60) then 1 else 0 end ) as "31-60 days" ,sum(case when (ws_ship_date_sk - ws_sold_date_sk > 60) and (ws_ship_date_sk - ws_sold_date_sk <= 90) then 1 else 0 end) as "61-90 days" ,sum(case when (ws_ship_date_sk - ws_sold_date_sk > 90) and (ws_ship_date_sk - ws_sold_date_sk <= 120) then 1 else 0 end) as "91-120 days" ,sum(case when (ws_ship_date_sk - ws_sold_date_sk > 120) then 1 else 0 end) as ">120 days" from web_sales ,warehouse ,ship_mode ,web_site ,date_dim where d_month_seq between 1204 and 1204 + 11 and ws_ship_date_sk = d_date_sk and ws_warehouse_sk = w_warehouse_sk and ws_ship_mode_sk = sm_ship_mode_sk and ws_web_site_sk = web_site_sk group by substr(w_warehouse_name,1,20) ,sm_type ,web_name order by substr(w_warehouse_name,1,20) ,sm_type ,web_name limit 100; |tpcds_1000| Jun 5 23:18:54 um1 ExeMgr[20561]: 54.253250 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 23:18:54 um1 ExeMgr[20561]: 54.384231 |27|0|0| D 16 CAL0041: Start SQL statement: select sum(ss_quantity) from store_sales, store, customer_demographics, customer_address, date_dim where s_store_sk = ss_store_sk and cd_demo_sk = ss_cdemo_sk and ss_addr_sk = ca_address_sk and ss_sold_date_sk = d_date_sk and d_year = 2000 and ( ( cd_marital_status = 'W' and cd_education_status = 'Advanced Degree' and ss_sales_price between 100.00 and 150.00 ) or ( cd_marital_status = 'U' and cd_education_status = '2 yr Degree' and ss_sales_price between 50.00 and 100.00 ) or ( cd_marital_status = 'M' and cd_education_status = 'Primary' and ss_sales_price between 150.00 and 200.00 ) ) and ( ( ca_country = 'United States' and ca_state in ('SD', 'AL', 'SC') and ss_net_profit between 0 and 2000 ) or ( ca_country = 'United States' and ca_state in ('NC', 'NM', 'WI') and ss_net_profit between 150 and 3000 ) or ( ca_country = 'United States' and ca_state in ('FL', 'ID', 'TX') and ss_net_profit between 50 and 25000 ) ); |tpcds_1000| Jun 5 23:23:27 um1 ExeMgr[20561]: 27.586006 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 23:23:32 um1 ExeMgr[20561]: 32.357480 |27|0|0| D 16 CAL0041: Start SQL statement: select cc_call_center_id Call_Center, cc_name Call_Center_Name, cc_manager Manager, sum(cr_net_loss) Returns_Loss from call_center, catalog_returns, date_dim, customer, customer_address, customer_demographics, household_demographics where cr_call_center_sk = cc_call_center_sk and cr_returned_date_sk = d_date_sk and cr_returning_customer_sk= c_customer_sk and cd_demo_sk = c_current_cdemo_sk and hd_demo_sk = c_current_hdemo_sk and ca_address_sk = c_current_addr_sk and d_year = 2000 and d_moy = 12 and ( (cd_marital_status = 'M' and cd_education_status = 'Unknown') or(cd_marital_status = 'W' and cd_education_status = 'Advanced Degree')) and hd_buy_potential like '1001-5000%' and ca_gmt_offset = -7 group by cc_call_center_id,cc_name,cc_manager,cd_marital_status,cd_education_status order by sum(cr_net_loss) desc; |tpcds_1000| Jun 5 23:23:37 um1 ExeMgr[20561]: 37.652828 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 23:23:37 um1 ExeMgr[20561]: 37.879936 |27|0|0| D 16 CAL0041: Start SQL statement: select c_last_name,c_first_name,substr(s_city,1,30),ss_ticket_number,amt,profit from (select ss_ticket_number ,ss_customer_sk ,store.s_city ,sum(ss_coupon_amt) amt ,sum(ss_net_profit) profit from store_sales,date_dim,store,household_demographics where store_sales.ss_sold_date_sk = date_dim.d_date_sk and store_sales.ss_store_sk = store.s_store_sk and store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk and (household_demographics.hd_dep_count = 1 or household_demographics.hd_vehicle_count > 1) and date_dim.d_dow = 1 and date_dim.d_year in (1999,1999+1,1999+2) and store.s_number_employees between 200 and 295 group by ss_ticket_number,ss_customer_sk,ss_addr_sk,store.s_city) ms,customer where ss_customer_sk = c_customer_sk order by c_last_name,c_first_name,substr(s_city,1,30), profit ,ss_ticket_number limit 100; |tpcds_1000| Jun 5 23:28:04 um1 ExeMgr[20561]: 04.248959 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 23:28:11 um1 ExeMgr[20561]: 11.750189 |27|0|0| D 16 CAL0041: Start SQL statement: select channel, item, return_ratio, return_rank, currency_rank from (select 'web' as channel ,web.item ,web.return_ratio ,web.return_rank ,web.currency_rank from ( select item ,return_ratio ,currency_ratio ,rank() over (order by return_ratio) as return_rank ,rank() over (order by currency_ratio) as currency_rank from ( select ws.ws_item_sk as item ,(cast(sum(coalesce(wr.wr_return_quantity,0)) as decimal(15,4))/ cast(sum(coalesce(ws.ws_quantity,0)) as decimal(15,4) )) as return_ratio ,(cast(sum(coalesce(wr.wr_return_amt,0)) as decimal(15,4))/ cast(sum(coalesce(ws.ws_net_paid,0)) as decimal(15,4) )) as currency_ratio from web_sales ws left outer join web_returns wr on (ws.ws_order_number = wr.wr_order_number and ws.ws_item_sk = wr.wr_item_sk) ,date_dim where wr.wr_return_amt > 10000 and ws.ws_net_profit > 1 and ws.ws_net_paid > 0 and ws.ws_quantity > 0 and ws_sold_date_sk = d_date_sk and d_year = 1999 and d_moy = 11 group by ws.ws_item_sk ) in_web ) web where ( web.return_rank <= 10 or web.currency_rank <= 10 ) union select 'catalog' as channel ,catalog.item ,catalog.return_ratio ,catalog.return_rank ,catalog.currency_rank from ( select item ,return_ratio ,currency_ratio ,rank() over (order by return_ratio) as return_rank ,rank() over (order by currency_ratio) as currency_rank from ( select cs.cs_item_sk as item ,(cast(sum(coalesce(cr.cr_return_quantity,0)) as decimal(15,4))/ cast(sum(coalesce(cs.cs_quantity,0)) as decimal(15,4) )) as return_ratio ,(cast(sum(coalesce(cr.cr_return_amount,0)) as decimal(15,4))/ cast(sum(coalesce(cs.cs_net_paid,0)) as decimal(15,4) )) as currency_ratio from catalog_sales cs left outer join catalog_returns cr on (cs.cs_order_number = cr.cr_order_number and cs.cs_item_sk = cr.cr_item_sk) ,date_dim where cr.cr_return_amount > 10000 and cs.cs_net_profit > 1 and cs.cs_net_paid > 0 and cs.cs_quantity > 0 and cs_sold_date_sk = d_date_sk and d_year = 1999 and d_moy = 11 group by cs.cs_item_sk ) in_cat ) catalog where ( catalog.return_rank <= 10 or catalog.currency_rank <=10 ) union select 'store' as channel ,store.item ,store.return_ratio ,store.return_rank ,store.currency_rank from ( select item ,return_ratio ,currency_ratio ,rank() over (order by return_ratio) as return_rank ,rank() over (order by currency_ratio) as currency_rank from ( select sts.ss_item_sk as item ,(cast(sum(coalesce(sr.sr_return_quantity,0)) as decimal(15,4))/cast(sum(coalesce(sts.ss_quantity,0)) as decimal(15,4) )) as return_ratio ,(cast(sum(coalesce(sr.sr_return_amt,0)) as decimal(15,4))/cast(sum(coalesce(sts.ss_net_paid,0)) as decimal(15,4) )) as currency_ratio from store_sales sts left outer join store_returns sr on (sts.ss_ticket_number = sr.sr_ticket_number and sts.ss_item_sk = sr.sr_item_sk) ,date_dim where sr.sr_return_amt > 10000 and sts.ss_net_profit > 1 and sts.ss_net_paid > 0 and sts.ss_quantity > 0 and ss_sold_date_sk = d_date_sk and d_year = 1999 and d_moy = 11 group by sts.ss_item_sk ) in_store ) store where ( store.return_rank <= 10 or store.currency_rank <= 10 ) )f order by 1,4,5,2 limit 100; |tpcds_1000| Jun 5 23:35:19 um1 ExeMgr[20561]: 19.425374 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 23:35:19 um1 ExeMgr[20561]: 19.687653 |27|0|0| D 16 CAL0041: Start SQL statement: select i_item_id, avg(ss_quantity) agg1, avg(ss_list_price) agg2, avg(ss_coupon_amt) agg3, avg(ss_sales_price) agg4 from store_sales, customer_demographics, date_dim, item, promotion where ss_sold_date_sk = d_date_sk and ss_item_sk = i_item_sk and ss_cdemo_sk = cd_demo_sk and ss_promo_sk = p_promo_sk and cd_gender = 'F' and cd_marital_status = 'D' and cd_education_status = '4 yr Degree' and (p_channel_email = 'N' or p_channel_event = 'N') and d_year = 1999 group by i_item_id order by i_item_id limit 100; |tpcds_1000| Jun 5 23:41:24 um1 ExeMgr[20561]: 24.658290 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 23:41:24 um1 ExeMgr[20561]: 24.905156 |27|0|0| D 16 CAL0041: Start SQL statement: select i_brand_id brand_id, i_brand brand, sum(ss_ext_sales_price) ext_price from date_dim, store_sales, item where d_date_sk = ss_sold_date_sk and ss_item_sk = i_item_sk and i_manager_id=78 and d_moy=11 and d_year=2002 group by i_brand, i_brand_id order by ext_price desc, i_brand_id limit 100; |tpcds_1000| Jun 5 23:43:57 um1 ExeMgr[20561]: 57.848772 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 23:43:58 um1 ExeMgr[20561]: 58.153982 |27|0|0| D 16 CAL0041: Start SQL statement: select i_item_id ,i_item_desc ,i_current_price from item, inventory, date_dim, store_sales where i_current_price between 64 and 64+30 and inv_item_sk = i_item_sk and d_date_sk=inv_date_sk and d_date between cast('1999-07-06' as date) and ADDDATE(cast('1999-07-06' as date),60) and i_manufact_id in (322,686,530,711) 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 limit 100; |tpcds_1000| Jun 5 23:44:57 um1 ExeMgr[20561]: 57.281719 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 23:45:05 um1 ExeMgr[20561]: 05.504668 |27|0|0| D 16 CAL0041: Start SQL statement: select s_store_name, i_item_desc, sc.revenue, i_current_price, i_wholesale_cost, i_brand from store, item, (select ss_store_sk, avg(revenue) as ave from (select ss_store_sk, ss_item_sk, sum(ss_sales_price) as revenue from store_sales, date_dim where ss_sold_date_sk = d_date_sk and d_month_seq between 1187 and 1187+11 group by ss_store_sk, ss_item_sk) sa group by ss_store_sk) sb, (select ss_store_sk, ss_item_sk, sum(ss_sales_price) as revenue from store_sales, date_dim where ss_sold_date_sk = d_date_sk and d_month_seq between 1187 and 1187+11 group by ss_store_sk, ss_item_sk) sc where sb.ss_store_sk = sc.ss_store_sk and sc.revenue <= 0.1 * sb.ave and s_store_sk = sc.ss_store_sk and i_item_sk = sc.ss_item_sk order by s_store_name, i_item_desc limit 100; |tpcds_1000| Jun 5 23:53:04 um1 ExeMgr[20561]: 04.661021 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 23:53:04 um1 ExeMgr[20561]: 04.683185 |2147483675|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='income_band' --columnRIDs/FE; || Jun 5 23:53:04 um1 ExeMgr[20561]: 04.794133 |2147483675|0|0| D 16 CAL0042: End SQL statement Jun 5 23:53:26 um1 ExeMgr[20561]: 26.997861 |27|0|0| D 16 CAL0041: Start SQL statement: select c_customer_id as customer_id , concat( coalesce(c_last_name,'') , ', ' , coalesce(c_first_name,'')) as customername from customer ,customer_address ,customer_demographics ,household_demographics ,income_band ,store_returns where ca_city = 'Sulphur Springs' and c_current_addr_sk = ca_address_sk and ib_lower_bound >= 12432 and ib_upper_bound <= 12432 + 50000 and ib_income_band_sk = hd_income_band_sk and cd_demo_sk = c_current_cdemo_sk and hd_demo_sk = c_current_hdemo_sk and sr_cdemo_sk = cd_demo_sk order by c_customer_id limit 100; |tpcds_1000| Jun 5 23:53:40 um1 ExeMgr[20561]: 40.258717 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 23:53:40 um1 ExeMgr[20561]: 40.578026 |27|0|0| D 16 CAL0041: Start SQL statement: 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 = 520 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; |tpcds_1000| Jun 5 23:55:25 um1 ExeMgr[20561]: 25.498146 |27|0|0| D 16 CAL0042: End SQL statement Jun 5 23:55:31 um1 ExeMgr[20561]: 31.055549 |2147483725|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='date_dim' --columnRIDs/FE; || Jun 5 23:55:31 um1 ExeMgr[20561]: 31.176073 |2147483725|0|0| D 16 CAL0042: End SQL statement Jun 5 23:55:31 um1 ExeMgr[20561]: 31.178878 |2147483725|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store_sales' --columnRIDs/FE; || Jun 5 23:55:31 um1 ExeMgr[20561]: 31.214546 |2147483725|0|0| D 16 CAL0042: End SQL statement Jun 5 23:55:31 um1 ExeMgr[20561]: 31.216790 |2147483725|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='item' --columnRIDs/FE; || Jun 5 23:55:31 um1 ExeMgr[20561]: 31.250270 |2147483725|0|0| D 16 CAL0042: End SQL statement Jun 5 23:55:31 um1 ExeMgr[20561]: 31.595523 |77|0|0| D 16 CAL0041: Start SQL statement: select dt.d_year ,item.i_brand_id brand_id ,item.i_brand brand ,TRIM(TRAILING '.' FROM TRIM((sum(ss_ext_sales_price))))+0 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 = 128 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; |tpcds_1000| Jun 5 23:58:15 um1 ExeMgr[20561]: 15.370714 |77|0|0| D 16 CAL0042: End SQL statement Jun 5 23:58:16 um1 ExeMgr[20561]: 16.236785 |2147483728|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='customer_address' --columnRIDs/FE; || Jun 5 23:58:16 um1 ExeMgr[20561]: 16.346493 |2147483728|0|0| D 16 CAL0042: End SQL statement Jun 5 23:58:16 um1 ExeMgr[20561]: 16.348466 |2147483728|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='customer' --columnRIDs/FE; || Jun 5 23:58:16 um1 ExeMgr[20561]: 16.378635 |2147483728|0|0| D 16 CAL0042: End SQL statement Jun 5 23:58:16 um1 ExeMgr[20561]: 16.379851 |2147483728|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store_sales' --columnRIDs/FE; || Jun 5 23:58:16 um1 ExeMgr[20561]: 16.410142 |2147483728|0|0| D 16 CAL0042: End SQL statement Jun 5 23:58:16 um1 ExeMgr[20561]: 16.411749 |2147483728|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='date_dim' --columnRIDs/FE; || Jun 5 23:58:16 um1 ExeMgr[20561]: 16.439076 |2147483728|0|0| D 16 CAL0042: End SQL statement Jun 5 23:58:16 um1 ExeMgr[20561]: 16.440247 |2147483728|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='item' --columnRIDs/FE; || Jun 5 23:58:16 um1 ExeMgr[20561]: 16.467163 |2147483728|0|0| D 16 CAL0042: End SQL statement Jun 5 23:58:16 um1 ExeMgr[20561]: 16.570129 |80|0|0| D 16 CAL0041: Start SQL statement: select a.ca_state state, count(*) cnt from customer_address a ,customer c ,store_sales s ,date_dim d ,item i where a.ca_address_sk = c.c_current_addr_sk and c.c_customer_sk = s.ss_customer_sk and s.ss_sold_date_sk = d.d_date_sk and s.ss_item_sk = i.i_item_sk and d.d_month_seq = (select distinct (d_month_seq) from date_dim where d_year = 2001 and d_moy = 1 ) and i.i_current_price > (select 1.2*avg(j.i_current_price) from item j where j.i_category = i.i_category) group by a.ca_state having count(*) >= 10 order by cnt, a.ca_state limit 100; |tpcds_1000| Jun 6 00:00:35 um1 ExeMgr[20561]: 35.240871 |80|0|0| D 16 CAL0042: End SQL statement Jun 6 00:00:36 um1 ExeMgr[20561]: 36.122438 |2147483731|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store_sales' --columnRIDs/FE; || Jun 6 00:00:36 um1 ExeMgr[20561]: 36.229414 |2147483731|0|0| D 16 CAL0042: End SQL statement Jun 6 00:00:36 um1 ExeMgr[20561]: 36.230978 |2147483731|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='customer_demographics' --columnRIDs/FE; || Jun 6 00:00:36 um1 ExeMgr[20561]: 36.258508 |2147483731|0|0| D 16 CAL0042: End SQL statement Jun 6 00:00:36 um1 ExeMgr[20561]: 36.259830 |2147483731|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='date_dim' --columnRIDs/FE; || Jun 6 00:00:36 um1 ExeMgr[20561]: 36.285170 |2147483731|0|0| D 16 CAL0042: End SQL statement Jun 6 00:00:36 um1 ExeMgr[20561]: 36.286368 |2147483731|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='item' --columnRIDs/FE; || Jun 6 00:00:36 um1 ExeMgr[20561]: 36.312559 |2147483731|0|0| D 16 CAL0042: End SQL statement Jun 6 00:00:36 um1 ExeMgr[20561]: 36.313835 |2147483731|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='promotion' --columnRIDs/FE; || Jun 6 00:00:36 um1 ExeMgr[20561]: 36.339287 |2147483731|0|0| D 16 CAL0042: End SQL statement Jun 6 00:00:36 um1 ExeMgr[20561]: 36.436904 |83|0|0| D 16 CAL0041: Start SQL statement: select i_item_id, avg(cast( ss_quantity as decimal(64,2)) ) agg1, avg(ss_list_price) agg2, avg(ss_coupon_amt) agg3, avg(ss_sales_price) agg4 from store_sales, customer_demographics, date_dim, item, promotion where ss_sold_date_sk = d_date_sk and ss_item_sk = i_item_sk and ss_cdemo_sk = cd_demo_sk and ss_promo_sk = p_promo_sk and cd_gender = 'M' and cd_marital_status = 'S' and cd_education_status = 'College' and (p_channel_email = 'N' or p_channel_event = 'N') and d_year = 2000 group by i_item_id order by i_item_id limit 100; |tpcds_1000| Jun 6 00:06:37 um1 ExeMgr[20561]: 37.272860 |83|0|0| D 16 CAL0042: End SQL statement Jun 6 00:06:38 um1 ExeMgr[20561]: 38.977493 |2147483734|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='web_sales' --columnRIDs/FE; || Jun 6 00:06:39 um1 ExeMgr[20561]: 39.092705 |2147483734|0|0| D 16 CAL0042: End SQL statement Jun 6 00:06:39 um1 ExeMgr[20561]: 39.096611 |2147483734|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='item' --columnRIDs/FE; || Jun 6 00:06:39 um1 ExeMgr[20561]: 39.128511 |2147483734|0|0| D 16 CAL0042: End SQL statement Jun 6 00:06:39 um1 ExeMgr[20561]: 39.129972 |2147483734|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='date_dim' --columnRIDs/FE; || Jun 6 00:06:39 um1 ExeMgr[20561]: 39.157573 |2147483734|0|0| D 16 CAL0042: End SQL statement Jun 6 00:06:39 um1 ExeMgr[20561]: 39.435244 |86|0|0| D 16 CAL0041: Start SQL statement: select i_item_id ,i_item_desc ,i_category ,i_class ,i_current_price ,sum(ws_ext_sales_price) as itemrevenue ,sum(ws_ext_sales_price)*100/sum(sum(ws_ext_sales_price)) over (partition by i_class) as revenueratio from web_sales ,item ,date_dim where ws_item_sk = i_item_sk and i_category in ('Sports', 'Books', 'Home') and ws_sold_date_sk = d_date_sk and d_date between cast('1999-02-22' as date) and ADDDATE(cast('1999-02-22' as date),30) group by i_item_id ,i_item_desc ,i_category ,i_class ,i_current_price order by i_category ,i_class ,i_item_id ,i_item_desc ,revenueratio limit 100; |tpcds_1000| Jun 6 00:07:22 um1 ExeMgr[20561]: 22.092848 |86|0|0| D 16 CAL0042: End SQL statement Jun 6 00:07:22 um1 ExeMgr[20561]: 22.355672 |2147483737|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store_sales' --columnRIDs/FE; || Jun 6 00:07:22 um1 ExeMgr[20561]: 22.487655 |2147483737|0|0| D 16 CAL0042: End SQL statement Jun 6 00:07:22 um1 ExeMgr[20561]: 22.488873 |2147483737|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store' --columnRIDs/FE; || Jun 6 00:07:22 um1 ExeMgr[20561]: 22.516129 |2147483737|0|0| D 16 CAL0042: End SQL statement Jun 6 00:07:22 um1 ExeMgr[20561]: 22.517433 |2147483737|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='customer_demographics' --columnRIDs/FE; || Jun 6 00:07:22 um1 ExeMgr[20561]: 22.544919 |2147483737|0|0| D 16 CAL0042: End SQL statement Jun 6 00:07:22 um1 ExeMgr[20561]: 22.546845 |2147483737|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='household_demographics' --columnRIDs/FE; || Jun 6 00:07:22 um1 ExeMgr[20561]: 22.577631 |2147483737|0|0| D 16 CAL0042: End SQL statement Jun 6 00:07:22 um1 ExeMgr[20561]: 22.578848 |2147483737|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='customer_address' --columnRIDs/FE; || Jun 6 00:07:22 um1 ExeMgr[20561]: 22.610623 |2147483737|0|0| D 16 CAL0042: End SQL statement Jun 6 00:07:22 um1 ExeMgr[20561]: 22.612486 |2147483737|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='date_dim' --columnRIDs/FE; || Jun 6 00:07:22 um1 ExeMgr[20561]: 22.644207 |2147483737|0|0| D 16 CAL0042: End SQL statement Jun 6 00:07:22 um1 ExeMgr[20561]: 22.763939 |89|0|0| D 16 CAL0041: Start SQL statement: select avg(ss_quantity) ,avg(ss_ext_sales_price) ,avg(ss_ext_wholesale_cost) ,sum(ss_ext_wholesale_cost) from store_sales ,store ,customer_demographics ,household_demographics ,customer_address ,date_dim where s_store_sk = ss_store_sk and ss_hdemo_sk=hd_demo_sk and cd_demo_sk = ss_cdemo_sk and ss_addr_sk = ca_address_sk and ss_sold_date_sk = d_date_sk and d_year = 2001 and((ss_hdemo_sk=hd_demo_sk and cd_marital_status = 'M' and cd_education_status = 'Advanced Degree' and ss_sales_price between 100.00 and 150.00 and hd_dep_count = 3 )or ( cd_marital_status = 'S' and cd_education_status = 'College' and ss_sales_price between 50.00 and 100.00 and hd_dep_count = 1 ) or ( cd_marital_status = 'W' and cd_education_status = '2 yr Degree' and ss_sales_price between 150.00 and 200.00 and hd_dep_count = 1 )) and(( ca_country = 'United States' and ca_state in ('TX', 'OH', 'TX') and ss_net_profit between 100 and 200 ) or ( ca_country = 'United States' and ca_state in ('OR', 'NM', 'KY') and ss_net_profit between 150 and 300 ) or ( ca_country = 'United States' and ca_state in ('VA', 'TX', 'MS') and ss_net_profit between 50 and 250 )); |tpcds_1000| Jun 6 00:14:26 um1 ExeMgr[20561]: 26.160081 |89|0|0| D 16 CAL0042: End SQL statement Jun 6 00:14:27 um1 ExeMgr[20561]: 27.909483 |2147483740|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='catalog_sales' --columnRIDs/FE; || Jun 6 00:14:28 um1 ExeMgr[20561]: 28.027494 |2147483740|0|0| D 16 CAL0042: End SQL statement Jun 6 00:14:28 um1 ExeMgr[20561]: 28.029380 |2147483740|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='customer' --columnRIDs/FE; || Jun 6 00:14:28 um1 ExeMgr[20561]: 28.055864 |2147483740|0|0| D 16 CAL0042: End SQL statement Jun 6 00:14:28 um1 ExeMgr[20561]: 28.059668 |2147483740|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='customer_address' --columnRIDs/FE; || Jun 6 00:14:28 um1 ExeMgr[20561]: 28.086130 |2147483740|0|0| D 16 CAL0042: End SQL statement Jun 6 00:14:28 um1 ExeMgr[20561]: 28.087809 |2147483740|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='date_dim' --columnRIDs/FE; || Jun 6 00:14:28 um1 ExeMgr[20561]: 28.118324 |2147483740|0|0| D 16 CAL0042: End SQL statement Jun 6 00:14:28 um1 ExeMgr[20561]: 28.218478 |92|0|0| D 16 CAL0041: Start SQL statement: select ca_zip ,sum(cs_sales_price) from catalog_sales ,customer ,customer_address ,date_dim where cs_bill_customer_sk = c_customer_sk and c_current_addr_sk = ca_address_sk and ( substr(ca_zip,1,5) in ('85669', '86197','88274','83405','86475', '85392', '85460', '80348', '81792') or ca_state in ('CA','WA','GA') or cs_sales_price > 500) and cs_sold_date_sk = d_date_sk and d_qoy = 2 and d_year = 2001 group by ca_zip order by ca_zip limit 100; |tpcds_1000| Jun 6 00:15:00 um1 ExeMgr[20561]: 00.005783 |92|0|0| D 16 CAL0042: End SQL statement Jun 6 00:15:00 um1 ExeMgr[20561]: 00.067665 |2147483743|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store_sales' --columnRIDs/FE; || Jun 6 00:15:00 um1 ExeMgr[20561]: 00.169153 |2147483743|0|0| D 16 CAL0042: End SQL statement Jun 6 00:15:00 um1 ExeMgr[20561]: 00.171708 |2147483743|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store_returns' --columnRIDs/FE; || Jun 6 00:15:00 um1 ExeMgr[20561]: 00.204606 |2147483743|0|0| D 16 CAL0042: End SQL statement Jun 6 00:15:00 um1 ExeMgr[20561]: 00.205720 |2147483743|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='catalog_sales' --columnRIDs/FE; || Jun 6 00:15:00 um1 ExeMgr[20561]: 00.233164 |2147483743|0|0| D 16 CAL0042: End SQL statement Jun 6 00:15:00 um1 ExeMgr[20561]: 00.234755 |2147483743|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='date_dim' --columnRIDs/FE; || Jun 6 00:15:00 um1 ExeMgr[20561]: 00.265529 |2147483743|0|0| D 16 CAL0042: End SQL statement Jun 6 00:15:00 um1 ExeMgr[20561]: 00.267496 |2147483743|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store' --columnRIDs/FE; || Jun 6 00:15:00 um1 ExeMgr[20561]: 00.299892 |2147483743|0|0| D 16 CAL0042: End SQL statement Jun 6 00:15:00 um1 ExeMgr[20561]: 00.302291 |2147483743|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='item' --columnRIDs/FE; || Jun 6 00:15:00 um1 ExeMgr[20561]: 00.335446 |2147483743|0|0| D 16 CAL0042: End SQL statement Jun 6 00:15:00 um1 ExeMgr[20561]: 00.455385 |95|0|0| D 16 CAL0041: Start SQL statement: select i_item_id ,i_item_desc ,s_state ,count(ss_quantity) as store_sales_quantitycount ,TRIM(TRAILING '.' FROM TRIM((avg(ss_quantity))))+0 as store_sales_quantityave ,stddev_samp(ss_quantity) as store_sales_quantitystdev ,stddev_samp(ss_quantity)/avg(ss_quantity) as store_sales_quantitycov ,count(sr_return_quantity) as store_returns_quantitycount ,TRIM(TRAILING '.' FROM TRIM((avg(sr_return_quantity))))+0 as store_returns_quantityave ,stddev_samp(sr_return_quantity) as store_returns_quantitystdev ,stddev_samp(sr_return_quantity)/avg(sr_return_quantity) as store_returns_quantitycov ,count(cs_quantity) as catalog_sales_quantitycount ,TRIM(TRAILING '.' FROM TRIM((avg(cs_quantity))))+0 as catalog_sales_quantityave ,stddev_samp(cs_quantity) as catalog_sales_quantitystdev ,stddev_samp(cs_quantity)/avg(cs_quantity) as catalog_sales_quantitycov from store_sales ,store_returns ,catalog_sales ,date_dim d1 ,date_dim d2 ,date_dim d3 ,store ,item where d1.d_quarter_name = '2001Q1' and d1.d_date_sk = ss_sold_date_sk and i_item_sk = ss_item_sk and s_store_sk = ss_store_sk and ss_customer_sk = sr_customer_sk and ss_item_sk = sr_item_sk and ss_ticket_number = sr_ticket_number and sr_returned_date_sk = d2.d_date_sk and d2.d_quarter_name in ('2001Q1','2001Q2','2001Q3') and sr_customer_sk = cs_bill_customer_sk and sr_item_sk = cs_item_sk and cs_sold_date_sk = d3.d_date_sk and d3.d_quarter_name in ('2001Q1','2001Q2','2001Q3') group by i_item_id ,i_item_desc ,s_state order by i_item_id ,i_item_desc ,s_state limit 100; |tpcds_1000| Jun 6 00:23:52 um1 ExeMgr[20561]: 52.023056 |95|0|0| D 16 CAL0042: End SQL statement Jun 6 00:23:53 um1 ExeMgr[20561]: 53.479736 |2147483746|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='date_dim' --columnRIDs/FE; || Jun 6 00:23:53 um1 ExeMgr[20561]: 53.590673 |2147483746|0|0| D 16 CAL0042: End SQL statement Jun 6 00:23:53 um1 ExeMgr[20561]: 53.592450 |2147483746|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store_sales' --columnRIDs/FE; || Jun 6 00:23:53 um1 ExeMgr[20561]: 53.622444 |2147483746|0|0| D 16 CAL0042: End SQL statement Jun 6 00:23:53 um1 ExeMgr[20561]: 53.623880 |2147483746|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='item' --columnRIDs/FE; || Jun 6 00:23:53 um1 ExeMgr[20561]: 53.652998 |2147483746|0|0| D 16 CAL0042: End SQL statement Jun 6 00:23:53 um1 ExeMgr[20561]: 53.654366 |2147483746|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='customer' --columnRIDs/FE; || Jun 6 00:23:53 um1 ExeMgr[20561]: 53.680770 |2147483746|0|0| D 16 CAL0042: End SQL statement Jun 6 00:23:53 um1 ExeMgr[20561]: 53.682111 |2147483746|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='customer_address' --columnRIDs/FE; || Jun 6 00:23:53 um1 ExeMgr[20561]: 53.705566 |2147483746|0|0| D 16 CAL0042: End SQL statement Jun 6 00:23:53 um1 ExeMgr[20561]: 53.707131 |2147483746|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store' --columnRIDs/FE; || Jun 6 00:23:53 um1 ExeMgr[20561]: 53.735994 |2147483746|0|0| D 16 CAL0042: End SQL statement Jun 6 00:23:53 um1 ExeMgr[20561]: 53.841289 |98|0|0| D 16 CAL0041: Start SQL statement: select i_brand_id brand_id, i_brand brand, i_manufact_id, i_manufact, sum(ss_ext_sales_price) ext_price from date_dim, store_sales, item,customer,customer_address,store where d_date_sk = ss_sold_date_sk and ss_item_sk = i_item_sk and i_manager_id=8 and d_moy=11 and d_year=1998 and ss_customer_sk = c_customer_sk and c_current_addr_sk = ca_address_sk and substr(ca_zip,1,5) <> substr(s_zip,1,5) and ss_store_sk = s_store_sk group by i_brand ,i_brand_id ,i_manufact_id ,i_manufact order by ext_price desc ,i_brand ,i_brand_id ,i_manufact_id ,i_manufact limit 100; |tpcds_1000| Jun 6 00:24:02 um1 joblist[20561]: 02.730095 |0|0|0| I 05 CAL0000: IDB-2001: Join or subselect exceeds memory limit. Jun 6 00:24:02 um1 ExeMgr[20561]: 02.748024 |98|0|0| D 16 CAL0042: End SQL statement Jun 6 00:24:02 um1 ExeMgr[20561]: 02.807074 |2147483749|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='catalog_sales' --columnRIDs/FE; || Jun 6 00:24:02 um1 ExeMgr[20561]: 02.919374 |2147483749|0|0| D 16 CAL0042: End SQL statement Jun 6 00:24:02 um1 ExeMgr[20561]: 02.921927 |2147483749|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='item' --columnRIDs/FE; || Jun 6 00:24:02 um1 ExeMgr[20561]: 02.954424 |2147483749|0|0| D 16 CAL0042: End SQL statement Jun 6 00:24:02 um1 ExeMgr[20561]: 02.956106 |2147483749|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='date_dim' --columnRIDs/FE; || Jun 6 00:24:02 um1 ExeMgr[20561]: 02.987165 |2147483749|0|0| D 16 CAL0042: End SQL statement Jun 6 00:24:03 um1 ExeMgr[20561]: 03.121995 |101|0|0| D 16 CAL0041: Start SQL statement: select i_item_id ,i_item_desc ,i_category ,i_class ,i_current_price ,sum(cs_ext_sales_price) as itemrevenue ,sum(cs_ext_sales_price)*100/sum(sum(cs_ext_sales_price)) over (partition by i_class) as revenueratio from catalog_sales ,item ,date_dim where cs_item_sk = i_item_sk and i_category in ('Home', 'Sports', 'Books') and cs_sold_date_sk = d_date_sk and d_date between cast('1999-02-22' as date) and ADDDATE(cast('1999-02-22' as date),30) group by i_item_id ,i_item_desc ,i_category ,i_class ,i_current_price order by i_category ,i_class ,i_item_id ,i_item_desc ,revenueratio limit 100; |tpcds_1000| Jun 6 00:24:08 um1 ExeMgr[20561]: 08.694400 |101|0|0| D 16 CAL0042: End SQL statement Jun 6 00:24:08 um1 ExeMgr[20561]: 08.734121 |2147483752|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='inventory' --columnRIDs/FE; || Jun 6 00:24:08 um1 ExeMgr[20561]: 08.844718 |2147483752|0|0| D 16 CAL0042: End SQL statement Jun 6 00:24:08 um1 ExeMgr[20561]: 08.847240 |2147483752|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='warehouse' --columnRIDs/FE; || Jun 6 00:24:08 um1 ExeMgr[20561]: 08.875689 |2147483752|0|0| D 16 CAL0042: End SQL statement Jun 6 00:24:08 um1 ExeMgr[20561]: 08.877404 |2147483752|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='item' --columnRIDs/FE; || Jun 6 00:24:08 um1 ExeMgr[20561]: 08.902907 |2147483752|0|0| D 16 CAL0042: End SQL statement Jun 6 00:24:08 um1 ExeMgr[20561]: 08.904000 |2147483752|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='date_dim' --columnRIDs/FE; || Jun 6 00:24:08 um1 ExeMgr[20561]: 08.930675 |2147483752|0|0| D 16 CAL0042: End SQL statement Jun 6 00:24:09 um1 ExeMgr[20561]: 09.043673 |104|0|0| D 16 CAL0041: Start SQL statement: select * from(select w_warehouse_name ,i_item_id ,sum(case when (cast(d_date as date) < cast('2000-03-11' as date)) then inv_quantity_on_hand else 0 end) as inv_before ,sum(case when (cast(d_date as date) >= cast('2000-03-11' as date)) then inv_quantity_on_hand else 0 end) as inv_after from inventory ,warehouse ,item ,date_dim where i_current_price between 0.99 and 1.49 and i_item_sk = inv_item_sk and inv_warehouse_sk = w_warehouse_sk and inv_date_sk = d_date_sk and d_date between DATE_SUB(cast('2000-03-11' as date),INTERVAL 30 day) and ADDDATE(cast('2000-03-11' as date),30) group by w_warehouse_name, i_item_id) x where (case when inv_before > 0 then inv_after / inv_before else null end) between 2.0/3.0 and 3.0/2.0 order by w_warehouse_name ,i_item_id limit 100; |tpcds_1000| Jun 6 00:24:12 um1 ExeMgr[20561]: 12.561995 |104|0|0| D 16 CAL0042: End SQL statement Jun 6 00:24:12 um1 ExeMgr[20561]: 12.607682 |2147483755|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store_sales' --columnRIDs/FE; || Jun 6 00:24:12 um1 ExeMgr[20561]: 12.710017 |2147483755|0|0| D 16 CAL0042: End SQL statement Jun 6 00:24:12 um1 ExeMgr[20561]: 12.711960 |2147483755|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store_returns' --columnRIDs/FE; || Jun 6 00:24:12 um1 ExeMgr[20561]: 12.743228 |2147483755|0|0| D 16 CAL0042: End SQL statement Jun 6 00:24:12 um1 ExeMgr[20561]: 12.744598 |2147483755|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='catalog_sales' --columnRIDs/FE; || Jun 6 00:24:12 um1 ExeMgr[20561]: 12.771396 |2147483755|0|0| D 16 CAL0042: End SQL statement Jun 6 00:24:12 um1 ExeMgr[20561]: 12.773353 |2147483755|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='date_dim' --columnRIDs/FE; || Jun 6 00:24:12 um1 ExeMgr[20561]: 12.799595 |2147483755|0|0| D 16 CAL0042: End SQL statement Jun 6 00:24:12 um1 ExeMgr[20561]: 12.802788 |2147483755|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='store' --columnRIDs/FE; || Jun 6 00:24:12 um1 ExeMgr[20561]: 12.832229 |2147483755|0|0| D 16 CAL0042: End SQL statement Jun 6 00:24:12 um1 ExeMgr[20561]: 12.834578 |2147483755|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1000' and tablename='item' --columnRIDs/FE; || Jun 6 00:24:12 um1 ExeMgr[20561]: 12.861895 |2147483755|0|0| D 16 CAL0042: End SQL statement Jun 6 00:24:12 um1 ExeMgr[20561]: 12.995726 |107|0|0| D 16 CAL0041: Start SQL statement: select i_item_id ,i_item_desc ,s_store_id ,s_store_name ,sum(ss_net_profit) as store_sales_profit ,sum(sr_net_loss) as store_returns_loss ,sum(cs_net_profit) as catalog_sales_profit from store_sales ,store_returns ,catalog_sales ,date_dim d1 ,date_dim d2 ,date_dim d3 ,store ,item where d1.d_moy = 4 and d1.d_year = 2001 and d1.d_date_sk = ss_sold_date_sk and i_item_sk = ss_item_sk and s_store_sk = ss_store_sk and ss_customer_sk = sr_customer_sk and ss_item_sk = sr_item_sk and ss_ticket_number = sr_ticket_number and sr_returned_date_sk = d2.d_date_sk and d2.d_moy between 4 and 10 and d2.d_year = 2001 and sr_customer_sk = cs_bill_customer_sk and sr_item_sk = cs_item_sk and cs_sold_date_sk = d3.d_date_sk and d3.d_moy between 4 and 10 and d3.d_year = 2001 group by i_item_id ,i_item_desc ,s_store_id ,s_store_name order by i_item_id ,i_item_desc ,s_store_id ,s_store_name limit 100; |tpcds_1000|