http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/4db330e6/testdata/workloads/functional-query/queries/QueryTest/compute-stats.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/functional-query/queries/QueryTest/compute-stats.test b/testdata/workloads/functional-query/queries/QueryTest/compute-stats.test index 817dd4d..b741c5a 100644 --- a/testdata/workloads/functional-query/queries/QueryTest/compute-stats.test +++ b/testdata/workloads/functional-query/queries/QueryTest/compute-stats.test @@ -988,3 +988,1019 @@ show column stats alltypes_no_coldef ---- TYPES STRING, STRING, BIGINT, BIGINT, INT, DOUBLE ==== +---- QUERY +# Test that compute stats works on wide tables. +create table widetable_1000_cols +stored as parquet +as +select * from functional_parquet.widetable_1000_cols +==== +---- QUERY +compute stats widetable_1000_cols +==== +---- QUERY +show column stats widetable_1000_cols +---- RESULTS +'bool_col1','BOOLEAN',2,-1,1,1 +'tinyint_col1','TINYINT',5,-1,1,1 +'smallint_col1','SMALLINT',5,-1,2,2 +'int_col1','INT',5,-1,4,4 +'bigint_col1','BIGINT',5,-1,8,8 +'float_col1','FLOAT',5,-1,4,4 +'double_col1','DOUBLE',5,-1,8,8 +'string_col1','STRING',5,-1,1,1 +'bool_col2','BOOLEAN',2,-1,1,1 +'tinyint_col2','TINYINT',5,-1,1,1 +'smallint_col2','SMALLINT',5,-1,2,2 +'int_col2','INT',5,-1,4,4 +'bigint_col2','BIGINT',5,-1,8,8 +'float_col2','FLOAT',5,-1,4,4 +'double_col2','DOUBLE',5,-1,8,8 +'string_col2','STRING',5,-1,1,1 +'bool_col3','BOOLEAN',2,-1,1,1 +'tinyint_col3','TINYINT',5,-1,1,1 +'smallint_col3','SMALLINT',5,-1,2,2 +'int_col3','INT',5,-1,4,4 +'bigint_col3','BIGINT',5,-1,8,8 +'float_col3','FLOAT',5,-1,4,4 +'double_col3','DOUBLE',5,-1,8,8 +'string_col3','STRING',5,-1,1,1 +'bool_col4','BOOLEAN',2,-1,1,1 +'tinyint_col4','TINYINT',5,-1,1,1 +'smallint_col4','SMALLINT',5,-1,2,2 +'int_col4','INT',5,-1,4,4 +'bigint_col4','BIGINT',5,-1,8,8 +'float_col4','FLOAT',5,-1,4,4 +'double_col4','DOUBLE',5,-1,8,8 +'string_col4','STRING',5,-1,1,1 +'bool_col5','BOOLEAN',2,-1,1,1 +'tinyint_col5','TINYINT',5,-1,1,1 +'smallint_col5','SMALLINT',5,-1,2,2 +'int_col5','INT',5,-1,4,4 +'bigint_col5','BIGINT',5,-1,8,8 +'float_col5','FLOAT',5,-1,4,4 +'double_col5','DOUBLE',5,-1,8,8 +'string_col5','STRING',5,-1,1,1 +'bool_col6','BOOLEAN',2,-1,1,1 +'tinyint_col6','TINYINT',5,-1,1,1 +'smallint_col6','SMALLINT',5,-1,2,2 +'int_col6','INT',5,-1,4,4 +'bigint_col6','BIGINT',5,-1,8,8 +'float_col6','FLOAT',5,-1,4,4 +'double_col6','DOUBLE',5,-1,8,8 +'string_col6','STRING',5,-1,1,1 +'bool_col7','BOOLEAN',2,-1,1,1 +'tinyint_col7','TINYINT',5,-1,1,1 +'smallint_col7','SMALLINT',5,-1,2,2 +'int_col7','INT',5,-1,4,4 +'bigint_col7','BIGINT',5,-1,8,8 +'float_col7','FLOAT',5,-1,4,4 +'double_col7','DOUBLE',5,-1,8,8 +'string_col7','STRING',5,-1,1,1 +'bool_col8','BOOLEAN',2,-1,1,1 +'tinyint_col8','TINYINT',5,-1,1,1 +'smallint_col8','SMALLINT',5,-1,2,2 +'int_col8','INT',5,-1,4,4 +'bigint_col8','BIGINT',5,-1,8,8 +'float_col8','FLOAT',5,-1,4,4 +'double_col8','DOUBLE',5,-1,8,8 +'string_col8','STRING',5,-1,1,1 +'bool_col9','BOOLEAN',2,-1,1,1 +'tinyint_col9','TINYINT',5,-1,1,1 +'smallint_col9','SMALLINT',5,-1,2,2 +'int_col9','INT',5,-1,4,4 +'bigint_col9','BIGINT',5,-1,8,8 +'float_col9','FLOAT',5,-1,4,4 +'double_col9','DOUBLE',5,-1,8,8 +'string_col9','STRING',5,-1,1,1 +'bool_col10','BOOLEAN',2,-1,1,1 +'tinyint_col10','TINYINT',5,-1,1,1 +'smallint_col10','SMALLINT',5,-1,2,2 +'int_col10','INT',5,-1,4,4 +'bigint_col10','BIGINT',5,-1,8,8 +'float_col10','FLOAT',5,-1,4,4 +'double_col10','DOUBLE',5,-1,8,8 +'string_col10','STRING',5,-1,1,1 +'bool_col11','BOOLEAN',2,-1,1,1 +'tinyint_col11','TINYINT',5,-1,1,1 +'smallint_col11','SMALLINT',5,-1,2,2 +'int_col11','INT',5,-1,4,4 +'bigint_col11','BIGINT',5,-1,8,8 +'float_col11','FLOAT',5,-1,4,4 +'double_col11','DOUBLE',5,-1,8,8 +'string_col11','STRING',5,-1,1,1 +'bool_col12','BOOLEAN',2,-1,1,1 +'tinyint_col12','TINYINT',5,-1,1,1 +'smallint_col12','SMALLINT',5,-1,2,2 +'int_col12','INT',5,-1,4,4 +'bigint_col12','BIGINT',5,-1,8,8 +'float_col12','FLOAT',5,-1,4,4 +'double_col12','DOUBLE',5,-1,8,8 +'string_col12','STRING',5,-1,1,1 +'bool_col13','BOOLEAN',2,-1,1,1 +'tinyint_col13','TINYINT',5,-1,1,1 +'smallint_col13','SMALLINT',5,-1,2,2 +'int_col13','INT',5,-1,4,4 +'bigint_col13','BIGINT',5,-1,8,8 +'float_col13','FLOAT',5,-1,4,4 +'double_col13','DOUBLE',5,-1,8,8 +'string_col13','STRING',5,-1,1,1 +'bool_col14','BOOLEAN',2,-1,1,1 +'tinyint_col14','TINYINT',5,-1,1,1 +'smallint_col14','SMALLINT',5,-1,2,2 +'int_col14','INT',5,-1,4,4 +'bigint_col14','BIGINT',5,-1,8,8 +'float_col14','FLOAT',5,-1,4,4 +'double_col14','DOUBLE',5,-1,8,8 +'string_col14','STRING',5,-1,1,1 +'bool_col15','BOOLEAN',2,-1,1,1 +'tinyint_col15','TINYINT',5,-1,1,1 +'smallint_col15','SMALLINT',5,-1,2,2 +'int_col15','INT',5,-1,4,4 +'bigint_col15','BIGINT',5,-1,8,8 +'float_col15','FLOAT',5,-1,4,4 +'double_col15','DOUBLE',5,-1,8,8 +'string_col15','STRING',5,-1,1,1 +'bool_col16','BOOLEAN',2,-1,1,1 +'tinyint_col16','TINYINT',5,-1,1,1 +'smallint_col16','SMALLINT',5,-1,2,2 +'int_col16','INT',5,-1,4,4 +'bigint_col16','BIGINT',5,-1,8,8 +'float_col16','FLOAT',5,-1,4,4 +'double_col16','DOUBLE',5,-1,8,8 +'string_col16','STRING',5,-1,1,1 +'bool_col17','BOOLEAN',2,-1,1,1 +'tinyint_col17','TINYINT',5,-1,1,1 +'smallint_col17','SMALLINT',5,-1,2,2 +'int_col17','INT',5,-1,4,4 +'bigint_col17','BIGINT',5,-1,8,8 +'float_col17','FLOAT',5,-1,4,4 +'double_col17','DOUBLE',5,-1,8,8 +'string_col17','STRING',5,-1,1,1 +'bool_col18','BOOLEAN',2,-1,1,1 +'tinyint_col18','TINYINT',5,-1,1,1 +'smallint_col18','SMALLINT',5,-1,2,2 +'int_col18','INT',5,-1,4,4 +'bigint_col18','BIGINT',5,-1,8,8 +'float_col18','FLOAT',5,-1,4,4 +'double_col18','DOUBLE',5,-1,8,8 +'string_col18','STRING',5,-1,1,1 +'bool_col19','BOOLEAN',2,-1,1,1 +'tinyint_col19','TINYINT',5,-1,1,1 +'smallint_col19','SMALLINT',5,-1,2,2 +'int_col19','INT',5,-1,4,4 +'bigint_col19','BIGINT',5,-1,8,8 +'float_col19','FLOAT',5,-1,4,4 +'double_col19','DOUBLE',5,-1,8,8 +'string_col19','STRING',5,-1,1,1 +'bool_col20','BOOLEAN',2,-1,1,1 +'tinyint_col20','TINYINT',5,-1,1,1 +'smallint_col20','SMALLINT',5,-1,2,2 +'int_col20','INT',5,-1,4,4 +'bigint_col20','BIGINT',5,-1,8,8 +'float_col20','FLOAT',5,-1,4,4 +'double_col20','DOUBLE',5,-1,8,8 +'string_col20','STRING',5,-1,1,1 +'bool_col21','BOOLEAN',2,-1,1,1 +'tinyint_col21','TINYINT',5,-1,1,1 +'smallint_col21','SMALLINT',5,-1,2,2 +'int_col21','INT',5,-1,4,4 +'bigint_col21','BIGINT',5,-1,8,8 +'float_col21','FLOAT',5,-1,4,4 +'double_col21','DOUBLE',5,-1,8,8 +'string_col21','STRING',5,-1,1,1 +'bool_col22','BOOLEAN',2,-1,1,1 +'tinyint_col22','TINYINT',5,-1,1,1 +'smallint_col22','SMALLINT',5,-1,2,2 +'int_col22','INT',5,-1,4,4 +'bigint_col22','BIGINT',5,-1,8,8 +'float_col22','FLOAT',5,-1,4,4 +'double_col22','DOUBLE',5,-1,8,8 +'string_col22','STRING',5,-1,1,1 +'bool_col23','BOOLEAN',2,-1,1,1 +'tinyint_col23','TINYINT',5,-1,1,1 +'smallint_col23','SMALLINT',5,-1,2,2 +'int_col23','INT',5,-1,4,4 +'bigint_col23','BIGINT',5,-1,8,8 +'float_col23','FLOAT',5,-1,4,4 +'double_col23','DOUBLE',5,-1,8,8 +'string_col23','STRING',5,-1,1,1 +'bool_col24','BOOLEAN',2,-1,1,1 +'tinyint_col24','TINYINT',5,-1,1,1 +'smallint_col24','SMALLINT',5,-1,2,2 +'int_col24','INT',5,-1,4,4 +'bigint_col24','BIGINT',5,-1,8,8 +'float_col24','FLOAT',5,-1,4,4 +'double_col24','DOUBLE',5,-1,8,8 +'string_col24','STRING',5,-1,1,1 +'bool_col25','BOOLEAN',2,-1,1,1 +'tinyint_col25','TINYINT',5,-1,1,1 +'smallint_col25','SMALLINT',5,-1,2,2 +'int_col25','INT',5,-1,4,4 +'bigint_col25','BIGINT',5,-1,8,8 +'float_col25','FLOAT',5,-1,4,4 +'double_col25','DOUBLE',5,-1,8,8 +'string_col25','STRING',5,-1,1,1 +'bool_col26','BOOLEAN',2,-1,1,1 +'tinyint_col26','TINYINT',5,-1,1,1 +'smallint_col26','SMALLINT',5,-1,2,2 +'int_col26','INT',5,-1,4,4 +'bigint_col26','BIGINT',5,-1,8,8 +'float_col26','FLOAT',5,-1,4,4 +'double_col26','DOUBLE',5,-1,8,8 +'string_col26','STRING',5,-1,1,1 +'bool_col27','BOOLEAN',2,-1,1,1 +'tinyint_col27','TINYINT',5,-1,1,1 +'smallint_col27','SMALLINT',5,-1,2,2 +'int_col27','INT',5,-1,4,4 +'bigint_col27','BIGINT',5,-1,8,8 +'float_col27','FLOAT',5,-1,4,4 +'double_col27','DOUBLE',5,-1,8,8 +'string_col27','STRING',5,-1,1,1 +'bool_col28','BOOLEAN',2,-1,1,1 +'tinyint_col28','TINYINT',5,-1,1,1 +'smallint_col28','SMALLINT',5,-1,2,2 +'int_col28','INT',5,-1,4,4 +'bigint_col28','BIGINT',5,-1,8,8 +'float_col28','FLOAT',5,-1,4,4 +'double_col28','DOUBLE',5,-1,8,8 +'string_col28','STRING',5,-1,1,1 +'bool_col29','BOOLEAN',2,-1,1,1 +'tinyint_col29','TINYINT',5,-1,1,1 +'smallint_col29','SMALLINT',5,-1,2,2 +'int_col29','INT',5,-1,4,4 +'bigint_col29','BIGINT',5,-1,8,8 +'float_col29','FLOAT',5,-1,4,4 +'double_col29','DOUBLE',5,-1,8,8 +'string_col29','STRING',5,-1,1,1 +'bool_col30','BOOLEAN',2,-1,1,1 +'tinyint_col30','TINYINT',5,-1,1,1 +'smallint_col30','SMALLINT',5,-1,2,2 +'int_col30','INT',5,-1,4,4 +'bigint_col30','BIGINT',5,-1,8,8 +'float_col30','FLOAT',5,-1,4,4 +'double_col30','DOUBLE',5,-1,8,8 +'string_col30','STRING',5,-1,1,1 +'bool_col31','BOOLEAN',2,-1,1,1 +'tinyint_col31','TINYINT',5,-1,1,1 +'smallint_col31','SMALLINT',5,-1,2,2 +'int_col31','INT',5,-1,4,4 +'bigint_col31','BIGINT',5,-1,8,8 +'float_col31','FLOAT',5,-1,4,4 +'double_col31','DOUBLE',5,-1,8,8 +'string_col31','STRING',5,-1,1,1 +'bool_col32','BOOLEAN',2,-1,1,1 +'tinyint_col32','TINYINT',5,-1,1,1 +'smallint_col32','SMALLINT',5,-1,2,2 +'int_col32','INT',5,-1,4,4 +'bigint_col32','BIGINT',5,-1,8,8 +'float_col32','FLOAT',5,-1,4,4 +'double_col32','DOUBLE',5,-1,8,8 +'string_col32','STRING',5,-1,1,1 +'bool_col33','BOOLEAN',2,-1,1,1 +'tinyint_col33','TINYINT',5,-1,1,1 +'smallint_col33','SMALLINT',5,-1,2,2 +'int_col33','INT',5,-1,4,4 +'bigint_col33','BIGINT',5,-1,8,8 +'float_col33','FLOAT',5,-1,4,4 +'double_col33','DOUBLE',5,-1,8,8 +'string_col33','STRING',5,-1,1,1 +'bool_col34','BOOLEAN',2,-1,1,1 +'tinyint_col34','TINYINT',5,-1,1,1 +'smallint_col34','SMALLINT',5,-1,2,2 +'int_col34','INT',5,-1,4,4 +'bigint_col34','BIGINT',5,-1,8,8 +'float_col34','FLOAT',5,-1,4,4 +'double_col34','DOUBLE',5,-1,8,8 +'string_col34','STRING',5,-1,1,1 +'bool_col35','BOOLEAN',2,-1,1,1 +'tinyint_col35','TINYINT',5,-1,1,1 +'smallint_col35','SMALLINT',5,-1,2,2 +'int_col35','INT',5,-1,4,4 +'bigint_col35','BIGINT',5,-1,8,8 +'float_col35','FLOAT',5,-1,4,4 +'double_col35','DOUBLE',5,-1,8,8 +'string_col35','STRING',5,-1,1,1 +'bool_col36','BOOLEAN',2,-1,1,1 +'tinyint_col36','TINYINT',5,-1,1,1 +'smallint_col36','SMALLINT',5,-1,2,2 +'int_col36','INT',5,-1,4,4 +'bigint_col36','BIGINT',5,-1,8,8 +'float_col36','FLOAT',5,-1,4,4 +'double_col36','DOUBLE',5,-1,8,8 +'string_col36','STRING',5,-1,1,1 +'bool_col37','BOOLEAN',2,-1,1,1 +'tinyint_col37','TINYINT',5,-1,1,1 +'smallint_col37','SMALLINT',5,-1,2,2 +'int_col37','INT',5,-1,4,4 +'bigint_col37','BIGINT',5,-1,8,8 +'float_col37','FLOAT',5,-1,4,4 +'double_col37','DOUBLE',5,-1,8,8 +'string_col37','STRING',5,-1,1,1 +'bool_col38','BOOLEAN',2,-1,1,1 +'tinyint_col38','TINYINT',5,-1,1,1 +'smallint_col38','SMALLINT',5,-1,2,2 +'int_col38','INT',5,-1,4,4 +'bigint_col38','BIGINT',5,-1,8,8 +'float_col38','FLOAT',5,-1,4,4 +'double_col38','DOUBLE',5,-1,8,8 +'string_col38','STRING',5,-1,1,1 +'bool_col39','BOOLEAN',2,-1,1,1 +'tinyint_col39','TINYINT',5,-1,1,1 +'smallint_col39','SMALLINT',5,-1,2,2 +'int_col39','INT',5,-1,4,4 +'bigint_col39','BIGINT',5,-1,8,8 +'float_col39','FLOAT',5,-1,4,4 +'double_col39','DOUBLE',5,-1,8,8 +'string_col39','STRING',5,-1,1,1 +'bool_col40','BOOLEAN',2,-1,1,1 +'tinyint_col40','TINYINT',5,-1,1,1 +'smallint_col40','SMALLINT',5,-1,2,2 +'int_col40','INT',5,-1,4,4 +'bigint_col40','BIGINT',5,-1,8,8 +'float_col40','FLOAT',5,-1,4,4 +'double_col40','DOUBLE',5,-1,8,8 +'string_col40','STRING',5,-1,1,1 +'bool_col41','BOOLEAN',2,-1,1,1 +'tinyint_col41','TINYINT',5,-1,1,1 +'smallint_col41','SMALLINT',5,-1,2,2 +'int_col41','INT',5,-1,4,4 +'bigint_col41','BIGINT',5,-1,8,8 +'float_col41','FLOAT',5,-1,4,4 +'double_col41','DOUBLE',5,-1,8,8 +'string_col41','STRING',5,-1,1,1 +'bool_col42','BOOLEAN',2,-1,1,1 +'tinyint_col42','TINYINT',5,-1,1,1 +'smallint_col42','SMALLINT',5,-1,2,2 +'int_col42','INT',5,-1,4,4 +'bigint_col42','BIGINT',5,-1,8,8 +'float_col42','FLOAT',5,-1,4,4 +'double_col42','DOUBLE',5,-1,8,8 +'string_col42','STRING',5,-1,1,1 +'bool_col43','BOOLEAN',2,-1,1,1 +'tinyint_col43','TINYINT',5,-1,1,1 +'smallint_col43','SMALLINT',5,-1,2,2 +'int_col43','INT',5,-1,4,4 +'bigint_col43','BIGINT',5,-1,8,8 +'float_col43','FLOAT',5,-1,4,4 +'double_col43','DOUBLE',5,-1,8,8 +'string_col43','STRING',5,-1,1,1 +'bool_col44','BOOLEAN',2,-1,1,1 +'tinyint_col44','TINYINT',5,-1,1,1 +'smallint_col44','SMALLINT',5,-1,2,2 +'int_col44','INT',5,-1,4,4 +'bigint_col44','BIGINT',5,-1,8,8 +'float_col44','FLOAT',5,-1,4,4 +'double_col44','DOUBLE',5,-1,8,8 +'string_col44','STRING',5,-1,1,1 +'bool_col45','BOOLEAN',2,-1,1,1 +'tinyint_col45','TINYINT',5,-1,1,1 +'smallint_col45','SMALLINT',5,-1,2,2 +'int_col45','INT',5,-1,4,4 +'bigint_col45','BIGINT',5,-1,8,8 +'float_col45','FLOAT',5,-1,4,4 +'double_col45','DOUBLE',5,-1,8,8 +'string_col45','STRING',5,-1,1,1 +'bool_col46','BOOLEAN',2,-1,1,1 +'tinyint_col46','TINYINT',5,-1,1,1 +'smallint_col46','SMALLINT',5,-1,2,2 +'int_col46','INT',5,-1,4,4 +'bigint_col46','BIGINT',5,-1,8,8 +'float_col46','FLOAT',5,-1,4,4 +'double_col46','DOUBLE',5,-1,8,8 +'string_col46','STRING',5,-1,1,1 +'bool_col47','BOOLEAN',2,-1,1,1 +'tinyint_col47','TINYINT',5,-1,1,1 +'smallint_col47','SMALLINT',5,-1,2,2 +'int_col47','INT',5,-1,4,4 +'bigint_col47','BIGINT',5,-1,8,8 +'float_col47','FLOAT',5,-1,4,4 +'double_col47','DOUBLE',5,-1,8,8 +'string_col47','STRING',5,-1,1,1 +'bool_col48','BOOLEAN',2,-1,1,1 +'tinyint_col48','TINYINT',5,-1,1,1 +'smallint_col48','SMALLINT',5,-1,2,2 +'int_col48','INT',5,-1,4,4 +'bigint_col48','BIGINT',5,-1,8,8 +'float_col48','FLOAT',5,-1,4,4 +'double_col48','DOUBLE',5,-1,8,8 +'string_col48','STRING',5,-1,1,1 +'bool_col49','BOOLEAN',2,-1,1,1 +'tinyint_col49','TINYINT',5,-1,1,1 +'smallint_col49','SMALLINT',5,-1,2,2 +'int_col49','INT',5,-1,4,4 +'bigint_col49','BIGINT',5,-1,8,8 +'float_col49','FLOAT',5,-1,4,4 +'double_col49','DOUBLE',5,-1,8,8 +'string_col49','STRING',5,-1,1,1 +'bool_col50','BOOLEAN',2,-1,1,1 +'tinyint_col50','TINYINT',5,-1,1,1 +'smallint_col50','SMALLINT',5,-1,2,2 +'int_col50','INT',5,-1,4,4 +'bigint_col50','BIGINT',5,-1,8,8 +'float_col50','FLOAT',5,-1,4,4 +'double_col50','DOUBLE',5,-1,8,8 +'string_col50','STRING',5,-1,1,1 +'bool_col51','BOOLEAN',2,-1,1,1 +'tinyint_col51','TINYINT',5,-1,1,1 +'smallint_col51','SMALLINT',5,-1,2,2 +'int_col51','INT',5,-1,4,4 +'bigint_col51','BIGINT',5,-1,8,8 +'float_col51','FLOAT',5,-1,4,4 +'double_col51','DOUBLE',5,-1,8,8 +'string_col51','STRING',5,-1,1,1 +'bool_col52','BOOLEAN',2,-1,1,1 +'tinyint_col52','TINYINT',5,-1,1,1 +'smallint_col52','SMALLINT',5,-1,2,2 +'int_col52','INT',5,-1,4,4 +'bigint_col52','BIGINT',5,-1,8,8 +'float_col52','FLOAT',5,-1,4,4 +'double_col52','DOUBLE',5,-1,8,8 +'string_col52','STRING',5,-1,1,1 +'bool_col53','BOOLEAN',2,-1,1,1 +'tinyint_col53','TINYINT',5,-1,1,1 +'smallint_col53','SMALLINT',5,-1,2,2 +'int_col53','INT',5,-1,4,4 +'bigint_col53','BIGINT',5,-1,8,8 +'float_col53','FLOAT',5,-1,4,4 +'double_col53','DOUBLE',5,-1,8,8 +'string_col53','STRING',5,-1,1,1 +'bool_col54','BOOLEAN',2,-1,1,1 +'tinyint_col54','TINYINT',5,-1,1,1 +'smallint_col54','SMALLINT',5,-1,2,2 +'int_col54','INT',5,-1,4,4 +'bigint_col54','BIGINT',5,-1,8,8 +'float_col54','FLOAT',5,-1,4,4 +'double_col54','DOUBLE',5,-1,8,8 +'string_col54','STRING',5,-1,1,1 +'bool_col55','BOOLEAN',2,-1,1,1 +'tinyint_col55','TINYINT',5,-1,1,1 +'smallint_col55','SMALLINT',5,-1,2,2 +'int_col55','INT',5,-1,4,4 +'bigint_col55','BIGINT',5,-1,8,8 +'float_col55','FLOAT',5,-1,4,4 +'double_col55','DOUBLE',5,-1,8,8 +'string_col55','STRING',5,-1,1,1 +'bool_col56','BOOLEAN',2,-1,1,1 +'tinyint_col56','TINYINT',5,-1,1,1 +'smallint_col56','SMALLINT',5,-1,2,2 +'int_col56','INT',5,-1,4,4 +'bigint_col56','BIGINT',5,-1,8,8 +'float_col56','FLOAT',5,-1,4,4 +'double_col56','DOUBLE',5,-1,8,8 +'string_col56','STRING',5,-1,1,1 +'bool_col57','BOOLEAN',2,-1,1,1 +'tinyint_col57','TINYINT',5,-1,1,1 +'smallint_col57','SMALLINT',5,-1,2,2 +'int_col57','INT',5,-1,4,4 +'bigint_col57','BIGINT',5,-1,8,8 +'float_col57','FLOAT',5,-1,4,4 +'double_col57','DOUBLE',5,-1,8,8 +'string_col57','STRING',5,-1,1,1 +'bool_col58','BOOLEAN',2,-1,1,1 +'tinyint_col58','TINYINT',5,-1,1,1 +'smallint_col58','SMALLINT',5,-1,2,2 +'int_col58','INT',5,-1,4,4 +'bigint_col58','BIGINT',5,-1,8,8 +'float_col58','FLOAT',5,-1,4,4 +'double_col58','DOUBLE',5,-1,8,8 +'string_col58','STRING',5,-1,1,1 +'bool_col59','BOOLEAN',2,-1,1,1 +'tinyint_col59','TINYINT',5,-1,1,1 +'smallint_col59','SMALLINT',5,-1,2,2 +'int_col59','INT',5,-1,4,4 +'bigint_col59','BIGINT',5,-1,8,8 +'float_col59','FLOAT',5,-1,4,4 +'double_col59','DOUBLE',5,-1,8,8 +'string_col59','STRING',5,-1,1,1 +'bool_col60','BOOLEAN',2,-1,1,1 +'tinyint_col60','TINYINT',5,-1,1,1 +'smallint_col60','SMALLINT',5,-1,2,2 +'int_col60','INT',5,-1,4,4 +'bigint_col60','BIGINT',5,-1,8,8 +'float_col60','FLOAT',5,-1,4,4 +'double_col60','DOUBLE',5,-1,8,8 +'string_col60','STRING',5,-1,1,1 +'bool_col61','BOOLEAN',2,-1,1,1 +'tinyint_col61','TINYINT',5,-1,1,1 +'smallint_col61','SMALLINT',5,-1,2,2 +'int_col61','INT',5,-1,4,4 +'bigint_col61','BIGINT',5,-1,8,8 +'float_col61','FLOAT',5,-1,4,4 +'double_col61','DOUBLE',5,-1,8,8 +'string_col61','STRING',5,-1,1,1 +'bool_col62','BOOLEAN',2,-1,1,1 +'tinyint_col62','TINYINT',5,-1,1,1 +'smallint_col62','SMALLINT',5,-1,2,2 +'int_col62','INT',5,-1,4,4 +'bigint_col62','BIGINT',5,-1,8,8 +'float_col62','FLOAT',5,-1,4,4 +'double_col62','DOUBLE',5,-1,8,8 +'string_col62','STRING',5,-1,1,1 +'bool_col63','BOOLEAN',2,-1,1,1 +'tinyint_col63','TINYINT',5,-1,1,1 +'smallint_col63','SMALLINT',5,-1,2,2 +'int_col63','INT',5,-1,4,4 +'bigint_col63','BIGINT',5,-1,8,8 +'float_col63','FLOAT',5,-1,4,4 +'double_col63','DOUBLE',5,-1,8,8 +'string_col63','STRING',5,-1,1,1 +'bool_col64','BOOLEAN',2,-1,1,1 +'tinyint_col64','TINYINT',5,-1,1,1 +'smallint_col64','SMALLINT',5,-1,2,2 +'int_col64','INT',5,-1,4,4 +'bigint_col64','BIGINT',5,-1,8,8 +'float_col64','FLOAT',5,-1,4,4 +'double_col64','DOUBLE',5,-1,8,8 +'string_col64','STRING',5,-1,1,1 +'bool_col65','BOOLEAN',2,-1,1,1 +'tinyint_col65','TINYINT',5,-1,1,1 +'smallint_col65','SMALLINT',5,-1,2,2 +'int_col65','INT',5,-1,4,4 +'bigint_col65','BIGINT',5,-1,8,8 +'float_col65','FLOAT',5,-1,4,4 +'double_col65','DOUBLE',5,-1,8,8 +'string_col65','STRING',5,-1,1,1 +'bool_col66','BOOLEAN',2,-1,1,1 +'tinyint_col66','TINYINT',5,-1,1,1 +'smallint_col66','SMALLINT',5,-1,2,2 +'int_col66','INT',5,-1,4,4 +'bigint_col66','BIGINT',5,-1,8,8 +'float_col66','FLOAT',5,-1,4,4 +'double_col66','DOUBLE',5,-1,8,8 +'string_col66','STRING',5,-1,1,1 +'bool_col67','BOOLEAN',2,-1,1,1 +'tinyint_col67','TINYINT',5,-1,1,1 +'smallint_col67','SMALLINT',5,-1,2,2 +'int_col67','INT',5,-1,4,4 +'bigint_col67','BIGINT',5,-1,8,8 +'float_col67','FLOAT',5,-1,4,4 +'double_col67','DOUBLE',5,-1,8,8 +'string_col67','STRING',5,-1,1,1 +'bool_col68','BOOLEAN',2,-1,1,1 +'tinyint_col68','TINYINT',5,-1,1,1 +'smallint_col68','SMALLINT',5,-1,2,2 +'int_col68','INT',5,-1,4,4 +'bigint_col68','BIGINT',5,-1,8,8 +'float_col68','FLOAT',5,-1,4,4 +'double_col68','DOUBLE',5,-1,8,8 +'string_col68','STRING',5,-1,1,1 +'bool_col69','BOOLEAN',2,-1,1,1 +'tinyint_col69','TINYINT',5,-1,1,1 +'smallint_col69','SMALLINT',5,-1,2,2 +'int_col69','INT',5,-1,4,4 +'bigint_col69','BIGINT',5,-1,8,8 +'float_col69','FLOAT',5,-1,4,4 +'double_col69','DOUBLE',5,-1,8,8 +'string_col69','STRING',5,-1,1,1 +'bool_col70','BOOLEAN',2,-1,1,1 +'tinyint_col70','TINYINT',5,-1,1,1 +'smallint_col70','SMALLINT',5,-1,2,2 +'int_col70','INT',5,-1,4,4 +'bigint_col70','BIGINT',5,-1,8,8 +'float_col70','FLOAT',5,-1,4,4 +'double_col70','DOUBLE',5,-1,8,8 +'string_col70','STRING',5,-1,1,1 +'bool_col71','BOOLEAN',2,-1,1,1 +'tinyint_col71','TINYINT',5,-1,1,1 +'smallint_col71','SMALLINT',5,-1,2,2 +'int_col71','INT',5,-1,4,4 +'bigint_col71','BIGINT',5,-1,8,8 +'float_col71','FLOAT',5,-1,4,4 +'double_col71','DOUBLE',5,-1,8,8 +'string_col71','STRING',5,-1,1,1 +'bool_col72','BOOLEAN',2,-1,1,1 +'tinyint_col72','TINYINT',5,-1,1,1 +'smallint_col72','SMALLINT',5,-1,2,2 +'int_col72','INT',5,-1,4,4 +'bigint_col72','BIGINT',5,-1,8,8 +'float_col72','FLOAT',5,-1,4,4 +'double_col72','DOUBLE',5,-1,8,8 +'string_col72','STRING',5,-1,1,1 +'bool_col73','BOOLEAN',2,-1,1,1 +'tinyint_col73','TINYINT',5,-1,1,1 +'smallint_col73','SMALLINT',5,-1,2,2 +'int_col73','INT',5,-1,4,4 +'bigint_col73','BIGINT',5,-1,8,8 +'float_col73','FLOAT',5,-1,4,4 +'double_col73','DOUBLE',5,-1,8,8 +'string_col73','STRING',5,-1,1,1 +'bool_col74','BOOLEAN',2,-1,1,1 +'tinyint_col74','TINYINT',5,-1,1,1 +'smallint_col74','SMALLINT',5,-1,2,2 +'int_col74','INT',5,-1,4,4 +'bigint_col74','BIGINT',5,-1,8,8 +'float_col74','FLOAT',5,-1,4,4 +'double_col74','DOUBLE',5,-1,8,8 +'string_col74','STRING',5,-1,1,1 +'bool_col75','BOOLEAN',2,-1,1,1 +'tinyint_col75','TINYINT',5,-1,1,1 +'smallint_col75','SMALLINT',5,-1,2,2 +'int_col75','INT',5,-1,4,4 +'bigint_col75','BIGINT',5,-1,8,8 +'float_col75','FLOAT',5,-1,4,4 +'double_col75','DOUBLE',5,-1,8,8 +'string_col75','STRING',5,-1,1,1 +'bool_col76','BOOLEAN',2,-1,1,1 +'tinyint_col76','TINYINT',5,-1,1,1 +'smallint_col76','SMALLINT',5,-1,2,2 +'int_col76','INT',5,-1,4,4 +'bigint_col76','BIGINT',5,-1,8,8 +'float_col76','FLOAT',5,-1,4,4 +'double_col76','DOUBLE',5,-1,8,8 +'string_col76','STRING',5,-1,1,1 +'bool_col77','BOOLEAN',2,-1,1,1 +'tinyint_col77','TINYINT',5,-1,1,1 +'smallint_col77','SMALLINT',5,-1,2,2 +'int_col77','INT',5,-1,4,4 +'bigint_col77','BIGINT',5,-1,8,8 +'float_col77','FLOAT',5,-1,4,4 +'double_col77','DOUBLE',5,-1,8,8 +'string_col77','STRING',5,-1,1,1 +'bool_col78','BOOLEAN',2,-1,1,1 +'tinyint_col78','TINYINT',5,-1,1,1 +'smallint_col78','SMALLINT',5,-1,2,2 +'int_col78','INT',5,-1,4,4 +'bigint_col78','BIGINT',5,-1,8,8 +'float_col78','FLOAT',5,-1,4,4 +'double_col78','DOUBLE',5,-1,8,8 +'string_col78','STRING',5,-1,1,1 +'bool_col79','BOOLEAN',2,-1,1,1 +'tinyint_col79','TINYINT',5,-1,1,1 +'smallint_col79','SMALLINT',5,-1,2,2 +'int_col79','INT',5,-1,4,4 +'bigint_col79','BIGINT',5,-1,8,8 +'float_col79','FLOAT',5,-1,4,4 +'double_col79','DOUBLE',5,-1,8,8 +'string_col79','STRING',5,-1,1,1 +'bool_col80','BOOLEAN',2,-1,1,1 +'tinyint_col80','TINYINT',5,-1,1,1 +'smallint_col80','SMALLINT',5,-1,2,2 +'int_col80','INT',5,-1,4,4 +'bigint_col80','BIGINT',5,-1,8,8 +'float_col80','FLOAT',5,-1,4,4 +'double_col80','DOUBLE',5,-1,8,8 +'string_col80','STRING',5,-1,1,1 +'bool_col81','BOOLEAN',2,-1,1,1 +'tinyint_col81','TINYINT',5,-1,1,1 +'smallint_col81','SMALLINT',5,-1,2,2 +'int_col81','INT',5,-1,4,4 +'bigint_col81','BIGINT',5,-1,8,8 +'float_col81','FLOAT',5,-1,4,4 +'double_col81','DOUBLE',5,-1,8,8 +'string_col81','STRING',5,-1,1,1 +'bool_col82','BOOLEAN',2,-1,1,1 +'tinyint_col82','TINYINT',5,-1,1,1 +'smallint_col82','SMALLINT',5,-1,2,2 +'int_col82','INT',5,-1,4,4 +'bigint_col82','BIGINT',5,-1,8,8 +'float_col82','FLOAT',5,-1,4,4 +'double_col82','DOUBLE',5,-1,8,8 +'string_col82','STRING',5,-1,1,1 +'bool_col83','BOOLEAN',2,-1,1,1 +'tinyint_col83','TINYINT',5,-1,1,1 +'smallint_col83','SMALLINT',5,-1,2,2 +'int_col83','INT',5,-1,4,4 +'bigint_col83','BIGINT',5,-1,8,8 +'float_col83','FLOAT',5,-1,4,4 +'double_col83','DOUBLE',5,-1,8,8 +'string_col83','STRING',5,-1,1,1 +'bool_col84','BOOLEAN',2,-1,1,1 +'tinyint_col84','TINYINT',5,-1,1,1 +'smallint_col84','SMALLINT',5,-1,2,2 +'int_col84','INT',5,-1,4,4 +'bigint_col84','BIGINT',5,-1,8,8 +'float_col84','FLOAT',5,-1,4,4 +'double_col84','DOUBLE',5,-1,8,8 +'string_col84','STRING',5,-1,1,1 +'bool_col85','BOOLEAN',2,-1,1,1 +'tinyint_col85','TINYINT',5,-1,1,1 +'smallint_col85','SMALLINT',5,-1,2,2 +'int_col85','INT',5,-1,4,4 +'bigint_col85','BIGINT',5,-1,8,8 +'float_col85','FLOAT',5,-1,4,4 +'double_col85','DOUBLE',5,-1,8,8 +'string_col85','STRING',5,-1,1,1 +'bool_col86','BOOLEAN',2,-1,1,1 +'tinyint_col86','TINYINT',5,-1,1,1 +'smallint_col86','SMALLINT',5,-1,2,2 +'int_col86','INT',5,-1,4,4 +'bigint_col86','BIGINT',5,-1,8,8 +'float_col86','FLOAT',5,-1,4,4 +'double_col86','DOUBLE',5,-1,8,8 +'string_col86','STRING',5,-1,1,1 +'bool_col87','BOOLEAN',2,-1,1,1 +'tinyint_col87','TINYINT',5,-1,1,1 +'smallint_col87','SMALLINT',5,-1,2,2 +'int_col87','INT',5,-1,4,4 +'bigint_col87','BIGINT',5,-1,8,8 +'float_col87','FLOAT',5,-1,4,4 +'double_col87','DOUBLE',5,-1,8,8 +'string_col87','STRING',5,-1,1,1 +'bool_col88','BOOLEAN',2,-1,1,1 +'tinyint_col88','TINYINT',5,-1,1,1 +'smallint_col88','SMALLINT',5,-1,2,2 +'int_col88','INT',5,-1,4,4 +'bigint_col88','BIGINT',5,-1,8,8 +'float_col88','FLOAT',5,-1,4,4 +'double_col88','DOUBLE',5,-1,8,8 +'string_col88','STRING',5,-1,1,1 +'bool_col89','BOOLEAN',2,-1,1,1 +'tinyint_col89','TINYINT',5,-1,1,1 +'smallint_col89','SMALLINT',5,-1,2,2 +'int_col89','INT',5,-1,4,4 +'bigint_col89','BIGINT',5,-1,8,8 +'float_col89','FLOAT',5,-1,4,4 +'double_col89','DOUBLE',5,-1,8,8 +'string_col89','STRING',5,-1,1,1 +'bool_col90','BOOLEAN',2,-1,1,1 +'tinyint_col90','TINYINT',5,-1,1,1 +'smallint_col90','SMALLINT',5,-1,2,2 +'int_col90','INT',5,-1,4,4 +'bigint_col90','BIGINT',5,-1,8,8 +'float_col90','FLOAT',5,-1,4,4 +'double_col90','DOUBLE',5,-1,8,8 +'string_col90','STRING',5,-1,1,1 +'bool_col91','BOOLEAN',2,-1,1,1 +'tinyint_col91','TINYINT',5,-1,1,1 +'smallint_col91','SMALLINT',5,-1,2,2 +'int_col91','INT',5,-1,4,4 +'bigint_col91','BIGINT',5,-1,8,8 +'float_col91','FLOAT',5,-1,4,4 +'double_col91','DOUBLE',5,-1,8,8 +'string_col91','STRING',5,-1,1,1 +'bool_col92','BOOLEAN',2,-1,1,1 +'tinyint_col92','TINYINT',5,-1,1,1 +'smallint_col92','SMALLINT',5,-1,2,2 +'int_col92','INT',5,-1,4,4 +'bigint_col92','BIGINT',5,-1,8,8 +'float_col92','FLOAT',5,-1,4,4 +'double_col92','DOUBLE',5,-1,8,8 +'string_col92','STRING',5,-1,1,1 +'bool_col93','BOOLEAN',2,-1,1,1 +'tinyint_col93','TINYINT',5,-1,1,1 +'smallint_col93','SMALLINT',5,-1,2,2 +'int_col93','INT',5,-1,4,4 +'bigint_col93','BIGINT',5,-1,8,8 +'float_col93','FLOAT',5,-1,4,4 +'double_col93','DOUBLE',5,-1,8,8 +'string_col93','STRING',5,-1,1,1 +'bool_col94','BOOLEAN',2,-1,1,1 +'tinyint_col94','TINYINT',5,-1,1,1 +'smallint_col94','SMALLINT',5,-1,2,2 +'int_col94','INT',5,-1,4,4 +'bigint_col94','BIGINT',5,-1,8,8 +'float_col94','FLOAT',5,-1,4,4 +'double_col94','DOUBLE',5,-1,8,8 +'string_col94','STRING',5,-1,1,1 +'bool_col95','BOOLEAN',2,-1,1,1 +'tinyint_col95','TINYINT',5,-1,1,1 +'smallint_col95','SMALLINT',5,-1,2,2 +'int_col95','INT',5,-1,4,4 +'bigint_col95','BIGINT',5,-1,8,8 +'float_col95','FLOAT',5,-1,4,4 +'double_col95','DOUBLE',5,-1,8,8 +'string_col95','STRING',5,-1,1,1 +'bool_col96','BOOLEAN',2,-1,1,1 +'tinyint_col96','TINYINT',5,-1,1,1 +'smallint_col96','SMALLINT',5,-1,2,2 +'int_col96','INT',5,-1,4,4 +'bigint_col96','BIGINT',5,-1,8,8 +'float_col96','FLOAT',5,-1,4,4 +'double_col96','DOUBLE',5,-1,8,8 +'string_col96','STRING',5,-1,1,1 +'bool_col97','BOOLEAN',2,-1,1,1 +'tinyint_col97','TINYINT',5,-1,1,1 +'smallint_col97','SMALLINT',5,-1,2,2 +'int_col97','INT',5,-1,4,4 +'bigint_col97','BIGINT',5,-1,8,8 +'float_col97','FLOAT',5,-1,4,4 +'double_col97','DOUBLE',5,-1,8,8 +'string_col97','STRING',5,-1,1,1 +'bool_col98','BOOLEAN',2,-1,1,1 +'tinyint_col98','TINYINT',5,-1,1,1 +'smallint_col98','SMALLINT',5,-1,2,2 +'int_col98','INT',5,-1,4,4 +'bigint_col98','BIGINT',5,-1,8,8 +'float_col98','FLOAT',5,-1,4,4 +'double_col98','DOUBLE',5,-1,8,8 +'string_col98','STRING',5,-1,1,1 +'bool_col99','BOOLEAN',2,-1,1,1 +'tinyint_col99','TINYINT',5,-1,1,1 +'smallint_col99','SMALLINT',5,-1,2,2 +'int_col99','INT',5,-1,4,4 +'bigint_col99','BIGINT',5,-1,8,8 +'float_col99','FLOAT',5,-1,4,4 +'double_col99','DOUBLE',5,-1,8,8 +'string_col99','STRING',5,-1,1,1 +'bool_col100','BOOLEAN',2,-1,1,1 +'tinyint_col100','TINYINT',5,-1,1,1 +'smallint_col100','SMALLINT',5,-1,2,2 +'int_col100','INT',5,-1,4,4 +'bigint_col100','BIGINT',5,-1,8,8 +'float_col100','FLOAT',5,-1,4,4 +'double_col100','DOUBLE',5,-1,8,8 +'string_col100','STRING',5,-1,1,1 +'bool_col101','BOOLEAN',2,-1,1,1 +'tinyint_col101','TINYINT',5,-1,1,1 +'smallint_col101','SMALLINT',5,-1,2,2 +'int_col101','INT',5,-1,4,4 +'bigint_col101','BIGINT',5,-1,8,8 +'float_col101','FLOAT',5,-1,4,4 +'double_col101','DOUBLE',5,-1,8,8 +'string_col101','STRING',5,-1,1,1 +'bool_col102','BOOLEAN',2,-1,1,1 +'tinyint_col102','TINYINT',5,-1,1,1 +'smallint_col102','SMALLINT',5,-1,2,2 +'int_col102','INT',5,-1,4,4 +'bigint_col102','BIGINT',5,-1,8,8 +'float_col102','FLOAT',5,-1,4,4 +'double_col102','DOUBLE',5,-1,8,8 +'string_col102','STRING',5,-1,1,1 +'bool_col103','BOOLEAN',2,-1,1,1 +'tinyint_col103','TINYINT',5,-1,1,1 +'smallint_col103','SMALLINT',5,-1,2,2 +'int_col103','INT',5,-1,4,4 +'bigint_col103','BIGINT',5,-1,8,8 +'float_col103','FLOAT',5,-1,4,4 +'double_col103','DOUBLE',5,-1,8,8 +'string_col103','STRING',5,-1,1,1 +'bool_col104','BOOLEAN',2,-1,1,1 +'tinyint_col104','TINYINT',5,-1,1,1 +'smallint_col104','SMALLINT',5,-1,2,2 +'int_col104','INT',5,-1,4,4 +'bigint_col104','BIGINT',5,-1,8,8 +'float_col104','FLOAT',5,-1,4,4 +'double_col104','DOUBLE',5,-1,8,8 +'string_col104','STRING',5,-1,1,1 +'bool_col105','BOOLEAN',2,-1,1,1 +'tinyint_col105','TINYINT',5,-1,1,1 +'smallint_col105','SMALLINT',5,-1,2,2 +'int_col105','INT',5,-1,4,4 +'bigint_col105','BIGINT',5,-1,8,8 +'float_col105','FLOAT',5,-1,4,4 +'double_col105','DOUBLE',5,-1,8,8 +'string_col105','STRING',5,-1,1,1 +'bool_col106','BOOLEAN',2,-1,1,1 +'tinyint_col106','TINYINT',5,-1,1,1 +'smallint_col106','SMALLINT',5,-1,2,2 +'int_col106','INT',5,-1,4,4 +'bigint_col106','BIGINT',5,-1,8,8 +'float_col106','FLOAT',5,-1,4,4 +'double_col106','DOUBLE',5,-1,8,8 +'string_col106','STRING',5,-1,1,1 +'bool_col107','BOOLEAN',2,-1,1,1 +'tinyint_col107','TINYINT',5,-1,1,1 +'smallint_col107','SMALLINT',5,-1,2,2 +'int_col107','INT',5,-1,4,4 +'bigint_col107','BIGINT',5,-1,8,8 +'float_col107','FLOAT',5,-1,4,4 +'double_col107','DOUBLE',5,-1,8,8 +'string_col107','STRING',5,-1,1,1 +'bool_col108','BOOLEAN',2,-1,1,1 +'tinyint_col108','TINYINT',5,-1,1,1 +'smallint_col108','SMALLINT',5,-1,2,2 +'int_col108','INT',5,-1,4,4 +'bigint_col108','BIGINT',5,-1,8,8 +'float_col108','FLOAT',5,-1,4,4 +'double_col108','DOUBLE',5,-1,8,8 +'string_col108','STRING',5,-1,1,1 +'bool_col109','BOOLEAN',2,-1,1,1 +'tinyint_col109','TINYINT',5,-1,1,1 +'smallint_col109','SMALLINT',5,-1,2,2 +'int_col109','INT',5,-1,4,4 +'bigint_col109','BIGINT',5,-1,8,8 +'float_col109','FLOAT',5,-1,4,4 +'double_col109','DOUBLE',5,-1,8,8 +'string_col109','STRING',5,-1,1,1 +'bool_col110','BOOLEAN',2,-1,1,1 +'tinyint_col110','TINYINT',5,-1,1,1 +'smallint_col110','SMALLINT',5,-1,2,2 +'int_col110','INT',5,-1,4,4 +'bigint_col110','BIGINT',5,-1,8,8 +'float_col110','FLOAT',5,-1,4,4 +'double_col110','DOUBLE',5,-1,8,8 +'string_col110','STRING',5,-1,1,1 +'bool_col111','BOOLEAN',2,-1,1,1 +'tinyint_col111','TINYINT',5,-1,1,1 +'smallint_col111','SMALLINT',5,-1,2,2 +'int_col111','INT',5,-1,4,4 +'bigint_col111','BIGINT',5,-1,8,8 +'float_col111','FLOAT',5,-1,4,4 +'double_col111','DOUBLE',5,-1,8,8 +'string_col111','STRING',5,-1,1,1 +'bool_col112','BOOLEAN',2,-1,1,1 +'tinyint_col112','TINYINT',5,-1,1,1 +'smallint_col112','SMALLINT',5,-1,2,2 +'int_col112','INT',5,-1,4,4 +'bigint_col112','BIGINT',5,-1,8,8 +'float_col112','FLOAT',5,-1,4,4 +'double_col112','DOUBLE',5,-1,8,8 +'string_col112','STRING',5,-1,1,1 +'bool_col113','BOOLEAN',2,-1,1,1 +'tinyint_col113','TINYINT',5,-1,1,1 +'smallint_col113','SMALLINT',5,-1,2,2 +'int_col113','INT',5,-1,4,4 +'bigint_col113','BIGINT',5,-1,8,8 +'float_col113','FLOAT',5,-1,4,4 +'double_col113','DOUBLE',5,-1,8,8 +'string_col113','STRING',5,-1,1,1 +'bool_col114','BOOLEAN',2,-1,1,1 +'tinyint_col114','TINYINT',5,-1,1,1 +'smallint_col114','SMALLINT',5,-1,2,2 +'int_col114','INT',5,-1,4,4 +'bigint_col114','BIGINT',5,-1,8,8 +'float_col114','FLOAT',5,-1,4,4 +'double_col114','DOUBLE',5,-1,8,8 +'string_col114','STRING',5,-1,1,1 +'bool_col115','BOOLEAN',2,-1,1,1 +'tinyint_col115','TINYINT',5,-1,1,1 +'smallint_col115','SMALLINT',5,-1,2,2 +'int_col115','INT',5,-1,4,4 +'bigint_col115','BIGINT',5,-1,8,8 +'float_col115','FLOAT',5,-1,4,4 +'double_col115','DOUBLE',5,-1,8,8 +'string_col115','STRING',5,-1,1,1 +'bool_col116','BOOLEAN',2,-1,1,1 +'tinyint_col116','TINYINT',5,-1,1,1 +'smallint_col116','SMALLINT',5,-1,2,2 +'int_col116','INT',5,-1,4,4 +'bigint_col116','BIGINT',5,-1,8,8 +'float_col116','FLOAT',5,-1,4,4 +'double_col116','DOUBLE',5,-1,8,8 +'string_col116','STRING',5,-1,1,1 +'bool_col117','BOOLEAN',2,-1,1,1 +'tinyint_col117','TINYINT',5,-1,1,1 +'smallint_col117','SMALLINT',5,-1,2,2 +'int_col117','INT',5,-1,4,4 +'bigint_col117','BIGINT',5,-1,8,8 +'float_col117','FLOAT',5,-1,4,4 +'double_col117','DOUBLE',5,-1,8,8 +'string_col117','STRING',5,-1,1,1 +'bool_col118','BOOLEAN',2,-1,1,1 +'tinyint_col118','TINYINT',5,-1,1,1 +'smallint_col118','SMALLINT',5,-1,2,2 +'int_col118','INT',5,-1,4,4 +'bigint_col118','BIGINT',5,-1,8,8 +'float_col118','FLOAT',5,-1,4,4 +'double_col118','DOUBLE',5,-1,8,8 +'string_col118','STRING',5,-1,1,1 +'bool_col119','BOOLEAN',2,-1,1,1 +'tinyint_col119','TINYINT',5,-1,1,1 +'smallint_col119','SMALLINT',5,-1,2,2 +'int_col119','INT',5,-1,4,4 +'bigint_col119','BIGINT',5,-1,8,8 +'float_col119','FLOAT',5,-1,4,4 +'double_col119','DOUBLE',5,-1,8,8 +'string_col119','STRING',5,-1,1,1 +'bool_col120','BOOLEAN',2,-1,1,1 +'tinyint_col120','TINYINT',5,-1,1,1 +'smallint_col120','SMALLINT',5,-1,2,2 +'int_col120','INT',5,-1,4,4 +'bigint_col120','BIGINT',5,-1,8,8 +'float_col120','FLOAT',5,-1,4,4 +'double_col120','DOUBLE',5,-1,8,8 +'string_col120','STRING',5,-1,1,1 +'bool_col121','BOOLEAN',2,-1,1,1 +'tinyint_col121','TINYINT',5,-1,1,1 +'smallint_col121','SMALLINT',5,-1,2,2 +'int_col121','INT',5,-1,4,4 +'bigint_col121','BIGINT',5,-1,8,8 +'float_col121','FLOAT',5,-1,4,4 +'double_col121','DOUBLE',5,-1,8,8 +'string_col121','STRING',5,-1,1,1 +'bool_col122','BOOLEAN',2,-1,1,1 +'tinyint_col122','TINYINT',5,-1,1,1 +'smallint_col122','SMALLINT',5,-1,2,2 +'int_col122','INT',5,-1,4,4 +'bigint_col122','BIGINT',5,-1,8,8 +'float_col122','FLOAT',5,-1,4,4 +'double_col122','DOUBLE',5,-1,8,8 +'string_col122','STRING',5,-1,1,1 +'bool_col123','BOOLEAN',2,-1,1,1 +'tinyint_col123','TINYINT',5,-1,1,1 +'smallint_col123','SMALLINT',5,-1,2,2 +'int_col123','INT',5,-1,4,4 +'bigint_col123','BIGINT',5,-1,8,8 +'float_col123','FLOAT',5,-1,4,4 +'double_col123','DOUBLE',5,-1,8,8 +'string_col123','STRING',5,-1,1,1 +'bool_col124','BOOLEAN',2,-1,1,1 +'tinyint_col124','TINYINT',5,-1,1,1 +'smallint_col124','SMALLINT',5,-1,2,2 +'int_col124','INT',5,-1,4,4 +'bigint_col124','BIGINT',5,-1,8,8 +'float_col124','FLOAT',5,-1,4,4 +'double_col124','DOUBLE',5,-1,8,8 +'string_col124','STRING',5,-1,1,1 +'bool_col125','BOOLEAN',2,-1,1,1 +'tinyint_col125','TINYINT',5,-1,1,1 +'smallint_col125','SMALLINT',5,-1,2,2 +'int_col125','INT',5,-1,4,4 +'bigint_col125','BIGINT',5,-1,8,8 +'float_col125','FLOAT',5,-1,4,4 +'double_col125','DOUBLE',5,-1,8,8 +'string_col125','STRING',5,-1,1,1 +---- TYPES +STRING, STRING, BIGINT, BIGINT, INT, DOUBLE +====
http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/4db330e6/tests/query_test/test_aggregation.py ---------------------------------------------------------------------- diff --git a/tests/query_test/test_aggregation.py b/tests/query_test/test_aggregation.py index c44c784..38900e6 100644 --- a/tests/query_test/test_aggregation.py +++ b/tests/query_test/test_aggregation.py @@ -19,13 +19,19 @@ # import pytest +from testdata.common import widetable from tests.common.environ import USING_OLD_AGGS_JOINS from tests.common.impala_test_suite import ImpalaTestSuite from tests.common.skip import SkipIfOldAggsJoins from tests.common.test_dimensions import ( create_exec_option_dimension, create_uncompressed_text_dimension) -from tests.common.test_result_verifier import assert_codegen_enabled +from tests.common.test_result_verifier import ( + assert_codegen_enabled, + parse_column_types, + parse_column_labels, + QueryTestResult, + parse_result_rows) from tests.common.test_vector import TestDimension # Test dimensions for TestAggregation. @@ -128,8 +134,9 @@ class TestAggregation(ImpalaTestSuite): self.verify_agg_result(agg_func, data_type, False, result.data[0]); if check_codegen_enabled: - # Verify codegen was enabled for both stages of the aggregation. - assert_codegen_enabled(result.runtime_profile, [1, 3]) + # Verify codegen was enabled for the preaggregation. + # It is deliberately disabled for the merge aggregation. + assert_codegen_enabled(result.runtime_profile, [1]) query = 'select %s(DISTINCT(%s_col)) from alltypesagg where day is not null' % ( agg_func, data_type) @@ -207,7 +214,7 @@ class TestAggregationQueries(ImpalaTestSuite): Required to run directly in python because the order in which results will be merged at the final, single-node aggregation step is non-deterministic (if the first phase is running on multiple nodes). Need to pull the result apart and - compare the actual items)""" + compare the actual items)""" exec_option = vector.get_value('exec_option') disable_codegen = exec_option['disable_codegen'] table_format = vector.get_value('table_format') @@ -263,6 +270,42 @@ class TestAggregationQueries(ImpalaTestSuite): # Verify codegen was enabled for all four stages of the aggregation. assert_codegen_enabled(result.runtime_profile, [1, 2, 4, 6]) +class TestWideAggregationQueries(ImpalaTestSuite): + """Test that aggregations with many grouping columns work""" + @classmethod + def get_workload(self): + return 'functional-query' + + @classmethod + def add_test_dimensions(cls): + super(TestWideAggregationQueries, cls).add_test_dimensions() + + cls.TestMatrix.add_dimension( + create_exec_option_dimension(disable_codegen_options=[False, True])) + + # File format doesn't matter for this test. + cls.TestMatrix.add_constraint( + lambda v: v.get_value('table_format').file_format == 'parquet') + + def test_many_grouping_columns(self, vector): + """Test that an aggregate with many grouping columns works""" + table_format = vector.get_value('table_format') + exec_option = vector.get_value('exec_option') + query = "select distinct * from widetable_1000_cols" + + # Ensure codegen is enabled. + result = self.execute_query(query, exec_option, table_format=table_format) + + # All rows should be distinct. + expected_result = widetable.get_data(1000, 10, quote_strings=True) + + types = parse_column_types(result.schema) + labels = parse_column_labels(result.schema) + expected = QueryTestResult(expected_result, types, labels, order_matters=False) + actual = QueryTestResult(parse_result_rows(result), types, labels, + order_matters=False) + assert expected == actual + class TestTPCHAggregationQueries(ImpalaTestSuite): # Uses the TPC-H dataset in order to have larger aggregations.
