启动PySpark时HiveSessionStateBuilder实例化失败求助

我最近启动PySpark时一直被这个错误卡着：

pyspark.sql.utils.IllegalArgumentException: u"Error while instantiating 'org.apache.spark.sql.hive.HiveSessionStateBuilder':"

之前碰到类似问题时，我通过设置tmp\hive目录的权限就解决了，但这次不管试了各种方法都没用，实在没辙了，来求助大家。

以下是完整的报错输出：

Python 2.7.13 (v2.7.13:a06454b1afa1, Dec 17 2016, 20:42:59) [MSC v.1500 32 bit (Intel)] on win32
Type "help", "copyright", "credits" or "license" for more information.
Using Spark's default log4j profile: org/apache/spark/log4j-defaults.properties
Setting default log level to "WARN".
To adjust logging level use sc.setLogLevel(newLevel). For SparkR, use setLogLevel(newLevel).
18/01/27 14:24:31 WARN NativeCodeLoader: Unable to load native-hadoop library for your platform... using built in-java classes where applicable
Traceback (most recent call last):
  File "D:\spark-2.2.1-bin-hadoop2.7\spark-2.2.1-bin-hadoop2.7\python\pyspark\shell.py", line 45, in <module>
    spark = SparkSession.builder\
  File "D:\spark-2.2.1-bin-hadoop2.7\spark-2.2.1-bin-hadoop2.7\python\pyspark\sql\session.py", line 183, in getOrCreate
    session._jsparkSession.sessionState().conf().setConfString(key, value)
  File "D:\spark-2.2.1-bin-hadoop2.7\spark-2.2.1-bin-hadoop2.7\python\lib\py4j-0.10.4-src.zip\py4j\java_gateway.py", line 1133, in __call__
  File "D:\spark-2.2.1-bin-hadoop2.7\spark-2.2.1-bin-hadoop2.7\python\pyspark\sql\utils.py", line 79, in deco
    raise IllegalArgumentException(s.split(': ', 1)[1], stackTrace)
pyspark.sql.utils.IllegalArgumentException: u"Error while instantiating 'org.apache.spark.sql.hive.HiveSessionStateBuilder':"

有没有大佬能帮我分析下这次到底是哪里出问题了？

内容的提问来源于stack exchange，提问作者Shubhankar Mayank