Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- oleg (0) /storage/work/scidb/tests/harness$ cat testcases/r/checkin/simple-repart.expected
- SCIDB QUERY : <create array a <value:int32> [x=0:5,3,0]>
- Query was executed successfully
- SCIDB QUERY : <create array b <value:int32> [x=0:5,2,0]>
- Query was executed successfully
- SCIDB QUERY : <store(build(a, x), a)>
- [(0),(1),(2),(3),(4),(5)]
- SCIDB QUERY : <explain_physical('store(repart(a,b), b)', 'afl')>
- [("[pPlan]:
- >[pNode] physicalStore agg 0 ddl 0 tile 0 children 1
- schema b<value:int32> [x=0:5,2,0]
- props sgm 1 sgo 1
- distr roro
- bound start {0} end {5} density 1 cells 6 chunks 3 est_bytes 222
- >>[pNode] impl_sg agg 0 ddl 0 tile 0 children 1
- schema b<value:int32> [x=0:5,2,0]
- props sgm 0 sgo 0
- distr roro
- bound start {0} end {5} density 1 cells 6 chunks 3 est_bytes 222
- >>>[pNode] physicalRepart agg 0 ddl 0 tile 0 children 1
- schema b<value:int32> [x=0:5,2,0]
- props sgm 1 sgo 1
- distr roro
- bound start {0} end {5} density 1 cells 6 chunks 3 est_bytes 222
- >>>>[pNode] physicalScan agg 0 ddl 0 tile 1 children 0
- schema a@1<value:int32> [xa=0:5,3,0]
- props sgm 1 sgo 1
- distr roro
- bound start {0} end {5} density 1 cells 6 chunks 2 est_bytes 206
- ")]
- SCIDB QUERY : <store(repart(a,b), b)>
- [(0),(1),(2),(3),(4),(5)]
- SCIDB QUERY : <remove(a)>
- Query was executed successfully
- SCIDB QUERY : <remove(b)>
- Query was executed successfully
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement