[
https://issues.apache.org/jira/browse/HIVE-13010?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Stanilovsky Evgeny resolved HIVE-13010.
---------------------------------------
Resolution: Not A Bug
> 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)
