Saving all output to "!!{outputDirectory}!!/index_compression.q.raw". Enter "record" with no arguments to stop it. >>> !run !!{qFileDirectory}!!/index_compression.q >>> SET hive.exec.compress.result=true; 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.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat; No rows affected >>> SET hive.optimize.index.filter=true; No rows affected >>> SET hive.optimize.index.filter.compact.minsize=0; No rows affected >>> >>> -- automatic indexing >>> EXPLAIN SELECT key, value FROM src WHERE key > 80 AND key < 100 ORDER BY key; 'Explain' 'ABSTRACT SYNTAX TREE:' ' (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL key)) (TOK_SELEXPR (TOK_TABLE_OR_COL value))) (TOK_WHERE (AND (> (TOK_TABLE_OR_COL key) 80) (< (TOK_TABLE_OR_COL key) 100))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL key)))))' '' 'STAGE DEPENDENCIES:' ' Stage-3 is a root stage' ' Stage-8 depends on stages: Stage-3 , consists of Stage-5, Stage-4, Stage-6' ' Stage-5' ' Stage-2 depends on stages: Stage-5, Stage-4, Stage-7' ' Stage-1 depends on stages: Stage-2' ' Stage-4' ' Stage-6' ' Stage-7 depends on stages: Stage-6' ' Stage-0 is a root stage' '' 'STAGE PLANS:' ' Stage: Stage-3' ' Map Reduce' ' Alias -> Map Operator Tree:' ' index_compression__src_src_index__ ' ' TableScan' ' alias: index_compression__src_src_index__' ' filterExpr:' ' expr: ((key > 80.0) and (key < 100.0))' ' type: boolean' ' Filter Operator' ' predicate:' ' expr: ((key > 80.0) and (key < 100.0))' ' type: boolean' ' Select Operator' ' expressions:' ' expr: _bucketname' ' type: string' ' expr: _offsets' ' type: array' ' outputColumnNames: _col0, _col1' ' File Output Operator' ' compressed: false' ' GlobalTableId: 1' ' table:' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' '' ' Stage: Stage-8' ' Conditional Operator' '' ' Stage: Stage-5' ' Move Operator' ' files:' ' hdfs directory: true' ' destination: file:!!{hive.exec.scratchdir}!!' '' ' Stage: Stage-2' ' Move Operator' ' files:' ' hdfs directory: true' ' destination: file:!!{hive.exec.scratchdir}!!' '' ' Stage: Stage-1' ' Map Reduce' ' Alias -> Map Operator Tree:' ' src ' ' TableScan' ' alias: src' ' filterExpr:' ' expr: ((key > 80.0) and (key < 100.0))' ' type: boolean' ' Filter Operator' ' predicate:' ' expr: ((key > 80.0) and (key < 100.0))' ' type: boolean' ' Select Operator' ' expressions:' ' expr: key' ' type: string' ' expr: value' ' type: string' ' outputColumnNames: _col0, _col1' ' Reduce Output Operator' ' key expressions:' ' expr: _col0' ' type: string' ' sort order: +' ' tag: -1' ' value expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' Reduce Operator Tree:' ' Extract' ' File Output Operator' ' compressed: false' ' GlobalTableId: 0' ' table:' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' '' ' Stage: Stage-4' ' Map Reduce' ' Alias -> Map Operator Tree:' ' file:!!{hive.exec.scratchdir}!! ' ' File Output Operator' ' compressed: false' ' GlobalTableId: 0' ' table:' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' '' ' Stage: Stage-6' ' Map Reduce' ' Alias -> Map Operator Tree:' ' file:!!{hive.exec.scratchdir}!! ' ' File Output Operator' ' compressed: false' ' GlobalTableId: 0' ' table:' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' '' ' Stage: Stage-7' ' Move Operator' ' files:' ' hdfs directory: true' ' destination: file:!!{hive.exec.scratchdir}!!' '' ' Stage: Stage-0' ' Fetch Operator' ' limit: -1' '' '' 130 rows selected >>> SELECT key, value FROM src WHERE key > 80 AND key < 100 ORDER BY key; 'key','value' '82','val_82' '83','val_83' '83','val_83' '84','val_84' '84','val_84' '85','val_85' '86','val_86' '87','val_87' '90','val_90' '90','val_90' '90','val_90' '92','val_92' '95','val_95' '95','val_95' '96','val_96' '97','val_97' '97','val_97' '98','val_98' '98','val_98' 19 rows selected >>> >>> DROP INDEX src_index on src; No rows affected >>> !record