Saving all output to "!!{outputDirectory}!!/rcfile_lazydecompress.q.raw". Enter "record" with no arguments to stop it.
>>>  !run !!{qFileDirectory}!!/rcfile_lazydecompress.q
>>>  
>>>  CREATE table rcfileTableLazyDecompress (key STRING, value STRING) STORED AS RCFile;
No rows affected 
>>>  
>>>  FROM src 
INSERT OVERWRITE TABLE rcfileTableLazyDecompress SELECT src.key, src.value LIMIT 10;
'key','value'
No rows selected 
>>>  
>>>  SELECT key, value FROM rcfileTableLazyDecompress where key > 238 ORDER BY key ASC, value ASC;
'key','value'
'255','val_255'
'278','val_278'
'311','val_311'
'409','val_409'
'484','val_484'
5 rows selected 
>>>  
>>>  SELECT key, value FROM rcfileTableLazyDecompress where key > 238 and key < 400 ORDER BY key ASC, value ASC;
'key','value'
'255','val_255'
'278','val_278'
'311','val_311'
3 rows selected 
>>>  
>>>  SELECT key, count(1) FROM rcfileTableLazyDecompress where key > 238 group by key ORDER BY key ASC;
'key','_c1'
'255','1'
'278','1'
'311','1'
'409','1'
'484','1'
5 rows selected 
>>>  
>>>  set mapred.output.compress=true;
No rows affected 
>>>  set hive.exec.compress.output=true;
No rows affected 
>>>  
>>>  FROM src 
INSERT OVERWRITE TABLE rcfileTableLazyDecompress SELECT src.key, src.value LIMIT 10;
'key','value'
No rows selected 
>>>  
>>>  SELECT key, value FROM rcfileTableLazyDecompress where key > 238 ORDER BY key ASC, value ASC;
'key','value'
'255','val_255'
'278','val_278'
'311','val_311'
'409','val_409'
'484','val_484'
5 rows selected 
>>>  
>>>  SELECT key, value FROM rcfileTableLazyDecompress where key > 238 and key < 400 ORDER BY key ASC, value ASC;
'key','value'
'255','val_255'
'278','val_278'
'311','val_311'
3 rows selected 
>>>  
>>>  SELECT key, count(1) FROM rcfileTableLazyDecompress where key > 238 group by key ORDER BY key ASC;
'key','_c1'
'255','1'
'278','1'
'311','1'
'409','1'
'484','1'
5 rows selected 
>>>  
>>>  set mapred.output.compress=false;
No rows affected 
>>>  set hive.exec.compress.output=false;
No rows affected 
>>>  
>>>  !record