If a view has errors, the way to determine what is causing the error is to run the following syntax:

show errors view VIEW_NAME;


The result will indicate what is causing the error in the view.