Can’t SELECT anything in a AWS Glue Data Catalog view due to invalid view text:
Summary I encountered a critical failure when attempting to query an AWS Glue Data Catalog view from an EMR cluster using Spark SQL. The view, created by a Glue job as a protected multi-dialect view with SECURITY DEFINER, generated an AnalysisException with the error code [INVALID_VIEW_TEXT]. The error explicitly stated that Spark could not display … Read more