| --! qt:dataset:src |
| set hive.mapred.mode=nonstrict; |
| set hive.cbo.enable=true; |
| |
| -- SORT_QUERY_RESULTS |
| |
| drop table srclimit; |
| create table srclimit as select * from src limit 10; |
| |
| select cast(value as binary), value from srclimit; |
| |
| select cast(value as binary), value from srclimit order by value; |
| |
| select cast(value as binary), value from srclimit order by value limit 5; |
| |
| select cast(value as binary), value, key from srclimit order by value, key limit 5; |
| |
| select *, key, value from srclimit; |
| |
| select * from (select *, key, value from srclimit) t; |
| |
| drop table srclimit; |