Feb 28 12:29:58 um1 ExeMgr[27652]: 58.521240 |218|0|0| D 16 CAL0041: Start SQL statement: select w_state ,i_item_id ,sum(case when (cast(d_date as date) < cast('2000-03-11' 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('2000-03-11' 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('2000-03-11' as date),INTERVAL 30 day) and ADDDATE(cast('2000-03-11' as date),30) group by w_state,i_item_id order by w_state,i_item_id limit 100; |tpcds_1| Feb 28 12:29:58 um1 ExeMgr[27652]: 58.780990 |218|0|0| D 16 CAL0042: End SQL statement Feb 28 12:29:58 um1 ExeMgr[27652]: 58.907389 |2147483870|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1' and tablename='item' --columnRIDs/FE; || Feb 28 12:29:58 um1 ExeMgr[27652]: 58.932540 |2147483870|0|0| D 16 CAL0042: End SQL statement Feb 28 12:29:59 um1 ExeMgr[27652]: 59.006573 |222|0|0| D 16 CAL0041: Start SQL statement: select distinct(i_product_name) from item i1 where i_manufact_id between 742 and 742+40 and (select count(*) as item_cnt from item where (i_manufact = i1.i_manufact and ((i_category = 'Women' and (i_color = 'orchid' or i_color = 'papaya') and (i_units = 'Pound' or i_units = 'Lb') and (i_size = 'petite' or i_size = 'medium') ) or (i_category = 'Women' and (i_color = 'burlywood' or i_color = 'navy') and (i_units = 'Bundle' or i_units = 'Each') and (i_size = 'N/A' or i_size = 'extra large') ) or (i_category = 'Men' and (i_color = 'bisque' or i_color = 'azure') and (i_units = 'N/A' or i_units = 'Tsp') and (i_size = 'small' or i_size = 'large') ) or (i_category = 'Men' and (i_color = 'chocolate' or i_color = 'cornflower') and (i_units = 'Bunch' or i_units = 'Gross') and (i_size = 'petite' or i_size = 'medium') ))) or (i_manufact = i1.i_manufact and ((i_category = 'Women' and (i_color = 'salmon' or i_color = 'midnight') and (i_units = 'Oz' or i_units = 'Box') and (i_size = 'petite' or i_size = 'medium') ) or (i_category = 'Women' and (i_color = 'snow' or i_color = 'steel') and (i_units = 'Carton' or i_units = 'Tbl') and (i_size = 'N/A' or i_size = 'extra large') ) or (i_category = 'Men' and (i_color = 'purple' or i_color = 'gainsboro') and (i_units = 'Dram' or i_units = 'Unknown') and (i_size = 'small' or i_size = 'large') ) or (i_category = 'Men' and (i_color = 'metallic' or i_color = 'forest') and (i_units = 'Gram' or i_units = 'Ounce') and (i_size = 'petite' or i_size = 'medium') )))) > 0 order by i_product_name limit 100; |tpcds_1| Feb 28 12:29:59 um1 joblist[27652]: 59.046022 |222|0|0| D 05 CAL0059: JobListFactory makeJoblist error: IDB-3001: This subquery type is not supported yet. Feb 28 12:29:59 um1 ExeMgr[27652]: 59.046170 |222|0|0| D 16 CAL0042: End SQL statement Feb 28 12:29:59 um1 ExeMgr[27652]: 59.115819 |222|0|0| D 16 CAL0041: Start SQL statement: select distinct(i_product_name) from item i1 where i_manufact_id between 742 and 742+40 and (select count(*) as item_cnt from item where (i_manufact = i1.i_manufact and ((i_category = 'Women' and (i_color = 'orchid' or i_color = 'papaya') and (i_units = 'Pound' or i_units = 'Lb') and (i_size = 'petite' or i_size = 'medium') ) or (i_category = 'Women' and (i_color = 'burlywood' or i_color = 'navy') and (i_units = 'Bundle' or i_units = 'Each') and (i_size = 'N/A' or i_size = 'extra large') ) or (i_category = 'Men' and (i_color = 'bisque' or i_color = 'azure') and (i_units = 'N/A' or i_units = 'Tsp') and (i_size = 'small' or i_size = 'large') ) or (i_category = 'Men' and (i_color = 'chocolate' or i_color = 'cornflower') and (i_units = 'Bunch' or i_units = 'Gross') and (i_size = 'petite' or i_size = 'medium') ))) or (i_manufact = i1.i_manufact and ((i_category = 'Women' and (i_color = 'salmon' or i_color = 'midnight') and (i_units = 'Oz' or i_units = 'Box') and (i_size = 'petite' or i_size = 'medium') ) or (i_category = 'Women' and (i_color = 'snow' or i_color = 'steel') and (i_units = 'Carton' or i_units = 'Tbl') and (i_size = 'N/A' or i_size = 'extra large') ) or (i_category = 'Men' and (i_color = 'purple' or i_color = 'gainsboro') and (i_units = 'Dram' or i_units = 'Unknown') and (i_size = 'small' or i_size = 'large') ) or (i_category = 'Men' and (i_color = 'metallic' or i_color = 'forest') and (i_units = 'Gram' or i_units = 'Ounce') and (i_size = 'petite' or i_size = 'medium') )))) > 0 order by i_product_name limit 100; |tpcds_1| Feb 28 12:29:59 um1 joblist[27652]: 59.156383 |222|0|0| D 05 CAL0059: JobListFactory makeJoblist error: IDB-3001: This subquery type is not supported yet. Feb 28 12:29:59 um1 ExeMgr[27652]: 59.156535 |222|0|0| D 16 CAL0042: End SQL statement Feb 28 12:29:59 um1 ExeMgr[27652]: 59.269440 |2147483874|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1' and tablename='date_dim' --columnRIDs/FE; || Feb 28 12:29:59 um1 ExeMgr[27652]: 59.287975 |2147483874|0|0| D 16 CAL0042: End SQL statement Feb 28 12:29:59 um1 ExeMgr[27652]: 59.289262 |2147483874|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1' and tablename='store_sales' --columnRIDs/FE; || Feb 28 12:29:59 um1 ExeMgr[27652]: 59.306419 |2147483874|0|0| D 16 CAL0042: End SQL statement Feb 28 12:29:59 um1 ExeMgr[27652]: 59.307245 |2147483874|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1' and tablename='item' --columnRIDs/FE; || Feb 28 12:29:59 um1 ExeMgr[27652]: 59.323686 |2147483874|0|0| D 16 CAL0042: End SQL statement Feb 28 12:29:59 um1 ExeMgr[27652]: 59.361613 |226|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=11 and dt.d_year=2000 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_1| Feb 28 12:29:59 um1 ExeMgr[27652]: 59.497480 |226|0|0| D 16 CAL0042: End SQL statement Feb 28 12:29:59 um1 ExeMgr[27652]: 59.629231 |2147483878|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1' and tablename='date_dim' --columnRIDs/FE; || Feb 28 12:29:59 um1 ExeMgr[27652]: 59.652597 |2147483878|0|0| D 16 CAL0042: End SQL statement Feb 28 12:29:59 um1 ExeMgr[27652]: 59.653564 |2147483878|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1' and tablename='store_sales' --columnRIDs/FE; || Feb 28 12:29:59 um1 ExeMgr[27652]: 59.670494 |2147483878|0|0| D 16 CAL0042: End SQL statement Feb 28 12:29:59 um1 ExeMgr[27652]: 59.671278 |2147483878|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1' and tablename='store' --columnRIDs/FE; || Feb 28 12:29:59 um1 ExeMgr[27652]: 59.686332 |2147483878|0|0| D 16 CAL0042: End SQL statement Feb 28 12:29:59 um1 ExeMgr[27652]: 59.742595 |230|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 = 2000 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_1| Feb 28 12:30:00 um1 ExeMgr[27652]: 00.228550 |230|0|0| D 16 CAL0042: End SQL statement Feb 28 12:30:00 um1 ExeMgr[27652]: 00.345007 |2147483882|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1' and tablename='store_sales' --columnRIDs/FE; || Feb 28 12:30:00 um1 ExeMgr[27652]: 00.365419 |2147483882|0|0| D 16 CAL0042: End SQL statement Feb 28 12:30:00 um1 ExeMgr[27652]: 00.375970 |2147483882|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1' and tablename='item' --columnRIDs/FE; || Feb 28 12:30:00 um1 ExeMgr[27652]: 00.390968 |2147483882|0|0| D 16 CAL0042: End SQL statement Feb 28 12:30:00 um1 ExeMgr[27652]: 00.425035 |234|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 = 4 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 = 4 and ss_addr_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 = 4 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 = 4 and ss_addr_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_1| Feb 28 12:30:00 um1 ExeMgr[27652]: 00.804445 |234|0|0| D 16 CAL0042: End SQL statement Feb 28 12:30:00 um1 ExeMgr[27652]: 00.929736 |2147483886|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1' and tablename='web_sales' --columnRIDs/FE; || Feb 28 12:30:00 um1 ExeMgr[27652]: 00.953519 |2147483886|0|0| D 16 CAL0042: End SQL statement Feb 28 12:30:00 um1 ExeMgr[27652]: 00.954634 |2147483886|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1' and tablename='customer' --columnRIDs/FE; || Feb 28 12:30:00 um1 ExeMgr[27652]: 00.971314 |2147483886|0|0| D 16 CAL0042: End SQL statement Feb 28 12:30:00 um1 ExeMgr[27652]: 00.972123 |2147483886|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1' and tablename='customer_address' --columnRIDs/FE; || Feb 28 12:30:00 um1 ExeMgr[27652]: 00.988709 |2147483886|0|0| D 16 CAL0042: End SQL statement Feb 28 12:30:00 um1 ExeMgr[27652]: 00.989871 |2147483886|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1' and tablename='date_dim' --columnRIDs/FE; || Feb 28 12:30:01 um1 ExeMgr[27652]: 01.007645 |2147483886|0|0| D 16 CAL0042: End SQL statement Feb 28 12:30:01 um1 ExeMgr[27652]: 01.008382 |2147483886|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1' and tablename='item' --columnRIDs/FE; || Feb 28 12:30:01 um1 ExeMgr[27652]: 01.024509 |2147483886|0|0| D 16 CAL0042: End SQL statement Feb 28 12:30:01 um1 ExeMgr[27652]: 01.064432 |238|0|0| D 16 CAL0041: Start SQL statement: ; |tpcds_1| Feb 28 12:30:01 um1 ExeMgr[27652]: 01.132164 |238|0|0| D 16 CAL0041: Start SQL statement: ; |tpcds_1| Feb 28 12:30:26 um1 ExeMgr[27652]: 26.582207 |238|0|0| D 16 CAL0041: Start SQL statement: ; |tpcds_1| Feb 28 12:31:04 um1 ExeMgr[27652]: 04.642638 |238|0|0| D 16 CAL0041: Start SQL statement: ; |tpcds_1| Feb 28 12:31:43 um1 ExeMgr[27652]: 43.094446 |238|0|0| D 16 CAL0042: End SQL statement Feb 28 12:31:43 um1 ExeMgr[27652]: 43.096462 |238|0|0| D 16 CAL0041: Start SQL statement: ; |tpcds_1| Feb 28 12:32:25 um1 ExeMgr[27652]: 25.803982 |238|0|0| D 16 CAL0042: End SQL statement Feb 28 12:32:25 um1 ExeMgr[27652]: 25.805532 |238|0|0| D 16 CAL0041: Start SQL statement: ; |tpcds_1| Feb 28 12:33:07 um1 ExeMgr[27652]: 07.669174 |238|0|0| D 16 CAL0042: End SQL statement Feb 28 12:33:07 um1 ExeMgr[27652]: 07.671087 |238|0|0| D 16 CAL0041: Start SQL statement: ; |tpcds_1| Feb 28 12:33:48 um1 ExeMgr[27652]: 48.399513 |238|0|0| D 16 CAL0042: End SQL statement Feb 28 12:33:48 um1 ExeMgr[27652]: 48.400828 |238|0|0| D 16 CAL0041: Start SQL statement: ; |tpcds_1| Feb 28 12:34:29 um1 ExeMgr[27652]: 29.348932 |238|0|0| D 16 CAL0042: End SQL statement Feb 28 12:34:29 um1 ExeMgr[27652]: 29.351026 |238|0|0| D 16 CAL0041: Start SQL statement: ; |tpcds_1| Feb 28 12:35:07 um1 ExeMgr[27652]: 07.119750 |238|0|0| D 16 CAL0042: End SQL statement Feb 28 12:35:07 um1 ExeMgr[27652]: 07.121728 |238|0|0| D 16 CAL0041: Start SQL statement: ; |tpcds_1| Feb 28 12:35:45 um1 ExeMgr[27652]: 45.390551 |238|0|0| D 16 CAL0042: End SQL statement Feb 28 12:35:45 um1 ExeMgr[27652]: 45.391723 |238|0|0| D 16 CAL0041: Start SQL statement: ; |tpcds_1| Feb 28 12:36:24 um1 ExeMgr[27652]: 24.472903 |238|0|0| D 16 CAL0042: End SQL statement Feb 28 12:36:24 um1 ExeMgr[27652]: 24.474256 |238|0|0| D 16 CAL0041: Start SQL statement: ; |tpcds_1| Feb 28 12:37:03 um1 ExeMgr[27652]: 03.158630 |238|0|0| D 16 CAL0042: End SQL statement Feb 28 12:37:03 um1 ExeMgr[27652]: 03.160975 |238|0|0| D 16 CAL0041: Start SQL statement: ; |tpcds_1| Feb 28 12:38:09 um1 ExeMgr[27652]: 09.273483 |238|0|0| D 16 CAL0042: End SQL statement Feb 28 12:38:09 um1 ExeMgr[27652]: 09.275015 |238|0|0| D 16 CAL0041: Start SQL statement: ; |tpcds_1| Feb 28 12:38:10 um1 ExeMgr[27652]: 10.225590 |238|0|0| D 16 CAL0042: End SQL statement Feb 28 12:38:10 um1 ExeMgr[27652]: 10.226952 |238|0|0| D 16 CAL0041: Start SQL statement: ; |tpcds_1| Feb 28 12:38:52 um1 ExeMgr[27652]: 52.303348 |238|0|0| D 16 CAL0042: End SQL statement Feb 28 12:38:52 um1 ExeMgr[27652]: 52.305049 |238|0|0| D 16 CAL0041: Start SQL statement: ; |tpcds_1| Feb 28 12:39:04 um1 ExeMgr[27652]: 04.162129 |238|0|0| D 16 CAL0042: End SQL statement Feb 28 12:39:04 um1 ExeMgr[27652]: 04.163274 |238|0|0| D 16 CAL0042: End SQL statement Feb 28 12:39:04 um1 ExeMgr[27652]: 04.163343 |238|0|0| C 16 CAL0055: ERROR: ExeMgr has caught an exception. ExeMgr: error projecting rows for tableOID: 100; rowCnt: 8192; prevTotRowCnt: 662040; InetStreamSocket::write error: Broken pipe -- write from InetStreamSocket: sd: 56 inet: 172.20.2.206 port: 33034 Feb 28 12:39:04 um1 ExeMgr[27652]: 04.163698 |238|0|0| D 16 CAL0042: End SQL statement Feb 28 12:39:04 um1 ExeMgr[27652]: 04.163887 |238|0|0| D 16 CAL0042: End SQL statement Feb 28 12:39:04 um1 ExeMgr[27652]: 04.322129 |2147483890|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1' and tablename='store_sales' --columnRIDs/FE; || Feb 28 12:39:04 um1 ExeMgr[27652]: 04.346789 |2147483890|0|0| D 16 CAL0042: End SQL statement Feb 28 12:39:04 um1 ExeMgr[27652]: 04.348502 |2147483890|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1' and tablename='date_dim' --columnRIDs/FE; || Feb 28 12:39:04 um1 ExeMgr[27652]: 04.368564 |2147483890|0|0| D 16 CAL0042: End SQL statement Feb 28 12:39:04 um1 ExeMgr[27652]: 04.369840 |2147483890|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1' and tablename='store' --columnRIDs/FE; || Feb 28 12:39:04 um1 ExeMgr[27652]: 04.394777 |2147483890|0|0| D 16 CAL0042: End SQL statement Feb 28 12:39:04 um1 ExeMgr[27652]: 04.395543 |2147483890|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1' and tablename='household_demographics' --columnRIDs/FE; || Feb 28 12:39:04 um1 ExeMgr[27652]: 04.415772 |2147483890|0|0| D 16 CAL0042: End SQL statement Feb 28 12:39:04 um1 ExeMgr[27652]: 04.417217 |2147483890|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1' and tablename='customer_address' --columnRIDs/FE; || Feb 28 12:39:04 um1 ExeMgr[27652]: 04.437804 |2147483890|0|0| D 16 CAL0042: End SQL statement Feb 28 12:39:04 um1 ExeMgr[27652]: 04.452764 |2147483890|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1' and tablename='customer' --columnRIDs/FE; || Feb 28 12:39:04 um1 ExeMgr[27652]: 04.474706 |2147483890|0|0| D 16 CAL0042: End SQL statement Feb 28 12:39:04 um1 ExeMgr[27652]: 04.532700 |242|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 = 4 or household_demographics.hd_vehicle_count= 3) and date_dim.d_dow in (6,0) and date_dim.d_year in (1999,1999+1,1999+2) and store.s_city in ('Midway','Fairview','Fairview','Midway','Fairview') 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_1| Feb 28 12:39:05 um1 ExeMgr[27652]: 05.040023 |242|0|0| D 16 CAL0042: End SQL statement Feb 28 12:39:05 um1 ExeMgr[27652]: 05.181975 |2147483894|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1' and tablename='item' --columnRIDs/FE; || Feb 28 12:39:05 um1 ExeMgr[27652]: 05.202561 |2147483894|0|0| D 16 CAL0042: End SQL statement Feb 28 12:39:05 um1 ExeMgr[27652]: 05.203655 |2147483894|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1' and tablename='store_sales' --columnRIDs/FE; || Feb 28 12:39:05 um1 ExeMgr[27652]: 05.225093 |2147483894|0|0| D 16 CAL0042: End SQL statement Feb 28 12:39:05 um1 ExeMgr[27652]: 05.226867 |2147483894|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1' and tablename='date_dim' --columnRIDs/FE; || Feb 28 12:39:05 um1 ExeMgr[27652]: 05.246283 |2147483894|0|0| D 16 CAL0042: End SQL statement Feb 28 12:39:05 um1 ExeMgr[27652]: 05.248701 |2147483894|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1' and tablename='store' --columnRIDs/FE; || Feb 28 12:39:05 um1 ExeMgr[27652]: 05.266144 |2147483894|0|0| D 16 CAL0042: End SQL statement Feb 28 12:39:05 um1 ExeMgr[27652]: 05.372625 |246|0|0| D 16 CAL0041: Start SQL statement: with v1 as( select i_category, i_brand, s_store_name, s_company_name, d_year, d_moy, sum(ss_sales_price) sum_sales, avg(sum(ss_sales_price)) over (partition by i_category, i_brand, s_store_name, s_company_name, d_year) avg_monthly_sales, rank() over (partition by i_category, i_brand, s_store_name, s_company_name order by d_year, d_moy) rn 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_year = 1999 or ( d_year = 1999-1 and d_moy =12) or ( d_year = 1999+1 and d_moy =1) ) group by i_category, i_brand, s_store_name, s_company_name, d_year, d_moy), v2 as( select v1.i_category, v1.i_brand, v1.s_store_name, v1.s_company_name ,v1.d_year, v1.d_moy ,v1.avg_monthly_sales ,v1.sum_sales, v1_lag.sum_sales psum, v1_lead.sum_sales nsum from v1, v1 v1_lag, v1 v1_lead where v1.i_category = v1_lag.i_category and v1.i_category = v1_lead.i_category and v1.i_brand = v1_lag.i_brand and v1.i_brand = v1_lead.i_brand and v1.s_store_name = v1_lag.s_store_name and v1.s_store_name = v1_lead.s_store_name and v1.s_company_name = v1_lag.s_company_name and v1.s_company_name = v1_lead.s_company_name and v1.rn = v1_lag.rn + 1 and v1.rn = v1_lead.rn - 1) select * from v2 where d_year = 1999 and avg_monthly_sales > 0 and case when avg_monthly_sales > 0 then abs(sum_sales - avg_monthly_sales) / avg_monthly_sales else null end > 0.1 order by sum_sales - avg_monthly_sales, 3 limit 100; |tpcds_1| Feb 28 12:39:05 um1 ExeMgr[27652]: 05.495231 |246|0|0| D 16 CAL0041: Start SQL statement: ; |tpcds_1| Feb 28 12:39:05 um1 ExeMgr[27652]: 05.594859 |246|0|0| D 16 CAL0041: Start SQL statement: ; |tpcds_1| Feb 28 12:39:14 um1 ExeMgr[27652]: 14.377494 |246|0|0| D 16 CAL0041: Start SQL statement: ; |tpcds_1| Feb 28 12:39:22 um1 ExeMgr[27652]: 22.025412 |246|0|0| D 16 CAL0042: End SQL statement Feb 28 12:39:22 um1 ExeMgr[27652]: 22.027075 |246|0|0| D 16 CAL0041: Start SQL statement: ; |tpcds_1| Feb 28 12:39:29 um1 ExeMgr[27652]: 29.693521 |246|0|0| D 16 CAL0042: End SQL statement Feb 28 12:39:29 um1 ExeMgr[27652]: 29.695010 |246|0|0| D 16 CAL0041: Start SQL statement: ; |tpcds_1| Feb 28 12:39:37 um1 ExeMgr[27652]: 37.187047 |246|0|0| D 16 CAL0042: End SQL statement Feb 28 12:39:37 um1 ExeMgr[27652]: 37.188675 |246|0|0| D 16 CAL0041: Start SQL statement: ; |tpcds_1| Feb 28 12:39:37 um1 ExeMgr[27652]: 37.277937 |246|0|0| D 16 CAL0041: Start SQL statement: ; |tpcds_1| Feb 28 13:42:26 um1 ExeMgr[27652]: 26.218646 |2147483902|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1' and tablename='store_sales' --columnRIDs/FE; || Feb 28 14:22:45 um1 ExeMgr[27652]: 45.150751 |2147483907|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1' and tablename='web_sales' --columnRIDs/FE; || Feb 28 14:33:40 um1 ExeMgr[27652]: 40.663465 |2147483911|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1' and tablename='store_sales' --columnRIDs/FE; || Feb 28 14:35:25 um1 ExeMgr[27652]: 25.647983 |2147483917|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1' and tablename='call_center' --columnRIDs/FE; || Feb 28 14:39:42 um1 ExeMgr[27652]: 42.876537 |2147483926|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1' and tablename='date_dim' --columnRIDs/FE; || Feb 28 14:41:15 um1 ExeMgr[27652]: 15.221301 |2147483932|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1' and tablename='call_center' --columnRIDs/FE; || Feb 28 14:42:15 um1 ExeMgr[27652]: 15.905129 |2147483918|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1' and tablename='call_center' --columnRIDs/FE; || Feb 28 14:43:36 um1 ExeMgr[27652]: 36.891808 |2147483937|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1' and tablename='item' --columnRIDs/FE; || Feb 28 14:54:33 um1 ExeMgr[27652]: 33.615940 |2147483941|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='tpcds_1' and tablename='item' --columnRIDs/FE; || Feb 28 14:55:23 um1 ExeMgr[27652]: 23.442233 |2147483944|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='foo1_1' and tablename='item' --columnRIDs/FE; || [root@um1 mariadb]#