hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lefty Leverenz <leftylever...@gmail.com>
Subject Re: Table not found in the definition of view
Date Sun, 29 Jan 2017 07:43:39 GMT
Manish, to unsubscribe please send a message to
user-unsubscribe@hive.apache.org as described here:  Mailing Lists
<http://hive.apache.org/mailing_lists.html>.

Thanks.  -- Lefty


On Sat, Jan 28, 2017 at 1:44 PM, Manish Sharma <maaand@gmail.com> wrote:

> unsubscribe
>
> On Thu, Dec 1, 2016 at 3:36 AM, Furcy Pin <furcy.pin@flaminem.com> wrote:
>
>> Hi,
>>
>> you should replace
>>
>> WITH table AS (subquery)
>> SELECT ...
>> FROM table
>>
>> with
>>
>> SELECT ...
>> FROM(
>>   subquery
>> ) table
>>
>> Regards.
>>
>> On Thu, Dec 1, 2016 at 12:32 PM, Priyanka Raghuvanshi <
>> PriyankaR@winjit.com> wrote:
>>
>>> Hi All
>>>
>>>
>>> Getting error 'Table not found in the definition of view ' if a view is
>>> created using 'WITH' clause to use the  result of one query in another.
>>>
>>>
>>> This issue has been resolved for Hive 1.3.0 and 2.0.0 but mine is 0.13
>>>
>>> Regards
>>>
>>> Priyanka Raghuvanshi
>>>
>>
>>
>

Mime
View raw message