Saving all output to "!!{outputDirectory}!!/ppd1.q.raw". Enter "record" with no arguments to stop it.
>>>  !run !!{qFileDirectory}!!/ppd1.q
>>>  set hive.optimize.ppd=true;
No rows affected 
>>>  set hive.ppd.remove.duplicatefilters=false;
No rows affected 
>>>  
>>>  EXPLAIN 
SELECT src.key as c3 from src where src.key > '2';
'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 src) key) c3)) (TOK_WHERE (> (. (TOK_TABLE_OR_COL src) key) '2'))))'
''
'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:'
'        src '
'          TableScan'
'            alias: src'
'            Filter Operator'
'              predicate:'
'                  expr: (key > '2')'
'                  type: boolean'
'              Filter Operator'
'                predicate:'
'                    expr: (key > '2')'
'                    type: boolean'
'                Select Operator'
'                  expressions:'
'                        expr: key'
'                        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'
''
''
39 rows selected 
>>>  
>>>  SELECT src.key as c3 from src where src.key > '2';
'c3'
'238'
'86'
'311'
'27'
'409'
'255'
'278'
'98'
'484'
'265'
'401'
'273'
'224'
'369'
'66'
'213'
'406'
'429'
'374'
'469'
'495'
'37'
'327'
'281'
'277'
'209'
'82'
'403'
'417'
'430'
'252'
'292'
'219'
'287'
'338'
'446'
'459'
'394'
'237'
'482'
'413'
'494'
'207'
'466'
'208'
'399'
'396'
'247'
'417'
'489'
'377'
'397'
'309'
'365'
'266'
'439'
'342'
'367'
'325'
'475'
'203'
'339'
'455'
'311'
'316'
'57'
'302'
'205'
'438'
'345'
'20'
'489'
'378'
'221'
'92'
'47'
'72'
'4'
'280'
'35'
'427'
'277'
'208'
'356'
'399'
'382'
'498'
'386'
'437'
'469'
'286'
'54'
'459'
'51'
'239'
'213'
'216'
'430'
'278'
'289'
'221'
'65'
'318'
'332'
'311'
'275'
'241'
'83'
'333'
'284'
'230'
'67'
'260'
'404'
'384'
'489'
'353'
'373'
'272'
'217'
'84'
'348'
'466'
'58'
'8'
'411'
'230'
'208'
'348'
'24'
'463'
'431'
'42'
'496'
'322'
'468'
'393'
'454'
'298'
'418'
'96'
'26'
'327'
'230'
'205'
'51'
'404'
'43'
'436'
'469'
'468'
'308'
'95'
'288'
'481'
'457'
'98'
'282'
'318'
'318'
'409'
'470'
'369'
'316'
'413'
'85'
'77'
'490'
'87'
'364'
'395'
'282'
'238'
'419'
'72'
'90'
'307'
'435'
'277'
'273'
'306'
'224'
'309'
'389'
'327'
'242'
'369'
'392'
'272'
'331'
'401'
'242'
'452'
'226'
'5'
'497'
'402'
'396'
'317'
'395'
'58'
'35'
'336'
'95'
'34'
'229'
'233'
'472'
'322'
'498'
'42'
'321'
'430'
'489'
'458'
'78'
'76'
'41'
'223'
'492'
'449'
'218'
'228'
'453'
'30'
'209'
'64'
'468'
'76'
'74'
'342'
'69'
'230'
'33'
'368'
'296'
'216'
'367'
'344'
'274'
'219'
'239'
'485'
'223'
'256'
'263'
'70'
'487'
'480'
'401'
'288'
'5'
'244'
'438'
'467'
'432'
'202'
'316'
'229'
'469'
'463'
'280'
'35'
'283'
'331'
'235'
'80'
'44'
'321'
'335'
'466'
'366'
'403'
'483'
'53'
'257'
'406'
'409'
'406'
'401'
'258'
'90'
'203'
'262'
'348'
'424'
'396'
'201'
'217'
'431'
'454'
'478'
'298'
'431'
'424'
'382'
'5'
'70'
'397'
'480'
'291'
'24'
'351'
'255'
'70'
'438'
'414'
'200'
'491'
'237'
'439'
'360'
'248'
'479'
'305'
'417'
'444'
'429'
'443'
'323'
'325'
'277'
'230'
'478'
'468'
'310'
'317'
'333'
'493'
'460'
'207'
'249'
'265'
'480'
'83'
'353'
'214'
'462'
'233'
'406'
'454'
'375'
'401'
'421'
'407'
'384'
'256'
'26'
'67'
'384'
'379'
'462'
'492'
'298'
'9'
'341'
'498'
'458'
'362'
'285'
'348'
'273'
'281'
'344'
'97'
'469'
'315'
'84'
'28'
'37'
'448'
'348'
'307'
'414'
'477'
'222'
'90'
'403'
'400'
'200'
'97'
381 rows selected 
>>>  
>>>  set hive.ppd.remove.duplicatefilters=true;
No rows affected 
>>>  
>>>  EXPLAIN 
SELECT src.key as c3 from src where src.key > '2';
'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 src) key) c3)) (TOK_WHERE (> (. (TOK_TABLE_OR_COL src) key) '2'))))'
''
'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:'
'        src '
'          TableScan'
'            alias: src'
'            Filter Operator'
'              predicate:'
'                  expr: (key > '2')'
'                  type: boolean'
'              Select Operator'
'                expressions:'
'                      expr: key'
'                      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'
''
''
35 rows selected 
>>>  
>>>  SELECT src.key as c3 from src where src.key > '2';
'c3'
'238'
'86'
'311'
'27'
'409'
'255'
'278'
'98'
'484'
'265'
'401'
'273'
'224'
'369'
'66'
'213'
'406'
'429'
'374'
'469'
'495'
'37'
'327'
'281'
'277'
'209'
'82'
'403'
'417'
'430'
'252'
'292'
'219'
'287'
'338'
'446'
'459'
'394'
'237'
'482'
'413'
'494'
'207'
'466'
'208'
'399'
'396'
'247'
'417'
'489'
'377'
'397'
'309'
'365'
'266'
'439'
'342'
'367'
'325'
'475'
'203'
'339'
'455'
'311'
'316'
'57'
'302'
'205'
'438'
'345'
'20'
'489'
'378'
'221'
'92'
'47'
'72'
'4'
'280'
'35'
'427'
'277'
'208'
'356'
'399'
'382'
'498'
'386'
'437'
'469'
'286'
'54'
'459'
'51'
'239'
'213'
'216'
'430'
'278'
'289'
'221'
'65'
'318'
'332'
'311'
'275'
'241'
'83'
'333'
'284'
'230'
'67'
'260'
'404'
'384'
'489'
'353'
'373'
'272'
'217'
'84'
'348'
'466'
'58'
'8'
'411'
'230'
'208'
'348'
'24'
'463'
'431'
'42'
'496'
'322'
'468'
'393'
'454'
'298'
'418'
'96'
'26'
'327'
'230'
'205'
'51'
'404'
'43'
'436'
'469'
'468'
'308'
'95'
'288'
'481'
'457'
'98'
'282'
'318'
'318'
'409'
'470'
'369'
'316'
'413'
'85'
'77'
'490'
'87'
'364'
'395'
'282'
'238'
'419'
'72'
'90'
'307'
'435'
'277'
'273'
'306'
'224'
'309'
'389'
'327'
'242'
'369'
'392'
'272'
'331'
'401'
'242'
'452'
'226'
'5'
'497'
'402'
'396'
'317'
'395'
'58'
'35'
'336'
'95'
'34'
'229'
'233'
'472'
'322'
'498'
'42'
'321'
'430'
'489'
'458'
'78'
'76'
'41'
'223'
'492'
'449'
'218'
'228'
'453'
'30'
'209'
'64'
'468'
'76'
'74'
'342'
'69'
'230'
'33'
'368'
'296'
'216'
'367'
'344'
'274'
'219'
'239'
'485'
'223'
'256'
'263'
'70'
'487'
'480'
'401'
'288'
'5'
'244'
'438'
'467'
'432'
'202'
'316'
'229'
'469'
'463'
'280'
'35'
'283'
'331'
'235'
'80'
'44'
'321'
'335'
'466'
'366'
'403'
'483'
'53'
'257'
'406'
'409'
'406'
'401'
'258'
'90'
'203'
'262'
'348'
'424'
'396'
'201'
'217'
'431'
'454'
'478'
'298'
'431'
'424'
'382'
'5'
'70'
'397'
'480'
'291'
'24'
'351'
'255'
'70'
'438'
'414'
'200'
'491'
'237'
'439'
'360'
'248'
'479'
'305'
'417'
'444'
'429'
'443'
'323'
'325'
'277'
'230'
'478'
'468'
'310'
'317'
'333'
'493'
'460'
'207'
'249'
'265'
'480'
'83'
'353'
'214'
'462'
'233'
'406'
'454'
'375'
'401'
'421'
'407'
'384'
'256'
'26'
'67'
'384'
'379'
'462'
'492'
'298'
'9'
'341'
'498'
'458'
'362'
'285'
'348'
'273'
'281'
'344'
'97'
'469'
'315'
'84'
'28'
'37'
'448'
'348'
'307'
'414'
'477'
'222'
'90'
'403'
'400'
'200'
'97'
381 rows selected 
>>>  !record