Saving all output to "!!{outputDirectory}!!/index_compact_binary_search.q.raw". Enter "record" with no arguments to stop it.
>>>  !run !!{qFileDirectory}!!/index_compact_binary_search.q
>>>  SET hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat;
No rows affected 
>>>  SET hive.default.fileformat=TextFile;
No rows affected 
>>>  
>>>  CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH DEFERRED REBUILD;
No rows affected 
>>>  ALTER INDEX src_index ON src REBUILD;
No rows affected 
>>>  
>>>  SET hive.optimize.index.filter=true;
No rows affected 
>>>  SET hive.optimize.index.filter.compact.minsize=1;
No rows affected 
>>>  SET hive.index.compact.binary.search=true;
No rows affected 
>>>  
>>>  SET hive.exec.post.hooks=org.apache.hadoop.hive.ql.hooks.VerifyHiveSortedInputFormatUsedHook;
No rows affected 
>>>  
>>>  SELECT * FROM src WHERE key = '0';
'key','value'
'0','val_0'
'0','val_0'
'0','val_0'
3 rows selected 
>>>  
>>>  SELECT * FROM src WHERE key < '1';
'key','value'
'0','val_0'
'0','val_0'
'0','val_0'
3 rows selected 
>>>  
>>>  SELECT * FROM src WHERE key <= '0';
'key','value'
'0','val_0'
'0','val_0'
'0','val_0'
3 rows selected 
>>>  
>>>  SELECT * FROM src WHERE key > '8';
'key','value'
'86','val_86'
'98','val_98'
'82','val_82'
'92','val_92'
'83','val_83'
'84','val_84'
'96','val_96'
'95','val_95'
'98','val_98'
'85','val_85'
'87','val_87'
'90','val_90'
'95','val_95'
'80','val_80'
'90','val_90'
'83','val_83'
'9','val_9'
'97','val_97'
'84','val_84'
'90','val_90'
'97','val_97'
21 rows selected 
>>>  
>>>  SELECT * FROM src WHERE key >= '9';
'key','value'
'98','val_98'
'92','val_92'
'96','val_96'
'95','val_95'
'98','val_98'
'90','val_90'
'95','val_95'
'90','val_90'
'9','val_9'
'97','val_97'
'90','val_90'
'97','val_97'
12 rows selected 
>>>  
>>>  SET hive.exec.post.hooks=;
No rows affected 
>>>  
>>>  DROP INDEX src_index ON src;
No rows affected 
>>>  
>>>  SET hive.default.fileformat=RCFILE;
No rows affected 
>>>  
>>>  CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH DEFERRED REBUILD;
No rows affected 
>>>  ALTER INDEX src_index ON src REBUILD;
No rows affected 
>>>  
>>>  SET hive.exec.post.hooks=org.apache.hadoop.hive.ql.hooks.VerifyHiveSortedInputFormatUsedHook;
No rows affected 
>>>  
>>>  SELECT * FROM src WHERE key = '0';
'key','value'
'0','val_0'
'0','val_0'
'0','val_0'
3 rows selected 
>>>  
>>>  SELECT * FROM src WHERE key < '1';
'key','value'
'0','val_0'
'0','val_0'
'0','val_0'
3 rows selected 
>>>  
>>>  SELECT * FROM src WHERE key <= '0';
'key','value'
'0','val_0'
'0','val_0'
'0','val_0'
3 rows selected 
>>>  
>>>  SELECT * FROM src WHERE key > '8';
'key','value'
'86','val_86'
'98','val_98'
'82','val_82'
'92','val_92'
'83','val_83'
'84','val_84'
'96','val_96'
'95','val_95'
'98','val_98'
'85','val_85'
'87','val_87'
'90','val_90'
'95','val_95'
'80','val_80'
'90','val_90'
'83','val_83'
'9','val_9'
'97','val_97'
'84','val_84'
'90','val_90'
'97','val_97'
21 rows selected 
>>>  
>>>  SELECT * FROM src WHERE key >= '9';
'key','value'
'98','val_98'
'92','val_92'
'96','val_96'
'95','val_95'
'98','val_98'
'90','val_90'
'95','val_95'
'90','val_90'
'9','val_9'
'97','val_97'
'90','val_90'
'97','val_97'
12 rows selected 
>>>  
>>>  SET hive.exec.post.hooks=;
No rows affected 
>>>  
>>>  DROP INDEX src_index ON src;
No rows affected 
>>>  
>>>  SET hive.input.format=org.apache.hadoop.hive.ql.io.CombineHiveInputFormat;
No rows affected 
>>>  SET hive.default.fileformat=TextFile;
No rows affected 
>>>  
>>>  CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH DEFERRED REBUILD;
No rows affected 
>>>  ALTER INDEX src_index ON src REBUILD;
No rows affected 
>>>  
>>>  SET hive.exec.post.hooks=org.apache.hadoop.hive.ql.hooks.VerifyHiveSortedInputFormatUsedHook;
No rows affected 
>>>  
>>>  SELECT * FROM src WHERE key = '0';
'key','value'
'0','val_0'
'0','val_0'
'0','val_0'
3 rows selected 
>>>  
>>>  SELECT * FROM src WHERE key < '1';
'key','value'
'0','val_0'
'0','val_0'
'0','val_0'
3 rows selected 
>>>  
>>>  SELECT * FROM src WHERE key <= '0';
'key','value'
'0','val_0'
'0','val_0'
'0','val_0'
3 rows selected 
>>>  
>>>  SELECT * FROM src WHERE key > '8';
'key','value'
'86','val_86'
'98','val_98'
'82','val_82'
'92','val_92'
'83','val_83'
'84','val_84'
'96','val_96'
'95','val_95'
'98','val_98'
'85','val_85'
'87','val_87'
'90','val_90'
'95','val_95'
'80','val_80'
'90','val_90'
'83','val_83'
'9','val_9'
'97','val_97'
'84','val_84'
'90','val_90'
'97','val_97'
21 rows selected 
>>>  
>>>  SELECT * FROM src WHERE key >= '9';
'key','value'
'98','val_98'
'92','val_92'
'96','val_96'
'95','val_95'
'98','val_98'
'90','val_90'
'95','val_95'
'90','val_90'
'9','val_9'
'97','val_97'
'90','val_90'
'97','val_97'
12 rows selected 
>>>  
>>>  SET hive.exec.post.hooks=;
No rows affected 
>>>  
>>>  DROP INDEX src_index ON src;
No rows affected 
>>>  
>>>  SET hive.default.fileformat=RCFILE;
No rows affected 
>>>  
>>>  CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH DEFERRED REBUILD;
No rows affected 
>>>  ALTER INDEX src_index ON src REBUILD;
No rows affected 
>>>  
>>>  SET hive.exec.post.hooks=org.apache.hadoop.hive.ql.hooks.VerifyHiveSortedInputFormatUsedHook;
No rows affected 
>>>  
>>>  SELECT * FROM src WHERE key = '0';
'key','value'
'0','val_0'
'0','val_0'
'0','val_0'
3 rows selected 
>>>  
>>>  SELECT * FROM src WHERE key < '1';
'key','value'
'0','val_0'
'0','val_0'
'0','val_0'
3 rows selected 
>>>  
>>>  SELECT * FROM src WHERE key <= '0';
'key','value'
'0','val_0'
'0','val_0'
'0','val_0'
3 rows selected 
>>>  
>>>  SELECT * FROM src WHERE key > '8';
'key','value'
'86','val_86'
'98','val_98'
'82','val_82'
'92','val_92'
'83','val_83'
'84','val_84'
'96','val_96'
'95','val_95'
'98','val_98'
'85','val_85'
'87','val_87'
'90','val_90'
'95','val_95'
'80','val_80'
'90','val_90'
'83','val_83'
'9','val_9'
'97','val_97'
'84','val_84'
'90','val_90'
'97','val_97'
21 rows selected 
>>>  
>>>  SELECT * FROM src WHERE key >= '9';
'key','value'
'98','val_98'
'92','val_92'
'96','val_96'
'95','val_95'
'98','val_98'
'90','val_90'
'95','val_95'
'90','val_90'
'9','val_9'
'97','val_97'
'90','val_90'
'97','val_97'
12 rows selected 
>>>  
>>>  SET hive.exec.post.hooks=;
No rows affected 
>>>  
>>>  DROP INDEX src_index ON src;
No rows affected 
>>>  
>>>  SET hive.input.format=org.apache.hadoop.hive.ql.io.BucketizedHiveInputFormat;
No rows affected 
>>>  SET hive.default.fileformat=TextFile;
No rows affected 
>>>  
>>>  CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH DEFERRED REBUILD;
No rows affected 
>>>  ALTER INDEX src_index ON src REBUILD;
No rows affected 
>>>  
>>>  SET hive.exec.post.hooks=org.apache.hadoop.hive.ql.hooks.VerifyHiveSortedInputFormatUsedHook;
No rows affected 
>>>  
>>>  SELECT * FROM src WHERE key = '0';
'key','value'
'0','val_0'
'0','val_0'
'0','val_0'
3 rows selected 
>>>  
>>>  SELECT * FROM src WHERE key < '1';
'key','value'
'0','val_0'
'0','val_0'
'0','val_0'
3 rows selected 
>>>  
>>>  SELECT * FROM src WHERE key <= '0';
'key','value'
'0','val_0'
'0','val_0'
'0','val_0'
3 rows selected 
>>>  
>>>  SELECT * FROM src WHERE key > '8';
'key','value'
'86','val_86'
'98','val_98'
'82','val_82'
'92','val_92'
'83','val_83'
'84','val_84'
'96','val_96'
'95','val_95'
'98','val_98'
'85','val_85'
'87','val_87'
'90','val_90'
'95','val_95'
'80','val_80'
'90','val_90'
'83','val_83'
'9','val_9'
'97','val_97'
'84','val_84'
'90','val_90'
'97','val_97'
21 rows selected 
>>>  
>>>  SELECT * FROM src WHERE key >= '9';
'key','value'
'98','val_98'
'92','val_92'
'96','val_96'
'95','val_95'
'98','val_98'
'90','val_90'
'95','val_95'
'90','val_90'
'9','val_9'
'97','val_97'
'90','val_90'
'97','val_97'
12 rows selected 
>>>  
>>>  SET hive.exec.post.hooks=;
No rows affected 
>>>  
>>>  DROP INDEX src_index ON src;
No rows affected 
>>>  
>>>  SET hive.default.fileformat=RCFILE;
No rows affected 
>>>  
>>>  CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH DEFERRED REBUILD;
No rows affected 
>>>  ALTER INDEX src_index ON src REBUILD;
No rows affected 
>>>  
>>>  SET hive.exec.post.hooks=org.apache.hadoop.hive.ql.hooks.VerifyHiveSortedInputFormatUsedHook;
No rows affected 
>>>  
>>>  SELECT * FROM src WHERE key = '0';
'key','value'
'0','val_0'
'0','val_0'
'0','val_0'
3 rows selected 
>>>  
>>>  SELECT * FROM src WHERE key < '1';
'key','value'
'0','val_0'
'0','val_0'
'0','val_0'
3 rows selected 
>>>  
>>>  SELECT * FROM src WHERE key <= '0';
'key','value'
'0','val_0'
'0','val_0'
'0','val_0'
3 rows selected 
>>>  
>>>  SELECT * FROM src WHERE key > '8';
'key','value'
'86','val_86'
'98','val_98'
'82','val_82'
'92','val_92'
'83','val_83'
'84','val_84'
'96','val_96'
'95','val_95'
'98','val_98'
'85','val_85'
'87','val_87'
'90','val_90'
'95','val_95'
'80','val_80'
'90','val_90'
'83','val_83'
'9','val_9'
'97','val_97'
'84','val_84'
'90','val_90'
'97','val_97'
21 rows selected 
>>>  
>>>  SELECT * FROM src WHERE key >= '9';
'key','value'
'98','val_98'
'92','val_92'
'96','val_96'
'95','val_95'
'98','val_98'
'90','val_90'
'95','val_95'
'90','val_90'
'9','val_9'
'97','val_97'
'90','val_90'
'97','val_97'
12 rows selected 
>>>  
>>>  SET hive.exec.post.hooks=;
No rows affected 
>>>  
>>>  DROP INDEX src_index ON src;
No rows affected 
>>>  !record