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
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 as follows:
hive> create view v1 as select * from t1;
OK
Time taken: 0.073 seconds
hive> analyze table t1 par
