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

Posted to user@hive.apache.org by Priyanka Raghuvanshi <Pr...@winjit.com> on 2016/12/01 11:32:53 UTC

Table not found in the definition of view

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

Re: Table not found in the definition of view

Posted by Manish Sharma <ma...@gmail.com>.

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 Furcy Pin <fu...@flaminem.com>.

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 <Pr...@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
>