Saving all output to "!!{outputDirectory}!!/create_merge_compressed.q.raw". Enter "record" with no arguments to stop it.
>>>  !run !!{qFileDirectory}!!/create_merge_compressed.q
>>>  create table src_rc_merge_test(key int, value string) stored as rcfile;
No rows affected 
>>>  
>>>  load data local inpath '../data/files/smbbucket_1.rc' into table src_rc_merge_test;
No rows affected 
>>>  
>>>  set hive.exec.compress.output = true;
No rows affected 
>>>  
>>>  create table tgt_rc_merge_test(key int, value string) stored as rcfile;
No rows affected 
>>>  insert into table tgt_rc_merge_test select * from src_rc_merge_test;
'key','value'
No rows selected 
>>>  insert into table tgt_rc_merge_test select * from src_rc_merge_test;
'key','value'
No rows selected 
>>>  
>>>  show table extended like `tgt_rc_merge_test`;
'tab_name'
'tableName:tgt_rc_merge_test'
'owner:!!{user.name}!!'
'location:!!{hive.metastore.warehouse.dir}!!/create_merge_compressed.db/tgt_rc_merge_test'
'inputformat:org.apache.hadoop.hive.ql.io.RCFileInputFormat'
'outputformat:org.apache.hadoop.hive.ql.io.RCFileOutputFormat'
'columns:struct columns { i32 key, string value}'
'partitioned:false'
'partitionColumns:'
'totalNumberFiles:1'
'totalFileSize:171'
'maxFileSize:171'
'minFileSize:171'
'lastAccessTime:0'
'lastUpdateTime:!!UNIXTIMEMILLIS!!'
''
15 rows selected 
>>>  
>>>  select count(1) from tgt_rc_merge_test;
'_c0'
'5'
1 row selected 
>>>  select sum(hash(key)), sum(hash(value)) from tgt_rc_merge_test;
'_c0','_c1'
'23','-375947694'
1 row selected 
>>>  
>>>  alter table tgt_rc_merge_test concatenate;
No rows affected 
>>>  
>>>  show table extended like `tgt_rc_merge_test`;
'tab_name'
'tableName:tgt_rc_merge_test'
'owner:!!{user.name}!!'
'location:!!{hive.metastore.warehouse.dir}!!/create_merge_compressed.db/tgt_rc_merge_test'
'inputformat:org.apache.hadoop.hive.ql.io.RCFileInputFormat'
'outputformat:org.apache.hadoop.hive.ql.io.RCFileOutputFormat'
'columns:struct columns { i32 key, string value}'
'partitioned:false'
'partitionColumns:'
'totalNumberFiles:1'
'totalFileSize:171'
'maxFileSize:171'
'minFileSize:171'
'lastAccessTime:0'
'lastUpdateTime:!!UNIXTIMEMILLIS!!'
''
15 rows selected 
>>>  
>>>  select count(1) from tgt_rc_merge_test;
'_c0'
'5'
1 row selected 
>>>  select sum(hash(key)), sum(hash(value)) from tgt_rc_merge_test;
'_c0','_c1'
'23','-375947694'
1 row selected 
>>>  
>>>  drop table src_rc_merge_test;
No rows affected 
>>>  drop table tgt_rc_merge_test;
No rows affected 
>>>  !record