aboutsummaryrefslogblamecommitdiff
path: root/sql/hive/src/test/resources/sqlgen/json_tuple_generator_2.sql
blob: 55dd491a32a327ec6d2de801dceef4499debccdd (plain) (tree)
1
2
3
4
5
6





                                                                                                                                                                                                                                                                                                                                                                                
-- This file is automatically generated by LogicalPlanToSQLSuite.
SELECT a, b, c
FROM parquet_t3
LATERAL VIEW JSON_TUPLE(json, 'f1', 'f2', 'f3') jt AS a, b, c
--------------------------------------------------------------------------------
SELECT `gen_attr` AS `a`, `gen_attr` AS `b`, `gen_attr` AS `c` FROM (SELECT `gen_attr`, `gen_attr`, `gen_attr` FROM (SELECT `arr` AS `gen_attr`, `arr2` AS `gen_attr`, `json` AS `gen_attr`, `id` AS `gen_attr` FROM `default`.`parquet_t3`) AS gen_subquery_0 LATERAL VIEW json_tuple(`gen_attr`, "f1", "f2", "f3") gen_subquery_1 AS `gen_attr`, `gen_attr`, `gen_attr`) AS jt