Re: Table not found in the definition of view

Manish, to unsubscribe please send a message to user-unsubscr...@hive.apache.org as described here: Mailing Lists . Thanks. -- Lefty On Sat, Jan 28, 2017 at 1:44 PM, Manish Sharma wrote: > unsubscribe > > On Thu, Dec 1, 2016 at 3:36 AM, Furcy Pin w

Re: Table not found in the definition of view

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

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 > created using 'WITH'