[jira] [Created] (HIVE-7060) Column stats give incorrect min and distinct_count

["Xuefu Zhang (JIRA)" <ji...@apache.org>]

Xuefu Zhang created HIVE-7060:
---------------------------------

             Summary: Column stats give incorrect min and distinct_count
                 Key: HIVE-7060
                 URL: https://issues.apache.org/jira/browse/HIVE-7060
             Project: Hive
          Issue Type: Bug
          Components: Statistics
    Affects Versions: 0.13.0
            Reporter: Xuefu Zhang


It seems that the result from column statistics isn't correct on two measures for numeric columns: min (which is always 0) and distinct count. Here is an example:

{code}
select count(distinct avgTimeOnSite), min(avgTimeO from UserVisits_web_text_nonenSite) from UserVisits_web_text_none;
...
OK
9	1
Time taken: 9.747 seconds, Fetched: 1 row(s)
(code}

The statisitics for the column:
{code}
PREHOOK: query: desc formatted UserVisits_web_text_none avgTimeOnSite
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@uservisits_web_text_none
POSTHOOK: query: desc formatted UserVisits_web_text_none avgTimeOnSite
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@uservisits_web_text_none
# col_name              data_type               min                     max                     num_nulls               distinct_count          avg_col_len             max_col_len             num_trues               num_falses              comment

avgTimeOnSite           int                     0                       9                       0                       11                      null                    null                    null               
{code}



--
This message was sent by Atlassian JIRA
(v6.2#6252)