hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Manish Sharma <maa...@gmail.com>
Subject Re: Table not found in the definition of view
Date Sat, 28 Jan 2017 21:44:05 GMT
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