hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Stanilovsky Evgeny (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-13010) partitions autogenerated predicates broken
Date Fri, 05 Feb 2016 10:49:39 GMT
Stanilovsky Evgeny created HIVE-13010:
-----------------------------------------

             Summary: partitions autogenerated predicates broken
                 Key: HIVE-13010
                 URL: https://issues.apache.org/jira/browse/HIVE-13010
             Project: Hive
          Issue Type: Bug
    Affects Versions: 1.1.0
            Reporter: Stanilovsky Evgeny
            Priority: Trivial


hi, i`m looking for simalar problem but found only:
https://issues.apache.org/jira/browse/HIVE-9630
it`s looks like the same but you can easily repeat it on testing i hope.
I have two simalar requests , the difference in autogenerated data predicates, in first case
explain show ful lscan.
'''
set hive.optimize.constant.propagation=true;
explain select * from logs.weather_forecasts where dt between
from_unixtime(unix_timestamp() - 3600*24*3, 'yyyy-MM-dd') and
from_unixtime(unix_timestamp() - 3600*24*1, 'yyyy-MM-dd') and
provider_id = 100

STAGE PLANS:
5	  Stage: Stage-1
6	    Map Reduce
7	      Map Operator Tree:
8	          TableScan
9	            alias: weather_forecasts
10	            Statistics: Num rows: 36124837607 Data size: 47395787122046 Basic stats: PARTIAL
Column stats: NONE
''''
and
''''
set hive.optimize.constant.propagation=true;
explain select * from logs.redir_log where dt between
'2016-02-02' and
'2016-02-04' and
pid = 100

0	STAGE DEPENDENCIES:
1	  Stage-1 is a root stage
2	  Stage-0 depends on stages: Stage-1
3	
4	STAGE PLANS:
5	  Stage: Stage-1
6	    Map Reduce
7	      Map Operator Tree:
8	          TableScan
9	            alias: redir_log
10	            Statistics: Num rows: 2798358420 Data size: 5761819991150 Basic stats: COMPLETE
Column stats: NONE
''''



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

Mime
View raw message