aboutsummaryrefslogblamecommitdiff
path: root/sql/hive/src/test/resources/sqlgen/json_tuple_generator_2.sql
blob: 0d4f67f18426b41bc9d4de95194d94d9ed5e533a (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_0` AS `a`, `gen_attr_1` AS `b`, `gen_attr_2` AS `c` FROM (SELECT `gen_attr_0`, `gen_attr_1`, `gen_attr_2` FROM (SELECT `arr` AS `gen_attr_4`, `arr2` AS `gen_attr_5`, `json` AS `gen_attr_3`, `id` AS `gen_attr_6` FROM `default`.`parquet_t3`) AS gen_subquery_0 LATERAL VIEW json_tuple(`gen_attr_3`, "f1", "f2", "f3") gen_subquery_1 AS `gen_attr_0`, `gen_attr_1`, `gen_attr_2`) AS jt