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


                                                                                
                                                                                                                                                                                                         
-- This file is automatically generated by LogicalPlanToSQLSuite.
SELECT COUNT(DISTINCT id) FROM parquet_t0
--------------------------------------------------------------------------------
SELECT `gen_attr_0` AS `count(DISTINCT id)` FROM (SELECT count(DISTINCT `gen_attr_1`) AS `gen_attr_0` FROM (SELECT `id` AS `gen_attr_1` FROM `default`.`parquet_t0`) AS gen_subquery_0) AS gen_subquery_1