blob: 7ae81ab5900b6ef283425682cc14feaaf7a0dbc2 [file] [log] [blame]
CREATE TABLE customer(orders array<string>);
set hive.explain.user=false;
EXPLAIN SELECT *
FROM customer
lateral view explode(orders) v as c1
lateral view explode(orders) v as c2
lateral view explode(orders) v as c3
lateral view explode(orders) v as c4
lateral view explode(orders) v as c5
lateral view explode(orders) v as c6
lateral view explode(orders) v as c7
lateral view explode(orders) v as c8
lateral view explode(orders) v as c9
;