Saving all output to "!!{outputDirectory}!!/auto_join29.q.raw". Enter "record" with no arguments to stop it. >>> !run !!{qFileDirectory}!!/auto_join29.q >>> set hive.auto.convert.join = true; No rows affected >>> explain SELECT * FROM src src1 LEFT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) RIGHT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value; 'Explain' 'ABSTRACT SYNTAX TREE:' ' (TOK_QUERY (TOK_FROM (TOK_RIGHTOUTERJOIN (TOK_LEFTOUTERJOIN (TOK_TABREF (TOK_TABNAME src) src1) (TOK_TABREF (TOK_TABNAME src) src2) (AND (AND (= (. (TOK_TABLE_OR_COL src1) key) (. (TOK_TABLE_OR_COL src2) key)) (< (. (TOK_TABLE_OR_COL src1) key) 10)) (> (. (TOK_TABLE_OR_COL src2) key) 10))) (TOK_TABREF (TOK_TABNAME src) src3) (AND (= (. (TOK_TABLE_OR_COL src2) key) (. (TOK_TABLE_OR_COL src3) key)) (< (. (TOK_TABLE_OR_COL src3) key) 10)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_SORTBY (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src1) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src1) value)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src2) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src2) value)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src3) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src3) value)))))' '' 'STAGE DEPENDENCIES:' ' Stage-6 is a root stage , consists of Stage-7, Stage-1' ' Stage-7 has a backup stage: Stage-1' ' Stage-5 depends on stages: Stage-7' ' Stage-2 depends on stages: Stage-1, Stage-5' ' Stage-1' ' Stage-0 is a root stage' '' 'STAGE PLANS:' ' Stage: Stage-6' ' Conditional Operator' '' ' Stage: Stage-7' ' Map Reduce Local Work' ' Alias -> Map Local Tables:' ' src1 ' ' Fetch Operator' ' limit: -1' ' src2 ' ' Fetch Operator' ' limit: -1' ' Alias -> Map Local Operator Tree:' ' src1 ' ' TableScan' ' alias: src1' ' HashTable Sink Operator' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' filter predicates:' ' 0 {(key < 10)}' ' 1 ' ' 2 {(key < 10)}' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' Position of Big Table: 2' ' src2 ' ' TableScan' ' alias: src2' ' Filter Operator' ' predicate:' ' expr: (key > 10)' ' type: boolean' ' HashTable Sink Operator' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' filter predicates:' ' 0 {(key < 10)}' ' 1 ' ' 2 {(key < 10)}' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' Position of Big Table: 2' '' ' Stage: Stage-5' ' Map Reduce' ' Alias -> Map Operator Tree:' ' src3 ' ' TableScan' ' alias: src3' ' Map Join Operator' ' condition map:' ' Left Outer Join0 to 1' ' Right Outer Join1 to 2' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' filter predicates:' ' 0 {(key < 10)}' ' 1 ' ' 2 {(key < 10)}' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9' ' Position of Big Table: 2' ' Select Operator' ' expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' expr: _col8' ' type: string' ' expr: _col9' ' type: string' ' outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5' ' File Output Operator' ' compressed: false' ' GlobalTableId: 0' ' table:' ' input format: org.apache.hadoop.mapred.SequenceFileInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat' ' Local Work:' ' Map Reduce Local Work' '' ' Stage: Stage-2' ' Map Reduce' ' Alias -> Map Operator Tree:' ' file:!!{hive.exec.scratchdir}!! ' ' Reduce Output Operator' ' key expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col2' ' type: string' ' expr: _col3' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' sort order: ++++++' ' tag: -1' ' value expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col2' ' type: string' ' expr: _col3' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' Reduce Operator Tree:' ' Extract' ' 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-1' ' Map Reduce' ' Alias -> Map Operator Tree:' ' src1 ' ' TableScan' ' alias: src1' ' Reduce Output Operator' ' key expressions:' ' expr: key' ' type: string' ' sort order: +' ' Map-reduce partition columns:' ' expr: key' ' type: string' ' tag: 0' ' value expressions:' ' expr: key' ' type: string' ' expr: value' ' type: string' ' src2 ' ' TableScan' ' alias: src2' ' Filter Operator' ' predicate:' ' expr: (key > 10)' ' type: boolean' ' Reduce Output Operator' ' key expressions:' ' expr: key' ' type: string' ' sort order: +' ' Map-reduce partition columns:' ' expr: key' ' type: string' ' tag: 1' ' value expressions:' ' expr: key' ' type: string' ' expr: value' ' type: string' ' src3 ' ' TableScan' ' alias: src3' ' Reduce Output Operator' ' key expressions:' ' expr: key' ' type: string' ' sort order: +' ' Map-reduce partition columns:' ' expr: key' ' type: string' ' tag: 2' ' value expressions:' ' expr: key' ' type: string' ' expr: value' ' type: string' ' Reduce Operator Tree:' ' Join Operator' ' condition map:' ' Left Outer Join0 to 1' ' Right Outer Join1 to 2' ' condition expressions:' ' 0 {VALUE._col0} {VALUE._col1}' ' 1 {VALUE._col0} {VALUE._col1}' ' 2 {VALUE._col0} {VALUE._col1}' ' filter predicates:' ' 0 {(VALUE._col0 < 10)}' ' 1 ' ' 2 {(VALUE._col0 < 10)}' ' handleSkewJoin: false' ' outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9' ' Select Operator' ' expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' expr: _col8' ' type: string' ' expr: _col9' ' type: string' ' outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5' ' File Output Operator' ' compressed: false' ' GlobalTableId: 0' ' table:' ' input format: org.apache.hadoop.mapred.SequenceFileInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat' '' ' Stage: Stage-0' ' Fetch Operator' ' limit: -1' '' '' 257 rows selected >>> >>> SELECT * FROM src src1 LEFT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) RIGHT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value; 'key','value','key','value','key','value' '','','','','0','val_0' '','','','','0','val_0' '','','','','0','val_0' '','','','','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' '','','','','103','val_103' '','','','','103','val_103' '','','','','103','val_103' '','','','','103','val_103' '','','','','103','val_103' '','','','','103','val_103' '','','','','104','val_104' '','','','','104','val_104' '','','','','104','val_104' '','','','','104','val_104' '','','','','104','val_104' '','','','','104','val_104' '','','','','104','val_104' '','','','','104','val_104' '','','','','105','val_105' '','','','','11','val_11' '','','','','111','val_111' '','','','','113','val_113' '','','','','113','val_113' '','','','','113','val_113' '','','','','113','val_113' '','','','','113','val_113' '','','','','113','val_113' '','','','','113','val_113' '','','','','113','val_113' '','','','','114','val_114' '','','','','116','val_116' '','','','','118','val_118' '','','','','118','val_118' '','','','','118','val_118' '','','','','118','val_118' '','','','','118','val_118' '','','','','118','val_118' '','','','','118','val_118' '','','','','118','val_118' '','','','','119','val_119' '','','','','119','val_119' '','','','','119','val_119' '','','','','119','val_119' '','','','','119','val_119' '','','','','119','val_119' '','','','','119','val_119' '','','','','119','val_119' '','','','','119','val_119' '','','','','119','val_119' '','','','','119','val_119' '','','','','119','val_119' '','','','','119','val_119' '','','','','119','val_119' '','','','','119','val_119' '','','','','119','val_119' '','','','','119','val_119' '','','','','119','val_119' '','','','','119','val_119' '','','','','119','val_119' '','','','','119','val_119' '','','','','119','val_119' '','','','','119','val_119' '','','','','119','val_119' '','','','','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' '','','','','120','val_120' '','','','','120','val_120' '','','','','120','val_120' '','','','','120','val_120' '','','','','120','val_120' '','','','','120','val_120' '','','','','125','val_125' '','','','','125','val_125' '','','','','125','val_125' '','','','','125','val_125' '','','','','125','val_125' '','','','','125','val_125' '','','','','125','val_125' '','','','','125','val_125' '','','','','126','val_126' '','','','','128','val_128' '','','','','128','val_128' '','','','','128','val_128' '','','','','128','val_128' '','','','','128','val_128' '','','','','128','val_128' '','','','','128','val_128' '','','','','128','val_128' '','','','','128','val_128' '','','','','128','val_128' '','','','','128','val_128' '','','','','128','val_128' '','','','','128','val_128' '','','','','128','val_128' '','','','','128','val_128' '','','','','128','val_128' '','','','','128','val_128' '','','','','128','val_128' '','','','','128','val_128' '','','','','128','val_128' '','','','','128','val_128' '','','','','128','val_128' '','','','','128','val_128' '','','','','128','val_128' '','','','','128','val_128' '','','','','128','val_128' '','','','','128','val_128' '','','','','129','val_129' '','','','','129','val_129' '','','','','129','val_129' '','','','','129','val_129' '','','','','129','val_129' '','','','','129','val_129' '','','','','129','val_129' '','','','','129','val_129' '','','','','131','val_131' '','','','','133','val_133' '','','','','134','val_134' '','','','','134','val_134' '','','','','134','val_134' '','','','','134','val_134' '','','','','134','val_134' '','','','','134','val_134' '','','','','134','val_134' '','','','','134','val_134' '','','','','136','val_136' '','','','','137','val_137' '','','','','137','val_137' '','','','','137','val_137' '','','','','137','val_137' '','','','','137','val_137' '','','','','137','val_137' '','','','','137','val_137' '','','','','137','val_137' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','143','val_143' '','','','','145','val_145' '','','','','146','val_146' '','','','','146','val_146' '','','','','146','val_146' '','','','','146','val_146' '','','','','146','val_146' '','','','','146','val_146' '','','','','146','val_146' '','','','','146','val_146' '','','','','149','val_149' '','','','','149','val_149' '','','','','149','val_149' '','','','','149','val_149' '','','','','149','val_149' '','','','','149','val_149' '','','','','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' '','','','','152','val_152' '','','','','152','val_152' '','','','','152','val_152' '','','','','152','val_152' '','','','','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' '','','','','164','val_164' '','','','','164','val_164' '','','','','164','val_164' '','','','','164','val_164' '','','','','164','val_164' '','','','','164','val_164' '','','','','165','val_165' '','','','','165','val_165' '','','','','165','val_165' '','','','','165','val_165' '','','','','165','val_165' '','','','','165','val_165' '','','','','165','val_165' '','','','','165','val_165' '','','','','166','val_166' '','','','','167','val_167' '','','','','167','val_167' '','','','','167','val_167' '','','','','167','val_167' '','','','','167','val_167' '','','','','167','val_167' '','','','','167','val_167' '','','','','167','val_167' '','','','','167','val_167' '','','','','167','val_167' '','','','','167','val_167' '','','','','167','val_167' '','','','','167','val_167' '','','','','167','val_167' '','','','','167','val_167' '','','','','167','val_167' '','','','','167','val_167' '','','','','167','val_167' '','','','','167','val_167' '','','','','167','val_167' '','','','','167','val_167' '','','','','167','val_167' '','','','','167','val_167' '','','','','167','val_167' '','','','','167','val_167' '','','','','167','val_167' '','','','','167','val_167' '','','','','168','val_168' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','17','val_17' '','','','','170','val_170' '','','','','172','val_172' '','','','','172','val_172' '','','','','172','val_172' '','','','','172','val_172' '','','','','172','val_172' '','','','','172','val_172' '','','','','172','val_172' '','','','','172','val_172' '','','','','174','val_174' '','','','','174','val_174' '','','','','174','val_174' '','','','','174','val_174' '','','','','174','val_174' '','','','','174','val_174' '','','','','174','val_174' '','','','','174','val_174' '','','','','175','val_175' '','','','','175','val_175' '','','','','175','val_175' '','','','','175','val_175' '','','','','175','val_175' '','','','','175','val_175' '','','','','175','val_175' '','','','','175','val_175' '','','','','176','val_176' '','','','','176','val_176' '','','','','176','val_176' '','','','','176','val_176' '','','','','176','val_176' '','','','','176','val_176' '','','','','176','val_176' '','','','','176','val_176' '','','','','177','val_177' '','','','','178','val_178' '','','','','179','val_179' '','','','','179','val_179' '','','','','179','val_179' '','','','','179','val_179' '','','','','179','val_179' '','','','','179','val_179' '','','','','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' '','','','','187','val_187' '','','','','187','val_187' '','','','','187','val_187' '','','','','187','val_187' '','','','','187','val_187' '','','','','187','val_187' '','','','','187','val_187' '','','','','187','val_187' '','','','','187','val_187' '','','','','187','val_187' '','','','','187','val_187' '','','','','187','val_187' '','','','','187','val_187' '','','','','187','val_187' '','','','','187','val_187' '','','','','187','val_187' '','','','','187','val_187' '','','','','187','val_187' '','','','','187','val_187' '','','','','187','val_187' '','','','','187','val_187' '','','','','187','val_187' '','','','','187','val_187' '','','','','187','val_187' '','','','','189','val_189' '','','','','19','val_19' '','','','','190','val_190' '','','','','191','val_191' '','','','','191','val_191' '','','','','191','val_191' '','','','','191','val_191' '','','','','191','val_191' '','','','','191','val_191' '','','','','191','val_191' '','','','','191','val_191' '','','','','192','val_192' '','','','','193','val_193' '','','','','193','val_193' '','','','','193','val_193' '','','','','193','val_193' '','','','','193','val_193' '','','','','193','val_193' '','','','','193','val_193' '','','','','193','val_193' '','','','','193','val_193' '','','','','193','val_193' '','','','','193','val_193' '','','','','193','val_193' '','','','','193','val_193' '','','','','193','val_193' '','','','','193','val_193' '','','','','193','val_193' '','','','','193','val_193' '','','','','193','val_193' '','','','','193','val_193' '','','','','193','val_193' '','','','','193','val_193' '','','','','193','val_193' '','','','','193','val_193' '','','','','193','val_193' '','','','','193','val_193' '','','','','193','val_193' '','','','','193','val_193' '','','','','194','val_194' '','','','','195','val_195' '','','','','195','val_195' '','','','','195','val_195' '','','','','195','val_195' '','','','','195','val_195' '','','','','195','val_195' '','','','','195','val_195' '','','','','195','val_195' '','','','','196','val_196' '','','','','197','val_197' '','','','','197','val_197' '','','','','197','val_197' '','','','','197','val_197' '','','','','197','val_197' '','','','','197','val_197' '','','','','197','val_197' '','','','','197','val_197' '','','','','199','val_199' '','','','','199','val_199' '','','','','199','val_199' '','','','','199','val_199' '','','','','199','val_199' '','','','','199','val_199' '','','','','199','val_199' '','','','','199','val_199' '','','','','199','val_199' '','','','','199','val_199' '','','','','199','val_199' '','','','','199','val_199' '','','','','199','val_199' '','','','','199','val_199' '','','','','199','val_199' '','','','','199','val_199' '','','','','199','val_199' '','','','','199','val_199' '','','','','199','val_199' '','','','','199','val_199' '','','','','199','val_199' '','','','','199','val_199' '','','','','199','val_199' '','','','','199','val_199' '','','','','199','val_199' '','','','','199','val_199' '','','','','199','val_199' '','','','','2','val_2' '','','','','20','val_20' '','','','','200','val_200' '','','','','200','val_200' '','','','','200','val_200' '','','','','200','val_200' '','','','','200','val_200' '','','','','200','val_200' '','','','','200','val_200' '','','','','200','val_200' '','','','','201','val_201' '','','','','202','val_202' '','','','','203','val_203' '','','','','203','val_203' '','','','','203','val_203' '','','','','203','val_203' '','','','','203','val_203' '','','','','203','val_203' '','','','','203','val_203' '','','','','203','val_203' '','','','','205','val_205' '','','','','205','val_205' '','','','','205','val_205' '','','','','205','val_205' '','','','','205','val_205' '','','','','205','val_205' '','','','','205','val_205' '','','','','205','val_205' '','','','','207','val_207' '','','','','207','val_207' '','','','','207','val_207' '','','','','207','val_207' '','','','','207','val_207' '','','','','207','val_207' '','','','','207','val_207' '','','','','207','val_207' '','','','','208','val_208' '','','','','208','val_208' '','','','','208','val_208' '','','','','208','val_208' '','','','','208','val_208' '','','','','208','val_208' '','','','','208','val_208' '','','','','208','val_208' '','','','','208','val_208' '','','','','208','val_208' '','','','','208','val_208' '','','','','208','val_208' '','','','','208','val_208' '','','','','208','val_208' '','','','','208','val_208' '','','','','208','val_208' '','','','','208','val_208' '','','','','208','val_208' '','','','','208','val_208' '','','','','208','val_208' '','','','','208','val_208' '','','','','208','val_208' '','','','','208','val_208' '','','','','208','val_208' '','','','','208','val_208' '','','','','208','val_208' '','','','','208','val_208' '','','','','209','val_209' '','','','','209','val_209' '','','','','209','val_209' '','','','','209','val_209' '','','','','209','val_209' '','','','','209','val_209' '','','','','209','val_209' '','','','','209','val_209' '','','','','213','val_213' '','','','','213','val_213' '','','','','213','val_213' '','','','','213','val_213' '','','','','213','val_213' '','','','','213','val_213' '','','','','213','val_213' '','','','','213','val_213' '','','','','214','val_214' '','','','','216','val_216' '','','','','216','val_216' '','','','','216','val_216' '','','','','216','val_216' '','','','','216','val_216' '','','','','216','val_216' '','','','','216','val_216' '','','','','216','val_216' '','','','','217','val_217' '','','','','217','val_217' '','','','','217','val_217' '','','','','217','val_217' '','','','','217','val_217' '','','','','217','val_217' '','','','','217','val_217' '','','','','217','val_217' '','','','','218','val_218' '','','','','219','val_219' '','','','','219','val_219' '','','','','219','val_219' '','','','','219','val_219' '','','','','219','val_219' '','','','','219','val_219' '','','','','219','val_219' '','','','','219','val_219' '','','','','221','val_221' '','','','','221','val_221' '','','','','221','val_221' '','','','','221','val_221' '','','','','221','val_221' '','','','','221','val_221' '','','','','221','val_221' '','','','','221','val_221' '','','','','222','val_222' '','','','','223','val_223' '','','','','223','val_223' '','','','','223','val_223' '','','','','223','val_223' '','','','','223','val_223' '','','','','223','val_223' '','','','','223','val_223' '','','','','223','val_223' '','','','','224','val_224' '','','','','224','val_224' '','','','','224','val_224' '','','','','224','val_224' '','','','','224','val_224' '','','','','224','val_224' '','','','','224','val_224' '','','','','224','val_224' '','','','','226','val_226' '','','','','228','val_228' '','','','','229','val_229' '','','','','229','val_229' '','','','','229','val_229' '','','','','229','val_229' '','','','','229','val_229' '','','','','229','val_229' '','','','','229','val_229' '','','','','229','val_229' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','233','val_233' '','','','','233','val_233' '','','','','233','val_233' '','','','','233','val_233' '','','','','233','val_233' '','','','','233','val_233' '','','','','233','val_233' '','','','','233','val_233' '','','','','235','val_235' '','','','','237','val_237' '','','','','237','val_237' '','','','','237','val_237' '','','','','237','val_237' '','','','','237','val_237' '','','','','237','val_237' '','','','','237','val_237' '','','','','237','val_237' '','','','','238','val_238' '','','','','238','val_238' '','','','','238','val_238' '','','','','238','val_238' '','','','','238','val_238' '','','','','238','val_238' '','','','','238','val_238' '','','','','238','val_238' '','','','','239','val_239' '','','','','239','val_239' '','','','','239','val_239' '','','','','239','val_239' '','','','','239','val_239' '','','','','239','val_239' '','','','','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' '','','','','242','val_242' '','','','','242','val_242' '','','','','242','val_242' '','','','','242','val_242' '','','','','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' '','','','','255','val_255' '','','','','255','val_255' '','','','','255','val_255' '','','','','255','val_255' '','','','','255','val_255' '','','','','255','val_255' '','','','','256','val_256' '','','','','256','val_256' '','','','','256','val_256' '','','','','256','val_256' '','','','','256','val_256' '','','','','256','val_256' '','','','','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' '','','','','265','val_265' '','','','','265','val_265' '','','','','265','val_265' '','','','','265','val_265' '','','','','265','val_265' '','','','','265','val_265' '','','','','266','val_266' '','','','','27','val_27' '','','','','272','val_272' '','','','','272','val_272' '','','','','272','val_272' '','','','','272','val_272' '','','','','272','val_272' '','','','','272','val_272' '','','','','272','val_272' '','','','','272','val_272' '','','','','273','val_273' '','','','','273','val_273' '','','','','273','val_273' '','','','','273','val_273' '','','','','273','val_273' '','','','','273','val_273' '','','','','273','val_273' '','','','','273','val_273' '','','','','273','val_273' '','','','','273','val_273' '','','','','273','val_273' '','','','','273','val_273' '','','','','273','val_273' '','','','','273','val_273' '','','','','273','val_273' '','','','','273','val_273' '','','','','273','val_273' '','','','','273','val_273' '','','','','273','val_273' '','','','','273','val_273' '','','','','273','val_273' '','','','','273','val_273' '','','','','273','val_273' '','','','','273','val_273' '','','','','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' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','278','val_278' '','','','','278','val_278' '','','','','278','val_278' '','','','','278','val_278' '','','','','278','val_278' '','','','','278','val_278' '','','','','278','val_278' '','','','','278','val_278' '','','','','28','val_28' '','','','','280','val_280' '','','','','280','val_280' '','','','','280','val_280' '','','','','280','val_280' '','','','','280','val_280' '','','','','280','val_280' '','','','','280','val_280' '','','','','280','val_280' '','','','','281','val_281' '','','','','281','val_281' '','','','','281','val_281' '','','','','281','val_281' '','','','','281','val_281' '','','','','281','val_281' '','','','','281','val_281' '','','','','281','val_281' '','','','','282','val_282' '','','','','282','val_282' '','','','','282','val_282' '','','','','282','val_282' '','','','','282','val_282' '','','','','282','val_282' '','','','','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' '','','','','288','val_288' '','','','','288','val_288' '','','','','288','val_288' '','','','','288','val_288' '','','','','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' '','','','','298','val_298' '','','','','298','val_298' '','','','','298','val_298' '','','','','298','val_298' '','','','','298','val_298' '','','','','298','val_298' '','','','','298','val_298' '','','','','298','val_298' '','','','','298','val_298' '','','','','298','val_298' '','','','','298','val_298' '','','','','298','val_298' '','','','','298','val_298' '','','','','298','val_298' '','','','','298','val_298' '','','','','298','val_298' '','','','','298','val_298' '','','','','298','val_298' '','','','','298','val_298' '','','','','298','val_298' '','','','','298','val_298' '','','','','298','val_298' '','','','','298','val_298' '','','','','298','val_298' '','','','','30','val_30' '','','','','302','val_302' '','','','','305','val_305' '','','','','306','val_306' '','','','','307','val_307' '','','','','307','val_307' '','','','','307','val_307' '','','','','307','val_307' '','','','','307','val_307' '','','','','307','val_307' '','','','','307','val_307' '','','','','307','val_307' '','','','','308','val_308' '','','','','309','val_309' '','','','','309','val_309' '','','','','309','val_309' '','','','','309','val_309' '','','','','309','val_309' '','','','','309','val_309' '','','','','309','val_309' '','','','','309','val_309' '','','','','310','val_310' '','','','','311','val_311' '','','','','311','val_311' '','','','','311','val_311' '','','','','311','val_311' '','','','','311','val_311' '','','','','311','val_311' '','','','','311','val_311' '','','','','311','val_311' '','','','','311','val_311' '','','','','311','val_311' '','','','','311','val_311' '','','','','311','val_311' '','','','','311','val_311' '','','','','311','val_311' '','','','','311','val_311' '','','','','311','val_311' '','','','','311','val_311' '','','','','311','val_311' '','','','','311','val_311' '','','','','311','val_311' '','','','','311','val_311' '','','','','311','val_311' '','','','','311','val_311' '','','','','311','val_311' '','','','','311','val_311' '','','','','311','val_311' '','','','','311','val_311' '','','','','315','val_315' '','','','','316','val_316' '','','','','316','val_316' '','','','','316','val_316' '','','','','316','val_316' '','','','','316','val_316' '','','','','316','val_316' '','','','','316','val_316' '','','','','316','val_316' '','','','','316','val_316' '','','','','316','val_316' '','','','','316','val_316' '','','','','316','val_316' '','','','','316','val_316' '','','','','316','val_316' '','','','','316','val_316' '','','','','316','val_316' '','','','','316','val_316' '','','','','316','val_316' '','','','','316','val_316' '','','','','316','val_316' '','','','','316','val_316' '','','','','316','val_316' '','','','','316','val_316' '','','','','316','val_316' '','','','','316','val_316' '','','','','316','val_316' '','','','','316','val_316' '','','','','317','val_317' '','','','','317','val_317' '','','','','317','val_317' '','','','','317','val_317' '','','','','317','val_317' '','','','','317','val_317' '','','','','317','val_317' '','','','','317','val_317' '','','','','318','val_318' '','','','','318','val_318' '','','','','318','val_318' '','','','','318','val_318' '','','','','318','val_318' '','','','','318','val_318' '','','','','318','val_318' '','','','','318','val_318' '','','','','318','val_318' '','','','','318','val_318' '','','','','318','val_318' '','','','','318','val_318' '','','','','318','val_318' '','','','','318','val_318' '','','','','318','val_318' '','','','','318','val_318' '','','','','318','val_318' '','','','','318','val_318' '','','','','318','val_318' '','','','','318','val_318' '','','','','318','val_318' '','','','','318','val_318' '','','','','318','val_318' '','','','','318','val_318' '','','','','318','val_318' '','','','','318','val_318' '','','','','318','val_318' '','','','','321','val_321' '','','','','321','val_321' '','','','','321','val_321' '','','','','321','val_321' '','','','','321','val_321' '','','','','321','val_321' '','','','','321','val_321' '','','','','321','val_321' '','','','','322','val_322' '','','','','322','val_322' '','','','','322','val_322' '','','','','322','val_322' '','','','','322','val_322' '','','','','322','val_322' '','','','','322','val_322' '','','','','322','val_322' '','','','','323','val_323' '','','','','325','val_325' '','','','','325','val_325' '','','','','325','val_325' '','','','','325','val_325' '','','','','325','val_325' '','','','','325','val_325' '','','','','325','val_325' '','','','','325','val_325' '','','','','327','val_327' '','','','','327','val_327' '','','','','327','val_327' '','','','','327','val_327' '','','','','327','val_327' '','','','','327','val_327' '','','','','327','val_327' '','','','','327','val_327' '','','','','327','val_327' '','','','','327','val_327' '','','','','327','val_327' '','','','','327','val_327' '','','','','327','val_327' '','','','','327','val_327' '','','','','327','val_327' '','','','','327','val_327' '','','','','327','val_327' '','','','','327','val_327' '','','','','327','val_327' '','','','','327','val_327' '','','','','327','val_327' '','','','','327','val_327' '','','','','327','val_327' '','','','','327','val_327' '','','','','327','val_327' '','','','','327','val_327' '','','','','327','val_327' '','','','','33','val_33' '','','','','331','val_331' '','','','','331','val_331' '','','','','331','val_331' '','','','','331','val_331' '','','','','331','val_331' '','','','','331','val_331' '','','','','331','val_331' '','','','','331','val_331' '','','','','332','val_332' '','','','','333','val_333' '','','','','333','val_333' '','','','','333','val_333' '','','','','333','val_333' '','','','','333','val_333' '','','','','333','val_333' '','','','','333','val_333' '','','','','333','val_333' '','','','','335','val_335' '','','','','336','val_336' '','','','','338','val_338' '','','','','339','val_339' '','','','','34','val_34' '','','','','341','val_341' '','','','','342','val_342' '','','','','342','val_342' '','','','','342','val_342' '','','','','342','val_342' '','','','','342','val_342' '','','','','342','val_342' '','','','','342','val_342' '','','','','342','val_342' '','','','','344','val_344' '','','','','344','val_344' '','','','','344','val_344' '','','','','344','val_344' '','','','','344','val_344' '','','','','344','val_344' '','','','','344','val_344' '','','','','344','val_344' '','','','','345','val_345' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','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' '','','','','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' '','','','','353','val_353' '','','','','353','val_353' '','','','','353','val_353' '','','','','353','val_353' '','','','','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' '','','','','367','val_367' '','','','','367','val_367' '','','','','367','val_367' '','','','','367','val_367' '','','','','367','val_367' '','','','','367','val_367' '','','','','368','val_368' '','','','','369','val_369' '','','','','369','val_369' '','','','','369','val_369' '','','','','369','val_369' '','','','','369','val_369' '','','','','369','val_369' '','','','','369','val_369' '','','','','369','val_369' '','','','','369','val_369' '','','','','369','val_369' '','','','','369','val_369' '','','','','369','val_369' '','','','','369','val_369' '','','','','369','val_369' '','','','','369','val_369' '','','','','369','val_369' '','','','','369','val_369' '','','','','369','val_369' '','','','','369','val_369' '','','','','369','val_369' '','','','','369','val_369' '','','','','369','val_369' '','','','','369','val_369' '','','','','369','val_369' '','','','','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' '','','','','382','val_382' '','','','','382','val_382' '','','','','382','val_382' '','','','','382','val_382' '','','','','382','val_382' '','','','','382','val_382' '','','','','384','val_384' '','','','','384','val_384' '','','','','384','val_384' '','','','','384','val_384' '','','','','384','val_384' '','','','','384','val_384' '','','','','384','val_384' '','','','','384','val_384' '','','','','384','val_384' '','','','','384','val_384' '','','','','384','val_384' '','','','','384','val_384' '','','','','384','val_384' '','','','','384','val_384' '','','','','384','val_384' '','','','','384','val_384' '','','','','384','val_384' '','','','','384','val_384' '','','','','384','val_384' '','','','','384','val_384' '','','','','384','val_384' '','','','','384','val_384' '','','','','384','val_384' '','','','','384','val_384' '','','','','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' '','','','','395','val_395' '','','','','395','val_395' '','','','','395','val_395' '','','','','395','val_395' '','','','','395','val_395' '','','','','395','val_395' '','','','','396','val_396' '','','','','396','val_396' '','','','','396','val_396' '','','','','396','val_396' '','','','','396','val_396' '','','','','396','val_396' '','','','','396','val_396' '','','','','396','val_396' '','','','','396','val_396' '','','','','396','val_396' '','','','','396','val_396' '','','','','396','val_396' '','','','','396','val_396' '','','','','396','val_396' '','','','','396','val_396' '','','','','396','val_396' '','','','','396','val_396' '','','','','396','val_396' '','','','','396','val_396' '','','','','396','val_396' '','','','','396','val_396' '','','','','396','val_396' '','','','','396','val_396' '','','','','396','val_396' '','','','','396','val_396' '','','','','396','val_396' '','','','','396','val_396' '','','','','397','val_397' '','','','','397','val_397' '','','','','397','val_397' '','','','','397','val_397' '','','','','397','val_397' '','','','','397','val_397' '','','','','397','val_397' '','','','','397','val_397' '','','','','399','val_399' '','','','','399','val_399' '','','','','399','val_399' '','','','','399','val_399' '','','','','399','val_399' '','','','','399','val_399' '','','','','399','val_399' '','','','','399','val_399' '','','','','4','val_4' '','','','','400','val_400' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','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' '','','','','403','val_403' '','','','','403','val_403' '','','','','403','val_403' '','','','','403','val_403' '','','','','403','val_403' '','','','','403','val_403' '','','','','403','val_403' '','','','','403','val_403' '','','','','403','val_403' '','','','','403','val_403' '','','','','403','val_403' '','','','','403','val_403' '','','','','403','val_403' '','','','','403','val_403' '','','','','403','val_403' '','','','','403','val_403' '','','','','403','val_403' '','','','','403','val_403' '','','','','403','val_403' '','','','','403','val_403' '','','','','403','val_403' '','','','','403','val_403' '','','','','403','val_403' '','','','','403','val_403' '','','','','404','val_404' '','','','','404','val_404' '','','','','404','val_404' '','','','','404','val_404' '','','','','404','val_404' '','','','','404','val_404' '','','','','404','val_404' '','','','','404','val_404' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','407','val_407' '','','','','409','val_409' '','','','','409','val_409' '','','','','409','val_409' '','','','','409','val_409' '','','','','409','val_409' '','','','','409','val_409' '','','','','409','val_409' '','','','','409','val_409' '','','','','409','val_409' '','','','','409','val_409' '','','','','409','val_409' '','','','','409','val_409' '','','','','409','val_409' '','','','','409','val_409' '','','','','409','val_409' '','','','','409','val_409' '','','','','409','val_409' '','','','','409','val_409' '','','','','409','val_409' '','','','','409','val_409' '','','','','409','val_409' '','','','','409','val_409' '','','','','409','val_409' '','','','','409','val_409' '','','','','409','val_409' '','','','','409','val_409' '','','','','409','val_409' '','','','','41','val_41' '','','','','411','val_411' '','','','','413','val_413' '','','','','413','val_413' '','','','','413','val_413' '','','','','413','val_413' '','','','','413','val_413' '','','','','413','val_413' '','','','','413','val_413' '','','','','413','val_413' '','','','','414','val_414' '','','','','414','val_414' '','','','','414','val_414' '','','','','414','val_414' '','','','','414','val_414' '','','','','414','val_414' '','','','','414','val_414' '','','','','414','val_414' '','','','','417','val_417' '','','','','417','val_417' '','','','','417','val_417' '','','','','417','val_417' '','','','','417','val_417' '','','','','417','val_417' '','','','','417','val_417' '','','','','417','val_417' '','','','','417','val_417' '','','','','417','val_417' '','','','','417','val_417' '','','','','417','val_417' '','','','','417','val_417' '','','','','417','val_417' '','','','','417','val_417' '','','','','417','val_417' '','','','','417','val_417' '','','','','417','val_417' '','','','','417','val_417' '','','','','417','val_417' '','','','','417','val_417' '','','','','417','val_417' '','','','','417','val_417' '','','','','417','val_417' '','','','','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' '','','','','424','val_424' '','','','','424','val_424' '','','','','424','val_424' '','','','','424','val_424' '','','','','424','val_424' '','','','','424','val_424' '','','','','427','val_427' '','','','','429','val_429' '','','','','429','val_429' '','','','','429','val_429' '','','','','429','val_429' '','','','','429','val_429' '','','','','429','val_429' '','','','','429','val_429' '','','','','429','val_429' '','','','','43','val_43' '','','','','430','val_430' '','','','','430','val_430' '','','','','430','val_430' '','','','','430','val_430' '','','','','430','val_430' '','','','','430','val_430' '','','','','430','val_430' '','','','','430','val_430' '','','','','430','val_430' '','','','','430','val_430' '','','','','430','val_430' '','','','','430','val_430' '','','','','430','val_430' '','','','','430','val_430' '','','','','430','val_430' '','','','','430','val_430' '','','','','430','val_430' '','','','','430','val_430' '','','','','430','val_430' '','','','','430','val_430' '','','','','430','val_430' '','','','','430','val_430' '','','','','430','val_430' '','','','','430','val_430' '','','','','430','val_430' '','','','','430','val_430' '','','','','430','val_430' '','','','','431','val_431' '','','','','431','val_431' '','','','','431','val_431' '','','','','431','val_431' '','','','','431','val_431' '','','','','431','val_431' '','','','','431','val_431' '','','','','431','val_431' '','','','','431','val_431' '','','','','431','val_431' '','','','','431','val_431' '','','','','431','val_431' '','','','','431','val_431' '','','','','431','val_431' '','','','','431','val_431' '','','','','431','val_431' '','','','','431','val_431' '','','','','431','val_431' '','','','','431','val_431' '','','','','431','val_431' '','','','','431','val_431' '','','','','431','val_431' '','','','','431','val_431' '','','','','431','val_431' '','','','','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' '','','','','438','val_438' '','','','','438','val_438' '','','','','438','val_438' '','','','','438','val_438' '','','','','438','val_438' '','','','','438','val_438' '','','','','438','val_438' '','','','','438','val_438' '','','','','438','val_438' '','','','','438','val_438' '','','','','438','val_438' '','','','','438','val_438' '','','','','438','val_438' '','','','','438','val_438' '','','','','438','val_438' '','','','','438','val_438' '','','','','438','val_438' '','','','','438','val_438' '','','','','438','val_438' '','','','','438','val_438' '','','','','438','val_438' '','','','','438','val_438' '','','','','438','val_438' '','','','','438','val_438' '','','','','439','val_439' '','','','','439','val_439' '','','','','439','val_439' '','','','','439','val_439' '','','','','439','val_439' '','','','','439','val_439' '','','','','439','val_439' '','','','','439','val_439' '','','','','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' '','','','','454','val_454' '','','','','454','val_454' '','','','','454','val_454' '','','','','454','val_454' '','','','','454','val_454' '','','','','454','val_454' '','','','','454','val_454' '','','','','454','val_454' '','','','','454','val_454' '','','','','454','val_454' '','','','','454','val_454' '','','','','454','val_454' '','','','','454','val_454' '','','','','454','val_454' '','','','','454','val_454' '','','','','454','val_454' '','','','','454','val_454' '','','','','454','val_454' '','','','','454','val_454' '','','','','454','val_454' '','','','','454','val_454' '','','','','454','val_454' '','','','','454','val_454' '','','','','454','val_454' '','','','','455','val_455' '','','','','457','val_457' '','','','','458','val_458' '','','','','458','val_458' '','','','','458','val_458' '','','','','458','val_458' '','','','','458','val_458' '','','','','458','val_458' '','','','','458','val_458' '','','','','458','val_458' '','','','','459','val_459' '','','','','459','val_459' '','','','','459','val_459' '','','','','459','val_459' '','','','','459','val_459' '','','','','459','val_459' '','','','','459','val_459' '','','','','459','val_459' '','','','','460','val_460' '','','','','462','val_462' '','','','','462','val_462' '','','','','462','val_462' '','','','','462','val_462' '','','','','462','val_462' '','','','','462','val_462' '','','','','462','val_462' '','','','','462','val_462' '','','','','463','val_463' '','','','','463','val_463' '','','','','463','val_463' '','','','','463','val_463' '','','','','463','val_463' '','','','','463','val_463' '','','','','463','val_463' '','','','','463','val_463' '','','','','466','val_466' '','','','','466','val_466' '','','','','466','val_466' '','','','','466','val_466' '','','','','466','val_466' '','','','','466','val_466' '','','','','466','val_466' '','','','','466','val_466' '','','','','466','val_466' '','','','','466','val_466' '','','','','466','val_466' '','','','','466','val_466' '','','','','466','val_466' '','','','','466','val_466' '','','','','466','val_466' '','','','','466','val_466' '','','','','466','val_466' '','','','','466','val_466' '','','','','466','val_466' '','','','','466','val_466' '','','','','466','val_466' '','','','','466','val_466' '','','','','466','val_466' '','','','','466','val_466' '','','','','466','val_466' '','','','','466','val_466' '','','','','466','val_466' '','','','','467','val_467' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','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' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','47','val_47' '','','','','470','val_470' '','','','','472','val_472' '','','','','475','val_475' '','','','','477','val_477' '','','','','478','val_478' '','','','','478','val_478' '','','','','478','val_478' '','','','','478','val_478' '','','','','478','val_478' '','','','','478','val_478' '','','','','478','val_478' '','','','','478','val_478' '','','','','479','val_479' '','','','','480','val_480' '','','','','480','val_480' '','','','','480','val_480' '','','','','480','val_480' '','','','','480','val_480' '','','','','480','val_480' '','','','','480','val_480' '','','','','480','val_480' '','','','','480','val_480' '','','','','480','val_480' '','','','','480','val_480' '','','','','480','val_480' '','','','','480','val_480' '','','','','480','val_480' '','','','','480','val_480' '','','','','480','val_480' '','','','','480','val_480' '','','','','480','val_480' '','','','','480','val_480' '','','','','480','val_480' '','','','','480','val_480' '','','','','480','val_480' '','','','','480','val_480' '','','','','480','val_480' '','','','','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' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','490','val_490' '','','','','491','val_491' '','','','','492','val_492' '','','','','492','val_492' '','','','','492','val_492' '','','','','492','val_492' '','','','','492','val_492' '','','','','492','val_492' '','','','','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' '','','','','498','val_498' '','','','','498','val_498' '','','','','498','val_498' '','','','','498','val_498' '','','','','498','val_498' '','','','','498','val_498' '','','','','498','val_498' '','','','','498','val_498' '','','','','498','val_498' '','','','','498','val_498' '','','','','498','val_498' '','','','','498','val_498' '','','','','498','val_498' '','','','','498','val_498' '','','','','498','val_498' '','','','','498','val_498' '','','','','498','val_498' '','','','','498','val_498' '','','','','498','val_498' '','','','','498','val_498' '','','','','498','val_498' '','','','','498','val_498' '','','','','498','val_498' '','','','','498','val_498' '','','','','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' '','','','','54','val_54' '','','','','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' '','','','','65','val_65' '','','','','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' '','','','','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' '','','','','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' '','','','','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' '','','','','78','val_78' '','','','','8','val_8' '','','','','80','val_80' '','','','','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' '','','','','86','val_86' '','','','','87','val_87' '','','','','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' '','','','','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' '','','','','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' '','','','','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' 2,606 rows selected >>> >>> explain SELECT * FROM src src1 LEFT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) LEFT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value; 'Explain' 'ABSTRACT SYNTAX TREE:' ' (TOK_QUERY (TOK_FROM (TOK_LEFTOUTERJOIN (TOK_LEFTOUTERJOIN (TOK_TABREF (TOK_TABNAME src) src1) (TOK_TABREF (TOK_TABNAME src) src2) (AND (AND (= (. (TOK_TABLE_OR_COL src1) key) (. (TOK_TABLE_OR_COL src2) key)) (< (. (TOK_TABLE_OR_COL src1) key) 10)) (> (. (TOK_TABLE_OR_COL src2) key) 10))) (TOK_TABREF (TOK_TABNAME src) src3) (AND (= (. (TOK_TABLE_OR_COL src2) key) (. (TOK_TABLE_OR_COL src3) key)) (< (. (TOK_TABLE_OR_COL src3) key) 10)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_SORTBY (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src1) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src1) value)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src2) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src2) value)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src3) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src3) value)))))' '' 'STAGE DEPENDENCIES:' ' Stage-6 is a root stage , consists of Stage-7, Stage-1' ' Stage-7 has a backup stage: Stage-1' ' Stage-5 depends on stages: Stage-7' ' Stage-2 depends on stages: Stage-1, Stage-5' ' Stage-1' ' Stage-0 is a root stage' '' 'STAGE PLANS:' ' Stage: Stage-6' ' Conditional Operator' '' ' Stage: Stage-7' ' Map Reduce Local Work' ' Alias -> Map Local Tables:' ' src2 ' ' Fetch Operator' ' limit: -1' ' src3 ' ' Fetch Operator' ' limit: -1' ' Alias -> Map Local Operator Tree:' ' src2 ' ' TableScan' ' alias: src2' ' Filter Operator' ' predicate:' ' expr: (key > 10)' ' type: boolean' ' HashTable Sink Operator' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' filter predicates:' ' 0 {(key < 10)}' ' 1 ' ' 2 ' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' Position of Big Table: 0' ' src3 ' ' TableScan' ' alias: src3' ' Filter Operator' ' predicate:' ' expr: ((key < 10) and (key > 10))' ' type: boolean' ' HashTable Sink Operator' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' filter predicates:' ' 0 {(key < 10)}' ' 1 ' ' 2 ' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' Position of Big Table: 0' '' ' Stage: Stage-5' ' Map Reduce' ' Alias -> Map Operator Tree:' ' src1 ' ' TableScan' ' alias: src1' ' Map Join Operator' ' condition map:' ' Left Outer Join0 to 1' ' Left Outer Join1 to 2' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' filter predicates:' ' 0 {(key < 10)}' ' 1 ' ' 2 ' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9' ' Position of Big Table: 0' ' Select Operator' ' expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' expr: _col8' ' type: string' ' expr: _col9' ' type: string' ' outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5' ' File Output Operator' ' compressed: false' ' GlobalTableId: 0' ' table:' ' input format: org.apache.hadoop.mapred.SequenceFileInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat' ' Local Work:' ' Map Reduce Local Work' '' ' Stage: Stage-2' ' Map Reduce' ' Alias -> Map Operator Tree:' ' file:!!{hive.exec.scratchdir}!! ' ' Reduce Output Operator' ' key expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col2' ' type: string' ' expr: _col3' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' sort order: ++++++' ' tag: -1' ' value expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col2' ' type: string' ' expr: _col3' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' Reduce Operator Tree:' ' Extract' ' 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-1' ' Map Reduce' ' Alias -> Map Operator Tree:' ' src1 ' ' TableScan' ' alias: src1' ' Reduce Output Operator' ' key expressions:' ' expr: key' ' type: string' ' sort order: +' ' Map-reduce partition columns:' ' expr: key' ' type: string' ' tag: 0' ' value expressions:' ' expr: key' ' type: string' ' expr: value' ' type: string' ' src2 ' ' TableScan' ' alias: src2' ' Filter Operator' ' predicate:' ' expr: (key > 10)' ' type: boolean' ' Reduce Output Operator' ' key expressions:' ' expr: key' ' type: string' ' sort order: +' ' Map-reduce partition columns:' ' expr: key' ' type: string' ' tag: 1' ' value expressions:' ' expr: key' ' type: string' ' expr: value' ' type: string' ' src3 ' ' TableScan' ' alias: src3' ' Filter Operator' ' predicate:' ' expr: ((key < 10) and (key > 10))' ' type: boolean' ' Reduce Output Operator' ' key expressions:' ' expr: key' ' type: string' ' sort order: +' ' Map-reduce partition columns:' ' expr: key' ' type: string' ' tag: 2' ' value expressions:' ' expr: key' ' type: string' ' expr: value' ' type: string' ' Reduce Operator Tree:' ' Join Operator' ' condition map:' ' Left Outer Join0 to 1' ' Left Outer Join1 to 2' ' condition expressions:' ' 0 {VALUE._col0} {VALUE._col1}' ' 1 {VALUE._col0} {VALUE._col1}' ' 2 {VALUE._col0} {VALUE._col1}' ' filter predicates:' ' 0 {(VALUE._col0 < 10)}' ' 1 ' ' 2 ' ' handleSkewJoin: false' ' outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9' ' Select Operator' ' expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' expr: _col8' ' type: string' ' expr: _col9' ' type: string' ' outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5' ' File Output Operator' ' compressed: false' ' GlobalTableId: 0' ' table:' ' input format: org.apache.hadoop.mapred.SequenceFileInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat' '' ' Stage: Stage-0' ' Fetch Operator' ' limit: -1' '' '' 265 rows selected >>> >>> SELECT * FROM src src1 LEFT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) LEFT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value; 'key','value','key','value','key','value' '0','val_0','','','','' '0','val_0','','','','' '0','val_0','','','','' '10','val_10','','','','' '100','val_100','','','','' '100','val_100','','','','' '100','val_100','','','','' '100','val_100','','','','' '103','val_103','','','','' '103','val_103','','','','' '103','val_103','','','','' '103','val_103','','','','' '104','val_104','','','','' '104','val_104','','','','' '104','val_104','','','','' '104','val_104','','','','' '105','val_105','','','','' '11','val_11','','','','' '111','val_111','','','','' '113','val_113','','','','' '113','val_113','','','','' '113','val_113','','','','' '113','val_113','','','','' '114','val_114','','','','' '116','val_116','','','','' '118','val_118','','','','' '118','val_118','','','','' '118','val_118','','','','' '118','val_118','','','','' '119','val_119','','','','' '119','val_119','','','','' '119','val_119','','','','' '119','val_119','','','','' '119','val_119','','','','' '119','val_119','','','','' '119','val_119','','','','' '119','val_119','','','','' '119','val_119','','','','' '12','val_12','','','','' '12','val_12','','','','' '12','val_12','','','','' '12','val_12','','','','' '120','val_120','','','','' '120','val_120','','','','' '120','val_120','','','','' '120','val_120','','','','' '125','val_125','','','','' '125','val_125','','','','' '125','val_125','','','','' '125','val_125','','','','' '126','val_126','','','','' '128','val_128','','','','' '128','val_128','','','','' '128','val_128','','','','' '128','val_128','','','','' '128','val_128','','','','' '128','val_128','','','','' '128','val_128','','','','' '128','val_128','','','','' '128','val_128','','','','' '129','val_129','','','','' '129','val_129','','','','' '129','val_129','','','','' '129','val_129','','','','' '131','val_131','','','','' '133','val_133','','','','' '134','val_134','','','','' '134','val_134','','','','' '134','val_134','','','','' '134','val_134','','','','' '136','val_136','','','','' '137','val_137','','','','' '137','val_137','','','','' '137','val_137','','','','' '137','val_137','','','','' '138','val_138','','','','' '138','val_138','','','','' '138','val_138','','','','' '138','val_138','','','','' '138','val_138','','','','' '138','val_138','','','','' '138','val_138','','','','' '138','val_138','','','','' '138','val_138','','','','' '138','val_138','','','','' '138','val_138','','','','' '138','val_138','','','','' '138','val_138','','','','' '138','val_138','','','','' '138','val_138','','','','' '138','val_138','','','','' '143','val_143','','','','' '145','val_145','','','','' '146','val_146','','','','' '146','val_146','','','','' '146','val_146','','','','' '146','val_146','','','','' '149','val_149','','','','' '149','val_149','','','','' '149','val_149','','','','' '149','val_149','','','','' '15','val_15','','','','' '15','val_15','','','','' '15','val_15','','','','' '15','val_15','','','','' '150','val_150','','','','' '152','val_152','','','','' '152','val_152','','','','' '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','','','','' '164','val_164','','','','' '164','val_164','','','','' '165','val_165','','','','' '165','val_165','','','','' '165','val_165','','','','' '165','val_165','','','','' '166','val_166','','','','' '167','val_167','','','','' '167','val_167','','','','' '167','val_167','','','','' '167','val_167','','','','' '167','val_167','','','','' '167','val_167','','','','' '167','val_167','','','','' '167','val_167','','','','' '167','val_167','','','','' '168','val_168','','','','' '169','val_169','','','','' '169','val_169','','','','' '169','val_169','','','','' '169','val_169','','','','' '169','val_169','','','','' '169','val_169','','','','' '169','val_169','','','','' '169','val_169','','','','' '169','val_169','','','','' '169','val_169','','','','' '169','val_169','','','','' '169','val_169','','','','' '169','val_169','','','','' '169','val_169','','','','' '169','val_169','','','','' '169','val_169','','','','' '17','val_17','','','','' '170','val_170','','','','' '172','val_172','','','','' '172','val_172','','','','' '172','val_172','','','','' '172','val_172','','','','' '174','val_174','','','','' '174','val_174','','','','' '174','val_174','','','','' '174','val_174','','','','' '175','val_175','','','','' '175','val_175','','','','' '175','val_175','','','','' '175','val_175','','','','' '176','val_176','','','','' '176','val_176','','','','' '176','val_176','','','','' '176','val_176','','','','' '177','val_177','','','','' '178','val_178','','','','' '179','val_179','','','','' '179','val_179','','','','' '179','val_179','','','','' '179','val_179','','','','' '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','','','','' '187','val_187','','','','' '187','val_187','','','','' '187','val_187','','','','' '187','val_187','','','','' '187','val_187','','','','' '187','val_187','','','','' '189','val_189','','','','' '19','val_19','','','','' '190','val_190','','','','' '191','val_191','','','','' '191','val_191','','','','' '191','val_191','','','','' '191','val_191','','','','' '192','val_192','','','','' '193','val_193','','','','' '193','val_193','','','','' '193','val_193','','','','' '193','val_193','','','','' '193','val_193','','','','' '193','val_193','','','','' '193','val_193','','','','' '193','val_193','','','','' '193','val_193','','','','' '194','val_194','','','','' '195','val_195','','','','' '195','val_195','','','','' '195','val_195','','','','' '195','val_195','','','','' '196','val_196','','','','' '197','val_197','','','','' '197','val_197','','','','' '197','val_197','','','','' '197','val_197','','','','' '199','val_199','','','','' '199','val_199','','','','' '199','val_199','','','','' '199','val_199','','','','' '199','val_199','','','','' '199','val_199','','','','' '199','val_199','','','','' '199','val_199','','','','' '199','val_199','','','','' '2','val_2','','','','' '20','val_20','','','','' '200','val_200','','','','' '200','val_200','','','','' '200','val_200','','','','' '200','val_200','','','','' '201','val_201','','','','' '202','val_202','','','','' '203','val_203','','','','' '203','val_203','','','','' '203','val_203','','','','' '203','val_203','','','','' '205','val_205','','','','' '205','val_205','','','','' '205','val_205','','','','' '205','val_205','','','','' '207','val_207','','','','' '207','val_207','','','','' '207','val_207','','','','' '207','val_207','','','','' '208','val_208','','','','' '208','val_208','','','','' '208','val_208','','','','' '208','val_208','','','','' '208','val_208','','','','' '208','val_208','','','','' '208','val_208','','','','' '208','val_208','','','','' '208','val_208','','','','' '209','val_209','','','','' '209','val_209','','','','' '209','val_209','','','','' '209','val_209','','','','' '213','val_213','','','','' '213','val_213','','','','' '213','val_213','','','','' '213','val_213','','','','' '214','val_214','','','','' '216','val_216','','','','' '216','val_216','','','','' '216','val_216','','','','' '216','val_216','','','','' '217','val_217','','','','' '217','val_217','','','','' '217','val_217','','','','' '217','val_217','','','','' '218','val_218','','','','' '219','val_219','','','','' '219','val_219','','','','' '219','val_219','','','','' '219','val_219','','','','' '221','val_221','','','','' '221','val_221','','','','' '221','val_221','','','','' '221','val_221','','','','' '222','val_222','','','','' '223','val_223','','','','' '223','val_223','','','','' '223','val_223','','','','' '223','val_223','','','','' '224','val_224','','','','' '224','val_224','','','','' '224','val_224','','','','' '224','val_224','','','','' '226','val_226','','','','' '228','val_228','','','','' '229','val_229','','','','' '229','val_229','','','','' '229','val_229','','','','' '229','val_229','','','','' '230','val_230','','','','' '230','val_230','','','','' '230','val_230','','','','' '230','val_230','','','','' '230','val_230','','','','' '230','val_230','','','','' '230','val_230','','','','' '230','val_230','','','','' '230','val_230','','','','' '230','val_230','','','','' '230','val_230','','','','' '230','val_230','','','','' '230','val_230','','','','' '230','val_230','','','','' '230','val_230','','','','' '230','val_230','','','','' '230','val_230','','','','' '230','val_230','','','','' '230','val_230','','','','' '230','val_230','','','','' '230','val_230','','','','' '230','val_230','','','','' '230','val_230','','','','' '230','val_230','','','','' '230','val_230','','','','' '233','val_233','','','','' '233','val_233','','','','' '233','val_233','','','','' '233','val_233','','','','' '235','val_235','','','','' '237','val_237','','','','' '237','val_237','','','','' '237','val_237','','','','' '237','val_237','','','','' '238','val_238','','','','' '238','val_238','','','','' '238','val_238','','','','' '238','val_238','','','','' '239','val_239','','','','' '239','val_239','','','','' '239','val_239','','','','' '239','val_239','','','','' '24','val_24','','','','' '24','val_24','','','','' '24','val_24','','','','' '24','val_24','','','','' '241','val_241','','','','' '242','val_242','','','','' '242','val_242','','','','' '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','','','','' '255','val_255','','','','' '255','val_255','','','','' '256','val_256','','','','' '256','val_256','','','','' '256','val_256','','','','' '256','val_256','','','','' '257','val_257','','','','' '258','val_258','','','','' '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','','','','' '265','val_265','','','','' '265','val_265','','','','' '266','val_266','','','','' '27','val_27','','','','' '272','val_272','','','','' '272','val_272','','','','' '272','val_272','','','','' '272','val_272','','','','' '273','val_273','','','','' '273','val_273','','','','' '273','val_273','','','','' '273','val_273','','','','' '273','val_273','','','','' '273','val_273','','','','' '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','','','','' '277','val_277','','','','' '277','val_277','','','','' '277','val_277','','','','' '277','val_277','','','','' '277','val_277','','','','' '277','val_277','','','','' '277','val_277','','','','' '277','val_277','','','','' '277','val_277','','','','' '277','val_277','','','','' '277','val_277','','','','' '277','val_277','','','','' '278','val_278','','','','' '278','val_278','','','','' '278','val_278','','','','' '278','val_278','','','','' '28','val_28','','','','' '280','val_280','','','','' '280','val_280','','','','' '280','val_280','','','','' '280','val_280','','','','' '281','val_281','','','','' '281','val_281','','','','' '281','val_281','','','','' '281','val_281','','','','' '282','val_282','','','','' '282','val_282','','','','' '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','','','','' '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','','','','' '298','val_298','','','','' '298','val_298','','','','' '298','val_298','','','','' '298','val_298','','','','' '298','val_298','','','','' '298','val_298','','','','' '30','val_30','','','','' '302','val_302','','','','' '305','val_305','','','','' '306','val_306','','','','' '307','val_307','','','','' '307','val_307','','','','' '307','val_307','','','','' '307','val_307','','','','' '308','val_308','','','','' '309','val_309','','','','' '309','val_309','','','','' '309','val_309','','','','' '309','val_309','','','','' '310','val_310','','','','' '311','val_311','','','','' '311','val_311','','','','' '311','val_311','','','','' '311','val_311','','','','' '311','val_311','','','','' '311','val_311','','','','' '311','val_311','','','','' '311','val_311','','','','' '311','val_311','','','','' '315','val_315','','','','' '316','val_316','','','','' '316','val_316','','','','' '316','val_316','','','','' '316','val_316','','','','' '316','val_316','','','','' '316','val_316','','','','' '316','val_316','','','','' '316','val_316','','','','' '316','val_316','','','','' '317','val_317','','','','' '317','val_317','','','','' '317','val_317','','','','' '317','val_317','','','','' '318','val_318','','','','' '318','val_318','','','','' '318','val_318','','','','' '318','val_318','','','','' '318','val_318','','','','' '318','val_318','','','','' '318','val_318','','','','' '318','val_318','','','','' '318','val_318','','','','' '321','val_321','','','','' '321','val_321','','','','' '321','val_321','','','','' '321','val_321','','','','' '322','val_322','','','','' '322','val_322','','','','' '322','val_322','','','','' '322','val_322','','','','' '323','val_323','','','','' '325','val_325','','','','' '325','val_325','','','','' '325','val_325','','','','' '325','val_325','','','','' '327','val_327','','','','' '327','val_327','','','','' '327','val_327','','','','' '327','val_327','','','','' '327','val_327','','','','' '327','val_327','','','','' '327','val_327','','','','' '327','val_327','','','','' '327','val_327','','','','' '33','val_33','','','','' '331','val_331','','','','' '331','val_331','','','','' '331','val_331','','','','' '331','val_331','','','','' '332','val_332','','','','' '333','val_333','','','','' '333','val_333','','','','' '333','val_333','','','','' '333','val_333','','','','' '335','val_335','','','','' '336','val_336','','','','' '338','val_338','','','','' '339','val_339','','','','' '34','val_34','','','','' '341','val_341','','','','' '342','val_342','','','','' '342','val_342','','','','' '342','val_342','','','','' '342','val_342','','','','' '344','val_344','','','','' '344','val_344','','','','' '344','val_344','','','','' '344','val_344','','','','' '345','val_345','','','','' '348','val_348','','','','' '348','val_348','','','','' '348','val_348','','','','' '348','val_348','','','','' '348','val_348','','','','' '348','val_348','','','','' '348','val_348','','','','' '348','val_348','','','','' '348','val_348','','','','' '348','val_348','','','','' '348','val_348','','','','' '348','val_348','','','','' '348','val_348','','','','' '348','val_348','','','','' '348','val_348','','','','' '348','val_348','','','','' '348','val_348','','','','' '348','val_348','','','','' '348','val_348','','','','' '348','val_348','','','','' '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','','','','' '351','val_351','','','','' '353','val_353','','','','' '353','val_353','','','','' '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','','','','' '367','val_367','','','','' '367','val_367','','','','' '368','val_368','','','','' '369','val_369','','','','' '369','val_369','','','','' '369','val_369','','','','' '369','val_369','','','','' '369','val_369','','','','' '369','val_369','','','','' '369','val_369','','','','' '369','val_369','','','','' '369','val_369','','','','' '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','','','','' '382','val_382','','','','' '382','val_382','','','','' '384','val_384','','','','' '384','val_384','','','','' '384','val_384','','','','' '384','val_384','','','','' '384','val_384','','','','' '384','val_384','','','','' '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','','','','' '395','val_395','','','','' '395','val_395','','','','' '396','val_396','','','','' '396','val_396','','','','' '396','val_396','','','','' '396','val_396','','','','' '396','val_396','','','','' '396','val_396','','','','' '396','val_396','','','','' '396','val_396','','','','' '396','val_396','','','','' '397','val_397','','','','' '397','val_397','','','','' '397','val_397','','','','' '397','val_397','','','','' '399','val_399','','','','' '399','val_399','','','','' '399','val_399','','','','' '399','val_399','','','','' '4','val_4','','','','' '400','val_400','','','','' '401','val_401','','','','' '401','val_401','','','','' '401','val_401','','','','' '401','val_401','','','','' '401','val_401','','','','' '401','val_401','','','','' '401','val_401','','','','' '401','val_401','','','','' '401','val_401','','','','' '401','val_401','','','','' '401','val_401','','','','' '401','val_401','','','','' '401','val_401','','','','' '401','val_401','','','','' '401','val_401','','','','' '401','val_401','','','','' '401','val_401','','','','' '401','val_401','','','','' '401','val_401','','','','' '401','val_401','','','','' '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','','','','' '403','val_403','','','','' '403','val_403','','','','' '403','val_403','','','','' '403','val_403','','','','' '403','val_403','','','','' '403','val_403','','','','' '404','val_404','','','','' '404','val_404','','','','' '404','val_404','','','','' '404','val_404','','','','' '406','val_406','','','','' '406','val_406','','','','' '406','val_406','','','','' '406','val_406','','','','' '406','val_406','','','','' '406','val_406','','','','' '406','val_406','','','','' '406','val_406','','','','' '406','val_406','','','','' '406','val_406','','','','' '406','val_406','','','','' '406','val_406','','','','' '406','val_406','','','','' '406','val_406','','','','' '406','val_406','','','','' '406','val_406','','','','' '407','val_407','','','','' '409','val_409','','','','' '409','val_409','','','','' '409','val_409','','','','' '409','val_409','','','','' '409','val_409','','','','' '409','val_409','','','','' '409','val_409','','','','' '409','val_409','','','','' '409','val_409','','','','' '41','val_41','','','','' '411','val_411','','','','' '413','val_413','','','','' '413','val_413','','','','' '413','val_413','','','','' '413','val_413','','','','' '414','val_414','','','','' '414','val_414','','','','' '414','val_414','','','','' '414','val_414','','','','' '417','val_417','','','','' '417','val_417','','','','' '417','val_417','','','','' '417','val_417','','','','' '417','val_417','','','','' '417','val_417','','','','' '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','','','','' '421','val_421','','','','' '424','val_424','','','','' '424','val_424','','','','' '424','val_424','','','','' '424','val_424','','','','' '427','val_427','','','','' '429','val_429','','','','' '429','val_429','','','','' '429','val_429','','','','' '429','val_429','','','','' '43','val_43','','','','' '430','val_430','','','','' '430','val_430','','','','' '430','val_430','','','','' '430','val_430','','','','' '430','val_430','','','','' '430','val_430','','','','' '430','val_430','','','','' '430','val_430','','','','' '430','val_430','','','','' '431','val_431','','','','' '431','val_431','','','','' '431','val_431','','','','' '431','val_431','','','','' '431','val_431','','','','' '431','val_431','','','','' '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','','','','' '438','val_438','','','','' '438','val_438','','','','' '438','val_438','','','','' '438','val_438','','','','' '438','val_438','','','','' '438','val_438','','','','' '439','val_439','','','','' '439','val_439','','','','' '439','val_439','','','','' '439','val_439','','','','' '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','','','','' '454','val_454','','','','' '454','val_454','','','','' '454','val_454','','','','' '454','val_454','','','','' '454','val_454','','','','' '454','val_454','','','','' '455','val_455','','','','' '457','val_457','','','','' '458','val_458','','','','' '458','val_458','','','','' '458','val_458','','','','' '458','val_458','','','','' '459','val_459','','','','' '459','val_459','','','','' '459','val_459','','','','' '459','val_459','','','','' '460','val_460','','','','' '462','val_462','','','','' '462','val_462','','','','' '462','val_462','','','','' '462','val_462','','','','' '463','val_463','','','','' '463','val_463','','','','' '463','val_463','','','','' '463','val_463','','','','' '466','val_466','','','','' '466','val_466','','','','' '466','val_466','','','','' '466','val_466','','','','' '466','val_466','','','','' '466','val_466','','','','' '466','val_466','','','','' '466','val_466','','','','' '466','val_466','','','','' '467','val_467','','','','' '468','val_468','','','','' '468','val_468','','','','' '468','val_468','','','','' '468','val_468','','','','' '468','val_468','','','','' '468','val_468','','','','' '468','val_468','','','','' '468','val_468','','','','' '468','val_468','','','','' '468','val_468','','','','' '468','val_468','','','','' '468','val_468','','','','' '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','','','','' '469','val_469','','','','' '469','val_469','','','','' '469','val_469','','','','' '469','val_469','','','','' '469','val_469','','','','' '469','val_469','','','','' '469','val_469','','','','' '469','val_469','','','','' '469','val_469','','','','' '469','val_469','','','','' '469','val_469','','','','' '469','val_469','','','','' '469','val_469','','','','' '469','val_469','','','','' '469','val_469','','','','' '469','val_469','','','','' '469','val_469','','','','' '469','val_469','','','','' '469','val_469','','','','' '469','val_469','','','','' '47','val_47','','','','' '470','val_470','','','','' '472','val_472','','','','' '475','val_475','','','','' '477','val_477','','','','' '478','val_478','','','','' '478','val_478','','','','' '478','val_478','','','','' '478','val_478','','','','' '479','val_479','','','','' '480','val_480','','','','' '480','val_480','','','','' '480','val_480','','','','' '480','val_480','','','','' '480','val_480','','','','' '480','val_480','','','','' '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','','','','' '489','val_489','','','','' '489','val_489','','','','' '489','val_489','','','','' '489','val_489','','','','' '489','val_489','','','','' '489','val_489','','','','' '489','val_489','','','','' '489','val_489','','','','' '489','val_489','','','','' '489','val_489','','','','' '489','val_489','','','','' '489','val_489','','','','' '490','val_490','','','','' '491','val_491','','','','' '492','val_492','','','','' '492','val_492','','','','' '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','','','','' '498','val_498','','','','' '498','val_498','','','','' '498','val_498','','','','' '498','val_498','','','','' '498','val_498','','','','' '498','val_498','','','','' '5','val_5','','','','' '5','val_5','','','','' '5','val_5','','','','' '51','val_51','','','','' '51','val_51','','','','' '51','val_51','','','','' '51','val_51','','','','' '53','val_53','','','','' '54','val_54','','','','' '57','val_57','','','','' '58','val_58','','','','' '58','val_58','','','','' '58','val_58','','','','' '58','val_58','','','','' '64','val_64','','','','' '65','val_65','','','','' '66','val_66','','','','' '67','val_67','','','','' '67','val_67','','','','' '67','val_67','','','','' '67','val_67','','','','' '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','','','','' '72','val_72','','','','' '72','val_72','','','','' '72','val_72','','','','' '72','val_72','','','','' '74','val_74','','','','' '76','val_76','','','','' '76','val_76','','','','' '76','val_76','','','','' '76','val_76','','','','' '77','val_77','','','','' '78','val_78','','','','' '8','val_8','','','','' '80','val_80','','','','' '82','val_82','','','','' '83','val_83','','','','' '83','val_83','','','','' '83','val_83','','','','' '83','val_83','','','','' '84','val_84','','','','' '84','val_84','','','','' '84','val_84','','','','' '84','val_84','','','','' '85','val_85','','','','' '86','val_86','','','','' '87','val_87','','','','' '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','','','','' '92','val_92','','','','' '95','val_95','','','','' '95','val_95','','','','' '95','val_95','','','','' '95','val_95','','','','' '96','val_96','','','','' '97','val_97','','','','' '97','val_97','','','','' '97','val_97','','','','' '97','val_97','','','','' '98','val_98','','','','' '98','val_98','','','','' '98','val_98','','','','' '98','val_98','','','','' 1,016 rows selected >>> >>> explain SELECT * FROM src src1 RIGHT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) LEFT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value; 'Explain' 'ABSTRACT SYNTAX TREE:' ' (TOK_QUERY (TOK_FROM (TOK_LEFTOUTERJOIN (TOK_RIGHTOUTERJOIN (TOK_TABREF (TOK_TABNAME src) src1) (TOK_TABREF (TOK_TABNAME src) src2) (AND (AND (= (. (TOK_TABLE_OR_COL src1) key) (. (TOK_TABLE_OR_COL src2) key)) (< (. (TOK_TABLE_OR_COL src1) key) 10)) (> (. (TOK_TABLE_OR_COL src2) key) 10))) (TOK_TABREF (TOK_TABNAME src) src3) (AND (= (. (TOK_TABLE_OR_COL src2) key) (. (TOK_TABLE_OR_COL src3) key)) (< (. (TOK_TABLE_OR_COL src3) key) 10)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_SORTBY (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src1) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src1) value)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src2) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src2) value)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src3) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src3) value)))))' '' 'STAGE DEPENDENCIES:' ' Stage-6 is a root stage , consists of Stage-7, Stage-1' ' Stage-7 has a backup stage: Stage-1' ' Stage-5 depends on stages: Stage-7' ' Stage-2 depends on stages: Stage-1, Stage-5' ' Stage-1' ' Stage-0 is a root stage' '' 'STAGE PLANS:' ' Stage: Stage-6' ' Conditional Operator' '' ' Stage: Stage-7' ' Map Reduce Local Work' ' Alias -> Map Local Tables:' ' src1 ' ' Fetch Operator' ' limit: -1' ' src3 ' ' Fetch Operator' ' limit: -1' ' Alias -> Map Local Operator Tree:' ' src1 ' ' TableScan' ' alias: src1' ' Filter Operator' ' predicate:' ' expr: (key < 10)' ' type: boolean' ' HashTable Sink Operator' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' filter predicates:' ' 0 ' ' 1 {(key > 10)}' ' 2 ' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' Position of Big Table: 1' ' src3 ' ' TableScan' ' alias: src3' ' Filter Operator' ' predicate:' ' expr: (key < 10)' ' type: boolean' ' HashTable Sink Operator' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' filter predicates:' ' 0 ' ' 1 {(key > 10)}' ' 2 ' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' Position of Big Table: 1' '' ' Stage: Stage-5' ' Map Reduce' ' Alias -> Map Operator Tree:' ' src2 ' ' TableScan' ' alias: src2' ' Map Join Operator' ' condition map:' ' Right Outer Join0 to 1' ' Left Outer Join1 to 2' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' filter predicates:' ' 0 ' ' 1 {(key > 10)}' ' 2 ' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9' ' Position of Big Table: 1' ' Select Operator' ' expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' expr: _col8' ' type: string' ' expr: _col9' ' type: string' ' outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5' ' File Output Operator' ' compressed: false' ' GlobalTableId: 0' ' table:' ' input format: org.apache.hadoop.mapred.SequenceFileInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat' ' Local Work:' ' Map Reduce Local Work' '' ' Stage: Stage-2' ' Map Reduce' ' Alias -> Map Operator Tree:' ' file:!!{hive.exec.scratchdir}!! ' ' Reduce Output Operator' ' key expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col2' ' type: string' ' expr: _col3' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' sort order: ++++++' ' tag: -1' ' value expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col2' ' type: string' ' expr: _col3' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' Reduce Operator Tree:' ' Extract' ' 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-1' ' Map Reduce' ' Alias -> Map Operator Tree:' ' src1 ' ' TableScan' ' alias: src1' ' Filter Operator' ' predicate:' ' expr: (key < 10)' ' type: boolean' ' Reduce Output Operator' ' key expressions:' ' expr: key' ' type: string' ' sort order: +' ' Map-reduce partition columns:' ' expr: key' ' type: string' ' tag: 0' ' value expressions:' ' expr: key' ' type: string' ' expr: value' ' type: string' ' src2 ' ' TableScan' ' alias: src2' ' Reduce Output Operator' ' key expressions:' ' expr: key' ' type: string' ' sort order: +' ' Map-reduce partition columns:' ' expr: key' ' type: string' ' tag: 1' ' value expressions:' ' expr: key' ' type: string' ' expr: value' ' type: string' ' src3 ' ' TableScan' ' alias: src3' ' Filter Operator' ' predicate:' ' expr: (key < 10)' ' type: boolean' ' Reduce Output Operator' ' key expressions:' ' expr: key' ' type: string' ' sort order: +' ' Map-reduce partition columns:' ' expr: key' ' type: string' ' tag: 2' ' value expressions:' ' expr: key' ' type: string' ' expr: value' ' type: string' ' Reduce Operator Tree:' ' Join Operator' ' condition map:' ' Right Outer Join0 to 1' ' Left Outer Join1 to 2' ' condition expressions:' ' 0 {VALUE._col0} {VALUE._col1}' ' 1 {VALUE._col0} {VALUE._col1}' ' 2 {VALUE._col0} {VALUE._col1}' ' filter predicates:' ' 0 ' ' 1 {(VALUE._col0 > 10)}' ' 2 ' ' handleSkewJoin: false' ' outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9' ' Select Operator' ' expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' expr: _col8' ' type: string' ' expr: _col9' ' type: string' ' outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5' ' File Output Operator' ' compressed: false' ' GlobalTableId: 0' ' table:' ' input format: org.apache.hadoop.mapred.SequenceFileInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat' '' ' Stage: Stage-0' ' Fetch Operator' ' limit: -1' '' '' 265 rows selected >>> >>> SELECT * FROM src src1 RIGHT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) LEFT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value; 'key','value','key','value','key','value' '','','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' '','','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' '','','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','','' '','','100','val_100','','' '','','100','val_100','','' '','','103','val_103','','' '','','103','val_103','','' '','','104','val_104','','' '','','104','val_104','','' '','','105','val_105','','' '','','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','','' '','','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','','' '','','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','','' '','','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','','' '','','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','','' '','','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','','' '','','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','','' '','','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','','' '','','260','val_260','','' '','','262','val_262','','' '','','263','val_263','','' '','','265','val_265','','' '','','265','val_265','','' '','','266','val_266','','' '','','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','','' '','','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','','' '','','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','','' '','','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','','' '','','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','','' '','','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','','' '','','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','','' '','','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','','' '','','421','val_421','','' '','','424','val_424','','' '','','424','val_424','','' '','','427','val_427','','' '','','429','val_429','','' '','','429','val_429','','' '','','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','','' '','','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','','' '','','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' '','','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' '','','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','','' '','','53','val_53','','' '','','54','val_54','','' '','','57','val_57','','' '','','58','val_58','','' '','','58','val_58','','' '','','64','val_64','','' '','','65','val_65','','' '','','66','val_66','','' '','','67','val_67','','' '','','67','val_67','','' '','','69','val_69','','' '','','70','val_70','','' '','','70','val_70','','' '','','70','val_70','','' '','','72','val_72','','' '','','72','val_72','','' '','','74','val_74','','' '','','76','val_76','','' '','','76','val_76','','' '','','77','val_77','','' '','','78','val_78','','' '','','8','val_8','8','val_8' '','','80','val_80','','' '','','82','val_82','','' '','','83','val_83','','' '','','83','val_83','','' '','','84','val_84','','' '','','84','val_84','','' '','','85','val_85','','' '','','86','val_86','','' '','','87','val_87','','' '','','9','val_9','9','val_9' '','','90','val_90','','' '','','90','val_90','','' '','','90','val_90','','' '','','92','val_92','','' '','','95','val_95','','' '','','95','val_95','','' '','','96','val_96','','' '','','97','val_97','','' '','','97','val_97','','' '','','98','val_98','','' '','','98','val_98','','' 548 rows selected >>> >>> explain SELECT * FROM src src1 RIGHT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) RIGHT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value; 'Explain' 'ABSTRACT SYNTAX TREE:' ' (TOK_QUERY (TOK_FROM (TOK_RIGHTOUTERJOIN (TOK_RIGHTOUTERJOIN (TOK_TABREF (TOK_TABNAME src) src1) (TOK_TABREF (TOK_TABNAME src) src2) (AND (AND (= (. (TOK_TABLE_OR_COL src1) key) (. (TOK_TABLE_OR_COL src2) key)) (< (. (TOK_TABLE_OR_COL src1) key) 10)) (> (. (TOK_TABLE_OR_COL src2) key) 10))) (TOK_TABREF (TOK_TABNAME src) src3) (AND (= (. (TOK_TABLE_OR_COL src2) key) (. (TOK_TABLE_OR_COL src3) key)) (< (. (TOK_TABLE_OR_COL src3) key) 10)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_SORTBY (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src1) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src1) value)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src2) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src2) value)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src3) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src3) value)))))' '' 'STAGE DEPENDENCIES:' ' Stage-6 is a root stage , consists of Stage-7, Stage-1' ' Stage-7 has a backup stage: Stage-1' ' Stage-5 depends on stages: Stage-7' ' Stage-2 depends on stages: Stage-1, Stage-5' ' Stage-1' ' Stage-0 is a root stage' '' 'STAGE PLANS:' ' Stage: Stage-6' ' Conditional Operator' '' ' Stage: Stage-7' ' Map Reduce Local Work' ' Alias -> Map Local Tables:' ' src1 ' ' Fetch Operator' ' limit: -1' ' src2 ' ' Fetch Operator' ' limit: -1' ' Alias -> Map Local Operator Tree:' ' src1 ' ' TableScan' ' alias: src1' ' Filter Operator' ' predicate:' ' expr: (key < 10)' ' type: boolean' ' HashTable Sink Operator' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' filter predicates:' ' 0 ' ' 1 {(key > 10)}' ' 2 {(key < 10)}' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' Position of Big Table: 2' ' src2 ' ' TableScan' ' alias: src2' ' HashTable Sink Operator' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' filter predicates:' ' 0 ' ' 1 {(key > 10)}' ' 2 {(key < 10)}' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' Position of Big Table: 2' '' ' Stage: Stage-5' ' Map Reduce' ' Alias -> Map Operator Tree:' ' src3 ' ' TableScan' ' alias: src3' ' Map Join Operator' ' condition map:' ' Right Outer Join0 to 1' ' Right Outer Join1 to 2' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' filter predicates:' ' 0 ' ' 1 {(key > 10)}' ' 2 {(key < 10)}' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9' ' Position of Big Table: 2' ' Select Operator' ' expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' expr: _col8' ' type: string' ' expr: _col9' ' type: string' ' outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5' ' File Output Operator' ' compressed: false' ' GlobalTableId: 0' ' table:' ' input format: org.apache.hadoop.mapred.SequenceFileInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat' ' Local Work:' ' Map Reduce Local Work' '' ' Stage: Stage-2' ' Map Reduce' ' Alias -> Map Operator Tree:' ' file:!!{hive.exec.scratchdir}!! ' ' Reduce Output Operator' ' key expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col2' ' type: string' ' expr: _col3' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' sort order: ++++++' ' tag: -1' ' value expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col2' ' type: string' ' expr: _col3' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' Reduce Operator Tree:' ' Extract' ' 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-1' ' Map Reduce' ' Alias -> Map Operator Tree:' ' src1 ' ' TableScan' ' alias: src1' ' Filter Operator' ' predicate:' ' expr: (key < 10)' ' type: boolean' ' Reduce Output Operator' ' key expressions:' ' expr: key' ' type: string' ' sort order: +' ' Map-reduce partition columns:' ' expr: key' ' type: string' ' tag: 0' ' value expressions:' ' expr: key' ' type: string' ' expr: value' ' type: string' ' src2 ' ' TableScan' ' alias: src2' ' Reduce Output Operator' ' key expressions:' ' expr: key' ' type: string' ' sort order: +' ' Map-reduce partition columns:' ' expr: key' ' type: string' ' tag: 1' ' value expressions:' ' expr: key' ' type: string' ' expr: value' ' type: string' ' src3 ' ' TableScan' ' alias: src3' ' Reduce Output Operator' ' key expressions:' ' expr: key' ' type: string' ' sort order: +' ' Map-reduce partition columns:' ' expr: key' ' type: string' ' tag: 2' ' value expressions:' ' expr: key' ' type: string' ' expr: value' ' type: string' ' Reduce Operator Tree:' ' Join Operator' ' condition map:' ' Right Outer Join0 to 1' ' Right Outer Join1 to 2' ' condition expressions:' ' 0 {VALUE._col0} {VALUE._col1}' ' 1 {VALUE._col0} {VALUE._col1}' ' 2 {VALUE._col0} {VALUE._col1}' ' filter predicates:' ' 0 ' ' 1 {(VALUE._col0 > 10)}' ' 2 {(VALUE._col0 < 10)}' ' handleSkewJoin: false' ' outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9' ' Select Operator' ' expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' expr: _col8' ' type: string' ' expr: _col9' ' type: string' ' outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5' ' File Output Operator' ' compressed: false' ' GlobalTableId: 0' ' table:' ' input format: org.apache.hadoop.mapred.SequenceFileInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat' '' ' Stage: Stage-0' ' Fetch Operator' ' limit: -1' '' '' 257 rows selected >>> >>> SELECT * FROM src src1 RIGHT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) RIGHT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value; 'key','value','key','value','key','value' '','','','','10','val_10' '','','','','100','val_100' '','','','','100','val_100' '','','','','100','val_100' '','','','','100','val_100' '','','','','103','val_103' '','','','','103','val_103' '','','','','103','val_103' '','','','','103','val_103' '','','','','104','val_104' '','','','','104','val_104' '','','','','104','val_104' '','','','','104','val_104' '','','','','105','val_105' '','','','','11','val_11' '','','','','111','val_111' '','','','','113','val_113' '','','','','113','val_113' '','','','','113','val_113' '','','','','113','val_113' '','','','','114','val_114' '','','','','116','val_116' '','','','','118','val_118' '','','','','118','val_118' '','','','','118','val_118' '','','','','118','val_118' '','','','','119','val_119' '','','','','119','val_119' '','','','','119','val_119' '','','','','119','val_119' '','','','','119','val_119' '','','','','119','val_119' '','','','','119','val_119' '','','','','119','val_119' '','','','','119','val_119' '','','','','12','val_12' '','','','','12','val_12' '','','','','12','val_12' '','','','','12','val_12' '','','','','120','val_120' '','','','','120','val_120' '','','','','120','val_120' '','','','','120','val_120' '','','','','125','val_125' '','','','','125','val_125' '','','','','125','val_125' '','','','','125','val_125' '','','','','126','val_126' '','','','','128','val_128' '','','','','128','val_128' '','','','','128','val_128' '','','','','128','val_128' '','','','','128','val_128' '','','','','128','val_128' '','','','','128','val_128' '','','','','128','val_128' '','','','','128','val_128' '','','','','129','val_129' '','','','','129','val_129' '','','','','129','val_129' '','','','','129','val_129' '','','','','131','val_131' '','','','','133','val_133' '','','','','134','val_134' '','','','','134','val_134' '','','','','134','val_134' '','','','','134','val_134' '','','','','136','val_136' '','','','','137','val_137' '','','','','137','val_137' '','','','','137','val_137' '','','','','137','val_137' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','138','val_138' '','','','','143','val_143' '','','','','145','val_145' '','','','','146','val_146' '','','','','146','val_146' '','','','','146','val_146' '','','','','146','val_146' '','','','','149','val_149' '','','','','149','val_149' '','','','','149','val_149' '','','','','149','val_149' '','','','','15','val_15' '','','','','15','val_15' '','','','','15','val_15' '','','','','15','val_15' '','','','','150','val_150' '','','','','152','val_152' '','','','','152','val_152' '','','','','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' '','','','','164','val_164' '','','','','164','val_164' '','','','','165','val_165' '','','','','165','val_165' '','','','','165','val_165' '','','','','165','val_165' '','','','','166','val_166' '','','','','167','val_167' '','','','','167','val_167' '','','','','167','val_167' '','','','','167','val_167' '','','','','167','val_167' '','','','','167','val_167' '','','','','167','val_167' '','','','','167','val_167' '','','','','167','val_167' '','','','','168','val_168' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','169','val_169' '','','','','17','val_17' '','','','','170','val_170' '','','','','172','val_172' '','','','','172','val_172' '','','','','172','val_172' '','','','','172','val_172' '','','','','174','val_174' '','','','','174','val_174' '','','','','174','val_174' '','','','','174','val_174' '','','','','175','val_175' '','','','','175','val_175' '','','','','175','val_175' '','','','','175','val_175' '','','','','176','val_176' '','','','','176','val_176' '','','','','176','val_176' '','','','','176','val_176' '','','','','177','val_177' '','','','','178','val_178' '','','','','179','val_179' '','','','','179','val_179' '','','','','179','val_179' '','','','','179','val_179' '','','','','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' '','','','','187','val_187' '','','','','187','val_187' '','','','','187','val_187' '','','','','187','val_187' '','','','','187','val_187' '','','','','187','val_187' '','','','','189','val_189' '','','','','19','val_19' '','','','','190','val_190' '','','','','191','val_191' '','','','','191','val_191' '','','','','191','val_191' '','','','','191','val_191' '','','','','192','val_192' '','','','','193','val_193' '','','','','193','val_193' '','','','','193','val_193' '','','','','193','val_193' '','','','','193','val_193' '','','','','193','val_193' '','','','','193','val_193' '','','','','193','val_193' '','','','','193','val_193' '','','','','194','val_194' '','','','','195','val_195' '','','','','195','val_195' '','','','','195','val_195' '','','','','195','val_195' '','','','','196','val_196' '','','','','197','val_197' '','','','','197','val_197' '','','','','197','val_197' '','','','','197','val_197' '','','','','199','val_199' '','','','','199','val_199' '','','','','199','val_199' '','','','','199','val_199' '','','','','199','val_199' '','','','','199','val_199' '','','','','199','val_199' '','','','','199','val_199' '','','','','199','val_199' '','','','','20','val_20' '','','','','200','val_200' '','','','','200','val_200' '','','','','200','val_200' '','','','','200','val_200' '','','','','201','val_201' '','','','','202','val_202' '','','','','203','val_203' '','','','','203','val_203' '','','','','203','val_203' '','','','','203','val_203' '','','','','205','val_205' '','','','','205','val_205' '','','','','205','val_205' '','','','','205','val_205' '','','','','207','val_207' '','','','','207','val_207' '','','','','207','val_207' '','','','','207','val_207' '','','','','208','val_208' '','','','','208','val_208' '','','','','208','val_208' '','','','','208','val_208' '','','','','208','val_208' '','','','','208','val_208' '','','','','208','val_208' '','','','','208','val_208' '','','','','208','val_208' '','','','','209','val_209' '','','','','209','val_209' '','','','','209','val_209' '','','','','209','val_209' '','','','','213','val_213' '','','','','213','val_213' '','','','','213','val_213' '','','','','213','val_213' '','','','','214','val_214' '','','','','216','val_216' '','','','','216','val_216' '','','','','216','val_216' '','','','','216','val_216' '','','','','217','val_217' '','','','','217','val_217' '','','','','217','val_217' '','','','','217','val_217' '','','','','218','val_218' '','','','','219','val_219' '','','','','219','val_219' '','','','','219','val_219' '','','','','219','val_219' '','','','','221','val_221' '','','','','221','val_221' '','','','','221','val_221' '','','','','221','val_221' '','','','','222','val_222' '','','','','223','val_223' '','','','','223','val_223' '','','','','223','val_223' '','','','','223','val_223' '','','','','224','val_224' '','','','','224','val_224' '','','','','224','val_224' '','','','','224','val_224' '','','','','226','val_226' '','','','','228','val_228' '','','','','229','val_229' '','','','','229','val_229' '','','','','229','val_229' '','','','','229','val_229' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','230','val_230' '','','','','233','val_233' '','','','','233','val_233' '','','','','233','val_233' '','','','','233','val_233' '','','','','235','val_235' '','','','','237','val_237' '','','','','237','val_237' '','','','','237','val_237' '','','','','237','val_237' '','','','','238','val_238' '','','','','238','val_238' '','','','','238','val_238' '','','','','238','val_238' '','','','','239','val_239' '','','','','239','val_239' '','','','','239','val_239' '','','','','239','val_239' '','','','','24','val_24' '','','','','24','val_24' '','','','','24','val_24' '','','','','24','val_24' '','','','','241','val_241' '','','','','242','val_242' '','','','','242','val_242' '','','','','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' '','','','','255','val_255' '','','','','255','val_255' '','','','','256','val_256' '','','','','256','val_256' '','','','','256','val_256' '','','','','256','val_256' '','','','','257','val_257' '','','','','258','val_258' '','','','','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' '','','','','265','val_265' '','','','','265','val_265' '','','','','266','val_266' '','','','','27','val_27' '','','','','272','val_272' '','','','','272','val_272' '','','','','272','val_272' '','','','','272','val_272' '','','','','273','val_273' '','','','','273','val_273' '','','','','273','val_273' '','','','','273','val_273' '','','','','273','val_273' '','','','','273','val_273' '','','','','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' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','277','val_277' '','','','','278','val_278' '','','','','278','val_278' '','','','','278','val_278' '','','','','278','val_278' '','','','','28','val_28' '','','','','280','val_280' '','','','','280','val_280' '','','','','280','val_280' '','','','','280','val_280' '','','','','281','val_281' '','','','','281','val_281' '','','','','281','val_281' '','','','','281','val_281' '','','','','282','val_282' '','','','','282','val_282' '','','','','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' '','','','','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' '','','','','298','val_298' '','','','','298','val_298' '','','','','298','val_298' '','','','','298','val_298' '','','','','298','val_298' '','','','','298','val_298' '','','','','30','val_30' '','','','','302','val_302' '','','','','305','val_305' '','','','','306','val_306' '','','','','307','val_307' '','','','','307','val_307' '','','','','307','val_307' '','','','','307','val_307' '','','','','308','val_308' '','','','','309','val_309' '','','','','309','val_309' '','','','','309','val_309' '','','','','309','val_309' '','','','','310','val_310' '','','','','311','val_311' '','','','','311','val_311' '','','','','311','val_311' '','','','','311','val_311' '','','','','311','val_311' '','','','','311','val_311' '','','','','311','val_311' '','','','','311','val_311' '','','','','311','val_311' '','','','','315','val_315' '','','','','316','val_316' '','','','','316','val_316' '','','','','316','val_316' '','','','','316','val_316' '','','','','316','val_316' '','','','','316','val_316' '','','','','316','val_316' '','','','','316','val_316' '','','','','316','val_316' '','','','','317','val_317' '','','','','317','val_317' '','','','','317','val_317' '','','','','317','val_317' '','','','','318','val_318' '','','','','318','val_318' '','','','','318','val_318' '','','','','318','val_318' '','','','','318','val_318' '','','','','318','val_318' '','','','','318','val_318' '','','','','318','val_318' '','','','','318','val_318' '','','','','321','val_321' '','','','','321','val_321' '','','','','321','val_321' '','','','','321','val_321' '','','','','322','val_322' '','','','','322','val_322' '','','','','322','val_322' '','','','','322','val_322' '','','','','323','val_323' '','','','','325','val_325' '','','','','325','val_325' '','','','','325','val_325' '','','','','325','val_325' '','','','','327','val_327' '','','','','327','val_327' '','','','','327','val_327' '','','','','327','val_327' '','','','','327','val_327' '','','','','327','val_327' '','','','','327','val_327' '','','','','327','val_327' '','','','','327','val_327' '','','','','33','val_33' '','','','','331','val_331' '','','','','331','val_331' '','','','','331','val_331' '','','','','331','val_331' '','','','','332','val_332' '','','','','333','val_333' '','','','','333','val_333' '','','','','333','val_333' '','','','','333','val_333' '','','','','335','val_335' '','','','','336','val_336' '','','','','338','val_338' '','','','','339','val_339' '','','','','34','val_34' '','','','','341','val_341' '','','','','342','val_342' '','','','','342','val_342' '','','','','342','val_342' '','','','','342','val_342' '','','','','344','val_344' '','','','','344','val_344' '','','','','344','val_344' '','','','','344','val_344' '','','','','345','val_345' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','348','val_348' '','','','','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' '','','','','351','val_351' '','','','','353','val_353' '','','','','353','val_353' '','','','','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' '','','','','367','val_367' '','','','','367','val_367' '','','','','368','val_368' '','','','','369','val_369' '','','','','369','val_369' '','','','','369','val_369' '','','','','369','val_369' '','','','','369','val_369' '','','','','369','val_369' '','','','','369','val_369' '','','','','369','val_369' '','','','','369','val_369' '','','','','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' '','','','','382','val_382' '','','','','382','val_382' '','','','','384','val_384' '','','','','384','val_384' '','','','','384','val_384' '','','','','384','val_384' '','','','','384','val_384' '','','','','384','val_384' '','','','','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' '','','','','395','val_395' '','','','','395','val_395' '','','','','396','val_396' '','','','','396','val_396' '','','','','396','val_396' '','','','','396','val_396' '','','','','396','val_396' '','','','','396','val_396' '','','','','396','val_396' '','','','','396','val_396' '','','','','396','val_396' '','','','','397','val_397' '','','','','397','val_397' '','','','','397','val_397' '','','','','397','val_397' '','','','','399','val_399' '','','','','399','val_399' '','','','','399','val_399' '','','','','399','val_399' '','','','','400','val_400' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','401','val_401' '','','','','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' '','','','','403','val_403' '','','','','403','val_403' '','','','','403','val_403' '','','','','403','val_403' '','','','','403','val_403' '','','','','403','val_403' '','','','','404','val_404' '','','','','404','val_404' '','','','','404','val_404' '','','','','404','val_404' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','406','val_406' '','','','','407','val_407' '','','','','409','val_409' '','','','','409','val_409' '','','','','409','val_409' '','','','','409','val_409' '','','','','409','val_409' '','','','','409','val_409' '','','','','409','val_409' '','','','','409','val_409' '','','','','409','val_409' '','','','','41','val_41' '','','','','411','val_411' '','','','','413','val_413' '','','','','413','val_413' '','','','','413','val_413' '','','','','413','val_413' '','','','','414','val_414' '','','','','414','val_414' '','','','','414','val_414' '','','','','414','val_414' '','','','','417','val_417' '','','','','417','val_417' '','','','','417','val_417' '','','','','417','val_417' '','','','','417','val_417' '','','','','417','val_417' '','','','','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' '','','','','421','val_421' '','','','','424','val_424' '','','','','424','val_424' '','','','','424','val_424' '','','','','424','val_424' '','','','','427','val_427' '','','','','429','val_429' '','','','','429','val_429' '','','','','429','val_429' '','','','','429','val_429' '','','','','43','val_43' '','','','','430','val_430' '','','','','430','val_430' '','','','','430','val_430' '','','','','430','val_430' '','','','','430','val_430' '','','','','430','val_430' '','','','','430','val_430' '','','','','430','val_430' '','','','','430','val_430' '','','','','431','val_431' '','','','','431','val_431' '','','','','431','val_431' '','','','','431','val_431' '','','','','431','val_431' '','','','','431','val_431' '','','','','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' '','','','','438','val_438' '','','','','438','val_438' '','','','','438','val_438' '','','','','438','val_438' '','','','','438','val_438' '','','','','438','val_438' '','','','','439','val_439' '','','','','439','val_439' '','','','','439','val_439' '','','','','439','val_439' '','','','','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' '','','','','454','val_454' '','','','','454','val_454' '','','','','454','val_454' '','','','','454','val_454' '','','','','454','val_454' '','','','','454','val_454' '','','','','455','val_455' '','','','','457','val_457' '','','','','458','val_458' '','','','','458','val_458' '','','','','458','val_458' '','','','','458','val_458' '','','','','459','val_459' '','','','','459','val_459' '','','','','459','val_459' '','','','','459','val_459' '','','','','460','val_460' '','','','','462','val_462' '','','','','462','val_462' '','','','','462','val_462' '','','','','462','val_462' '','','','','463','val_463' '','','','','463','val_463' '','','','','463','val_463' '','','','','463','val_463' '','','','','466','val_466' '','','','','466','val_466' '','','','','466','val_466' '','','','','466','val_466' '','','','','466','val_466' '','','','','466','val_466' '','','','','466','val_466' '','','','','466','val_466' '','','','','466','val_466' '','','','','467','val_467' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','468','val_468' '','','','','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' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','469','val_469' '','','','','47','val_47' '','','','','470','val_470' '','','','','472','val_472' '','','','','475','val_475' '','','','','477','val_477' '','','','','478','val_478' '','','','','478','val_478' '','','','','478','val_478' '','','','','478','val_478' '','','','','479','val_479' '','','','','480','val_480' '','','','','480','val_480' '','','','','480','val_480' '','','','','480','val_480' '','','','','480','val_480' '','','','','480','val_480' '','','','','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' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','489','val_489' '','','','','490','val_490' '','','','','491','val_491' '','','','','492','val_492' '','','','','492','val_492' '','','','','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' '','','','','498','val_498' '','','','','498','val_498' '','','','','498','val_498' '','','','','498','val_498' '','','','','498','val_498' '','','','','498','val_498' '','','','','51','val_51' '','','','','51','val_51' '','','','','51','val_51' '','','','','51','val_51' '','','','','53','val_53' '','','','','54','val_54' '','','','','57','val_57' '','','','','58','val_58' '','','','','58','val_58' '','','','','58','val_58' '','','','','58','val_58' '','','','','64','val_64' '','','','','65','val_65' '','','','','66','val_66' '','','','','67','val_67' '','','','','67','val_67' '','','','','67','val_67' '','','','','67','val_67' '','','','','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' '','','','','72','val_72' '','','','','72','val_72' '','','','','72','val_72' '','','','','72','val_72' '','','','','74','val_74' '','','','','76','val_76' '','','','','76','val_76' '','','','','76','val_76' '','','','','76','val_76' '','','','','77','val_77' '','','','','78','val_78' '','','','','80','val_80' '','','','','82','val_82' '','','','','83','val_83' '','','','','83','val_83' '','','','','83','val_83' '','','','','83','val_83' '','','','','84','val_84' '','','','','84','val_84' '','','','','84','val_84' '','','','','84','val_84' '','','','','85','val_85' '','','','','86','val_86' '','','','','87','val_87' '','','','','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' '','','','','95','val_95' '','','','','95','val_95' '','','','','95','val_95' '','','','','95','val_95' '','','','','96','val_96' '','','','','97','val_97' '','','','','97','val_97' '','','','','97','val_97' '','','','','97','val_97' '','','','','98','val_98' '','','','','98','val_98' '','','','','98','val_98' '','','','','98','val_98' '','','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' '','','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' '','','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' '','','2','val_2','2','val_2' '','','4','val_4','4','val_4' '','','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' '','','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' '','','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' '','','8','val_8','8','val_8' '','','9','val_9','9','val_9' 1,064 rows selected >>> >>> explain SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) LEFT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value; 'Explain' 'ABSTRACT SYNTAX TREE:' ' (TOK_QUERY (TOK_FROM (TOK_LEFTOUTERJOIN (TOK_JOIN (TOK_TABREF (TOK_TABNAME src) src1) (TOK_TABREF (TOK_TABNAME src) src2) (AND (AND (= (. (TOK_TABLE_OR_COL src1) key) (. (TOK_TABLE_OR_COL src2) key)) (< (. (TOK_TABLE_OR_COL src1) key) 10)) (> (. (TOK_TABLE_OR_COL src2) key) 10))) (TOK_TABREF (TOK_TABNAME src) src3) (AND (= (. (TOK_TABLE_OR_COL src2) key) (. (TOK_TABLE_OR_COL src3) key)) (< (. (TOK_TABLE_OR_COL src3) key) 10)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_SORTBY (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src1) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src1) value)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src2) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src2) value)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src3) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src3) value)))))' '' 'STAGE DEPENDENCIES:' ' Stage-7 is a root stage , consists of Stage-8, Stage-9, Stage-1' ' Stage-8 has a backup stage: Stage-1' ' Stage-5 depends on stages: Stage-8' ' Stage-2 depends on stages: Stage-1, Stage-5, Stage-6' ' Stage-9 has a backup stage: Stage-1' ' Stage-6 depends on stages: Stage-9' ' Stage-1' ' Stage-0 is a root stage' '' 'STAGE PLANS:' ' Stage: Stage-7' ' Conditional Operator' '' ' Stage: Stage-8' ' Map Reduce Local Work' ' Alias -> Map Local Tables:' ' src2 ' ' Fetch Operator' ' limit: -1' ' src3 ' ' Fetch Operator' ' limit: -1' ' Alias -> Map Local Operator Tree:' ' src2 ' ' TableScan' ' alias: src2' ' Filter Operator' ' predicate:' ' expr: ((key > 10) and (key < 10))' ' type: boolean' ' HashTable Sink Operator' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' Position of Big Table: 0' ' src3 ' ' TableScan' ' alias: src3' ' Filter Operator' ' predicate:' ' expr: ((key < 10) and (key > 10))' ' type: boolean' ' HashTable Sink Operator' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' Position of Big Table: 0' '' ' Stage: Stage-5' ' Map Reduce' ' Alias -> Map Operator Tree:' ' src1 ' ' TableScan' ' alias: src1' ' Filter Operator' ' predicate:' ' expr: ((key < 10) and (key > 10))' ' type: boolean' ' Map Join Operator' ' condition map:' ' Inner Join 0 to 1' ' Left Outer Join1 to 2' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9' ' Position of Big Table: 0' ' Select Operator' ' expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' expr: _col8' ' type: string' ' expr: _col9' ' type: string' ' outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5' ' File Output Operator' ' compressed: false' ' GlobalTableId: 0' ' table:' ' input format: org.apache.hadoop.mapred.SequenceFileInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat' ' Local Work:' ' Map Reduce Local Work' '' ' Stage: Stage-2' ' Map Reduce' ' Alias -> Map Operator Tree:' ' file:!!{hive.exec.scratchdir}!! ' ' Reduce Output Operator' ' key expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col2' ' type: string' ' expr: _col3' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' sort order: ++++++' ' tag: -1' ' value expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col2' ' type: string' ' expr: _col3' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' Reduce Operator Tree:' ' Extract' ' 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-9' ' Map Reduce Local Work' ' Alias -> Map Local Tables:' ' src1 ' ' Fetch Operator' ' limit: -1' ' src3 ' ' Fetch Operator' ' limit: -1' ' Alias -> Map Local Operator Tree:' ' src1 ' ' TableScan' ' alias: src1' ' Filter Operator' ' predicate:' ' expr: ((key < 10) and (key > 10))' ' type: boolean' ' HashTable Sink Operator' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' Position of Big Table: 1' ' src3 ' ' TableScan' ' alias: src3' ' Filter Operator' ' predicate:' ' expr: ((key < 10) and (key > 10))' ' type: boolean' ' HashTable Sink Operator' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' Position of Big Table: 1' '' ' Stage: Stage-6' ' Map Reduce' ' Alias -> Map Operator Tree:' ' src2 ' ' TableScan' ' alias: src2' ' Filter Operator' ' predicate:' ' expr: ((key > 10) and (key < 10))' ' type: boolean' ' Map Join Operator' ' condition map:' ' Inner Join 0 to 1' ' Left Outer Join1 to 2' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9' ' Position of Big Table: 1' ' Select Operator' ' expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' expr: _col8' ' type: string' ' expr: _col9' ' type: string' ' outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5' ' File Output Operator' ' compressed: false' ' GlobalTableId: 0' ' table:' ' input format: org.apache.hadoop.mapred.SequenceFileInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat' ' Local Work:' ' Map Reduce Local Work' '' ' Stage: Stage-1' ' Map Reduce' ' Alias -> Map Operator Tree:' ' src1 ' ' TableScan' ' alias: src1' ' Filter Operator' ' predicate:' ' expr: ((key < 10) and (key > 10))' ' type: boolean' ' Reduce Output Operator' ' key expressions:' ' expr: key' ' type: string' ' sort order: +' ' Map-reduce partition columns:' ' expr: key' ' type: string' ' tag: 0' ' value expressions:' ' expr: key' ' type: string' ' expr: value' ' type: string' ' src2 ' ' TableScan' ' alias: src2' ' Filter Operator' ' predicate:' ' expr: ((key > 10) and (key < 10))' ' type: boolean' ' Reduce Output Operator' ' key expressions:' ' expr: key' ' type: string' ' sort order: +' ' Map-reduce partition columns:' ' expr: key' ' type: string' ' tag: 1' ' value expressions:' ' expr: key' ' type: string' ' expr: value' ' type: string' ' src3 ' ' TableScan' ' alias: src3' ' Filter Operator' ' predicate:' ' expr: ((key < 10) and (key > 10))' ' type: boolean' ' Reduce Output Operator' ' key expressions:' ' expr: key' ' type: string' ' sort order: +' ' Map-reduce partition columns:' ' expr: key' ' type: string' ' tag: 2' ' value expressions:' ' expr: key' ' type: string' ' expr: value' ' type: string' ' Reduce Operator Tree:' ' Join Operator' ' condition map:' ' Inner Join 0 to 1' ' Left Outer Join1 to 2' ' condition expressions:' ' 0 {VALUE._col0} {VALUE._col1}' ' 1 {VALUE._col0} {VALUE._col1}' ' 2 {VALUE._col0} {VALUE._col1}' ' handleSkewJoin: false' ' outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9' ' Select Operator' ' expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' expr: _col8' ' type: string' ' expr: _col9' ' type: string' ' outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5' ' File Output Operator' ' compressed: false' ' GlobalTableId: 0' ' table:' ' input format: org.apache.hadoop.mapred.SequenceFileInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat' '' ' Stage: Stage-0' ' Fetch Operator' ' limit: -1' '' '' 355 rows selected >>> >>> SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) LEFT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value; 'key','value','key','value','key','value' No rows selected >>> >>> explain SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) RIGHT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value; 'Explain' 'ABSTRACT SYNTAX TREE:' ' (TOK_QUERY (TOK_FROM (TOK_RIGHTOUTERJOIN (TOK_JOIN (TOK_TABREF (TOK_TABNAME src) src1) (TOK_TABREF (TOK_TABNAME src) src2) (AND (AND (= (. (TOK_TABLE_OR_COL src1) key) (. (TOK_TABLE_OR_COL src2) key)) (< (. (TOK_TABLE_OR_COL src1) key) 10)) (> (. (TOK_TABLE_OR_COL src2) key) 10))) (TOK_TABREF (TOK_TABNAME src) src3) (AND (= (. (TOK_TABLE_OR_COL src2) key) (. (TOK_TABLE_OR_COL src3) key)) (< (. (TOK_TABLE_OR_COL src3) key) 10)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_SORTBY (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src1) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src1) value)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src2) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src2) value)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src3) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src3) value)))))' '' 'STAGE DEPENDENCIES:' ' Stage-6 is a root stage , consists of Stage-7, Stage-1' ' Stage-7 has a backup stage: Stage-1' ' Stage-5 depends on stages: Stage-7' ' Stage-2 depends on stages: Stage-1, Stage-5' ' Stage-1' ' Stage-0 is a root stage' '' 'STAGE PLANS:' ' Stage: Stage-6' ' Conditional Operator' '' ' Stage: Stage-7' ' Map Reduce Local Work' ' Alias -> Map Local Tables:' ' src1 ' ' Fetch Operator' ' limit: -1' ' src2 ' ' Fetch Operator' ' limit: -1' ' Alias -> Map Local Operator Tree:' ' src1 ' ' TableScan' ' alias: src1' ' Filter Operator' ' predicate:' ' expr: ((key < 10) and (key > 10))' ' type: boolean' ' HashTable Sink Operator' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' filter predicates:' ' 0 ' ' 1 ' ' 2 {(key < 10)}' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' Position of Big Table: 2' ' src2 ' ' TableScan' ' alias: src2' ' Filter Operator' ' predicate:' ' expr: ((key > 10) and (key < 10))' ' type: boolean' ' HashTable Sink Operator' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' filter predicates:' ' 0 ' ' 1 ' ' 2 {(key < 10)}' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' Position of Big Table: 2' '' ' Stage: Stage-5' ' Map Reduce' ' Alias -> Map Operator Tree:' ' src3 ' ' TableScan' ' alias: src3' ' Map Join Operator' ' condition map:' ' Inner Join 0 to 1' ' Right Outer Join1 to 2' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' filter predicates:' ' 0 ' ' 1 ' ' 2 {(key < 10)}' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9' ' Position of Big Table: 2' ' Select Operator' ' expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' expr: _col8' ' type: string' ' expr: _col9' ' type: string' ' outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5' ' File Output Operator' ' compressed: false' ' GlobalTableId: 0' ' table:' ' input format: org.apache.hadoop.mapred.SequenceFileInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat' ' Local Work:' ' Map Reduce Local Work' '' ' Stage: Stage-2' ' Map Reduce' ' Alias -> Map Operator Tree:' ' file:!!{hive.exec.scratchdir}!! ' ' Reduce Output Operator' ' key expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col2' ' type: string' ' expr: _col3' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' sort order: ++++++' ' tag: -1' ' value expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col2' ' type: string' ' expr: _col3' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' Reduce Operator Tree:' ' Extract' ' 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-1' ' Map Reduce' ' Alias -> Map Operator Tree:' ' src1 ' ' TableScan' ' alias: src1' ' Filter Operator' ' predicate:' ' expr: ((key < 10) and (key > 10))' ' type: boolean' ' Reduce Output Operator' ' key expressions:' ' expr: key' ' type: string' ' sort order: +' ' Map-reduce partition columns:' ' expr: key' ' type: string' ' tag: 0' ' value expressions:' ' expr: key' ' type: string' ' expr: value' ' type: string' ' src2 ' ' TableScan' ' alias: src2' ' Filter Operator' ' predicate:' ' expr: ((key > 10) and (key < 10))' ' type: boolean' ' Reduce Output Operator' ' key expressions:' ' expr: key' ' type: string' ' sort order: +' ' Map-reduce partition columns:' ' expr: key' ' type: string' ' tag: 1' ' value expressions:' ' expr: key' ' type: string' ' expr: value' ' type: string' ' src3 ' ' TableScan' ' alias: src3' ' Reduce Output Operator' ' key expressions:' ' expr: key' ' type: string' ' sort order: +' ' Map-reduce partition columns:' ' expr: key' ' type: string' ' tag: 2' ' value expressions:' ' expr: key' ' type: string' ' expr: value' ' type: string' ' Reduce Operator Tree:' ' Join Operator' ' condition map:' ' Inner Join 0 to 1' ' Right Outer Join1 to 2' ' condition expressions:' ' 0 {VALUE._col0} {VALUE._col1}' ' 1 {VALUE._col0} {VALUE._col1}' ' 2 {VALUE._col0} {VALUE._col1}' ' filter predicates:' ' 0 ' ' 1 ' ' 2 {(VALUE._col0 < 10)}' ' handleSkewJoin: false' ' outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9' ' Select Operator' ' expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' expr: _col8' ' type: string' ' expr: _col9' ' type: string' ' outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5' ' File Output Operator' ' compressed: false' ' GlobalTableId: 0' ' table:' ' input format: org.apache.hadoop.mapred.SequenceFileInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat' '' ' Stage: Stage-0' ' Fetch Operator' ' limit: -1' '' '' 265 rows selected >>> >>> SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) RIGHT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value; 'key','value','key','value','key','value' '','','','','0','val_0' '','','','','0','val_0' '','','','','0','val_0' '','','','','10','val_10' '','','','','100','val_100' '','','','','100','val_100' '','','','','103','val_103' '','','','','103','val_103' '','','','','104','val_104' '','','','','104','val_104' '','','','','105','val_105' '','','','','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' '','','','','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' '','','','','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' '','','','','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' '','','','','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' '','','','','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' '','','','','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' '','','','','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' '','','','','260','val_260' '','','','','262','val_262' '','','','','263','val_263' '','','','','265','val_265' '','','','','265','val_265' '','','','','266','val_266' '','','','','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' '','','','','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' '','','','','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' '','','','','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' '','','','','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' '','','','','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' '','','','','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' '','','','','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' '','','','','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' '','','','','421','val_421' '','','','','424','val_424' '','','','','424','val_424' '','','','','427','val_427' '','','','','429','val_429' '','','','','429','val_429' '','','','','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' '','','','','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' '','','','','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' '','','','','51','val_51' '','','','','51','val_51' '','','','','53','val_53' '','','','','54','val_54' '','','','','57','val_57' '','','','','58','val_58' '','','','','58','val_58' '','','','','64','val_64' '','','','','65','val_65' '','','','','66','val_66' '','','','','67','val_67' '','','','','67','val_67' '','','','','69','val_69' '','','','','70','val_70' '','','','','70','val_70' '','','','','70','val_70' '','','','','72','val_72' '','','','','72','val_72' '','','','','74','val_74' '','','','','76','val_76' '','','','','76','val_76' '','','','','77','val_77' '','','','','78','val_78' '','','','','8','val_8' '','','','','80','val_80' '','','','','82','val_82' '','','','','83','val_83' '','','','','83','val_83' '','','','','84','val_84' '','','','','84','val_84' '','','','','85','val_85' '','','','','86','val_86' '','','','','87','val_87' '','','','','9','val_9' '','','','','90','val_90' '','','','','90','val_90' '','','','','90','val_90' '','','','','92','val_92' '','','','','95','val_95' '','','','','95','val_95' '','','','','96','val_96' '','','','','97','val_97' '','','','','97','val_97' '','','','','98','val_98' '','','','','98','val_98' 500 rows selected >>> >>> explain SELECT * FROM src src1 LEFT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value; 'Explain' 'ABSTRACT SYNTAX TREE:' ' (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_LEFTOUTERJOIN (TOK_TABREF (TOK_TABNAME src) src1) (TOK_TABREF (TOK_TABNAME src) src2) (AND (AND (= (. (TOK_TABLE_OR_COL src1) key) (. (TOK_TABLE_OR_COL src2) key)) (< (. (TOK_TABLE_OR_COL src1) key) 10)) (> (. (TOK_TABLE_OR_COL src2) key) 10))) (TOK_TABREF (TOK_TABNAME src) src3) (AND (= (. (TOK_TABLE_OR_COL src2) key) (. (TOK_TABLE_OR_COL src3) key)) (< (. (TOK_TABLE_OR_COL src3) key) 10)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_SORTBY (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src1) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src1) value)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src2) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src2) value)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src3) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src3) value)))))' '' 'STAGE DEPENDENCIES:' ' Stage-6 is a root stage , consists of Stage-7, Stage-1' ' Stage-7 has a backup stage: Stage-1' ' Stage-5 depends on stages: Stage-7' ' Stage-2 depends on stages: Stage-1, Stage-5' ' Stage-1' ' Stage-0 is a root stage' '' 'STAGE PLANS:' ' Stage: Stage-6' ' Conditional Operator' '' ' Stage: Stage-7' ' Map Reduce Local Work' ' Alias -> Map Local Tables:' ' src2 ' ' Fetch Operator' ' limit: -1' ' src3 ' ' Fetch Operator' ' limit: -1' ' Alias -> Map Local Operator Tree:' ' src2 ' ' TableScan' ' alias: src2' ' Filter Operator' ' predicate:' ' expr: ((key > 10) and (key < 10))' ' type: boolean' ' HashTable Sink Operator' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' filter predicates:' ' 0 {(key < 10)}' ' 1 ' ' 2 ' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' Position of Big Table: 0' ' src3 ' ' TableScan' ' alias: src3' ' Filter Operator' ' predicate:' ' expr: ((key < 10) and (key > 10))' ' type: boolean' ' HashTable Sink Operator' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' filter predicates:' ' 0 {(key < 10)}' ' 1 ' ' 2 ' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' Position of Big Table: 0' '' ' Stage: Stage-5' ' Map Reduce' ' Alias -> Map Operator Tree:' ' src1 ' ' TableScan' ' alias: src1' ' Map Join Operator' ' condition map:' ' Left Outer Join0 to 1' ' Inner Join 1 to 2' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' filter predicates:' ' 0 {(key < 10)}' ' 1 ' ' 2 ' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9' ' Position of Big Table: 0' ' Select Operator' ' expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' expr: _col8' ' type: string' ' expr: _col9' ' type: string' ' outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5' ' File Output Operator' ' compressed: false' ' GlobalTableId: 0' ' table:' ' input format: org.apache.hadoop.mapred.SequenceFileInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat' ' Local Work:' ' Map Reduce Local Work' '' ' Stage: Stage-2' ' Map Reduce' ' Alias -> Map Operator Tree:' ' file:!!{hive.exec.scratchdir}!! ' ' Reduce Output Operator' ' key expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col2' ' type: string' ' expr: _col3' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' sort order: ++++++' ' tag: -1' ' value expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col2' ' type: string' ' expr: _col3' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' Reduce Operator Tree:' ' Extract' ' 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-1' ' Map Reduce' ' Alias -> Map Operator Tree:' ' src1 ' ' TableScan' ' alias: src1' ' Reduce Output Operator' ' key expressions:' ' expr: key' ' type: string' ' sort order: +' ' Map-reduce partition columns:' ' expr: key' ' type: string' ' tag: 0' ' value expressions:' ' expr: key' ' type: string' ' expr: value' ' type: string' ' src2 ' ' TableScan' ' alias: src2' ' Filter Operator' ' predicate:' ' expr: ((key > 10) and (key < 10))' ' type: boolean' ' Reduce Output Operator' ' key expressions:' ' expr: key' ' type: string' ' sort order: +' ' Map-reduce partition columns:' ' expr: key' ' type: string' ' tag: 1' ' value expressions:' ' expr: key' ' type: string' ' expr: value' ' type: string' ' src3 ' ' TableScan' ' alias: src3' ' Filter Operator' ' predicate:' ' expr: ((key < 10) and (key > 10))' ' type: boolean' ' Reduce Output Operator' ' key expressions:' ' expr: key' ' type: string' ' sort order: +' ' Map-reduce partition columns:' ' expr: key' ' type: string' ' tag: 2' ' value expressions:' ' expr: key' ' type: string' ' expr: value' ' type: string' ' Reduce Operator Tree:' ' Join Operator' ' condition map:' ' Left Outer Join0 to 1' ' Inner Join 1 to 2' ' condition expressions:' ' 0 {VALUE._col0} {VALUE._col1}' ' 1 {VALUE._col0} {VALUE._col1}' ' 2 {VALUE._col0} {VALUE._col1}' ' filter predicates:' ' 0 {(VALUE._col0 < 10)}' ' 1 ' ' 2 ' ' handleSkewJoin: false' ' outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9' ' Select Operator' ' expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' expr: _col8' ' type: string' ' expr: _col9' ' type: string' ' outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5' ' File Output Operator' ' compressed: false' ' GlobalTableId: 0' ' table:' ' input format: org.apache.hadoop.mapred.SequenceFileInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat' '' ' Stage: Stage-0' ' Fetch Operator' ' limit: -1' '' '' 265 rows selected >>> >>> SELECT * FROM src src1 LEFT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value; 'key','value','key','value','key','value' No rows selected >>> >>> explain SELECT * FROM src src1 RIGHT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value; 'Explain' 'ABSTRACT SYNTAX TREE:' ' (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_RIGHTOUTERJOIN (TOK_TABREF (TOK_TABNAME src) src1) (TOK_TABREF (TOK_TABNAME src) src2) (AND (AND (= (. (TOK_TABLE_OR_COL src1) key) (. (TOK_TABLE_OR_COL src2) key)) (< (. (TOK_TABLE_OR_COL src1) key) 10)) (> (. (TOK_TABLE_OR_COL src2) key) 10))) (TOK_TABREF (TOK_TABNAME src) src3) (AND (= (. (TOK_TABLE_OR_COL src2) key) (. (TOK_TABLE_OR_COL src3) key)) (< (. (TOK_TABLE_OR_COL src3) key) 10)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_SORTBY (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src1) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src1) value)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src2) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src2) value)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src3) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src3) value)))))' '' 'STAGE DEPENDENCIES:' ' Stage-7 is a root stage , consists of Stage-8, Stage-9, Stage-1' ' Stage-8 has a backup stage: Stage-1' ' Stage-5 depends on stages: Stage-8' ' Stage-2 depends on stages: Stage-1, Stage-5, Stage-6' ' Stage-9 has a backup stage: Stage-1' ' Stage-6 depends on stages: Stage-9' ' Stage-1' ' Stage-0 is a root stage' '' 'STAGE PLANS:' ' Stage: Stage-7' ' Conditional Operator' '' ' Stage: Stage-8' ' Map Reduce Local Work' ' Alias -> Map Local Tables:' ' src1 ' ' Fetch Operator' ' limit: -1' ' src3 ' ' Fetch Operator' ' limit: -1' ' Alias -> Map Local Operator Tree:' ' src1 ' ' TableScan' ' alias: src1' ' Filter Operator' ' predicate:' ' expr: (key < 10)' ' type: boolean' ' HashTable Sink Operator' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' filter predicates:' ' 0 ' ' 1 {(key > 10)}' ' 2 ' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' Position of Big Table: 1' ' src3 ' ' TableScan' ' alias: src3' ' Filter Operator' ' predicate:' ' expr: (key < 10)' ' type: boolean' ' HashTable Sink Operator' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' filter predicates:' ' 0 ' ' 1 {(key > 10)}' ' 2 ' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' Position of Big Table: 1' '' ' Stage: Stage-5' ' Map Reduce' ' Alias -> Map Operator Tree:' ' src2 ' ' TableScan' ' alias: src2' ' Filter Operator' ' predicate:' ' expr: (key < 10)' ' type: boolean' ' Map Join Operator' ' condition map:' ' Right Outer Join0 to 1' ' Inner Join 1 to 2' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' filter predicates:' ' 0 ' ' 1 {(key > 10)}' ' 2 ' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9' ' Position of Big Table: 1' ' Select Operator' ' expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' expr: _col8' ' type: string' ' expr: _col9' ' type: string' ' outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5' ' File Output Operator' ' compressed: false' ' GlobalTableId: 0' ' table:' ' input format: org.apache.hadoop.mapred.SequenceFileInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat' ' Local Work:' ' Map Reduce Local Work' '' ' Stage: Stage-2' ' Map Reduce' ' Alias -> Map Operator Tree:' ' file:!!{hive.exec.scratchdir}!! ' ' Reduce Output Operator' ' key expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col2' ' type: string' ' expr: _col3' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' sort order: ++++++' ' tag: -1' ' value expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col2' ' type: string' ' expr: _col3' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' Reduce Operator Tree:' ' Extract' ' 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-9' ' Map Reduce Local Work' ' Alias -> Map Local Tables:' ' src1 ' ' Fetch Operator' ' limit: -1' ' src2 ' ' Fetch Operator' ' limit: -1' ' Alias -> Map Local Operator Tree:' ' src1 ' ' TableScan' ' alias: src1' ' Filter Operator' ' predicate:' ' expr: (key < 10)' ' type: boolean' ' HashTable Sink Operator' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' filter predicates:' ' 0 ' ' 1 {(key > 10)}' ' 2 ' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' Position of Big Table: 2' ' src2 ' ' TableScan' ' alias: src2' ' Filter Operator' ' predicate:' ' expr: (key < 10)' ' type: boolean' ' HashTable Sink Operator' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' filter predicates:' ' 0 ' ' 1 {(key > 10)}' ' 2 ' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' Position of Big Table: 2' '' ' Stage: Stage-6' ' Map Reduce' ' Alias -> Map Operator Tree:' ' src3 ' ' TableScan' ' alias: src3' ' Filter Operator' ' predicate:' ' expr: (key < 10)' ' type: boolean' ' Map Join Operator' ' condition map:' ' Right Outer Join0 to 1' ' Inner Join 1 to 2' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' filter predicates:' ' 0 ' ' 1 {(key > 10)}' ' 2 ' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9' ' Position of Big Table: 2' ' Select Operator' ' expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' expr: _col8' ' type: string' ' expr: _col9' ' type: string' ' outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5' ' File Output Operator' ' compressed: false' ' GlobalTableId: 0' ' table:' ' input format: org.apache.hadoop.mapred.SequenceFileInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat' ' Local Work:' ' Map Reduce Local Work' '' ' Stage: Stage-1' ' Map Reduce' ' Alias -> Map Operator Tree:' ' src1 ' ' TableScan' ' alias: src1' ' Filter Operator' ' predicate:' ' expr: (key < 10)' ' type: boolean' ' Reduce Output Operator' ' key expressions:' ' expr: key' ' type: string' ' sort order: +' ' Map-reduce partition columns:' ' expr: key' ' type: string' ' tag: 0' ' value expressions:' ' expr: key' ' type: string' ' expr: value' ' type: string' ' src2 ' ' TableScan' ' alias: src2' ' Filter Operator' ' predicate:' ' expr: (key < 10)' ' type: boolean' ' Reduce Output Operator' ' key expressions:' ' expr: key' ' type: string' ' sort order: +' ' Map-reduce partition columns:' ' expr: key' ' type: string' ' tag: 1' ' value expressions:' ' expr: key' ' type: string' ' expr: value' ' type: string' ' src3 ' ' TableScan' ' alias: src3' ' Filter Operator' ' predicate:' ' expr: (key < 10)' ' type: boolean' ' Reduce Output Operator' ' key expressions:' ' expr: key' ' type: string' ' sort order: +' ' Map-reduce partition columns:' ' expr: key' ' type: string' ' tag: 2' ' value expressions:' ' expr: key' ' type: string' ' expr: value' ' type: string' ' Reduce Operator Tree:' ' Join Operator' ' condition map:' ' Right Outer Join0 to 1' ' Inner Join 1 to 2' ' condition expressions:' ' 0 {VALUE._col0} {VALUE._col1}' ' 1 {VALUE._col0} {VALUE._col1}' ' 2 {VALUE._col0} {VALUE._col1}' ' filter predicates:' ' 0 ' ' 1 {(VALUE._col0 > 10)}' ' 2 ' ' handleSkewJoin: false' ' outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9' ' Select Operator' ' expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' expr: _col8' ' type: string' ' expr: _col9' ' type: string' ' outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5' ' File Output Operator' ' compressed: false' ' GlobalTableId: 0' ' table:' ' input format: org.apache.hadoop.mapred.SequenceFileInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat' '' ' Stage: Stage-0' ' Fetch Operator' ' limit: -1' '' '' 383 rows selected >>> >>> SELECT * FROM src src1 RIGHT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value; 'key','value','key','value','key','value' '','','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' '','','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' '','','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' '','','2','val_2','2','val_2' '','','4','val_4','4','val_4' '','','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' '','','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' '','','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' '','','8','val_8','8','val_8' '','','9','val_9','9','val_9' 58 rows selected >>> >>> explain SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value; 'Explain' 'ABSTRACT SYNTAX TREE:' ' (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_JOIN (TOK_TABREF (TOK_TABNAME src) src1) (TOK_TABREF (TOK_TABNAME src) src2) (AND (AND (= (. (TOK_TABLE_OR_COL src1) key) (. (TOK_TABLE_OR_COL src2) key)) (< (. (TOK_TABLE_OR_COL src1) key) 10)) (> (. (TOK_TABLE_OR_COL src2) key) 10))) (TOK_TABREF (TOK_TABNAME src) src3) (AND (= (. (TOK_TABLE_OR_COL src2) key) (. (TOK_TABLE_OR_COL src3) key)) (< (. (TOK_TABLE_OR_COL src3) key) 10)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_SORTBY (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src1) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src1) value)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src2) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src2) value)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src3) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src3) value)))))' '' 'STAGE DEPENDENCIES:' ' Stage-8 is a root stage , consists of Stage-9, Stage-10, Stage-11, Stage-1' ' Stage-9 has a backup stage: Stage-1' ' Stage-5 depends on stages: Stage-9' ' Stage-2 depends on stages: Stage-1, Stage-5, Stage-6, Stage-7' ' Stage-10 has a backup stage: Stage-1' ' Stage-6 depends on stages: Stage-10' ' Stage-11 has a backup stage: Stage-1' ' Stage-7 depends on stages: Stage-11' ' Stage-1' ' Stage-0 is a root stage' '' 'STAGE PLANS:' ' Stage: Stage-8' ' Conditional Operator' '' ' Stage: Stage-9' ' Map Reduce Local Work' ' Alias -> Map Local Tables:' ' src2 ' ' Fetch Operator' ' limit: -1' ' src3 ' ' Fetch Operator' ' limit: -1' ' Alias -> Map Local Operator Tree:' ' src2 ' ' TableScan' ' alias: src2' ' Filter Operator' ' predicate:' ' expr: ((key > 10) and (key < 10))' ' type: boolean' ' HashTable Sink Operator' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' Position of Big Table: 0' ' src3 ' ' TableScan' ' alias: src3' ' Filter Operator' ' predicate:' ' expr: ((key < 10) and (key > 10))' ' type: boolean' ' HashTable Sink Operator' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' Position of Big Table: 0' '' ' Stage: Stage-5' ' Map Reduce' ' Alias -> Map Operator Tree:' ' src1 ' ' TableScan' ' alias: src1' ' Filter Operator' ' predicate:' ' expr: ((key < 10) and (key > 10))' ' type: boolean' ' Map Join Operator' ' condition map:' ' Inner Join 0 to 1' ' Inner Join 1 to 2' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9' ' Position of Big Table: 0' ' Select Operator' ' expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' expr: _col8' ' type: string' ' expr: _col9' ' type: string' ' outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5' ' File Output Operator' ' compressed: false' ' GlobalTableId: 0' ' table:' ' input format: org.apache.hadoop.mapred.SequenceFileInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat' ' Local Work:' ' Map Reduce Local Work' '' ' Stage: Stage-2' ' Map Reduce' ' Alias -> Map Operator Tree:' ' file:!!{hive.exec.scratchdir}!! ' ' Reduce Output Operator' ' key expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col2' ' type: string' ' expr: _col3' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' sort order: ++++++' ' tag: -1' ' value expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col2' ' type: string' ' expr: _col3' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' Reduce Operator Tree:' ' Extract' ' 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-10' ' Map Reduce Local Work' ' Alias -> Map Local Tables:' ' src1 ' ' Fetch Operator' ' limit: -1' ' src3 ' ' Fetch Operator' ' limit: -1' ' Alias -> Map Local Operator Tree:' ' src1 ' ' TableScan' ' alias: src1' ' Filter Operator' ' predicate:' ' expr: ((key < 10) and (key > 10))' ' type: boolean' ' HashTable Sink Operator' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' Position of Big Table: 1' ' src3 ' ' TableScan' ' alias: src3' ' Filter Operator' ' predicate:' ' expr: ((key < 10) and (key > 10))' ' type: boolean' ' HashTable Sink Operator' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' Position of Big Table: 1' '' ' Stage: Stage-6' ' Map Reduce' ' Alias -> Map Operator Tree:' ' src2 ' ' TableScan' ' alias: src2' ' Filter Operator' ' predicate:' ' expr: ((key > 10) and (key < 10))' ' type: boolean' ' Map Join Operator' ' condition map:' ' Inner Join 0 to 1' ' Inner Join 1 to 2' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9' ' Position of Big Table: 1' ' Select Operator' ' expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' expr: _col8' ' type: string' ' expr: _col9' ' type: string' ' outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5' ' File Output Operator' ' compressed: false' ' GlobalTableId: 0' ' table:' ' input format: org.apache.hadoop.mapred.SequenceFileInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat' ' Local Work:' ' Map Reduce Local Work' '' ' Stage: Stage-11' ' Map Reduce Local Work' ' Alias -> Map Local Tables:' ' src1 ' ' Fetch Operator' ' limit: -1' ' src2 ' ' Fetch Operator' ' limit: -1' ' Alias -> Map Local Operator Tree:' ' src1 ' ' TableScan' ' alias: src1' ' Filter Operator' ' predicate:' ' expr: ((key < 10) and (key > 10))' ' type: boolean' ' HashTable Sink Operator' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' Position of Big Table: 2' ' src2 ' ' TableScan' ' alias: src2' ' Filter Operator' ' predicate:' ' expr: ((key > 10) and (key < 10))' ' type: boolean' ' HashTable Sink Operator' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' Position of Big Table: 2' '' ' Stage: Stage-7' ' Map Reduce' ' Alias -> Map Operator Tree:' ' src3 ' ' TableScan' ' alias: src3' ' Filter Operator' ' predicate:' ' expr: ((key < 10) and (key > 10))' ' type: boolean' ' Map Join Operator' ' condition map:' ' Inner Join 0 to 1' ' Inner Join 1 to 2' ' condition expressions:' ' 0 {key} {value}' ' 1 {key} {value}' ' 2 {key} {value}' ' handleSkewJoin: false' ' keys:' ' 0 [Column[key]]' ' 1 [Column[key]]' ' 2 [Column[key]]' ' outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9' ' Position of Big Table: 2' ' Select Operator' ' expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' expr: _col8' ' type: string' ' expr: _col9' ' type: string' ' outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5' ' File Output Operator' ' compressed: false' ' GlobalTableId: 0' ' table:' ' input format: org.apache.hadoop.mapred.SequenceFileInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat' ' Local Work:' ' Map Reduce Local Work' '' ' Stage: Stage-1' ' Map Reduce' ' Alias -> Map Operator Tree:' ' src1 ' ' TableScan' ' alias: src1' ' Filter Operator' ' predicate:' ' expr: ((key < 10) and (key > 10))' ' type: boolean' ' Reduce Output Operator' ' key expressions:' ' expr: key' ' type: string' ' sort order: +' ' Map-reduce partition columns:' ' expr: key' ' type: string' ' tag: 0' ' value expressions:' ' expr: key' ' type: string' ' expr: value' ' type: string' ' src2 ' ' TableScan' ' alias: src2' ' Filter Operator' ' predicate:' ' expr: ((key > 10) and (key < 10))' ' type: boolean' ' Reduce Output Operator' ' key expressions:' ' expr: key' ' type: string' ' sort order: +' ' Map-reduce partition columns:' ' expr: key' ' type: string' ' tag: 1' ' value expressions:' ' expr: key' ' type: string' ' expr: value' ' type: string' ' src3 ' ' TableScan' ' alias: src3' ' Filter Operator' ' predicate:' ' expr: ((key < 10) and (key > 10))' ' type: boolean' ' Reduce Output Operator' ' key expressions:' ' expr: key' ' type: string' ' sort order: +' ' Map-reduce partition columns:' ' expr: key' ' type: string' ' tag: 2' ' value expressions:' ' expr: key' ' type: string' ' expr: value' ' type: string' ' Reduce Operator Tree:' ' Join Operator' ' condition map:' ' Inner Join 0 to 1' ' Inner Join 1 to 2' ' condition expressions:' ' 0 {VALUE._col0} {VALUE._col1}' ' 1 {VALUE._col0} {VALUE._col1}' ' 2 {VALUE._col0} {VALUE._col1}' ' handleSkewJoin: false' ' outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9' ' Select Operator' ' expressions:' ' expr: _col0' ' type: string' ' expr: _col1' ' type: string' ' expr: _col4' ' type: string' ' expr: _col5' ' type: string' ' expr: _col8' ' type: string' ' expr: _col9' ' type: string' ' outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5' ' File Output Operator' ' compressed: false' ' GlobalTableId: 0' ' table:' ' input format: org.apache.hadoop.mapred.SequenceFileInputFormat' ' output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat' '' ' Stage: Stage-0' ' Fetch Operator' ' limit: -1' '' '' 453 rows selected >>> >>> SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value; 'key','value','key','value','key','value' No rows selected >>> !record