[jira] [Commented] (HIVE-13010) partitions autogenerated predicates broken

["Gopal V (JIRA)" <ji...@apache.org>]

    [ 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)