There is no specific restriction against it being a view. You may be hitting a bug. Can you provide more details about the error/SQL?
On 11/8/17, 9:55 PM, "Narendra Singh" <narendra...@gmail.com> wrote: Hello Team, I am doing one poc on SCD concept and trying to solve proble using MERGE concept explained here https://issues.apache.org/jira/browse/HIVE-10924 Wanted to check if source (right side table) can be a View, definition says it is expression or table. in RDBMS world source cab be a view, I tried with view but getting error. please help !!! -- Regards, Narendra Singh