Author: gunther
Date: Tue Jul 29 22:25:20 2014
New Revision: 1614504

URL: http://svn.apache.org/r1614504
Log:
HIVE-7535: Make use of number of nulls column statistics in filter rule 
(Prasanth J via Gunther Hagleitner)

Modified:
    
hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/optimizer/stats/annotation/StatsRulesProcFactory.java
    hive/trunk/ql/src/test/results/clientpositive/annotate_stats_filter.q.out
    hive/trunk/ql/src/test/results/clientpositive/annotate_stats_join.q.out
    hive/trunk/ql/src/test/results/clientpositive/metadataonly1.q.out
    hive/trunk/ql/src/test/results/clientpositive/tez/metadataonly1.q.out

Modified: 
hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/optimizer/stats/annotation/StatsRulesProcFactory.java
URL: 
http://svn.apache.org/viewvc/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/optimizer/stats/annotation/StatsRulesProcFactory.java?rev=1614504&r1=1614503&r2=1614504&view=diff
==============================================================================
--- 
hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/optimizer/stats/annotation/StatsRulesProcFactory.java
 (original)
+++ 
hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/optimizer/stats/annotation/StatsRulesProcFactory.java
 Tue Jul 29 22:25:20 2014
@@ -401,7 +401,6 @@ public class StatsRulesProcFactory {
 
       long numRows = stats.getNumRows();
 
-      // evaluate similar to "col = constant" expr
       if (pred instanceof ExprNodeGenericFuncDesc) {
 
         ExprNodeGenericFuncDesc genFunc = (ExprNodeGenericFuncDesc) pred;
@@ -413,9 +412,7 @@ public class StatsRulesProcFactory {
             String tabAlias = colDesc.getTabAlias();
             ColStatistics cs = stats.getColumnStatisticsForColumn(tabAlias, 
colName);
             if (cs != null) {
-              long dvs = cs.getCountDistint();
-              numRows = dvs == 0 ? numRows / 2 : numRows / dvs;
-              return numRows;
+              return cs.getNumNulls();
             }
           }
         }

Modified: 
hive/trunk/ql/src/test/results/clientpositive/annotate_stats_filter.q.out
URL: 
http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/annotate_stats_filter.q.out?rev=1614504&r1=1614503&r2=1614504&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/annotate_stats_filter.q.out 
(original) and 
hive/trunk/ql/src/test/results/clientpositive/annotate_stats_filter.q.out Tue 
Jul 29 22:25:20 2014 differ

Modified: 
hive/trunk/ql/src/test/results/clientpositive/annotate_stats_join.q.out
URL: 
http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/annotate_stats_join.q.out?rev=1614504&r1=1614503&r2=1614504&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/annotate_stats_join.q.out 
(original) and 
hive/trunk/ql/src/test/results/clientpositive/annotate_stats_join.q.out Tue Jul 
29 22:25:20 2014 differ

Modified: hive/trunk/ql/src/test/results/clientpositive/metadataonly1.q.out
URL: 
http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/metadataonly1.q.out?rev=1614504&r1=1614503&r2=1614504&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/metadataonly1.q.out 
(original) and 
hive/trunk/ql/src/test/results/clientpositive/metadataonly1.q.out Tue Jul 29 
22:25:20 2014 differ

Modified: hive/trunk/ql/src/test/results/clientpositive/tez/metadataonly1.q.out
URL: 
http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/metadataonly1.q.out?rev=1614504&r1=1614503&r2=1614504&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/tez/metadataonly1.q.out 
(original) and 
hive/trunk/ql/src/test/results/clientpositive/tez/metadataonly1.q.out Tue Jul 
29 22:25:20 2014 differ


Reply via email to