[ https://issues.apache.org/jira/browse/HIVE-13010?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15133994#comment-15133994 ]
Gopal V commented on HIVE-13010: -------------------------------- [~zstan]: This is expected, because of unix_timestamp() - that is *NOT* constant folded at compile time. > 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)