Saving all output to "!!{outputDirectory}!!/print_header.q.raw". Enter "record" with no arguments to stop it.
>>>  !run !!{qFileDirectory}!!/print_header.q
>>>  
>>>  set hive.cli.print.header=true;
No rows affected 
>>>  
>>>  SELECT src1.key as k1, src1.value as v1, 
src2.key as k2, src2.value as v2 FROM 
(SELECT * FROM src WHERE src.key < 10) src1 
JOIN 
(SELECT * FROM src WHERE src.key < 10) src2 
SORT BY k1, v1, k2, v2 
LIMIT 10;
'k1','v1','k2','v2'
'0','val_0','0','val_0'
'0','val_0','0','val_0'
'0','val_0','0','val_0'
'0','val_0','0','val_0'
'0','val_0','0','val_0'
'0','val_0','0','val_0'
'0','val_0','0','val_0'
'0','val_0','0','val_0'
'0','val_0','0','val_0'
'0','val_0','2','val_2'
10 rows selected 
>>>  
>>>  SELECT src.key, sum(substr(src.value,5)) FROM src GROUP BY src.key LIMIT 10;
'key','_c1'
'0','0.0'
'10','10.0'
'100','200.0'
'103','206.0'
'104','208.0'
'105','105.0'
'11','11.0'
'111','111.0'
'113','226.0'
'114','114.0'
10 rows selected 
>>>  
>>>  use default;
No rows affected 
>>>  !record