blob: a7e101b0a8dca2a2919a6a722fa427421ae3a97c [file] [log] [blame]
CREATE TEMPORARY TABLE dfs.tmp.temp_tbl9w PARTITION BY ( col_chr )
AS
SELECT col_int, col_chr, col_vrchr1, col_vrchr2 , col_dt, col_tim, col_tmstmp , col_flt, col_intrvl_yr , col_intrvl_day , col_bln
FROM typeall_l;
SELECT
MAX(col_int) mx_int,
MIN(col_int) min_int,
SUM(col_int) sum_int,
AVG(col_int) avg_int,
MIN(col_chr) min_chr,
MAX(col_chr) mx_chr,
MIN(col_vrchr1) min_vrcr1,
MAX(col_vrchr1) mx_vrcr1,
MIN(col_vrchr2) min_vrcr2,
MAX(col_vrchr2) mx_vrcr2,
MAX(col_dt) mx_dt,
MIN(col_dt) mn_dt,
MAX(col_tim) mx_tm,
MIN(col_tim) mn_tm,
COUNT(*) cow_nt
FROM dfs.tmp.temp_tbl9w;
DROP TABLE dfs.tmp.temp_tbl9w;