You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Manish Sharma <ma...@gmail.com> on 2017/01/28 21:44:05 UTC

Re: Table not found in the definition of view

unsubscribe

On Thu, Dec 1, 2016 at 3:36 AM, Furcy Pin <fu...@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
>>
>
>

Re: Table not found in the definition of view

Posted by Lefty Leverenz <le...@gmail.com>.

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 <ma...@gmail.com> wrote:

> unsubscribe
>
> On Thu, Dec 1, 2016 at 3:36 AM, Furcy Pin <fu...@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
>>>
>>
>>
>