--! qt:dataset:src
drop table ba_test_n2;

-- All the tests of ba_table1.q + test for a group-by and aggregation on a binary key.

create table ba_test_n2 (ba_key binary, ba_val binary) ;

from src insert overwrite table ba_test_n2 select cast (src.key as binary), cast (src.value as binary);

select ba_test_n2.ba_key, count(ba_test_n2.ba_val) from ba_test_n2 group by ba_test_n2.ba_key order by ba_key limit 5;

drop table ba_test_n2;