n both the view
and the table shows the analizer does indeed pick up the right partition on
both cases (view and table).
From: Mich Talebzadeh
To: user@hive.apache.org; 'cobby cohen'
Sent: Monday, March 16, 2015 9:36 PM
Subject: RE: view over partitioned table
#yiv36648
]
Sent: 16 March 2015 16:14
To: user@hive.apache.org
Subject: Re: view over partitioned table
hi,
i am using CDH 5.2 (hive 13).
as for partitioned views, to my understanding they are more about abstracting a
non partitioned back end. My questing is related to how and if the query
optimizer can
any responsibility.
From: Moore, Douglas [mailto:douglas.mo...@thinkbiganalytics.com]
Sent: 16 March 2015 14:20
To: user@hive.apache.org; 'cobby cohen'
Subject: Re: view over partitioned table
Mich,
What version of Hive are you running?
Have you seen this?
https://cwiki.apache.org/confl
r multiple
view).Empirical tests, by the show, suggest that indeed, partition optimization
does take place. regards, cobby.
From: "Moore, Douglas"
To: "user@hive.apache.org" ; 'cobby cohen'
Sent: Monday, March 16, 2015 4:19 PM
Subject: Re: view over par
mailto:user@hive.apache.org>>, 'cobby cohen'
mailto:ququr...@yahoo.com>>
Subject: RE: view over partitioned table
OK,
This is the way I read it. Crearte table t1 .. partitioned by date will use
horizontal partitioning as per common with any RDBMS say Oracle.
The view I will create it
hat this email is virus free, therefore neither Peridale
Ltd, its subsidiaries nor their employees accept any responsibility.
From: cobby cohen [mailto:ququr...@yahoo.com]
Sent: 15 March 2015 17:52
To: user@hive.apache.org
Subject: view over partitioned table
in the following ca
in the following case:
create table T1(id string)partitioned by (date date);
create view V1(id, date)select id, date from T1
if i do the followingselect id from V1 where date = '2015-04-04'will the query
optimize on T1's partitioning?
and what if V1 is a bit more complex, further depending on othe
