-- ppd leaves invalid expr in field expr | |
CREATE TABLE test_issue (fileid int, infos ARRAY<STRUCT<u:INT>>, test_c STRUCT<user_c:STRUCT<age:INT>>); | |
CREATE VIEW v_test_issue AS SELECT fileid, i.u, test_c.user_c.age FROM test_issue LATERAL VIEW explode(infos) info AS i; | |
-- dummy data | |
LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE test_issue; | |
SELECT * FROM v_test_issue WHERE age = 25; |