[jira] [Commented] (HIVE-19939) Verify any other aggregation functions other than COUNT
[ https://issues.apache.org/jira/browse/HIVE-19939?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16524560#comment-16524560 ] Ashutosh Chauhan commented on HIVE-19939: - [~steveyeom2017] I am not sure what are you asking? But if question is what aggregation queries can be answered using stats then its count, min, max. Also, null count is used. So, count, min, max and null stats can be used by StatsOptimizer to answer queries. > Verify any other aggregation functions other than COUNT > --- > > Key: HIVE-19939 > URL: https://issues.apache.org/jira/browse/HIVE-19939 > Project: Hive > Issue Type: Sub-task > Components: Transactions >Affects Versions: 4.0.0 >Reporter: Steve Yeom >Priority: Major > > 1. More on MAX > I have added MAX query into stats_part.q and stats_nonpart.q but showed a > slightly different > explain.out which might be a bug. > 2. Other functions than MAX and COUNT. > Also I think we need to check other possible aggregation functions than MAX > and COUNT. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-19939) Verify any other aggregation functions other than COUNT
[ https://issues.apache.org/jira/browse/HIVE-19939?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16524347#comment-16524347 ] Steve Yeom commented on HIVE-19939: --- Hi [~ashutoshc] Do you have any comments for this jira. I only added COUNT/MAX aggregation queries to my new stats_nonpart.q, stats_part.q, stats_part2.q. Thank you, Steve. > Verify any other aggregation functions other than COUNT > --- > > Key: HIVE-19939 > URL: https://issues.apache.org/jira/browse/HIVE-19939 > Project: Hive > Issue Type: Sub-task > Components: Transactions >Affects Versions: 4.0.0 >Reporter: Steve Yeom >Priority: Major > > 1. More on MAX > I have added MAX query into stats_part.q and stats_nonpart.q but showed a > slightly different > explain.out which might be a bug. > 2. Other functions than MAX and COUNT. > Also I think we need to check other possible aggregation functions than MAX > and COUNT. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-19939) Verify any other aggregation functions other than COUNT
[ https://issues.apache.org/jira/browse/HIVE-19939?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16524326#comment-16524326 ] Sergey Shelukhin commented on HIVE-19939: - Need to add tests > Verify any other aggregation functions other than COUNT > --- > > Key: HIVE-19939 > URL: https://issues.apache.org/jira/browse/HIVE-19939 > Project: Hive > Issue Type: Sub-task > Components: Transactions >Affects Versions: 4.0.0 >Reporter: Steve Yeom >Priority: Major > > 1. More on MAX > I have added MAX query into stats_part.q and stats_nonpart.q but showed a > slightly different > explain.out which might be a bug. > 2. Other functions than MAX and COUNT. > Also I think we need to check other possible aggregation functions than MAX > and COUNT. -- This message was sent by Atlassian JIRA (v7.6.3#76005)