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:
us...@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org
For additional commands, e-mail: gitbox-h...@hive.apache.org

Reply via email to