You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Stanilovsky Evgeny (JIRA)" <ji...@apache.org> on 2016/02/05 11:49:39 UTC
[jira] [Created] (HIVE-13010) partitions autogenerated predicates
broken
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)