Added: hive/trunk/ql/src/test/results/clientpositive/index_compact_binary_search.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/index_compact_binary_search.q.out?rev=1202525&view=auto ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/index_compact_binary_search.q.out (added) +++ hive/trunk/ql/src/test/results/clientpositive/index_compact_binary_search.q.out Wed Nov 16 04:42:03 2011 @@ -0,0 +1,459 @@ +PREHOOK: query: CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH DEFERRED REBUILD +PREHOOK: type: CREATEINDEX +POSTHOOK: query: CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH DEFERRED REBUILD +POSTHOOK: type: CREATEINDEX +PREHOOK: query: ALTER INDEX src_index ON src REBUILD +PREHOOK: type: ALTERINDEX_REBUILD +PREHOOK: Input: default@src +PREHOOK: Output: default@default__src_src_index__ +POSTHOOK: query: ALTER INDEX src_index ON src REBUILD +POSTHOOK: type: ALTERINDEX_REBUILD +POSTHOOK: Input: default@src +POSTHOOK: Output: default@default__src_src_index__ +POSTHOOK: Lineage: default__src_src_index__._bucketname SIMPLE [(src)src.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] +POSTHOOK: Lineage: default__src_src_index__._offsets EXPRESSION [(src)src.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ] +POSTHOOK: Lineage: default__src_src_index__.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +PREHOOK: query: SELECT * FROM src WHERE key = '0' +PREHOOK: type: QUERY +PREHOOK: Input: default@default__src_src_index__ +PREHOOK: Input: default@src +PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-28-16_162_4530544379793726356/-mr-10000 +0 val_0 +0 val_0 +0 val_0 +PREHOOK: query: SELECT * FROM src WHERE key < '1' +PREHOOK: type: QUERY +PREHOOK: Input: default@default__src_src_index__ +PREHOOK: Input: default@src +PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-28-24_910_8422770577218536886/-mr-10000 +0 val_0 +0 val_0 +0 val_0 +PREHOOK: query: SELECT * FROM src WHERE key <= '0' +PREHOOK: type: QUERY +PREHOOK: Input: default@default__src_src_index__ +PREHOOK: Input: default@src +PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-28-33_506_4731041870462994974/-mr-10000 +0 val_0 +0 val_0 +0 val_0 +PREHOOK: query: SELECT * FROM src WHERE key > '8' +PREHOOK: type: QUERY +PREHOOK: Input: default@default__src_src_index__ +PREHOOK: Input: default@src +PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-28-42_116_5213638754635953384/-mr-10000 +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 +PREHOOK: query: SELECT * FROM src WHERE key >= '9' +PREHOOK: type: QUERY +PREHOOK: Input: default@default__src_src_index__ +PREHOOK: Input: default@src +PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-28-50_540_3532759530680718240/-mr-10000 +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 +PREHOOK: query: DROP INDEX src_index ON src +PREHOOK: type: DROPINDEX +PREHOOK: query: CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH DEFERRED REBUILD +PREHOOK: type: CREATEINDEX +PREHOOK: query: ALTER INDEX src_index ON src REBUILD +PREHOOK: type: ALTERINDEX_REBUILD +PREHOOK: Input: default@src +PREHOOK: Output: default@default__src_src_index__ +PREHOOK: query: SELECT * FROM src WHERE key = '0' +PREHOOK: type: QUERY +PREHOOK: Input: default@default__src_src_index__ +PREHOOK: Input: default@src +PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-29-07_718_5321452601706822472/-mr-10000 +0 val_0 +0 val_0 +0 val_0 +PREHOOK: query: SELECT * FROM src WHERE key < '1' +PREHOOK: type: QUERY +PREHOOK: Input: default@default__src_src_index__ +PREHOOK: Input: default@src +PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-29-16_481_5807706878522087187/-mr-10000 +0 val_0 +0 val_0 +0 val_0 +PREHOOK: query: SELECT * FROM src WHERE key <= '0' +PREHOOK: type: QUERY +PREHOOK: Input: default@default__src_src_index__ +PREHOOK: Input: default@src +PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-29-24_683_6289978315989311017/-mr-10000 +0 val_0 +0 val_0 +0 val_0 +PREHOOK: query: SELECT * FROM src WHERE key > '8' +PREHOOK: type: QUERY +PREHOOK: Input: default@default__src_src_index__ +PREHOOK: Input: default@src +PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-29-33_397_8866306423858815160/-mr-10000 +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 +PREHOOK: query: SELECT * FROM src WHERE key >= '9' +PREHOOK: type: QUERY +PREHOOK: Input: default@default__src_src_index__ +PREHOOK: Input: default@src +PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-29-42_150_3909923166888031983/-mr-10000 +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 +PREHOOK: query: DROP INDEX src_index ON src +PREHOOK: type: DROPINDEX +PREHOOK: query: CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH DEFERRED REBUILD +PREHOOK: type: CREATEINDEX +PREHOOK: query: ALTER INDEX src_index ON src REBUILD +PREHOOK: type: ALTERINDEX_REBUILD +PREHOOK: Input: default@src +PREHOOK: Output: default@default__src_src_index__ +PREHOOK: query: SELECT * FROM src WHERE key = '0' +PREHOOK: type: QUERY +PREHOOK: Input: default@default__src_src_index__ +PREHOOK: Input: default@src +PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-29-58_166_3678265151794926604/-mr-10000 +0 val_0 +0 val_0 +0 val_0 +PREHOOK: query: SELECT * FROM src WHERE key < '1' +PREHOOK: type: QUERY +PREHOOK: Input: default@default__src_src_index__ +PREHOOK: Input: default@src +PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-30-06_723_4428955348995805938/-mr-10000 +0 val_0 +0 val_0 +0 val_0 +PREHOOK: query: SELECT * FROM src WHERE key <= '0' +PREHOOK: type: QUERY +PREHOOK: Input: default@default__src_src_index__ +PREHOOK: Input: default@src +PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-30-15_252_6268745784357839984/-mr-10000 +0 val_0 +0 val_0 +0 val_0 +PREHOOK: query: SELECT * FROM src WHERE key > '8' +PREHOOK: type: QUERY +PREHOOK: Input: default@default__src_src_index__ +PREHOOK: Input: default@src +PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-30-23_915_5724065339829448949/-mr-10000 +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 +PREHOOK: query: SELECT * FROM src WHERE key >= '9' +PREHOOK: type: QUERY +PREHOOK: Input: default@default__src_src_index__ +PREHOOK: Input: default@src +PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-30-32_371_334426532692286168/-mr-10000 +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 +PREHOOK: query: DROP INDEX src_index ON src +PREHOOK: type: DROPINDEX +PREHOOK: query: CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH DEFERRED REBUILD +PREHOOK: type: CREATEINDEX +PREHOOK: query: ALTER INDEX src_index ON src REBUILD +PREHOOK: type: ALTERINDEX_REBUILD +PREHOOK: Input: default@src +PREHOOK: Output: default@default__src_src_index__ +PREHOOK: query: SELECT * FROM src WHERE key = '0' +PREHOOK: type: QUERY +PREHOOK: Input: default@default__src_src_index__ +PREHOOK: Input: default@src +PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-30-47_153_9199966558974802063/-mr-10000 +0 val_0 +0 val_0 +0 val_0 +PREHOOK: query: SELECT * FROM src WHERE key < '1' +PREHOOK: type: QUERY +PREHOOK: Input: default@default__src_src_index__ +PREHOOK: Input: default@src +PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-30-55_387_6708123102148378807/-mr-10000 +0 val_0 +0 val_0 +0 val_0 +PREHOOK: query: SELECT * FROM src WHERE key <= '0' +PREHOOK: type: QUERY +PREHOOK: Input: default@default__src_src_index__ +PREHOOK: Input: default@src +PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-31-03_712_8643764022963931262/-mr-10000 +0 val_0 +0 val_0 +0 val_0 +PREHOOK: query: SELECT * FROM src WHERE key > '8' +PREHOOK: type: QUERY +PREHOOK: Input: default@default__src_src_index__ +PREHOOK: Input: default@src +PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-31-12_217_4545846333420817182/-mr-10000 +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 +PREHOOK: query: SELECT * FROM src WHERE key >= '9' +PREHOOK: type: QUERY +PREHOOK: Input: default@default__src_src_index__ +PREHOOK: Input: default@src +PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-31-20_405_7128617548959801569/-mr-10000 +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 +PREHOOK: query: DROP INDEX src_index ON src +PREHOOK: type: DROPINDEX +PREHOOK: query: CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH DEFERRED REBUILD +PREHOOK: type: CREATEINDEX +PREHOOK: query: ALTER INDEX src_index ON src REBUILD +PREHOOK: type: ALTERINDEX_REBUILD +PREHOOK: Input: default@src +PREHOOK: Output: default@default__src_src_index__ +PREHOOK: query: SELECT * FROM src WHERE key = '0' +PREHOOK: type: QUERY +PREHOOK: Input: default@default__src_src_index__ +PREHOOK: Input: default@src +PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-31-35_592_7263189839927522587/-mr-10000 +0 val_0 +0 val_0 +0 val_0 +PREHOOK: query: SELECT * FROM src WHERE key < '1' +PREHOOK: type: QUERY +PREHOOK: Input: default@default__src_src_index__ +PREHOOK: Input: default@src +PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-31-44_027_7622604667919537891/-mr-10000 +0 val_0 +0 val_0 +0 val_0 +PREHOOK: query: SELECT * FROM src WHERE key <= '0' +PREHOOK: type: QUERY +PREHOOK: Input: default@default__src_src_index__ +PREHOOK: Input: default@src +PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-31-52_682_8498170072495224496/-mr-10000 +0 val_0 +0 val_0 +0 val_0 +PREHOOK: query: SELECT * FROM src WHERE key > '8' +PREHOOK: type: QUERY +PREHOOK: Input: default@default__src_src_index__ +PREHOOK: Input: default@src +PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-32-01_171_3483974250307194429/-mr-10000 +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 +PREHOOK: query: SELECT * FROM src WHERE key >= '9' +PREHOOK: type: QUERY +PREHOOK: Input: default@default__src_src_index__ +PREHOOK: Input: default@src +PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-32-09_626_7969856304834644252/-mr-10000 +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 +PREHOOK: query: DROP INDEX src_index ON src +PREHOOK: type: DROPINDEX +PREHOOK: query: CREATE INDEX src_index ON TABLE src(key) as 'COMPACT' WITH DEFERRED REBUILD +PREHOOK: type: CREATEINDEX +PREHOOK: query: ALTER INDEX src_index ON src REBUILD +PREHOOK: type: ALTERINDEX_REBUILD +PREHOOK: Input: default@src +PREHOOK: Output: default@default__src_src_index__ +PREHOOK: query: SELECT * FROM src WHERE key = '0' +PREHOOK: type: QUERY +PREHOOK: Input: default@default__src_src_index__ +PREHOOK: Input: default@src +PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-32-24_952_7986831589488854044/-mr-10000 +0 val_0 +0 val_0 +0 val_0 +PREHOOK: query: SELECT * FROM src WHERE key < '1' +PREHOOK: type: QUERY +PREHOOK: Input: default@default__src_src_index__ +PREHOOK: Input: default@src +PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-32-33_434_6857699378136194430/-mr-10000 +0 val_0 +0 val_0 +0 val_0 +PREHOOK: query: SELECT * FROM src WHERE key <= '0' +PREHOOK: type: QUERY +PREHOOK: Input: default@default__src_src_index__ +PREHOOK: Input: default@src +PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-32-41_908_1172462155728735633/-mr-10000 +0 val_0 +0 val_0 +0 val_0 +PREHOOK: query: SELECT * FROM src WHERE key > '8' +PREHOOK: type: QUERY +PREHOOK: Input: default@default__src_src_index__ +PREHOOK: Input: default@src +PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-32-52_719_4367930844159597815/-mr-10000 +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 +PREHOOK: query: SELECT * FROM src WHERE key >= '9' +PREHOOK: type: QUERY +PREHOOK: Input: default@default__src_src_index__ +PREHOOK: Input: default@src +PREHOOK: Output: file:/var/folders/Y1/Y1Kf7th8FAawW1lYb6Tt+l+pemQ/-Tmp-/kevinwilfong/hive_2011-11-03_17-33-01_910_3573322999685212570/-mr-10000 +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 +PREHOOK: query: DROP INDEX src_index ON src +PREHOOK: type: DROPINDEX
