Attached screenshot has update commands, with the only difference being one has temp view being used in nested subquery and the other one has normal view used in nested subquery . The one using temp view fails but the one using normal view succeeds. And if we see the error message bein displayed for the first one, it is incorrect as nested subquery is being allowed in the second command . The first command should have shown error as "Error in SQL statement: AnalysisException: Temp Views in Nested subquery is not supported in the UPDATE condition."
