Saving all output to "!!{outputDirectory}!!/ba_table_union.q.raw". Enter "record" with no arguments to stop it.
>>>  !run !!{qFileDirectory}!!/ba_table_union.q
>>>  drop table ba_test;
No rows affected 
>>>  
>>>  -- 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) ;
No rows affected 
>>>  
>>>  describe extended ba_test;
'col_name','data_type','comment'
'ba_key','binary',''
'ba_val','binary',''
'','',''
'Detailed Table Information','Table(tableName:ba_test, dbName:ba_table_union, owner:!!{user.name}!!, createTime:!!UNIXTIME!!, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:ba_key, type:binary, comment:null), FieldSchema(name:ba_val, type:binary, comment:null)], location:!!{hive.metastore.warehouse.dir}!!/ba_table_union.db/ba_test, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}, skewedInfo:SkewedInfo(skewedColNames:[], skewedColValues:[], skewedColValueLocationMaps:{})), partitionKeys:[], parameters:{transient_lastDdlTime=!!UNIXTIME!!}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)',''
4 rows selected 
>>>  
>>>  from src insert overwrite table ba_test select cast (src.key as binary), cast (src.value as binary);
'_c0','_c1'
No rows selected 
>>>  
>>>  select * from ( select key  from src where key < 50 union all select cast(ba_key as string) as key from ba_test limit 50) unioned order by key limit 10;
'key'
'0'
'0'
'0'
'10'
'11'
'12'
'12'
'128'
'145'
'146'
10 rows selected 
>>>  
>>>  drop table ba_test;
No rows affected 
>>>  
>>>  
>>>  !record