Saving all output to "!!{outputDirectory}!!/nullscript.q.raw". Enter "record" with no arguments to stop it.
>>>  !run !!{qFileDirectory}!!/nullscript.q
>>>  
>>>  CREATE TABLE nullscript(KEY STRING, VALUE STRING) STORED AS TEXTFILE;
No rows affected 
>>>  LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE nullscript;
No rows affected 
>>>  LOAD DATA LOCAL INPATH '../data/files/nullfile.txt' INTO TABLE nullscript;
No rows affected 
>>>  explain 
select transform(key) using 'cat' as key1 from nullscript;
'Explain'
'ABSTRACT SYNTAX TREE:'
'  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME nullscript))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_EXPLIST (TOK_TABLE_OR_COL key)) TOK_SERDE TOK_RECORDWRITER 'cat' TOK_SERDE TOK_RECORDREADER (TOK_ALIASLIST key1))))))'
''
'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:'
'        nullscript '
'          TableScan'
'            alias: nullscript'
'            Select Operator'
'              expressions:'
'                    expr: key'
'                    type: string'
'              outputColumnNames: _col0'
'              Transform Operator'
'                command: cat'
'                output info:'
'                    input format: org.apache.hadoop.mapred.TextInputFormat'
'                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
'                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'
''
''
36 rows selected 
>>>  select transform(key) using 'cat' as key1 from nullscript;
'key1'
'238'
'86'
'311'
'27'
'165'
'409'
'255'
'278'
'98'
'484'
'265'
'193'
'401'
'150'
'273'
'224'
'369'
'66'
'128'
'213'
'146'
'406'
'429'
'374'
'152'
'469'
'145'
'495'
'37'
'327'
'281'
'277'
'209'
'15'
'82'
'403'
'166'
'417'
'430'
'252'
'292'
'219'
'287'
'153'
'193'
'338'
'446'
'459'
'394'
'237'
'482'
'174'
'413'
'494'
'207'
'199'
'466'
'208'
'174'
'399'
'396'
'247'
'417'
'489'
'162'
'377'
'397'
'309'
'365'
'266'
'439'
'342'
'367'
'325'
'167'
'195'
'475'
'17'
'113'
'155'
'203'
'339'
'0'
'455'
'128'
'311'
'316'
'57'
'302'
'205'
'149'
'438'
'345'
'129'
'170'
'20'
'489'
'157'
'378'
'221'
'92'
'111'
'47'
'72'
'4'
'280'
'35'
'427'
'277'
'208'
'356'
'399'
'169'
'382'
'498'
'125'
'386'
'437'
'469'
'192'
'286'
'187'
'176'
'54'
'459'
'51'
'138'
'103'
'239'
'213'
'216'
'430'
'278'
'176'
'289'
'221'
'65'
'318'
'332'
'311'
'275'
'137'
'241'
'83'
'333'
'180'
'284'
'12'
'230'
'181'
'67'
'260'
'404'
'384'
'489'
'353'
'373'
'272'
'138'
'217'
'84'
'348'
'466'
'58'
'8'
'411'
'230'
'208'
'348'
'24'
'463'
'431'
'179'
'172'
'42'
'129'
'158'
'119'
'496'
'0'
'322'
'197'
'468'
'393'
'454'
'100'
'298'
'199'
'191'
'418'
'96'
'26'
'165'
'327'
'230'
'205'
'120'
'131'
'51'
'404'
'43'
'436'
'156'
'469'
'468'
'308'
'95'
'196'
'288'
'481'
'457'
'98'
'282'
'197'
'187'
'318'
'318'
'409'
'470'
'137'
'369'
'316'
'169'
'413'
'85'
'77'
'0'
'490'
'87'
'364'
'179'
'118'
'134'
'395'
'282'
'138'
'238'
'419'
'15'
'118'
'72'
'90'
'307'
'19'
'435'
'10'
'277'
'273'
'306'
'224'
'309'
'389'
'327'
'242'
'369'
'392'
'272'
'331'
'401'
'242'
'452'
'177'
'226'
'5'
'497'
'402'
'396'
'317'
'395'
'58'
'35'
'336'
'95'
'11'
'168'
'34'
'229'
'233'
'143'
'472'
'322'
'498'
'160'
'195'
'42'
'321'
'430'
'119'
'489'
'458'
'78'
'76'
'41'
'223'
'492'
'149'
'449'
'218'
'228'
'138'
'453'
'30'
'209'
'64'
'468'
'76'
'74'
'342'
'69'
'230'
'33'
'368'
'103'
'296'
'113'
'216'
'367'
'344'
'167'
'274'
'219'
'239'
'485'
'116'
'223'
'256'
'263'
'70'
'487'
'480'
'401'
'288'
'191'
'5'
'244'
'438'
'128'
'467'
'432'
'202'
'316'
'229'
'469'
'463'
'280'
'2'
'35'
'283'
'331'
'235'
'80'
'44'
'193'
'321'
'335'
'104'
'466'
'366'
'175'
'403'
'483'
'53'
'105'
'257'
'406'
'409'
'190'
'406'
'401'
'114'
'258'
'90'
'203'
'262'
'348'
'424'
'12'
'396'
'201'
'217'
'164'
'431'
'454'
'478'
'298'
'125'
'431'
'164'
'424'
'187'
'382'
'5'
'70'
'397'
'480'
'291'
'24'
'351'
'255'
'104'
'70'
'163'
'438'
'119'
'414'
'200'
'491'
'237'
'439'
'360'
'248'
'479'
'305'
'417'
'199'
'444'
'120'
'429'
'169'
'443'
'323'
'325'
'277'
'230'
'478'
'178'
'468'
'310'
'317'
'333'
'493'
'460'
'207'
'249'
'265'
'480'
'83'
'136'
'353'
'172'
'214'
'462'
'233'
'406'
'133'
'175'
'189'
'454'
'375'
'401'
'421'
'407'
'384'
'256'
'26'
'134'
'67'
'384'
'379'
'18'
'462'
'492'
'100'
'298'
'9'
'341'
'498'
'146'
'458'
'362'
'186'
'285'
'348'
'167'
'18'
'273'
'183'
'281'
'344'
'97'
'469'
'315'
'84'
'28'
'37'
'448'
'152'
'348'
'307'
'194'
'414'
'477'
'222'
'126'
'90'
'169'
'403'
'400'
'200'
'97'
500 rows selected 
>>>  
>>>  
>>>  
>>>  !record