PREHOOK: query: -- UDTF forwards nothing, OUTER LV add null for that explain select * from src LATERAL VIEW OUTER explode(array()) C AS a limit 10 PREHOOK: type: QUERY POSTHOOK: query: -- UDTF forwards nothing, OUTER LV add null for that explain select * from src LATERAL VIEW OUTER explode(array()) C AS a limit 10 POSTHOOK: type: QUERY ABSTRACT SYNTAX TREE: (TOK_QUERY (TOK_FROM (TOK_LATERAL_VIEW_OUTER (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION explode (TOK_FUNCTION array)) a (TOK_TABALIAS C))) (TOK_TABREF (TOK_TABNAME src)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_LIMIT 10))) STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 is a root stage STAGE PLANS: Stage: Stage-1 Map Reduce Alias -> Map Operator Tree: src TableScan alias: src Lateral View Forward Select Operator expressions: expr: key type: string expr: value type: string outputColumnNames: key, value Lateral View Join Operator outputColumnNames: _col0, _col1, _col4 Select Operator expressions: expr: _col0 type: string expr: _col1 type: string expr: _col4 type: string outputColumnNames: _col0, _col1, _col2 Limit File Output Operator compressed: false GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Select Operator expressions: expr: array() type: array outputColumnNames: _col0 UDTF Operator function name: explode outer lateral view: true Lateral View Join Operator outputColumnNames: _col0, _col1, _col4 Select Operator expressions: expr: _col0 type: string expr: _col1 type: string expr: _col4 type: string outputColumnNames: _col0, _col1, _col2 Limit File Output Operator compressed: false GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Stage: Stage-0 Fetch Operator limit: 10 PREHOOK: query: select * from src LATERAL VIEW OUTER explode(array()) C AS a limit 10 PREHOOK: type: QUERY PREHOOK: Input: default@src #### A masked pattern was here #### POSTHOOK: query: select * from src LATERAL VIEW OUTER explode(array()) C AS a limit 10 POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### 238 val_238 NULL 86 val_86 NULL 311 val_311 NULL 27 val_27 NULL 165 val_165 NULL 409 val_409 NULL 255 val_255 NULL 278 val_278 NULL 98 val_98 NULL 484 val_484 NULL PREHOOK: query: -- backward compatible (UDTF forwards something for OUTER LV) explain select * from src LATERAL VIEW OUTER explode(array(4,5)) C AS a limit 10 PREHOOK: type: QUERY POSTHOOK: query: -- backward compatible (UDTF forwards something for OUTER LV) explain select * from src LATERAL VIEW OUTER explode(array(4,5)) C AS a limit 10 POSTHOOK: type: QUERY ABSTRACT SYNTAX TREE: (TOK_QUERY (TOK_FROM (TOK_LATERAL_VIEW_OUTER (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION explode (TOK_FUNCTION array 4 5)) a (TOK_TABALIAS C))) (TOK_TABREF (TOK_TABNAME src)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_LIMIT 10))) STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 is a root stage STAGE PLANS: Stage: Stage-1 Map Reduce Alias -> Map Operator Tree: src TableScan alias: src Lateral View Forward Select Operator expressions: expr: key type: string expr: value type: string outputColumnNames: key, value Lateral View Join Operator outputColumnNames: _col0, _col1, _col4 Select Operator expressions: expr: _col0 type: string expr: _col1 type: string expr: _col4 type: int outputColumnNames: _col0, _col1, _col2 Limit File Output Operator compressed: false GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Select Operator expressions: expr: array(4,5) type: array outputColumnNames: _col0 UDTF Operator function name: explode outer lateral view: true Lateral View Join Operator outputColumnNames: _col0, _col1, _col4 Select Operator expressions: expr: _col0 type: string expr: _col1 type: string expr: _col4 type: int outputColumnNames: _col0, _col1, _col2 Limit File Output Operator compressed: false GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Stage: Stage-0 Fetch Operator limit: 10 PREHOOK: query: select * from src LATERAL VIEW OUTER explode(array(4,5)) C AS a limit 10 PREHOOK: type: QUERY PREHOOK: Input: default@src #### A masked pattern was here #### POSTHOOK: query: select * from src LATERAL VIEW OUTER explode(array(4,5)) C AS a limit 10 POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### 238 val_238 4 238 val_238 5 86 val_86 4 86 val_86 5 311 val_311 4 311 val_311 5 27 val_27 4 27 val_27 5 165 val_165 4 165 val_165 5 PREHOOK: query: create table array_valued as select key, if (key > 300, array(value, value), null) as value from src PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src POSTHOOK: query: create table array_valued as select key, if (key > 300, array(value, value), null) as value from src POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src POSTHOOK: Output: default@array_valued PREHOOK: query: explain select * from array_valued LATERAL VIEW OUTER explode(value) C AS a limit 10 PREHOOK: type: QUERY POSTHOOK: query: explain select * from array_valued LATERAL VIEW OUTER explode(value) C AS a limit 10 POSTHOOK: type: QUERY ABSTRACT SYNTAX TREE: (TOK_QUERY (TOK_FROM (TOK_LATERAL_VIEW_OUTER (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION explode (TOK_TABLE_OR_COL value)) a (TOK_TABALIAS C))) (TOK_TABREF (TOK_TABNAME array_valued)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_LIMIT 10))) STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 is a root stage STAGE PLANS: Stage: Stage-1 Map Reduce Alias -> Map Operator Tree: array_valued TableScan alias: array_valued Lateral View Forward Select Operator expressions: expr: key type: string expr: value type: array outputColumnNames: key, value Lateral View Join Operator outputColumnNames: _col0, _col1, _col4 Select Operator expressions: expr: _col0 type: string expr: _col1 type: array expr: _col4 type: string outputColumnNames: _col0, _col1, _col2 Limit File Output Operator compressed: false GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Select Operator expressions: expr: value type: array outputColumnNames: _col0 UDTF Operator function name: explode outer lateral view: true Lateral View Join Operator outputColumnNames: _col0, _col1, _col4 Select Operator expressions: expr: _col0 type: string expr: _col1 type: array expr: _col4 type: string outputColumnNames: _col0, _col1, _col2 Limit File Output Operator compressed: false GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Stage: Stage-0 Fetch Operator limit: 10 PREHOOK: query: select * from array_valued LATERAL VIEW OUTER explode(value) C AS a limit 10 PREHOOK: type: QUERY PREHOOK: Input: default@array_valued #### A masked pattern was here #### POSTHOOK: query: select * from array_valued LATERAL VIEW OUTER explode(value) C AS a limit 10 POSTHOOK: type: QUERY POSTHOOK: Input: default@array_valued #### A masked pattern was here #### 238 NULL NULL 86 NULL NULL 311 ["val_311","val_311"] val_311 311 ["val_311","val_311"] val_311 27 NULL NULL 165 NULL NULL 409 ["val_409","val_409"] val_409 409 ["val_409","val_409"] val_409 255 NULL NULL 278 NULL NULL