Re: Any Scenarios in which Views impose performance penalties

2013-08-20 Thread Stephen Boesch
Thanks for the inputs Edward and Ricky. I did look at the relevant source code on the version we are using 0.9 and it does not appear there would be any impact of views on the underlying sql - it does column aliasing and checks that the query partition columns match partition columns of the under

Re: Any Scenarios in which Views impose performance penalties

2013-08-20 Thread Ricky Saltzer
My apologies, being on both a Hive and Impala mailing list can be confusing ;). On Tue, Aug 20, 2013 at 10:40 PM, Edward Capriolo wrote: > Views are logical . The view is compiled and has no penalty over the > standard query. > > > On Tuesday, August 20, 2013, Ricky Saltzer wrote: > > Since thi

Re: Any Scenarios in which Views impose performance penalties

2013-08-20 Thread Edward Capriolo
Views are logical . The view is compiled and has no penalty over the standard query. On Tuesday, August 20, 2013, Ricky Saltzer wrote: > Since this bug was in Impala's query planner, I'm sure Hive is unaffected. > > On Aug 20, 2013 10:15 PM, "Stephen Boesch" wrote: >> >> Thanks v much Ricky. Is

Re: Any Scenarios in which Views impose performance penalties

2013-08-20 Thread Ricky Saltzer
Since this bug was in Impala's query planner, I'm sure Hive is unaffected. On Aug 20, 2013 10:15 PM, "Stephen Boesch" wrote: > > Thanks v much Ricky. Is this fixed in hive 0.11 - or going to be later > i.e. 0.12? > > > 2013/8/20 Ricky Saltzer > >> Although this is already fixed in the next and

Re: Any Scenarios in which Views impose performance penalties

2013-08-20 Thread Stephen Boesch
Thanks v much Ricky. Is this fixed in hive 0.11 - or going to be later i.e. 0.12? 2013/8/20 Ricky Saltzer > Although this is already fixed in the next and upcoming impala release, > you might want to be aware of the following view limitation. > > https://issues.cloudera.org/browse/IMPALA-495 >

Re: Any Scenarios in which Views impose performance penalties

2013-08-20 Thread Ricky Saltzer
Although this is already fixed in the next and upcoming impala release, you might want to be aware of the following view limitation. https://issues.cloudera.org/browse/IMPALA-495 On Aug 20, 2013 7:16 PM, "Stephen Boesch" wrote: > Views should theoretically not incur performance penalties: they s

Any Scenarios in which Views impose performance penalties

2013-08-20 Thread Stephen Boesch
Views should theoretically not incur performance penalties: they simply represent queries. Are there situtions that things are "not that simple" - i.e. views may actually result in different exeucution plans than the underlying sql? Additionally, are there views-related bugs that we should be awar