| --! qt:dataset:cbo_t3 | |
| --! qt:dataset:alltypesorc | |
| set hive.mapred.mode=nonstrict; | |
| set hive.explain.user=true; | |
| explain | |
| select rank() over (order by return_ratio) as return_rank from | |
| (select sum(wr.cint)/sum(ws.c_int) as return_ratio | |
| from cbo_t3 ws join alltypesorc wr on ws.value = wr.cstring1 | |
| group by ws.c_boolean ) in_web | |
| ; |