spark报错：CREATE TEMPORARY TABLE

异常信息：

2022-02-09 03:14:01 INFO Error in query:
2022-02-09 03:14:01 INFO CREATE TEMPORARY TABLE is not supported yet. Please use CREATE TEMPORARY VIEW as an alternative.(line 3, pos 4)
2022-02-09 03:14:01 INFO 
2022-02-09 03:14:01 INFO == SQL ==
2022-02-09 03:14:01 INFO 
2022-02-09 03:14:01 INFO 
2022-02-09 03:14:01 INFO create temporary table temp_app_jx_official_vender_d_0 as
2022-02-09 03:14:01 INFO ----^^^
2022-02-09 03:14:01 INFO SELECT

解决方案：

方案一：请使用CREATE TEMPORARY VIEW语法

方案二：升级至spark3.0版本，并且增加参数spark.sql.legacy.hive.tmpTable=true