Please make sure that jars for your version of hive and hadoop are included in the paths passed to s

问题：

Exception in thread "main" java.lang.IllegalArgumentException: Error while instantiating 'org.apache.spark.sql.hive.HiveSessionState':
    at org.apache.spark.sql.SparkSession$.org$apache$spark$sql$SparkSession$$reflect(SparkSession.scala:981)
    at org.apache.spark.sql.SparkSession.sessionState$lzycompute(SparkSession.scala:110)
    at org.apache.spark.sql.SparkSession.sessionState(SparkSession.scala:109)
    at org.apache.spark.sql.SparkSession$Builder$$anonfun$getOrCreate$5.apply(SparkSession.scala:878)
    at org.apache.spark.sql.SparkSession$Builder$$anonfun$getOrCreate$5.apply(SparkSession.scala:878)
    at scala.collection.mutable.HashMap$$anonfun$foreach$1.apply(HashMap.scala:99)
    at scala.collection.mutable.HashMap$$anonfun$foreach$1.apply(HashMap.scala:99)
    at scala.collection.mutable.HashTable$class.foreachEntry(HashTable.scala:230)
    at scala.collection.mutable.HashMap.foreachEntry(HashMap.scala:40)
    at scala.collection.mutable.HashMap.foreach(HashMap.scala:99)
    at org.apache.spark.sql.SparkSession$Builder.getOrCreate(SparkSession.scala:878)
    at com.atguigu.bigdata.sparkmall.mock.util.MockerOffline$.main(MockerOffline.scala:42)
    at com.atguigu.bigdata.sparkmall.mock.util.MockerOffline.main(MockerOffline.scala)
Caused by: java.lang.reflect.InvocationTargetException
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    at org.apache.spark.sql.SparkSession$.org$apache$spark$sql$SparkSession$$reflect(SparkSession.scala:978)
    ... 12 more
Caused by: java.lang.IllegalArgumentException: Error while instantiating 'org.apache.spark.sql.hive.HiveExternalCatalog':
    at org.apache.spark.sql.internal.SharedState$.org$apache$spark$sql$internal$SharedState$$reflect(SharedState.scala:169)
    at org.apache.spark.sql.internal.SharedState.<init>(SharedState.scala:86)
    at org.apache.spark.sql.SparkSession$$anonfun$sharedState$1.apply(SparkSession.scala:101)
    at org.apache.spark.sql.SparkSession$$anonfun$sharedState$1.apply(SparkSession.scala:101)
    at scala.Option.getOrElse(Option.scala:121)
    at org.apache.spark.sql.SparkSession.sharedState$lzycompute(SparkSession.scala:101)
    at org.apache.spark.sql.SparkSession.sharedState(SparkSession.scala:100)
    at org.apache.spark.sql.internal.SessionState.<init>(SessionState.scala:157)
    at org.apache.spark.sql.hive.HiveSessionState.<init>(HiveSessionState.scala:32)
    ... 17 more
Caused by: java.lang.reflect.InvocationTargetException
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    at org.apache.spark.sql.internal.SharedState$.org$apache$spark$sql$internal$SharedState$$reflect(SharedState.scala:166)
    ... 25 more
Caused by: java.lang.ClassNotFoundException: java.lang.NoClassDefFoundError: org/apache/tez/dag/api/SessionNotRunning when creating Hive client using classpath: file:/C:/Program%20Files/Java/jdk1.8.0_171/jre/lib/charsets.jar, file:/C:/Program%20Files/Java/jdk1.8.0_171/jre/lib/deploy.jar, file:/C:/Program%20Files/Java/jdk1.8.0_171/jre/lib/ext/access-bridge-64.jar, file:/C:/Program%20Files/Java/jdk1.8.0_171/jre/lib/ext/cldrdata.jar, file:/C:/Program%20Files/Java/jdk1.8.0_171/jre/lib/ext/dnsns.jar, file:/C:/Program%20Files/Java/jdk1.8.0_171/jre/lib/ext/jaccess.jar, file:/C:/Program%20Files/Java/jdk1.8.0_171/jre/lib/ext/jfxrt.jar, file:/C:/Program%20Files/Java/jdk1.8.0_171/jre/lib/ext/localedata.jar, file:/C:/Program%20Files/Java/jdk1.8.0_171/jre/lib/ext/nashorn.jar, file:/C:/Program%20Files/Java/jdk1.8.0_171/jre/lib/ext/sunec.jar, file:/C:/Program%20Files/Java/jdk1.8.0_171/jre/lib/ext/sunjce_provider.jar, file:/C:/Program%20Files/Java/jdk1.8.0_171/jre/lib/ext/sunmscapi.jar, file:/C:/Program%20Files/Java/jdk1.8.0_171/jre/lib/ext/sunpkcs11.jar, file:/C:/Program%20Files/Java/jdk1.8.0_171/jre/lib/ext/zipfs.jar, file:/C:/Program%20Files/Java/jdk1.8.0_171/jre/lib/javaws.jar, file:/C:/Program%20Files/Java/jdk1.8.0_171/jre/lib/jce.jar, file:/C:/Program%20Files/Java/jdk1.8.0_171/jre/lib/jfr.jar, file:/C:/Program%20Files/Java/jdk1.8.0_171/jre/lib/jfxswt.jar, file:/C:/Program%20Files/Java/jdk1.8.0_171/jre/lib/jsse.jar, file:/C:/Program%20Files/Java/jdk1.8.0_171/jre/lib/management-agent.jar, file:/C:/Program%20Files/Java/jdk1.8.0_171/jre/lib/plugin.jar, file:/C:/Program%20Files/Java/jdk1.8.0_171/jre/lib/resources.jar, file:/C:/Program%20Files/Java/jdk1.8.0_171/jre/lib/rt.jar, file:/D:/IdeaProjectstest/sparkmall-190218/sparkmall-mock/target/classes/, file:/D:/IdeaProjectstest/sparkmall-190218/sparkmall-common/target/classes/, file:/E:/maven_tools/maven_repository/maven_repository/com/alibaba/fastjson/1.2.47/fastjson-1.2.47.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/commons/commons-pool2/2.4.2/commons-pool2-2.4.2.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/commons/commons-configuration2/2.2/commons-configuration2-2.2.jar, file:/E:/maven_tools/maven_repository/maven_repository/commons-logging/commons-logging/1.2/commons-logging-1.2.jar, file:/E:/maven_tools/maven_repository/maven_repository/commons-beanutils/commons-beanutils/1.9.3/commons-beanutils-1.9.3.jar, file:/E:/maven_tools/maven_repository/maven_repository/commons-collections/commons-collections/3.2.2/commons-collections-3.2.2.jar, file:/E:/maven_tools/maven_repository/maven_repository/mysql/mysql-connector-java/5.1.47/mysql-connector-java-5.1.47.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/kafka/kafka-clients/0.10.2.1/kafka-clients-0.10.2.1.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/spark/spark-streaming_2.11/2.1.1/spark-streaming_2.11-2.1.1.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/spark/spark-streaming-kafka-0-10_2.11/2.1.1/spark-streaming-kafka-0-10_2.11-2.1.1.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/kafka/kafka_2.11/0.10.0.1/kafka_2.11-0.10.0.1.jar, file:/E:/maven_tools/maven_repository/maven_repository/com/101tec/zkclient/0.8/zkclient-0.8.jar, file:/E:/maven_tools/maven_repository/maven_repository/com/yammer/metrics/metrics-core/2.2.0/metrics-core-2.2.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/scala-lang/modules/scala-parser-combinators_2.11/1.0.4/scala-parser-combinators_2.11-1.0.4.jar, file:/E:/maven_tools/maven_repository/maven_repository/redis/clients/jedis/2.9.0/jedis-2.9.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/com/alibaba/druid/1.1.10/druid-1.1.10.jar, file:/E:/maven_tools/maven_repository/maven_repository/net/sf/json-lib/json-lib/2.4/json-lib-2.4-jdk15.jar, file:/E:/maven_tools/maven_repository/maven_repository/commons-lang/commons-lang/2.5/commons-lang-2.5.jar, file:/E:/maven_tools/maven_repository/maven_repository/net/sf/ezmorph/ezmorph/1.0.6/ezmorph-1.0.6.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/json4s/json4s-native_2.11/3.2.11/json4s-native_2.11-3.2.11.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/json4s/json4s-core_2.11/3.2.11/json4s-core_2.11-3.2.11.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/json4s/json4s-ast_2.11/3.2.11/json4s-ast_2.11-3.2.11.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/scala-lang/scalap/2.11.0/scalap-2.11.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/scala-lang/scala-compiler/2.11.0/scala-compiler-2.11.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/scala-lang/modules/scala-xml_2.11/1.0.1/scala-xml_2.11-1.0.1.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/json4s/json4s-jackson_2.11/3.2.11/json4s-jackson_2.11-3.2.11.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/spark/spark-core_2.11/2.1.1/spark-core_2.11-2.1.1.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/avro/avro-mapred/1.7.7/avro-mapred-1.7.7-hadoop2.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/avro/avro-ipc/1.7.7/avro-ipc-1.7.7.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/avro/avro-ipc/1.7.7/avro-ipc-1.7.7-tests.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/codehaus/jackson/jackson-core-asl/1.9.13/jackson-core-asl-1.9.13.jar, file:/E:/maven_tools/maven_repository/maven_repository/com/twitter/chill_2.11/0.8.0/chill_2.11-0.8.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/com/esotericsoftware/kryo-shaded/3.0.3/kryo-shaded-3.0.3.jar, file:/E:/maven_tools/maven_repository/maven_repository/com/esotericsoftware/minlog/1.3.0/minlog-1.3.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/objenesis/objenesis/2.1/objenesis-2.1.jar, file:/E:/maven_tools/maven_repository/maven_repository/com/twitter/chill-java/0.8.0/chill-java-0.8.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/xbean/xbean-asm5-shaded/4.4/xbean-asm5-shaded-4.4.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/hadoop/hadoop-client/2.2.0/hadoop-client-2.2.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/hadoop/hadoop-common/2.2.0/hadoop-common-2.2.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/commons/commons-math/2.1/commons-math-2.1.jar, file:/E:/maven_tools/maven_repository/maven_repository/xmlenc/xmlenc/0.52/xmlenc-0.52.jar, file:/E:/maven_tools/maven_repository/maven_repository/commons-configuration/commons-configuration/1.6/commons-configuration-1.6.jar, file:/E:/maven_tools/maven_repository/maven_repository/commons-digester/commons-digester/1.8/commons-digester-1.8.jar, file:/E:/maven_tools/maven_repository/maven_repository/commons-beanutils/commons-beanutils-core/1.8.0/commons-beanutils-core-1.8.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/com/google/protobuf/protobuf-java/2.5.0/protobuf-java-2.5.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/hadoop/hadoop-auth/2.2.0/hadoop-auth-2.2.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/hadoop/hadoop-hdfs/2.2.0/hadoop-hdfs-2.2.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/mortbay/jetty/jetty-util/6.1.26/jetty-util-6.1.26.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/hadoop/hadoop-mapreduce-client-app/2.2.0/hadoop-mapreduce-client-app-2.2.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/hadoop/hadoop-mapreduce-client-common/2.2.0/hadoop-mapreduce-client-common-2.2.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/hadoop/hadoop-yarn-client/2.2.0/hadoop-yarn-client-2.2.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/com/google/inject/guice/3.0/guice-3.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/javax/inject/javax.inject/1/javax.inject-1.jar, file:/E:/maven_tools/maven_repository/maven_repository/aopalliance/aopalliance/1.0/aopalliance-1.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/hadoop/hadoop-yarn-server-common/2.2.0/hadoop-yarn-server-common-2.2.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/hadoop/hadoop-mapreduce-client-shuffle/2.2.0/hadoop-mapreduce-client-shuffle-2.2.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/hadoop/hadoop-yarn-api/2.2.0/hadoop-yarn-api-2.2.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/hadoop/hadoop-mapreduce-client-core/2.2.0/hadoop-mapreduce-client-core-2.2.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/hadoop/hadoop-yarn-common/2.2.0/hadoop-yarn-common-2.2.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/hadoop/hadoop-mapreduce-client-jobclient/2.2.0/hadoop-mapreduce-client-jobclient-2.2.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/hadoop/hadoop-annotations/2.2.0/hadoop-annotations-2.2.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/spark/spark-launcher_2.11/2.1.1/spark-launcher_2.11-2.1.1.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/spark/spark-network-common_2.11/2.1.1/spark-network-common_2.11-2.1.1.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/fusesource/leveldbjni/leveldbjni-all/1.8/leveldbjni-all-1.8.jar, file:/E:/maven_tools/maven_repository/maven_repository/com/fasterxml/jackson/core/jackson-annotations/2.6.5/jackson-annotations-2.6.5.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/spark/spark-network-shuffle_2.11/2.1.1/spark-network-shuffle_2.11-2.1.1.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/spark/spark-unsafe_2.11/2.1.1/spark-unsafe_2.11-2.1.1.jar, file:/E:/maven_tools/maven_repository/maven_repository/net/java/dev/jets3t/jets3t/0.7.1/jets3t-0.7.1.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/curator/curator-recipes/2.4.0/curator-recipes-2.4.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/curator/curator-framework/2.4.0/curator-framework-2.4.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/curator/curator-client/2.4.0/curator-client-2.4.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/zookeeper/zookeeper/3.4.5/zookeeper-3.4.5.jar, file:/E:/maven_tools/maven_repository/maven_repository/com/google/guava/guava/14.0.1/guava-14.0.1.jar, file:/E:/maven_tools/maven_repository/maven_repository/javax/servlet/javax.servlet-api/3.1.0/javax.servlet-api-3.1.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/commons/commons-lang3/3.5/commons-lang3-3.5.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/commons/commons-math3/3.4.1/commons-math3-3.4.1.jar, file:/E:/maven_tools/maven_repository/maven_repository/com/google/code/findbugs/jsr305/1.3.9/jsr305-1.3.9.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/slf4j/jul-to-slf4j/1.7.16/jul-to-slf4j-1.7.16.jar, file:/E:/maven_tools/maven_repository/maven_repository/com/ning/compress-lzf/1.0.3/compress-lzf-1.0.3.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/xerial/snappy/snappy-java/1.1.2.6/snappy-java-1.1.2.6.jar, file:/E:/maven_tools/maven_repository/maven_repository/net/jpountz/lz4/lz4/1.3.0/lz4-1.3.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/roaringbitmap/RoaringBitmap/0.5.11/RoaringBitmap-0.5.11.jar, file:/E:/maven_tools/maven_repository/maven_repository/commons-net/commons-net/2.2/commons-net-2.2.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/scala-lang/scala-library/2.11.8/scala-library-2.11.8.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/glassfish/jersey/core/jersey-client/2.22.2/jersey-client-2.22.2.jar, file:/E:/maven_tools/maven_repository/maven_repository/javax/ws/rs/javax.ws.rs-api/2.0.1/javax.ws.rs-api-2.0.1.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/glassfish/hk2/hk2-api/2.4.0-b34/hk2-api-2.4.0-b34.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/glassfish/hk2/hk2-utils/2.4.0-b34/hk2-utils-2.4.0-b34.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/glassfish/hk2/external/aopalliance-repackaged/2.4.0-b34/aopalliance-repackaged-2.4.0-b34.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/glassfish/hk2/external/javax.inject/2.4.0-b34/javax.inject-2.4.0-b34.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/glassfish/hk2/hk2-locator/2.4.0-b34/hk2-locator-2.4.0-b34.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/javassist/javassist/3.18.1-GA/javassist-3.18.1-GA.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/glassfish/jersey/core/jersey-common/2.22.2/jersey-common-2.22.2.jar, file:/E:/maven_tools/maven_repository/maven_repository/javax/annotation/javax.annotation-api/1.2/javax.annotation-api-1.2.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/glassfish/jersey/bundles/repackaged/jersey-guava/2.22.2/jersey-guava-2.22.2.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/glassfish/hk2/osgi-resource-locator/1.0.1/osgi-resource-locator-1.0.1.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/glassfish/jersey/core/jersey-server/2.22.2/jersey-server-2.22.2.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/glassfish/jersey/media/jersey-media-jaxb/2.22.2/jersey-media-jaxb-2.22.2.jar, file:/E:/maven_tools/maven_repository/maven_repository/javax/validation/validation-api/1.1.0.Final/validation-api-1.1.0.Final.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/glassfish/jersey/containers/jersey-container-servlet/2.22.2/jersey-container-servlet-2.22.2.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/glassfish/jersey/containers/jersey-container-servlet-core/2.22.2/jersey-container-servlet-core-2.22.2.jar, file:/E:/maven_tools/maven_repository/maven_repository/io/netty/netty-all/4.0.42.Final/netty-all-4.0.42.Final.jar, file:/E:/maven_tools/maven_repository/maven_repository/io/netty/netty/3.8.0.Final/netty-3.8.0.Final.jar, file:/E:/maven_tools/maven_repository/maven_repository/com/clearspring/analytics/stream/2.7.0/stream-2.7.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/io/dropwizard/metrics/metrics-core/3.1.2/metrics-core-3.1.2.jar, file:/E:/maven_tools/maven_repository/maven_repository/io/dropwizard/metrics/metrics-jvm/3.1.2/metrics-jvm-3.1.2.jar, file:/E:/maven_tools/maven_repository/maven_repository/io/dropwizard/metrics/metrics-json/3.1.2/metrics-json-3.1.2.jar, file:/E:/maven_tools/maven_repository/maven_repository/io/dropwizard/metrics/metrics-graphite/3.1.2/metrics-graphite-3.1.2.jar, file:/E:/maven_tools/maven_repository/maven_repository/com/fasterxml/jackson/core/jackson-databind/2.6.5/jackson-databind-2.6.5.jar, file:/E:/maven_tools/maven_repository/maven_repository/com/fasterxml/jackson/core/jackson-core/2.6.5/jackson-core-2.6.5.jar, file:/E:/maven_tools/maven_repository/maven_repository/com/fasterxml/jackson/module/jackson-module-scala_2.11/2.6.5/jackson-module-scala_2.11-2.6.5.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/scala-lang/scala-reflect/2.11.7/scala-reflect-2.11.7.jar, file:/E:/maven_tools/maven_repository/maven_repository/com/fasterxml/jackson/module/jackson-module-paranamer/2.6.5/jackson-module-paranamer-2.6.5.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/ivy/ivy/2.4.0/ivy-2.4.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/oro/oro/2.0.8/oro-2.0.8.jar, file:/E:/maven_tools/maven_repository/maven_repository/net/razorvine/pyrolite/4.13/pyrolite-4.13.jar, file:/E:/maven_tools/maven_repository/maven_repository/net/sf/py4j/py4j/0.10.4/py4j-0.10.4.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/spark/spark-tags_2.11/2.1.1/spark-tags_2.11-2.1.1.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/commons/commons-crypto/1.0.0/commons-crypto-1.0.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/spark-project/spark/unused/1.0.0/unused-1.0.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/spark/spark-sql_2.11/2.1.1/spark-sql_2.11-2.1.1.jar, file:/E:/maven_tools/maven_repository/maven_repository/com/univocity/univocity-parsers/2.2.1/univocity-parsers-2.2.1.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/spark/spark-sketch_2.11/2.1.1/spark-sketch_2.11-2.1.1.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/spark/spark-catalyst_2.11/2.1.1/spark-catalyst_2.11-2.1.1.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/codehaus/janino/janino/3.0.0/janino-3.0.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/codehaus/janino/commons-compiler/3.0.0/commons-compiler-3.0.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/antlr/antlr4-runtime/4.5.3/antlr4-runtime-4.5.3.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/parquet/parquet-column/1.8.1/parquet-column-1.8.1.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/parquet/parquet-common/1.8.1/parquet-common-1.8.1.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/parquet/parquet-encoding/1.8.1/parquet-encoding-1.8.1.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/parquet/parquet-hadoop/1.8.1/parquet-hadoop-1.8.1.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/parquet/parquet-format/2.3.0-incubating/parquet-format-2.3.0-incubating.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/parquet/parquet-jackson/1.8.1/parquet-jackson-1.8.1.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/spark/spark-hive_2.11/2.1.1/spark-hive_2.11-2.1.1.jar, file:/E:/maven_tools/maven_repository/maven_repository/com/twitter/parquet-hadoop-bundle/1.6.0/parquet-hadoop-bundle-1.6.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/spark-project/hive/hive-exec/1.2.1.spark2/hive-exec-1.2.1.spark2.jar, file:/E:/maven_tools/maven_repository/maven_repository/commons-io/commons-io/2.4/commons-io-2.4.jar, file:/E:/maven_tools/maven_repository/maven_repository/javolution/javolution/5.5.1/javolution-5.5.1.jar, file:/E:/maven_tools/maven_repository/maven_repository/log4j/apache-log4j-extras/1.2.17/apache-log4j-extras-1.2.17.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/antlr/antlr-runtime/3.4/antlr-runtime-3.4.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/antlr/stringtemplate/3.2.1/stringtemplate-3.2.1.jar, file:/E:/maven_tools/maven_repository/maven_repository/antlr/antlr/2.7.7/antlr-2.7.7.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/antlr/ST4/4.0.4/ST4-4.0.4.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/commons/commons-compress/1.4.1/commons-compress-1.4.1.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/tukaani/xz/1.0/xz-1.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/com/googlecode/javaewah/JavaEWAH/0.3.2/JavaEWAH-0.3.2.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/iq80/snappy/snappy/0.2/snappy-0.2.jar, file:/E:/maven_tools/maven_repository/maven_repository/stax/stax-api/1.0.1/stax-api-1.0.1.jar, file:/E:/maven_tools/maven_repository/maven_repository/net/sf/opencsv/opencsv/2.3/opencsv-2.3.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/spark-project/hive/hive-metastore/1.2.1.spark2/hive-metastore-1.2.1.spark2.jar, file:/E:/maven_tools/maven_repository/maven_repository/com/jolbox/bonecp/0.8.0.RELEASE/bonecp-0.8.0.RELEASE.jar, file:/E:/maven_tools/maven_repository/maven_repository/commons-cli/commons-cli/1.2/commons-cli-1.2.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/derby/derby/10.10.2.0/derby-10.10.2.0.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/datanucleus/datanucleus-api-jdo/3.2.6/datanucleus-api-jdo-3.2.6.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/datanucleus/datanucleus-rdbms/3.2.9/datanucleus-rdbms-3.2.9.jar, file:/E:/maven_tools/maven_repository/maven_repository/commons-pool/commons-pool/1.5.4/commons-pool-1.5.4.jar, file:/E:/maven_tools/maven_repository/maven_repository/commons-dbcp/commons-dbcp/1.4/commons-dbcp-1.4.jar, file:/E:/maven_tools/maven_repository/maven_repository/javax/jdo/jdo-api/3.0.1/jdo-api-3.0.1.jar, file:/E:/maven_tools/maven_repository/maven_repository/javax/transaction/jta/1.1/jta-1.1.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/avro/avro/1.7.7/avro-1.7.7.jar, file:/E:/maven_tools/maven_repository/maven_repository/com/thoughtworks/paranamer/paranamer/2.3/paranamer-2.3.jar, file:/E:/maven_tools/maven_repository/maven_repository/commons-httpclient/commons-httpclient/3.1/commons-httpclient-3.1.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/calcite/calcite-avatica/1.2.0-incubating/calcite-avatica-1.2.0-incubating.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/calcite/calcite-core/1.2.0-incubating/calcite-core-1.2.0-incubating.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/calcite/calcite-linq4j/1.2.0-incubating/calcite-linq4j-1.2.0-incubating.jar, file:/E:/maven_tools/maven_repository/maven_repository/net/hydromatic/eigenbase-properties/1.1.5/eigenbase-properties-1.1.5.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/httpcomponents/httpclient/4.5.2/httpclient-4.5.2.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/httpcomponents/httpcore/4.4.4/httpcore-4.4.4.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/codehaus/jackson/jackson-mapper-asl/1.9.13/jackson-mapper-asl-1.9.13.jar, file:/E:/maven_tools/maven_repository/maven_repository/commons-codec/commons-codec/1.10/commons-codec-1.10.jar, file:/E:/maven_tools/maven_repository/maven_repository/joda-time/joda-time/2.9.3/joda-time-2.9.3.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/jodd/jodd-core/3.5.2/jodd-core-3.5.2.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/datanucleus/datanucleus-core/3.2.10/datanucleus-core-3.2.10.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/thrift/libthrift/0.9.3/libthrift-0.9.3.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/apache/thrift/libfb303/0.9.3/libfb303-0.9.3.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/slf4j/jcl-over-slf4j/1.7.22/jcl-over-slf4j-1.7.22.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/slf4j/slf4j-api/1.7.22/slf4j-api-1.7.22.jar, file:/E:/maven_tools/maven_repository/maven_repository/org/slf4j/slf4j-log4j12/1.7.22/slf4j-log4j12-1.7.22.jar, file:/E:/maven_tools/maven_repository/maven_repository/log4j/log4j/1.2.17/log4j-1.2.17.jar, file:/C:/tool/IDEA/lib/idea_rt.jar, file:/C:/Program%20Files/Java/jdk1.8.0_171/jre/lib/ext/access-bridge-64.jar, file:/C:/Program%20Files/Java/jdk1.8.0_171/jre/lib/ext/cldrdata.jar, file:/C:/Program%20Files/Java/jdk1.8.0_171/jre/lib/ext/dnsns.jar, file:/C:/Program%20Files/Java/jdk1.8.0_171/jre/lib/ext/jaccess.jar, file:/C:/Program%20Files/Java/jdk1.8.0_171/jre/lib/ext/jfxrt.jar, file:/C:/Program%20Files/Java/jdk1.8.0_171/jre/lib/ext/localedata.jar, file:/C:/Program%20Files/Java/jdk1.8.0_171/jre/lib/ext/nashorn.jar, file:/C:/Program%20Files/Java/jdk1.8.0_171/jre/lib/ext/sunec.jar, file:/C:/Program%20Files/Java/jdk1.8.0_171/jre/lib/ext/sunjce_provider.jar, file:/C:/Program%20Files/Java/jdk1.8.0_171/jre/lib/ext/sunmscapi.jar, file:/C:/Program%20Files/Java/jdk1.8.0_171/jre/lib/ext/sunpkcs11.jar, file:/C:/Program%20Files/Java/jdk1.8.0_171/jre/lib/ext/zipfs.jar
Please make sure that jars for your version of hive and hadoop are included in the paths passed to spark.sql.hive.metastore.jars.
    at org.apache.spark.sql.hive.client.IsolatedClientLoader.createClient(IsolatedClientLoader.scala:270)
    at org.apache.spark.sql.hive.HiveUtils$.newClientForMetadata(HiveUtils.scala:358)
    at org.apache.spark.sql.hive.HiveUtils$.newClientForMetadata(HiveUtils.scala:262)
    at org.apache.spark.sql.hive.HiveExternalCatalog.<init>(HiveExternalCatalog.scala:66)
    ... 30 more
Caused by: java.lang.reflect.InvocationTargetException
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    at org.apache.spark.sql.hive.client.IsolatedClientLoader.createClient(IsolatedClientLoader.scala:264)
    ... 33 more
Caused by: java.lang.NoClassDefFoundError: org/apache/tez/dag/api/SessionNotRunning
    at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:529)
    at org.apache.spark.sql.hive.client.HiveClientImpl.<init>(HiveClientImpl.scala:188)
    ... 38 more
Caused by: java.lang.ClassNotFoundException: org.apache.tez.dag.api.SessionNotRunning
    at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
    at org.apache.spark.sql.hive.client.IsolatedClientLoader$$anon$1.doLoadClass(IsolatedClientLoader.scala:221)
    at org.apache.spark.sql.hive.client.IsolatedClientLoader$$anon$1.loadClass(IsolatedClientLoader.scala:210)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
    ... 40 more

 

解决方案：