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