hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gopal V (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-13010) partitions autogenerated predicates broken
Date Fri, 05 Feb 2016 21:56:40 GMT

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

Gopal V commented on HIVE-13010:
--------------------------------

I have a backport to 1.0 

https://github.com/t3rmin4t0r/current-timestamp/blob/master/src/main/java/org/notmysock/hive/udf/CurrentTimeStampUDF.java

> 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