| --! qt:dataset:src |
| -- SORT_QUERY_RESULTS |
| |
| drop table ba_test_n4; |
| |
| -- This query tests a) binary type works correctly in grammar b) string can be cast into binary c) binary can be stored in a table d) binary data can be loaded back again and queried d) order-by on a binary key |
| |
| create table ba_test_n4 (ba_key binary, ba_val binary) ; |
| |
| describe extended ba_test_n4; |
| |
| from src insert overwrite table ba_test_n4 select cast (src.key as binary), cast (src.value as binary); |
| |
| select * from ba_test_n4 tablesample (10 rows); |
| |
| drop table ba_test_n4; |