1DROP TABLE parquet_types_staging; 2DROP TABLE parquet_types; 3 4CREATE TABLE parquet_types_staging ( 5 cint int, 6 ctinyint tinyint, 7 csmallint smallint, 8 cfloat float, 9 cdouble double, 10 cstring1 string 11) ROW FORMAT DELIMITED 12FIELDS TERMINATED BY '|'; 13 14CREATE TABLE parquet_types ( 15 cint int, 16 ctinyint tinyint, 17 csmallint smallint, 18 cfloat float, 19 cdouble double, 20 cstring1 string 21) STORED AS PARQUET; 22 23LOAD DATA LOCAL INPATH '../../data/files/parquet_types.txt' OVERWRITE INTO TABLE parquet_types_staging; 24 25INSERT OVERWRITE TABLE parquet_types SELECT * FROM parquet_types_staging; 26 27SELECT * FROM parquet_types; 28 29SELECT ctinyint, 30 MAX(cint), 31 MIN(csmallint), 32 COUNT(cstring1), 33 AVG(cfloat), 34 STDDEV_POP(cdouble) 35FROM parquet_types 36GROUP BY ctinyint 37ORDER BY ctinyint 38; 39