| 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; |