unsubscribe On Thu, Dec 1, 2016 at 3:36 AM, Furcy Pin <furcy....@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 < > 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 >> > >