用IDEA scala 编写一个sparksql读写csv文件的代码

最新推荐文章于 2024-03-18 10:28:01 发布

振兴东北

最新推荐文章于 2024-03-18 10:28:01 发布

阅读量1.8k

点赞数

分类专栏：学习笔记文章标签： spark scala

本文链接：https://blog.csdn.net/spsace/article/details/104727064

版权

学习笔记专栏收录该内容

21 篇文章 0 订阅

订阅专栏

试着使用sparksql写一个读写csv文件。

使用工具如下：

1. IntelliJIDEA 2019.3.3 U E

2. scala-sdk-2.11.12

3. jdk 1.8.0_91

----------------------------------------------------------------------------------------------------------------------------------------------------------

创建一个Maven项目

代码如下：

import org.apache.spark.sql.{DataFrame, SQLContext}
import org.apache.spark.{SparkConf, SparkContext}
import com.databricks.spark.csv._
import org.apache.spark.sql.types.{DoubleType, StringType, StructField, StructType}

object App {

  def main(args: Array[String]) {
    println("start")
    val conf = new SparkConf().setAppName("Test1").setMaster("local[*]")
    val sparkContext = new SparkContext(conf)
    val sqlContext = new SQLContext(sparkContext)
    val fieldSchema = StructType(Array(
      StructField("DistributorTier", StringType, true),
      StructField("Seller Code", StringType, true),
      StructField("Seller Name", StringType, true),
      StructField("Province", StringType, true),
      StructField("shop", StringType, true),
      StructField("hospital", StringType, true),
      StructField("Total", DoubleType, true)
    ))

    val taxiDF:DataFrame = sqlContext.read.format("com.databricks.spark.csv")
      .option("header", "true")
      .option("inferSchema",true.toString)
      .schema(fieldSchema)
      .load("D:\\AWS\\result.csv")


    taxiDF.registerTempTable("t_test")

    val area:DataFrame = sqlContext.sql("select * from t_test")
    area.write.mode("Append").csv("D:\\AWS\\result")
    area.show()

    sparkContext.stop()
  }

}

----------------------------------------------------------------------------------------------------------------------------------------------------------

pom.xml内容如下：

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>org.example</groupId>
  <artifactId>scalaDemo</artifactId>
  <version>1.0-SNAPSHOT</version>
  <inceptionYear>2008</inceptionYear>
  <properties>
    <spark.version>2.3.1</spark.version>
    <scala.version>2.11</scala.version>
    <!-- 配置以下可以解决 在jdk1.8环境下打包时报错 “-source 1.5 中不支持 lambda 表达式” -->
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <maven.compiler.source>1.8</maven.compiler.source>
    <maven.compiler.target>1.8</maven.compiler.target>
  </properties>

  <repositories>
    <repository>
      <id>scala-tools.org</id>
      <name>Scala-Tools Maven2 Repository</name>
      <url>http://scala-tools.org/repo-releases</url>
    </repository>
  </repositories>

  <pluginRepositories>
    <pluginRepository>
      <id>scala-tools.org</id>
      <name>Scala-Tools Maven2 Repository</name>
      <url>http://scala-tools.org/repo-releases</url>
    </pluginRepository>
  </pluginRepositories>

  <dependencies>
    <dependency>
      <groupId>org.apache.spark</groupId>
      <artifactId>spark-core_${scala.version}</artifactId>
      <version>${spark.version}</version>
    </dependency>
    <dependency>
      <groupId>org.apache.spark</groupId>
      <artifactId>spark-sql_${scala.version}</artifactId>
      <version>${spark.version}</version>
    </dependency>
    <dependency>
      <groupId>org.apache.spark</groupId>
      <artifactId>spark-hive_${scala.version}</artifactId>
      <version>${spark.version}</version>
    </dependency>
    <dependency>
      <groupId>org.apache.spark</groupId>
      <artifactId>spark-streaming_${scala.version}</artifactId>
      <version>${spark.version}</version>
    </dependency>
    <dependency>
      <groupId>org.apache.spark</groupId>
      <artifactId>spark-csv_1.5.0</artifactId>
      <version>1.6.0</version>
    </dependency>
    <dependency>
      <groupId>com.databricks</groupId>
      <artifactId>spark-csv_2.10</artifactId>
      <version>1.4.0</version>
    </dependency>

    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.4</version>
      <scope>test</scope>
    </dependency>
    <dependency>
      <groupId>org.specs</groupId>
      <artifactId>specs</artifactId>
      <version>1.2.5</version>
      <scope>test</scope>
    </dependency>
  </dependencies>

  <build>
    <sourceDirectory>src/main/scala</sourceDirectory>
    <testSourceDirectory>src/test/scala</testSourceDirectory>
    <plugins>
      <plugin>
        <groupId>org.scala-tools</groupId>
        <artifactId>maven-scala-plugin</artifactId>
        <executions>
          <execution>
            <goals>
              <goal>compile</goal>
              <goal>testCompile</goal>
            </goals>
          </execution>
        </executions>
        <configuration>
          <scalaVersion>2.11.7</scalaVersion>
          <args>
            <arg>target:jvm-1.8</arg>
          </args>
        </configuration>
      </plugin>
      <plugin>
        <groupId>org.apache.maven.plugins</groupId>
        <artifactId>maven-eclipse-plugin</artifactId>
        <configuration>
          <downloadSources>true</downloadSources>
          <buildcommands>
            <buildcommand>ch.epfl.lamp.sdt.core.scalabuilder</buildcommand>
          </buildcommands>
          <additionalProjectnatures>
            <projectnature>ch.epfl.lamp.sdt.core.scalanature</projectnature>
          </additionalProjectnatures>
          <classpathContainers>
            <classpathContainer>org.eclipse.jdt.launching.JRE_CONTAINER</classpathContainer>
            <classpathContainer>ch.epfl.lamp.sdt.launching.SCALA_CONTAINER</classpathContainer>
          </classpathContainers>
        </configuration>
      </plugin>
    </plugins>
  </build>
  <reporting>
    <plugins>
      <plugin>
        <groupId>org.scala-tools</groupId>
        <artifactId>maven-scala-plugin</artifactId>
        <configuration>
          <scalaVersion>2.11.7</scalaVersion>
        </configuration>
      </plugin>
    </plugins>
  </reporting>
</project>

----------------------------------------------------------------------------------------------------------------------------------------------------------

--------------------------------------------------------------------------------------------------------------------------------------------------------------

执行报异常如下：

"C:\Program Files\Java\jdk1.8.0_91\bin\java.exe" -javaagent:D:\DcBrowserDownloads\DevelopmentTools\ideaiu2019\ideaIU-2019.3.3.win\lib\idea_rt.jar=62530:D:\DcBrowserDownloads\DevelopmentTools\ideaiu2019\ideaIU-2019.3.3.win\bin -Dfile.encoding=UTF-8 -classpath "C:\Program Files\Java\jdk1.8.0_91\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.8.0_91\jre\lib\deploy.jar;C:\Program Files\Java\jdk1.8.0_91\jre\lib\ext\access-bridge-64.jar;C:\Program Files\Java\jdk1.8.0_91\jre\lib\ext\cldrdata.jar;C:\Program Files\Java\jdk1.8.0_91\jre\lib\ext\dnsns.jar;C:\Program Files\Java\jdk1.8.0_91\jre\lib\ext\jaccess.jar;C:\Program Files\Java\jdk1.8.0_91\jre\lib\ext\jfxrt.jar;C:\Program Files\Java\jdk1.8.0_91\jre\lib\ext\localedata.jar;C:\Program Files\Java\jdk1.8.0_91\jre\lib\ext\nashorn.jar;C:\Program Files\Java\jdk1.8.0_91\jre\lib\ext\sunec.jar;C:\Program Files\Java\jdk1.8.0_91\jre\lib\ext\sunjce_provider.jar;C:\Program Files\Java\jdk1.8.0_91\jre\lib\ext\sunmscapi.jar;C:\Program Files\Java\jdk1.8.0_91\jre\lib\ext\sunpkcs11.jar;C:\Program Files\Java\jdk1.8.0_91\jre\lib\ext\zipfs.jar;C:\Program Files\Java\jdk1.8.0_91\jre\lib\javaws.jar;C:\Program Files\Java\jdk1.8.0_91\jre\lib\jce.jar;C:\Program Files\Java\jdk1.8.0_91\jre\lib\jfr.jar;C:\Program Files\Java\jdk1.8.0_91\jre\lib\jfxswt.jar;C:\Program Files\Java\jdk1.8.0_91\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.8.0_91\jre\lib\management-agent.jar;C:\Program Files\Java\jdk1.8.0_91\jre\lib\plugin.jar;C:\Program Files\Java\jdk1.8.0_91\jre\lib\resources.jar;C:\Program Files\Java\jdk1.8.0_91\jre\lib\rt.jar;D:\workspase\scalaDemo\target\classes;D:\DcBrowserDownloads\scala-2.13.1\lib\scala-library.jar;D:\DcBrowserDownloads\scala-2.13.1\lib\scala-reflect.jar;D:\workspase\scalaDemo\src\lib\spark-csv_2.11-1.5.0.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\spark\spark-core_2.11\2.3.1\spark-core_2.11-2.3.1.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\avro\avro\1.7.7\avro-1.7.7.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\codehaus\jackson\jackson-core-asl\1.9.13\jackson-core-asl-1.9.13.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\com\thoughtworks\paranamer\paranamer\2.3\paranamer-2.3.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\commons\commons-compress\1.4.1\commons-compress-1.4.1.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\tukaani\xz\1.0\xz-1.0.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\avro\avro-mapred\1.7.7\avro-mapred-1.7.7-hadoop2.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\avro\avro-ipc\1.7.7\avro-ipc-1.7.7.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\avro\avro-ipc\1.7.7\avro-ipc-1.7.7-tests.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\com\twitter\chill_2.11\0.8.4\chill_2.11-0.8.4.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\com\esotericsoftware\kryo-shaded\3.0.3\kryo-shaded-3.0.3.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\com\esotericsoftware\minlog\1.3.0\minlog-1.3.0.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\objenesis\objenesis\2.1\objenesis-2.1.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\com\twitter\chill-java\0.8.4\chill-java-0.8.4.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\xbean\xbean-asm5-shaded\4.4\xbean-asm5-shaded-4.4.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\hadoop\hadoop-client\2.6.5\hadoop-client-2.6.5.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\hadoop\hadoop-common\2.6.5\hadoop-common-2.6.5.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\xmlenc\xmlenc\0.52\xmlenc-0.52.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\commons-collections\commons-collections\3.2.2\commons-collections-3.2.2.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\commons-configuration\commons-configuration\1.6\commons-configuration-1.6.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\commons-digester\commons-digester\1.8\commons-digester-1.8.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\commons-beanutils\commons-beanutils\1.7.0\commons-beanutils-1.7.0.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\commons-beanutils\commons-beanutils-core\1.8.0\commons-beanutils-core-1.8.0.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\com\google\code\gson\gson\2.2.4\gson-2.2.4.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\hadoop\hadoop-auth\2.6.5\hadoop-auth-2.6.5.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\directory\server\apacheds-kerberos-codec\2.0.0-M15\apacheds-kerberos-codec-2.0.0-M15.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\directory\server\apacheds-i18n\2.0.0-M15\apacheds-i18n-2.0.0-M15.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\directory\api\api-asn1-api\1.0.0-M20\api-asn1-api-1.0.0-M20.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\directory\api\api-util\1.0.0-M20\api-util-1.0.0-M20.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\curator\curator-client\2.6.0\curator-client-2.6.0.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\htrace\htrace-core\3.0.4\htrace-core-3.0.4.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\hadoop\hadoop-hdfs\2.6.5\hadoop-hdfs-2.6.5.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\mortbay\jetty\jetty-util\6.1.26\jetty-util-6.1.26.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\xerces\xercesImpl\2.9.1\xercesImpl-2.9.1.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\xml-apis\xml-apis\1.3.04\xml-apis-1.3.04.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\hadoop\hadoop-mapreduce-client-app\2.6.5\hadoop-mapreduce-client-app-2.6.5.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\hadoop\hadoop-mapreduce-client-common\2.6.5\hadoop-mapreduce-client-common-2.6.5.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\hadoop\hadoop-yarn-client\2.6.5\hadoop-yarn-client-2.6.5.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\hadoop\hadoop-yarn-server-common\2.6.5\hadoop-yarn-server-common-2.6.5.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\hadoop\hadoop-mapreduce-client-shuffle\2.6.5\hadoop-mapreduce-client-shuffle-2.6.5.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\hadoop\hadoop-yarn-api\2.6.5\hadoop-yarn-api-2.6.5.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\hadoop\hadoop-mapreduce-client-core\2.6.5\hadoop-mapreduce-client-core-2.6.5.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\hadoop\hadoop-yarn-common\2.6.5\hadoop-yarn-common-2.6.5.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\javax\xml\bind\jaxb-api\2.2.2\jaxb-api-2.2.2.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\javax\xml\stream\stax-api\1.0-2\stax-api-1.0-2.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\codehaus\jackson\jackson-jaxrs\1.9.13\jackson-jaxrs-1.9.13.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\codehaus\jackson\jackson-xc\1.9.13\jackson-xc-1.9.13.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\hadoop\hadoop-mapreduce-client-jobclient\2.6.5\hadoop-mapreduce-client-jobclient-2.6.5.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\hadoop\hadoop-annotations\2.6.5\hadoop-annotations-2.6.5.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\spark\spark-launcher_2.11\2.3.1\spark-launcher_2.11-2.3.1.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\spark\spark-kvstore_2.11\2.3.1\spark-kvstore_2.11-2.3.1.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\fusesource\leveldbjni\leveldbjni-all\1.8\leveldbjni-all-1.8.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\com\fasterxml\jackson\core\jackson-core\2.6.7\jackson-core-2.6.7.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\com\fasterxml\jackson\core\jackson-annotations\2.6.7\jackson-annotations-2.6.7.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\spark\spark-network-common_2.11\2.3.1\spark-network-common_2.11-2.3.1.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\spark\spark-network-shuffle_2.11\2.3.1\spark-network-shuffle_2.11-2.3.1.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\spark\spark-unsafe_2.11\2.3.1\spark-unsafe_2.11-2.3.1.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\net\java\dev\jets3t\jets3t\0.9.4\jets3t-0.9.4.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\httpcomponents\httpcore\4.4.1\httpcore-4.4.1.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\javax\activation\activation\1.1.1\activation-1.1.1.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\bouncycastle\bcprov-jdk15on\1.52\bcprov-jdk15on-1.52.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\com\jamesmurty\utils\java-xmlbuilder\1.1\java-xmlbuilder-1.1.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\net\iharder\base64\2.3.8\base64-2.3.8.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\curator\curator-recipes\2.6.0\curator-recipes-2.6.0.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\curator\curator-framework\2.6.0\curator-framework-2.6.0.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\zookeeper\zookeeper\3.4.6\zookeeper-3.4.6.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\com\google\guava\guava\16.0.1\guava-16.0.1.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\javax\servlet\javax.servlet-api\3.1.0\javax.servlet-api-3.1.0.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\commons\commons-lang3\3.5\commons-lang3-3.5.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\commons\commons-math3\3.4.1\commons-math3-3.4.1.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\com\google\code\findbugs\jsr305\1.3.9\jsr305-1.3.9.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\slf4j\slf4j-api\1.7.16\slf4j-api-1.7.16.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\slf4j\jul-to-slf4j\1.7.16\jul-to-slf4j-1.7.16.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\slf4j\jcl-over-slf4j\1.7.16\jcl-over-slf4j-1.7.16.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\log4j\log4j\1.2.17\log4j-1.2.17.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\slf4j\slf4j-log4j12\1.7.16\slf4j-log4j12-1.7.16.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\com\ning\compress-lzf\1.0.3\compress-lzf-1.0.3.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\xerial\snappy\snappy-java\1.1.2.6\snappy-java-1.1.2.6.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\lz4\lz4-java\1.4.0\lz4-java-1.4.0.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\com\github\luben\zstd-jni\1.3.2-2\zstd-jni-1.3.2-2.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\roaringbitmap\RoaringBitmap\0.5.11\RoaringBitmap-0.5.11.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\commons-net\commons-net\2.2\commons-net-2.2.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\scala-lang\scala-library\2.11.8\scala-library-2.11.8.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\json4s\json4s-jackson_2.11\3.2.11\json4s-jackson_2.11-3.2.11.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\json4s\json4s-core_2.11\3.2.11\json4s-core_2.11-3.2.11.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\json4s\json4s-ast_2.11\3.2.11\json4s-ast_2.11-3.2.11.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\scala-lang\scalap\2.11.0\scalap-2.11.0.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\scala-lang\scala-compiler\2.11.0\scala-compiler-2.11.0.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\scala-lang\modules\scala-xml_2.11\1.0.1\scala-xml_2.11-1.0.1.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\glassfish\jersey\core\jersey-client\2.22.2\jersey-client-2.22.2.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\javax\ws\rs\javax.ws.rs-api\2.0.1\javax.ws.rs-api-2.0.1.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\glassfish\hk2\hk2-api\2.4.0-b34\hk2-api-2.4.0-b34.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\glassfish\hk2\hk2-utils\2.4.0-b34\hk2-utils-2.4.0-b34.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\glassfish\hk2\external\aopalliance-repackaged\2.4.0-b34\aopalliance-repackaged-2.4.0-b34.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\glassfish\hk2\external\javax.inject\2.4.0-b34\javax.inject-2.4.0-b34.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\glassfish\hk2\hk2-locator\2.4.0-b34\hk2-locator-2.4.0-b34.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\javassist\javassist\3.18.1-GA\javassist-3.18.1-GA.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\glassfish\jersey\core\jersey-common\2.22.2\jersey-common-2.22.2.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\javax\annotation\javax.annotation-api\1.2\javax.annotation-api-1.2.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\glassfish\jersey\bundles\repackaged\jersey-guava\2.22.2\jersey-guava-2.22.2.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\glassfish\hk2\osgi-resource-locator\1.0.1\osgi-resource-locator-1.0.1.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\glassfish\jersey\core\jersey-server\2.22.2\jersey-server-2.22.2.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\glassfish\jersey\media\jersey-media-jaxb\2.22.2\jersey-media-jaxb-2.22.2.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\javax\validation\validation-api\1.1.0.Final\validation-api-1.1.0.Final.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\glassfish\jersey\containers\jersey-container-servlet\2.22.2\jersey-container-servlet-2.22.2.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\glassfish\jersey\containers\jersey-container-servlet-core\2.22.2\jersey-container-servlet-core-2.22.2.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\io\netty\netty-all\4.1.17.Final\netty-all-4.1.17.Final.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\io\netty\netty\3.9.9.Final\netty-3.9.9.Final.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\com\clearspring\analytics\stream\2.7.0\stream-2.7.0.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\io\dropwizard\metrics\metrics-core\3.1.5\metrics-core-3.1.5.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\io\dropwizard\metrics\metrics-jvm\3.1.5\metrics-jvm-3.1.5.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\io\dropwizard\metrics\metrics-json\3.1.5\metrics-json-3.1.5.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\io\dropwizard\metrics\metrics-graphite\3.1.5\metrics-graphite-3.1.5.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\com\fasterxml\jackson\core\jackson-databind\2.6.7.1\jackson-databind-2.6.7.1.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\com\fasterxml\jackson\module\jackson-module-scala_2.11\2.6.7.1\jackson-module-scala_2.11-2.6.7.1.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\scala-lang\scala-reflect\2.11.8\scala-reflect-2.11.8.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\com\fasterxml\jackson\module\jackson-module-paranamer\2.7.9\jackson-module-paranamer-2.7.9.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\ivy\ivy\2.4.0\ivy-2.4.0.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\oro\oro\2.0.8\oro-2.0.8.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\net\razorvine\pyrolite\4.13\pyrolite-4.13.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\net\sf\py4j\py4j\0.10.7\py4j-0.10.7.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\spark\spark-tags_2.11\2.3.1\spark-tags_2.11-2.3.1.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\commons\commons-crypto\1.0.0\commons-crypto-1.0.0.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\spark-project\spark\unused\1.0.0\unused-1.0.0.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\spark\spark-sql_2.11\2.3.1\spark-sql_2.11-2.3.1.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\com\univocity\univocity-parsers\2.5.9\univocity-parsers-2.5.9.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\spark\spark-sketch_2.11\2.3.1\spark-sketch_2.11-2.3.1.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\spark\spark-catalyst_2.11\2.3.1\spark-catalyst_2.11-2.3.1.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\scala-lang\modules\scala-parser-combinators_2.11\1.0.4\scala-parser-combinators_2.11-1.0.4.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\codehaus\janino\janino\3.0.8\janino-3.0.8.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\codehaus\janino\commons-compiler\3.0.8\commons-compiler-3.0.8.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\antlr\antlr4-runtime\4.7\antlr4-runtime-4.7.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\orc\orc-core\1.4.4\orc-core-1.4.4-nohive.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\com\google\protobuf\protobuf-java\2.5.0\protobuf-java-2.5.0.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\commons-lang\commons-lang\2.6\commons-lang-2.6.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\io\airlift\aircompressor\0.8\aircompressor-0.8.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\orc\orc-mapreduce\1.4.4\orc-mapreduce-1.4.4-nohive.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\parquet\parquet-column\1.8.3\parquet-column-1.8.3.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\parquet\parquet-common\1.8.3\parquet-common-1.8.3.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\parquet\parquet-encoding\1.8.3\parquet-encoding-1.8.3.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\parquet\parquet-hadoop\1.8.3\parquet-hadoop-1.8.3.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\parquet\parquet-format\2.3.1\parquet-format-2.3.1.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\parquet\parquet-jackson\1.8.3\parquet-jackson-1.8.3.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\arrow\arrow-vector\0.8.0\arrow-vector-0.8.0.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\arrow\arrow-format\0.8.0\arrow-format-0.8.0.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\arrow\arrow-memory\0.8.0\arrow-memory-0.8.0.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\com\carrotsearch\hppc\0.7.2\hppc-0.7.2.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\com\vlkan\flatbuffers\1.2.0-3f79e055\flatbuffers-1.2.0-3f79e055.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\spark\spark-hive_2.11\2.3.1\spark-hive_2.11-2.3.1.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\com\twitter\parquet-hadoop-bundle\1.6.0\parquet-hadoop-bundle-1.6.0.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\spark-project\hive\hive-exec\1.2.1.spark2\hive-exec-1.2.1.spark2.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\commons-io\commons-io\2.4\commons-io-2.4.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\javolution\javolution\5.5.1\javolution-5.5.1.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\log4j\apache-log4j-extras\1.2.17\apache-log4j-extras-1.2.17.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\antlr\antlr-runtime\3.4\antlr-runtime-3.4.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\antlr\stringtemplate\3.2.1\stringtemplate-3.2.1.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\antlr\antlr\2.7.7\antlr-2.7.7.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\antlr\ST4\4.0.4\ST4-4.0.4.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\com\googlecode\javaewah\JavaEWAH\0.3.2\JavaEWAH-0.3.2.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\iq80\snappy\snappy\0.2\snappy-0.2.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\stax\stax-api\1.0.1\stax-api-1.0.1.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\net\sf\opencsv\opencsv\2.3\opencsv-2.3.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\spark-project\hive\hive-metastore\1.2.1.spark2\hive-metastore-1.2.1.spark2.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\com\jolbox\bonecp\0.8.0.RELEASE\bonecp-0.8.0.RELEASE.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\commons-cli\commons-cli\1.2\commons-cli-1.2.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\commons-logging\commons-logging\1.1.3\commons-logging-1.1.3.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\datanucleus\datanucleus-api-jdo\3.2.6\datanucleus-api-jdo-3.2.6.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\datanucleus\datanucleus-rdbms\3.2.9\datanucleus-rdbms-3.2.9.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\commons-pool\commons-pool\1.5.4\commons-pool-1.5.4.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\commons-dbcp\commons-dbcp\1.4\commons-dbcp-1.4.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\javax\jdo\jdo-api\3.0.1\jdo-api-3.0.1.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\javax\transaction\jta\1.1\jta-1.1.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\commons-httpclient\commons-httpclient\3.1\commons-httpclient-3.1.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\calcite\calcite-avatica\1.2.0-incubating\calcite-avatica-1.2.0-incubating.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\calcite\calcite-core\1.2.0-incubating\calcite-core-1.2.0-incubating.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\calcite\calcite-linq4j\1.2.0-incubating\calcite-linq4j-1.2.0-incubating.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\net\hydromatic\eigenbase-properties\1.1.5\eigenbase-properties-1.1.5.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\httpcomponents\httpclient\4.5.4\httpclient-4.5.4.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\codehaus\jackson\jackson-mapper-asl\1.9.13\jackson-mapper-asl-1.9.13.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\commons-codec\commons-codec\1.10\commons-codec-1.10.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\joda-time\joda-time\2.9.3\joda-time-2.9.3.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\jodd\jodd-core\3.5.2\jodd-core-3.5.2.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\datanucleus\datanucleus-core\3.2.10\datanucleus-core-3.2.10.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\thrift\libthrift\0.9.3\libthrift-0.9.3.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\thrift\libfb303\0.9.3\libfb303-0.9.3.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\derby\derby\10.12.1.1\derby-10.12.1.1.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\spark\spark-streaming_2.11\2.3.1\spark-streaming_2.11-2.3.1.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\com\databricks\spark-csv_2.10\1.4.0\spark-csv_2.10-1.4.0.jar;D:\DcBrowserDownloads\apache-maven-3.6.3-bin\localRepository\org\apache\commons\commons-csv\1.1\commons-csv-1.1.jar" App
start
Exception in thread "main" java.lang.VerifyError: class scala.collection.mutable.WrappedArray overrides final method toBuffer.()Lscala/collection/mutable/Buffer;
   at java.lang.ClassLoader.defineClass1(Native Method)
   at java.lang.ClassLoader.defineClass(ClassLoader.java:763)
   at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142)
   at java.net.URLClassLoader.defineClass(URLClassLoader.java:467)
   at java.net.URLClassLoader.access$100(URLClassLoader.java:73)
   at java.net.URLClassLoader$1.run(URLClassLoader.java:368)
   at java.net.URLClassLoader$1.run(URLClassLoader.java:362)
   at java.security.AccessController.doPrivileged(Native Method)
   at java.net.URLClassLoader.findClass(URLClassLoader.java:361)
   at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
   at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331)
   at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
   at org.apache.spark.SparkConf.loadFromSystemProperties(SparkConf.scala:75)
   at org.apache.spark.SparkConf.<init>(SparkConf.scala:70)
   at org.apache.spark.SparkConf.<init>(SparkConf.scala:57)
   at App$.main(App.scala:10)
   at App.main(App.scala)

Process finished with exit code 1
--------------------------------------------------------------------------------------------------------------------------------------------------------

1. 试了将pom中的scala和spark对应版本改过几次无效。

2. 试着IDEA中Global Libaraies >>scala sdk版本改过几次无效。

到目前还没有找到解决方法，请有相同遭遇或者大侠们侠义相助，求指教回复。

jdk 改为1.8.0_121 版本依然无效。

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

解决：应当在spark集群环境中运行。本地安装hadoop环境可解决。

振兴东北

关注

0
点赞
踩
6

收藏

觉得还不错? 一键收藏
0
评论
用IDEA scala 编写一个sparksql读写csv文件的代码

试着使用sparksql写一个读写csv文件。使用工具如下：1. IntelliJIDEA 2019.3.3 U E2. scala-sdk-2.11.123. jdk 1.8.0_91-------------------------------------------------------------------------------------------------...
复制链接

扫一扫

专栏目录