| PREHOOK: query: DESCRIBE FUNCTION stack |
| PREHOOK: type: DESCFUNCTION |
| POSTHOOK: query: DESCRIBE FUNCTION stack |
| POSTHOOK: type: DESCFUNCTION |
| stack(n, cols...) - turns k columns into n rows of size k/n each |
| PREHOOK: query: EXPLAIN SELECT x, y FROM src LATERAL VIEW STACK(2, 'x', array(1), 'z') a AS x, y LIMIT 2 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN SELECT x, y FROM src LATERAL VIEW STACK(2, 'x', array(1), 'z') a AS x, y LIMIT 2 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: 2 |
| Processor Tree: |
| TableScan |
| alias: src |
| Lateral View Forward |
| Select Operator |
| Lateral View Join Operator |
| outputColumnNames: _col5, _col6 |
| Limit |
| Number of rows: 2 |
| Select Operator |
| expressions: _col5 (type: string), _col6 (type: array<int>) |
| outputColumnNames: _col0, _col1 |
| ListSink |
| Select Operator |
| expressions: 2 (type: int), 'x' (type: string), array(1) (type: array<int>), 'z' (type: string) |
| outputColumnNames: _col0, _col1, _col2, _col3 |
| UDTF Operator |
| function name: stack |
| Lateral View Join Operator |
| outputColumnNames: _col5, _col6 |
| Limit |
| Number of rows: 2 |
| Select Operator |
| expressions: _col5 (type: string), _col6 (type: array<int>) |
| outputColumnNames: _col0, _col1 |
| ListSink |
| |
| PREHOOK: query: EXPLAIN SELECT x, y FROM src LATERAL VIEW STACK(2, 'x', array(1), 'z', array(4)) a AS x, y LIMIT 2 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN SELECT x, y FROM src LATERAL VIEW STACK(2, 'x', array(1), 'z', array(4)) a AS x, y LIMIT 2 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: 2 |
| Processor Tree: |
| TableScan |
| alias: src |
| Lateral View Forward |
| Select Operator |
| Lateral View Join Operator |
| outputColumnNames: _col5, _col6 |
| Limit |
| Number of rows: 2 |
| Select Operator |
| expressions: _col5 (type: string), _col6 (type: array<int>) |
| outputColumnNames: _col0, _col1 |
| ListSink |
| Select Operator |
| expressions: 2 (type: int), 'x' (type: string), array(1) (type: array<int>), 'z' (type: string), array(4) (type: array<int>) |
| outputColumnNames: _col0, _col1, _col2, _col3, _col4 |
| UDTF Operator |
| function name: stack |
| Lateral View Join Operator |
| outputColumnNames: _col5, _col6 |
| Limit |
| Number of rows: 2 |
| Select Operator |
| expressions: _col5 (type: string), _col6 (type: array<int>) |
| outputColumnNames: _col0, _col1 |
| ListSink |
| |
| PREHOOK: query: SELECT x, y FROM src LATERAL VIEW STACK(2, 'x', array(1), 'z') a AS x, y LIMIT 2 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT x, y FROM src LATERAL VIEW STACK(2, 'x', array(1), 'z') a AS x, y LIMIT 2 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| #### A masked pattern was here #### |
| x [1] |
| z NULL |
| PREHOOK: query: SELECT x, y FROM src LATERAL VIEW STACK(2, 'x', array(1), 'z', array(4)) a AS x, y LIMIT 2 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT x, y FROM src LATERAL VIEW STACK(2, 'x', array(1), 'z', array(4)) a AS x, y LIMIT 2 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| #### A masked pattern was here #### |
| x [1] |
| z [4] |
| PREHOOK: query: EXPLAIN |
| SELECT stack(1, "en", "dbpedia", NULL ) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN |
| SELECT stack(1, "en", "dbpedia", NULL ) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| TableScan |
| alias: _dummy_table |
| Row Limit Per Split: 1 |
| Select Operator |
| expressions: 1 (type: int), 'en' (type: string), 'dbpedia' (type: string), null (type: void) |
| outputColumnNames: _col0, _col1, _col2, _col3 |
| UDTF Operator |
| function name: stack |
| Select Operator |
| expressions: col0 (type: string), col1 (type: string), null (type: void) |
| outputColumnNames: _col0, _col1, _col2 |
| ListSink |
| |
| PREHOOK: query: SELECT stack(1, "en", "dbpedia", NULL ) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT stack(1, "en", "dbpedia", NULL ) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| #### A masked pattern was here #### |
| en dbpedia NULL |