You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@impala.apache.org by jo...@apache.org on 2018/12/10 23:43:59 UTC

[2/8] impala git commit: IMPALA-7659: Populate NULL count while computing column stats

http://git-wip-us.apache.org/repos/asf/impala/blob/04d027df/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 8db8377..9b17cd3 100644
--- a/testdata/workloads/functional-query/queries/QueryTest/compute-stats.test
+++ b/testdata/workloads/functional-query/queries/QueryTest/compute-stats.test
@@ -50,17 +50,17 @@ show column stats alltypes
 ---- LABELS
 COLUMN, TYPE, #DISTINCT VALUES, #NULLS, MAX SIZE, AVG SIZE
 ---- RESULTS
-'id','INT',7300,-1,4,4
-'bool_col','BOOLEAN',2,-1,1,1
-'tinyint_col','TINYINT',10,-1,1,1
-'smallint_col','SMALLINT',10,-1,2,2
-'int_col','INT',10,-1,4,4
-'bigint_col','BIGINT',10,-1,8,8
-'float_col','FLOAT',10,-1,4,4
-'double_col','DOUBLE',10,-1,8,8
-'date_string_col','STRING',736,-1,8,8
-'string_col','STRING',10,-1,1,1
-'timestamp_col','TIMESTAMP',7300,-1,16,16
+'id','INT',7300,0,4,4
+'bool_col','BOOLEAN',2,0,1,1
+'tinyint_col','TINYINT',10,0,1,1
+'smallint_col','SMALLINT',10,0,2,2
+'int_col','INT',10,0,4,4
+'bigint_col','BIGINT',10,0,8,8
+'float_col','FLOAT',10,0,4,4
+'double_col','DOUBLE',10,0,8,8
+'date_string_col','STRING',736,0,8,8
+'string_col','STRING',10,0,1,1
+'timestamp_col','TIMESTAMP',7300,0,16,16
 'year','INT',2,0,4,4
 'month','INT',12,0,4,4
 ---- TYPES
@@ -77,20 +77,20 @@ show column stats alltypes
 ---- LABELS
 COLUMN, TYPE, #DISTINCT VALUES, #NULLS, MAX SIZE, AVG SIZE
 ---- RESULTS
-'id','INT',7300,-1,4,4
-'bool_col','BOOLEAN',2,-1,1,1
-'tinyint_col','TINYINT',10,-1,1,1
-'smallint_col','SMALLINT',10,-1,2,2
-'int_col','INT',10,-1,4,4
-'bigint_col','BIGINT',10,-1,8,8
-'float_col','FLOAT',10,-1,4,4
-'double_col','DOUBLE',10,-1,8,8
-'date_string_col','STRING',736,-1,8,8
-'string_col','STRING',10,-1,1,1
-'timestamp_col','TIMESTAMP',7300,-1,16,16
+'id','INT',7300,0,4,4
+'bool_col','BOOLEAN',2,0,1,1
+'tinyint_col','TINYINT',10,0,1,1
+'smallint_col','SMALLINT',10,0,2,2
+'int_col','INT',10,0,4,4
+'bigint_col','BIGINT',10,0,8,8
+'float_col','FLOAT',10,0,4,4
+'double_col','DOUBLE',10,0,8,8
+'date_string_col','STRING',736,0,8,8
+'string_col','STRING',10,0,1,1
+'timestamp_col','TIMESTAMP',7300,0,16,16
+'new_col','INT',-1,-1,4,4
 'year','INT',2,0,4,4
 'month','INT',12,0,4,4
-'new_col','INT',-1,-1,4,4
 ---- TYPES
 STRING, STRING, BIGINT, BIGINT, BIGINT, DOUBLE
 ====
@@ -107,20 +107,20 @@ show column stats alltypes
 ---- LABELS
 COLUMN, TYPE, #DISTINCT VALUES, #NULLS, MAX SIZE, AVG SIZE
 ---- RESULTS
-'id','INT',7300,-1,4,4
-'bool_col','BOOLEAN',2,-1,1,1
-'tinyint_col','TINYINT',10,-1,1,1
-'smallint_col','SMALLINT',10,-1,2,2
-'int_col','INT',10,-1,4,4
-'bigint_col','BIGINT',10,-1,8,8
-'float_col','FLOAT',10,-1,4,4
-'double_col','DOUBLE',10,-1,8,8
-'date_string_col','STRING',736,-1,8,8
-'string_col','STRING',10,-1,1,1
-'timestamp_col','TIMESTAMP',7300,-1,16,16
+'id','INT',7300,0,4,4
+'bool_col','BOOLEAN',2,0,1,1
+'tinyint_col','TINYINT',10,0,1,1
+'smallint_col','SMALLINT',10,0,2,2
+'int_col','INT',10,0,4,4
+'bigint_col','BIGINT',10,0,8,8
+'float_col','FLOAT',10,0,4,4
+'double_col','DOUBLE',10,0,8,8
+'date_string_col','STRING',736,0,8,8
+'string_col','STRING',10,0,1,1
+'timestamp_col','TIMESTAMP',7300,0,16,16
+'new_col2','INT',-1,-1,4,4
 'year','INT',2,0,4,4
 'month','INT',12,0,4,4
-'new_col2','INT',-1,-1,4,4
 ---- TYPES
 STRING, STRING, BIGINT, BIGINT, BIGINT, DOUBLE
 ====
@@ -135,17 +135,17 @@ show column stats alltypes
 ---- LABELS
 COLUMN, TYPE, #DISTINCT VALUES, #NULLS, MAX SIZE, AVG SIZE
 ---- RESULTS
-'id','INT',7300,-1,4,4
-'bool_col','BOOLEAN',2,-1,1,1
-'tinyint_col','TINYINT',10,-1,1,1
-'smallint_col','SMALLINT',10,-1,2,2
-'int_col','INT',10,-1,4,4
-'bigint_col','BIGINT',10,-1,8,8
-'float_col','FLOAT',10,-1,4,4
-'double_col','DOUBLE',10,-1,8,8
-'date_string_col','STRING',736,-1,8,8
-'string_col','STRING',10,-1,1,1
-'timestamp_col','TIMESTAMP',7300,-1,16,16
+'id','INT',7300,0,4,4
+'bool_col','BOOLEAN',2,0,1,1
+'tinyint_col','TINYINT',10,0,1,1
+'smallint_col','SMALLINT',10,0,2,2
+'int_col','INT',10,0,4,4
+'bigint_col','BIGINT',10,0,8,8
+'float_col','FLOAT',10,0,4,4
+'double_col','DOUBLE',10,0,8,8
+'date_string_col','STRING',736,0,8,8
+'string_col','STRING',10,0,1,1
+'timestamp_col','TIMESTAMP',7300,0,16,16
 'year','INT',2,0,4,4
 'month','INT',12,0,4,4
 ---- TYPES
@@ -263,11 +263,11 @@ COLUMN, TYPE, #DISTINCT VALUES, #NULLS, MAX SIZE, AVG SIZE
 ---- RESULTS
 'id','INT',-1,-1,4,4
 'bool_col','BOOLEAN',-1,-1,1,1
-'tinyint_col','TINYINT',10,-1,1,1
+'tinyint_col','TINYINT',10,0,1,1
 'smallint_col','SMALLINT',-1,-1,2,2
 'int_col','INT',-1,-1,4,4
 'bigint_col','BIGINT',-1,-1,8,8
-'float_col','FLOAT',10,-1,4,4
+'float_col','FLOAT',10,0,4,4
 'double_col','DOUBLE',-1,-1,8,8
 'date_string_col','STRING',-1,-1,-1,-1
 'string_col','STRING',-1,-1,-1,-1
@@ -483,17 +483,17 @@ show column stats alltypesnopart
 ---- LABELS
 COLUMN, TYPE, #DISTINCT VALUES, #NULLS, MAX SIZE, AVG SIZE
 ---- RESULTS
-'id','INT',99,-1,4,4
-'bool_col','BOOLEAN',2,-1,1,1
-'tinyint_col','TINYINT',10,-1,1,1
-'smallint_col','SMALLINT',10,-1,2,2
-'int_col','INT',10,-1,4,4
-'bigint_col','BIGINT',10,-1,8,8
-'float_col','FLOAT',10,-1,4,4
-'double_col','DOUBLE',10,-1,8,8
-'date_string_col','STRING',12,-1,8,8
-'string_col','STRING',10,-1,1,1
-'timestamp_col','TIMESTAMP',100,-1,16,16
+'id','INT',99,0,4,4
+'bool_col','BOOLEAN',2,0,1,1
+'tinyint_col','TINYINT',10,0,1,1
+'smallint_col','SMALLINT',10,0,2,2
+'int_col','INT',10,0,4,4
+'bigint_col','BIGINT',10,0,8,8
+'float_col','FLOAT',10,0,4,4
+'double_col','DOUBLE',10,0,8,8
+'date_string_col','STRING',12,0,8,8
+'string_col','STRING',10,0,1,1
+'timestamp_col','TIMESTAMP',100,0,16,16
 ---- TYPES
 STRING, STRING, BIGINT, BIGINT, BIGINT, DOUBLE
 ====
@@ -562,17 +562,17 @@ show column stats alltypes_parquet
 ---- LABELS
 COLUMN, TYPE, #DISTINCT VALUES, #NULLS, MAX SIZE, AVG SIZE
 ---- RESULTS
-'id','INT',7300,-1,4,4
-'bool_col','BOOLEAN',2,-1,1,1
-'tinyint_col','TINYINT',10,-1,1,1
-'smallint_col','SMALLINT',10,-1,2,2
-'int_col','INT',10,-1,4,4
-'bigint_col','BIGINT',10,-1,8,8
-'float_col','FLOAT',10,-1,4,4
-'double_col','DOUBLE',10,-1,8,8
-'date_string_col','STRING',736,-1,8,8
-'string_col','STRING',10,-1,1,1
-'timestamp_col','TIMESTAMP',7300,-1,16,16
+'id','INT',7300,0,4,4
+'bool_col','BOOLEAN',2,0,1,1
+'tinyint_col','TINYINT',10,0,1,1
+'smallint_col','SMALLINT',10,0,2,2
+'int_col','INT',10,0,4,4
+'bigint_col','BIGINT',10,0,8,8
+'float_col','FLOAT',10,0,4,4
+'double_col','DOUBLE',10,0,8,8
+'date_string_col','STRING',736,0,8,8
+'string_col','STRING',10,0,1,1
+'timestamp_col','TIMESTAMP',7300,0,16,16
 'year','INT',2,0,4,4
 'month','INT',12,0,4,4
 ---- TYPES
@@ -640,17 +640,17 @@ show column stats alltypes_empty
 ---- LABELS
 COLUMN, TYPE, #DISTINCT VALUES, #NULLS, MAX SIZE, AVG SIZE
 ---- RESULTS
-'id','INT',0,-1,4,4
-'bool_col','BOOLEAN',2,-1,1,1
-'tinyint_col','TINYINT',0,-1,1,1
-'smallint_col','SMALLINT',0,-1,2,2
-'int_col','INT',0,-1,4,4
-'bigint_col','BIGINT',0,-1,8,8
-'float_col','FLOAT',0,-1,4,4
-'double_col','DOUBLE',0,-1,8,8
-'date_string_col','STRING',0,-1,0,0
-'string_col','STRING',0,-1,0,0
-'timestamp_col','TIMESTAMP',0,-1,16,16
+'id','INT',0,0,4,4
+'bool_col','BOOLEAN',2,0,1,1
+'tinyint_col','TINYINT',0,0,1,1
+'smallint_col','SMALLINT',0,0,2,2
+'int_col','INT',0,0,4,4
+'bigint_col','BIGINT',0,0,8,8
+'float_col','FLOAT',0,0,4,4
+'double_col','DOUBLE',0,0,8,8
+'date_string_col','STRING',0,0,0,0
+'string_col','STRING',0,0,0,0
+'timestamp_col','TIMESTAMP',0,0,16,16
 'year','INT',0,0,4,4
 'month','INT',0,0,4,4
 ---- TYPES
@@ -693,17 +693,17 @@ show column stats avro_hive_alltypes
 ---- LABELS
 COLUMN, TYPE, #DISTINCT VALUES, #NULLS, MAX SIZE, AVG SIZE
 ---- RESULTS
-'id','INT',0,-1,4,4
-'bool_col','BOOLEAN',2,-1,1,1
-'tinyint_col','INT',0,-1,4,4
-'smallint_col','INT',0,-1,4,4
-'int_col','INT',0,-1,4,4
-'bigint_col','BIGINT',0,-1,8,8
-'float_col','FLOAT',0,-1,4,4
-'double_col','DOUBLE',0,-1,8,8
-'date_string_col','STRING',0,-1,0,0
-'string_col','STRING',0,-1,0,0
-'timestamp_col','STRING',0,-1,0,0
+'id','INT',0,0,4,4
+'bool_col','BOOLEAN',2,0,1,1
+'tinyint_col','INT',0,0,4,4
+'smallint_col','INT',0,0,4,4
+'int_col','INT',0,0,4,4
+'bigint_col','BIGINT',0,0,8,8
+'float_col','FLOAT',0,0,4,4
+'double_col','DOUBLE',0,0,8,8
+'date_string_col','STRING',0,0,0,0
+'string_col','STRING',0,0,0,0
+'timestamp_col','STRING',0,0,0,0
 'year','INT',0,0,4,4
 'month','INT',0,0,4,4
 ---- TYPES
@@ -731,18 +731,18 @@ show column stats avro_hive_alltypes_extra_coldef
 ---- LABELS
 COLUMN, TYPE, #DISTINCT VALUES, #NULLS, MAX SIZE, AVG SIZE
 ---- RESULTS
-'id','INT',0,-1,4,4
-'bool_col','BOOLEAN',2,-1,1,1
-'tinyint_col','TINYINT',0,-1,1,1
-'smallint_col','SMALLINT',0,-1,2,2
-'int_col','INT',0,-1,4,4
-'bigint_col','BIGINT',0,-1,8,8
-'float_col','FLOAT',0,-1,4,4
-'double_col','DOUBLE',0,-1,8,8
-'date_string_col','STRING',0,-1,0,0
-'string_col','STRING',0,-1,0,0
-'timestamp_col','TIMESTAMP',0,-1,16,16
-'extra_col','STRING',0,-1,0,0
+'id','INT',0,0,4,4
+'bool_col','BOOLEAN',2,0,1,1
+'tinyint_col','TINYINT',0,0,1,1
+'smallint_col','SMALLINT',0,0,2,2
+'int_col','INT',0,0,4,4
+'bigint_col','BIGINT',0,0,8,8
+'float_col','FLOAT',0,0,4,4
+'double_col','DOUBLE',0,0,8,8
+'date_string_col','STRING',0,0,0,0
+'string_col','STRING',0,0,0,0
+'timestamp_col','TIMESTAMP',0,0,16,16
+'extra_col','STRING',0,0,0,0
 'year','INT',0,0,4,4
 'month','INT',0,0,4,4
 ---- TYPES
@@ -770,15 +770,15 @@ show column stats avro_hive_alltypes_missing_coldef
 ---- LABELS
 COLUMN, TYPE, #DISTINCT VALUES, #NULLS, MAX SIZE, AVG SIZE
 ---- RESULTS
-'id','INT',0,-1,4,4
-'bool_col','BOOLEAN',2,-1,1,1
-'smallint_col','SMALLINT',0,-1,2,2
-'int_col','INT',0,-1,4,4
-'bigint_col','BIGINT',0,-1,8,8
-'float_col','FLOAT',0,-1,4,4
-'double_col','DOUBLE',0,-1,8,8
-'date_string_col','STRING',0,-1,0,0
-'string_col','STRING',0,-1,0,0
+'id','INT',0,0,4,4
+'bool_col','BOOLEAN',2,0,1,1
+'smallint_col','SMALLINT',0,0,2,2
+'int_col','INT',0,0,4,4
+'bigint_col','BIGINT',0,0,8,8
+'float_col','FLOAT',0,0,4,4
+'double_col','DOUBLE',0,0,8,8
+'date_string_col','STRING',0,0,0,0
+'string_col','STRING',0,0,0,0
 'year','INT',0,0,4,4
 'month','INT',0,0,4,4
 ---- TYPES
@@ -807,17 +807,17 @@ show column stats avro_hive_alltypes_type_mismatch
 ---- LABELS
 COLUMN, TYPE, #DISTINCT VALUES, #NULLS, MAX SIZE, AVG SIZE
 ---- RESULTS
-'id','INT',0,-1,4,4
-'bool_col','BOOLEAN',2,-1,1,1
-'tinyint_col','TINYINT',0,-1,1,1
-'smallint_col','SMALLINT',0,-1,2,2
-'int_col','INT',0,-1,4,4
-'bigint_col','STRING',0,-1,0,0
-'float_col','FLOAT',0,-1,4,4
-'double_col','DOUBLE',0,-1,8,8
-'date_string_col','STRING',0,-1,0,0
-'string_col','STRING',0,-1,0,0
-'timestamp_col','TIMESTAMP',0,-1,16,16
+'id','INT',0,0,4,4
+'bool_col','BOOLEAN',2,0,1,1
+'tinyint_col','TINYINT',0,0,1,1
+'smallint_col','SMALLINT',0,0,2,2
+'int_col','INT',0,0,4,4
+'bigint_col','STRING',0,0,0,0
+'float_col','FLOAT',0,0,4,4
+'double_col','DOUBLE',0,0,8,8
+'date_string_col','STRING',0,0,0,0
+'string_col','STRING',0,0,0,0
+'timestamp_col','TIMESTAMP',0,0,16,16
 'year','INT',0,0,4,4
 'month','INT',0,0,4,4
 ---- TYPES
@@ -846,17 +846,17 @@ show column stats avro_hive_no_avro_schema
 ---- LABELS
 COLUMN, TYPE, #DISTINCT VALUES, #NULLS, MAX SIZE, AVG SIZE
 ---- RESULTS
-'id','INT',0,-1,4,4
-'bool_col','BOOLEAN',2,-1,1,1
-'tinyint_col','INT',0,-1,4,4
-'smallint_col','INT',0,-1,4,4
-'int_col','INT',0,-1,4,4
-'bigint_col','BIGINT',0,-1,8,8
-'float_col','FLOAT',0,-1,4,4
-'double_col','DOUBLE',0,-1,8,8
-'date_string_col','STRING',0,-1,0,0
-'string_col','STRING',0,-1,0,0
-'timestamp_col','STRING',0,-1,0,0
+'id','INT',0,0,4,4
+'bool_col','BOOLEAN',2,0,1,1
+'tinyint_col','INT',0,0,4,4
+'smallint_col','INT',0,0,4,4
+'int_col','INT',0,0,4,4
+'bigint_col','BIGINT',0,0,8,8
+'float_col','FLOAT',0,0,4,4
+'double_col','DOUBLE',0,0,8,8
+'date_string_col','STRING',0,0,0,0
+'string_col','STRING',0,0,0,0
+'timestamp_col','STRING',0,0,0,0
 'year','INT',0,0,4,4
 'month','INT',0,0,4,4
 ---- TYPES
@@ -891,17 +891,17 @@ show column stats avro_impala_alltypes_no_coldefs
 ---- LABELS
 COLUMN, TYPE, #DISTINCT VALUES, #NULLS, MAX SIZE, AVG SIZE
 ---- RESULTS
-'id','INT',0,-1,4,4
-'bool_col','BOOLEAN',2,-1,1,1
-'tinyint_col','INT',0,-1,4,4
-'smallint_col','INT',0,-1,4,4
-'int_col','INT',0,-1,4,4
-'bigint_col','BIGINT',0,-1,8,8
-'float_col','FLOAT',0,-1,4,4
-'double_col','DOUBLE',0,-1,8,8
-'date_string_col','STRING',0,-1,0,0
-'string_col','STRING',0,-1,0,0
-'timestamp_col','STRING',0,-1,0,0
+'id','INT',0,0,4,4
+'bool_col','BOOLEAN',2,0,1,1
+'tinyint_col','INT',0,0,4,4
+'smallint_col','INT',0,0,4,4
+'int_col','INT',0,0,4,4
+'bigint_col','BIGINT',0,0,8,8
+'float_col','FLOAT',0,0,4,4
+'double_col','DOUBLE',0,0,8,8
+'date_string_col','STRING',0,0,0,0
+'string_col','STRING',0,0,0,0
+'timestamp_col','STRING',0,0,0,0
 'year','INT',0,0,4,4
 'month','INT',0,0,4,4
 ---- TYPES
@@ -940,17 +940,17 @@ show column stats avro_impala_alltypes_bad_colname
 ---- LABELS
 COLUMN, TYPE, #DISTINCT VALUES, #NULLS, MAX SIZE, AVG SIZE
 ---- RESULTS
-'id','INT',0,-1,4,4
-'bool_col','BOOLEAN',2,-1,1,1
-'tinyint_col','INT',0,-1,4,4
-'smallint_col','INT',0,-1,4,4
-'int_col','INT',0,-1,4,4
-'bigint_col','BIGINT',0,-1,8,8
-'float_col','FLOAT',0,-1,4,4
-'double_col','DOUBLE',0,-1,8,8
-'date_string_col','STRING',0,-1,0,0
-'string_col','STRING',0,-1,0,0
-'timestamp_col','STRING',0,-1,0,0
+'id','INT',0,0,4,4
+'bool_col','BOOLEAN',2,0,1,1
+'tinyint_col','INT',0,0,4,4
+'smallint_col','INT',0,0,4,4
+'int_col','INT',0,0,4,4
+'bigint_col','BIGINT',0,0,8,8
+'float_col','FLOAT',0,0,4,4
+'double_col','DOUBLE',0,0,8,8
+'date_string_col','STRING',0,0,0,0
+'string_col','STRING',0,0,0,0
+'timestamp_col','STRING',0,0,0,0
 'year','INT',0,0,4,4
 'month','INT',0,0,4,4
 ---- TYPES
@@ -989,17 +989,17 @@ show column stats avro_impala_alltypes_bad_coltype
 ---- LABELS
 COLUMN, TYPE, #DISTINCT VALUES, #NULLS, MAX SIZE, AVG SIZE
 ---- RESULTS
-'id','INT',0,-1,4,4
-'bool_col','BOOLEAN',2,-1,1,1
-'tinyint_col','INT',0,-1,4,4
-'smallint_col','INT',0,-1,4,4
-'int_col','INT',0,-1,4,4
-'bigint_col','BIGINT',0,-1,8,8
-'float_col','FLOAT',0,-1,4,4
-'double_col','DOUBLE',0,-1,8,8
-'date_string_col','STRING',0,-1,0,0
-'string_col','STRING',0,-1,0,0
-'timestamp_col','STRING',0,-1,0,0
+'id','INT',0,0,4,4
+'bool_col','BOOLEAN',2,0,1,1
+'tinyint_col','INT',0,0,4,4
+'smallint_col','INT',0,0,4,4
+'int_col','INT',0,0,4,4
+'bigint_col','BIGINT',0,0,8,8
+'float_col','FLOAT',0,0,4,4
+'double_col','DOUBLE',0,0,8,8
+'date_string_col','STRING',0,0,0,0
+'string_col','STRING',0,0,0,0
+'timestamp_col','STRING',0,0,0,0
 'year','INT',0,0,4,4
 'month','INT',0,0,4,4
 ---- TYPES
@@ -1089,7 +1089,6 @@ show table stats `123_table`
 ---- TYPES
 STRING, BIGINT, BIGINT, STRING, STRING, STRING, STRING, STRING, STRING
 ====
-====
 ---- QUERY
 # IMPALA-1629: Verify that the column stats for CHAR/VARCHAR columns are populated.
 # The values of date_string_col always have exactly 8 characters. The CHAR/VARCHAR
@@ -1141,14 +1140,14 @@ show column stats chars_tbl
 ---- LABELS
 COLUMN, TYPE, #DISTINCT VALUES, #NULLS, MAX SIZE, AVG SIZE
 ---- RESULTS
-'id','INT',2915,-1,4,4
-'ch1','CHAR(1)',1,-1,1,1
-'ch2','CHAR(8)',10,-1,8,8
-'ch3','CHAR(20)',10,-1,8,8
-'ts','TIMESTAMP',2871,-1,16,16
-'vc1','VARCHAR(1)',1,-1,1,1
-'vc2','VARCHAR(8)',10,-1,8,8
-'vc3','VARCHAR(20)',10,-1,8,8
+'id','INT',2915,0,4,4
+'ch1','CHAR(1)',1,0,1,1
+'ch2','CHAR(8)',10,0,8,8
+'ch3','CHAR(20)',10,0,8,8
+'ts','TIMESTAMP',2871,0,16,16
+'vc1','VARCHAR(1)',1,0,1,1
+'vc2','VARCHAR(8)',10,0,8,8
+'vc3','VARCHAR(20)',10,0,8,8
 'year','CHAR(5)',1,0,5,5
 'day','VARCHAR(13)',3,1,-1,-1
 ---- TYPES
@@ -1167,17 +1166,17 @@ STRING
 ---- QUERY
 show column stats alltypes_no_coldef
 ---- RESULTS
-'id','INT',0,-1,4,4
-'bool_col','BOOLEAN',2,-1,1,1
-'tinyint_col','INT',0,-1,4,4
-'smallint_col','INT',0,-1,4,4
-'int_col','INT',0,-1,4,4
-'bigint_col','BIGINT',0,-1,8,8
-'float_col','FLOAT',0,-1,4,4
-'double_col','DOUBLE',0,-1,8,8
-'date_string_col','STRING',0,-1,0,0
-'string_col','STRING',0,-1,0,0
-'timestamp_col','STRING',0,-1,0,0
+'id','INT',0,0,4,4
+'bool_col','BOOLEAN',2,0,1,1
+'tinyint_col','INT',0,0,4,4
+'smallint_col','INT',0,0,4,4
+'int_col','INT',0,0,4,4
+'bigint_col','BIGINT',0,0,8,8
+'float_col','FLOAT',0,0,4,4
+'double_col','DOUBLE',0,0,8,8
+'date_string_col','STRING',0,0,0,0
+'string_col','STRING',0,0,0,0
+'timestamp_col','STRING',0,0,0,0
 ---- TYPES
 STRING, STRING, BIGINT, BIGINT, BIGINT, DOUBLE
 ====
@@ -1194,1006 +1193,1006 @@ 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
+'bool_col1','BOOLEAN',2,0,1,1
+'tinyint_col1','TINYINT',5,0,1,1
+'smallint_col1','SMALLINT',5,0,2,2
+'int_col1','INT',5,0,4,4
+'bigint_col1','BIGINT',5,0,8,8
+'float_col1','FLOAT',5,0,4,4
+'double_col1','DOUBLE',5,0,8,8
+'string_col1','STRING',5,0,1,1
+'bool_col2','BOOLEAN',2,0,1,1
+'tinyint_col2','TINYINT',5,0,1,1
+'smallint_col2','SMALLINT',5,0,2,2
+'int_col2','INT',5,0,4,4
+'bigint_col2','BIGINT',5,0,8,8
+'float_col2','FLOAT',5,0,4,4
+'double_col2','DOUBLE',5,0,8,8
+'string_col2','STRING',5,0,1,1
+'bool_col3','BOOLEAN',2,0,1,1
+'tinyint_col3','TINYINT',5,0,1,1
+'smallint_col3','SMALLINT',5,0,2,2
+'int_col3','INT',5,0,4,4
+'bigint_col3','BIGINT',5,0,8,8
+'float_col3','FLOAT',5,0,4,4
+'double_col3','DOUBLE',5,0,8,8
+'string_col3','STRING',5,0,1,1
+'bool_col4','BOOLEAN',2,0,1,1
+'tinyint_col4','TINYINT',5,0,1,1
+'smallint_col4','SMALLINT',5,0,2,2
+'int_col4','INT',5,0,4,4
+'bigint_col4','BIGINT',5,0,8,8
+'float_col4','FLOAT',5,0,4,4
+'double_col4','DOUBLE',5,0,8,8
+'string_col4','STRING',5,0,1,1
+'bool_col5','BOOLEAN',2,0,1,1
+'tinyint_col5','TINYINT',5,0,1,1
+'smallint_col5','SMALLINT',5,0,2,2
+'int_col5','INT',5,0,4,4
+'bigint_col5','BIGINT',5,0,8,8
+'float_col5','FLOAT',5,0,4,4
+'double_col5','DOUBLE',5,0,8,8
+'string_col5','STRING',5,0,1,1
+'bool_col6','BOOLEAN',2,0,1,1
+'tinyint_col6','TINYINT',5,0,1,1
+'smallint_col6','SMALLINT',5,0,2,2
+'int_col6','INT',5,0,4,4
+'bigint_col6','BIGINT',5,0,8,8
+'float_col6','FLOAT',5,0,4,4
+'double_col6','DOUBLE',5,0,8,8
+'string_col6','STRING',5,0,1,1
+'bool_col7','BOOLEAN',2,0,1,1
+'tinyint_col7','TINYINT',5,0,1,1
+'smallint_col7','SMALLINT',5,0,2,2
+'int_col7','INT',5,0,4,4
+'bigint_col7','BIGINT',5,0,8,8
+'float_col7','FLOAT',5,0,4,4
+'double_col7','DOUBLE',5,0,8,8
+'string_col7','STRING',5,0,1,1
+'bool_col8','BOOLEAN',2,0,1,1
+'tinyint_col8','TINYINT',5,0,1,1
+'smallint_col8','SMALLINT',5,0,2,2
+'int_col8','INT',5,0,4,4
+'bigint_col8','BIGINT',5,0,8,8
+'float_col8','FLOAT',5,0,4,4
+'double_col8','DOUBLE',5,0,8,8
+'string_col8','STRING',5,0,1,1
+'bool_col9','BOOLEAN',2,0,1,1
+'tinyint_col9','TINYINT',5,0,1,1
+'smallint_col9','SMALLINT',5,0,2,2
+'int_col9','INT',5,0,4,4
+'bigint_col9','BIGINT',5,0,8,8
+'float_col9','FLOAT',5,0,4,4
+'double_col9','DOUBLE',5,0,8,8
+'string_col9','STRING',5,0,1,1
+'bool_col10','BOOLEAN',2,0,1,1
+'tinyint_col10','TINYINT',5,0,1,1
+'smallint_col10','SMALLINT',5,0,2,2
+'int_col10','INT',5,0,4,4
+'bigint_col10','BIGINT',5,0,8,8
+'float_col10','FLOAT',5,0,4,4
+'double_col10','DOUBLE',5,0,8,8
+'string_col10','STRING',5,0,1,1
+'bool_col11','BOOLEAN',2,0,1,1
+'tinyint_col11','TINYINT',5,0,1,1
+'smallint_col11','SMALLINT',5,0,2,2
+'int_col11','INT',5,0,4,4
+'bigint_col11','BIGINT',5,0,8,8
+'float_col11','FLOAT',5,0,4,4
+'double_col11','DOUBLE',5,0,8,8
+'string_col11','STRING',5,0,1,1
+'bool_col12','BOOLEAN',2,0,1,1
+'tinyint_col12','TINYINT',5,0,1,1
+'smallint_col12','SMALLINT',5,0,2,2
+'int_col12','INT',5,0,4,4
+'bigint_col12','BIGINT',5,0,8,8
+'float_col12','FLOAT',5,0,4,4
+'double_col12','DOUBLE',5,0,8,8
+'string_col12','STRING',5,0,1,1
+'bool_col13','BOOLEAN',2,0,1,1
+'tinyint_col13','TINYINT',5,0,1,1
+'smallint_col13','SMALLINT',5,0,2,2
+'int_col13','INT',5,0,4,4
+'bigint_col13','BIGINT',5,0,8,8
+'float_col13','FLOAT',5,0,4,4
+'double_col13','DOUBLE',5,0,8,8
+'string_col13','STRING',5,0,1,1
+'bool_col14','BOOLEAN',2,0,1,1
+'tinyint_col14','TINYINT',5,0,1,1
+'smallint_col14','SMALLINT',5,0,2,2
+'int_col14','INT',5,0,4,4
+'bigint_col14','BIGINT',5,0,8,8
+'float_col14','FLOAT',5,0,4,4
+'double_col14','DOUBLE',5,0,8,8
+'string_col14','STRING',5,0,1,1
+'bool_col15','BOOLEAN',2,0,1,1
+'tinyint_col15','TINYINT',5,0,1,1
+'smallint_col15','SMALLINT',5,0,2,2
+'int_col15','INT',5,0,4,4
+'bigint_col15','BIGINT',5,0,8,8
+'float_col15','FLOAT',5,0,4,4
+'double_col15','DOUBLE',5,0,8,8
+'string_col15','STRING',5,0,1,1
+'bool_col16','BOOLEAN',2,0,1,1
+'tinyint_col16','TINYINT',5,0,1,1
+'smallint_col16','SMALLINT',5,0,2,2
+'int_col16','INT',5,0,4,4
+'bigint_col16','BIGINT',5,0,8,8
+'float_col16','FLOAT',5,0,4,4
+'double_col16','DOUBLE',5,0,8,8
+'string_col16','STRING',5,0,1,1
+'bool_col17','BOOLEAN',2,0,1,1
+'tinyint_col17','TINYINT',5,0,1,1
+'smallint_col17','SMALLINT',5,0,2,2
+'int_col17','INT',5,0,4,4
+'bigint_col17','BIGINT',5,0,8,8
+'float_col17','FLOAT',5,0,4,4
+'double_col17','DOUBLE',5,0,8,8
+'string_col17','STRING',5,0,1,1
+'bool_col18','BOOLEAN',2,0,1,1
+'tinyint_col18','TINYINT',5,0,1,1
+'smallint_col18','SMALLINT',5,0,2,2
+'int_col18','INT',5,0,4,4
+'bigint_col18','BIGINT',5,0,8,8
+'float_col18','FLOAT',5,0,4,4
+'double_col18','DOUBLE',5,0,8,8
+'string_col18','STRING',5,0,1,1
+'bool_col19','BOOLEAN',2,0,1,1
+'tinyint_col19','TINYINT',5,0,1,1
+'smallint_col19','SMALLINT',5,0,2,2
+'int_col19','INT',5,0,4,4
+'bigint_col19','BIGINT',5,0,8,8
+'float_col19','FLOAT',5,0,4,4
+'double_col19','DOUBLE',5,0,8,8
+'string_col19','STRING',5,0,1,1
+'bool_col20','BOOLEAN',2,0,1,1
+'tinyint_col20','TINYINT',5,0,1,1
+'smallint_col20','SMALLINT',5,0,2,2
+'int_col20','INT',5,0,4,4
+'bigint_col20','BIGINT',5,0,8,8
+'float_col20','FLOAT',5,0,4,4
+'double_col20','DOUBLE',5,0,8,8
+'string_col20','STRING',5,0,1,1
+'bool_col21','BOOLEAN',2,0,1,1
+'tinyint_col21','TINYINT',5,0,1,1
+'smallint_col21','SMALLINT',5,0,2,2
+'int_col21','INT',5,0,4,4
+'bigint_col21','BIGINT',5,0,8,8
+'float_col21','FLOAT',5,0,4,4
+'double_col21','DOUBLE',5,0,8,8
+'string_col21','STRING',5,0,1,1
+'bool_col22','BOOLEAN',2,0,1,1
+'tinyint_col22','TINYINT',5,0,1,1
+'smallint_col22','SMALLINT',5,0,2,2
+'int_col22','INT',5,0,4,4
+'bigint_col22','BIGINT',5,0,8,8
+'float_col22','FLOAT',5,0,4,4
+'double_col22','DOUBLE',5,0,8,8
+'string_col22','STRING',5,0,1,1
+'bool_col23','BOOLEAN',2,0,1,1
+'tinyint_col23','TINYINT',5,0,1,1
+'smallint_col23','SMALLINT',5,0,2,2
+'int_col23','INT',5,0,4,4
+'bigint_col23','BIGINT',5,0,8,8
+'float_col23','FLOAT',5,0,4,4
+'double_col23','DOUBLE',5,0,8,8
+'string_col23','STRING',5,0,1,1
+'bool_col24','BOOLEAN',2,0,1,1
+'tinyint_col24','TINYINT',5,0,1,1
+'smallint_col24','SMALLINT',5,0,2,2
+'int_col24','INT',5,0,4,4
+'bigint_col24','BIGINT',5,0,8,8
+'float_col24','FLOAT',5,0,4,4
+'double_col24','DOUBLE',5,0,8,8
+'string_col24','STRING',5,0,1,1
+'bool_col25','BOOLEAN',2,0,1,1
+'tinyint_col25','TINYINT',5,0,1,1
+'smallint_col25','SMALLINT',5,0,2,2
+'int_col25','INT',5,0,4,4
+'bigint_col25','BIGINT',5,0,8,8
+'float_col25','FLOAT',5,0,4,4
+'double_col25','DOUBLE',5,0,8,8
+'string_col25','STRING',5,0,1,1
+'bool_col26','BOOLEAN',2,0,1,1
+'tinyint_col26','TINYINT',5,0,1,1
+'smallint_col26','SMALLINT',5,0,2,2
+'int_col26','INT',5,0,4,4
+'bigint_col26','BIGINT',5,0,8,8
+'float_col26','FLOAT',5,0,4,4
+'double_col26','DOUBLE',5,0,8,8
+'string_col26','STRING',5,0,1,1
+'bool_col27','BOOLEAN',2,0,1,1
+'tinyint_col27','TINYINT',5,0,1,1
+'smallint_col27','SMALLINT',5,0,2,2
+'int_col27','INT',5,0,4,4
+'bigint_col27','BIGINT',5,0,8,8
+'float_col27','FLOAT',5,0,4,4
+'double_col27','DOUBLE',5,0,8,8
+'string_col27','STRING',5,0,1,1
+'bool_col28','BOOLEAN',2,0,1,1
+'tinyint_col28','TINYINT',5,0,1,1
+'smallint_col28','SMALLINT',5,0,2,2
+'int_col28','INT',5,0,4,4
+'bigint_col28','BIGINT',5,0,8,8
+'float_col28','FLOAT',5,0,4,4
+'double_col28','DOUBLE',5,0,8,8
+'string_col28','STRING',5,0,1,1
+'bool_col29','BOOLEAN',2,0,1,1
+'tinyint_col29','TINYINT',5,0,1,1
+'smallint_col29','SMALLINT',5,0,2,2
+'int_col29','INT',5,0,4,4
+'bigint_col29','BIGINT',5,0,8,8
+'float_col29','FLOAT',5,0,4,4
+'double_col29','DOUBLE',5,0,8,8
+'string_col29','STRING',5,0,1,1
+'bool_col30','BOOLEAN',2,0,1,1
+'tinyint_col30','TINYINT',5,0,1,1
+'smallint_col30','SMALLINT',5,0,2,2
+'int_col30','INT',5,0,4,4
+'bigint_col30','BIGINT',5,0,8,8
+'float_col30','FLOAT',5,0,4,4
+'double_col30','DOUBLE',5,0,8,8
+'string_col30','STRING',5,0,1,1
+'bool_col31','BOOLEAN',2,0,1,1
+'tinyint_col31','TINYINT',5,0,1,1
+'smallint_col31','SMALLINT',5,0,2,2
+'int_col31','INT',5,0,4,4
+'bigint_col31','BIGINT',5,0,8,8
+'float_col31','FLOAT',5,0,4,4
+'double_col31','DOUBLE',5,0,8,8
+'string_col31','STRING',5,0,1,1
+'bool_col32','BOOLEAN',2,0,1,1
+'tinyint_col32','TINYINT',5,0,1,1
+'smallint_col32','SMALLINT',5,0,2,2
+'int_col32','INT',5,0,4,4
+'bigint_col32','BIGINT',5,0,8,8
+'float_col32','FLOAT',5,0,4,4
+'double_col32','DOUBLE',5,0,8,8
+'string_col32','STRING',5,0,1,1
+'bool_col33','BOOLEAN',2,0,1,1
+'tinyint_col33','TINYINT',5,0,1,1
+'smallint_col33','SMALLINT',5,0,2,2
+'int_col33','INT',5,0,4,4
+'bigint_col33','BIGINT',5,0,8,8
+'float_col33','FLOAT',5,0,4,4
+'double_col33','DOUBLE',5,0,8,8
+'string_col33','STRING',5,0,1,1
+'bool_col34','BOOLEAN',2,0,1,1
+'tinyint_col34','TINYINT',5,0,1,1
+'smallint_col34','SMALLINT',5,0,2,2
+'int_col34','INT',5,0,4,4
+'bigint_col34','BIGINT',5,0,8,8
+'float_col34','FLOAT',5,0,4,4
+'double_col34','DOUBLE',5,0,8,8
+'string_col34','STRING',5,0,1,1
+'bool_col35','BOOLEAN',2,0,1,1
+'tinyint_col35','TINYINT',5,0,1,1
+'smallint_col35','SMALLINT',5,0,2,2
+'int_col35','INT',5,0,4,4
+'bigint_col35','BIGINT',5,0,8,8
+'float_col35','FLOAT',5,0,4,4
+'double_col35','DOUBLE',5,0,8,8
+'string_col35','STRING',5,0,1,1
+'bool_col36','BOOLEAN',2,0,1,1
+'tinyint_col36','TINYINT',5,0,1,1
+'smallint_col36','SMALLINT',5,0,2,2
+'int_col36','INT',5,0,4,4
+'bigint_col36','BIGINT',5,0,8,8
+'float_col36','FLOAT',5,0,4,4
+'double_col36','DOUBLE',5,0,8,8
+'string_col36','STRING',5,0,1,1
+'bool_col37','BOOLEAN',2,0,1,1
+'tinyint_col37','TINYINT',5,0,1,1
+'smallint_col37','SMALLINT',5,0,2,2
+'int_col37','INT',5,0,4,4
+'bigint_col37','BIGINT',5,0,8,8
+'float_col37','FLOAT',5,0,4,4
+'double_col37','DOUBLE',5,0,8,8
+'string_col37','STRING',5,0,1,1
+'bool_col38','BOOLEAN',2,0,1,1
+'tinyint_col38','TINYINT',5,0,1,1
+'smallint_col38','SMALLINT',5,0,2,2
+'int_col38','INT',5,0,4,4
+'bigint_col38','BIGINT',5,0,8,8
+'float_col38','FLOAT',5,0,4,4
+'double_col38','DOUBLE',5,0,8,8
+'string_col38','STRING',5,0,1,1
+'bool_col39','BOOLEAN',2,0,1,1
+'tinyint_col39','TINYINT',5,0,1,1
+'smallint_col39','SMALLINT',5,0,2,2
+'int_col39','INT',5,0,4,4
+'bigint_col39','BIGINT',5,0,8,8
+'float_col39','FLOAT',5,0,4,4
+'double_col39','DOUBLE',5,0,8,8
+'string_col39','STRING',5,0,1,1
+'bool_col40','BOOLEAN',2,0,1,1
+'tinyint_col40','TINYINT',5,0,1,1
+'smallint_col40','SMALLINT',5,0,2,2
+'int_col40','INT',5,0,4,4
+'bigint_col40','BIGINT',5,0,8,8
+'float_col40','FLOAT',5,0,4,4
+'double_col40','DOUBLE',5,0,8,8
+'string_col40','STRING',5,0,1,1
+'bool_col41','BOOLEAN',2,0,1,1
+'tinyint_col41','TINYINT',5,0,1,1
+'smallint_col41','SMALLINT',5,0,2,2
+'int_col41','INT',5,0,4,4
+'bigint_col41','BIGINT',5,0,8,8
+'float_col41','FLOAT',5,0,4,4
+'double_col41','DOUBLE',5,0,8,8
+'string_col41','STRING',5,0,1,1
+'bool_col42','BOOLEAN',2,0,1,1
+'tinyint_col42','TINYINT',5,0,1,1
+'smallint_col42','SMALLINT',5,0,2,2
+'int_col42','INT',5,0,4,4
+'bigint_col42','BIGINT',5,0,8,8
+'float_col42','FLOAT',5,0,4,4
+'double_col42','DOUBLE',5,0,8,8
+'string_col42','STRING',5,0,1,1
+'bool_col43','BOOLEAN',2,0,1,1
+'tinyint_col43','TINYINT',5,0,1,1
+'smallint_col43','SMALLINT',5,0,2,2
+'int_col43','INT',5,0,4,4
+'bigint_col43','BIGINT',5,0,8,8
+'float_col43','FLOAT',5,0,4,4
+'double_col43','DOUBLE',5,0,8,8
+'string_col43','STRING',5,0,1,1
+'bool_col44','BOOLEAN',2,0,1,1
+'tinyint_col44','TINYINT',5,0,1,1
+'smallint_col44','SMALLINT',5,0,2,2
+'int_col44','INT',5,0,4,4
+'bigint_col44','BIGINT',5,0,8,8
+'float_col44','FLOAT',5,0,4,4
+'double_col44','DOUBLE',5,0,8,8
+'string_col44','STRING',5,0,1,1
+'bool_col45','BOOLEAN',2,0,1,1
+'tinyint_col45','TINYINT',5,0,1,1
+'smallint_col45','SMALLINT',5,0,2,2
+'int_col45','INT',5,0,4,4
+'bigint_col45','BIGINT',5,0,8,8
+'float_col45','FLOAT',5,0,4,4
+'double_col45','DOUBLE',5,0,8,8
+'string_col45','STRING',5,0,1,1
+'bool_col46','BOOLEAN',2,0,1,1
+'tinyint_col46','TINYINT',5,0,1,1
+'smallint_col46','SMALLINT',5,0,2,2
+'int_col46','INT',5,0,4,4
+'bigint_col46','BIGINT',5,0,8,8
+'float_col46','FLOAT',5,0,4,4
+'double_col46','DOUBLE',5,0,8,8
+'string_col46','STRING',5,0,1,1
+'bool_col47','BOOLEAN',2,0,1,1
+'tinyint_col47','TINYINT',5,0,1,1
+'smallint_col47','SMALLINT',5,0,2,2
+'int_col47','INT',5,0,4,4
+'bigint_col47','BIGINT',5,0,8,8
+'float_col47','FLOAT',5,0,4,4
+'double_col47','DOUBLE',5,0,8,8
+'string_col47','STRING',5,0,1,1
+'bool_col48','BOOLEAN',2,0,1,1
+'tinyint_col48','TINYINT',5,0,1,1
+'smallint_col48','SMALLINT',5,0,2,2
+'int_col48','INT',5,0,4,4
+'bigint_col48','BIGINT',5,0,8,8
+'float_col48','FLOAT',5,0,4,4
+'double_col48','DOUBLE',5,0,8,8
+'string_col48','STRING',5,0,1,1
+'bool_col49','BOOLEAN',2,0,1,1
+'tinyint_col49','TINYINT',5,0,1,1
+'smallint_col49','SMALLINT',5,0,2,2
+'int_col49','INT',5,0,4,4
+'bigint_col49','BIGINT',5,0,8,8
+'float_col49','FLOAT',5,0,4,4
+'double_col49','DOUBLE',5,0,8,8
+'string_col49','STRING',5,0,1,1
+'bool_col50','BOOLEAN',2,0,1,1
+'tinyint_col50','TINYINT',5,0,1,1
+'smallint_col50','SMALLINT',5,0,2,2
+'int_col50','INT',5,0,4,4
+'bigint_col50','BIGINT',5,0,8,8
+'float_col50','FLOAT',5,0,4,4
+'double_col50','DOUBLE',5,0,8,8
+'string_col50','STRING',5,0,1,1
+'bool_col51','BOOLEAN',2,0,1,1
+'tinyint_col51','TINYINT',5,0,1,1
+'smallint_col51','SMALLINT',5,0,2,2
+'int_col51','INT',5,0,4,4
+'bigint_col51','BIGINT',5,0,8,8
+'float_col51','FLOAT',5,0,4,4
+'double_col51','DOUBLE',5,0,8,8
+'string_col51','STRING',5,0,1,1
+'bool_col52','BOOLEAN',2,0,1,1
+'tinyint_col52','TINYINT',5,0,1,1
+'smallint_col52','SMALLINT',5,0,2,2
+'int_col52','INT',5,0,4,4
+'bigint_col52','BIGINT',5,0,8,8
+'float_col52','FLOAT',5,0,4,4
+'double_col52','DOUBLE',5,0,8,8
+'string_col52','STRING',5,0,1,1
+'bool_col53','BOOLEAN',2,0,1,1
+'tinyint_col53','TINYINT',5,0,1,1
+'smallint_col53','SMALLINT',5,0,2,2
+'int_col53','INT',5,0,4,4
+'bigint_col53','BIGINT',5,0,8,8
+'float_col53','FLOAT',5,0,4,4
+'double_col53','DOUBLE',5,0,8,8
+'string_col53','STRING',5,0,1,1
+'bool_col54','BOOLEAN',2,0,1,1
+'tinyint_col54','TINYINT',5,0,1,1
+'smallint_col54','SMALLINT',5,0,2,2
+'int_col54','INT',5,0,4,4
+'bigint_col54','BIGINT',5,0,8,8
+'float_col54','FLOAT',5,0,4,4
+'double_col54','DOUBLE',5,0,8,8
+'string_col54','STRING',5,0,1,1
+'bool_col55','BOOLEAN',2,0,1,1
+'tinyint_col55','TINYINT',5,0,1,1
+'smallint_col55','SMALLINT',5,0,2,2
+'int_col55','INT',5,0,4,4
+'bigint_col55','BIGINT',5,0,8,8
+'float_col55','FLOAT',5,0,4,4
+'double_col55','DOUBLE',5,0,8,8
+'string_col55','STRING',5,0,1,1
+'bool_col56','BOOLEAN',2,0,1,1
+'tinyint_col56','TINYINT',5,0,1,1
+'smallint_col56','SMALLINT',5,0,2,2
+'int_col56','INT',5,0,4,4
+'bigint_col56','BIGINT',5,0,8,8
+'float_col56','FLOAT',5,0,4,4
+'double_col56','DOUBLE',5,0,8,8
+'string_col56','STRING',5,0,1,1
+'bool_col57','BOOLEAN',2,0,1,1
+'tinyint_col57','TINYINT',5,0,1,1
+'smallint_col57','SMALLINT',5,0,2,2
+'int_col57','INT',5,0,4,4
+'bigint_col57','BIGINT',5,0,8,8
+'float_col57','FLOAT',5,0,4,4
+'double_col57','DOUBLE',5,0,8,8
+'string_col57','STRING',5,0,1,1
+'bool_col58','BOOLEAN',2,0,1,1
+'tinyint_col58','TINYINT',5,0,1,1
+'smallint_col58','SMALLINT',5,0,2,2
+'int_col58','INT',5,0,4,4
+'bigint_col58','BIGINT',5,0,8,8
+'float_col58','FLOAT',5,0,4,4
+'double_col58','DOUBLE',5,0,8,8
+'string_col58','STRING',5,0,1,1
+'bool_col59','BOOLEAN',2,0,1,1
+'tinyint_col59','TINYINT',5,0,1,1
+'smallint_col59','SMALLINT',5,0,2,2
+'int_col59','INT',5,0,4,4
+'bigint_col59','BIGINT',5,0,8,8
+'float_col59','FLOAT',5,0,4,4
+'double_col59','DOUBLE',5,0,8,8
+'string_col59','STRING',5,0,1,1
+'bool_col60','BOOLEAN',2,0,1,1
+'tinyint_col60','TINYINT',5,0,1,1
+'smallint_col60','SMALLINT',5,0,2,2
+'int_col60','INT',5,0,4,4
+'bigint_col60','BIGINT',5,0,8,8
+'float_col60','FLOAT',5,0,4,4
+'double_col60','DOUBLE',5,0,8,8
+'string_col60','STRING',5,0,1,1
+'bool_col61','BOOLEAN',2,0,1,1
+'tinyint_col61','TINYINT',5,0,1,1
+'smallint_col61','SMALLINT',5,0,2,2
+'int_col61','INT',5,0,4,4
+'bigint_col61','BIGINT',5,0,8,8
+'float_col61','FLOAT',5,0,4,4
+'double_col61','DOUBLE',5,0,8,8
+'string_col61','STRING',5,0,1,1
+'bool_col62','BOOLEAN',2,0,1,1
+'tinyint_col62','TINYINT',5,0,1,1
+'smallint_col62','SMALLINT',5,0,2,2
+'int_col62','INT',5,0,4,4
+'bigint_col62','BIGINT',5,0,8,8
+'float_col62','FLOAT',5,0,4,4
+'double_col62','DOUBLE',5,0,8,8
+'string_col62','STRING',5,0,1,1
+'bool_col63','BOOLEAN',2,0,1,1
+'tinyint_col63','TINYINT',5,0,1,1
+'smallint_col63','SMALLINT',5,0,2,2
+'int_col63','INT',5,0,4,4
+'bigint_col63','BIGINT',5,0,8,8
+'float_col63','FLOAT',5,0,4,4
+'double_col63','DOUBLE',5,0,8,8
+'string_col63','STRING',5,0,1,1
+'bool_col64','BOOLEAN',2,0,1,1
+'tinyint_col64','TINYINT',5,0,1,1
+'smallint_col64','SMALLINT',5,0,2,2
+'int_col64','INT',5,0,4,4
+'bigint_col64','BIGINT',5,0,8,8
+'float_col64','FLOAT',5,0,4,4
+'double_col64','DOUBLE',5,0,8,8
+'string_col64','STRING',5,0,1,1
+'bool_col65','BOOLEAN',2,0,1,1
+'tinyint_col65','TINYINT',5,0,1,1
+'smallint_col65','SMALLINT',5,0,2,2
+'int_col65','INT',5,0,4,4
+'bigint_col65','BIGINT',5,0,8,8
+'float_col65','FLOAT',5,0,4,4
+'double_col65','DOUBLE',5,0,8,8
+'string_col65','STRING',5,0,1,1
+'bool_col66','BOOLEAN',2,0,1,1
+'tinyint_col66','TINYINT',5,0,1,1
+'smallint_col66','SMALLINT',5,0,2,2
+'int_col66','INT',5,0,4,4
+'bigint_col66','BIGINT',5,0,8,8
+'float_col66','FLOAT',5,0,4,4
+'double_col66','DOUBLE',5,0,8,8
+'string_col66','STRING',5,0,1,1
+'bool_col67','BOOLEAN',2,0,1,1
+'tinyint_col67','TINYINT',5,0,1,1
+'smallint_col67','SMALLINT',5,0,2,2
+'int_col67','INT',5,0,4,4
+'bigint_col67','BIGINT',5,0,8,8
+'float_col67','FLOAT',5,0,4,4
+'double_col67','DOUBLE',5,0,8,8
+'string_col67','STRING',5,0,1,1
+'bool_col68','BOOLEAN',2,0,1,1
+'tinyint_col68','TINYINT',5,0,1,1
+'smallint_col68','SMALLINT',5,0,2,2
+'int_col68','INT',5,0,4,4
+'bigint_col68','BIGINT',5,0,8,8
+'float_col68','FLOAT',5,0,4,4
+'double_col68','DOUBLE',5,0,8,8
+'string_col68','STRING',5,0,1,1
+'bool_col69','BOOLEAN',2,0,1,1
+'tinyint_col69','TINYINT',5,0,1,1
+'smallint_col69','SMALLINT',5,0,2,2
+'int_col69','INT',5,0,4,4
+'bigint_col69','BIGINT',5,0,8,8
+'float_col69','FLOAT',5,0,4,4
+'double_col69','DOUBLE',5,0,8,8
+'string_col69','STRING',5,0,1,1
+'bool_col70','BOOLEAN',2,0,1,1
+'tinyint_col70','TINYINT',5,0,1,1
+'smallint_col70','SMALLINT',5,0,2,2
+'int_col70','INT',5,0,4,4
+'bigint_col70','BIGINT',5,0,8,8
+'float_col70','FLOAT',5,0,4,4
+'double_col70','DOUBLE',5,0,8,8
+'string_col70','STRING',5,0,1,1
+'bool_col71','BOOLEAN',2,0,1,1
+'tinyint_col71','TINYINT',5,0,1,1
+'smallint_col71','SMALLINT',5,0,2,2
+'int_col71','INT',5,0,4,4
+'bigint_col71','BIGINT',5,0,8,8
+'float_col71','FLOAT',5,0,4,4
+'double_col71','DOUBLE',5,0,8,8
+'string_col71','STRING',5,0,1,1
+'bool_col72','BOOLEAN',2,0,1,1
+'tinyint_col72','TINYINT',5,0,1,1
+'smallint_col72','SMALLINT',5,0,2,2
+'int_col72','INT',5,0,4,4
+'bigint_col72','BIGINT',5,0,8,8
+'float_col72','FLOAT',5,0,4,4
+'double_col72','DOUBLE',5,0,8,8
+'string_col72','STRING',5,0,1,1
+'bool_col73','BOOLEAN',2,0,1,1
+'tinyint_col73','TINYINT',5,0,1,1
+'smallint_col73','SMALLINT',5,0,2,2
+'int_col73','INT',5,0,4,4
+'bigint_col73','BIGINT',5,0,8,8
+'float_col73','FLOAT',5,0,4,4
+'double_col73','DOUBLE',5,0,8,8
+'string_col73','STRING',5,0,1,1
+'bool_col74','BOOLEAN',2,0,1,1
+'tinyint_col74','TINYINT',5,0,1,1
+'smallint_col74','SMALLINT',5,0,2,2
+'int_col74','INT',5,0,4,4
+'bigint_col74','BIGINT',5,0,8,8
+'float_col74','FLOAT',5,0,4,4
+'double_col74','DOUBLE',5,0,8,8
+'string_col74','STRING',5,0,1,1
+'bool_col75','BOOLEAN',2,0,1,1
+'tinyint_col75','TINYINT',5,0,1,1
+'smallint_col75','SMALLINT',5,0,2,2
+'int_col75','INT',5,0,4,4
+'bigint_col75','BIGINT',5,0,8,8
+'float_col75','FLOAT',5,0,4,4
+'double_col75','DOUBLE',5,0,8,8
+'string_col75','STRING',5,0,1,1
+'bool_col76','BOOLEAN',2,0,1,1
+'tinyint_col76','TINYINT',5,0,1,1
+'smallint_col76','SMALLINT',5,0,2,2
+'int_col76','INT',5,0,4,4
+'bigint_col76','BIGINT',5,0,8,8
+'float_col76','FLOAT',5,0,4,4
+'double_col76','DOUBLE',5,0,8,8
+'string_col76','STRING',5,0,1,1
+'bool_col77','BOOLEAN',2,0,1,1
+'tinyint_col77','TINYINT',5,0,1,1
+'smallint_col77','SMALLINT',5,0,2,2
+'int_col77','INT',5,0,4,4
+'bigint_col77','BIGINT',5,0,8,8
+'float_col77','FLOAT',5,0,4,4
+'double_col77','DOUBLE',5,0,8,8
+'string_col77','STRING',5,0,1,1
+'bool_col78','BOOLEAN',2,0,1,1
+'tinyint_col78','TINYINT',5,0,1,1
+'smallint_col78','SMALLINT',5,0,2,2
+'int_col78','INT',5,0,4,4
+'bigint_col78','BIGINT',5,0,8,8
+'float_col78','FLOAT',5,0,4,4
+'double_col78','DOUBLE',5,0,8,8
+'string_col78','STRING',5,0,1,1
+'bool_col79','BOOLEAN',2,0,1,1
+'tinyint_col79','TINYINT',5,0,1,1
+'smallint_col79','SMALLINT',5,0,2,2
+'int_col79','INT',5,0,4,4
+'bigint_col79','BIGINT',5,0,8,8
+'float_col79','FLOAT',5,0,4,4
+'double_col79','DOUBLE',5,0,8,8
+'string_col79','STRING',5,0,1,1
+'bool_col80','BOOLEAN',2,0,1,1
+'tinyint_col80','TINYINT',5,0,1,1
+'smallint_col80','SMALLINT',5,0,2,2
+'int_col80','INT',5,0,4,4
+'bigint_col80','BIGINT',5,0,8,8
+'float_col80','FLOAT',5,0,4,4
+'double_col80','DOUBLE',5,0,8,8
+'string_col80','STRING',5,0,1,1
+'bool_col81','BOOLEAN',2,0,1,1
+'tinyint_col81','TINYINT',5,0,1,1
+'smallint_col81','SMALLINT',5,0,2,2
+'int_col81','INT',5,0,4,4
+'bigint_col81','BIGINT',5,0,8,8
+'float_col81','FLOAT',5,0,4,4
+'double_col81','DOUBLE',5,0,8,8
+'string_col81','STRING',5,0,1,1
+'bool_col82','BOOLEAN',2,0,1,1
+'tinyint_col82','TINYINT',5,0,1,1
+'smallint_col82','SMALLINT',5,0,2,2
+'int_col82','INT',5,0,4,4
+'bigint_col82','BIGINT',5,0,8,8
+'float_col82','FLOAT',5,0,4,4
+'double_col82','DOUBLE',5,0,8,8
+'string_col82','STRING',5,0,1,1
+'bool_col83','BOOLEAN',2,0,1,1
+'tinyint_col83','TINYINT',5,0,1,1
+'smallint_col83','SMALLINT',5,0,2,2
+'int_col83','INT',5,0,4,4
+'bigint_col83','BIGINT',5,0,8,8
+'float_col83','FLOAT',5,0,4,4
+'double_col83','DOUBLE',5,0,8,8
+'string_col83','STRING',5,0,1,1
+'bool_col84','BOOLEAN',2,0,1,1
+'tinyint_col84','TINYINT',5,0,1,1
+'smallint_col84','SMALLINT',5,0,2,2
+'int_col84','INT',5,0,4,4
+'bigint_col84','BIGINT',5,0,8,8
+'float_col84','FLOAT',5,0,4,4
+'double_col84','DOUBLE',5,0,8,8
+'string_col84','STRING',5,0,1,1
+'bool_col85','BOOLEAN',2,0,1,1
+'tinyint_col85','TINYINT',5,0,1,1
+'smallint_col85','SMALLINT',5,0,2,2
+'int_col85','INT',5,0,4,4
+'bigint_col85','BIGINT',5,0,8,8
+'float_col85','FLOAT',5,0,4,4
+'double_col85','DOUBLE',5,0,8,8
+'string_col85','STRING',5,0,1,1
+'bool_col86','BOOLEAN',2,0,1,1
+'tinyint_col86','TINYINT',5,0,1,1
+'smallint_col86','SMALLINT',5,0,2,2
+'int_col86','INT',5,0,4,4
+'bigint_col86','BIGINT',5,0,8,8
+'float_col86','FLOAT',5,0,4,4
+'double_col86','DOUBLE',5,0,8,8
+'string_col86','STRING',5,0,1,1
+'bool_col87','BOOLEAN',2,0,1,1
+'tinyint_col87','TINYINT',5,0,1,1
+'smallint_col87','SMALLINT',5,0,2,2
+'int_col87','INT',5,0,4,4
+'bigint_col87','BIGINT',5,0,8,8
+'float_col87','FLOAT',5,0,4,4
+'double_col87','DOUBLE',5,0,8,8
+'string_col87','STRING',5,0,1,1
+'bool_col88','BOOLEAN',2,0,1,1
+'tinyint_col88','TINYINT',5,0,1,1
+'smallint_col88','SMALLINT',5,0,2,2
+'int_col88','INT',5,0,4,4
+'bigint_col88','BIGINT',5,0,8,8
+'float_col88','FLOAT',5,0,4,4
+'double_col88','DOUBLE',5,0,8,8
+'string_col88','STRING',5,0,1,1
+'bool_col89','BOOLEAN',2,0,1,1
+'tinyint_col89','TINYINT',5,0,1,1
+'smallint_col89','SMALLINT',5,0,2,2
+'int_col89','INT',5,0,4,4
+'bigint_col89','BIGINT',5,0,8,8
+'float_col89','FLOAT',5,0,4,4
+'double_col89','DOUBLE',5,0,8,8
+'string_col89','STRING',5,0,1,1
+'bool_col90','BOOLEAN',2,0,1,1
+'tinyint_col90','TINYINT',5,0,1,1
+'smallint_col90','SMALLINT',5,0,2,2
+'int_col90','INT',5,0,4,4
+'bigint_col90','BIGINT',5,0,8,8
+'float_col90','FLOAT',5,0,4,4
+'double_col90','DOUBLE',5,0,8,8
+'string_col90','STRING',5,0,1,1
+'bool_col91','BOOLEAN',2,0,1,1
+'tinyint_col91','TINYINT',5,0,1,1
+'smallint_col91','SMALLINT',5,0,2,2
+'int_col91','INT',5,0,4,4
+'bigint_col91','BIGINT',5,0,8,8
+'float_col91','FLOAT',5,0,4,4
+'double_col91','DOUBLE',5,0,8,8
+'string_col91','STRING',5,0,1,1
+'bool_col92','BOOLEAN',2,0,1,1
+'tinyint_col92','TINYINT',5,0,1,1
+'smallint_col92','SMALLINT',5,0,2,2
+'int_col92','INT',5,0,4,4
+'bigint_col92','BIGINT',5,0,8,8
+'float_col92','FLOAT',5,0,4,4
+'double_col92','DOUBLE',5,0,8,8
+'string_col92','STRING',5,0,1,1
+'bool_col93','BOOLEAN',2,0,1,1
+'tinyint_col93','TINYINT',5,0,1,1
+'smallint_col93','SMALLINT',5,0,2,2
+'int_col93','INT',5,0,4,4
+'bigint_col93','BIGINT',5,0,8,8
+'float_col93','FLOAT',5,0,4,4
+'double_col93','DOUBLE',5,0,8,8
+'string_col93','STRING',5,0,1,1
+'bool_col94','BOOLEAN',2,0,1,1
+'tinyint_col94','TINYINT',5,0,1,1
+'smallint_col94','SMALLINT',5,0,2,2
+'int_col94','INT',5,0,4,4
+'bigint_col94','BIGINT',5,0,8,8
+'float_col94','FLOAT',5,0,4,4
+'double_col94','DOUBLE',5,0,8,8
+'string_col94','STRING',5,0,1,1
+'bool_col95','BOOLEAN',2,0,1,1
+'tinyint_col95','TINYINT',5,0,1,1
+'smallint_col95','SMALLINT',5,0,2,2
+'int_col95','INT',5,0,4,4
+'bigint_col95','BIGINT',5,0,8,8
+'float_col95','FLOAT',5,0,4,4
+'double_col95','DOUBLE',5,0,8,8
+'string_col95','STRING',5,0,1,1
+'bool_col96','BOOLEAN',2,0,1,1
+'tinyint_col96','TINYINT',5,0,1,1
+'smallint_col96','SMALLINT',5,0,2,2
+'int_col96','INT',5,0,4,4
+'bigint_col96','BIGINT',5,0,8,8
+'float_col96','FLOAT',5,0,4,4
+'double_col96','DOUBLE',5,0,8,8
+'string_col96','STRING',5,0,1,1
+'bool_col97','BOOLEAN',2,0,1,1
+'tinyint_col97','TINYINT',5,0,1,1
+'smallint_col97','SMALLINT',5,0,2,2
+'int_col97','INT',5,0,4,4
+'bigint_col97','BIGINT',5,0,8,8
+'float_col97','FLOAT',5,0,4,4
+'double_col97','DOUBLE',5,0,8,8
+'string_col97','STRING',5,0,1,1
+'bool_col98','BOOLEAN',2,0,1,1
+'tinyint_col98','TINYINT',5,0,1,1
+'smallint_col98','SMALLINT',5,0,2,2
+'int_col98','INT',5,0,4,4
+'bigint_col98','BIGINT',5,0,8,8
+'float_col98','FLOAT',5,0,4,4
+'double_col98','DOUBLE',5,0,8,8
+'string_col98','STRING',5,0,1,1
+'bool_col99','BOOLEAN',2,0,1,1
+'tinyint_col99','TINYINT',5,0,1,1
+'smallint_col99','SMALLINT',5,0,2,2
+'int_col99','INT',5,0,4,4
+'bigint_col99','BIGINT',5,0,8,8
+'float_col99','FLOAT',5,0,4,4
+'double_col99','DOUBLE',5,0,8,8
+'string_col99','STRING',5,0,1,1
+'bool_col100','BOOLEAN',2,0,1,1
+'tinyint_col100','TINYINT',5,0,1,1
+'smallint_col100','SMALLINT',5,0,2,2
+'int_col100','INT',5,0,4,4
+'bigint_col100','BIGINT',5,0,8,8
+'float_col100','FLOAT',5,0,4,4
+'double_col100','DOUBLE',5,0,8,8
+'string_col100','STRING',5,0,1,1
+'bool_col101','BOOLEAN',2,0,1,1
+'tinyint_col101','TINYINT',5,0,1,1
+'smallint_col101','SMALLINT',5,0,2,2
+'int_col101','INT',5,0,4,4
+'bigint_col101','BIGINT',5,0,8,8
+'float_col101','FLOAT',5,0,4,4
+'double_col101','DOUBLE',5,0,8,8
+'string_col101','STRING',5,0,1,1
+'bool_col102','BOOLEAN',2,0,1,1
+'tinyint_col102','TINYINT',5,0,1,1
+'smallint_col102','SMALLINT',5,0,2,2
+'int_col102','INT',5,0,4,4
+'bigint_col102','BIGINT',5,0,8,8
+'float_col102','FLOAT',5,0,4,4
+'double_col102','DOUBLE',5,0,8,8
+'string_col102','STRING',5,0,1,1
+'bool_col103','BOOLEAN',2,0,1,1
+'tinyint_col103','TINYINT',5,0,1,1
+'smallint_col103','SMALLINT',5,0,2,2
+'int_col103','INT',5,0,4,4
+'bigint_col103','BIGINT',5,0,8,8
+'float_col103','FLOAT',5,0,4,4
+'double_col103','DOUBLE',5,0,8,8
+'string_col103','STRING',5,0,1,1
+'bool_col104','BOOLEAN',2,0,1,1
+'tinyint_col104','TINYINT',5,0,1,1
+'smallint_col104','SMALLINT',5,0,2,2
+'int_col104','INT',5,0,4,4
+'bigint_col104','BIGINT',5,0,8,8
+'float_col104','FLOAT',5,0,4,4
+'double_col104','DOUBLE',5,0,8,8
+'string_col104','STRING',5,0,1,1
+'bool_col105','BOOLEAN',2,0,1,1
+'tinyint_col105','TINYINT',5,0,1,1
+'smallint_col105','SMALLINT',5,0,2,2
+'int_col105','INT',5,0,4,4
+'bigint_col105','BIGINT',5,0,8,8
+'float_col105','FLOAT',5,0,4,4
+'double_col105','DOUBLE',5,0,8,8
+'string_col105','STRING',5,0,1,1
+'bool_col106','BOOLEAN',2,0,1,1
+'tinyint_col106','TINYINT',5,0,1,1
+'smallint_col106','SMALLINT',5,0,2,2
+'int_col106','INT',5,0,4,4
+'bigint_col106','BIGINT',5,0,8,8
+'float_col106','FLOAT',5,0,4,4
+'double_col106','DOUBLE',5,0,8,8
+'string_col106','STRING',5,0,1,1
+'bool_col107','BOOLEAN',2,0,1,1
+'tinyint_col107','TINYINT',5,0,1,1
+'smallint_col107','SMALLINT',5,0,2,2
+'int_col107','INT',5,0,4,4
+'bigint_col107','BIGINT',5,0,8,8
+'float_col107','FLOAT',5,0,4,4
+'double_col107','DOUBLE',5,0,8,8
+'string_col107','STRING',5,0,1,1
+'bool_col108','BOOLEAN',2,0,1,1
+'tinyint_col108','TINYINT',5,0,1,1
+'smallint_col108','SMALLINT',5,0,2,2
+'int_col108','INT',5,0,4,4
+'bigint_col108','BIGINT',5,0,8,8
+'float_col108','FLOAT',5,0,4,4
+'double_col108','DOUBLE',5,0,8,8
+'string_col108','STRING',5,0,1,1
+'bool_col109','BOOLEAN',2,0,1,1
+'tinyint_col109','TINYINT',5,0,1,1
+'smallint_col109','SMALLINT',5,0,2,2
+'int_col109','INT',5,0,4,4
+'bigint_col109','BIGINT',5,0,8,8
+'float_col109','FLOAT',5,0,4,4
+'double_col109','DOUBLE',5,0,8,8
+'string_col109','STRING',5,0,1,1
+'bool_col110','BOOLEAN',2,0,1,1
+'tinyint_col110','TINYINT',5,0,1,1
+'smallint_col110','SMALLINT',5,0,2,2
+'int_col110','INT',5,0,4,4
+'bigint_col110','BIGINT',5,0,8,8
+'float_col110','FLOAT',5,0,4,4
+'double_col110','DOUBLE',5,0,8,8
+'string_col110','STRING',5,0,1,1
+'bool_col111','BOOLEAN',2,0,1,1
+'tinyint_col111','TINYINT',5,0,1,1
+'smallint_col111','SMALLINT',5,0,2,2
+'int_col111','INT',5,0,4,4
+'bigint_col111','BIGINT',5,0,8,8
+'float_col111','FLOAT',5,0,4,4
+'double_col111','DOUBLE',5,0,8,8
+'string_col111','STRING',5,0,1,1
+'bool_col112','BOOLEAN',2,0,1,1
+'tinyint_col112','TINYINT',5,0,1,1
+'smallint_col112','SMALLINT',5,0,2,2
+'int_col112','INT',5,0,4,4
+'bigint_col112','BIGINT',5,0,8,8
+'float_col112','FLOAT',5,0,4,4
+'double_col112','DOUBLE',5,0,8,8
+'string_col112','STRING',5,0,1,1
+'bool_col113','BOOLEAN',2,0,1,1
+'tinyint_col113','TINYINT',5,0,1,1
+'smallint_col113','SMALLINT',5,0,2,2
+'int_col113','INT',5,0,4,4
+'bigint_col113','BIGINT',5,0,8,8
+'float_col113','FLOAT',5,0,4,4
+'double_col113','DOUBLE',5,0,8,8
+'string_col113','STRING',5,0,1,1
+'bool_col114','BOOLEAN',2,0,1,1
+'tinyint_col114','TINYINT',5,0,1,1
+'smallint_col114','SMALLINT',5,0,2,2
+'int_col114','INT',5,0,4,4
+'bigint_col114','BIGINT',5,0,8,8
+'float_col114','FLOAT',5,0,4,4
+'double_col114','DOUBLE',5,0,8,8
+'string_col114','STRING',5,0,1,1
+'bool_col115','BOOLEAN',2,0,1,1
+'tinyint_col115','TINYINT',5,0,1,1
+'smallint_col115','SMALLINT',5,0,2,2
+'int_col115','INT',5,0,4,4
+'bigint_col115','BIGINT',5,0,8,8
+'float_col115','FLOAT',5,0,4,4
+'double_col115','DOUBLE',5,0,8,8
+'string_col115','STRING',5,0,1,1
+'bool_col116','BOOLEAN',2,0,1,1
+'tinyint_col116','TINYINT',5,0,1,1
+'smallint_col116','SMALLINT',5,0,2,2
+'int_col116','INT',5,0,4,4
+'bigint_col116','BIGINT',5,0,8,8
+'float_col116','FLOAT',5,0,4,4
+'double_col116','DOUBLE',5,0,8,8
+'string_col116','STRING',5,0,1,1
+'bool_col117','BOOLEAN',2,0,1,1
+'tinyint_col117','TINYINT',5,0,1,1
+'smallint_col117','SMALLINT',5,0,2,2
+'int_col117','INT',5,0,4,4
+'bigint_col117','BIGINT',5,0,8,8
+'float_col117','FLOAT',5,0,4,4
+'double_col117','DOUBLE',5,0,8,8
+'string_col117','STRING',5,0,1,1
+'bool_col118','BOOLEAN',2,0,1,1
+'tinyint_col118','TINYINT',5,0,1,1
+'smallint_col118','SMALLINT',5,0,2,2
+'int_col118','INT',5,0,4,4
+'bigint_col118','BIGINT',5,0,8,8
+'float_col118','FLOAT',5,0,4,4
+'double_col118','DOUBLE',5,0,8,8
+'string_col118','STRING',5,0,1,1
+'bool_col119','BOOLEAN',2,0,1,1
+'tinyint_col119','TINYINT',5,0,1,1
+'smallint_col119','SMALLINT',5,0,2,2
+'int_col119','INT',5,0,4,4
+'bigint_col119','BIGINT',5,0,8,8
+'float_col119','FLOAT',5,0,4,4
+'double_col119','DOUBLE',5,0,8,8
+'string_col119','STRING',5,0,1,1
+'bool_col120','BOOLEAN',2,0,1,1
+'tinyint_col120','TINYINT',5,0,1,1
+'smallint_col120','SMALLINT',5,0,2,2
+'int_col120','INT',5,0,4,4
+'bigint_col120','BIGINT',5,0,8,8
+'float_col120','FLOAT',5,0,4,4
+'double_col120','DOUBLE',5,0,8,8
+'string_col120','STRING',5,0,1,1
+'bool_col121','BOOLEAN',2,0,1,1
+'tinyint_col121','TINYINT',5,0,1,1
+'smallint_col121','SMALLINT',5,0,2,2
+'int_col121','INT',5,0,4,4
+'bigint_col121','BIGINT',5,0,8,8
+'float_col121','FLOAT',5,0,4,4
+'double_col121','DOUBLE',5,0,8,8
+'string_col121','STRING',5,0,1,1
+'bool_col122','BOOLEAN',2,0,1,1
+'tinyint_col122','TINYINT',5,0,1,1
+'smallint_col122','SMALLINT',5,0,2,2
+'int_col122','INT',5,0,4,4
+'bigint_col122','BIGINT',5,0,8,8
+'float_col122','FLOAT',5,0,4,4
+'double_col122','DOUBLE',5,0,8,8
+'string_col122','STRING',5,0,1,1
+'bool_col123','BOOLEAN',2,0,1,1
+'tinyint_col123','TINYINT',5,0,1,1
+'smallint_col123','SMALLINT',5,0,2,2
+'int_col123','INT',5,0,4,4
+'bigint_col123','BIGINT',5,0,8,8
+'float_col123','FLOAT',5,0,4,4
+'double_col123','DOUBLE',5,0,8,8
+'string_col123','STRING',5,0,1,1
+'bool_col124','BOOLEAN',2,0,1,1
+'tinyint_col124','TINYINT',5,0,1,1
+'smallint_col124','SMALLINT',5,0,2,2
+'int_col124','INT',5,0,4,4
+'bigint_col124','BIGINT',5,0,8,8
+'float_col124','FLOAT',5,0,4,4
+'double_col124','DOUBLE',5,0,8,8
+'string_col124','STRING',5,0,1,1
+'bool_col125','BOOLEAN',2,0,1,1
+'tinyint_col125','TINYINT',5,0,1,1
+'smallint_col125','SMALLINT',5,0,2,2
+'int_col125','INT',5,0,4,4
+'bigint_col125','BIGINT',5,0,8,8
+'float_col125','FLOAT',5,0,4,4
+'double_col125','DOUBLE',5,0,8,8
+'string_col125','STRING',5,0,1,1
 ---- TYPES
 STRING, STRING, BIGINT, BIGINT, BIGINT, DOUBLE
 ====

http://git-wip-us.apache.org/repos/asf/impala/blob/04d027df/testdata/workloads/functional-query/queries/QueryTest/hbase-compute-stats-incremental.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/functional-query/queries/QueryTest/hbase-compute-stats-incremental.test b/testdata/workloads/functional-query/queries/QueryTest/hbase-compute-stats-incremental.test
index a0ecb18..191b468 100644
--- a/testdata/workloads/functional-query/queries/QueryTest/hbase-compute-stats-incremental.test
+++ b/testdata/workloads/functional-query/queries/QueryTest/hbase-compute-stats-incremental.test
@@ -31,19 +31,19 @@ show column stats alltypessmall_hbase
 ---- LABELS
 COLUMN, TYPE, #DISTINCT VALUES, #NULLS, MAX SIZE, AVG SIZE
 ---- RESULTS
-'id','INT',99,-1,4,4
-'bigint_col','BIGINT',10,-1,8,8
-'bool_col','BOOLEAN',2,-1,1,1
-'date_string_col','STRING',12,-1,8,8
-'double_col','DOUBLE',10,-1,8,8
-'float_col','FLOAT',10,-1,4,4
-'int_col','INT',10,-1,4,4
-'month','INT',4,-1,4,4
-'smallint_col','SMALLINT',10,-1,2,2
-'string_col','STRING',10,-1,1,1
-'timestamp_col','TIMESTAMP',100,-1,16,16
-'tinyint_col','TINYINT',10,-1,1,1
-'year','INT',1,-1,4,4
+'id','INT',99,0,4,4
+'bigint_col','BIGINT',10,0,8,8
+'bool_col','BOOLEAN',2,0,1,1
+'date_string_col','STRING',12,0,8,8
+'double_col','DOUBLE',10,0,8,8
+'float_col','FLOAT',10,0,4,4
+'int_col','INT',10,0,4,4
+'month','INT',4,0,4,4
+'smallint_col','SMALLINT',10,0,2,2
+'string_col','STRING',10,0,1,1
+'timestamp_col','TIMESTAMP',100,0,16,16
+'tinyint_col','TINYINT',10,0,1,1
+'year','INT',1,0,4,4
 ---- TYPES
 STRING, STRING, BIGINT, BIGINT, BIGINT, DOUBLE
-====
+====
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/impala/blob/04d027df/testdata/workloads/functional-query/queries/QueryTest/hbase-compute-stats.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/functional-query/queries/QueryTest/hbase-compute-stats.test b/testdata/workloads/functional-query/queries/QueryTest/hbase-compute-stats.test
index d1e60b3..b559dc6 100644
--- a/testdata/workloads/functional-query/queries/QueryTest/hbase-compute-stats.test
+++ b/testdata/workloads/functional-query/queries/QueryTest/hbase-compute-stats.test
@@ -30,19 +30,19 @@ show column stats alltypessmall_hbase
 ---- LABELS
 COLUMN, TYPE, #DISTINCT VALUES, #NULLS, MAX SIZE, AVG SIZE
 ---- RESULTS
-'id','INT',99,-1,4,4
-'bigint_col','BIGINT',10,-1,8,8
-'bool_col','BOOLEAN',2,-1,1,1
-'date_string_col','STRING',12,-1,8,8
-'double_col','DOUBLE',10,-1,8,8
-'float_col','FLOAT',10,-1,4,4
-'int_col','INT',10,-1,4,4
-'month','INT',4,-1,4,4
-'smallint_col','SMALLINT',10,-1,2,2
-'string_col','STRING',10,-1,1,1
-'timestamp_col','TIMESTAMP',100,-1,16,16
-'tinyint_col','TINYINT',10,-1,1,1
-'year','INT',1,-1,4,4
+'id','INT',99,0,4,4
+'bigint_col','BIGINT',10,0,8,8
+'bool_col','BOOLEAN',2,0,1,1
+'date_string_col','STRING',12,0,8,8
+'double_col','DOUBLE',10,0,8,8
+'float_col','FLOAT',10,0,4,4
+'int_col','INT',10,0,4,4
+'month','INT',4,0,4,4
+'smallint_col','SMALLINT',10,0,2,2
+'string_col','STRING',10,0,1,1
+'timestamp_col','TIMESTAMP',100,0,16,16
+'tinyint_col','TINYINT',10,0,1,1
+'year','INT',1,0,4,4
 ---- TYPES
 STRING, STRING, BIGINT, BIGINT, BIGINT, DOUBLE
 ====
@@ -71,19 +71,19 @@ show column stats alltypessmall_hbase_bin
 ---- LABELS
 COLUMN, TYPE, #DISTINCT VALUES, #NULLS, MAX SIZE, AVG SIZE
 ---- RESULTS
-'id','INT',99,-1,4,4
-'bigint_col','BIGINT',10,-1,8,8
-'bool_col','BOOLEAN',2,-1,1,1
-'date_string_col','STRING',12,-1,8,8
-'double_col','DOUBLE',10,-1,8,8
-'float_col','FLOAT',10,-1,4,4
-'int_col','INT',10,-1,4,4
-'month','INT',4,-1,4,4
-'smallint_col','SMALLINT',10,-1,2,2
-'string_col','STRING',10,-1,1,1
-'timestamp_col','TIMESTAMP',100,-1,16,16
-'tinyint_col','TINYINT',10,-1,1,1
-'year','INT',1,-1,4,4
+'id','INT',99,0,4,4
+'bigint_col','BIGINT',10,0,8,8
+'bool_col','BOOLEAN',2,0,1,1
+'date_string_col','STRING',12,0,8,8
+'double_col','DOUBLE',10,0,8,8
+'float_col','FLOAT',10,0,4,4
+'int_col','INT',10,0,4,4
+'month','INT',4,0,4,4
+'smallint_col','SMALLINT',10,0,2,2
+'string_col','STRING',10,0,1,1
+'timestamp_col','TIMESTAMP',100,0,16,16
+'tinyint_col','TINYINT',10,0,1,1
+'year','INT',1,0,4,4
 ---- TYPES
 STRING, STRING, BIGINT, BIGINT, BIGINT, DOUBLE
 ====
@@ -113,7 +113,7 @@ show column stats allcomplextypes_hbase
 ---- LABELS
 COLUMN, TYPE, #DISTINCT VALUES, #NULLS, MAX SIZE, AVG SIZE
 ---- RESULTS
-'id','INT',0,-1,4,4
+'id','INT',0,0,4,4
 'array_array_col','ARRAY<ARRAY<INT>>',-1,-1,-1,-1
 'array_map_col','MAP<STRING,ARRAY<INT>>',-1,-1,-1,-1
 'complex_nested_struct_col','STRUCT<f1:INT,f2:ARRAY<STRUCT<f11:BIGINT,f12:MAP<STRING,STRUCT<f21:BIGINT>>>>>',-1,-1,-1,-1
@@ -123,11 +123,11 @@ COLUMN, TYPE, #DISTINCT VALUES, #NULLS, MAX SIZE, AVG SIZE
 'int_struct_col','STRUCT<f1:INT,f2:INT>',-1,-1,-1,-1
 'map_array_col','ARRAY<MAP<STRING,INT>>',-1,-1,-1,-1
 'map_map_col','MAP<STRING,MAP<STRING,INT>>',-1,-1,-1,-1
-'month','INT',0,-1,4,4
+'month','INT',0,0,4,4
 'nested_struct_col','STRUCT<f1:INT,f2:STRUCT<f11:BIGINT,f12:STRUCT<f21:BIGINT>>>',-1,-1,-1,-1
 'struct_array_col','ARRAY<STRUCT<f1:BIGINT,f2:STRING>>',-1,-1,-1,-1
 'struct_map_col','MAP<STRING,STRUCT<f1:BIGINT,f2:STRING>>',-1,-1,-1,-1
-'year','INT',0,-1,4,4
+'year','INT',0,0,4,4
 ---- TYPES
 STRING, STRING, BIGINT, BIGINT, BIGINT, DOUBLE
-====
+====
\ No newline at end of file