set hive.cbo.enable=true;

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 limit 5;

select *, key, value from srclimit;

select * from (select *, key, value from srclimit) t;

drop table srclimit;