hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ricky Saltzer <ri...@cloudera.com>
Subject Re: Any Scenarios in which Views impose performance penalties
Date Wed, 21 Aug 2013 02:18:53 GMT
Since this bug was in Impala's query planner, I'm sure Hive is unaffected.
On Aug 20, 2013 10:15 PM, "Stephen Boesch" <javadba@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 <ricky@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.
>>
>> https://issues.cloudera.org/browse/IMPALA-495
>> On Aug 20, 2013 7:16 PM, "Stephen Boesch" <javadba@gmail.com> wrote:
>>
>>> 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 of
>>> that would limit the occasions that we could use them?
>>>
>>> Thanks for the pointers.
>>>
>>>
>>>
>

Mime
View raw message