You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by px...@apache.org on 2017/07/25 22:42:10 UTC
[07/11] hive git commit: HIVE-16997: Extend object store to store and
use bit vectors (Pengcheng Xiong, reviewed by Ashutosh Chauhan)
http://git-wip-us.apache.org/repos/asf/hive/blob/f8b79fe6/ql/src/test/results/clientpositive/alter_table_update_status.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/alter_table_update_status.q.out b/ql/src/test/results/clientpositive/alter_table_update_status.q.out
index 9cd9a8d..f23ba57 100644
--- a/ql/src/test/results/clientpositive/alter_table_update_status.q.out
+++ b/ql/src/test/results/clientpositive/alter_table_update_status.q.out
@@ -46,10 +46,12 @@ PREHOOK: Input: default@src_stat
POSTHOOK: query: describe formatted src_stat key
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@src_stat
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-key string 0 16 1.72 3 from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"key\":\"true\"}}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+key string 0 16 1.72 3 SExM4BAQgaTbFYDg/BOBktRrv6WcHMDErSCAotAegLu2HIHRunr/p8hhwLbpSsD22ZgBgdS9KMHV
+myn/wfcugOGjfsCYzA0=
+ from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"key\":\"true\"}}
PREHOOK: query: ALTER TABLE src_stat UPDATE STATISTICS for column key SET ('numDVs'='1111','avgColLen'='1.111')
PREHOOK: type: ALTERTABLE_UPDATETABLESTATS
POSTHOOK: query: ALTER TABLE src_stat UPDATE STATISTICS for column key SET ('numDVs'='1111','avgColLen'='1.111')
@@ -60,10 +62,12 @@ PREHOOK: Input: default@src_stat
POSTHOOK: query: describe formatted src_stat key
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@src_stat
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-key string 0 1111 1.111 3 from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"key\":\"true\"}}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+key string 0 1111 1.111 3 SExM4BAQgaTbFYDg/BOBktRrv6WcHMDErSCAotAegLu2HIHRunr/p8hhwLbpSsD22ZgBgdS9KMHV
+myn/wfcugOGjfsCYzA0=
+ from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"key\":\"true\"}}
PREHOOK: query: ALTER TABLE src_stat UPDATE STATISTICS for column value SET ('numDVs'='121','numNulls'='122','avgColLen'='1.23','maxColLen'='124')
PREHOOK: type: ALTERTABLE_UPDATETABLESTATS
POSTHOOK: query: ALTER TABLE src_stat UPDATE STATISTICS for column value SET ('numDVs'='121','numNulls'='122','avgColLen'='1.23','maxColLen'='124')
@@ -74,10 +78,10 @@ PREHOOK: Input: default@src_stat
POSTHOOK: query: describe formatted src_stat value
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@src_stat
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-value string 122 121 1.23 124 from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"key\":\"true\",\"value\":\"true\"}}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+value string 122 121 1.23 124 from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"key\":\"true\",\"value\":\"true\"}}
PREHOOK: query: ANALYZE TABLE src_stat_int COMPUTE STATISTICS for columns key
PREHOOK: type: QUERY
PREHOOK: Input: default@src_stat_int
@@ -92,10 +96,12 @@ PREHOOK: Input: default@src_stat_int
POSTHOOK: query: describe formatted src_stat_int key
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@src_stat_int
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-key double 66.0 406.0 10 15 from deserializer
-COLUMN_STATS_ACCURATE {\"COLUMN_STATS\":{\"key\":\"true\"}}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+key double 66.0 406.0 10 15 SExM4A8PgZLrJoLyx3uBrPspvqnUPoHIoA/+prAWgPaQT4Du5BLDosR5vZLrGIDtbYDVh+QBwKHW
+UIOz9UG+ouNE
+ from deserializer
+COLUMN_STATS_ACCURATE {\"COLUMN_STATS\":{\"key\":\"true\"}}
PREHOOK: query: ALTER TABLE src_stat_int UPDATE STATISTICS for column key SET ('numDVs'='2222','lowValue'='333.22','highValue'='22.22')
PREHOOK: type: ALTERTABLE_UPDATETABLESTATS
POSTHOOK: query: ALTER TABLE src_stat_int UPDATE STATISTICS for column key SET ('numDVs'='2222','lowValue'='333.22','highValue'='22.22')
@@ -106,10 +112,12 @@ PREHOOK: Input: default@src_stat_int
POSTHOOK: query: describe formatted src_stat_int key
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@src_stat_int
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-key double 333.22 22.22 10 2222 from deserializer
-COLUMN_STATS_ACCURATE {\"COLUMN_STATS\":{\"key\":\"true\"}}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+key double 333.22 22.22 10 2222 SExM4A8PgZLrJoLyx3uBrPspvqnUPoHIoA/+prAWgPaQT4Du5BLDosR5vZLrGIDtbYDVh+QBwKHW
+UIOz9UG+ouNE
+ from deserializer
+COLUMN_STATS_ACCURATE {\"COLUMN_STATS\":{\"key\":\"true\"}}
PREHOOK: query: create database if not exists dummydb
PREHOOK: type: CREATEDATABASE
PREHOOK: Output: database:dummydb
@@ -132,10 +140,12 @@ PREHOOK: Input: default@src_stat
POSTHOOK: query: describe formatted default.src_stat key
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@src_stat
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-key string 0 3333 2.222 3 from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"key\":\"true\",\"value\":\"true\"}}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+key string 0 3333 2.222 3 SExM4BAQgaTbFYDg/BOBktRrv6WcHMDErSCAotAegLu2HIHRunr/p8hhwLbpSsD22ZgBgdS9KMHV
+myn/wfcugOGjfsCYzA0=
+ from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"key\":\"true\",\"value\":\"true\"}}
PREHOOK: query: ALTER TABLE default.src_stat UPDATE STATISTICS for column value SET ('numDVs'='232','numNulls'='233','avgColLen'='2.34','maxColLen'='235')
PREHOOK: type: ALTERTABLE_UPDATETABLESTATS
POSTHOOK: query: ALTER TABLE default.src_stat UPDATE STATISTICS for column value SET ('numDVs'='232','numNulls'='233','avgColLen'='2.34','maxColLen'='235')
@@ -146,10 +156,10 @@ PREHOOK: Input: default@src_stat
POSTHOOK: query: describe formatted default.src_stat value
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@src_stat
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-value string 233 232 2.34 235 from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"key\":\"true\",\"value\":\"true\"}}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+value string 233 232 2.34 235 from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"key\":\"true\",\"value\":\"true\"}}
PREHOOK: query: use default
PREHOOK: type: SWITCHDATABASE
PREHOOK: Input: database:default
@@ -246,140 +256,140 @@ PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats s
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-s smallint from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+s smallint from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
PREHOOK: query: DESC FORMATTED datatype_stats i
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats i
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-i int from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+i int from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
PREHOOK: query: DESC FORMATTED datatype_stats b
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats b
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-b bigint from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+b bigint from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
PREHOOK: query: DESC FORMATTED datatype_stats f
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats f
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-f float from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+f float from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
PREHOOK: query: DESC FORMATTED datatype_stats d
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats d
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-d double from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+d double from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
PREHOOK: query: DESC FORMATTED datatype_stats dem
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats dem
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-dem decimal(10,0) from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+dem decimal(10,0) from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
PREHOOK: query: DESC FORMATTED datatype_stats ts
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats ts
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-ts timestamp from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+ts timestamp from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
PREHOOK: query: DESC FORMATTED datatype_stats dt
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats dt
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-dt date from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+dt date from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
PREHOOK: query: DESC FORMATTED datatype_stats str
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats str
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-str string from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+str string from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
PREHOOK: query: DESC FORMATTED datatype_stats v
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats v
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-v varchar(12) from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+v varchar(12) from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
PREHOOK: query: DESC FORMATTED datatype_stats c
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats c
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-c char(5) from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+c char(5) from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
PREHOOK: query: DESC FORMATTED datatype_stats bl
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats bl
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-bl boolean from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+bl boolean from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
PREHOOK: query: DESC FORMATTED datatype_stats bin
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats bin
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-bin binary from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+bin binary from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
PREHOOK: query: DESC FORMATTED datatype_stats t
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats t
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-t tinyint from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+t tinyint from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"}
PREHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for column t SET ('numDVs'='232','numNulls'='233','highValue'='234','lowValue'='35')
PREHOOK: type: ALTERTABLE_UPDATETABLESTATS
POSTHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for column t SET ('numDVs'='232','numNulls'='233','highValue'='234','lowValue'='35')
@@ -390,20 +400,20 @@ PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats t
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-t tinyint 35 234 233 232 from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"t\":\"true\"}}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+t tinyint 35 234 233 232 from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"t\":\"true\"}}
PREHOOK: query: DESC FORMATTED datatype_stats s
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats s
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-s smallint from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"t\":\"true\"}}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+s smallint from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"t\":\"true\"}}
PREHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for column s SET ('numDVs'='56','numNulls'='56','highValue'='489','lowValue'='25')
PREHOOK: type: ALTERTABLE_UPDATETABLESTATS
POSTHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for column s SET ('numDVs'='56','numNulls'='56','highValue'='489','lowValue'='25')
@@ -414,20 +424,20 @@ PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats s
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-s smallint 25 489 56 56 from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"s\":\"true\",\"t\":\"true\"}}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+s smallint 25 489 56 56 from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"s\":\"true\",\"t\":\"true\"}}
PREHOOK: query: DESC FORMATTED datatype_stats i
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats i
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-i int from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"s\":\"true\",\"t\":\"true\"}}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+i int from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"s\":\"true\",\"t\":\"true\"}}
PREHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for column i SET ('numDVs'='59','numNulls'='1','highValue'='889','lowValue'='5')
PREHOOK: type: ALTERTABLE_UPDATETABLESTATS
POSTHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for column i SET ('numDVs'='59','numNulls'='1','highValue'='889','lowValue'='5')
@@ -438,20 +448,20 @@ PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats i
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-i int 5 889 1 59 from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"i\":\"true\",\"s\":\"true\",\"t\":\"true\"}}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+i int 5 889 1 59 from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"i\":\"true\",\"s\":\"true\",\"t\":\"true\"}}
PREHOOK: query: DESC FORMATTED datatype_stats b
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats b
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-b bigint from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"i\":\"true\",\"s\":\"true\",\"t\":\"true\"}}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+b bigint from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"i\":\"true\",\"s\":\"true\",\"t\":\"true\"}}
PREHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for column b SET ('numDVs'='9','numNulls'='14','highValue'='89','lowValue'='8')
PREHOOK: type: ALTERTABLE_UPDATETABLESTATS
POSTHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for column b SET ('numDVs'='9','numNulls'='14','highValue'='89','lowValue'='8')
@@ -462,20 +472,20 @@ PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats b
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-b bigint 8 89 14 9 from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"i\":\"true\",\"s\":\"true\",\"t\":\"true\"}}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+b bigint 8 89 14 9 from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"i\":\"true\",\"s\":\"true\",\"t\":\"true\"}}
PREHOOK: query: DESC FORMATTED datatype_stats f
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats f
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-f float from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"i\":\"true\",\"s\":\"true\",\"t\":\"true\"}}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+f float from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"i\":\"true\",\"s\":\"true\",\"t\":\"true\"}}
PREHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for column f SET ('numDVs'='563','numNulls'='45','highValue'='2345.656','lowValue'='8.00')
PREHOOK: type: ALTERTABLE_UPDATETABLESTATS
POSTHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for column f SET ('numDVs'='563','numNulls'='45','highValue'='2345.656','lowValue'='8.00')
@@ -486,20 +496,20 @@ PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats f
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-f float 8.0 2345.656 45 563 from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"t\":\"true\"}}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+f float 8.0 2345.656 45 563 from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"t\":\"true\"}}
PREHOOK: query: DESC FORMATTED datatype_stats d
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats d
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-d double from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"t\":\"true\"}}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+d double from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"t\":\"true\"}}
PREHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for column d SET ('numDVs'='5677','numNulls'='12','highValue'='560.3367','lowValue'='0.00455')
PREHOOK: type: ALTERTABLE_UPDATETABLESTATS
POSTHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for column d SET ('numDVs'='5677','numNulls'='12','highValue'='560.3367','lowValue'='0.00455')
@@ -510,20 +520,20 @@ PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats d
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-d double 0.00455 560.3367 12 5677 from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"d\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"t\":\"true\"}}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+d double 0.00455 560.3367 12 5677 from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"d\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"t\":\"true\"}}
PREHOOK: query: DESC FORMATTED datatype_stats dem
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats dem
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-dem decimal(10,0) from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"d\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"t\":\"true\"}}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+dem decimal(10,0) from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"d\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"t\":\"true\"}}
PREHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for column dem SET ('numDVs'='57','numNulls'='912','highValue'='560','lowValue'='0')
PREHOOK: type: ALTERTABLE_UPDATETABLESTATS
POSTHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for column dem SET ('numDVs'='57','numNulls'='912','highValue'='560','lowValue'='0')
@@ -534,20 +544,20 @@ PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats dem
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-dem decimal(10,0) 0 560 912 57 from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"t\":\"true\"}}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+dem decimal(10,0) 0 560 912 57 from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"t\":\"true\"}}
PREHOOK: query: DESC FORMATTED datatype_stats ts
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats ts
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-ts timestamp from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"t\":\"true\"}}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+ts timestamp from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"t\":\"true\"}}
PREHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for column ts SET ('numDVs'='7','numNulls'='12','highValue'='1357030923','lowValue'='1357030924')
PREHOOK: type: ALTERTABLE_UPDATETABLESTATS
POSTHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for column ts SET ('numDVs'='7','numNulls'='12','highValue'='1357030923','lowValue'='1357030924')
@@ -558,20 +568,20 @@ PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats ts
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-ts timestamp 1357030924 1357030923 12 7 from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"t\":\"true\",\"ts\":\"true\"}}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+ts timestamp 1357030924 1357030923 12 7 from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"t\":\"true\",\"ts\":\"true\"}}
PREHOOK: query: DESC FORMATTED datatype_stats dt
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats dt
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-dt date from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"t\":\"true\",\"ts\":\"true\"}}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+dt date from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"t\":\"true\",\"ts\":\"true\"}}
PREHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for column dt SET ('numDVs'='57','numNulls'='912','highValue'='2012-01-01','lowValue'='2001-02-04')
PREHOOK: type: ALTERTABLE_UPDATETABLESTATS
POSTHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for column dt SET ('numDVs'='57','numNulls'='912','highValue'='2012-01-01','lowValue'='2001-02-04')
@@ -582,20 +592,20 @@ PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats dt
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-dt date 2001-02-04 2012-01-01 912 57 from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"dt\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"t\":\"true\",\"ts\":\"true\"}}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+dt date 2001-02-04 2012-01-01 912 57 from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"dt\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"t\":\"true\",\"ts\":\"true\"}}
PREHOOK: query: DESC FORMATTED datatype_stats str
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats str
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-str string from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"dt\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"t\":\"true\",\"ts\":\"true\"}}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+str string from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"dt\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"t\":\"true\",\"ts\":\"true\"}}
PREHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for column str SET ('numDVs'='232','numNulls'='233','avgColLen'='2.34','maxColLen'='235')
PREHOOK: type: ALTERTABLE_UPDATETABLESTATS
POSTHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for column str SET ('numDVs'='232','numNulls'='233','avgColLen'='2.34','maxColLen'='235')
@@ -606,20 +616,20 @@ PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats str
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-str string 233 232 2.34 235 from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"dt\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"str\":\"true\",\"t\":\"true\",\"ts\":\"true\"}}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+str string 233 232 2.34 235 from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"dt\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"str\":\"true\",\"t\":\"true\",\"ts\":\"true\"}}
PREHOOK: query: DESC FORMATTED datatype_stats v
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats v
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-v varchar(12) from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"dt\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"str\":\"true\",\"t\":\"true\",\"ts\":\"true\"}}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+v varchar(12) from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"dt\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"str\":\"true\",\"t\":\"true\",\"ts\":\"true\"}}
PREHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for column v SET ('numDVs'='22','numNulls'='33','avgColLen'='4.40','maxColLen'='25')
PREHOOK: type: ALTERTABLE_UPDATETABLESTATS
POSTHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for column v SET ('numDVs'='22','numNulls'='33','avgColLen'='4.40','maxColLen'='25')
@@ -630,20 +640,20 @@ PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats v
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-v varchar(12) 33 22 4.4 25 from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"dt\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"str\":\"true\",\"t\":\"true\",\"ts\":\"true\",\"v\":\"true\"}}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+v varchar(12) 33 22 4.4 25 from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"dt\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"str\":\"true\",\"t\":\"true\",\"ts\":\"true\",\"v\":\"true\"}}
PREHOOK: query: DESC FORMATTED datatype_stats c
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats c
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-c char(5) from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"dt\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"str\":\"true\",\"t\":\"true\",\"ts\":\"true\",\"v\":\"true\"}}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+c char(5) from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"dt\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"str\":\"true\",\"t\":\"true\",\"ts\":\"true\",\"v\":\"true\"}}
PREHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for column c SET ('numDVs'='2','numNulls'='03','avgColLen'='9.00','maxColLen'='58')
PREHOOK: type: ALTERTABLE_UPDATETABLESTATS
POSTHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for column c SET ('numDVs'='2','numNulls'='03','avgColLen'='9.00','maxColLen'='58')
@@ -654,20 +664,20 @@ PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats c
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-c char(5) 3 2 9.0 58 from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"c\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"dt\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"str\":\"true\",\"t\":\"true\",\"ts\":\"true\",\"v\":\"true\"}}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+c char(5) 3 2 9.0 58 from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"c\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"dt\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"str\":\"true\",\"t\":\"true\",\"ts\":\"true\",\"v\":\"true\"}}
PREHOOK: query: DESC FORMATTED datatype_stats bl
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats bl
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-bl boolean from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"c\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"dt\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"str\":\"true\",\"t\":\"true\",\"ts\":\"true\",\"v\":\"true\"}}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+bl boolean from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"c\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"dt\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"str\":\"true\",\"t\":\"true\",\"ts\":\"true\",\"v\":\"true\"}}
PREHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for column bl SET ('numNulls'='1','numTrues'='9','numFalses'='8')
PREHOOK: type: ALTERTABLE_UPDATETABLESTATS
POSTHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for column bl SET ('numNulls'='1','numTrues'='9','numFalses'='8')
@@ -678,20 +688,20 @@ PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats bl
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-bl boolean 1 9 8 from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"bl\":\"true\",\"c\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"dt\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"str\":\"true\",\"t\":\"true\",\"ts\":\"true\",\"v\":\"true\"}}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+bl boolean 1 9 8 from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"bl\":\"true\",\"c\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"dt\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"str\":\"true\",\"t\":\"true\",\"ts\":\"true\",\"v\":\"true\"}}
PREHOOK: query: DESC FORMATTED datatype_stats bin
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats bin
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-bin binary from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"bl\":\"true\",\"c\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"dt\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"str\":\"true\",\"t\":\"true\",\"ts\":\"true\",\"v\":\"true\"}}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+bin binary from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"bl\":\"true\",\"c\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"dt\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"str\":\"true\",\"t\":\"true\",\"ts\":\"true\",\"v\":\"true\"}}
PREHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for column bin SET ('numNulls'='8','avgColLen'='2.0','maxColLen'='8')
PREHOOK: type: ALTERTABLE_UPDATETABLESTATS
POSTHOOK: query: ALTER TABLE default.datatype_stats UPDATE STATISTICS for column bin SET ('numNulls'='8','avgColLen'='2.0','maxColLen'='8')
@@ -702,7 +712,7 @@ PREHOOK: Input: default@datatype_stats
POSTHOOK: query: DESC FORMATTED datatype_stats bin
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@datatype_stats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment
-
-bin binary 8 2.0 8 from deserializer
-COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"bin\":\"true\",\"bl\":\"true\",\"c\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"dt\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"str\":\"true\",\"t\":\"true\",\"ts\":\"true\",\"v\":\"true\"}}
+# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
+
+bin binary 8 2.0 8 from deserializer
+COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"b\":\"true\",\"bin\":\"true\",\"bl\":\"true\",\"c\":\"true\",\"d\":\"true\",\"dem\":\"true\",\"dt\":\"true\",\"f\":\"true\",\"i\":\"true\",\"s\":\"true\",\"str\":\"true\",\"t\":\"true\",\"ts\":\"true\",\"v\":\"true\"}}