CREATE OR REPLACE VIEW and ALTER VIEW not supported
ALTER VIEW and CREATE OR REPLACE VIEW AS commands are no longer supported.
Type of change: Configuration/Spark Core Changes
Spark 1.6
You can create views as follows:
CREATE OR REPLACE [ [ GLOBAL ] TEMPORARY ] VIEW [ IF NOT EXISTS ] view_name [ column_list ] [ COMMENT view_comment ] [ properties ] AS query ALTER VIEW view_name { rename | set_properties | unset_properties | alter_body }
Spark 2.4
ALTER VIEW and CREATE OR REPLACE commands above are not supported.
Action Required
Recreate views using the following syntax:
CREATE [ [ GLOBAL ] TEMPORARY ] VIEW [ IF NOT EXISTS ] view_name [ column_list ] [ COMMENT view_comment ] [ properties ] AS query