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
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
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
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
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
>
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
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