Saving all output to "!!{outputDirectory}!!/noalias_subq1.q.raw". Enter "record" with no arguments to stop it. >>> !run !!{qFileDirectory}!!/noalias_subq1.q >>> EXPLAIN SELECT c1 FROM (select value as c1, key as c2 from src) x where c2 < 100; 'Explain' 'ABSTRACT SYNTAX TREE:' ' (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (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 value) c1) (TOK_SELEXPR (TOK_TABLE_OR_COL key) c2)))) x)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL c1))) (TOK_WHERE (< (TOK_TABLE_OR_COL c2) 100))))' '' 'STAGE DEPENDENCIES:' ' Stage-1 is a root stage' ' Stage-0 is a root stage' '' 'STAGE PLANS:' ' Stage: Stage-1' ' Map Reduce' ' Alias -> Map Operator Tree:' ' x:src ' ' TableScan' ' alias: src' ' Filter Operator' ' predicate:' ' expr: (key < 100.0)' ' type: boolean' ' Select Operator' ' expressions:' ' expr: value' ' type: string' ' expr: key' ' type: string' ' outputColumnNames: _col0, _col1' ' Select Operator' ' expressions:' ' expr: _col0' ' type: string' ' outputColumnNames: _col0' ' 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-0' ' Fetch Operator' ' limit: -1' '' '' 42 rows selected >>> >>> SELECT c1 FROM (select value as c1, key as c2 from src) x where c2 < 100; 'c1' 'val_86' 'val_27' 'val_98' 'val_66' 'val_37' 'val_15' 'val_82' 'val_17' 'val_0' 'val_57' 'val_20' 'val_92' 'val_47' 'val_72' 'val_4' 'val_35' 'val_54' 'val_51' 'val_65' 'val_83' 'val_12' 'val_67' 'val_84' 'val_58' 'val_8' 'val_24' 'val_42' 'val_0' 'val_96' 'val_26' 'val_51' 'val_43' 'val_95' 'val_98' 'val_85' 'val_77' 'val_0' 'val_87' 'val_15' 'val_72' 'val_90' 'val_19' 'val_10' 'val_5' 'val_58' 'val_35' 'val_95' 'val_11' 'val_34' 'val_42' 'val_78' 'val_76' 'val_41' 'val_30' 'val_64' 'val_76' 'val_74' 'val_69' 'val_33' 'val_70' 'val_5' 'val_2' 'val_35' 'val_80' 'val_44' 'val_53' 'val_90' 'val_12' 'val_5' 'val_70' 'val_24' 'val_70' 'val_83' 'val_26' 'val_67' 'val_18' 'val_9' 'val_18' 'val_97' 'val_84' 'val_28' 'val_37' 'val_90' 'val_97' 84 rows selected >>> >>> !record