[jira] [Commented] (HIVE-13863) Improve AnnotateWithStatistics with support for cartesian product

2016-05-30 Thread Jesus Camacho Rodriguez (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-13863?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15306713#comment-15306713
 ] 

Jesus Camacho Rodriguez commented on HIVE-13863:


{noformat}
Test Name   DurationAge
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_correlationoptimizer5   
12 sec  1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_bucketmapjoin_negative2 
4.5 sec 1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_correlationoptimizer9   
8.6 sec 1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_input23 4 sec   1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_stats11 11 sec  1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_bucket_map_join_1   
2 sec   1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_sort_merge_join_desc_6  
9.6 sec 1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_no_hooks4.5 sec 
1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_join42  26 sec  1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_vector_between_columns  
11 sec  1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_bucketmapjoin2  5.9 sec 
1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_mapjoin14.6 sec 
1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_bucketmapjoin10 7.5 sec 
1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_bucketmapjoin12 8.9 sec 
1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_bucketmapjoin3  5.9 sec 
1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_bucketcontext_2 5.5 sec 
1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_bucketmapjoin_negative  
4.6 sec 1
 
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_subquery_unqualcolumnrefs
   5.7 sec 1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_cbo_rp_join116 sec  
1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_subquery_views  51 sec  
1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_ppd_outer_join5 4.4 sec 
1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_correlationoptimizer15  
7.7 sec 1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_skewjoin1 min 
19 sec1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_correlationoptimizer4   
8.2 sec 1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_correlationoptimizer10  
6.6 sec 1
 
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_cbo_rp_cross_product_check_2
8 sec   1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_bucketmapjoin1  1.6 sec 
1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_pointlookup219 sec  
1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_correlationoptimizer11  
13 sec  1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_constprog2  3 sec   
1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_sortmerge_join_11  
14 sec  1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_join_cond_pushdown_3
4.7 sec 1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_join26  1.1 sec 1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_select_transform_hint   
0.73 sec1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_parallel_join0  18 sec  
1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_sort_merge_join_desc_4  
5.6 sec 1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_complex_alias   9.6 sec 
1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_smb_mapjoin_25  9.7 sec 
1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_mapjoin_distinct
6.6 sec 1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_correlationoptimizer7   
6.9 sec 1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_subquery_multiinsert
21 sec  1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_constprog_partitioner   
7.3 sec 1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_join37  0.7 sec 1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_sort_merge_join_desc_7  
22 sec  1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_pointlookup316 sec  
1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_correlationoptimizer1   
6.4 sec 1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_bucketcontext_4 15 sec  
1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_correlationoptimizer6   
13 sec  1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_join36  6.4 sec 1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_bucketmapjoin13 11 sec  
1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_cross_product_check_1   
9.5 sec 1
 
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_join_cond_pushdown_unqual3
  5.6 sec 1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_correlationoptimizer2   
11 sec  1
 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_smb_mapjoin_14  32

[jira] [Commented] (HIVE-13863) Improve AnnotateWithStatistics with support for cartesian product

2016-05-26 Thread Ashutosh Chauhan (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-13863?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15303227#comment-15303227
 ] 

Ashutosh Chauhan commented on HIVE-13863:
-

+1 I am assuming it probably require updating few other golden files as well.

> Improve AnnotateWithStatistics with support for cartesian product
> -
>
> Key: HIVE-13863
> URL: https://issues.apache.org/jira/browse/HIVE-13863
> Project: Hive
>  Issue Type: Bug
>  Components: Statistics
>Affects Versions: 2.1.0
>Reporter: Jesus Camacho Rodriguez
>Assignee: Jesus Camacho Rodriguez
> Attachments: HIVE-13863.patch
>
>
> Currently cartesian product stats based on cardinality of inputs are not 
> inferred correctly.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)