| --! qt:dataset:src |
| drop table ba_test; |
| |
| -- this query tests ba_table1.q + nested queries with multiple operations on binary data types + union on binary types |
| create table ba_test (ba_key binary, ba_val binary) ; |
| |
| describe extended ba_test; |
| |
| from src insert overwrite table ba_test select cast (src.key as binary), cast (src.value as binary); |
| |
| select * from ( select key from src where key < 50 union all select cast(ba_key as string) as key from ba_test order by key limit 50) unioned order by key limit 10; |
| |
| drop table ba_test; |
| |
| |