/backends /catalog /hadoop-varz /log_level /logs /memz /metrics /queries /rpcz /sessions /threadz /varz Queries This page lists all running queries, plus any completed queries that are archived in memory. The size of that archive is controlled with the --query_log_size command line parameter. 0 queries in flight User Default Db Statement Query Type Start Time Duration Scan Progress State Last Event # rows fetched Resource Pool Details Action 0 waiting to be closed [?] User Default Db Statement Query Type Start Time Waiting Time Duration Scan Progress State Last Event # rows fetched Resource Pool Details Action Last 250 Completed Queries User Default Db Statement Query Type Start Time End Time Duration Scan Progress State # rows fetched Resource Pool Details table_level_tests insert into store_sales partition(ss_sold_date_sk=107) select * from store_sales_source DML 2017-03-29 17:13:16.983279000 2017-03-29 17:13:27.011039000 10s027ms 1 / 1 ( 100%) EXCEPTION 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(52) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:13.784244000 2017-03-29 17:13:26.984297000 13s200ms 1 / 1 ( 100%) EXCEPTION 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(51) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:13.589457000 2017-03-29 17:13:26.913866000 13s324ms 1 / 1 ( 100%) EXCEPTION 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(55) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:14.322670000 2017-03-29 17:13:26.794355000 12s471ms 1 / 1 ( 100%) EXCEPTION 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(57) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:14.597906000 2017-03-29 17:13:26.597909000 12s000ms 1 / 1 ( 100%) EXCEPTION 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(54) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:14.562243000 2017-03-29 17:13:26.546658000 11s984ms 1 / 1 ( 100%) EXCEPTION 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(56) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:14.480362000 2017-03-29 17:13:26.514538000 12s034ms 1 / 1 ( 100%) EXCEPTION 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(58) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:14.667649000 2017-03-29 17:13:26.463341000 11s795ms 1 / 1 ( 100%) EXCEPTION 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=111) select * from store_sales_source DML 2017-03-29 17:13:17.435527000 2017-03-29 17:13:26.439110000 9s003ms 1 / 1 ( 100%) EXCEPTION 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=110) select * from store_sales_source DML 2017-03-29 17:13:17.397203000 2017-03-29 17:13:26.375751000 8s978ms 1 / 1 ( 100%) EXCEPTION 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=108) select * from store_sales_source DML 2017-03-29 17:13:17.336649000 2017-03-29 17:13:26.347639000 9s010ms 1 / 1 ( 100%) EXCEPTION 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(59) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:14.842094000 2017-03-29 17:13:26.319096000 11s477ms 1 / 1 ( 100%) EXCEPTION 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=109) select * from store_sales_source DML 2017-03-29 17:13:17.361918000 2017-03-29 17:13:26.236588000 8s874ms 1 / 1 ( 100%) EXCEPTION 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(62) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:16.416849000 2017-03-29 17:13:26.041293000 9s624ms 1 / 1 ( 100%) EXCEPTION 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(64) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:17.439761000 2017-03-29 17:13:26.019477000 8s579ms 1 / 1 ( 100%) EXCEPTION 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(63) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:16.791374000 2017-03-29 17:13:25.997394000 9s206ms 1 / 1 ( 100%) EXCEPTION 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(61) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:16.316126000 2017-03-29 17:13:25.968168000 9s652ms 1 / 1 ( 100%) EXCEPTION 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(60) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:15.588116000 2017-03-29 17:13:25.938885000 10s350ms 1 / 1 ( 100%) EXCEPTION 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(65) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:17.536045000 2017-03-29 17:13:25.909895000 8s373ms 1 / 1 ( 100%) EXCEPTION 0 root.default Details default drop database if exists TESTDB CASCADE DDL 2017-03-29 17:13:22.789075000 2017-03-29 17:13:25.541163000 2s752ms N/A FINISHED 0 Details table_level_tests show tables DDL 2017-03-29 17:13:22.736470000 2017-03-29 17:13:22.763166000 26ms N/A FINISHED 2 Details table_level_tests show tables DDL 2017-03-29 17:13:22.696031000 2017-03-29 17:13:22.713296000 17ms N/A FINISHED 0 Details table_level_tests invalidate metadata store_sales DDL 2017-03-29 17:13:22.508671000 2017-03-29 17:13:22.619443000 110ms N/A FINISHED 0 Details table_level_tests invalidate metadata store_sales DDL 2017-03-29 17:13:22.505926000 2017-03-29 17:13:22.619143000 113ms N/A FINISHED 0 Details table_level_tests invalidate metadata store_sales DDL 2017-03-29 17:13:22.508239000 2017-03-29 17:13:22.618887000 110ms N/A FINISHED 0 Details table_level_tests invalidate metadata store_sales DDL 2017-03-29 17:13:22.504163000 2017-03-29 17:13:22.618567000 114ms N/A FINISHED 0 Details table_level_tests invalidate metadata store_sales DDL 2017-03-29 17:13:22.495606000 2017-03-29 17:13:22.615576000 119ms N/A FINISHED 0 Details table_level_tests invalidate metadata store_sales DDL 2017-03-29 17:13:22.483744000 2017-03-29 17:13:22.615244000 131ms N/A FINISHED 0 Details table_level_tests invalidate metadata store_sales DDL 2017-03-29 17:13:22.469609000 2017-03-29 17:13:22.613104000 143ms N/A FINISHED 0 Details table_level_tests invalidate metadata store_sales DDL 2017-03-29 17:13:22.413076000 2017-03-29 17:13:22.436296000 23ms N/A FINISHED 0 Details table_level_tests ALTER TABLE store_sales RECOVER PARTITIONS DDL 2017-03-29 17:13:22.274669000 2017-03-29 17:13:22.305924000 31ms N/A EXCEPTION 0 Details table_level_tests refresh store_sales DDL 2017-03-29 17:13:22.268953000 2017-03-29 17:13:22.301752000 32ms N/A EXCEPTION 0 Details table_level_tests refresh store_sales DDL 2017-03-29 17:13:22.269420000 2017-03-29 17:13:22.297001000 27ms N/A EXCEPTION 0 Details table_level_tests refresh store_sales DDL 2017-03-29 17:13:22.267726000 2017-03-29 17:13:22.295525000 27ms N/A EXCEPTION 0 Details table_level_tests refresh store_sales DDL 2017-03-29 17:13:22.268296000 2017-03-29 17:13:22.294755000 26ms N/A EXCEPTION 0 Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:17.762504000 2017-03-29 17:13:18.611447000 848ms 1726 / 1726 ( 100%) FINISHED 1 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:17.762501000 2017-03-29 17:13:18.609752000 847ms 1726 / 1726 ( 100%) FINISHED 1 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:17.158649000 2017-03-29 17:13:18.575024000 1s416ms 1586 / 1586 ( 100%) FINISHED 1 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:17.167338000 2017-03-29 17:13:18.570408000 1s403ms 1586 / 1586 ( 100%) FINISHED 1 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:17.167364000 2017-03-29 17:13:18.536656000 1s369ms 1586 / 1586 ( 100%) FINISHED 1 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=88) select * from store_sales_source DML 2017-03-29 17:13:13.670828000 2017-03-29 17:13:18.535365000 4s864ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:17.129492000 2017-03-29 17:13:18.519464000 1s389ms 1586 / 1586 ( 100%) FINISHED 1 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:17.132993000 2017-03-29 17:13:18.522304000 1s389ms 1586 / 1586 ( 100%) FINISHED 1 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=98) select * from store_sales_source DML 2017-03-29 17:13:14.582113000 2017-03-29 17:13:18.521836000 3s939ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests ALTER TABLE store_sales RECOVER PARTITIONS DDL 2017-03-29 17:13:18.478439000 2017-03-29 17:13:18.515998000 37ms N/A EXCEPTION 0 Details table_level_tests insert into store_sales partition(ss_sold_date_sk=78) select * from store_sales_source DML 2017-03-29 17:13:13.130407000 2017-03-29 17:13:18.497658000 5s367ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=99) select * from store_sales_source DML 2017-03-29 17:13:14.749654000 2017-03-29 17:13:18.473653000 3s723ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(45) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:12.689269000 2017-03-29 17:13:18.450467000 5s761ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=85) select * from store_sales_source DML 2017-03-29 17:13:13.506580000 2017-03-29 17:13:18.362102000 4s855ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests ALTER TABLE store_sales RECOVER PARTITIONS DDL 2017-03-29 17:13:12.341062000 2017-03-29 17:13:18.351549000 6s010ms N/A FINISHED 0 Details table_level_tests ALTER TABLE store_sales RECOVER PARTITIONS DDL 2017-03-29 17:13:18.281950000 2017-03-29 17:13:18.300057000 18ms N/A EXCEPTION 0 Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(50) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:13.367905000 2017-03-29 17:13:18.187582000 4s819ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests ALTER TABLE store_sales RECOVER PARTITIONS DDL 2017-03-29 17:13:18.118514000 2017-03-29 17:13:18.137175000 18ms N/A EXCEPTION 0 Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(49) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:13.190351000 2017-03-29 17:13:18.100723000 4s910ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=102) select * from store_sales_source DML 2017-03-29 17:13:15.550566000 2017-03-29 17:13:17.998652000 2s448ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=106) select * from store_sales_source DML 2017-03-29 17:13:16.635854000 2017-03-29 17:13:17.995706000 1s359ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(53) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:13.988812000 2017-03-29 17:13:17.982502000 3s993ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests ALTER TABLE store_sales RECOVER PARTITIONS DDL 2017-03-29 17:13:17.941557000 2017-03-29 17:13:17.968217000 26ms N/A EXCEPTION 0 Details table_level_tests ALTER TABLE store_sales RECOVER PARTITIONS DDL 2017-03-29 17:13:17.926148000 2017-03-29 17:13:17.953356000 27ms N/A EXCEPTION 0 Details table_level_tests ALTER TABLE store_sales RECOVER PARTITIONS DDL 2017-03-29 17:13:17.924538000 2017-03-29 17:13:17.952479000 27ms N/A EXCEPTION 0 Details table_level_tests insert into store_sales partition(ss_sold_date_sk=82) select * from store_sales_source DML 2017-03-29 17:13:13.304171000 2017-03-29 17:13:17.862489000 4s558ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(40) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:10.443278000 2017-03-29 17:13:17.835649000 7s392ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:17.571625000 2017-03-29 17:13:17.731895000 160ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:17.543041000 2017-03-29 17:13:17.730859000 187ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=80) select * from store_sales_source DML 2017-03-29 17:13:13.262947000 2017-03-29 17:13:17.725783000 4s462ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=83) select * from store_sales_source DML 2017-03-29 17:13:13.429317000 2017-03-29 17:13:17.714007000 4s284ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=86) select * from store_sales_source DML 2017-03-29 17:13:13.513021000 2017-03-29 17:13:17.699055000 4s186ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=93) select * from store_sales_source DML 2017-03-29 17:13:14.135518000 2017-03-29 17:13:17.679976000 3s544ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:17.040402000 2017-03-29 17:13:17.652322000 611ms 1586 / 1586 ( 100%) FINISHED 1 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(47) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:12.819179000 2017-03-29 17:13:17.601939000 4s782ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=84) select * from store_sales_source DML 2017-03-29 17:13:13.506358000 2017-03-29 17:13:17.650201000 4s143ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=105) select * from store_sales_source DML 2017-03-29 17:13:16.213641000 2017-03-29 17:13:17.638720000 1s425ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=94) select * from store_sales_source DML 2017-03-29 17:13:14.141844000 2017-03-29 17:13:17.658387000 3s516ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(46) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:12.796100000 2017-03-29 17:13:17.489948000 4s693ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests invalidate metadata store_sales DDL 2017-03-29 17:13:17.305775000 2017-03-29 17:13:17.434291000 128ms N/A FINISHED 0 Details table_level_tests invalidate metadata store_sales DDL 2017-03-29 17:13:17.276700000 2017-03-29 17:13:17.434939000 158ms N/A FINISHED 0 Details table_level_tests invalidate metadata store_sales DDL 2017-03-29 17:13:17.339082000 2017-03-29 17:13:17.433739000 94ms N/A FINISHED 0 Details table_level_tests invalidate metadata store_sales DDL 2017-03-29 17:13:17.337407000 2017-03-29 17:13:17.428844000 91ms N/A FINISHED 0 Details table_level_tests invalidate metadata store_sales DDL 2017-03-29 17:13:17.328190000 2017-03-29 17:13:17.423523000 95ms N/A FINISHED 0 Details table_level_tests invalidate metadata store_sales DDL 2017-03-29 17:13:17.320887000 2017-03-29 17:13:17.421629000 100ms N/A FINISHED 0 Details table_level_tests invalidate metadata store_sales DDL 2017-03-29 17:13:17.285056000 2017-03-29 17:13:17.410176000 125ms N/A FINISHED 0 Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(48) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:12.984908000 2017-03-29 17:13:17.391739000 4s406ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=77) select * from store_sales_source DML 2017-03-29 17:13:13.129914000 2017-03-29 17:13:17.392776000 4s262ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests invalidate metadata store_sales DDL 2017-03-29 17:13:17.250539000 2017-03-29 17:13:17.384264000 133ms N/A FINISHED 0 Details table_level_tests insert into store_sales partition(ss_sold_date_sk=100) select * from store_sales_source DML 2017-03-29 17:13:14.981570000 2017-03-29 17:13:17.317298000 2s335ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=104) select * from store_sales_source DML 2017-03-29 17:13:16.019569000 2017-03-29 17:13:17.259539000 1s239ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=92) select * from store_sales_source DML 2017-03-29 17:13:14.013660000 2017-03-29 17:13:17.227041000 3s213ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests ALTER TABLE store_sales RECOVER PARTITIONS DDL 2017-03-29 17:13:12.347118000 2017-03-29 17:13:17.219819000 4s872ms N/A FINISHED 0 Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:17.078493000 2017-03-29 17:13:17.133319000 54ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:17.074195000 2017-03-29 17:13:17.131580000 57ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:17.053272000 2017-03-29 17:13:17.124422000 71ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:17.045333000 2017-03-29 17:13:17.105661000 60ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:17.041026000 2017-03-29 17:13:17.100586000 59ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:16.960023000 2017-03-29 17:13:16.994974000 34ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=103) select * from store_sales_source DML 2017-03-29 17:13:15.766450000 2017-03-29 17:13:16.949892000 1s183ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(43) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:11.808213000 2017-03-29 17:13:16.763771000 4s955ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=95) select * from store_sales_source DML 2017-03-29 17:13:14.149301000 2017-03-29 17:13:16.603742000 2s454ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:15.962516000 2017-03-29 17:13:16.538101000 575ms 1374 / 1374 ( 100%) FINISHED 1 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:15.945134000 2017-03-29 17:13:16.500116000 554ms 1374 / 1374 ( 100%) FINISHED 1 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(39) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:10.182880000 2017-03-29 17:13:16.376319000 6s193ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(44) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:12.368570000 2017-03-29 17:13:16.282064000 3s913ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=90) select * from store_sales_source DML 2017-03-29 17:13:13.797379000 2017-03-29 17:13:16.174707000 2s377ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:15.093694000 2017-03-29 17:13:16.018217000 924ms 1310 / 1310 ( 100%) FINISHED 1 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:15.083180000 2017-03-29 17:13:16.017878000 934ms 1310 / 1310 ( 100%) FINISHED 1 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:14.937014000 2017-03-29 17:13:16.008116000 1s071ms 1310 / 1310 ( 100%) FINISHED 1 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:14.934076000 2017-03-29 17:13:15.976563000 1s042ms 1310 / 1310 ( 100%) FINISHED 1 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:14.934352000 2017-03-29 17:13:15.974207000 1s039ms 1310 / 1310 ( 100%) FINISHED 1 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=101) select * from store_sales_source DML 2017-03-29 17:13:15.209516000 2017-03-29 17:13:15.962231000 752ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:15.880618000 2017-03-29 17:13:15.929319000 48ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:14.935034000 2017-03-29 17:13:15.915493000 980ms 1310 / 1310 ( 100%) FINISHED 1 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:15.868861000 2017-03-29 17:13:15.913189000 44ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=97) select * from store_sales_source DML 2017-03-29 17:13:14.528271000 2017-03-29 17:13:15.731309000 1s203ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(42) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:11.023116000 2017-03-29 17:13:15.554029000 4s530ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=96) select * from store_sales_source DML 2017-03-29 17:13:14.321490000 2017-03-29 17:13:15.514889000 1s193ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=91) select * from store_sales_source DML 2017-03-29 17:13:13.911324000 2017-03-29 17:13:15.180994000 1s269ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:15.023789000 2017-03-29 17:13:15.064856000 41ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:14.955004000 2017-03-29 17:13:15.058807000 103ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=87) select * from store_sales_source DML 2017-03-29 17:13:13.526606000 2017-03-29 17:13:14.944540000 1s417ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:14.840393000 2017-03-29 17:13:14.895551000 55ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:14.840690000 2017-03-29 17:13:14.888843000 48ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:14.831663000 2017-03-29 17:13:14.880829000 49ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:14.821157000 2017-03-29 17:13:14.878204000 57ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:14.287134000 2017-03-29 17:13:14.820681000 533ms 1307 / 1307 ( 100%) FINISHED 1 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:14.267663000 2017-03-29 17:13:14.811258000 543ms 1307 / 1307 ( 100%) FINISHED 1 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(24) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:04.783261000 2017-03-29 17:13:14.784301000 10s001ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=89) select * from store_sales_source DML 2017-03-29 17:13:13.744017000 2017-03-29 17:13:14.721284000 977ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(35) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:08.150962000 2017-03-29 17:13:14.638374000 6s487ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(27) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:04.981901000 2017-03-29 17:13:14.561290000 9s579ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=79) select * from store_sales_source DML 2017-03-29 17:13:13.133861000 2017-03-29 17:13:14.554827000 1s420ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=58) select * from store_sales_source DML 2017-03-29 17:13:08.510769000 2017-03-29 17:13:14.490777000 5s980ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(20) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:12:56.656756000 2017-03-29 17:13:14.434153000 17s777ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(41) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:10.504326000 2017-03-29 17:13:14.290271000 3s785ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=75) select * from store_sales_source DML 2017-03-29 17:13:12.980506000 2017-03-29 17:13:14.281000000 1s300ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:14.215325000 2017-03-29 17:13:14.255408000 40ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(18) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:12:56.605117000 2017-03-29 17:13:14.248444000 17s643ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:14.212732000 2017-03-29 17:13:14.244134000 31ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=81) select * from store_sales_source DML 2017-03-29 17:13:13.289188000 2017-03-29 17:13:14.121499000 832ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=26) select * from store_sales_source DML 2017-03-29 17:13:01.644655000 2017-03-29 17:13:14.108233000 12s463ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=11) select * from store_sales_source DML 2017-03-29 17:12:56.897713000 2017-03-29 17:13:14.101273000 17s203ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=63) select * from store_sales_source DML 2017-03-29 17:13:09.795191000 2017-03-29 17:13:13.967605000 4s172ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(30) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:05.391412000 2017-03-29 17:13:13.954943000 8s563ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:13.505171000 2017-03-29 17:13:13.916564000 411ms 1244 / 1244 ( 100%) FINISHED 1 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=49) select * from store_sales_source DML 2017-03-29 17:13:06.390630000 2017-03-29 17:13:13.878907000 7s488ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:12.797708000 2017-03-29 17:13:13.765118000 967ms 1198 / 1198 ( 100%) FINISHED 1 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:12.804652000 2017-03-29 17:13:13.763466000 958ms 1198 / 1198 ( 100%) FINISHED 1 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=8) select * from store_sales_source DML 2017-03-29 17:12:56.828262000 2017-03-29 17:13:13.765849000 16s937ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:12.795813000 2017-03-29 17:13:13.752946000 957ms 1198 / 1198 ( 100%) FINISHED 1 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:12.812692000 2017-03-29 17:13:13.749952000 937ms 1198 / 1198 ( 100%) FINISHED 1 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(36) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:08.219352000 2017-03-29 17:13:13.753901000 5s534ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:12.814375000 2017-03-29 17:13:13.746925000 932ms 1198 / 1198 ( 100%) FINISHED 1 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=76) select * from store_sales_source DML 2017-03-29 17:13:12.985109000 2017-03-29 17:13:13.680896000 695ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=66) select * from store_sales_source DML 2017-03-29 17:13:10.744411000 2017-03-29 17:13:13.642670000 2s898ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(32) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:05.498004000 2017-03-29 17:13:13.552284000 8s054ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=57) select * from store_sales_source DML 2017-03-29 17:13:08.052901000 2017-03-29 17:13:13.489155000 5s436ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=18) select * from store_sales_source DML 2017-03-29 17:12:57.047250000 2017-03-29 17:13:13.481028000 16s433ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=60) select * from store_sales_source DML 2017-03-29 17:13:09.039557000 2017-03-29 17:13:13.444039000 4s404ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:13.386637000 2017-03-29 17:13:13.438484000 51ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=74) select * from store_sales_source DML 2017-03-29 17:13:12.796921000 2017-03-29 17:13:13.437610000 640ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests ALTER TABLE store_sales RECOVER PARTITIONS DDL 2017-03-29 17:13:12.346972000 2017-03-29 17:13:13.437924000 1s090ms N/A FINISHED 0 Details table_level_tests insert into store_sales partition(ss_sold_date_sk=59) select * from store_sales_source DML 2017-03-29 17:13:08.697975000 2017-03-29 17:13:13.403349000 4s705ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(38) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:09.125548000 2017-03-29 17:13:13.338802000 4s213ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=73) select * from store_sales_source DML 2017-03-29 17:13:12.578885000 2017-03-29 17:13:13.275885000 697ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=48) select * from store_sales_source DML 2017-03-29 17:13:06.171994000 2017-03-29 17:13:13.256550000 7s084ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests ALTER TABLE store_sales RECOVER PARTITIONS DDL 2017-03-29 17:13:12.346759000 2017-03-29 17:13:13.251133000 904ms N/A FINISHED 0 Details table_level_tests insert into store_sales partition(ss_sold_date_sk=30) select * from store_sales_source DML 2017-03-29 17:13:02.556367000 2017-03-29 17:13:13.236422000 10s680ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:12.259104000 2017-03-29 17:13:13.167713000 908ms 1198 / 1198 ( 100%) FINISHED 1 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:12.270557000 2017-03-29 17:13:13.165631000 895ms 1198 / 1198 ( 100%) FINISHED 1 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(3) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:12:56.240707000 2017-03-29 17:13:13.155870000 16s915ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=72) select * from store_sales_source DML 2017-03-29 17:13:12.270710000 2017-03-29 17:13:13.099186000 828ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=51) select * from store_sales_source DML 2017-03-29 17:13:06.956698000 2017-03-29 17:13:13.089666000 6s132ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests ALTER TABLE store_sales RECOVER PARTITIONS DDL 2017-03-29 17:13:12.347103000 2017-03-29 17:13:13.088094000 740ms N/A FINISHED 0 Details table_level_tests insert into store_sales partition(ss_sold_date_sk=67) select * from store_sales_source DML 2017-03-29 17:13:10.964876000 2017-03-29 17:13:13.080998000 2s116ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=70) select * from store_sales_source DML 2017-03-29 17:13:11.707105000 2017-03-29 17:13:12.944507000 1s237ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(37) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:08.847306000 2017-03-29 17:13:12.939952000 4s092ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=71) select * from store_sales_source DML 2017-03-29 17:13:12.029660000 2017-03-29 17:13:12.933797000 904ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests ALTER TABLE store_sales RECOVER PARTITIONS DDL 2017-03-29 17:13:12.347109000 2017-03-29 17:13:12.908147000 561ms N/A FINISHED 0 Details table_level_tests ALTER TABLE store_sales RECOVER PARTITIONS DDL 2017-03-29 17:13:12.347127000 2017-03-29 17:13:12.890024000 542ms N/A FINISHED 0 Details table_level_tests ALTER TABLE store_sales RECOVER PARTITIONS DDL 2017-03-29 17:13:12.346296000 2017-03-29 17:13:12.885034000 538ms N/A FINISHED 0 Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(6) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:12:56.311474000 2017-03-29 17:13:12.774428000 16s462ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:12.692504000 2017-03-29 17:13:12.764228000 71ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:12.692196000 2017-03-29 17:13:12.752527000 60ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:12.694245000 2017-03-29 17:13:12.746637000 52ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:12.658566000 2017-03-29 17:13:12.735757000 77ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:12.651358000 2017-03-29 17:13:12.734904000 83ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=10) select * from store_sales_source DML 2017-03-29 17:12:56.876089000 2017-03-29 17:13:12.728674000 15s852ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(31) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:05.428270000 2017-03-29 17:13:12.723698000 7s295ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(23) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:04.730899000 2017-03-29 17:13:12.616438000 7s885ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=68) select * from store_sales_source DML 2017-03-29 17:13:11.259938000 2017-03-29 17:13:12.544147000 1s284ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:11.898142000 2017-03-29 17:13:12.327715000 429ms 1135 / 1135 ( 100%) FINISHED 1 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(10) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:12:56.411765000 2017-03-29 17:13:12.315248000 15s903ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:12.183027000 2017-03-29 17:13:12.233754000 50ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:12.182898000 2017-03-29 17:13:12.229862000 46ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=69) select * from store_sales_source DML 2017-03-29 17:13:11.506159000 2017-03-29 17:13:12.225255000 719ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests invalidate metadata store_sales DDL 2017-03-29 17:13:12.180933000 2017-03-29 17:13:12.226550000 45ms N/A FINISHED 0 Details table_level_tests invalidate metadata store_sales DDL 2017-03-29 17:13:12.181178000 2017-03-29 17:13:12.225803000 44ms N/A FINISHED 0 Details table_level_tests invalidate metadata store_sales DDL 2017-03-29 17:13:12.181364000 2017-03-29 17:13:12.225548000 44ms N/A FINISHED 0 Details table_level_tests invalidate metadata store_sales DDL 2017-03-29 17:13:12.179412000 2017-03-29 17:13:12.222755000 43ms N/A FINISHED 0 Details table_level_tests invalidate metadata store_sales DDL 2017-03-29 17:13:12.177313000 2017-03-29 17:13:12.220802000 43ms N/A FINISHED 0 Details table_level_tests invalidate metadata store_sales DDL 2017-03-29 17:13:12.176563000 2017-03-29 17:13:12.214381000 37ms N/A FINISHED 0 Details table_level_tests invalidate metadata store_sales DDL 2017-03-29 17:13:12.177313000 2017-03-29 17:13:12.214056000 36ms N/A FINISHED 0 Details table_level_tests invalidate metadata store_sales DDL 2017-03-29 17:13:12.171246000 2017-03-29 17:13:12.207473000 36ms N/A FINISHED 0 Details table_level_tests insert into store_sales partition(ss_sold_date_sk=40) select * from store_sales_source DML 2017-03-29 17:13:04.646243000 2017-03-29 17:13:11.993023000 7s346ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:11.825725000 2017-03-29 17:13:11.868499000 42ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(34) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:06.738238000 2017-03-29 17:13:11.767993000 5s029ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=50) select * from store_sales_source DML 2017-03-29 17:13:06.679959000 2017-03-29 17:13:11.673577000 4s993ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:10.678850000 2017-03-29 17:13:11.629341000 950ms 1070 / 1070 ( 100%) FINISHED 1 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:10.728939000 2017-03-29 17:13:11.619736000 890ms 1071 / 1071 ( 100%) FINISHED 1 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:10.756008000 2017-03-29 17:13:11.618144000 862ms 1071 / 1071 ( 100%) FINISHED 1 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:10.678971000 2017-03-29 17:13:11.602552000 923ms 1070 / 1070 ( 100%) FINISHED 1 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:10.679206000 2017-03-29 17:13:11.602892000 923ms 1070 / 1070 ( 100%) FINISHED 1 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=37) select * from store_sales_source DML 2017-03-29 17:13:04.603880000 2017-03-29 17:13:11.471366000 6s867ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=65) select * from store_sales_source DML 2017-03-29 17:13:10.362714000 2017-03-29 17:13:11.228785000 866ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:10.506964000 2017-03-29 17:13:11.083042000 576ms 1070 / 1070 ( 100%) FINISHED 1 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:10.485545000 2017-03-29 17:13:11.081036000 595ms 1070 / 1070 ( 100%) FINISHED 1 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(25) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:04.842684000 2017-03-29 17:13:10.995739000 6s153ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=55) select * from store_sales_source DML 2017-03-29 17:13:07.849129000 2017-03-29 17:13:10.934715000 3s085ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:10.416233000 2017-03-29 17:13:10.781782000 365ms 1070 / 1070 ( 100%) FINISHED 1 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:10.636070000 2017-03-29 17:13:10.719371000 83ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=64) select * from store_sales_source DML 2017-03-29 17:13:10.031011000 2017-03-29 17:13:10.709373000 678ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:10.614152000 2017-03-29 17:13:10.699753000 85ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:10.588218000 2017-03-29 17:13:10.635347000 47ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:10.569817000 2017-03-29 17:13:10.635147000 65ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:10.585050000 2017-03-29 17:13:10.634949000 49ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:10.433951000 2017-03-29 17:13:10.476936000 42ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(33) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:06.453638000 2017-03-29 17:13:10.472049000 4s018ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:10.412918000 2017-03-29 17:13:10.459916000 46ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(29) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:05.112497000 2017-03-29 17:13:10.400181000 5s287ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:10.319127000 2017-03-29 17:13:10.380826000 61ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=62) select * from store_sales_source DML 2017-03-29 17:13:09.597595000 2017-03-29 17:13:10.331738000 734ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(28) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:05.043561000 2017-03-29 17:13:10.142328000 5s098ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=61) select * from store_sales_source DML 2017-03-29 17:13:09.371094000 2017-03-29 17:13:09.987393000 616ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=53) select * from store_sales_source DML 2017-03-29 17:13:07.421320000 2017-03-29 17:13:09.757557000 2s336ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:08.625103000 2017-03-29 17:13:09.578901000 953ms 734 / 734 ( 100%) FINISHED 1 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:08.626315000 2017-03-29 17:13:09.570555000 944ms 734 / 734 ( 100%) FINISHED 1 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=46) select * from store_sales_source DML 2017-03-29 17:13:05.729267000 2017-03-29 17:13:09.564334000 3s835ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:08.625624000 2017-03-29 17:13:09.542935000 917ms 734 / 734 ( 100%) FINISHED 1 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:08.619353000 2017-03-29 17:13:09.533026000 913ms 734 / 734 ( 100%) FINISHED 1 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:08.602053000 2017-03-29 17:13:09.517421000 915ms 733 / 733 ( 100%) FINISHED 1 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:08.607061000 2017-03-29 17:13:09.376736000 769ms 733 / 733 ( 100%) FINISHED 1 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:08.569303000 2017-03-29 17:13:09.363806000 794ms 733 / 733 ( 100%) FINISHED 1 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=56) select * from store_sales_source DML 2017-03-29 17:13:07.853021000 2017-03-29 17:13:09.334329000 1s481ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales QUERY 2017-03-29 17:13:08.563524000 2017-03-29 17:13:09.276090000 712ms 733 / 733 ( 100%) FINISHED 1 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(26) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:04.903615000 2017-03-29 17:13:09.093391000 4s189ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=54) select * from store_sales_source DML 2017-03-29 17:13:07.621631000 2017-03-29 17:13:09.005934000 1s384ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk) /*+ clustered,shuffle */ select * from (select *, mod(cast(rand(22) * 1000000000 as int),30) from store_sales_source union all select *, 0 from store_sales_source limit 0) a DML 2017-03-29 17:13:04.681098000 2017-03-29 17:13:08.795301000 4s114ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests insert into store_sales partition(ss_sold_date_sk=42) select * from store_sales_source DML 2017-03-29 17:13:04.984036000 2017-03-29 17:13:08.650743000 3s666ms 1 / 1 ( 100%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:08.504269000 2017-03-29 17:13:08.580528000 76ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:08.502411000 2017-03-29 17:13:08.575607000 73ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:08.505650000 2017-03-29 17:13:08.572069000 66ms 0 / 0 ( 0%) FINISHED 0 root.default Details table_level_tests select count(*) from store_sales LIMIT 0 QUERY 2017-03-29 17:13:08.499568000 2017-03-29 17:13:08.563621000 64ms 0 / 0 ( 0%) FINISHED 0 root.default Details