Re: Table not found in the definition of view

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

Re: Table not found in the definition of view

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

Re: Table not found in the definition of view

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 wrote: > Hi All > > > Getting error 'Table not found in the definition of view ' if a view is

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