Saving all output to "!!{outputDirectory}!!/input32.q.raw". Enter "record" with no arguments to stop it. >>> !run !!{qFileDirectory}!!/input32.q >>> >>> >>> >>> set hive.test.mode=true; No rows affected >>> set hive.test.mode.prefix=tst_; No rows affected >>> set hive.test.mode.nosamplelist=src,srcbucket; No rows affected >>> >>> create table dest32(a int); No rows affected >>> create table tst_dest32(a int); No rows affected >>> >>> explain insert overwrite table dest32 select count(1) from srcbucket; 'Explain' 'ABSTRACT SYNTAX TREE:' ' (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME srcbucket))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest32))) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION count 1)))))' '' 'STAGE DEPENDENCIES:' ' Stage-1 is a root stage' ' Stage-0 depends on stages: Stage-1' ' Stage-2 depends on stages: Stage-0' '' 'STAGE PLANS:' ' Stage: Stage-1' ' Map Reduce' ' Alias -> Map Operator Tree:' ' srcbucket ' ' TableScan' ' alias: srcbucket' ' Select Operator' ' Group By Operator' ' aggregations:' ' expr: count(1)' ' bucketGroup: false' ' mode: hash' ' outputColumnNames: _col0' ' Reduce Output Operator' ' sort order: ' ' tag: -1' ' value expressions:' ' expr: _col0' ' type: bigint' ' Reduce Operator Tree:' ' Group By Operator' ' aggregations:' ' expr: count(VALUE._col0)' ' bucketGroup: false' ' mode: mergepartial' ' outputColumnNames: _col0' ' Select Operator' ' expressions:' ' expr: _col0' ' type: bigint' ' outputColumnNames: _col0' ' Select Operator' ' expressions:' ' expr: UDFToInteger(_col0)' ' type: int' ' outputColumnNames: _col0' ' File Output Operator' ' compressed: false' ' GlobalTableId: 1' ' table:' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' name: input32.tst_dest32' '' ' Stage: Stage-0' ' Move Operator' ' tables:' ' replace: true' ' table:' ' input format: org.apache.hadoop.mapred.TextInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' ' serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' ' name: input32.tst_dest32' '' ' Stage: Stage-2' ' Stats-Aggr Operator' '' '' 68 rows selected >>> >>> insert overwrite table dest32 select count(1) from srcbucket; '_col0' No rows selected >>> >>> set hive.test.mode=false; No rows affected >>> >>> select * from tst_dest32; 'a' '1000' 1 row selected >>> >>> >>> >>> >>> >>> !record