Saving all output to "!!{outputDirectory}!!/join39.q.raw". Enter "record" with no arguments to stop it.
>>>  !run !!{qFileDirectory}!!/join39.q
>>>  CREATE TABLE dest_j1(key STRING, value STRING, key1 string, val2 STRING) STORED AS TEXTFILE;
No rows affected 
>>>  
>>>  explain 
INSERT OVERWRITE TABLE dest_j1 
SELECT /*+ MAPJOIN(y) */ x.key, x.value, y.key, y.value 
FROM src x left outer JOIN (select * from src where key <= 100) y ON (x.key = y.key);
'Explain'
'ABSTRACT SYNTAX TREE:'
'  (TOK_QUERY (TOK_FROM (TOK_LEFTOUTERJOIN (TOK_TABREF (TOK_TABNAME src) x) (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_ALLCOLREF)) (TOK_WHERE (<= (TOK_TABLE_OR_COL key) 100)))) y) (= (. (TOK_TABLE_OR_COL x) key) (. (TOK_TABLE_OR_COL y) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest_j1))) (TOK_SELECT (TOK_HINTLIST (TOK_HINT TOK_MAPJOIN (TOK_HINTARGLIST y))) (TOK_SELEXPR (. (TOK_TABLE_OR_COL x) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL x) value)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL y) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL y) value)))))'
''
'STAGE DEPENDENCIES:'
'  Stage-9 is a root stage'
'  Stage-1 depends on stages: Stage-9'
'  Stage-7 depends on stages: Stage-1 , consists of Stage-4, Stage-3, Stage-5'
'  Stage-4'
'  Stage-0 depends on stages: Stage-4, Stage-3, Stage-6'
'  Stage-2 depends on stages: Stage-0'
'  Stage-3'
'  Stage-5'
'  Stage-6 depends on stages: Stage-5'
''
'STAGE PLANS:'
'  Stage: Stage-9'
'    Map Reduce Local Work'
'      Alias -> Map Local Tables:'
'        y:src '
'          Fetch Operator'
'            limit: -1'
'      Alias -> Map Local Operator Tree:'
'        y:src '
'          TableScan'
'            alias: src'
'            Filter Operator'
'              predicate:'
'                  expr: (key <= 100.0)'
'                  type: boolean'
'              Select Operator'
'                expressions:'
'                      expr: key'
'                      type: string'
'                      expr: value'
'                      type: string'
'                outputColumnNames: _col0, _col1'
'                HashTable Sink Operator'
'                  condition expressions:'
'                    0 {key} {value}'
'                    1 {_col0} {_col1}'
'                  handleSkewJoin: false'
'                  keys:'
'                    0 [Column[key]]'
'                    1 [Column[_col0]]'
'                  Position of Big Table: 0'
''
'  Stage: Stage-1'
'    Map Reduce'
'      Alias -> Map Operator Tree:'
'        x '
'          TableScan'
'            alias: x'
'            Map Join Operator'
'              condition map:'
'                   Left Outer Join0 to 1'
'              condition expressions:'
'                0 {key} {value}'
'                1 {_col0} {_col1}'
'              handleSkewJoin: false'
'              keys:'
'                0 [Column[key]]'
'                1 [Column[_col0]]'
'              outputColumnNames: _col0, _col1, _col4, _col5'
'              Position of Big Table: 0'
'              Select Operator'
'                expressions:'
'                      expr: _col0'
'                      type: string'
'                      expr: _col1'
'                      type: string'
'                      expr: _col4'
'                      type: string'
'                      expr: _col5'
'                      type: string'
'                outputColumnNames: _col0, _col1, _col4, _col5'
'                Select Operator'
'                  expressions:'
'                        expr: _col0'
'                        type: string'
'                        expr: _col1'
'                        type: string'
'                        expr: _col4'
'                        type: string'
'                        expr: _col5'
'                        type: string'
'                  outputColumnNames: _col0, _col1, _col2, _col3'
'                  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: join39.dest_j1'
'      Local Work:'
'        Map Reduce Local Work'
''
'  Stage: Stage-7'
'    Conditional Operator'
''
'  Stage: Stage-4'
'    Move Operator'
'      files:'
'          hdfs directory: true'
'          destination: pfile:!!{hive.exec.scratchdir}!!'
''
'  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: join39.dest_j1'
''
'  Stage: Stage-2'
'    Stats-Aggr Operator'
''
'  Stage: Stage-3'
'    Map Reduce'
'      Alias -> Map Operator Tree:'
'        pfile:!!{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'
'                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
'                  name: join39.dest_j1'
''
'  Stage: Stage-5'
'    Map Reduce'
'      Alias -> Map Operator Tree:'
'        pfile:!!{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'
'                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
'                  name: join39.dest_j1'
''
'  Stage: Stage-6'
'    Move Operator'
'      files:'
'          hdfs directory: true'
'          destination: pfile:!!{hive.exec.scratchdir}!!'
''
''
152 rows selected 
>>>  
>>>  
>>>  INSERT OVERWRITE TABLE dest_j1 
SELECT /*+ MAPJOIN(y) */ x.key, x.value, y.key, y.value 
FROM src x left outer JOIN (select * from src where key <= 100) y ON (x.key = y.key);
'key','value','key','value'
No rows selected 
>>>  
>>>  select * from dest_j1 x order by x.key;
'key','value','key1','val2'
'0','val_0','0','val_0'
'0','val_0','0','val_0'
'0','val_0','0','val_0'
'0','val_0','0','val_0'
'0','val_0','0','val_0'
'0','val_0','0','val_0'
'0','val_0','0','val_0'
'0','val_0','0','val_0'
'0','val_0','0','val_0'
'10','val_10','10','val_10'
'100','val_100','100','val_100'
'100','val_100','100','val_100'
'100','val_100','100','val_100'
'100','val_100','100','val_100'
'103','val_103','',''
'103','val_103','',''
'104','val_104','',''
'104','val_104','',''
'105','val_105','',''
'11','val_11','11','val_11'
'111','val_111','',''
'113','val_113','',''
'113','val_113','',''
'114','val_114','',''
'116','val_116','',''
'118','val_118','',''
'118','val_118','',''
'119','val_119','',''
'119','val_119','',''
'119','val_119','',''
'12','val_12','12','val_12'
'12','val_12','12','val_12'
'12','val_12','12','val_12'
'12','val_12','12','val_12'
'120','val_120','',''
'120','val_120','',''
'125','val_125','',''
'125','val_125','',''
'126','val_126','',''
'128','val_128','',''
'128','val_128','',''
'128','val_128','',''
'129','val_129','',''
'129','val_129','',''
'131','val_131','',''
'133','val_133','',''
'134','val_134','',''
'134','val_134','',''
'136','val_136','',''
'137','val_137','',''
'137','val_137','',''
'138','val_138','',''
'138','val_138','',''
'138','val_138','',''
'138','val_138','',''
'143','val_143','',''
'145','val_145','',''
'146','val_146','',''
'146','val_146','',''
'149','val_149','',''
'149','val_149','',''
'15','val_15','15','val_15'
'15','val_15','15','val_15'
'15','val_15','15','val_15'
'15','val_15','15','val_15'
'150','val_150','',''
'152','val_152','',''
'152','val_152','',''
'153','val_153','',''
'155','val_155','',''
'156','val_156','',''
'157','val_157','',''
'158','val_158','',''
'160','val_160','',''
'162','val_162','',''
'163','val_163','',''
'164','val_164','',''
'164','val_164','',''
'165','val_165','',''
'165','val_165','',''
'166','val_166','',''
'167','val_167','',''
'167','val_167','',''
'167','val_167','',''
'168','val_168','',''
'169','val_169','',''
'169','val_169','',''
'169','val_169','',''
'169','val_169','',''
'17','val_17','17','val_17'
'170','val_170','',''
'172','val_172','',''
'172','val_172','',''
'174','val_174','',''
'174','val_174','',''
'175','val_175','',''
'175','val_175','',''
'176','val_176','',''
'176','val_176','',''
'177','val_177','',''
'178','val_178','',''
'179','val_179','',''
'179','val_179','',''
'18','val_18','18','val_18'
'18','val_18','18','val_18'
'18','val_18','18','val_18'
'18','val_18','18','val_18'
'180','val_180','',''
'181','val_181','',''
'183','val_183','',''
'186','val_186','',''
'187','val_187','',''
'187','val_187','',''
'187','val_187','',''
'189','val_189','',''
'19','val_19','19','val_19'
'190','val_190','',''
'191','val_191','',''
'191','val_191','',''
'192','val_192','',''
'193','val_193','',''
'193','val_193','',''
'193','val_193','',''
'194','val_194','',''
'195','val_195','',''
'195','val_195','',''
'196','val_196','',''
'197','val_197','',''
'197','val_197','',''
'199','val_199','',''
'199','val_199','',''
'199','val_199','',''
'2','val_2','2','val_2'
'20','val_20','20','val_20'
'200','val_200','',''
'200','val_200','',''
'201','val_201','',''
'202','val_202','',''
'203','val_203','',''
'203','val_203','',''
'205','val_205','',''
'205','val_205','',''
'207','val_207','',''
'207','val_207','',''
'208','val_208','',''
'208','val_208','',''
'208','val_208','',''
'209','val_209','',''
'209','val_209','',''
'213','val_213','',''
'213','val_213','',''
'214','val_214','',''
'216','val_216','',''
'216','val_216','',''
'217','val_217','',''
'217','val_217','',''
'218','val_218','',''
'219','val_219','',''
'219','val_219','',''
'221','val_221','',''
'221','val_221','',''
'222','val_222','',''
'223','val_223','',''
'223','val_223','',''
'224','val_224','',''
'224','val_224','',''
'226','val_226','',''
'228','val_228','',''
'229','val_229','',''
'229','val_229','',''
'230','val_230','',''
'230','val_230','',''
'230','val_230','',''
'230','val_230','',''
'230','val_230','',''
'233','val_233','',''
'233','val_233','',''
'235','val_235','',''
'237','val_237','',''
'237','val_237','',''
'238','val_238','',''
'238','val_238','',''
'239','val_239','',''
'239','val_239','',''
'24','val_24','24','val_24'
'24','val_24','24','val_24'
'24','val_24','24','val_24'
'24','val_24','24','val_24'
'241','val_241','',''
'242','val_242','',''
'242','val_242','',''
'244','val_244','',''
'247','val_247','',''
'248','val_248','',''
'249','val_249','',''
'252','val_252','',''
'255','val_255','',''
'255','val_255','',''
'256','val_256','',''
'256','val_256','',''
'257','val_257','',''
'258','val_258','',''
'26','val_26','26','val_26'
'26','val_26','26','val_26'
'26','val_26','26','val_26'
'26','val_26','26','val_26'
'260','val_260','',''
'262','val_262','',''
'263','val_263','',''
'265','val_265','',''
'265','val_265','',''
'266','val_266','',''
'27','val_27','27','val_27'
'272','val_272','',''
'272','val_272','',''
'273','val_273','',''
'273','val_273','',''
'273','val_273','',''
'274','val_274','',''
'275','val_275','',''
'277','val_277','',''
'277','val_277','',''
'277','val_277','',''
'277','val_277','',''
'278','val_278','',''
'278','val_278','',''
'28','val_28','28','val_28'
'280','val_280','',''
'280','val_280','',''
'281','val_281','',''
'281','val_281','',''
'282','val_282','',''
'282','val_282','',''
'283','val_283','',''
'284','val_284','',''
'285','val_285','',''
'286','val_286','',''
'287','val_287','',''
'288','val_288','',''
'288','val_288','',''
'289','val_289','',''
'291','val_291','',''
'292','val_292','',''
'296','val_296','',''
'298','val_298','',''
'298','val_298','',''
'298','val_298','',''
'30','val_30','30','val_30'
'302','val_302','',''
'305','val_305','',''
'306','val_306','',''
'307','val_307','',''
'307','val_307','',''
'308','val_308','',''
'309','val_309','',''
'309','val_309','',''
'310','val_310','',''
'311','val_311','',''
'311','val_311','',''
'311','val_311','',''
'315','val_315','',''
'316','val_316','',''
'316','val_316','',''
'316','val_316','',''
'317','val_317','',''
'317','val_317','',''
'318','val_318','',''
'318','val_318','',''
'318','val_318','',''
'321','val_321','',''
'321','val_321','',''
'322','val_322','',''
'322','val_322','',''
'323','val_323','',''
'325','val_325','',''
'325','val_325','',''
'327','val_327','',''
'327','val_327','',''
'327','val_327','',''
'33','val_33','33','val_33'
'331','val_331','',''
'331','val_331','',''
'332','val_332','',''
'333','val_333','',''
'333','val_333','',''
'335','val_335','',''
'336','val_336','',''
'338','val_338','',''
'339','val_339','',''
'34','val_34','34','val_34'
'341','val_341','',''
'342','val_342','',''
'342','val_342','',''
'344','val_344','',''
'344','val_344','',''
'345','val_345','',''
'348','val_348','',''
'348','val_348','',''
'348','val_348','',''
'348','val_348','',''
'348','val_348','',''
'35','val_35','35','val_35'
'35','val_35','35','val_35'
'35','val_35','35','val_35'
'35','val_35','35','val_35'
'35','val_35','35','val_35'
'35','val_35','35','val_35'
'35','val_35','35','val_35'
'35','val_35','35','val_35'
'35','val_35','35','val_35'
'351','val_351','',''
'353','val_353','',''
'353','val_353','',''
'356','val_356','',''
'360','val_360','',''
'362','val_362','',''
'364','val_364','',''
'365','val_365','',''
'366','val_366','',''
'367','val_367','',''
'367','val_367','',''
'368','val_368','',''
'369','val_369','',''
'369','val_369','',''
'369','val_369','',''
'37','val_37','37','val_37'
'37','val_37','37','val_37'
'37','val_37','37','val_37'
'37','val_37','37','val_37'
'373','val_373','',''
'374','val_374','',''
'375','val_375','',''
'377','val_377','',''
'378','val_378','',''
'379','val_379','',''
'382','val_382','',''
'382','val_382','',''
'384','val_384','',''
'384','val_384','',''
'384','val_384','',''
'386','val_386','',''
'389','val_389','',''
'392','val_392','',''
'393','val_393','',''
'394','val_394','',''
'395','val_395','',''
'395','val_395','',''
'396','val_396','',''
'396','val_396','',''
'396','val_396','',''
'397','val_397','',''
'397','val_397','',''
'399','val_399','',''
'399','val_399','',''
'4','val_4','4','val_4'
'400','val_400','',''
'401','val_401','',''
'401','val_401','',''
'401','val_401','',''
'401','val_401','',''
'401','val_401','',''
'402','val_402','',''
'403','val_403','',''
'403','val_403','',''
'403','val_403','',''
'404','val_404','',''
'404','val_404','',''
'406','val_406','',''
'406','val_406','',''
'406','val_406','',''
'406','val_406','',''
'407','val_407','',''
'409','val_409','',''
'409','val_409','',''
'409','val_409','',''
'41','val_41','41','val_41'
'411','val_411','',''
'413','val_413','',''
'413','val_413','',''
'414','val_414','',''
'414','val_414','',''
'417','val_417','',''
'417','val_417','',''
'417','val_417','',''
'418','val_418','',''
'419','val_419','',''
'42','val_42','42','val_42'
'42','val_42','42','val_42'
'42','val_42','42','val_42'
'42','val_42','42','val_42'
'421','val_421','',''
'424','val_424','',''
'424','val_424','',''
'427','val_427','',''
'429','val_429','',''
'429','val_429','',''
'43','val_43','43','val_43'
'430','val_430','',''
'430','val_430','',''
'430','val_430','',''
'431','val_431','',''
'431','val_431','',''
'431','val_431','',''
'432','val_432','',''
'435','val_435','',''
'436','val_436','',''
'437','val_437','',''
'438','val_438','',''
'438','val_438','',''
'438','val_438','',''
'439','val_439','',''
'439','val_439','',''
'44','val_44','44','val_44'
'443','val_443','',''
'444','val_444','',''
'446','val_446','',''
'448','val_448','',''
'449','val_449','',''
'452','val_452','',''
'453','val_453','',''
'454','val_454','',''
'454','val_454','',''
'454','val_454','',''
'455','val_455','',''
'457','val_457','',''
'458','val_458','',''
'458','val_458','',''
'459','val_459','',''
'459','val_459','',''
'460','val_460','',''
'462','val_462','',''
'462','val_462','',''
'463','val_463','',''
'463','val_463','',''
'466','val_466','',''
'466','val_466','',''
'466','val_466','',''
'467','val_467','',''
'468','val_468','',''
'468','val_468','',''
'468','val_468','',''
'468','val_468','',''
'469','val_469','',''
'469','val_469','',''
'469','val_469','',''
'469','val_469','',''
'469','val_469','',''
'47','val_47','47','val_47'
'470','val_470','',''
'472','val_472','',''
'475','val_475','',''
'477','val_477','',''
'478','val_478','',''
'478','val_478','',''
'479','val_479','',''
'480','val_480','',''
'480','val_480','',''
'480','val_480','',''
'481','val_481','',''
'482','val_482','',''
'483','val_483','',''
'484','val_484','',''
'485','val_485','',''
'487','val_487','',''
'489','val_489','',''
'489','val_489','',''
'489','val_489','',''
'489','val_489','',''
'490','val_490','',''
'491','val_491','',''
'492','val_492','',''
'492','val_492','',''
'493','val_493','',''
'494','val_494','',''
'495','val_495','',''
'496','val_496','',''
'497','val_497','',''
'498','val_498','',''
'498','val_498','',''
'498','val_498','',''
'5','val_5','5','val_5'
'5','val_5','5','val_5'
'5','val_5','5','val_5'
'5','val_5','5','val_5'
'5','val_5','5','val_5'
'5','val_5','5','val_5'
'5','val_5','5','val_5'
'5','val_5','5','val_5'
'5','val_5','5','val_5'
'51','val_51','51','val_51'
'51','val_51','51','val_51'
'51','val_51','51','val_51'
'51','val_51','51','val_51'
'53','val_53','53','val_53'
'54','val_54','54','val_54'
'57','val_57','57','val_57'
'58','val_58','58','val_58'
'58','val_58','58','val_58'
'58','val_58','58','val_58'
'58','val_58','58','val_58'
'64','val_64','64','val_64'
'65','val_65','65','val_65'
'66','val_66','66','val_66'
'67','val_67','67','val_67'
'67','val_67','67','val_67'
'67','val_67','67','val_67'
'67','val_67','67','val_67'
'69','val_69','69','val_69'
'70','val_70','70','val_70'
'70','val_70','70','val_70'
'70','val_70','70','val_70'
'70','val_70','70','val_70'
'70','val_70','70','val_70'
'70','val_70','70','val_70'
'70','val_70','70','val_70'
'70','val_70','70','val_70'
'70','val_70','70','val_70'
'72','val_72','72','val_72'
'72','val_72','72','val_72'
'72','val_72','72','val_72'
'72','val_72','72','val_72'
'74','val_74','74','val_74'
'76','val_76','76','val_76'
'76','val_76','76','val_76'
'76','val_76','76','val_76'
'76','val_76','76','val_76'
'77','val_77','77','val_77'
'78','val_78','78','val_78'
'8','val_8','8','val_8'
'80','val_80','80','val_80'
'82','val_82','82','val_82'
'83','val_83','83','val_83'
'83','val_83','83','val_83'
'83','val_83','83','val_83'
'83','val_83','83','val_83'
'84','val_84','84','val_84'
'84','val_84','84','val_84'
'84','val_84','84','val_84'
'84','val_84','84','val_84'
'85','val_85','85','val_85'
'86','val_86','86','val_86'
'87','val_87','87','val_87'
'9','val_9','9','val_9'
'90','val_90','90','val_90'
'90','val_90','90','val_90'
'90','val_90','90','val_90'
'90','val_90','90','val_90'
'90','val_90','90','val_90'
'90','val_90','90','val_90'
'90','val_90','90','val_90'
'90','val_90','90','val_90'
'90','val_90','90','val_90'
'92','val_92','92','val_92'
'95','val_95','95','val_95'
'95','val_95','95','val_95'
'95','val_95','95','val_95'
'95','val_95','95','val_95'
'96','val_96','96','val_96'
'97','val_97','97','val_97'
'97','val_97','97','val_97'
'97','val_97','97','val_97'
'97','val_97','97','val_97'
'98','val_98','98','val_98'
'98','val_98','98','val_98'
'98','val_98','98','val_98'
'98','val_98','98','val_98'
566 rows selected 
>>>  
>>>  
>>>  
>>>  !record