miklosgergely commented on a change in pull request #813: HIVE-22323 Fix Desc
Table bugs
URL: https://github.com/apache/hive/pull/813#discussion_r334364791
##########
File path: ql/src/test/results/clientpositive/beeline/colstats_all_nulls.q.out
##########
@@ -43,38 +43,38 @@ PREHOOK: Input: default@all_nulls
POSTHOOK: query: describe formatted all_nulls a
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@all_nulls
-col_name a NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL
-data_type bigint NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL
-min 0 NULL NULL NULL NULL NULL NULL NULL NULL
NULL NULL
-max 0 NULL NULL NULL NULL NULL NULL NULL NULL
NULL NULL
-num_nulls 5 NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL
-distinct_count 1 NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL
-avg_col_len NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL
-max_col_len NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL
-num_trues NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL
-num_falses NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL
-bitVector HL NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL
-comment from deserializer NULL NULL NULL NULL NULL
NULL NULL NULL NULL NULL
-COLUMN_STATS_ACCURATE
{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"a\":\"true\",\"b\":\"true\",\"c\":\"true\"}}
NULL NULL NULL NULL NULL NULL NULL NULL NULL
NULL
+col_name a
+data_type bigint
+min 0
+max 0
+num_nulls 5
+distinct_count 1
+avg_col_len
+max_col_len
+num_trues
+num_falses
+bit_vector HL
+comment from deserializer
+COLUMN_STATS_ACCURATE
{\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"a\":\"true\",\"b\":\"true\",\"c\":\"true\"}}
PREHOOK: query: describe formatted all_nulls b
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@all_nulls
POSTHOOK: query: describe formatted all_nulls b
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@all_nulls
-col_name b NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL
Review comment:
Yes. It was because the program has applied the long, detailed header for
formatted desc for column data. These tables have 12 data, but they are
transposed, so at the end they have only 2 columns. Still they were given the
schema containing the 12 columns at the fetch task, which led to these tables
with many empty columns. It was fixed in this patch.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
