aboutsummaryrefslogblamecommitdiff
path: root/sql/hive/src/test/resources/sqlgen/union_distinct.sql
blob: 46644b89ebb047051618458e24bff8f24cbcf25c (plain) (tree)
1
2
3
4


                                                                                
                                                                                                                                                                                                                                                     
-- This file is automatically generated by LogicalPlanToSQLSuite.
SELECT * FROM t0 UNION SELECT * FROM t0
--------------------------------------------------------------------------------
SELECT `gen_attr_0` AS `id` FROM ((SELECT `gen_attr_0` FROM (SELECT `id` AS `gen_attr_0` FROM `default`.`t0`) AS gen_subquery_0) UNION DISTINCT (SELECT `gen_attr_1` FROM (SELECT `id` AS `gen_attr_1` FROM `default`.`t0`) AS gen_subquery_1)) AS t0