| PREHOOK: query: CREATE TABLE t1_n135(x5 STRUCT<x4: STRUCT<x3: ARRAY<STRUCT<x1: STRING, x2: ARRAY<STRING>>>> >) |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@t1_n135 |
| POSTHOOK: query: CREATE TABLE t1_n135(x5 STRUCT<x4: STRUCT<x3: ARRAY<STRUCT<x1: STRING, x2: ARRAY<STRING>>>> >) |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@t1_n135 |
| PREHOOK: query: INSERT INTO t1_n135 SELECT NAMED_STRUCT('x4', NAMED_STRUCT('x3', ARRAY(NAMED_STRUCT('x1', 'x1_1', 'x2', ARRAY('x2_1', 'x2_2'))))) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| PREHOOK: Output: default@t1_n135 |
| POSTHOOK: query: INSERT INTO t1_n135 SELECT NAMED_STRUCT('x4', NAMED_STRUCT('x3', ARRAY(NAMED_STRUCT('x1', 'x1_1', 'x2', ARRAY('x2_1', 'x2_2'))))) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| POSTHOOK: Output: default@t1_n135 |
| POSTHOOK: Lineage: t1_n135.x5 EXPRESSION [] |
| PREHOOK: query: SELECT c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16 |
| FROM t1_n135 |
| LATERAL VIEW EXPLODE(x5.x4.x3) lv as c1 |
| LATERAL VIEW EXPLODE(c1.x2) lv as c2 |
| LATERAL VIEW EXPLODE(x5.x4.x3) lv as c3 |
| LATERAL VIEW EXPLODE(c1.x2) lv as c4 |
| LATERAL VIEW EXPLODE(x5.x4.x3) lv as c5 |
| LATERAL VIEW EXPLODE(c1.x2) lv as c6 |
| LATERAL VIEW EXPLODE(x5.x4.x3) lv as c7 |
| LATERAL VIEW EXPLODE(c1.x2) lv as c8 |
| LATERAL VIEW EXPLODE(x5.x4.x3) lv as c9 |
| LATERAL VIEW EXPLODE(c1.x2) lv as c10 |
| LATERAL VIEW EXPLODE(x5.x4.x3) lv as c11 |
| LATERAL VIEW EXPLODE(c1.x2) lv as c12 |
| LATERAL VIEW EXPLODE(x5.x4.x3) lv as c13 |
| LATERAL VIEW EXPLODE(c1.x2) lv as c14 |
| LATERAL VIEW EXPLODE(x5.x4.x3) lv as c15 |
| LATERAL VIEW EXPLODE(c1.x2) lv as c16 |
| LIMIT 1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@t1_n135 |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16 |
| FROM t1_n135 |
| LATERAL VIEW EXPLODE(x5.x4.x3) lv as c1 |
| LATERAL VIEW EXPLODE(c1.x2) lv as c2 |
| LATERAL VIEW EXPLODE(x5.x4.x3) lv as c3 |
| LATERAL VIEW EXPLODE(c1.x2) lv as c4 |
| LATERAL VIEW EXPLODE(x5.x4.x3) lv as c5 |
| LATERAL VIEW EXPLODE(c1.x2) lv as c6 |
| LATERAL VIEW EXPLODE(x5.x4.x3) lv as c7 |
| LATERAL VIEW EXPLODE(c1.x2) lv as c8 |
| LATERAL VIEW EXPLODE(x5.x4.x3) lv as c9 |
| LATERAL VIEW EXPLODE(c1.x2) lv as c10 |
| LATERAL VIEW EXPLODE(x5.x4.x3) lv as c11 |
| LATERAL VIEW EXPLODE(c1.x2) lv as c12 |
| LATERAL VIEW EXPLODE(x5.x4.x3) lv as c13 |
| LATERAL VIEW EXPLODE(c1.x2) lv as c14 |
| LATERAL VIEW EXPLODE(x5.x4.x3) lv as c15 |
| LATERAL VIEW EXPLODE(c1.x2) lv as c16 |
| LIMIT 1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@t1_n135 |
| #### A masked pattern was here #### |
| {"x1":"x1_1","x2":["x2_1","x2_2"]} x2_1 {"x1":"x1_1","x2":["x2_1","x2_2"]} x2_1 {"x1":"x1_1","x2":["x2_1","x2_2"]} x2_1 {"x1":"x1_1","x2":["x2_1","x2_2"]} x2_1 {"x1":"x1_1","x2":["x2_1","x2_2"]} x2_1 {"x1":"x1_1","x2":["x2_1","x2_2"]} x2_1 {"x1":"x1_1","x2":["x2_1","x2_2"]} x2_1 {"x1":"x1_1","x2":["x2_1","x2_2"]} x2_1 |