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 aware
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 java...@gmail.com wrote:
Views should theoretically not incur performance
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 ri...@cloudera.com
Although this is already fixed in the next and upcoming impala release,
you might want to be aware of the following view limitation.
Since this bug was in Impala's query planner, I'm sure Hive is unaffected.
On Aug 20, 2013 10:15 PM, Stephen Boesch java...@gmail.com 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 ri...@cloudera.com
Although this is
Views are logical . The view is compiled and has no penalty over the
standard query.
On Tuesday, August 20, 2013, Ricky Saltzer ri...@cloudera.com 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 java...@gmail.com wrote:
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 edlinuxg...@gmail.comwrote:
Views are logical . The view is compiled and has no penalty over the
standard query.
On Tuesday, August 20, 2013, Ricky Saltzer
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