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