hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Furcy Pin <furcy....@flaminem.com>
Subject Re: Table not found in the definition of view
Date Thu, 01 Dec 2016 11:36:50 GMT
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