You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Mostafa Mokhtar (JIRA)" <ji...@apache.org> on 2014/11/04 22:13:34 UTC
[jira] [Created] (HIVE-8731) TPC-DS Q49 : More rows are returned
than the limit set in the query
Mostafa Mokhtar created HIVE-8731:
-------------------------------------
Summary: TPC-DS Q49 : More rows are returned than the limit set in the query
Key: HIVE-8731
URL: https://issues.apache.org/jira/browse/HIVE-8731
Project: Hive
Issue Type: Bug
Components: Vectorization
Affects Versions: 0.14.0
Reporter: Mostafa Mokhtar
Assignee: Matt McCline
Priority: Critical
Fix For: 0.14.0
TPC-DS query 49 returns more rows than that set in limit.
Query
{code}
set hive.cbo.enable=true;
set hive.stats.fetch.column.stats=true;
set hive.exec.dynamic.partition.mode=nonstrict;
set hive.tez.auto.reducer.parallelism=true;
set hive.auto.convert.join.noconditionaltask.size=1280000000;
set hive.exec.reducers.bytes.per.reducer=100000000;
set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DummyTxnManager;
set hive.support.concurrency=false;
set hive.tez.exec.print.summary=true;
explain
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.ws_sold_date_sk = date_dim.d_date_sk
and d_year = 2000
and d_moy = 12
group by ws.ws_item_sk
) in_web
) web
where
(
web.return_rank <= 10
or
web.currency_rank <= 10
)
union all
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 = 2000
and d_moy = 12
group by cs.cs_item_sk
) in_cat
) catalog
where
(
catalog.return_rank <= 10
or
catalog.currency_rank <=10
)
union all
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 = 2000
and d_moy = 12
group by sts.ss_item_sk
) in_store
) store
where (
store.return_rank <= 10
or
store.currency_rank <= 10
)
order by 1,4,5
limit 100
{code}
Explain
{code}
OK
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
STAGE PLANS:
Stage: Stage-1
Tez
Edges:
Map 11 <- Map 2 (BROADCAST_EDGE)
Map 16 <- Map 1 (BROADCAST_EDGE)
Map 9 <- Map 10 (BROADCAST_EDGE)
Reducer 12 <- Map 11 (SIMPLE_EDGE), Map 23 (SIMPLE_EDGE)
Reducer 13 <- Reducer 12 (SIMPLE_EDGE)
Reducer 14 <- Reducer 13 (SIMPLE_EDGE)
Reducer 15 <- Reducer 14 (SIMPLE_EDGE), Union 8 (CONTAINS)
Reducer 17 <- Map 16 (SIMPLE_EDGE), Map 22 (SIMPLE_EDGE)
Reducer 18 <- Reducer 17 (SIMPLE_EDGE)
Reducer 19 <- Reducer 18 (SIMPLE_EDGE)
Reducer 20 <- Reducer 19 (SIMPLE_EDGE)
Reducer 21 <- Reducer 20 (SIMPLE_EDGE), Union 8 (CONTAINS)
Reducer 4 <- Map 3 (SIMPLE_EDGE), Map 9 (SIMPLE_EDGE)
Reducer 5 <- Reducer 4 (SIMPLE_EDGE)
Reducer 6 <- Reducer 5 (SIMPLE_EDGE)
Reducer 7 <- Reducer 6 (SIMPLE_EDGE), Union 8 (CONTAINS)
DagName: mmokhtar_20141104031616_2feed955-8bb2-41e9-a7be-247a5fd102f0:1
Vertices:
Map 1
Map Operator Tree:
TableScan
alias: date_dim
filterExpr: (((d_year = 2000) and (d_moy = 12)) and d_date_sk is not null) (type: boolean)
Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (((d_year = 2000) and (d_moy = 12)) and d_date_sk is not null) (type: boolean)
Statistics: Num rows: 652 Data size: 7824 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: d_date_sk (type: int)
outputColumnNames: _col0
Statistics: Num rows: 652 Data size: 2608 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
Statistics: Num rows: 652 Data size: 2608 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col0 (type: int)
outputColumnNames: _col0
Statistics: Num rows: 652 Data size: 2608 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
keys: _col0 (type: int)
mode: hash
outputColumnNames: _col0
Statistics: Num rows: 326 Data size: 1304 Basic stats: COMPLETE Column stats: COMPLETE
Dynamic Partitioning Event Operator
Target Input: sts
Partition key expr: ss_sold_date_sk
Statistics: Num rows: 326 Data size: 1304 Basic stats: COMPLETE Column stats: COMPLETE
Target column: ss_sold_date_sk
Target Vertex: Map 16
Execution mode: vectorized
Map 10
Map Operator Tree:
TableScan
alias: date_dim
filterExpr: (((d_year = 2000) and (d_moy = 12)) and d_date_sk is not null) (type: boolean)
Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (((d_year = 2000) and (d_moy = 12)) and d_date_sk is not null) (type: boolean)
Statistics: Num rows: 652 Data size: 7824 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: d_date_sk (type: int)
outputColumnNames: _col0
Statistics: Num rows: 652 Data size: 2608 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
Statistics: Num rows: 652 Data size: 2608 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col0 (type: int)
outputColumnNames: _col0
Statistics: Num rows: 652 Data size: 2608 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
keys: _col0 (type: int)
mode: hash
outputColumnNames: _col0
Statistics: Num rows: 326 Data size: 1304 Basic stats: COMPLETE Column stats: COMPLETE
Dynamic Partitioning Event Operator
Target Input: ws
Partition key expr: ws_sold_date_sk
Statistics: Num rows: 326 Data size: 1304 Basic stats: COMPLETE Column stats: COMPLETE
Target column: ws_sold_date_sk
Target Vertex: Map 9
Execution mode: vectorized
Map 11
Map Operator Tree:
TableScan
alias: cs
filterExpr: (((((cs_net_profit > 1.0) and (cs_net_paid > 0.0)) and (cs_quantity > 0)) and cs_order_number is not null) and cs_item_sk is not null) (type: boolean)
Statistics: Num rows: 43005109025 Data size: 5569553841288 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (((((cs_net_profit > 1.0) and (cs_net_paid > 0.0)) and (cs_quantity > 0)) and cs_order_number is not null) and cs_item_sk is not null) (type: boolean)
Statistics: Num rows: 712248037 Data size: 15504677212 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: cs_item_sk (type: int), cs_order_number (type: int), cs_quantity (type: int), cs_net_paid (type: float), cs_sold_date_sk (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col5
Statistics: Num rows: 712248037 Data size: 12655685064 Basic stats: COMPLETE Column stats: COMPLETE
Map Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
0 {_col0} {_col1} {_col2} {_col3}
1
keys:
0 _col5 (type: int)
1 _col0 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3
input vertices:
1 Map 2
Statistics: Num rows: 795181027 Data size: 12722896432 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col0 (type: int), _col1 (type: int), _col2 (type: int), _col3 (type: float)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 795181027 Data size: 12722896432 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col1 (type: int), _col0 (type: int)
sort order: ++
Map-reduce partition columns: _col1 (type: int), _col0 (type: int)
Statistics: Num rows: 795181027 Data size: 12722896432 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col2 (type: int), _col3 (type: float)
Execution mode: vectorized
Map 16
Map Operator Tree:
TableScan
alias: sts
filterExpr: (((((ss_net_profit > 1.0) and (ss_net_paid > 0.0)) and (ss_quantity > 0)) and ss_ticket_number is not null) and ss_item_sk is not null) (type: boolean)
Statistics: Num rows: 82510879939 Data size: 6873789738208 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (((((ss_net_profit > 1.0) and (ss_net_paid > 0.0)) and (ss_quantity > 0)) and ss_ticket_number is not null) and ss_item_sk is not null) (type: boolean)
Statistics: Num rows: 911486684 Data size: 19059525624 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: ss_item_sk (type: int), ss_ticket_number (type: int), ss_quantity (type: int), ss_net_paid (type: float), ss_sold_date_sk (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col5
Statistics: Num rows: 911486684 Data size: 15499570644 Basic stats: COMPLETE Column stats: COMPLETE
Map Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
0 {_col0} {_col1} {_col2} {_col3}
1
keys:
0 _col5 (type: int)
1 _col0 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3
input vertices:
1 Map 1
Statistics: Num rows: 1017618695 Data size: 16281899120 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col0 (type: int), _col1 (type: int), _col2 (type: int), _col3 (type: float)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 1017618695 Data size: 16281899120 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col1 (type: int), _col0 (type: int)
sort order: ++
Map-reduce partition columns: _col1 (type: int), _col0 (type: int)
Statistics: Num rows: 1017618695 Data size: 16281899120 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col2 (type: int), _col3 (type: float)
Execution mode: vectorized
Map 2
Map Operator Tree:
TableScan
alias: date_dim
filterExpr: (((d_year = 2000) and (d_moy = 12)) and d_date_sk is not null) (type: boolean)
Statistics: Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (((d_year = 2000) and (d_moy = 12)) and d_date_sk is not null) (type: boolean)
Statistics: Num rows: 652 Data size: 7824 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: d_date_sk (type: int)
outputColumnNames: _col0
Statistics: Num rows: 652 Data size: 2608 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
Statistics: Num rows: 652 Data size: 2608 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col0 (type: int)
outputColumnNames: _col0
Statistics: Num rows: 652 Data size: 2608 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
keys: _col0 (type: int)
mode: hash
outputColumnNames: _col0
Statistics: Num rows: 326 Data size: 1304 Basic stats: COMPLETE Column stats: COMPLETE
Dynamic Partitioning Event Operator
Target Input: cs
Partition key expr: cs_sold_date_sk
Statistics: Num rows: 326 Data size: 1304 Basic stats: COMPLETE Column stats: COMPLETE
Target column: cs_sold_date_sk
Target Vertex: Map 11
Execution mode: vectorized
Map 22
Map Operator Tree:
TableScan
alias: sr
filterExpr: (((sr_return_amt > 10000.0) and sr_ticket_number is not null) and sr_item_sk is not null) (type: boolean)
Statistics: Num rows: 8332595709 Data size: 599630285540 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (((sr_return_amt > 10000.0) and sr_ticket_number is not null) and sr_item_sk is not null) (type: boolean)
Statistics: Num rows: 828937940 Data size: 10816321020 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: sr_item_sk (type: int), sr_ticket_number (type: int), sr_return_quantity (type: int), sr_return_amt (type: float)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 828937940 Data size: 10816321020 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col1 (type: int), _col0 (type: int)
sort order: ++
Map-reduce partition columns: _col1 (type: int), _col0 (type: int)
Statistics: Num rows: 828937940 Data size: 10816321020 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col2 (type: int), _col3 (type: float)
Execution mode: vectorized
Map 23
Map Operator Tree:
TableScan
alias: cr
filterExpr: (((cr_return_amount > 10000.0) and cr_order_number is not null) and cr_item_sk is not null) (type: boolean)
Statistics: Num rows: 4320980099 Data size: 431907559456 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (((cr_return_amount > 10000.0) and cr_order_number is not null) and cr_item_sk is not null) (type: boolean)
Statistics: Num rows: 644267320 Data size: 8780816984 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: cr_item_sk (type: int), cr_order_number (type: int), cr_return_quantity (type: int), cr_return_amount (type: float)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 644267320 Data size: 8780816984 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col1 (type: int), _col0 (type: int)
sort order: ++
Map-reduce partition columns: _col1 (type: int), _col0 (type: int)
Statistics: Num rows: 644267320 Data size: 8780816984 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col2 (type: int), _col3 (type: float)
Execution mode: vectorized
Map 3
Map Operator Tree:
TableScan
alias: wr
filterExpr: (((wr_return_amt > 10000.0) and wr_order_number is not null) and wr_item_sk is not null) (type: boolean)
Statistics: Num rows: 2062802370 Data size: 185695406284 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (((wr_return_amt > 10000.0) and wr_order_number is not null) and wr_item_sk is not null) (type: boolean)
Statistics: Num rows: 687600790 Data size: 10872009264 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: wr_item_sk (type: int), wr_order_number (type: int), wr_return_quantity (type: int), wr_return_amt (type: float)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 687600790 Data size: 10872009264 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col1 (type: int), _col0 (type: int)
sort order: ++
Map-reduce partition columns: _col1 (type: int), _col0 (type: int)
Statistics: Num rows: 687600790 Data size: 10872009264 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col2 (type: int), _col3 (type: float)
Execution mode: vectorized
Map 9
Map Operator Tree:
TableScan
alias: ws
filterExpr: (((((ws_net_profit > 1.0) and (ws_net_paid > 0.0)) and (ws_quantity > 0)) and ws_order_number is not null) and ws_item_sk is not null) (type: boolean)
Statistics: Num rows: 21594638446 Data size: 2850189889652 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (((((ws_net_profit > 1.0) and (ws_net_paid > 0.0)) and (ws_quantity > 0)) and ws_order_number is not null) and ws_item_sk is not null) (type: boolean)
Statistics: Num rows: 799801423 Data size: 19194435896 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: ws_item_sk (type: int), ws_order_number (type: int), ws_quantity (type: int), ws_net_paid (type: float), ws_sold_date_sk (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col5
Statistics: Num rows: 799801423 Data size: 15995230204 Basic stats: COMPLETE Column stats: COMPLETE
Map Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
0 {_col0} {_col1} {_col2} {_col3}
1
keys:
0 _col5 (type: int)
1 _col0 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3
input vertices:
1 Map 10
Statistics: Num rows: 892928985 Data size: 14286863760 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col0 (type: int), _col1 (type: int), _col2 (type: int), _col3 (type: float)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 892928985 Data size: 14286863760 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col1 (type: int), _col0 (type: int)
sort order: ++
Map-reduce partition columns: _col1 (type: int), _col0 (type: int)
Statistics: Num rows: 892928985 Data size: 14286863760 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col2 (type: int), _col3 (type: float)
Execution mode: vectorized
Reducer 12
Reduce Operator Tree:
Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
0 {VALUE._col0} {VALUE._col1}
1 {KEY.reducesinkkey1} {VALUE._col0} {VALUE._col1}
outputColumnNames: _col2, _col3, _col4, _col6, _col7
Statistics: Num rows: 750469116 Data size: 9005629392 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col4 (type: int), COALESCE(_col2,0) (type: int), COALESCE(_col6,0) (type: int), COALESCE(_col3,0) (type: float), COALESCE(_col7,0) (type: float)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics: Num rows: 750469116 Data size: 9005629392 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: sum(_col1), sum(_col2), sum(_col3), sum(_col4)
keys: _col0 (type: int)
mode: hash
outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics: Num rows: 461643 Data size: 16619148 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
Statistics: Num rows: 461643 Data size: 16619148 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: bigint), _col2 (type: bigint), _col3 (type: double), _col4 (type: double)
Reducer 13
Reduce Operator Tree:
Group By Operator
aggregations: sum(VALUE._col0), sum(VALUE._col1), sum(VALUE._col2), sum(VALUE._col3)
keys: KEY._col0 (type: int)
mode: mergepartial
outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics: Num rows: 5073 Data size: 182628 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col0 (type: int), (CAST( _col1 AS decimal(15,4)) / CAST( _col2 AS decimal(15,4))) (type: decimal(35,20)), (CAST( _col3 AS decimal(15,4)) / CAST( _col4 AS decimal(15,4))) (type: decimal(35,20))
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 5073 Data size: 1156644 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: 0 (type: int), _col1 (type: decimal(35,20))
sort order: ++
Map-reduce partition columns: 0 (type: int)
Statistics: Num rows: 5073 Data size: 1156644 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: int), _col1 (type: decimal(35,20)), _col2 (type: decimal(35,20))
Execution mode: vectorized
Reducer 14
Reduce Operator Tree:
Extract
Statistics: Num rows: 5073 Data size: 1156644 Basic stats: COMPLETE Column stats: COMPLETE
PTF Operator
Statistics: Num rows: 5073 Data size: 1156644 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: 0 (type: int), _col2 (type: decimal(35,20))
sort order: ++
Map-reduce partition columns: 0 (type: int)
Statistics: Num rows: 5073 Data size: 1156644 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _wcol0 (type: int), _col0 (type: int), _col1 (type: decimal(35,20)), _col2 (type: decimal(35,20))
Reducer 15
Reduce Operator Tree:
Extract
PTF Operator
Filter Operator
predicate: ((_col0 <= 10) or (_wcol1 <= 10)) (type: boolean)
Select Operator
expressions: 'catalog' (type: string), _col1 (type: int), _col2 (type: decimal(35,20)), _col0 (type: int), _wcol1 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
Select Operator
expressions: _col0 (type: string), _col1 (type: int), _col2 (type: decimal(35,20)), _col3 (type: int), _col4 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
File Output Operator
compressed: false
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Reducer 17
Reduce Operator Tree:
Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
0 {VALUE._col0} {VALUE._col1}
1 {KEY.reducesinkkey1} {VALUE._col0} {VALUE._col1}
outputColumnNames: _col2, _col3, _col4, _col6, _col7
Statistics: Num rows: 5092708834 Data size: 61112506008 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col4 (type: int), COALESCE(_col2,0) (type: int), COALESCE(_col6,0) (type: int), COALESCE(_col3,0) (type: float), COALESCE(_col7,0) (type: float)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics: Num rows: 5092708834 Data size: 61112506008 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: sum(_col1), sum(_col2), sum(_col3), sum(_col4)
keys: _col0 (type: int)
mode: hash
outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics: Num rows: 2194632 Data size: 79006752 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
Statistics: Num rows: 2194632 Data size: 79006752 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: bigint), _col2 (type: bigint), _col3 (type: double), _col4 (type: double)
Reducer 18
Reduce Operator Tree:
Group By Operator
aggregations: sum(VALUE._col0), sum(VALUE._col1), sum(VALUE._col2), sum(VALUE._col3)
keys: KEY._col0 (type: int)
mode: mergepartial
outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics: Num rows: 3586 Data size: 129096 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col0 (type: int), (CAST( _col1 AS decimal(15,4)) / CAST( _col2 AS decimal(15,4))) (type: decimal(35,20)), (CAST( _col3 AS decimal(15,4)) / CAST( _col4 AS decimal(15,4))) (type: decimal(35,20))
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 3586 Data size: 817608 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: 0 (type: int), _col1 (type: decimal(35,20))
sort order: ++
Map-reduce partition columns: 0 (type: int)
Statistics: Num rows: 3586 Data size: 817608 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: int), _col1 (type: decimal(35,20)), _col2 (type: decimal(35,20))
Execution mode: vectorized
Reducer 19
Reduce Operator Tree:
Extract
Statistics: Num rows: 3586 Data size: 817608 Basic stats: COMPLETE Column stats: COMPLETE
PTF Operator
Statistics: Num rows: 3586 Data size: 817608 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: 0 (type: int), _col2 (type: decimal(35,20))
sort order: ++
Map-reduce partition columns: 0 (type: int)
Statistics: Num rows: 3586 Data size: 817608 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _wcol0 (type: int), _col0 (type: int), _col1 (type: decimal(35,20)), _col2 (type: decimal(35,20))
Reducer 20
Reduce Operator Tree:
Extract
Statistics: Num rows: 3586 Data size: 817608 Basic stats: COMPLETE Column stats: COMPLETE
PTF Operator
Statistics: Num rows: 3586 Data size: 817608 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: ((_col0 <= 10) or (_wcol1 <= 10)) (type: boolean)
Statistics: Num rows: 2390 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
Select Operator
expressions: 'store' (type: string), _col1 (type: int), _col2 (type: decimal(35,20)), _col0 (type: int), _wcol1 (type: int), 1 (type: int), 4 (type: int), 5 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
Statistics: Num rows: 2390 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
Reduce Output Operator
key expressions: _col5 (type: int), _col6 (type: int), _col7 (type: int)
sort order: +++
Statistics: Num rows: 2390 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
TopN Hash Memory Usage: 0.04
value expressions: _col0 (type: string), _col1 (type: int), _col2 (type: decimal(35,20)), _col3 (type: int), _col4 (type: int)
Reducer 21
Reduce Operator Tree:
Select Operator
expressions: VALUE._col0 (type: string), VALUE._col1 (type: int), VALUE._col2 (type: decimal(35,20)), VALUE._col3 (type: int), VALUE._col4 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
Limit
Number of rows: 100
Select Operator
expressions: _col0 (type: string), _col1 (type: int), _col2 (type: decimal(35,20)), _col3 (type: int), _col4 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
Select Operator
expressions: _col0 (type: string), _col1 (type: int), _col2 (type: decimal(35,20)), _col3 (type: int), _col4 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
File Output Operator
compressed: false
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Execution mode: vectorized
Reducer 4
Reduce Operator Tree:
Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
0 {VALUE._col0} {VALUE._col1}
1 {KEY.reducesinkkey1} {VALUE._col0} {VALUE._col1}
outputColumnNames: _col2, _col3, _col4, _col6, _col7
Statistics: Num rows: 375616827 Data size: 4507401924 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col4 (type: int), COALESCE(_col2,0) (type: int), COALESCE(_col6,0) (type: int), COALESCE(_col3,0) (type: float), COALESCE(_col7,0) (type: float)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics: Num rows: 375616827 Data size: 4507401924 Basic stats: COMPLETE Column stats: COMPLETE
Group By Operator
aggregations: sum(_col1), sum(_col2), sum(_col3), sum(_col4)
keys: _col0 (type: int)
mode: hash
outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics: Num rows: 232622 Data size: 8374392 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Map-reduce partition columns: _col0 (type: int)
Statistics: Num rows: 232622 Data size: 8374392 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col1 (type: bigint), _col2 (type: bigint), _col3 (type: double), _col4 (type: double)
Reducer 5
Reduce Operator Tree:
Group By Operator
aggregations: sum(VALUE._col0), sum(VALUE._col1), sum(VALUE._col2), sum(VALUE._col3)
keys: KEY._col0 (type: int)
mode: mergepartial
outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics: Num rows: 5057 Data size: 182052 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col0 (type: int), (CAST( _col1 AS decimal(15,4)) / CAST( _col2 AS decimal(15,4))) (type: decimal(35,20)), (CAST( _col3 AS decimal(15,4)) / CAST( _col4 AS decimal(15,4))) (type: decimal(35,20))
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 5057 Data size: 1152996 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: 0 (type: int), _col1 (type: decimal(35,20))
sort order: ++
Map-reduce partition columns: 0 (type: int)
Statistics: Num rows: 5057 Data size: 1152996 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _col0 (type: int), _col1 (type: decimal(35,20)), _col2 (type: decimal(35,20))
Execution mode: vectorized
Reducer 6
Reduce Operator Tree:
Extract
Statistics: Num rows: 5057 Data size: 1152996 Basic stats: COMPLETE Column stats: COMPLETE
PTF Operator
Statistics: Num rows: 5057 Data size: 1152996 Basic stats: COMPLETE Column stats: COMPLETE
Reduce Output Operator
key expressions: 0 (type: int), _col2 (type: decimal(35,20))
sort order: ++
Map-reduce partition columns: 0 (type: int)
Statistics: Num rows: 5057 Data size: 1152996 Basic stats: COMPLETE Column stats: COMPLETE
value expressions: _wcol0 (type: int), _col0 (type: int), _col1 (type: decimal(35,20)), _col2 (type: decimal(35,20))
Reducer 7
Reduce Operator Tree:
Extract
PTF Operator
Filter Operator
predicate: ((_col0 <= 10) or (_wcol1 <= 10)) (type: boolean)
Select Operator
expressions: 'web' (type: string), _col1 (type: int), _col2 (type: decimal(35,20)), _col0 (type: int), _wcol1 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
Select Operator
expressions: _col0 (type: string), _col1 (type: int), _col2 (type: decimal(35,20)), _col3 (type: int), _col4 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
File Output Operator
compressed: false
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Union 8
Vertex: Union 8
Stage: Stage-0
Fetch Operator
limit: -1
Processor Tree:
ListSink
{code}
Results
{code}
OK
web 55255 0.37373737373737373737 1072 1
web 305651 0.38383838383838383838 1138 2
web 336757 0.38461538461538461538 1142 3
web 256885 0.39 1191 4
web 229082 0.39175257731958762887 1204 5
web 151723 0.4 1265 6
web 293861 0.4 1265 6
web 178178 0.4 1265 8
web 354485 0.40449438202247191011 1315 9
web 124375 0.40625 1334 10
web 80125 0 1 44
web 417227 0 1 103
web 316352 0 1 142
web 116672 0 1 143
web 267277 0 1 181
web 100247 0 1 237
web 247022 0 1 505
web 247679 0 1 966
web 89753 0 1 1081
web 88964 0 1 1492
web 292469 0 1 1771
web 31958 0 1 1868
web 200161 0 1 1937
web 194660 0 1 2064
web 381619 0 1 2233
web 244238 0 1 2437
web 54247 0 1 2647
web 105464 0 1 2669
web 297959 0 1 3196
web 405146 0 1 3278
web 79435 0 1 3298
web 101285 0 1 3625
web 33871 0 1 3866
web 190016 0 1 4068
web 147661 0 1 4068
web 164804 0 1 4076
web 461345 0 1 4119
web 339872 0 1 4271
web 286802 0 1 4431
web 127811 0 1 4636
web 157763 0 1 4652
web 232867 0 1 4800
web 102164 0 1 5068
web 170683 0 1 5404
web 280421 0 1 5457
web 354487 0 1 5839
web 159923 0 1 5889
web 326413 0 1 5940
web 455582 0 1 6098
web 170078 0 1 6809
web 430406 0 1 6939
web 372425 0 1 6939
web 124520 0 1 7178
web 68522 0 1 7229
web 185078 0 1 7247
web 364901 0 1 7262
web 361805 0 1 7276
web 75752 0 1 7378
web 207637 0 1 7395
web 32810 0 1 7743
web 86717 0 1 8253
web 241475 0 1 8377
web 346709 0 1 8646
web 280169 0 1 8661
web 49567 0 1 8800
web 29849 0 1 9090
web 130943 0 1 9152
web 301475 0 1 9260
web 161756 0 1 9504
web 358580 0 1 9606
web 277976 0 1 10594
web 134677 0 1 11027
web 275977 0 1 11476
web 297167 0 1 11944
web 430345 0 1 12058
web 166676 0 1 12808
web 179306 0 1 12875
web 254888 0 1 12954
web 353521 0 1 13176
web 240865 0 1 13998
web 423649 0 1 14122
web 408743 0 1 14122
web 460999 0 1 15733
web 286481 0 1 15733
web 329173 0 1 17252
web 130622 0 1 17840
web 178213 0 1 17997
web 335984 0 1 18289
web 427916 0 1 18728
web 114487 0 1 19540
web 162031 0 1 20434
web 55337 0 1 20436
web 240067 0 1 20440
web 126476 0 1 20663
web 293327 0 1 20860
web 190472 0 1 21262
web 45476 0 1 21341
web 33242 0 1 21492
web 278471 0 1 21522
web 91147 0 1 21528
web 16073 0 1 21542
web 433838 0 1 21696
web 302984 0 1 21892
web 29873 0 1 22205
web 385919 0 1 22224
web 143483 0 1 22738
web 282407 0 1 22741
web 450079 0 1 22868
web 101966 0 1 23096
web 166459 0 1 23115
web 375350 0 1 23368
web 97184 0 1 23376
web 359954 0 1 24597
web 188270 0 1 25893
web 179275 0 1 26023
web 454568 0 1 26873
web 15557 0 1 26997
web 70519 0 1 27962
web 100357 0 1 28291
web 301403 0 1 28709
web 111667 0 1 28850
web 10501 0 1 28998
web 97295 0 1 29488
web 375497 0 1 29488
web 440813 0 1 30025
web 203027 0 1 30114
web 29135 0 1 30178
web 105905 0 1 30452
web 9041 0 1 32084
web 238418 0 1 32241
web 220373 0 1 32704
web 160309 0 1 33182
web 381818 0 1 33546
web 370256 0 1 34171
web 243403 0 1 34283
web 20515 0 1 34603
web 230303 0 1 35673
web 411935 0 1 35705
web 233701 0 1 37837
web 443305 0 1 37946
web 216317 0 1 38667
web 317917 0 1 39702
web 434725 0 1 40089
web 244205 0 1 41401
web 43489 0 1 41622
web 75620 0 1 42416
web 175826 0 1 42550
web 152153 0 1 43205
web 149119 0 1 43608
web 211130 0 1 44405
web 24283 0 1 44707
web 281659 0 1 44955
web 371879 0 1 44960
web 136409 0 1 45813
web 299177 0 1 46233
web 438806 0 1 46450
web 238466 0 1 46451
web 299749 0 1 47191
web 71201 0 1 48191
web 114923 0 1 48312
web 174617 0 1 48846
web 20420 0 1 50055
web 219266 0 1 50118
web 54392 0 1 51281
web 11507 0 1 51359
web 24517 0 1 51719
web 306482 0 1 51945
web 110642 0 1 52339
web 433994 0 1 52722
web 313400 0 1 52873
web 252587 0 1 53020
web 318925 0 1 53983
web 409789 0 1 54250
web 270332 0 1 54454
web 314339 0 1 54457
web 399728 0 1 54962
web 5275 0 1 55300
web 296609 0 1 55474
web 126703 0 1 56460
web 3847 0 1 56483
web 434144 0 1 57400
web 270977 0 1 57678
web 357530 0 1 58668
web 415016 0 1 59103
web 364253 0 1 59424
web 138307 0 1 59424
web 446414 0 1 61467
web 243497 0 1 61496
web 88586 0 1 62134
web 21259 0 1 62872
web 275609 0 1 63160
web 347183 0 1 63160
web 454637 0 1 63761
web 338377 0 1 63889
web 92663 0 1 64335
web 4477 0 1 64458
web 4999 0 1 65909
web 7748 0 1 65909
web 287239 0 1 65909
web 323351 0 1 66236
web 58081 0 1 66398
web 91541 0 1 66398
web 441350 0 1 67000
web 3367 0 1 68511
web 29492 0 1 68511
web 167318 0 1 70048
web 249703 0 1 70673
web 294482 0 1 71769
web 429041 0 1 73030
web 147769 0 1 73049
web 228656 0 1 73062
web 57223 0 1 73185
web 431921 0 1 74475
web 443024 0 1 74750
web 95546 0 1 74750
web 56474 0 1 75727
web 439543 0 1 76122
web 58297 0 1 77271
web 73100 0 1 77278
web 94982 0 1 78993
web 104297 0 1 79275
web 141467 0 1 80408
web 44077 0 1 80417
web 237227 0 1 80952
web 67067 0 1 80968
web 347354 0 1 81793
web 320251 0 1 83749
web 452603 0 1 83883
web 337321 0 1 86256
web 367706 0 1 86304
web 75293 0 1 86311
web 66464 0 1 89520
web 417877 0 1 90913
web 100349 0 1 92083
web 178415 0 1 92095
web 145946 0 1 92121
web 342131 0 1 92172
web 118316 0 1 92172
web 242335 0 1 92292
web 296270 0 1 92309
web 177391 0 1 93635
web 240829 0 1 93645
web 264623 0 1 95054
web 288746 0 1 95276
web 146369 0 1 95292
web 356861 0 1 95504
web 354331 0 1 95508
web 224348 0 1 96361
web 228715 0 1 97615
web 247843 0 1 98442
web 347473 0 1 98728
web 156895 0 1 98977
web 351461 0 1 99521
web 304111 0 1 99608
web 428719 0 1 100158
web 82130 0 1 100197
web 82010 0 1 101038
web 24121 0 1 101239
web 296849 0 1 101694
web 194371 0 1 102225
web 112235 0 1 103045
web 127214 0 1 103867
web 164423 0 1 103972
web 439169 0 1 104959
web 163760 0 1 104964
web 368695 0 1 104981
web 298418 0 1 105715
web 13838 0 1 105866
web 432998 0 1 105867
web 446179 0 1 106045
web 412615 0 1 106777
web 120055 0 1 107221
web 191501 0 1 107289
web 360653 0 1 107307
web 190070 0 1 108386
web 107633 0 1 108518
web 366209 0 1 109023
web 429101 0 1 109466
web 316070 0 1 109482
web 10712 0 1 109692
web 266069 0 1 109700
web 249733 0 1 111139
web 70045 0 1 111164
web 240698 0 1 111551
web 401072 0 1 111573
web 355184 0 1 111962
web 377269 0 1 112397
web 202675 0 1 112397
web 42194 0 1 112934
web 134465 0 1 113204
web 217639 0 1 113553
web 80789 0 1 113553
web 115991 0 1 114061
web 239695 0 1 114247
web 444767 0 1 114730
web 110083 0 1 114730
web 275573 0 1 115520
web 197687 0 1 116150
web 446195 0 1 116700
web 307259 0 1 117173
web 323371 0 1 117189
web 381079 0 1 117605
web 128753 0 1 117762
web 39799 0 1 117791
web 310532 0 1 118044
web 221660 0 1 118184
web 268621 0 1 118202
web 110063 0 1 118210
web 249179 0 1 118212
web 42971 0 1 119018
web 310208 0 1 119076
web 454793 0 1 120232
web 208957 0 1 120465
web 82849 0 1 121192
web 53702 0 1 121192
web 21062 0 1 121415
web 324653 0 1 121428
web 153002 0 1 121429
web 304052 0 1 121683
web 446263 0 1 123094
web 158507 0 1 124550
web 206918 0 1 124959
web 157307 0 1 125162
web 202565 0 1 125773
web 71246 0 1 125781
web 128735 0 1 126272
web 144110 0 1 126272
web 44654 0 1 127071
web 349571 0 1 127579
web 394307 0 1 128562
web 361969 0 1 128562
web 21656 0 1 129341
web 285827 0 1 129391
web 420451 0 1 129485
web 11240 0 1 129495
web 29203 0 1 129643
web 197699 0 1 129834
web 270757 0 1 130245
web 258089 0 1 130251
web 183977 0 1 131074
web 454580 0 1 131107
web 367465 0 1 131406
web 45728 0 1 131939
web 109316 0 1 132352
web 443213 0 1 133289
web 250055 0 1 133307
web 148897 0 1 133549
web 226133 0 1 133611
web 378464 0 1 133625
web 404870 0 1 134382
web 16751 0 1 135055
web 431300 0 1 135080
web 9101 0 1 135862
web 74167 0 1 135990
web 158111 0 1 136667
web 446257 0 1 136754
web 98861 0 1 136911
web 38111 0 1 137801
web 344714 0 1 137818
web 413459 0 1 138113
web 365432 0 1 138364
web 362185 0 1 138744
web 321278 0 1 139129
web 135563 0 1 139162
web 378050 0 1 139564
web 23233 0 1 139850
web 443606 0 1 139877
web 331412 0 1 140624
web 216851 0 1 141028
web 200971 0 1 141294
web 447476 0 1 141994
web 321644 0 1 141995
web 289843 0 1 141995
web 344893 0 1 142793
web 322694 0 1 143356
web 215177 0 1 143574
web 379513 0 1 144646
web 136381 0 1 144665
web 112166 0 1 144678
web 387167 0 1 144738
web 135875 0 1 144739
web 85513 0 1 145059
web 444338 0 1 145505
web 104180 0 1 145514
web 297272 0 1 145723
web 451567 0 1 146429
web 345578 0 1 147055
web 455189 0 1 147055
web 272654 0 1 147691
web 443003 0 1 147816
web 7837 0 1 147950
web 70021 0 1 148596
web 53366 0 1 148864
web 371419 0 1 149339
web 185819 0 1 149762
web 191372 0 1 149997
web 284921 0 1 150014
web 136532 0 1 150033
web 216551 0 1 150241
web 80057 0 1 150794
web 274727 0 1 150810
web 117356 0 1 151306
web 361817 0 1 151335
web 295796 0 1 151424
web 38725 0 1 152205
web 251423 0 1 152531
web 144761 0 1 153554
web 189515 0 1 153582
web 351413 0 1 154217
web 293585 0 1 154319
web 279683 0 1 154325
web 227969 0 1 154802
web 187759 0 1 154826
web 352051 0 1 155327
web 62095 0 1 155373
web 177086 0 1 155847
web 382045 0 1 155898
web 201965 0 1 156292
web 381419 0 1 156297
web 203105 0 1 156304
web 338525 0 1 156867
web 416054 0 1 156871
web 56239 0 1 157215
web 156785 0 1 157215
web 72518 0 1 157361
web 208465 0 1 157774
web 222926 0 1 157784
web 208063 0 1 157857
web 438182 0 1 157969
web 237950 0 1 158278
web 207437 0 1 158284
web 58406 0 1 158388
web 142868 0 1 158410
web 39155 0 1 158864
web 323903 0 1 158953
web 358037 0 1 159159
web 312679 0 1 159171
web 90818 0 1 159196
web 7525 0 1 159609
web 3386 0 1 159614
web 395951 0 1 159925
web 295775 0 1 159952
web 422113 0 1 160420
web 165458 0 1 160848
web 178304 0 1 161288
web 370973 0 1 161310
web 30404 0 1 161497
web 440456 0 1 161838
web 387740 0 1 162003
web 416287 0 1 162003
web 443935 0 1 162145
web 389287 0 1 162432
web 307988 0 1 162530
web 378701 0 1 163066
web 4567 0 1 163389
web 275792 0 1 163397
web 234338 0 1 163560
web 190736 0 1 163990
web 217508 0 1 163998
web 27181 0 1 164342
web 397964 0 1 164360
web 345305 0 1 164746
web 376712 0 1 164847
web 161449 0 1 164965
web 235189 0 1 165122
web 137629 0 1 165291
web 400481 0 1 165490
web 348188 0 1 165740
web 417158 0 1 166242
web 234497 0 1 166291
web 65624 0 1 166764
web 246455 0 1 167191
web 304189 0 1 167288
web 444188 0 1 167295
web 460183 0 1 167316
web 105062 0 1 168620
web 112568 0 1 168933
web 18827 0 1 168941
web 292856 0 1 168960
web 192938 0 1 169256
web 215065 0 1 169759
web 154034 0 1 170141
web 447899 0 1 170441
web 183338 0 1 170755
web 319253 0 1 170933
web 53867 0 1 170933
web 115433 0 1 171296
web 113051 0 1 171372
web 356915 0 1 171588
web 30014 0 1 172055
web 109862 0 1 172055
web 162671 0 1 172059
web 166028 0 1 172690
web 61987 0 1 172699
web 168686 0 1 172929
web 139213 0 1 173137
web 262022 0 1 173420
web 93445 0 1 173545
web 316241 0 1 173676
web 214199 0 1 174169
web 112993 0 1 174852
web 429389 0 1 174868
web 173216 0 1 175038
web 165416 0 1 175092
web 105485 0 1 175600
web 65141 0 1 175921
web 48878 0 1 175932
web 92330 0 1 176537
web 279734 0 1 176725
web 426727 0 1 177549
web 292759 0 1 177686
web 401549 0 1 177708
web 286231 0 1 177792
web 397046 0 1 178518
web 415478 0 1 178698
web 345227 0 1 178875
web 373058 0 1 178875
web 192193 0 1 178996
web 24245 0 1 179019
web 444314 0 1 179470
web 403379 0 1 179859
web 69434 0 1 179936
web 746 0 1 179937
web 214748 0 1 179937
web 219847 0 1 180392
web 313981 0 1 180410
web 98843 0 1 180668
web 205861 0 1 180880
web 393587 0 1 181268
web 9164 0 1 181306
web 70031 0 1 181319
web 307993 0 1 181320
web 311756 0 1 181367
web 168731 0 1 181417
web 439243 0 1 181417
web 347090 0 1 181872
web 182627 0 1 181873
web 408947 0 1 182003
web 29887 0 1 182045
web 272653 0 1 182140
web 458648 0 1 182186
web 182732 0 1 182200
web 390362 0 1 182423
web 12614 0 1 182553
web 261158 0 1 182577
web 428389 0 1 182578
web 320552 0 1 182687
web 352496 0 1 182795
web 167641 0 1 182924
web 172007 0 1 183787
web 254639 0 1 183794
web 29762 0 1 184001
web 202970 0 1 184391
web 194341 0 1 184408
web 84125 0 1 184473
web 333872 0 1 184735
web 310244 0 1 184837
web 109853 0 1 184948
web 373225 0 1 185346
web 48956 0 1 185446
web 450572 0 1 185618
web 196123 0 1 185629
web 164741 0 1 185707
web 10721 0 1 185876
web 135947 0 1 185894
web 134987 0 1 186211
web 458419 0 1 186211
web 25957 0 1 186218
web 130142 0 1 186275
web 408863 0 1 186581
web 384218 0 1 186599
web 329651 0 1 186620
web 134729 0 1 186787
web 103717 0 1 186788
web 122177 0 1 186898
web 328189 0 1 186907
web 50717 0 1 186907
web 12242 0 1 186947
web 372416 0 1 186962
web 83042 0 1 187134
web 318499 0 1 187220
web 208199 0 1 187382
web 451279 0 1 187631
web 319525 0 1 187667
web 82928 0 1 187685
web 281635 0 1 187797
web 104849 0 1 187855
web 71876 0 1 188585
web 381907 0 1 188846
web 260773 0 1 189026
web 386726 0 1 189297
web 102103 0 1 189654
web 348878 0 1 189654
web 402841 0 1 189654
web 144085 0 1 189654
web 302581 0 1 189654
web 458959 0 1 189654
web 246554 0 1 189654
web 131540 0 1 189654
web 404552 0 1 189654
web 344834 0 1 189654
web 279482 0 1 189654
web 248431 0 1 189654
web 122065 0 1 189654
web 352094 0 1 189654
web 85391 0 1 189654
web 255914 0 1 189654
web 167519 0 1 189654
web 295909 0 1 189654
web 188629 0 1 189654
web 201883 0 1 189654
web 296264 0 1 189654
web 151561 0 1 189654
web 142142 0 1 189654
web 111001 0 1 189654
web 414559 0 1 189654
web 396169 0 1 189654
web 305462 0 1 189654
web 17276 0 1 189654
web 114194 0 1 189654
web 114101 0 1 189654
web 300413 0 1 189654
web 383321 0 1 189654
web 154477 0 1 189654
web 12698 0 1 193152
web 210649 0 1 194566
web 447470 0 1 195058
web 310556 0 1 197541
web 440797 0 1 199129
web 18866 0 1 199861
web 49477 0 1 201136
web 153674 0 1 201933
web 363962 0 1 202791
web 426728 0 1 202915
web 149978 0 1 203421
web 226847 0 1 204326
web 318781 0 1 204414
web 134401 0 1 204620
web 325106 0 1 204685
web 164107 0 1 204789
web 84458 0 1 204865
web 186523 0 1 205635
web 128297 0 1 205651
web 129775 0 1 205883
web 341921 0 1 206184
web 349607 0 1 206248
web 40061 0 1 206281
web 241748 0 1 206673
web 311768 0 1 206673
web 65837 0 1 206727
web 182147 0 1 207056
web 135277 0 1 207199
web 406442 0 1 207409
web 325064 0 1 207542
web 31625 0 1 207772
web 35335 0 1 207780
web 409537 0 1 207873
web 425522 0 1 207878
web 316321 0 1 208065
web 336535 0 1 208099
web 200663 0 1 208183
web 276626 0 1 208184
web 105517 0 1 208415
web 159845 0 1 208495
store 159049 0.55555555555555555556 957 1
store 461875 0 1 88642
store 301262 0.56 962 3
store 64993 0.56 962 3
store 106037 0.5625 967 5
store 452918 0.56565656565656565657 973 6
store 99950 0.56701030927835051546 975 7
store 441133 0 1 88726
store 313939 0.57 981 9
store 293299 0.53608247422680412371 946 10
store 67513 0.53608247422680412371 946 10
store 44396 0 1 187
store 226271 0 1 187
store 2798 0 1 536
store 405805 0 1 1883
store 316363 0 1 2164
store 390566 0 1 2449
store 72133 0 1 2598
store 232121 0 1 2598
store 142753 0 1 2693
store 64795 0 1 3213
store 254627 0 1 3213
store 152245 0 1 3426
store 379699 0 1 3426
store 371191 0 1 3537
store 215285 0 1 3537
store 376124 0 1 3703
store 49580 0 1 3833
store 123643 0 1 3937
store 344917 0 1 4100
store 213242 0 1 4115
store 438661 0 1 88828
store 37921 0 1 4181
store 116881 0 1 4371
store 16763 0 1 4371
store 182257 0 1 4502
store 344072 0 1 4513
store 259760 0 1 4742
store 419867 0 1 4757
store 120439 0 1 4992
store 97423 0 1 5063
store 154801 0 1 5192
store 351752 0 1 5204
store 273161 0 1 5379
store 148745 0 1 5379
store 66377 0 1 5432
store 235223 0 1 5888
store 234377 0 1 5888
store 98900 0 1 5946
store 80741 0 1 7150
store 61165 0 1 7150
store 243379 0 1 7261
store 443174 0 1 7328
store 304759 0 1 7374
store 157934 0 1 7374
store 182426 0 1 7379
store 448247 0 1 7920
store 124027 0 1 7920
store 370889 0 1 7956
store 225500 0 1 8259
store 116441 0 1 8259
store 98851 0 1 8566
store 312899 0 1 8655
store 319273 0 1 8853
store 373891 0 1 9427
store 430379 0 1 9427
store 100771 0 1 9466
store 148939 0 1 9633
store 366697 0 1 9633
store 280493 0 1 9921
store 181862 0 1 9938
store 303197 0 1 10222
store 65090 0 1 10222
store 177205 0 1 10342
store 161438 0 1 10522
store 55621 0 1 10631
store 198065 0 1 10631
store 81320 0 1 10694
store 422851 0 1 10694
store 145669 0 1 10889
store 176960 0 1 10889
store 228017 0 1 10935
store 109945 0 1 11471
store 180157 0 1 11471
store 277454 0 1 11753
store 128576 0 1 11753
store 271805 0 1 11766
store 418925 0 1 11766
store 237101 0 1 12271
store 357680 0 1 12696
store 110846 0 1 13006
store 422353 0 1 13006
store 100184 0 1 13024
store 64679 0 1 13024
store 132031 0 1 13166
store 31790 0 1 13235
store 169577 0 1 13632
store 291643 0 1 13632
store 397028 0 1 14254
store 364919 0 1 14359
Time taken: 201.381 seconds, Fetched: 764 row(s)
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)