The following query returns results
select h.dealer_code from view1 h left outer join view2 i on h.dealer_code = i.dealer_code limit 5;
But the same query with reversed tables order, throws authorization error
select h.dealer_code from view2 h left outer join view1 i on h.dealer_code = i.dealer_code limit 5;
ERROR: AuthorizationException: User 'xx' does not have privileges to access: databse_yy
On checking the logs, it's seen that impala is trying to get write access on the source database databse_yy on which these views are built.
Impala should not need write access to database to just join the views.