Thomas Rebele created HIVE-29275:
------------------------------------

             Summary: Stats autogather calculates the min statistic incorrectly
                 Key: HIVE-29275
                 URL: https://issues.apache.org/jira/browse/HIVE-29275
             Project: Hive
          Issue Type: Bug
            Reporter: Thomas Rebele


 In stats_histogram.q autogather gets enabled and then rows are inserted into a 
newly created table. The minimum value for column e is 
[-123.2|https://github.com/apache/hive/blob/55d9ab7d6b00fa510be791b9de55974f61c90519/ql/src/test/queries/clientpositive/stats_histogram.q#L20].
 However, {{DESCRIBE FORMATTED test_stats e}} shows 
[-10.2|https://github.com/apache/hive/blob/55d9ab7d6b00fa510be791b9de55974f61c90519/ql/src/test/results/clientpositive/llap/stats_histogram.q.out#L364]
 as the minimum value.

When executing {{ANALYZE TABLE test_stats COMPUTE STATISTICS FOR COLUMNS;}} 
before the {{DESCRIBE FORMATTED test_stats e}} command, the min value is -123.2 
as expected.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to