Sergey Shelukhin created HIVE-19326: ---------------------------------------
Summary: union_fast_stats golden file has incorrect "accurate" stats Key: HIVE-19326 URL: https://issues.apache.org/jira/browse/HIVE-19326 Project: Hive Issue Type: Bug Reporter: Sergey Shelukhin Assignee: Ashutosh Chauhan Found when investigating results change after converting tables to MM, turns out the MM result is correct but the current one is not. The test ends like so: {noformat} desc formatted small_alltypesorc_a; ANALYZE TABLE small_alltypesorc_a COMPUTE STATISTICS; desc formatted small_alltypesorc_a; insert into table small_alltypesorc_a select * from small_alltypesorc1a; desc formatted small_alltypesorc_a; {noformat} The results from the descs in the golden file are: {noformat} COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} numFiles 1 numRows 5 ... COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} numFiles 1 numRows 15 ... COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} numFiles 2 numRows 20 {noformat} Note the result change after analyze - the original nomRows is inaccurate, but BASIC_STATS is set to true. I am assuming with metadata only optimization this can produce incorrect results. -- This message was sent by Atlassian JIRA (v7.6.3#76005)