Spark高效数据分析03、Spack SQL
Spark高效数据分析03、Spack SQL
📋前言📋 💝博客：【红目香薰的博客_CSDN博客-计算机理论,2022年蓝桥杯,MySQL领域博主】💝 ✍本文由在下【红目香薰】原创，首发于CSDN✍ 🤗2022年最大愿望：【服务百万技术人次】🤗 💝Spark初始环境地址：【Spark高效数据分析01、idea开发环境搭建】💝
环境需求 环境：win10 开发工具：IntelliJ IDEA 2020.1.3 x64 maven版本：3.0.5
1、修改pom.xml
<dependencies>
<!-- https://mvnrepository.com/artifact/org.apache.spark/spark-core -->
<dependency>
<groupId>org.apache.spark</groupId>
<artifactId>spark-core_2.13</artifactId>
<version>3.3.0</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.apache.spark/spark-sql -->
<dependency>
<groupId>org.apache.spark</groupId>
<artifactId>spark-sql_2.13</artifactId>
<version>3.3.0</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.apache.spark/spark-streaming -->
<dependency>
<groupId>org.apache.spark</groupId>
<artifactId>spark-streaming_2.13</artifactId>
<version>3.3.0</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.apache.spark/spark-mllib -->
<dependency>
<groupId>org.apache.spark</groupId>
<artifactId>spark-mllib_2.13</artifactId>
<version>3.3.0</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.apache.spark/spark-hive -->
<dependency>
<groupId>org.apache.spark</groupId>
<artifactId>spark-hive_2.13</artifactId>
<version>3.3.0</version>
</dependency>
</dependencies>修改完一定要刷新一下：
2、创建测试文件【info.json】，这里不是标准的json，面向行编写的【json】文件
{"name":"娉婷的彩亭", "age":19}
{"name":"静怡的梦莹", "age":20}
{"name":"潇洒的龙姑娘", "age":21}
{"name":"优雅的秋兰", "age":21}
{"name":"玲珑的巧蓉", "age":19}
别担心报错，可以正常读取的
数据2
{"name":"娉婷的星望", "age":19,"birthday": "2001-05-06 12:00:00","sex":"女"}
{"name":"静怡的雷静", "age":20,"birthday": "1999-05-02 12:00:00","sex":"女"}
{"name":"潇洒的春梦", "age":22,"birthday": "2000-01-06 12:00:00","sex":"女"}
{"name":"优雅的蓉菲", "age":21,"birthday": "2001-06-06 12:00:00","sex":"女"}
{"name":"玲珑的文静", "age":19,"birthday": "2002-05-09 12:00:00","sex":"女"}
{"name":"风雅的晓凤", "age":18,"birthday": "2004-05-09 12:00:00","sex":"女"}
3、SparkSession
SparkSession 是 Spark 最新的 SQL 查询起始点，实质上是 SQLContext 和 HiveContext 的组合。
val spark = SparkSession.builder()
.appName("Spark SQL").master("local[*]")
.getOrCreate()
import spark.implicits._4、Demo1
package com.item.action
import org.apache.spark.sql.SparkSession
object DemoSparkSQL {
def main(args: Array[String]) {
val spark = SparkSession.builder()
.appName("Spark SQL").master("local[*]")
.getOrCreate()
import spark.implicits._
val df = spark.read.json("src/info.json")
// df.show()//展示所有数据
// df.filter($"age" >= 20).show()//过滤年龄大于20的
df.createOrReplaceTempView("info")//创建一个视图
spark.sql("SELECT * FROM info where age >= 20")//sql数据
.show()//展示
spark.stop()
}
}C:\java\jdk\jdk1.8.0_152\bin\java.exe "-javaagent:C:\java\IDEA\IntelliJ IDEA 2020.1.3\lib\idea_rt.jar=57086:C:\java\IDEA\IntelliJ IDEA 2020.1.3\bin" -Dfile.encoding=UTF-8 -classpath C:\java\jdk\jdk1.8.0_152\jre\lib\charsets.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\deploy.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\ext\access-bridge-64.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\ext\cldrdata.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\ext\dnsns.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\ext\jaccess.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\ext\jfxrt.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\ext\localedata.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\ext\nashorn.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\ext\sunec.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\ext\sunjce_provider.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\ext\sunmscapi.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\ext\sunpkcs11.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\ext\zipfs.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\javaws.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\jce.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\jfr.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\jfxswt.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\jsse.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\management-agent.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\plugin.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\resources.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\rt.jar;C:\Users\Administrator\IdeaProjects\baidu1\target\classes;C:\Users\Administrator\.ivy2\cache\org.scala-lang\scala-library\jars\scala-library-2.13.8.jar;C:\Users\Administrator\.ivy2\cache\org.scala-lang\scala-reflect\jars\scala-reflect-2.13.8.jar;C:\Users\Administrator\.ivy2\cache\org.scala-lang\scala-library\srcs\scala-library-2.13.8-sources.jar;D:\old\newPro\org\apache\spark\spark-core_2.13\3.3.0\spark-core_2.13-3.3.0.jar;D:\old\newPro\org\scala-lang\modules\scala-parallel-collections_2.13\1.0.3\scala-parallel-collections_2.13-1.0.3.jar;D:\old\newPro\org\apache\avro\avro\1.11.0\avro-1.11.0.jar;D:\old\newPro\com\fasterxml\jackson\core\jackson-core\2.12.5\jackson-core-2.12.5.jar;D:\old\newPro\org\apache\commons\commons-compress\1.21\commons-compress-1.21.jar;D:\old\newPro\org\apache\avro\avro-mapred\1.11.0\avro-mapred-1.11.0.jar;D:\old\newPro\org\apache\avro\avro-ipc\1.11.0\avro-ipc-1.11.0.jar;D:\old\newPro\org\tukaani\xz\1.9\xz-1.9.jar;D:\old\newPro\com\twitter\chill_2.13\0.10.0\chill_2.13-0.10.0.jar;D:\old\newPro\com\esotericsoftware\kryo-shaded\4.0.2\kryo-shaded-4.0.2.jar;D:\old\newPro\com\esotericsoftware\minlog\1.3.0\minlog-1.3.0.jar;D:\old\newPro\org\objenesis\objenesis\2.5.1\objenesis-2.5.1.jar;D:\old\newPro\com\twitter\chill-java\0.10.0\chill-java-0.10.0.jar;D:\old\newPro\org\apache\xbean\xbean-asm9-shaded\4.20\xbean-asm9-shaded-4.20.jar;D:\old\newPro\org\apache\hadoop\hadoop-client-api\3.3.2\hadoop-client-api-3.3.2.jar;D:\old\newPro\org\apache\hadoop\hadoop-client-runtime\3.3.2\hadoop-client-runtime-3.3.2.jar;D:\old\newPro\commons-logging\commons-logging\1.1.3\commons-logging-1.1.3.jar;D:\old\newPro\org\apache\spark\spark-launcher_2.13\3.3.0\spark-launcher_2.13-3.3.0.jar;D:\old\newPro\org\apache\spark\spark-kvstore_2.13\3.3.0\spark-kvstore_2.13-3.3.0.jar;D:\old\newPro\org\fusesource\leveldbjni\leveldbjni-all\1.8\leveldbjni-all-1.8.jar;D:\old\newPro\com\fasterxml\jackson\core\jackson-annotations\2.13.3\jackson-annotations-2.13.3.jar;D:\old\newPro\org\apache\spark\spark-network-common_2.13\3.3.0\spark-network-common_2.13-3.3.0.jar;D:\old\newPro\com\google\crypto\tink\tink\1.6.1\tink-1.6.1.jar;D:\old\newPro\org\apache\spark\spark-network-shuffle_2.13\3.3.0\spark-network-shuffle_2.13-3.3.0.jar;D:\old\newPro\org\apache\spark\spark-unsafe_2.13\3.3.0\spark-unsafe_2.13-3.3.0.jar;D:\old\newPro\javax\activation\activation\1.1.1\activation-1.1.1.jar;D:\old\newPro\org\apache\curator\curator-recipes\2.13.0\curator-recipes-2.13.0.jar;D:\old\newPro\org\apache\curator\curator-framework\2.13.0\curator-framework-2.13.0.jar;D:\old\newPro\org\apache\curator\curator-client\2.13.0\curator-client-2.13.0.jar;D:\old\newPro\org\apache\zookeeper\zookeeper\3.6.2\zookeeper-3.6.2.jar;D:\old\newPro\commons-lang\commons-lang\2.6\commons-lang-2.6.jar;D:\old\newPro\org\apache\zookeeper\zookeeper-jute\3.6.2\zookeeper-jute-3.6.2.jar;D:\old\newPro\org\apache\yetus\audience-annotations\0.5.0\audience-annotations-0.5.0.jar;D:\old\newPro\jakarta\servlet\jakarta.servlet-api\4.0.3\jakarta.servlet-api-4.0.3.jar;D:\old\newPro\commons-codec\commons-codec\1.15\commons-codec-1.15.jar;D:\old\newPro\org\apache\commons\commons-lang3\3.12.0\commons-lang3-3.12.0.jar;D:\old\newPro\org\apache\commons\commons-math3\3.6.1\commons-math3-3.6.1.jar;D:\old\newPro\org\apache\commons\commons-text\1.9\commons-text-1.9.jar;D:\old\newPro\commons-io\commons-io\2.11.0\commons-io-2.11.0.jar;D:\old\newPro\commons-collections\commons-collections\3.2.2\commons-collections-3.2.2.jar;D:\old\newPro\org\apache\commons\commons-collections4\4.4\commons-collections4-4.4.jar;D:\old\newPro\com\google\code\findbugs\jsr305\3.0.0\jsr305-3.0.0.jar;D:\old\newPro\org\slf4j\slf4j-api\1.7.32\slf4j-api-1.7.32.jar;D:\old\newPro\org\slf4j\jul-to-slf4j\1.7.32\jul-to-slf4j-1.7.32.jar;D:\old\newPro\org\slf4j\jcl-over-slf4j\1.7.32\jcl-over-slf4j-1.7.32.jar;D:\old\newPro\org\apache\logging\log4j\log4j-slf4j-impl\2.17.2\log4j-slf4j-impl-2.17.2.jar;D:\old\newPro\org\apache\logging\log4j\log4j-api\2.17.2\log4j-api-2.17.2.jar;D:\old\newPro\org\apache\logging\log4j\log4j-core\2.17.2\log4j-core-2.17.2.jar;D:\old\newPro\org\apache\logging\log4j\log4j-1.2-api\2.17.2\log4j-1.2-api-2.17.2.jar;D:\old\newPro\com\ning\compress-lzf\1.1\compress-lzf-1.1.jar;D:\old\newPro\org\xerial\snappy\snappy-java\1.1.8.4\snappy-java-1.1.8.4.jar;D:\old\newPro\org\lz4\lz4-java\1.8.0\lz4-java-1.8.0.jar;D:\old\newPro\com\github\luben\zstd-jni\1.5.2-1\zstd-jni-1.5.2-1.jar;D:\old\newPro\org\roaringbitmap\RoaringBitmap\0.9.25\RoaringBitmap-0.9.25.jar;D:\old\newPro\org\roaringbitmap\shims\0.9.25\shims-0.9.25.jar;D:\old\newPro\org\scala-lang\modules\scala-xml_2.13\1.2.0\scala-xml_2.13-1.2.0.jar;D:\old\newPro\org\scala-lang\scala-library\2.13.8\scala-library-2.13.8.jar;D:\old\newPro\org\scala-lang\scala-reflect\2.13.8\scala-reflect-2.13.8.jar;D:\old\newPro\org\json4s\json4s-jackson_2.13\3.7.0-M11\json4s-jackson_2.13-3.7.0-M11.jar;D:\old\newPro\org\json4s\json4s-core_2.13\3.7.0-M11\json4s-core_2.13-3.7.0-M11.jar;D:\old\newPro\org\json4s\json4s-ast_2.13\3.7.0-M11\json4s-ast_2.13-3.7.0-M11.jar;D:\old\newPro\org\json4s\json4s-scalap_2.13\3.7.0-M11\json4s-scalap_2.13-3.7.0-M11.jar;D:\old\newPro\org\glassfish\jersey\core\jersey-client\2.34\jersey-client-2.34.jar;D:\old\newPro\jakarta\ws\rs\jakarta.ws.rs-api\2.1.6\jakarta.ws.rs-api-2.1.6.jar;D:\old\newPro\org\glassfish\hk2\external\jakarta.inject\2.6.1\jakarta.inject-2.6.1.jar;D:\old\newPro\org\glassfish\jersey\core\jersey-common\2.34\jersey-common-2.34.jar;D:\old\newPro\jakarta\annotation\jakarta.annotation-api\1.3.5\jakarta.annotation-api-1.3.5.jar;D:\old\newPro\org\glassfish\hk2\osgi-resource-locator\1.0.3\osgi-resource-locator-1.0.3.jar;D:\old\newPro\org\glassfish\jersey\core\jersey-server\2.34\jersey-server-2.34.jar;D:\old\newPro\jakarta\validation\jakarta.validation-api\2.0.2\jakarta.validation-api-2.0.2.jar;D:\old\newPro\org\glassfish\jersey\containers\jersey-container-servlet\2.34\jersey-container-servlet-2.34.jar;D:\old\newPro\org\glassfish\jersey\containers\jersey-container-servlet-core\2.34\jersey-container-servlet-core-2.34.jar;D:\old\newPro\org\glassfish\jersey\inject\jersey-hk2\2.34\jersey-hk2-2.34.jar;D:\old\newPro\org\glassfish\hk2\hk2-locator\2.6.1\hk2-locator-2.6.1.jar;D:\old\newPro\org\glassfish\hk2\external\aopalliance-repackaged\2.6.1\aopalliance-repackaged-2.6.1.jar;D:\old\newPro\org\glassfish\hk2\hk2-api\2.6.1\hk2-api-2.6.1.jar;D:\old\newPro\org\glassfish\hk2\hk2-utils\2.6.1\hk2-utils-2.6.1.jar;D:\old\newPro\org\javassist\javassist\3.25.0-GA\javassist-3.25.0-GA.jar;D:\old\newPro\io\netty\netty-all\4.1.74.Final\netty-all-4.1.74.Final.jar;D:\old\newPro\io\netty\netty-buffer\4.1.74.Final\netty-buffer-4.1.74.Final.jar;D:\old\newPro\io\netty\netty-codec\4.1.74.Final\netty-codec-4.1.74.Final.jar;D:\old\newPro\io\netty\netty-common\4.1.74.Final\netty-common-4.1.74.Final.jar;D:\old\newPro\io\netty\netty-handler\4.1.74.Final\netty-handler-4.1.74.Final.jar;D:\old\newPro\io\netty\netty-tcnative-classes\2.0.48.Final\netty-tcnative-classes-2.0.48.Final.jar;D:\old\newPro\io\netty\netty-resolver\4.1.74.Final\netty-resolver-4.1.74.Final.jar;D:\old\newPro\io\netty\netty-transport\4.1.74.Final\netty-transport-4.1.74.Final.jar;D:\old\newPro\io\netty\netty-transport-classes-epoll\4.1.74.Final\netty-transport-classes-epoll-4.1.74.Final.jar;D:\old\newPro\io\netty\netty-transport-native-unix-common\4.1.74.Final\netty-transport-native-unix-common-4.1.74.Final.jar;D:\old\newPro\io\netty\netty-transport-classes-kqueue\4.1.74.Final\netty-transport-classes-kqueue-4.1.74.Final.jar;D:\old\newPro\io\netty\netty-transport-native-epoll\4.1.74.Final\netty-transport-native-epoll-4.1.74.Final-linux-x86_64.jar;D:\old\newPro\io\netty\netty-transport-native-epoll\4.1.74.Final\netty-transport-native-epoll-4.1.74.Final-linux-aarch_64.jar;D:\old\newPro\io\netty\netty-transport-native-kqueue\4.1.74.Final\netty-transport-native-kqueue-4.1.74.Final-osx-x86_64.jar;D:\old\newPro\io\netty\netty-transport-native-kqueue\4.1.74.Final\netty-transport-native-kqueue-4.1.74.Final-osx-aarch_64.jar;D:\old\newPro\com\clearspring\analytics\stream\2.9.6\stream-2.9.6.jar;D:\old\newPro\io\dropwizard\metrics\metrics-core\4.2.7\metrics-core-4.2.7.jar;D:\old\newPro\io\dropwizard\metrics\metrics-jvm\4.2.7\metrics-jvm-4.2.7.jar;D:\old\newPro\io\dropwizard\metrics\metrics-json\4.2.7\metrics-json-4.2.7.jar;D:\old\newPro\io\dropwizard\metrics\metrics-graphite\4.2.7\metrics-graphite-4.2.7.jar;D:\old\newPro\io\dropwizard\metrics\metrics-jmx\4.2.7\metrics-jmx-4.2.7.jar;D:\old\newPro\com\fasterxml\jackson\core\jackson-databind\2.13.3\jackson-databind-2.13.3.jar;D:\old\newPro\com\fasterxml\jackson\module\jackson-module-scala_2.13\2.13.3\jackson-module-scala_2.13-2.13.3.jar;D:\old\newPro\com\thoughtworks\paranamer\paranamer\2.8\paranamer-2.8.jar;D:\old\newPro\org\apache\ivy\ivy\2.5.0\ivy-2.5.0.jar;D:\old\newPro\oro\oro\2.0.8\oro-2.0.8.jar;D:\old\newPro\net\razorvine\pickle\1.2\pickle-1.2.jar;D:\old\newPro\net\sf\py4j\py4j\0.10.9.5\py4j-0.10.9.5.jar;D:\old\newPro\org\apache\spark\spark-tags_2.13\3.3.0\spark-tags_2.13-3.3.0.jar;D:\old\newPro\org\apache\commons\commons-crypto\1.1.0\commons-crypto-1.1.0.jar;D:\old\newPro\org\spark-project\spark\unused\1.0.0\unused-1.0.0.jar;D:\old\newPro\org\apache\spark\spark-sql_2.13\3.3.0\spark-sql_2.13-3.3.0.jar;D:\old\newPro\org\rocksdb\rocksdbjni\6.20.3\rocksdbjni-6.20.3.jar;D:\old\newPro\com\univocity\univocity-parsers\2.9.1\univocity-parsers-2.9.1.jar;D:\old\newPro\org\apache\spark\spark-sketch_2.13\3.3.0\spark-sketch_2.13-3.3.0.jar;D:\old\newPro\org\apache\spark\spark-catalyst_2.13\3.3.0\spark-catalyst_2.13-3.3.0.jar;D:\old\newPro\org\codehaus\janino\janino\3.0.16\janino-3.0.16.jar;D:\old\newPro\org\codehaus\janino\commons-compiler\3.0.16\commons-compiler-3.0.16.jar;D:\old\newPro\org\antlr\antlr4-runtime\4.8\antlr4-runtime-4.8.jar;D:\old\newPro\org\apache\arrow\arrow-vector\7.0.0\arrow-vector-7.0.0.jar;D:\old\newPro\org\apache\arrow\arrow-format\7.0.0\arrow-format-7.0.0.jar;D:\old\newPro\org\apache\arrow\arrow-memory-core\7.0.0\arrow-memory-core-7.0.0.jar;D:\old\newPro\com\google\flatbuffers\flatbuffers-java\1.12.0\flatbuffers-java-1.12.0.jar;D:\old\newPro\org\apache\arrow\arrow-memory-netty\7.0.0\arrow-memory-netty-7.0.0.jar;D:\old\newPro\org\apache\orc\orc-core\1.7.4\orc-core-1.7.4.jar;D:\old\newPro\org\apache\orc\orc-shims\1.7.4\orc-shims-1.7.4.jar;D:\old\newPro\com\google\protobuf\protobuf-java\2.5.0\protobuf-java-2.5.0.jar;D:\old\newPro\io\airlift\aircompressor\0.21\aircompressor-0.21.jar;D:\old\newPro\org\jetbrains\annotations\17.0.0\annotations-17.0.0.jar;D:\old\newPro\org\threeten\threeten-extra\1.5.0\threeten-extra-1.5.0.jar;D:\old\newPro\org\apache\orc\orc-mapreduce\1.7.4\orc-mapreduce-1.7.4.jar;D:\old\newPro\org\apache\hive\hive-storage-api\2.7.2\hive-storage-api-2.7.2.jar;D:\old\newPro\org\apache\parquet\parquet-column\1.12.2\parquet-column-1.12.2.jar;D:\old\newPro\org\apache\parquet\parquet-common\1.12.2\parquet-common-1.12.2.jar;D:\old\newPro\org\apache\parquet\parquet-encoding\1.12.2\parquet-encoding-1.12.2.jar;D:\old\newPro\org\apache\parquet\parquet-hadoop\1.12.2\parquet-hadoop-1.12.2.jar;D:\old\newPro\org\apache\parquet\parquet-format-structures\1.12.2\parquet-format-structures-1.12.2.jar;D:\old\newPro\org\apache\parquet\parquet-jackson\1.12.2\parquet-jackson-1.12.2.jar;D:\old\newPro\org\apache\spark\spark-streaming_2.13\3.3.0\spark-streaming_2.13-3.3.0.jar;D:\old\newPro\org\apache\spark\spark-mllib_2.13\3.3.0\spark-mllib_2.13-3.3.0.jar;D:\old\newPro\org\scala-lang\modules\scala-parser-combinators_2.13\1.1.2\scala-parser-combinators_2.13-1.1.2.jar;D:\old\newPro\org\apache\spark\spark-graphx_2.13\3.3.0\spark-graphx_2.13-3.3.0.jar;D:\old\newPro\net\sourceforge\f2j\arpack_combined_all\0.1\arpack_combined_all-0.1.jar;D:\old\newPro\org\apache\spark\spark-mllib-local_2.13\3.3.0\spark-mllib-local_2.13-3.3.0.jar;D:\old\newPro\org\scalanlp\breeze_2.13\1.2\breeze_2.13-1.2.jar;D:\old\newPro\org\scalanlp\breeze-macros_2.13\1.2\breeze-macros_2.13-1.2.jar;D:\old\newPro\com\github\fommil\netlib\core\1.1.2\core-1.1.2.jar;D:\old\newPro\net\sf\opencsv\opencsv\2.3\opencsv-2.3.jar;D:\old\newPro\com\github\wendykierp\JTransforms\3.1\JTransforms-3.1.jar;D:\old\newPro\pl\edu\icm\JLargeArrays\1.5\JLargeArrays-1.5.jar;D:\old\newPro\com\chuusai\shapeless_2.13\2.3.3\shapeless_2.13-2.3.3.jar;D:\old\newPro\org\typelevel\spire_2.13\0.17.0\spire_2.13-0.17.0.jar;D:\old\newPro\org\typelevel\spire-macros_2.13\0.17.0\spire-macros_2.13-0.17.0.jar;D:\old\newPro\org\typelevel\spire-platform_2.13\0.17.0\spire-platform_2.13-0.17.0.jar;D:\old\newPro\org\typelevel\spire-util_2.13\0.17.0\spire-util_2.13-0.17.0.jar;D:\old\newPro\org\typelevel\algebra_2.13\2.0.1\algebra_2.13-2.0.1.jar;D:\old\newPro\org\typelevel\cats-kernel_2.13\2.1.1\cats-kernel_2.13-2.1.1.jar;D:\old\newPro\org\scala-lang\modules\scala-collection-compat_2.13\2.1.1\scala-collection-compat_2.13-2.1.1.jar;D:\old\newPro\org\glassfish\jaxb\jaxb-runtime\2.3.2\jaxb-runtime-2.3.2.jar;D:\old\newPro\jakarta\xml\bind\jakarta.xml.bind-api\2.3.2\jakarta.xml.bind-api-2.3.2.jar;D:\old\newPro\com\sun\istack\istack-commons-runtime\3.0.8\istack-commons-runtime-3.0.8.jar;D:\old\newPro\dev\ludovic\netlib\blas\2.2.1\blas-2.2.1.jar;D:\old\newPro\dev\ludovic\netlib\lapack\2.2.1\lapack-2.2.1.jar;D:\old\newPro\dev\ludovic\netlib\arpack\2.2.1\arpack-2.2.1.jar;D:\old\newPro\org\apache\spark\spark-hive_2.13\3.3.0\spark-hive_2.13-3.3.0.jar;D:\old\newPro\org\apache\hive\hive-common\2.3.9\hive-common-2.3.9.jar;D:\old\newPro\commons-cli\commons-cli\1.2\commons-cli-1.2.jar;D:\old\newPro\jline\jline\2.12\jline-2.12.jar;D:\old\newPro\com\tdunning\json\1.8\json-1.8.jar;D:\old\newPro\com\github\joshelser\dropwizard-metrics-hadoop-metrics2-reporter\0.1.2\dropwizard-metrics-hadoop-metrics2-reporter-0.1.2.jar;D:\old\newPro\org\apache\hive\hive-exec\2.3.9\hive-exec-2.3.9-core.jar;D:\old\newPro\org\apache\hive\hive-vector-code-gen\2.3.9\hive-vector-code-gen-2.3.9.jar;D:\old\newPro\com\google\guava\guava\14.0.1\guava-14.0.1.jar;D:\old\newPro\org\apache\velocity\velocity\1.5\velocity-1.5.jar;D:\old\newPro\org\antlr\antlr-runtime\3.5.2\antlr-runtime-3.5.2.jar;D:\old\newPro\org\antlr\ST4\4.0.4\ST4-4.0.4.jar;D:\old\newPro\com\google\code\gson\gson\2.2.4\gson-2.2.4.jar;D:\old\newPro\stax\stax-api\1.0.1\stax-api-1.0.1.jar;D:\old\newPro\org\apache\hive\hive-metastore\2.3.9\hive-metastore-2.3.9.jar;D:\old\newPro\javolution\javolution\5.5.1\javolution-5.5.1.jar;D:\old\newPro\com\jolbox\bonecp\0.8.0.RELEASE\bonecp-0.8.0.RELEASE.jar;D:\old\newPro\com\zaxxer\HikariCP\2.5.1\HikariCP-2.5.1.jar;D:\old\newPro\org\datanucleus\datanucleus-api-jdo\4.2.4\datanucleus-api-jdo-4.2.4.jar;D:\old\newPro\org\datanucleus\datanucleus-rdbms\4.1.19\datanucleus-rdbms-4.1.19.jar;D:\old\newPro\commons-pool\commons-pool\1.5.4\commons-pool-1.5.4.jar;D:\old\newPro\commons-dbcp\commons-dbcp\1.4\commons-dbcp-1.4.jar;D:\old\newPro\javax\jdo\jdo-api\3.0.1\jdo-api-3.0.1.jar;D:\old\newPro\javax\transaction\jta\1.1\jta-1.1.jar;D:\old\newPro\org\datanucleus\javax.jdo\3.2.0-m3\javax.jdo-3.2.0-m3.jar;D:\old\newPro\javax\transaction\transaction-api\1.1\transaction-api-1.1.jar;D:\old\newPro\org\apache\hive\hive-serde\2.3.9\hive-serde-2.3.9.jar;D:\old\newPro\org\apache\hive\hive-shims\2.3.9\hive-shims-2.3.9.jar;D:\old\newPro\org\apache\hive\shims\hive-shims-common\2.3.9\hive-shims-common-2.3.9.jar;D:\old\newPro\org\apache\hive\shims\hive-shims-0.23\2.3.9\hive-shims-0.23-2.3.9.jar;D:\old\newPro\org\apache\hive\shims\hive-shims-scheduler\2.3.9\hive-shims-scheduler-2.3.9.jar;D:\old\newPro\org\apache\hive\hive-llap-common\2.3.9\hive-llap-common-2.3.9.jar;D:\old\newPro\org\apache\hive\hive-llap-client\2.3.9\hive-llap-client-2.3.9.jar;D:\old\newPro\org\apache\httpcomponents\httpclient\4.5.13\httpclient-4.5.13.jar;D:\old\newPro\org\apache\httpcomponents\httpcore\4.4.13\httpcore-4.4.13.jar;D:\old\newPro\org\codehaus\jackson\jackson-mapper-asl\1.9.13\jackson-mapper-asl-1.9.13.jar;D:\old\newPro\org\codehaus\jackson\jackson-core-asl\1.9.13\jackson-core-asl-1.9.13.jar;D:\old\newPro\joda-time\joda-time\2.10.13\joda-time-2.10.13.jar;D:\old\newPro\org\jodd\jodd-core\3.5.2\jodd-core-3.5.2.jar;D:\old\newPro\org\datanucleus\datanucleus-core\4.1.17\datanucleus-core-4.1.17.jar;D:\old\newPro\org\apache\thrift\libthrift\0.12.0\libthrift-0.12.0.jar;D:\old\newPro\org\apache\thrift\libfb303\0.9.3\libfb303-0.9.3.jar;D:\old\newPro\org\apache\derby\derby\10.14.2.0\derby-10.14.2.0.jar com.item.action.DemoSparkSQL Using Spark's default log4j profile: org/apache/spark/log4j2-defaults.properties 22/07/18 19:58:22 INFO SparkContext: Running Spark version 3.3.0 22/07/18 19:58:23 INFO ResourceUtils: ============================================================== 22/07/18 19:58:23 INFO ResourceUtils: No custom resources configured for spark.driver. 22/07/18 19:58:23 INFO ResourceUtils: ============================================================== 22/07/18 19:58:23 INFO SparkContext: Submitted application: Spark SQL 22/07/18 19:58:23 INFO ResourceProfile: Default ResourceProfile created, executor resources: Map(cores -> name: cores, amount: 1, script: , vendor: , memory -> name: memory, amount: 1024, script: , vendor: , offHeap -> name: offHeap, amount: 0, script: , vendor: ), task resources: Map(cpus -> name: cpus, amount: 1.0) 22/07/18 19:58:23 INFO ResourceProfile: Limiting resource is cpu 22/07/18 19:58:23 INFO ResourceProfileManager: Added ResourceProfile id: 0 22/07/18 19:58:23 INFO SecurityManager: Changing view acls to: Administrator 22/07/18 19:58:23 INFO SecurityManager: Changing modify acls to: Administrator 22/07/18 19:58:23 INFO SecurityManager: Changing view acls groups to: 22/07/18 19:58:23 INFO SecurityManager: Changing modify acls groups to: 22/07/18 19:58:23 INFO SecurityManager: SecurityManager: authentication disabled; ui acls disabled; users with view permissions: Set(Administrator); groups with view permissions: Set(); users with modify permissions: Set(Administrator); groups with modify permissions: Set() 22/07/18 19:58:23 INFO Utils: Successfully started service 'sparkDriver' on port 57125. 22/07/18 19:58:23 INFO SparkEnv: Registering MapOutputTracker 22/07/18 19:58:23 INFO SparkEnv: Registering BlockManagerMaster 22/07/18 19:58:23 INFO BlockManagerMasterEndpoint: Using org.apache.spark.storage.DefaultTopologyMapper for getting topology information 22/07/18 19:58:23 INFO BlockManagerMasterEndpoint: BlockManagerMasterEndpoint up 22/07/18 19:58:23 INFO SparkEnv: Registering BlockManagerMasterHeartbeat 22/07/18 19:58:23 INFO DiskBlockManager: Created local directory at C:\Users\Administrator\AppData\Local\Temp\blockmgr-bb1c5f1a-9493-481d-b6a5-7bb2105634d2 22/07/18 19:58:23 INFO MemoryStore: MemoryStore started with capacity 898.5 MiB 22/07/18 19:58:23 INFO SparkEnv: Registering OutputCommitCoordinator 22/07/18 19:58:24 INFO Utils: Successfully started service 'SparkUI' on port 4040. 22/07/18 19:58:24 INFO Executor: Starting executor ID driver on host 192.168.15.19 22/07/18 19:58:24 INFO Executor: Starting executor with user classpath (userClassPathFirst = false): '' 22/07/18 19:58:24 INFO Utils: Successfully started service 'org.apache.spark.network.netty.NettyBlockTransferService' on port 57168. 22/07/18 19:58:24 INFO NettyBlockTransferService: Server created on 192.168.15.19:57168 22/07/18 19:58:24 INFO BlockManager: Using org.apache.spark.storage.RandomBlockReplicationPolicy for block replication policy 22/07/18 19:58:24 INFO BlockManagerMaster: Registering BlockManager BlockManagerId(driver, 192.168.15.19, 57168, None) 22/07/18 19:58:24 INFO BlockManagerMasterEndpoint: Registering block manager 192.168.15.19:57168 with 898.5 MiB RAM, BlockManagerId(driver, 192.168.15.19, 57168, None) 22/07/18 19:58:24 INFO BlockManagerMaster: Registered BlockManager BlockManagerId(driver, 192.168.15.19, 57168, None) 22/07/18 19:58:24 INFO BlockManager: Initialized BlockManager: BlockManagerId(driver, 192.168.15.19, 57168, None) 22/07/18 19:58:24 INFO SharedState: Setting hive.metastore.warehouse.dir ('null') to the value of spark.sql.warehouse.dir. 22/07/18 19:58:24 INFO SharedState: Warehouse path is 'file:/C:/Users/Administrator/IdeaProjects/baidu1/spark-warehouse'. 22/07/18 19:58:25 INFO InMemoryFileIndex: It took 25 ms to list leaf files for 1 paths. 22/07/18 19:58:25 INFO InMemoryFileIndex: It took 1 ms to list leaf files for 1 paths. 22/07/18 19:58:27 INFO FileSourceStrategy: Pushed Filters: 22/07/18 19:58:27 INFO FileSourceStrategy: Post-Scan Filters: 22/07/18 19:58:27 INFO FileSourceStrategy: Output Data Schema: struct<value: string> 22/07/18 19:58:27 INFO MemoryStore: Block broadcast_0 stored as values in memory (estimated size 348.6 KiB, free 898.2 MiB) 22/07/18 19:58:27 INFO MemoryStore: Block broadcast_0_piece0 stored as bytes in memory (estimated size 33.7 KiB, free 898.1 MiB) 22/07/18 19:58:27 INFO BlockManagerInfo: Added broadcast_0_piece0 in memory on 192.168.15.19:57168 (size: 33.7 KiB, free: 898.5 MiB) 22/07/18 19:58:27 INFO SparkContext: Created broadcast 0 from json at DemoSparkSQL.scala:10 22/07/18 19:58:27 INFO FileSourceScanExec: Planning scan with bin packing, max size: 4194304 bytes, open cost is considered as scanning 4194304 bytes. 22/07/18 19:58:27 INFO SparkContext: Starting job: json at DemoSparkSQL.scala:10 22/07/18 19:58:27 INFO DAGScheduler: Got job 0 (json at DemoSparkSQL.scala:10) with 1 output partitions 22/07/18 19:58:27 INFO DAGScheduler: Final stage: ResultStage 0 (json at DemoSparkSQL.scala:10) 22/07/18 19:58:27 INFO DAGScheduler: Parents of final stage: List() 22/07/18 19:58:27 INFO DAGScheduler: Missing parents: List() 22/07/18 19:58:27 INFO DAGScheduler: Submitting ResultStage 0 (MapPartitionsRDD[3] at json at DemoSparkSQL.scala:10), which has no missing parents 22/07/18 19:58:27 INFO MemoryStore: Block broadcast_1 stored as values in memory (estimated size 14.2 KiB, free 898.1 MiB) 22/07/18 19:58:27 INFO MemoryStore: Block broadcast_1_piece0 stored as bytes in memory (estimated size 6.7 KiB, free 898.1 MiB) 22/07/18 19:58:27 INFO BlockManagerInfo: Added broadcast_1_piece0 in memory on 192.168.15.19:57168 (size: 6.7 KiB, free: 898.5 MiB) 22/07/18 19:58:27 INFO SparkContext: Created broadcast 1 from broadcast at DAGScheduler.scala:1513 22/07/18 19:58:27 INFO DAGScheduler: Submitting 1 missing tasks from ResultStage 0 (MapPartitionsRDD[3] at json at DemoSparkSQL.scala:10) (first 15 tasks are for partitions Vector(0)) 22/07/18 19:58:27 INFO TaskSchedulerImpl: Adding task set 0.0 with 1 tasks resource profile 0 22/07/18 19:58:27 INFO TaskSetManager: Starting task 0.0 in stage 0.0 (TID 0) (192.168.15.19, executor driver, partition 0, PROCESS_LOCAL, 7881 bytes) taskResourceAssignments Map() 22/07/18 19:58:27 INFO Executor: Running task 0.0 in stage 0.0 (TID 0) 22/07/18 19:58:27 INFO FileScanRDD: Reading File path: file:///C:/Users/Administrator/IdeaProjects/baidu1/src/info.json, range: 0-191, partition values: [empty row] 22/07/18 19:58:28 INFO CodeGenerator: Code generated in 193.9552 ms 22/07/18 19:58:28 INFO Executor: Finished task 0.0 in stage 0.0 (TID 0). 2167 bytes result sent to driver 22/07/18 19:58:28 INFO TaskSetManager: Finished task 0.0 in stage 0.0 (TID 0) in 553 ms on 192.168.15.19 (executor driver) (1/1) 22/07/18 19:58:28 INFO TaskSchedulerImpl: Removed TaskSet 0.0, whose tasks have all completed, from pool 22/07/18 19:58:28 INFO DAGScheduler: ResultStage 0 (json at DemoSparkSQL.scala:10) finished in 0.728 s 22/07/18 19:58:28 INFO DAGScheduler: Job 0 is finished. Cancelling potential speculative or zombie tasks for this job 22/07/18 19:58:28 INFO TaskSchedulerImpl: Killing all running tasks in stage 0: Stage finished 22/07/18 19:58:28 INFO DAGScheduler: Job 0 finished: json at DemoSparkSQL.scala:10, took 0.766775 s 22/07/18 19:58:28 INFO FileSourceStrategy: Pushed Filters: IsNotNull(age),GreaterThanOrEqual(age,20) 22/07/18 19:58:28 INFO FileSourceStrategy: Post-Scan Filters: isnotnull(age#8L),(age#8L >= 20) 22/07/18 19:58:28 INFO FileSourceStrategy: Output Data Schema: struct<age: bigint, name: string> 22/07/18 19:58:28 INFO CodeGenerator: Code generated in 19.7363 ms 22/07/18 19:58:28 INFO MemoryStore: Block broadcast_2 stored as values in memory (estimated size 348.5 KiB, free 897.8 MiB) 22/07/18 19:58:28 INFO MemoryStore: Block broadcast_2_piece0 stored as bytes in memory (estimated size 33.7 KiB, free 897.7 MiB) 22/07/18 19:58:28 INFO BlockManagerInfo: Added broadcast_2_piece0 in memory on 192.168.15.19:57168 (size: 33.7 KiB, free: 898.4 MiB) 22/07/18 19:58:28 INFO SparkContext: Created broadcast 2 from show at DemoSparkSQL.scala:14 22/07/18 19:58:28 INFO FileSourceScanExec: Planning scan with bin packing, max size: 4194304 bytes, open cost is considered as scanning 4194304 bytes. 22/07/18 19:58:28 INFO SparkContext: Starting job: show at DemoSparkSQL.scala:14 22/07/18 19:58:28 INFO DAGScheduler: Got job 1 (show at DemoSparkSQL.scala:14) with 1 output partitions 22/07/18 19:58:28 INFO DAGScheduler: Final stage: ResultStage 1 (show at DemoSparkSQL.scala:14) 22/07/18 19:58:28 INFO DAGScheduler: Parents of final stage: List() 22/07/18 19:58:28 INFO DAGScheduler: Missing parents: List() 22/07/18 19:58:28 INFO DAGScheduler: Submitting ResultStage 1 (MapPartitionsRDD[7] at show at DemoSparkSQL.scala:14), which has no missing parents 22/07/18 19:58:28 INFO MemoryStore: Block broadcast_3 stored as values in memory (estimated size 13.8 KiB, free 897.7 MiB) 22/07/18 19:58:28 INFO MemoryStore: Block broadcast_3_piece0 stored as bytes in memory (estimated size 6.9 KiB, free 897.7 MiB) 22/07/18 19:58:28 INFO BlockManagerInfo: Added broadcast_3_piece0 in memory on 192.168.15.19:57168 (size: 6.9 KiB, free: 898.4 MiB) 22/07/18 19:58:28 INFO SparkContext: Created broadcast 3 from broadcast at DAGScheduler.scala:1513 22/07/18 19:58:28 INFO DAGScheduler: Submitting 1 missing tasks from ResultStage 1 (MapPartitionsRDD[7] at show at DemoSparkSQL.scala:14) (first 15 tasks are for partitions Vector(0)) 22/07/18 19:58:28 INFO TaskSchedulerImpl: Adding task set 1.0 with 1 tasks resource profile 0 22/07/18 19:58:28 INFO TaskSetManager: Starting task 0.0 in stage 1.0 (TID 1) (192.168.15.19, executor driver, partition 0, PROCESS_LOCAL, 7881 bytes) taskResourceAssignments Map() 22/07/18 19:58:28 INFO Executor: Running task 0.0 in stage 1.0 (TID 1) 22/07/18 19:58:28 INFO FileScanRDD: Reading File path: file:///C:/Users/Administrator/IdeaProjects/baidu1/src/info.json, range: 0-191, partition values: [empty row] 22/07/18 19:58:28 INFO CodeGenerator: Code generated in 13.8558 ms 22/07/18 19:58:28 INFO CodeGenerator: Code generated in 6.469 ms 22/07/18 19:58:28 INFO Executor: Finished task 0.0 in stage 1.0 (TID 1). 1755 bytes result sent to driver 22/07/18 19:58:28 INFO TaskSetManager: Finished task 0.0 in stage 1.0 (TID 1) in 128 ms on 192.168.15.19 (executor driver) (1/1) 22/07/18 19:58:28 INFO TaskSchedulerImpl: Removed TaskSet 1.0, whose tasks have all completed, from pool 22/07/18 19:58:28 INFO DAGScheduler: ResultStage 1 (show at DemoSparkSQL.scala:14) finished in 0.147 s 22/07/18 19:58:28 INFO DAGScheduler: Job 1 is finished. Cancelling potential speculative or zombie tasks for this job 22/07/18 19:58:28 INFO TaskSchedulerImpl: Killing all running tasks in stage 1: Stage finished 22/07/18 19:58:28 INFO DAGScheduler: Job 1 finished: show at DemoSparkSQL.scala:14, took 0.152033 s 22/07/18 19:58:28 INFO CodeGenerator: Code generated in 13.3474 ms +---+------------+ |age| name| +---+------------+ | 20| 静怡的梦莹| | 21|潇洒的龙姑娘| | 21| 优雅的秋兰| +---+------------+ 22/07/18 19:58:28 INFO SparkUI: Stopped Spark web UI at http://192.168.15.19:4040 22/07/18 19:58:28 INFO MapOutputTrackerMasterEndpoint: MapOutputTrackerMasterEndpoint stopped! 22/07/18 19:58:28 INFO MemoryStore: MemoryStore cleared 22/07/18 19:58:28 INFO BlockManager: BlockManager stopped 22/07/18 19:58:28 INFO BlockManagerMaster: BlockManagerMaster stopped 22/07/18 19:58:28 INFO OutputCommitCoordinator$OutputCommitCoordinatorEndpoint: OutputCommitCoordinator stopped! 22/07/18 19:58:28 INFO SparkContext: Successfully stopped SparkContext 22/07/18 19:58:28 INFO ShutdownHookManager: Shutdown hook called 22/07/18 19:58:28 INFO ShutdownHookManager: Deleting directory C:\Users\Administrator\AppData\Local\Temp\spark-04b6bffe-345b-4fc2-aaa2-a02c88e0dea4 Process finished with exit code 0
5、Demo2
package com.item.action
import org.apache.spark.sql.SparkSession
object Demo2 {
def main(args: Array[String]): Unit = {
//使用常量接受
val spark2 = SparkSession.builder().appName("班长").master("local[*]")
.getOrCreate()
import spark2.implicits._
//查询文件信息
var df = spark2.read.json("info.json")
//展示一下获取的数据
df.show()
df.filter($"age" > 20).show()
df.filter($"age" > 20 && $"age" <= 22).show()
df.filter(line => {
if (line.toString().contains("雅")) {
true
} else {
false
}
}).show()
//sql
//创建一个表
df.createOrReplaceTempView("superGirl")
//基础查询
spark2.sql("select name,age from superGirl").show()
//筛选
spark2.sql("select name,age from superGirl where age>20 and age<22").show()
spark2.sql("select name,age from superGirl where age between 20 and 22 order by age desc").show()
//时间类型筛选
spark2.sql(
"""
|select * from superGirl where birthday>"2000-01-01 00:00:00"
|""".stripMargin).show()
spark2.sql(
"""
|select * from superGirl where birthday between "2001-01-01 00:00:00" and "2002-12-01 00:00:00"
|""".stripMargin).show()
//分组、排序、聚合函数
spark2.sql(
"""
|select sex,count(*) from superGirl group by sex
|""".stripMargin).show()
spark2.sql(
"""
|select * from superGirl where order by birthday asc
|""".stripMargin).show()
spark2.sql(
"""
|select sum(age),count(*),round(avg(age),2),max(age),min(age) from superGirl
|""".stripMargin).show()
//关闭spark
spark2.stop()
}
}C:\java\jdk\jdk1.8.0_152\bin\java.exe "-javaagent:C:\java\IDEA\IntelliJ IDEA 2020.1.3\lib\idea_rt.jar=7127:C:\java\IDEA\IntelliJ IDEA 2020.1.3\bin" -Dfile.encoding=UTF-8 -classpath C:\java\jdk\jdk1.8.0_152\jre\lib\charsets.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\deploy.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\ext\access-bridge-64.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\ext\cldrdata.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\ext\dnsns.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\ext\jaccess.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\ext\jfxrt.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\ext\localedata.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\ext\nashorn.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\ext\sunec.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\ext\sunjce_provider.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\ext\sunmscapi.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\ext\sunpkcs11.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\ext\zipfs.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\javaws.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\jce.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\jfr.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\jfxswt.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\jsse.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\management-agent.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\plugin.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\resources.jar;C:\java\jdk\jdk1.8.0_152\jre\lib\rt.jar;C:\Users\Administrator\IdeaProjects\baidu2\target\classes;D:\old\newPro\org\apache\spark\spark-core_2.13\3.3.0\spark-core_2.13-3.3.0.jar;D:\old\newPro\org\scala-lang\modules\scala-parallel-collections_2.13\1.0.3\scala-parallel-collections_2.13-1.0.3.jar;D:\old\newPro\org\apache\avro\avro\1.11.0\avro-1.11.0.jar;D:\old\newPro\com\fasterxml\jackson\core\jackson-core\2.12.5\jackson-core-2.12.5.jar;D:\old\newPro\org\apache\commons\commons-compress\1.21\commons-compress-1.21.jar;D:\old\newPro\org\apache\avro\avro-mapred\1.11.0\avro-mapred-1.11.0.jar;D:\old\newPro\org\apache\avro\avro-ipc\1.11.0\avro-ipc-1.11.0.jar;D:\old\newPro\org\tukaani\xz\1.9\xz-1.9.jar;D:\old\newPro\com\twitter\chill_2.13\0.10.0\chill_2.13-0.10.0.jar;D:\old\newPro\com\esotericsoftware\kryo-shaded\4.0.2\kryo-shaded-4.0.2.jar;D:\old\newPro\com\esotericsoftware\minlog\1.3.0\minlog-1.3.0.jar;D:\old\newPro\org\objenesis\objenesis\2.5.1\objenesis-2.5.1.jar;D:\old\newPro\com\twitter\chill-java\0.10.0\chill-java-0.10.0.jar;D:\old\newPro\org\apache\xbean\xbean-asm9-shaded\4.20\xbean-asm9-shaded-4.20.jar;D:\old\newPro\org\apache\hadoop\hadoop-client-api\3.3.2\hadoop-client-api-3.3.2.jar;D:\old\newPro\org\apache\hadoop\hadoop-client-runtime\3.3.2\hadoop-client-runtime-3.3.2.jar;D:\old\newPro\commons-logging\commons-logging\1.1.3\commons-logging-1.1.3.jar;D:\old\newPro\org\apache\spark\spark-launcher_2.13\3.3.0\spark-launcher_2.13-3.3.0.jar;D:\old\newPro\org\apache\spark\spark-kvstore_2.13\3.3.0\spark-kvstore_2.13-3.3.0.jar;D:\old\newPro\org\fusesource\leveldbjni\leveldbjni-all\1.8\leveldbjni-all-1.8.jar;D:\old\newPro\com\fasterxml\jackson\core\jackson-annotations\2.13.3\jackson-annotations-2.13.3.jar;D:\old\newPro\org\apache\spark\spark-network-common_2.13\3.3.0\spark-network-common_2.13-3.3.0.jar;D:\old\newPro\com\google\crypto\tink\tink\1.6.1\tink-1.6.1.jar;D:\old\newPro\org\apache\spark\spark-network-shuffle_2.13\3.3.0\spark-network-shuffle_2.13-3.3.0.jar;D:\old\newPro\org\apache\spark\spark-unsafe_2.13\3.3.0\spark-unsafe_2.13-3.3.0.jar;D:\old\newPro\javax\activation\activation\1.1.1\activation-1.1.1.jar;D:\old\newPro\org\apache\curator\curator-recipes\2.13.0\curator-recipes-2.13.0.jar;D:\old\newPro\org\apache\curator\curator-framework\2.13.0\curator-framework-2.13.0.jar;D:\old\newPro\org\apache\curator\curator-client\2.13.0\curator-client-2.13.0.jar;D:\old\newPro\org\apache\zookeeper\zookeeper\3.6.2\zookeeper-3.6.2.jar;D:\old\newPro\commons-lang\commons-lang\2.6\commons-lang-2.6.jar;D:\old\newPro\org\apache\zookeeper\zookeeper-jute\3.6.2\zookeeper-jute-3.6.2.jar;D:\old\newPro\org\apache\yetus\audience-annotations\0.5.0\audience-annotations-0.5.0.jar;D:\old\newPro\jakarta\servlet\jakarta.servlet-api\4.0.3\jakarta.servlet-api-4.0.3.jar;D:\old\newPro\commons-codec\commons-codec\1.15\commons-codec-1.15.jar;D:\old\newPro\org\apache\commons\commons-lang3\3.12.0\commons-lang3-3.12.0.jar;D:\old\newPro\org\apache\commons\commons-math3\3.6.1\commons-math3-3.6.1.jar;D:\old\newPro\org\apache\commons\commons-text\1.9\commons-text-1.9.jar;D:\old\newPro\commons-io\commons-io\2.11.0\commons-io-2.11.0.jar;D:\old\newPro\commons-collections\commons-collections\3.2.2\commons-collections-3.2.2.jar;D:\old\newPro\org\apache\commons\commons-collections4\4.4\commons-collections4-4.4.jar;D:\old\newPro\com\google\code\findbugs\jsr305\3.0.0\jsr305-3.0.0.jar;D:\old\newPro\org\slf4j\slf4j-api\1.7.32\slf4j-api-1.7.32.jar;D:\old\newPro\org\slf4j\jul-to-slf4j\1.7.32\jul-to-slf4j-1.7.32.jar;D:\old\newPro\org\slf4j\jcl-over-slf4j\1.7.32\jcl-over-slf4j-1.7.32.jar;D:\old\newPro\org\apache\logging\log4j\log4j-slf4j-impl\2.17.2\log4j-slf4j-impl-2.17.2.jar;D:\old\newPro\org\apache\logging\log4j\log4j-api\2.17.2\log4j-api-2.17.2.jar;D:\old\newPro\org\apache\logging\log4j\log4j-core\2.17.2\log4j-core-2.17.2.jar;D:\old\newPro\org\apache\logging\log4j\log4j-1.2-api\2.17.2\log4j-1.2-api-2.17.2.jar;D:\old\newPro\com\ning\compress-lzf\1.1\compress-lzf-1.1.jar;D:\old\newPro\org\xerial\snappy\snappy-java\1.1.8.4\snappy-java-1.1.8.4.jar;D:\old\newPro\org\lz4\lz4-java\1.8.0\lz4-java-1.8.0.jar;D:\old\newPro\com\github\luben\zstd-jni\1.5.2-1\zstd-jni-1.5.2-1.jar;D:\old\newPro\org\roaringbitmap\RoaringBitmap\0.9.25\RoaringBitmap-0.9.25.jar;D:\old\newPro\org\roaringbitmap\shims\0.9.25\shims-0.9.25.jar;D:\old\newPro\org\scala-lang\modules\scala-xml_2.13\1.2.0\scala-xml_2.13-1.2.0.jar;D:\old\newPro\org\scala-lang\scala-library\2.13.8\scala-library-2.13.8.jar;D:\old\newPro\org\scala-lang\scala-reflect\2.13.8\scala-reflect-2.13.8.jar;D:\old\newPro\org\json4s\json4s-jackson_2.13\3.7.0-M11\json4s-jackson_2.13-3.7.0-M11.jar;D:\old\newPro\org\json4s\json4s-core_2.13\3.7.0-M11\json4s-core_2.13-3.7.0-M11.jar;D:\old\newPro\org\json4s\json4s-ast_2.13\3.7.0-M11\json4s-ast_2.13-3.7.0-M11.jar;D:\old\newPro\org\json4s\json4s-scalap_2.13\3.7.0-M11\json4s-scalap_2.13-3.7.0-M11.jar;D:\old\newPro\org\glassfish\jersey\core\jersey-client\2.34\jersey-client-2.34.jar;D:\old\newPro\jakarta\ws\rs\jakarta.ws.rs-api\2.1.6\jakarta.ws.rs-api-2.1.6.jar;D:\old\newPro\org\glassfish\hk2\external\jakarta.inject\2.6.1\jakarta.inject-2.6.1.jar;D:\old\newPro\org\glassfish\jersey\core\jersey-common\2.34\jersey-common-2.34.jar;D:\old\newPro\jakarta\annotation\jakarta.annotation-api\1.3.5\jakarta.annotation-api-1.3.5.jar;D:\old\newPro\org\glassfish\hk2\osgi-resource-locator\1.0.3\osgi-resource-locator-1.0.3.jar;D:\old\newPro\org\glassfish\jersey\core\jersey-server\2.34\jersey-server-2.34.jar;D:\old\newPro\jakarta\validation\jakarta.validation-api\2.0.2\jakarta.validation-api-2.0.2.jar;D:\old\newPro\org\glassfish\jersey\containers\jersey-container-servlet\2.34\jersey-container-servlet-2.34.jar;D:\old\newPro\org\glassfish\jersey\containers\jersey-container-servlet-core\2.34\jersey-container-servlet-core-2.34.jar;D:\old\newPro\org\glassfish\jersey\inject\jersey-hk2\2.34\jersey-hk2-2.34.jar;D:\old\newPro\org\glassfish\hk2\hk2-locator\2.6.1\hk2-locator-2.6.1.jar;D:\old\newPro\org\glassfish\hk2\external\aopalliance-repackaged\2.6.1\aopalliance-repackaged-2.6.1.jar;D:\old\newPro\org\glassfish\hk2\hk2-api\2.6.1\hk2-api-2.6.1.jar;D:\old\newPro\org\glassfish\hk2\hk2-utils\2.6.1\hk2-utils-2.6.1.jar;D:\old\newPro\org\javassist\javassist\3.25.0-GA\javassist-3.25.0-GA.jar;D:\old\newPro\io\netty\netty-all\4.1.74.Final\netty-all-4.1.74.Final.jar;D:\old\newPro\io\netty\netty-buffer\4.1.74.Final\netty-buffer-4.1.74.Final.jar;D:\old\newPro\io\netty\netty-codec\4.1.74.Final\netty-codec-4.1.74.Final.jar;D:\old\newPro\io\netty\netty-common\4.1.74.Final\netty-common-4.1.74.Final.jar;D:\old\newPro\io\netty\netty-handler\4.1.74.Final\netty-handler-4.1.74.Final.jar;D:\old\newPro\io\netty\netty-tcnative-classes\2.0.48.Final\netty-tcnative-classes-2.0.48.Final.jar;D:\old\newPro\io\netty\netty-resolver\4.1.74.Final\netty-resolver-4.1.74.Final.jar;D:\old\newPro\io\netty\netty-transport\4.1.74.Final\netty-transport-4.1.74.Final.jar;D:\old\newPro\io\netty\netty-transport-classes-epoll\4.1.74.Final\netty-transport-classes-epoll-4.1.74.Final.jar;D:\old\newPro\io\netty\netty-transport-native-unix-common\4.1.74.Final\netty-transport-native-unix-common-4.1.74.Final.jar;D:\old\newPro\io\netty\netty-transport-classes-kqueue\4.1.74.Final\netty-transport-classes-kqueue-4.1.74.Final.jar;D:\old\newPro\io\netty\netty-transport-native-epoll\4.1.74.Final\netty-transport-native-epoll-4.1.74.Final-linux-x86_64.jar;D:\old\newPro\io\netty\netty-transport-native-epoll\4.1.74.Final\netty-transport-native-epoll-4.1.74.Final-linux-aarch_64.jar;D:\old\newPro\io\netty\netty-transport-native-kqueue\4.1.74.Final\netty-transport-native-kqueue-4.1.74.Final-osx-x86_64.jar;D:\old\newPro\io\netty\netty-transport-native-kqueue\4.1.74.Final\netty-transport-native-kqueue-4.1.74.Final-osx-aarch_64.jar;D:\old\newPro\com\clearspring\analytics\stream\2.9.6\stream-2.9.6.jar;D:\old\newPro\io\dropwizard\metrics\metrics-core\4.2.7\metrics-core-4.2.7.jar;D:\old\newPro\io\dropwizard\metrics\metrics-jvm\4.2.7\metrics-jvm-4.2.7.jar;D:\old\newPro\io\dropwizard\metrics\metrics-json\4.2.7\metrics-json-4.2.7.jar;D:\old\newPro\io\dropwizard\metrics\metrics-graphite\4.2.7\metrics-graphite-4.2.7.jar;D:\old\newPro\io\dropwizard\metrics\metrics-jmx\4.2.7\metrics-jmx-4.2.7.jar;D:\old\newPro\com\fasterxml\jackson\core\jackson-databind\2.13.3\jackson-databind-2.13.3.jar;D:\old\newPro\com\fasterxml\jackson\module\jackson-module-scala_2.13\2.13.3\jackson-module-scala_2.13-2.13.3.jar;D:\old\newPro\com\thoughtworks\paranamer\paranamer\2.8\paranamer-2.8.jar;D:\old\newPro\org\apache\ivy\ivy\2.5.0\ivy-2.5.0.jar;D:\old\newPro\oro\oro\2.0.8\oro-2.0.8.jar;D:\old\newPro\net\razorvine\pickle\1.2\pickle-1.2.jar;D:\old\newPro\net\sf\py4j\py4j\0.10.9.5\py4j-0.10.9.5.jar;D:\old\newPro\org\apache\spark\spark-tags_2.13\3.3.0\spark-tags_2.13-3.3.0.jar;D:\old\newPro\org\apache\commons\commons-crypto\1.1.0\commons-crypto-1.1.0.jar;D:\old\newPro\org\spark-project\spark\unused\1.0.0\unused-1.0.0.jar;D:\old\newPro\org\apache\spark\spark-sql_2.13\3.3.0\spark-sql_2.13-3.3.0.jar;D:\old\newPro\org\rocksdb\rocksdbjni\6.20.3\rocksdbjni-6.20.3.jar;D:\old\newPro\com\univocity\univocity-parsers\2.9.1\univocity-parsers-2.9.1.jar;D:\old\newPro\org\apache\spark\spark-sketch_2.13\3.3.0\spark-sketch_2.13-3.3.0.jar;D:\old\newPro\org\apache\spark\spark-catalyst_2.13\3.3.0\spark-catalyst_2.13-3.3.0.jar;D:\old\newPro\org\codehaus\janino\janino\3.0.16\janino-3.0.16.jar;D:\old\newPro\org\codehaus\janino\commons-compiler\3.0.16\commons-compiler-3.0.16.jar;D:\old\newPro\org\antlr\antlr4-runtime\4.8\antlr4-runtime-4.8.jar;D:\old\newPro\org\apache\arrow\arrow-vector\7.0.0\arrow-vector-7.0.0.jar;D:\old\newPro\org\apache\arrow\arrow-format\7.0.0\arrow-format-7.0.0.jar;D:\old\newPro\org\apache\arrow\arrow-memory-core\7.0.0\arrow-memory-core-7.0.0.jar;D:\old\newPro\com\google\flatbuffers\flatbuffers-java\1.12.0\flatbuffers-java-1.12.0.jar;D:\old\newPro\org\apache\arrow\arrow-memory-netty\7.0.0\arrow-memory-netty-7.0.0.jar;D:\old\newPro\org\apache\orc\orc-core\1.7.4\orc-core-1.7.4.jar;D:\old\newPro\org\apache\orc\orc-shims\1.7.4\orc-shims-1.7.4.jar;D:\old\newPro\com\google\protobuf\protobuf-java\2.5.0\protobuf-java-2.5.0.jar;D:\old\newPro\io\airlift\aircompressor\0.21\aircompressor-0.21.jar;D:\old\newPro\org\jetbrains\annotations\17.0.0\annotations-17.0.0.jar;D:\old\newPro\org\threeten\threeten-extra\1.5.0\threeten-extra-1.5.0.jar;D:\old\newPro\org\apache\orc\orc-mapreduce\1.7.4\orc-mapreduce-1.7.4.jar;D:\old\newPro\org\apache\hive\hive-storage-api\2.7.2\hive-storage-api-2.7.2.jar;D:\old\newPro\org\apache\parquet\parquet-column\1.12.2\parquet-column-1.12.2.jar;D:\old\newPro\org\apache\parquet\parquet-common\1.12.2\parquet-common-1.12.2.jar;D:\old\newPro\org\apache\parquet\parquet-encoding\1.12.2\parquet-encoding-1.12.2.jar;D:\old\newPro\org\apache\parquet\parquet-hadoop\1.12.2\parquet-hadoop-1.12.2.jar;D:\old\newPro\org\apache\parquet\parquet-format-structures\1.12.2\parquet-format-structures-1.12.2.jar;D:\old\newPro\org\apache\parquet\parquet-jackson\1.12.2\parquet-jackson-1.12.2.jar;D:\old\newPro\org\apache\spark\spark-streaming_2.13\3.3.0\spark-streaming_2.13-3.3.0.jar;D:\old\newPro\org\apache\spark\spark-mllib_2.13\3.3.0\spark-mllib_2.13-3.3.0.jar;D:\old\newPro\org\scala-lang\modules\scala-parser-combinators_2.13\1.1.2\scala-parser-combinators_2.13-1.1.2.jar;D:\old\newPro\org\apache\spark\spark-graphx_2.13\3.3.0\spark-graphx_2.13-3.3.0.jar;D:\old\newPro\net\sourceforge\f2j\arpack_combined_all\0.1\arpack_combined_all-0.1.jar;D:\old\newPro\org\apache\spark\spark-mllib-local_2.13\3.3.0\spark-mllib-local_2.13-3.3.0.jar;D:\old\newPro\org\scalanlp\breeze_2.13\1.2\breeze_2.13-1.2.jar;D:\old\newPro\org\scalanlp\breeze-macros_2.13\1.2\breeze-macros_2.13-1.2.jar;D:\old\newPro\com\github\fommil\netlib\core\1.1.2\core-1.1.2.jar;D:\old\newPro\net\sf\opencsv\opencsv\2.3\opencsv-2.3.jar;D:\old\newPro\com\github\wendykierp\JTransforms\3.1\JTransforms-3.1.jar;D:\old\newPro\pl\edu\icm\JLargeArrays\1.5\JLargeArrays-1.5.jar;D:\old\newPro\com\chuusai\shapeless_2.13\2.3.3\shapeless_2.13-2.3.3.jar;D:\old\newPro\org\typelevel\spire_2.13\0.17.0\spire_2.13-0.17.0.jar;D:\old\newPro\org\typelevel\spire-macros_2.13\0.17.0\spire-macros_2.13-0.17.0.jar;D:\old\newPro\org\typelevel\spire-platform_2.13\0.17.0\spire-platform_2.13-0.17.0.jar;D:\old\newPro\org\typelevel\spire-util_2.13\0.17.0\spire-util_2.13-0.17.0.jar;D:\old\newPro\org\typelevel\algebra_2.13\2.0.1\algebra_2.13-2.0.1.jar;D:\old\newPro\org\typelevel\cats-kernel_2.13\2.1.1\cats-kernel_2.13-2.1.1.jar;D:\old\newPro\org\scala-lang\modules\scala-collection-compat_2.13\2.1.1\scala-collection-compat_2.13-2.1.1.jar;D:\old\newPro\org\glassfish\jaxb\jaxb-runtime\2.3.2\jaxb-runtime-2.3.2.jar;D:\old\newPro\jakarta\xml\bind\jakarta.xml.bind-api\2.3.2\jakarta.xml.bind-api-2.3.2.jar;D:\old\newPro\com\sun\istack\istack-commons-runtime\3.0.8\istack-commons-runtime-3.0.8.jar;D:\old\newPro\dev\ludovic\netlib\blas\2.2.1\blas-2.2.1.jar;D:\old\newPro\dev\ludovic\netlib\lapack\2.2.1\lapack-2.2.1.jar;D:\old\newPro\dev\ludovic\netlib\arpack\2.2.1\arpack-2.2.1.jar;D:\old\newPro\org\apache\spark\spark-hive_2.13\3.3.0\spark-hive_2.13-3.3.0.jar;D:\old\newPro\org\apache\hive\hive-common\2.3.9\hive-common-2.3.9.jar;D:\old\newPro\commons-cli\commons-cli\1.2\commons-cli-1.2.jar;D:\old\newPro\jline\jline\2.12\jline-2.12.jar;D:\old\newPro\com\tdunning\json\1.8\json-1.8.jar;D:\old\newPro\com\github\joshelser\dropwizard-metrics-hadoop-metrics2-reporter\0.1.2\dropwizard-metrics-hadoop-metrics2-reporter-0.1.2.jar;D:\old\newPro\org\apache\hive\hive-exec\2.3.9\hive-exec-2.3.9-core.jar;D:\old\newPro\org\apache\hive\hive-vector-code-gen\2.3.9\hive-vector-code-gen-2.3.9.jar;D:\old\newPro\com\google\guava\guava\14.0.1\guava-14.0.1.jar;D:\old\newPro\org\apache\velocity\velocity\1.5\velocity-1.5.jar;D:\old\newPro\org\antlr\antlr-runtime\3.5.2\antlr-runtime-3.5.2.jar;D:\old\newPro\org\antlr\ST4\4.0.4\ST4-4.0.4.jar;D:\old\newPro\com\google\code\gson\gson\2.2.4\gson-2.2.4.jar;D:\old\newPro\stax\stax-api\1.0.1\stax-api-1.0.1.jar;D:\old\newPro\org\apache\hive\hive-metastore\2.3.9\hive-metastore-2.3.9.jar;D:\old\newPro\javolution\javolution\5.5.1\javolution-5.5.1.jar;D:\old\newPro\com\jolbox\bonecp\0.8.0.RELEASE\bonecp-0.8.0.RELEASE.jar;D:\old\newPro\com\zaxxer\HikariCP\2.5.1\HikariCP-2.5.1.jar;D:\old\newPro\org\datanucleus\datanucleus-api-jdo\4.2.4\datanucleus-api-jdo-4.2.4.jar;D:\old\newPro\org\datanucleus\datanucleus-rdbms\4.1.19\datanucleus-rdbms-4.1.19.jar;D:\old\newPro\commons-pool\commons-pool\1.5.4\commons-pool-1.5.4.jar;D:\old\newPro\commons-dbcp\commons-dbcp\1.4\commons-dbcp-1.4.jar;D:\old\newPro\javax\jdo\jdo-api\3.0.1\jdo-api-3.0.1.jar;D:\old\newPro\javax\transaction\jta\1.1\jta-1.1.jar;D:\old\newPro\org\datanucleus\javax.jdo\3.2.0-m3\javax.jdo-3.2.0-m3.jar;D:\old\newPro\javax\transaction\transaction-api\1.1\transaction-api-1.1.jar;D:\old\newPro\org\apache\hive\hive-serde\2.3.9\hive-serde-2.3.9.jar;D:\old\newPro\org\apache\hive\hive-shims\2.3.9\hive-shims-2.3.9.jar;D:\old\newPro\org\apache\hive\shims\hive-shims-common\2.3.9\hive-shims-common-2.3.9.jar;D:\old\newPro\org\apache\hive\shims\hive-shims-0.23\2.3.9\hive-shims-0.23-2.3.9.jar;D:\old\newPro\org\apache\hive\shims\hive-shims-scheduler\2.3.9\hive-shims-scheduler-2.3.9.jar;D:\old\newPro\org\apache\hive\hive-llap-common\2.3.9\hive-llap-common-2.3.9.jar;D:\old\newPro\org\apache\hive\hive-llap-client\2.3.9\hive-llap-client-2.3.9.jar;D:\old\newPro\org\apache\httpcomponents\httpclient\4.5.13\httpclient-4.5.13.jar;D:\old\newPro\org\apache\httpcomponents\httpcore\4.4.13\httpcore-4.4.13.jar;D:\old\newPro\org\codehaus\jackson\jackson-mapper-asl\1.9.13\jackson-mapper-asl-1.9.13.jar;D:\old\newPro\org\codehaus\jackson\jackson-core-asl\1.9.13\jackson-core-asl-1.9.13.jar;D:\old\newPro\joda-time\joda-time\2.10.13\joda-time-2.10.13.jar;D:\old\newPro\org\jodd\jodd-core\3.5.2\jodd-core-3.5.2.jar;D:\old\newPro\org\datanucleus\datanucleus-core\4.1.17\datanucleus-core-4.1.17.jar;D:\old\newPro\org\apache\thrift\libthrift\0.12.0\libthrift-0.12.0.jar;D:\old\newPro\org\apache\thrift\libfb303\0.9.3\libfb303-0.9.3.jar;D:\old\newPro\org\apache\derby\derby\10.14.2.0\derby-10.14.2.0.jar;C:\Users\Administrator\.ivy2\cache\org.scala-lang\scala-library\jars\scala-library-2.13.8.jar;C:\Users\Administrator\.ivy2\cache\org.scala-lang\scala-reflect\jars\scala-reflect-2.13.8.jar;C:\Users\Administrator\.ivy2\cache\org.scala-lang\scala-library\srcs\scala-library-2.13.8-sources.jar com.item.action.Demo2 Using Spark's default log4j profile: org/apache/spark/log4j2-defaults.properties 22/07/22 19:58:36 INFO SparkContext: Running Spark version 3.3.0 22/07/22 19:58:36 INFO ResourceUtils: ============================================================== 22/07/22 19:58:36 INFO ResourceUtils: No custom resources configured for spark.driver. 22/07/22 19:58:36 INFO ResourceUtils: ============================================================== 22/07/22 19:58:36 INFO SparkContext: Submitted application: 班长 22/07/22 19:58:36 INFO ResourceProfile: Default ResourceProfile created, executor resources: Map(cores -> name: cores, amount: 1, script: , vendor: , memory -> name: memory, amount: 1024, script: , vendor: , offHeap -> name: offHeap, amount: 0, script: , vendor: ), task resources: Map(cpus -> name: cpus, amount: 1.0) 22/07/22 19:58:36 INFO ResourceProfile: Limiting resource is cpu 22/07/22 19:58:36 INFO ResourceProfileManager: Added ResourceProfile id: 0 22/07/22 19:58:36 INFO SecurityManager: Changing view acls to: Administrator 22/07/22 19:58:36 INFO SecurityManager: Changing modify acls to: Administrator 22/07/22 19:58:36 INFO SecurityManager: Changing view acls groups to: 22/07/22 19:58:36 INFO SecurityManager: Changing modify acls groups to: 22/07/22 19:58:36 INFO SecurityManager: SecurityManager: authentication disabled; ui acls disabled; users with view permissions: Set(Administrator); groups with view permissions: Set(); users with modify permissions: Set(Administrator); groups with modify permissions: Set() 22/07/22 19:58:37 INFO Utils: Successfully started service 'sparkDriver' on port 7173. 22/07/22 19:58:37 INFO SparkEnv: Registering MapOutputTracker 22/07/22 19:58:37 INFO SparkEnv: Registering BlockManagerMaster 22/07/22 19:58:37 INFO BlockManagerMasterEndpoint: Using org.apache.spark.storage.DefaultTopologyMapper for getting topology information 22/07/22 19:58:37 INFO BlockManagerMasterEndpoint: BlockManagerMasterEndpoint up 22/07/22 19:58:37 INFO SparkEnv: Registering BlockManagerMasterHeartbeat 22/07/22 19:58:37 INFO DiskBlockManager: Created local directory at C:\Users\Administrator\AppData\Local\Temp\blockmgr-3bebc1a5-44dd-4713-ad32-8ae2610dfaef 22/07/22 19:58:37 INFO MemoryStore: MemoryStore started with capacity 898.5 MiB 22/07/22 19:58:37 INFO SparkEnv: Registering OutputCommitCoordinator 22/07/22 19:58:37 INFO Utils: Successfully started service 'SparkUI' on port 4040. 22/07/22 19:58:37 INFO Executor: Starting executor ID driver on host 192.168.15.19 22/07/22 19:58:37 INFO Executor: Starting executor with user classpath (userClassPathFirst = false): '' 22/07/22 19:58:37 INFO Utils: Successfully started service 'org.apache.spark.network.netty.NettyBlockTransferService' on port 7216. 22/07/22 19:58:37 INFO NettyBlockTransferService: Server created on 192.168.15.19:7216 22/07/22 19:58:37 INFO BlockManager: Using org.apache.spark.storage.RandomBlockReplicationPolicy for block replication policy 22/07/22 19:58:37 INFO BlockManagerMaster: Registering BlockManager BlockManagerId(driver, 192.168.15.19, 7216, None) 22/07/22 19:58:37 INFO BlockManagerMasterEndpoint: Registering block manager 192.168.15.19:7216 with 898.5 MiB RAM, BlockManagerId(driver, 192.168.15.19, 7216, None) 22/07/22 19:58:37 INFO BlockManagerMaster: Registered BlockManager BlockManagerId(driver, 192.168.15.19, 7216, None) 22/07/22 19:58:37 INFO BlockManager: Initialized BlockManager: BlockManagerId(driver, 192.168.15.19, 7216, None) 22/07/22 19:58:38 INFO SharedState: Setting hive.metastore.warehouse.dir ('null') to the value of spark.sql.warehouse.dir. 22/07/22 19:58:38 INFO SharedState: Warehouse path is 'file:/C:/Users/Administrator/IdeaProjects/baidu2/spark-warehouse'. 22/07/22 19:58:39 INFO InMemoryFileIndex: It took 24 ms to list leaf files for 1 paths. 22/07/22 19:58:39 INFO InMemoryFileIndex: It took 1 ms to list leaf files for 1 paths. 22/07/22 19:58:40 INFO FileSourceStrategy: Pushed Filters: 22/07/22 19:58:40 INFO FileSourceStrategy: Post-Scan Filters: 22/07/22 19:58:40 INFO FileSourceStrategy: Output Data Schema: struct<value: string> 22/07/22 19:58:41 INFO MemoryStore: Block broadcast_0 stored as values in memory (estimated size 348.5 KiB, free 898.2 MiB) 22/07/22 19:58:41 INFO MemoryStore: Block broadcast_0_piece0 stored as bytes in memory (estimated size 33.7 KiB, free 898.1 MiB) 22/07/22 19:58:41 INFO BlockManagerInfo: Added broadcast_0_piece0 in memory on 192.168.15.19:7216 (size: 33.7 KiB, free: 898.5 MiB) 22/07/22 19:58:41 INFO SparkContext: Created broadcast 0 from json at Demo2.scala:12 22/07/22 19:58:41 INFO FileSourceScanExec: Planning scan with bin packing, max size: 4194304 bytes, open cost is considered as scanning 4194304 bytes. 22/07/22 19:58:41 INFO SparkContext: Starting job: json at Demo2.scala:12 22/07/22 19:58:41 INFO DAGScheduler: Got job 0 (json at Demo2.scala:12) with 1 output partitions 22/07/22 19:58:41 INFO DAGScheduler: Final stage: ResultStage 0 (json at Demo2.scala:12) 22/07/22 19:58:41 INFO DAGScheduler: Parents of final stage: List() 22/07/22 19:58:41 INFO DAGScheduler: Missing parents: List() 22/07/22 19:58:41 INFO DAGScheduler: Submitting ResultStage 0 (MapPartitionsRDD[3] at json at Demo2.scala:12), which has no missing parents 22/07/22 19:58:41 INFO MemoryStore: Block broadcast_1 stored as values in memory (estimated size 14.2 KiB, free 898.1 MiB) 22/07/22 19:58:41 INFO MemoryStore: Block broadcast_1_piece0 stored as bytes in memory (estimated size 6.7 KiB, free 898.1 MiB) 22/07/22 19:58:41 INFO BlockManagerInfo: Added broadcast_1_piece0 in memory on 192.168.15.19:7216 (size: 6.7 KiB, free: 898.5 MiB) 22/07/22 19:58:41 INFO SparkContext: Created broadcast 1 from broadcast at DAGScheduler.scala:1513 22/07/22 19:58:41 INFO DAGScheduler: Submitting 1 missing tasks from ResultStage 0 (MapPartitionsRDD[3] at json at Demo2.scala:12) (first 15 tasks are for partitions Vector(0)) 22/07/22 19:58:41 INFO TaskSchedulerImpl: Adding task set 0.0 with 1 tasks resource profile 0 22/07/22 19:58:41 INFO TaskSetManager: Starting task 0.0 in stage 0.0 (TID 0) (192.168.15.19, executor driver, partition 0, PROCESS_LOCAL, 7877 bytes) taskResourceAssignments Map() 22/07/22 19:58:41 INFO Executor: Running task 0.0 in stage 0.0 (TID 0) 22/07/22 19:58:41 INFO FileScanRDD: Reading File path: file:///C:/Users/Administrator/IdeaProjects/baidu2/info.json, range: 0-502, partition values: [empty row] 22/07/22 19:58:41 INFO CodeGenerator: Code generated in 165.6827 ms 22/07/22 19:58:42 INFO Executor: Finished task 0.0 in stage 0.0 (TID 0). 2218 bytes result sent to driver 22/07/22 19:58:42 INFO TaskSetManager: Finished task 0.0 in stage 0.0 (TID 0) in 515 ms on 192.168.15.19 (executor driver) (1/1) 22/07/22 19:58:42 INFO TaskSchedulerImpl: Removed TaskSet 0.0, whose tasks have all completed, from pool 22/07/22 19:58:42 INFO DAGScheduler: ResultStage 0 (json at Demo2.scala:12) finished in 0.703 s 22/07/22 19:58:42 INFO DAGScheduler: Job 0 is finished. Cancelling potential speculative or zombie tasks for this job 22/07/22 19:58:42 INFO TaskSchedulerImpl: Killing all running tasks in stage 0: Stage finished 22/07/22 19:58:42 INFO DAGScheduler: Job 0 finished: json at Demo2.scala:12, took 0.731110 s 22/07/22 19:58:42 INFO FileSourceStrategy: Pushed Filters: 22/07/22 19:58:42 INFO FileSourceStrategy: Post-Scan Filters: 22/07/22 19:58:42 INFO FileSourceStrategy: Output Data Schema: struct<age: bigint, birthday: string, name: string, sex: string ... 2 more fields> 22/07/22 19:58:42 INFO CodeGenerator: Code generated in 17.4943 ms 22/07/22 19:58:42 INFO MemoryStore: Block broadcast_2 stored as values in memory (estimated size 348.4 KiB, free 897.8 MiB) 22/07/22 19:58:42 INFO MemoryStore: Block broadcast_2_piece0 stored as bytes in memory (estimated size 33.7 KiB, free 897.7 MiB) 22/07/22 19:58:42 INFO BlockManagerInfo: Added broadcast_2_piece0 in memory on 192.168.15.19:7216 (size: 33.7 KiB, free: 898.4 MiB) 22/07/22 19:58:42 INFO SparkContext: Created broadcast 2 from show at Demo2.scala:14 22/07/22 19:58:42 INFO FileSourceScanExec: Planning scan with bin packing, max size: 4194304 bytes, open cost is considered as scanning 4194304 bytes. 22/07/22 19:58:42 INFO SparkContext: Starting job: show at Demo2.scala:14 22/07/22 19:58:42 INFO DAGScheduler: Got job 1 (show at Demo2.scala:14) with 1 output partitions 22/07/22 19:58:42 INFO DAGScheduler: Final stage: ResultStage 1 (show at Demo2.scala:14) 22/07/22 19:58:42 INFO DAGScheduler: Parents of final stage: List() 22/07/22 19:58:42 INFO DAGScheduler: Missing parents: List() 22/07/22 19:58:42 INFO DAGScheduler: Submitting ResultStage 1 (MapPartitionsRDD[7] at show at Demo2.scala:14), which has no missing parents 22/07/22 19:58:42 INFO MemoryStore: Block broadcast_3 stored as values in memory (estimated size 14.0 KiB, free 897.7 MiB) 22/07/22 19:58:42 INFO MemoryStore: Block broadcast_3_piece0 stored as bytes in memory (estimated size 6.8 KiB, free 897.7 MiB) 22/07/22 19:58:42 INFO BlockManagerInfo: Added broadcast_3_piece0 in memory on 192.168.15.19:7216 (size: 6.8 KiB, free: 898.4 MiB) 22/07/22 19:58:42 INFO SparkContext: Created broadcast 3 from broadcast at DAGScheduler.scala:1513 22/07/22 19:58:42 INFO DAGScheduler: Submitting 1 missing tasks from ResultStage 1 (MapPartitionsRDD[7] at show at Demo2.scala:14) (first 15 tasks are for partitions Vector(0)) 22/07/22 19:58:42 INFO TaskSchedulerImpl: Adding task set 1.0 with 1 tasks resource profile 0 22/07/22 19:58:42 INFO TaskSetManager: Starting task 0.0 in stage 1.0 (TID 1) (192.168.15.19, executor driver, partition 0, PROCESS_LOCAL, 7877 bytes) taskResourceAssignments Map() 22/07/22 19:58:42 INFO Executor: Running task 0.0 in stage 1.0 (TID 1) 22/07/22 19:58:42 INFO FileScanRDD: Reading File path: file:///C:/Users/Administrator/IdeaProjects/baidu2/info.json, range: 0-502, partition values: [empty row] 22/07/22 19:58:42 INFO CodeGenerator: Code generated in 9.933 ms 22/07/22 19:58:42 INFO Executor: Finished task 0.0 in stage 1.0 (TID 1). 1792 bytes result sent to driver 22/07/22 19:58:42 INFO TaskSetManager: Finished task 0.0 in stage 1.0 (TID 1) in 63 ms on 192.168.15.19 (executor driver) (1/1) 22/07/22 19:58:42 INFO TaskSchedulerImpl: Removed TaskSet 1.0, whose tasks have all completed, from pool 22/07/22 19:58:42 INFO DAGScheduler: ResultStage 1 (show at Demo2.scala:14) finished in 0.078 s 22/07/22 19:58:42 INFO DAGScheduler: Job 1 is finished. Cancelling potential speculative or zombie tasks for this job 22/07/22 19:58:42 INFO TaskSchedulerImpl: Killing all running tasks in stage 1: Stage finished 22/07/22 19:58:42 INFO DAGScheduler: Job 1 finished: show at Demo2.scala:14, took 0.086583 s 22/07/22 19:58:42 INFO CodeGenerator: Code generated in 13.8487 ms +---+-------------------+----------+---+ |age| birthday| name|sex| +---+-------------------+----------+---+ | 19|2001-05-06 12:00:00|娉婷的星望| 女| | 20|1999-05-02 12:00:00|静怡的雷静| 女| | 22|2000-01-06 12:00:00|潇洒的春梦| 女| | 21|2001-06-06 12:00:00|优雅的蓉菲| 女| | 19|2002-05-09 12:00:00|玲珑的文静| 女| | 18|2004-05-09 12:00:00|风雅的晓凤| 女| +---+-------------------+----------+---+ 22/07/22 19:58:42 INFO FileSourceStrategy: Pushed Filters: IsNotNull(age),GreaterThan(age,20) 22/07/22 19:58:42 INFO FileSourceStrategy: Post-Scan Filters: isnotnull(age#8L),(age#8L > 20) 22/07/22 19:58:42 INFO FileSourceStrategy: Output Data Schema: struct<age: bigint, birthday: string, name: string, sex: string ... 2 more fields> 22/07/22 19:58:42 INFO CodeGenerator: Code generated in 15.693 ms 22/07/22 19:58:42 INFO MemoryStore: Block broadcast_4 stored as values in memory (estimated size 348.4 KiB, free 897.4 MiB) 22/07/22 19:58:42 INFO MemoryStore: Block broadcast_4_piece0 stored as bytes in memory (estimated size 33.7 KiB, free 897.3 MiB) 22/07/22 19:58:42 INFO BlockManagerInfo: Added broadcast_4_piece0 in memory on 192.168.15.19:7216 (size: 33.7 KiB, free: 898.4 MiB) 22/07/22 19:58:42 INFO SparkContext: Created broadcast 4 from show at Demo2.scala:15 22/07/22 19:58:42 INFO FileSourceScanExec: Planning scan with bin packing, max size: 4194304 bytes, open cost is considered as scanning 4194304 bytes. 22/07/22 19:58:42 INFO SparkContext: Starting job: show at Demo2.scala:15 22/07/22 19:58:42 INFO DAGScheduler: Got job 2 (show at Demo2.scala:15) with 1 output partitions 22/07/22 19:58:42 INFO DAGScheduler: Final stage: ResultStage 2 (show at Demo2.scala:15) 22/07/22 19:58:42 INFO DAGScheduler: Parents of final stage: List() 22/07/22 19:58:42 INFO DAGScheduler: Missing parents: List() 22/07/22 19:58:42 INFO DAGScheduler: Submitting ResultStage 2 (MapPartitionsRDD[11] at show at Demo2.scala:15), which has no missing parents 22/07/22 19:58:42 INFO MemoryStore: Block broadcast_5 stored as values in memory (estimated size 14.6 KiB, free 897.3 MiB) 22/07/22 19:58:42 INFO MemoryStore: Block broadcast_5_piece0 stored as bytes in memory (estimated size 7.1 KiB, free 897.3 MiB) 22/07/22 19:58:42 INFO BlockManagerInfo: Added broadcast_5_piece0 in memory on 192.168.15.19:7216 (size: 7.1 KiB, free: 898.4 MiB) 22/07/22 19:58:42 INFO SparkContext: Created broadcast 5 from broadcast at DAGScheduler.scala:1513 22/07/22 19:58:42 INFO DAGScheduler: Submitting 1 missing tasks from ResultStage 2 (MapPartitionsRDD[11] at show at Demo2.scala:15) (first 15 tasks are for partitions Vector(0)) 22/07/22 19:58:42 INFO TaskSchedulerImpl: Adding task set 2.0 with 1 tasks resource profile 0 22/07/22 19:58:42 INFO TaskSetManager: Starting task 0.0 in stage 2.0 (TID 2) (192.168.15.19, executor driver, partition 0, PROCESS_LOCAL, 7877 bytes) taskResourceAssignments Map() 22/07/22 19:58:42 INFO Executor: Running task 0.0 in stage 2.0 (TID 2) 22/07/22 19:58:42 INFO FileScanRDD: Reading File path: file:///C:/Users/Administrator/IdeaProjects/baidu2/info.json, range: 0-502, partition values: [empty row] 22/07/22 19:58:42 INFO CodeGenerator: Code generated in 5.9686 ms 22/07/22 19:58:42 INFO Executor: Finished task 0.0 in stage 2.0 (TID 2). 1680 bytes result sent to driver 22/07/22 19:58:42 INFO TaskSetManager: Finished task 0.0 in stage 2.0 (TID 2) in 46 ms on 192.168.15.19 (executor driver) (1/1) 22/07/22 19:58:42 INFO TaskSchedulerImpl: Removed TaskSet 2.0, whose tasks have all completed, from pool 22/07/22 19:58:42 INFO DAGScheduler: ResultStage 2 (show at Demo2.scala:15) finished in 0.046 s 22/07/22 19:58:42 INFO DAGScheduler: Job 2 is finished. Cancelling potential speculative or zombie tasks for this job 22/07/22 19:58:42 INFO TaskSchedulerImpl: Killing all running tasks in stage 2: Stage finished 22/07/22 19:58:42 INFO DAGScheduler: Job 2 finished: show at Demo2.scala:15, took 0.052316 s +---+-------------------+----------+---+ |age| birthday| name|sex| +---+-------------------+----------+---+ | 22|2000-01-06 12:00:00|潇洒的春梦| 女| | 21|2001-06-06 12:00:00|优雅的蓉菲| 女| +---+-------------------+----------+---+ 22/07/22 19:58:42 INFO FileSourceStrategy: Pushed Filters: IsNotNull(age),GreaterThan(age,20),LessThanOrEqual(age,22) 22/07/22 19:58:42 INFO FileSourceStrategy: Post-Scan Filters: isnotnull(age#8L),(age#8L > 20),(age#8L <= 22) 22/07/22 19:58:42 INFO FileSourceStrategy: Output Data Schema: struct<age: bigint, birthday: string, name: string, sex: string ... 2 more fields> 22/07/22 19:58:42 INFO CodeGenerator: Code generated in 12.3019 ms 22/07/22 19:58:42 INFO MemoryStore: Block broadcast_6 stored as values in memory (estimated size 348.4 KiB, free 897.0 MiB) 22/07/22 19:58:42 INFO MemoryStore: Block broadcast_6_piece0 stored as bytes in memory (estimated size 33.7 KiB, free 896.9 MiB) 22/07/22 19:58:42 INFO BlockManagerInfo: Added broadcast_6_piece0 in memory on 192.168.15.19:7216 (size: 33.7 KiB, free: 898.3 MiB) 22/07/22 19:58:42 INFO SparkContext: Created broadcast 6 from show at Demo2.scala:16 22/07/22 19:58:42 INFO FileSourceScanExec: Planning scan with bin packing, max size: 4194304 bytes, open cost is considered as scanning 4194304 bytes. 22/07/22 19:58:42 INFO SparkContext: Starting job: show at Demo2.scala:16 22/07/22 19:58:42 INFO DAGScheduler: Got job 3 (show at Demo2.scala:16) with 1 output partitions 22/07/22 19:58:42 INFO DAGScheduler: Final stage: ResultStage 3 (show at Demo2.scala:16) 22/07/22 19:58:42 INFO DAGScheduler: Parents of final stage: List() 22/07/22 19:58:42 INFO DAGScheduler: Missing parents: List() 22/07/22 19:58:42 INFO DAGScheduler: Submitting ResultStage 3 (MapPartitionsRDD[15] at show at Demo2.scala:16), which has no missing parents 22/07/22 19:58:42 INFO MemoryStore: Block broadcast_7 stored as values in memory (estimated size 14.9 KiB, free 896.9 MiB) 22/07/22 19:58:42 INFO MemoryStore: Block broadcast_7_piece0 stored as bytes in memory (estimated size 7.2 KiB, free 896.9 MiB) 22/07/22 19:58:42 INFO BlockManagerInfo: Added broadcast_7_piece0 in memory on 192.168.15.19:7216 (size: 7.2 KiB, free: 898.3 MiB) 22/07/22 19:58:42 INFO SparkContext: Created broadcast 7 from broadcast at DAGScheduler.scala:1513 22/07/22 19:58:42 INFO DAGScheduler: Submitting 1 missing tasks from ResultStage 3 (MapPartitionsRDD[15] at show at Demo2.scala:16) (first 15 tasks are for partitions Vector(0)) 22/07/22 19:58:42 INFO TaskSchedulerImpl: Adding task set 3.0 with 1 tasks resource profile 0 22/07/22 19:58:42 INFO TaskSetManager: Starting task 0.0 in stage 3.0 (TID 3) (192.168.15.19, executor driver, partition 0, PROCESS_LOCAL, 7877 bytes) taskResourceAssignments Map() 22/07/22 19:58:42 INFO Executor: Running task 0.0 in stage 3.0 (TID 3) 22/07/22 19:58:42 INFO FileScanRDD: Reading File path: file:///C:/Users/Administrator/IdeaProjects/baidu2/info.json, range: 0-502, partition values: [empty row] 22/07/22 19:58:42 INFO CodeGenerator: Code generated in 9.1326 ms 22/07/22 19:58:42 INFO Executor: Finished task 0.0 in stage 3.0 (TID 3). 1680 bytes result sent to driver 22/07/22 19:58:42 INFO TaskSetManager: Finished task 0.0 in stage 3.0 (TID 3) in 31 ms on 192.168.15.19 (executor driver) (1/1) 22/07/22 19:58:42 INFO TaskSchedulerImpl: Removed TaskSet 3.0, whose tasks have all completed, from pool 22/07/22 19:58:42 INFO DAGScheduler: ResultStage 3 (show at Demo2.scala:16) finished in 0.047 s 22/07/22 19:58:42 INFO DAGScheduler: Job 3 is finished. Cancelling potential speculative or zombie tasks for this job 22/07/22 19:58:42 INFO TaskSchedulerImpl: Killing all running tasks in stage 3: Stage finished 22/07/22 19:58:42 INFO DAGScheduler: Job 3 finished: show at Demo2.scala:16, took 0.048115 s +---+-------------------+----------+---+ |age| birthday| name|sex| +---+-------------------+----------+---+ | 22|2000-01-06 12:00:00|潇洒的春梦| 女| | 21|2001-06-06 12:00:00|优雅的蓉菲| 女| +---+-------------------+----------+---+ 22/07/22 19:58:42 INFO FileSourceStrategy: Pushed Filters: 22/07/22 19:58:42 INFO FileSourceStrategy: Post-Scan Filters: 22/07/22 19:58:42 INFO FileSourceStrategy: Output Data Schema: struct<age: bigint, birthday: string, name: string, sex: string ... 2 more fields> 22/07/22 19:58:42 INFO CodeGenerator: Code generated in 14.9588 ms 22/07/22 19:58:42 INFO MemoryStore: Block broadcast_8 stored as values in memory (estimated size 348.4 KiB, free 896.6 MiB) 22/07/22 19:58:42 INFO MemoryStore: Block broadcast_8_piece0 stored as bytes in memory (estimated size 33.7 KiB, free 896.6 MiB) 22/07/22 19:58:42 INFO BlockManagerInfo: Added broadcast_8_piece0 in memory on 192.168.15.19:7216 (size: 33.7 KiB, free: 898.3 MiB) 22/07/22 19:58:42 INFO SparkContext: Created broadcast 8 from show at Demo2.scala:17 22/07/22 19:58:42 INFO FileSourceScanExec: Planning scan with bin packing, max size: 4194304 bytes, open cost is considered as scanning 4194304 bytes. 22/07/22 19:58:42 INFO SparkContext: Starting job: show at Demo2.scala:17 22/07/22 19:58:42 INFO DAGScheduler: Got job 4 (show at Demo2.scala:17) with 1 output partitions 22/07/22 19:58:42 INFO DAGScheduler: Final stage: ResultStage 4 (show at Demo2.scala:17) 22/07/22 19:58:42 INFO DAGScheduler: Parents of final stage: List() 22/07/22 19:58:42 INFO DAGScheduler: Missing parents: List() 22/07/22 19:58:42 INFO DAGScheduler: Submitting ResultStage 4 (MapPartitionsRDD[19] at show at Demo2.scala:17), which has no missing parents 22/07/22 19:58:42 INFO MemoryStore: Block broadcast_9 stored as values in memory (estimated size 16.6 KiB, free 896.5 MiB) 22/07/22 19:58:42 INFO MemoryStore: Block broadcast_9_piece0 stored as bytes in memory (estimated size 7.8 KiB, free 896.5 MiB) 22/07/22 19:58:42 INFO BlockManagerInfo: Added broadcast_9_piece0 in memory on 192.168.15.19:7216 (size: 7.8 KiB, free: 898.3 MiB) 22/07/22 19:58:42 INFO SparkContext: Created broadcast 9 from broadcast at DAGScheduler.scala:1513 22/07/22 19:58:42 INFO DAGScheduler: Submitting 1 missing tasks from ResultStage 4 (MapPartitionsRDD[19] at show at Demo2.scala:17) (first 15 tasks are for partitions Vector(0)) 22/07/22 19:58:42 INFO TaskSchedulerImpl: Adding task set 4.0 with 1 tasks resource profile 0 22/07/22 19:58:42 INFO TaskSetManager: Starting task 0.0 in stage 4.0 (TID 4) (192.168.15.19, executor driver, partition 0, PROCESS_LOCAL, 7877 bytes) taskResourceAssignments Map() 22/07/22 19:58:42 INFO Executor: Running task 0.0 in stage 4.0 (TID 4) 22/07/22 19:58:42 INFO FileScanRDD: Reading File path: file:///C:/Users/Administrator/IdeaProjects/baidu2/info.json, range: 0-502, partition values: [empty row] 22/07/22 19:58:42 INFO Executor: Finished task 0.0 in stage 4.0 (TID 4). 1681 bytes result sent to driver 22/07/22 19:58:42 INFO TaskSetManager: Finished task 0.0 in stage 4.0 (TID 4) in 16 ms on 192.168.15.19 (executor driver) (1/1) 22/07/22 19:58:42 INFO TaskSchedulerImpl: Removed TaskSet 4.0, whose tasks have all completed, from pool 22/07/22 19:58:42 INFO DAGScheduler: ResultStage 4 (show at Demo2.scala:17) finished in 0.016 s 22/07/22 19:58:42 INFO DAGScheduler: Job 4 is finished. Cancelling potential speculative or zombie tasks for this job 22/07/22 19:58:42 INFO TaskSchedulerImpl: Killing all running tasks in stage 4: Stage finished 22/07/22 19:58:42 INFO DAGScheduler: Job 4 finished: show at Demo2.scala:17, took 0.024943 s +---+-------------------+----------+---+ |age| birthday| name|sex| +---+-------------------+----------+---+ | 21|2001-06-06 12:00:00|优雅的蓉菲| 女| | 18|2004-05-09 12:00:00|风雅的晓凤| 女| +---+-------------------+----------+---+ 22/07/22 19:58:42 INFO FileSourceStrategy: Pushed Filters: 22/07/22 19:58:42 INFO FileSourceStrategy: Post-Scan Filters: 22/07/22 19:58:42 INFO FileSourceStrategy: Output Data Schema: struct<age: bigint, name: string> 22/07/22 19:58:42 INFO CodeGenerator: Code generated in 11.0494 ms 22/07/22 19:58:42 INFO MemoryStore: Block broadcast_10 stored as values in memory (estimated size 348.4 KiB, free 896.2 MiB) 22/07/22 19:58:43 INFO MemoryStore: Block broadcast_10_piece0 stored as bytes in memory (estimated size 33.7 KiB, free 896.2 MiB) 22/07/22 19:58:43 INFO BlockManagerInfo: Added broadcast_10_piece0 in memory on 192.168.15.19:7216 (size: 33.7 KiB, free: 898.3 MiB) 22/07/22 19:58:43 INFO SparkContext: Created broadcast 10 from show at Demo2.scala:28 22/07/22 19:58:43 INFO FileSourceScanExec: Planning scan with bin packing, max size: 4194304 bytes, open cost is considered as scanning 4194304 bytes. 22/07/22 19:58:43 INFO SparkContext: Starting job: show at Demo2.scala:28 22/07/22 19:58:43 INFO DAGScheduler: Got job 5 (show at Demo2.scala:28) with 1 output partitions 22/07/22 19:58:43 INFO DAGScheduler: Final stage: ResultStage 5 (show at Demo2.scala:28) 22/07/22 19:58:43 INFO DAGScheduler: Parents of final stage: List() 22/07/22 19:58:43 INFO DAGScheduler: Missing parents: List() 22/07/22 19:58:43 INFO DAGScheduler: Submitting ResultStage 5 (MapPartitionsRDD[23] at show at Demo2.scala:28), which has no missing parents 22/07/22 19:58:43 INFO MemoryStore: Block broadcast_11 stored as values in memory (estimated size 13.2 KiB, free 896.1 MiB) 22/07/22 19:58:43 INFO MemoryStore: Block broadcast_11_piece0 stored as bytes in memory (estimated size 6.7 KiB, free 896.1 MiB) 22/07/22 19:58:43 INFO BlockManagerInfo: Added broadcast_11_piece0 in memory on 192.168.15.19:7216 (size: 6.7 KiB, free: 898.3 MiB) 22/07/22 19:58:43 INFO SparkContext: Created broadcast 11 from broadcast at DAGScheduler.scala:1513 22/07/22 19:58:43 INFO DAGScheduler: Submitting 1 missing tasks from ResultStage 5 (MapPartitionsRDD[23] at show at Demo2.scala:28) (first 15 tasks are for partitions Vector(0)) 22/07/22 19:58:43 INFO TaskSchedulerImpl: Adding task set 5.0 with 1 tasks resource profile 0 22/07/22 19:58:43 INFO TaskSetManager: Starting task 0.0 in stage 5.0 (TID 5) (192.168.15.19, executor driver, partition 0, PROCESS_LOCAL, 7877 bytes) taskResourceAssignments Map() 22/07/22 19:58:43 INFO Executor: Running task 0.0 in stage 5.0 (TID 5) 22/07/22 19:58:43 INFO FileScanRDD: Reading File path: file:///C:/Users/Administrator/IdeaProjects/baidu2/info.json, range: 0-502, partition values: [empty row] 22/07/22 19:58:43 INFO CodeGenerator: Code generated in 8.1742 ms 22/07/22 19:58:43 INFO Executor: Finished task 0.0 in stage 5.0 (TID 5). 1705 bytes result sent to driver 22/07/22 19:58:43 INFO TaskSetManager: Finished task 0.0 in stage 5.0 (TID 5) in 31 ms on 192.168.15.19 (executor driver) (1/1) 22/07/22 19:58:43 INFO TaskSchedulerImpl: Removed TaskSet 5.0, whose tasks have all completed, from pool 22/07/22 19:58:43 INFO DAGScheduler: ResultStage 5 (show at Demo2.scala:28) finished in 0.031 s 22/07/22 19:58:43 INFO DAGScheduler: Job 5 is finished. Cancelling potential speculative or zombie tasks for this job 22/07/22 19:58:43 INFO TaskSchedulerImpl: Killing all running tasks in stage 5: Stage finished 22/07/22 19:58:43 INFO DAGScheduler: Job 5 finished: show at Demo2.scala:28, took 0.030228 s 22/07/22 19:58:43 INFO CodeGenerator: Code generated in 7.3015 ms +----------+---+ | name|age| +----------+---+ |娉婷的星望| 19| |静怡的雷静| 20| |潇洒的春梦| 22| |优雅的蓉菲| 21| |玲珑的文静| 19| |风雅的晓凤| 18| +----------+---+ 22/07/22 19:58:43 INFO FileSourceStrategy: Pushed Filters: IsNotNull(age),GreaterThan(age,20),LessThan(age,22) 22/07/22 19:58:43 INFO FileSourceStrategy: Post-Scan Filters: isnotnull(age#8L),(age#8L > 20),(age#8L < 22) 22/07/22 19:58:43 INFO FileSourceStrategy: Output Data Schema: struct<age: bigint, name: string> 22/07/22 19:58:43 INFO CodeGenerator: Code generated in 9.621 ms 22/07/22 19:58:43 INFO MemoryStore: Block broadcast_12 stored as values in memory (estimated size 348.4 KiB, free 895.8 MiB) 22/07/22 19:58:43 INFO MemoryStore: Block broadcast_12_piece0 stored as bytes in memory (estimated size 33.7 KiB, free 895.8 MiB) 22/07/22 19:58:43 INFO BlockManagerInfo: Added broadcast_12_piece0 in memory on 192.168.15.19:7216 (size: 33.7 KiB, free: 898.2 MiB) 22/07/22 19:58:43 INFO SparkContext: Created broadcast 12 from show at Demo2.scala:30 22/07/22 19:58:43 INFO FileSourceScanExec: Planning scan with bin packing, max size: 4194304 bytes, open cost is considered as scanning 4194304 bytes. 22/07/22 19:58:43 INFO SparkContext: Starting job: show at Demo2.scala:30 22/07/22 19:58:43 INFO DAGScheduler: Got job 6 (show at Demo2.scala:30) with 1 output partitions 22/07/22 19:58:43 INFO DAGScheduler: Final stage: ResultStage 6 (show at Demo2.scala:30) 22/07/22 19:58:43 INFO DAGScheduler: Parents of final stage: List() 22/07/22 19:58:43 INFO DAGScheduler: Missing parents: List() 22/07/22 19:58:43 INFO DAGScheduler: Submitting ResultStage 6 (MapPartitionsRDD[27] at show at Demo2.scala:30), which has no missing parents 22/07/22 19:58:43 INFO MemoryStore: Block broadcast_13 stored as values in memory (estimated size 14.1 KiB, free 895.7 MiB) 22/07/22 19:58:43 INFO MemoryStore: Block broadcast_13_piece0 stored as bytes in memory (estimated size 7.0 KiB, free 895.7 MiB) 22/07/22 19:58:43 INFO BlockManagerInfo: Added broadcast_13_piece0 in memory on 192.168.15.19:7216 (size: 7.0 KiB, free: 898.2 MiB) 22/07/22 19:58:43 INFO SparkContext: Created broadcast 13 from broadcast at DAGScheduler.scala:1513 22/07/22 19:58:43 INFO DAGScheduler: Submitting 1 missing tasks from ResultStage 6 (MapPartitionsRDD[27] at show at Demo2.scala:30) (first 15 tasks are for partitions Vector(0)) 22/07/22 19:58:43 INFO TaskSchedulerImpl: Adding task set 6.0 with 1 tasks resource profile 0 22/07/22 19:58:43 INFO TaskSetManager: Starting task 0.0 in stage 6.0 (TID 6) (192.168.15.19, executor driver, partition 0, PROCESS_LOCAL, 7877 bytes) taskResourceAssignments Map() 22/07/22 19:58:43 INFO Executor: Running task 0.0 in stage 6.0 (TID 6) 22/07/22 19:58:43 INFO FileScanRDD: Reading File path: file:///C:/Users/Administrator/IdeaProjects/baidu2/info.json, range: 0-502, partition values: [empty row] 22/07/22 19:58:43 INFO CodeGenerator: Code generated in 7.0615 ms 22/07/22 19:58:43 INFO Executor: Finished task 0.0 in stage 6.0 (TID 6). 1596 bytes result sent to driver 22/07/22 19:58:43 INFO TaskSetManager: Finished task 0.0 in stage 6.0 (TID 6) in 15 ms on 192.168.15.19 (executor driver) (1/1) 22/07/22 19:58:43 INFO TaskSchedulerImpl: Removed TaskSet 6.0, whose tasks have all completed, from pool 22/07/22 19:58:43 INFO DAGScheduler: ResultStage 6 (show at Demo2.scala:30) finished in 0.031 s 22/07/22 19:58:43 INFO DAGScheduler: Job 6 is finished. Cancelling potential speculative or zombie tasks for this job 22/07/22 19:58:43 INFO TaskSchedulerImpl: Killing all running tasks in stage 6: Stage finished 22/07/22 19:58:43 INFO DAGScheduler: Job 6 finished: show at Demo2.scala:30, took 0.034273 s +----------+---+ | name|age| +----------+---+ |优雅的蓉菲| 21| +----------+---+ 22/07/22 19:58:43 INFO FileSourceStrategy: Pushed Filters: IsNotNull(age),GreaterThanOrEqual(age,20),LessThanOrEqual(age,22) 22/07/22 19:58:43 INFO FileSourceStrategy: Post-Scan Filters: isnotnull(age#8L),(age#8L >= 20),(age#8L <= 22) 22/07/22 19:58:43 INFO FileSourceStrategy: Output Data Schema: struct<age: bigint, name: string> 22/07/22 19:58:43 INFO CodeGenerator: Code generated in 22.5614 ms 22/07/22 19:58:43 INFO CodeGenerator: Code generated in 13.2475 ms 22/07/22 19:58:43 INFO MemoryStore: Block broadcast_14 stored as values in memory (estimated size 348.4 KiB, free 895.4 MiB) 22/07/22 19:58:43 INFO MemoryStore: Block broadcast_14_piece0 stored as bytes in memory (estimated size 33.7 KiB, free 895.4 MiB) 22/07/22 19:58:43 INFO BlockManagerInfo: Added broadcast_14_piece0 in memory on 192.168.15.19:7216 (size: 33.7 KiB, free: 898.2 MiB) 22/07/22 19:58:43 INFO SparkContext: Created broadcast 14 from show at Demo2.scala:31 22/07/22 19:58:43 INFO FileSourceScanExec: Planning scan with bin packing, max size: 4194304 bytes, open cost is considered as scanning 4194304 bytes. 22/07/22 19:58:43 INFO SparkContext: Starting job: show at Demo2.scala:31 22/07/22 19:58:43 INFO DAGScheduler: Got job 7 (show at Demo2.scala:31) with 1 output partitions 22/07/22 19:58:43 INFO DAGScheduler: Final stage: ResultStage 7 (show at Demo2.scala:31) 22/07/22 19:58:43 INFO DAGScheduler: Parents of final stage: List() 22/07/22 19:58:43 INFO DAGScheduler: Missing parents: List() 22/07/22 19:58:43 INFO DAGScheduler: Submitting ResultStage 7 (MapPartitionsRDD[32] at show at Demo2.scala:31), which has no missing parents 22/07/22 19:58:43 INFO MemoryStore: Block broadcast_15 stored as values in memory (estimated size 15.8 KiB, free 895.4 MiB) 22/07/22 19:58:43 INFO MemoryStore: Block broadcast_15_piece0 stored as bytes in memory (estimated size 7.6 KiB, free 895.3 MiB) 22/07/22 19:58:43 INFO BlockManagerInfo: Added broadcast_15_piece0 in memory on 192.168.15.19:7216 (size: 7.6 KiB, free: 898.2 MiB) 22/07/22 19:58:43 INFO SparkContext: Created broadcast 15 from broadcast at DAGScheduler.scala:1513 22/07/22 19:58:43 INFO DAGScheduler: Submitting 1 missing tasks from ResultStage 7 (MapPartitionsRDD[32] at show at Demo2.scala:31) (first 15 tasks are for partitions Vector(0)) 22/07/22 19:58:43 INFO TaskSchedulerImpl: Adding task set 7.0 with 1 tasks resource profile 0 22/07/22 19:58:43 INFO TaskSetManager: Starting task 0.0 in stage 7.0 (TID 7) (192.168.15.19, executor driver, partition 0, PROCESS_LOCAL, 7877 bytes) taskResourceAssignments Map() 22/07/22 19:58:43 INFO Executor: Running task 0.0 in stage 7.0 (TID 7) 22/07/22 19:58:43 INFO BlockManagerInfo: Removed broadcast_3_piece0 on 192.168.15.19:7216 in memory (size: 6.8 KiB, free: 898.2 MiB) 22/07/22 19:58:43 INFO FileScanRDD: Reading File path: file:///C:/Users/Administrator/IdeaProjects/baidu2/info.json, range: 0-502, partition values: [empty row] 22/07/22 19:58:43 INFO BlockManagerInfo: Removed broadcast_2_piece0 on 192.168.15.19:7216 in memory (size: 33.7 KiB, free: 898.2 MiB) 22/07/22 19:58:43 INFO BlockManagerInfo: Removed broadcast_12_piece0 on 192.168.15.19:7216 in memory (size: 33.7 KiB, free: 898.3 MiB) 22/07/22 19:58:43 INFO BlockManagerInfo: Removed broadcast_7_piece0 on 192.168.15.19:7216 in memory (size: 7.2 KiB, free: 898.3 MiB) 22/07/22 19:58:43 INFO CodeGenerator: Code generated in 10.2324 ms 22/07/22 19:58:43 INFO BlockManagerInfo: Removed broadcast_6_piece0 on 192.168.15.19:7216 in memory (size: 33.7 KiB, free: 898.3 MiB) 22/07/22 19:58:43 INFO BlockManagerInfo: Removed broadcast_4_piece0 on 192.168.15.19:7216 in memory (size: 33.7 KiB, free: 898.3 MiB) 22/07/22 19:58:43 INFO BlockManagerInfo: Removed broadcast_5_piece0 on 192.168.15.19:7216 in memory (size: 7.1 KiB, free: 898.3 MiB) 22/07/22 19:58:43 INFO BlockManagerInfo: Removed broadcast_13_piece0 on 192.168.15.19:7216 in memory (size: 7.0 KiB, free: 898.3 MiB) 22/07/22 19:58:43 INFO Executor: Finished task 0.0 in stage 7.0 (TID 7). 4155 bytes result sent to driver 22/07/22 19:58:43 INFO BlockManagerInfo: Removed broadcast_8_piece0 on 192.168.15.19:7216 in memory (size: 33.7 KiB, free: 898.4 MiB) 22/07/22 19:58:43 INFO TaskSetManager: Finished task 0.0 in stage 7.0 (TID 7) in 62 ms on 192.168.15.19 (executor driver) (1/1) 22/07/22 19:58:43 INFO TaskSchedulerImpl: Removed TaskSet 7.0, whose tasks have all completed, from pool 22/07/22 19:58:43 INFO DAGScheduler: ResultStage 7 (show at Demo2.scala:31) finished in 0.094 s 22/07/22 19:58:43 INFO DAGScheduler: Job 7 is finished. Cancelling potential speculative or zombie tasks for this job 22/07/22 19:58:43 INFO TaskSchedulerImpl: Killing all running tasks in stage 7: Stage finished 22/07/22 19:58:43 INFO DAGScheduler: Job 7 finished: show at Demo2.scala:31, took 0.097717 s 22/07/22 19:58:43 INFO BlockManagerInfo: Removed broadcast_11_piece0 on 192.168.15.19:7216 in memory (size: 6.7 KiB, free: 898.4 MiB) 22/07/22 19:58:43 INFO BlockManagerInfo: Removed broadcast_10_piece0 on 192.168.15.19:7216 in memory (size: 33.7 KiB, free: 898.4 MiB) 22/07/22 19:58:43 INFO BlockManagerInfo: Removed broadcast_9_piece0 on 192.168.15.19:7216 in memory (size: 7.8 KiB, free: 898.4 MiB) 22/07/22 19:58:43 INFO CodeGenerator: Code generated in 11.2196 ms +----------+---+ | name|age| +----------+---+ |潇洒的春梦| 22| |优雅的蓉菲| 21| |静怡的雷静| 20| +----------+---+ 22/07/22 19:58:43 INFO FileSourceStrategy: Pushed Filters: IsNotNull(birthday),GreaterThan(birthday,2000-01-01 00:00:00) 22/07/22 19:58:43 INFO FileSourceStrategy: Post-Scan Filters: isnotnull(birthday#9),(birthday#9 > 2000-01-01 00:00:00) 22/07/22 19:58:43 INFO FileSourceStrategy: Output Data Schema: struct<age: bigint, birthday: string, name: string, sex: string ... 2 more fields> 22/07/22 19:58:43 INFO CodeGenerator: Code generated in 10.7126 ms 22/07/22 19:58:43 INFO MemoryStore: Block broadcast_16 stored as values in memory (estimated size 348.4 KiB, free 897.4 MiB) 22/07/22 19:58:43 INFO MemoryStore: Block broadcast_16_piece0 stored as bytes in memory (estimated size 33.7 KiB, free 897.3 MiB) 22/07/22 19:58:43 INFO BlockManagerInfo: Added broadcast_16_piece0 in memory on 192.168.15.19:7216 (size: 33.7 KiB, free: 898.4 MiB) 22/07/22 19:58:43 INFO SparkContext: Created broadcast 16 from show at Demo2.scala:34 22/07/22 19:58:43 INFO FileSourceScanExec: Planning scan with bin packing, max size: 4194304 bytes, open cost is considered as scanning 4194304 bytes. 22/07/22 19:58:43 INFO SparkContext: Starting job: show at Demo2.scala:34 22/07/22 19:58:43 INFO DAGScheduler: Got job 8 (show at Demo2.scala:34) with 1 output partitions 22/07/22 19:58:43 INFO DAGScheduler: Final stage: ResultStage 8 (show at Demo2.scala:34) 22/07/22 19:58:43 INFO DAGScheduler: Parents of final stage: List() 22/07/22 19:58:43 INFO DAGScheduler: Missing parents: List() 22/07/22 19:58:43 INFO DAGScheduler: Submitting ResultStage 8 (MapPartitionsRDD[36] at show at Demo2.scala:34), which has no missing parents 22/07/22 19:58:43 INFO MemoryStore: Block broadcast_17 stored as values in memory (estimated size 14.7 KiB, free 897.3 MiB) 22/07/22 19:58:43 INFO MemoryStore: Block broadcast_17_piece0 stored as bytes in memory (estimated size 7.2 KiB, free 897.3 MiB) 22/07/22 19:58:43 INFO BlockManagerInfo: Added broadcast_17_piece0 in memory on 192.168.15.19:7216 (size: 7.2 KiB, free: 898.4 MiB) 22/07/22 19:58:43 INFO SparkContext: Created broadcast 17 from broadcast at DAGScheduler.scala:1513 22/07/22 19:58:43 INFO DAGScheduler: Submitting 1 missing tasks from ResultStage 8 (MapPartitionsRDD[36] at show at Demo2.scala:34) (first 15 tasks are for partitions Vector(0)) 22/07/22 19:58:43 INFO TaskSchedulerImpl: Adding task set 8.0 with 1 tasks resource profile 0 22/07/22 19:58:43 INFO TaskSetManager: Starting task 0.0 in stage 8.0 (TID 8) (192.168.15.19, executor driver, partition 0, PROCESS_LOCAL, 7877 bytes) taskResourceAssignments Map() 22/07/22 19:58:43 INFO Executor: Running task 0.0 in stage 8.0 (TID 8) 22/07/22 19:58:43 INFO FileScanRDD: Reading File path: file:///C:/Users/Administrator/IdeaProjects/baidu2/info.json, range: 0-502, partition values: [empty row] 22/07/22 19:58:43 INFO CodeGenerator: Code generated in 6.3449 ms 22/07/22 19:58:43 INFO Executor: Finished task 0.0 in stage 8.0 (TID 8). 1771 bytes result sent to driver 22/07/22 19:58:43 INFO TaskSetManager: Finished task 0.0 in stage 8.0 (TID 8) in 31 ms on 192.168.15.19 (executor driver) (1/1) 22/07/22 19:58:43 INFO TaskSchedulerImpl: Removed TaskSet 8.0, whose tasks have all completed, from pool 22/07/22 19:58:43 INFO DAGScheduler: ResultStage 8 (show at Demo2.scala:34) finished in 0.031 s 22/07/22 19:58:43 INFO DAGScheduler: Job 8 is finished. Cancelling potential speculative or zombie tasks for this job 22/07/22 19:58:43 INFO TaskSchedulerImpl: Killing all running tasks in stage 8: Stage finished 22/07/22 19:58:43 INFO DAGScheduler: Job 8 finished: show at Demo2.scala:34, took 0.033509 s +---+-------------------+----------+---+ |age| birthday| name|sex| +---+-------------------+----------+---+ | 19|2001-05-06 12:00:00|娉婷的星望| 女| | 22|2000-01-06 12:00:00|潇洒的春梦| 女| | 21|2001-06-06 12:00:00|优雅的蓉菲| 女| | 19|2002-05-09 12:00:00|玲珑的文静| 女| | 18|2004-05-09 12:00:00|风雅的晓凤| 女| +---+-------------------+----------+---+ 22/07/22 19:58:43 INFO FileSourceStrategy: Pushed Filters: IsNotNull(birthday),GreaterThanOrEqual(birthday,2001-01-01 00:00:00),LessThanOrEqual(birthday,2002-12-01 00:00:00) 22/07/22 19:58:43 INFO FileSourceStrategy: Post-Scan Filters: isnotnull(birthday#9),(birthday#9 >= 2001-01-01 00:00:00),(birthday#9 <= 2002-12-01 00:00:00) 22/07/22 19:58:43 INFO FileSourceStrategy: Output Data Schema: struct<age: bigint, birthday: string, name: string, sex: string ... 2 more fields> 22/07/22 19:58:43 INFO CodeGenerator: Code generated in 9.1247 ms 22/07/22 19:58:43 INFO MemoryStore: Block broadcast_18 stored as values in memory (estimated size 348.4 KiB, free 897.0 MiB) 22/07/22 19:58:43 INFO MemoryStore: Block broadcast_18_piece0 stored as bytes in memory (estimated size 33.7 KiB, free 896.9 MiB) 22/07/22 19:58:43 INFO BlockManagerInfo: Added broadcast_18_piece0 in memory on 192.168.15.19:7216 (size: 33.7 KiB, free: 898.3 MiB) 22/07/22 19:58:43 INFO SparkContext: Created broadcast 18 from show at Demo2.scala:38 22/07/22 19:58:43 INFO FileSourceScanExec: Planning scan with bin packing, max size: 4194304 bytes, open cost is considered as scanning 4194304 bytes. 22/07/22 19:58:43 INFO SparkContext: Starting job: show at Demo2.scala:38 22/07/22 19:58:43 INFO DAGScheduler: Got job 9 (show at Demo2.scala:38) with 1 output partitions 22/07/22 19:58:43 INFO DAGScheduler: Final stage: ResultStage 9 (show at Demo2.scala:38) 22/07/22 19:58:43 INFO DAGScheduler: Parents of final stage: List() 22/07/22 19:58:43 INFO DAGScheduler: Missing parents: List() 22/07/22 19:58:43 INFO DAGScheduler: Submitting ResultStage 9 (MapPartitionsRDD[40] at show at Demo2.scala:38), which has no missing parents 22/07/22 19:58:43 INFO MemoryStore: Block broadcast_19 stored as values in memory (estimated size 15.1 KiB, free 896.9 MiB) 22/07/22 19:58:43 INFO MemoryStore: Block broadcast_19_piece0 stored as bytes in memory (estimated size 7.3 KiB, free 896.9 MiB) 22/07/22 19:58:43 INFO BlockManagerInfo: Added broadcast_19_piece0 in memory on 192.168.15.19:7216 (size: 7.3 KiB, free: 898.3 MiB) 22/07/22 19:58:43 INFO SparkContext: Created broadcast 19 from broadcast at DAGScheduler.scala:1513 22/07/22 19:58:43 INFO DAGScheduler: Submitting 1 missing tasks from ResultStage 9 (MapPartitionsRDD[40] at show at Demo2.scala:38) (first 15 tasks are for partitions Vector(0)) 22/07/22 19:58:43 INFO TaskSchedulerImpl: Adding task set 9.0 with 1 tasks resource profile 0 22/07/22 19:58:43 INFO TaskSetManager: Starting task 0.0 in stage 9.0 (TID 9) (192.168.15.19, executor driver, partition 0, PROCESS_LOCAL, 7877 bytes) taskResourceAssignments Map() 22/07/22 19:58:43 INFO Executor: Running task 0.0 in stage 9.0 (TID 9) 22/07/22 19:58:43 INFO FileScanRDD: Reading File path: file:///C:/Users/Administrator/IdeaProjects/baidu2/info.json, range: 0-502, partition values: [empty row] 22/07/22 19:58:43 INFO CodeGenerator: Code generated in 4.4931 ms 22/07/22 19:58:43 INFO Executor: Finished task 0.0 in stage 9.0 (TID 9). 1665 bytes result sent to driver 22/07/22 19:58:43 INFO TaskSetManager: Finished task 0.0 in stage 9.0 (TID 9) in 31 ms on 192.168.15.19 (executor driver) (1/1) 22/07/22 19:58:43 INFO TaskSchedulerImpl: Removed TaskSet 9.0, whose tasks have all completed, from pool 22/07/22 19:58:43 INFO DAGScheduler: ResultStage 9 (show at Demo2.scala:38) finished in 0.031 s 22/07/22 19:58:43 INFO DAGScheduler: Job 9 is finished. Cancelling potential speculative or zombie tasks for this job 22/07/22 19:58:43 INFO TaskSchedulerImpl: Killing all running tasks in stage 9: Stage finished 22/07/22 19:58:43 INFO DAGScheduler: Job 9 finished: show at Demo2.scala:38, took 0.037209 s +---+-------------------+----------+---+ |age| birthday| name|sex| +---+-------------------+----------+---+ | 19|2001-05-06 12:00:00|娉婷的星望| 女| | 21|2001-06-06 12:00:00|优雅的蓉菲| 女| | 19|2002-05-09 12:00:00|玲珑的文静| 女| +---+-------------------+----------+---+ 22/07/22 19:58:43 INFO FileSourceStrategy: Pushed Filters: 22/07/22 19:58:43 INFO FileSourceStrategy: Post-Scan Filters: 22/07/22 19:58:43 INFO FileSourceStrategy: Output Data Schema: struct<sex: string> 22/07/22 19:58:43 INFO CodeGenerator: Code generated in 46.4082 ms 22/07/22 19:58:43 INFO MemoryStore: Block broadcast_20 stored as values in memory (estimated size 348.4 KiB, free 896.6 MiB) 22/07/22 19:58:44 INFO MemoryStore: Block broadcast_20_piece0 stored as bytes in memory (estimated size 33.7 KiB, free 896.5 MiB) 22/07/22 19:58:44 INFO BlockManagerInfo: Added broadcast_20_piece0 in memory on 192.168.15.19:7216 (size: 33.7 KiB, free: 898.3 MiB) 22/07/22 19:58:44 INFO SparkContext: Created broadcast 20 from show at Demo2.scala:43 22/07/22 19:58:44 INFO FileSourceScanExec: Planning scan with bin packing, max size: 4194304 bytes, open cost is considered as scanning 4194304 bytes. 22/07/22 19:58:44 INFO DAGScheduler: Registering RDD 44 (show at Demo2.scala:43) as input to shuffle 0 22/07/22 19:58:44 INFO DAGScheduler: Got map stage job 10 (show at Demo2.scala:43) with 1 output partitions 22/07/22 19:58:44 INFO DAGScheduler: Final stage: ShuffleMapStage 10 (show at Demo2.scala:43) 22/07/22 19:58:44 INFO DAGScheduler: Parents of final stage: List() 22/07/22 19:58:44 INFO DAGScheduler: Missing parents: List() 22/07/22 19:58:44 INFO DAGScheduler: Submitting ShuffleMapStage 10 (MapPartitionsRDD[44] at show at Demo2.scala:43), which has no missing parents 22/07/22 19:58:44 INFO MemoryStore: Block broadcast_21 stored as values in memory (estimated size 30.2 KiB, free 896.5 MiB) 22/07/22 19:58:44 INFO MemoryStore: Block broadcast_21_piece0 stored as bytes in memory (estimated size 13.7 KiB, free 896.5 MiB) 22/07/22 19:58:44 INFO BlockManagerInfo: Added broadcast_21_piece0 in memory on 192.168.15.19:7216 (size: 13.7 KiB, free: 898.3 MiB) 22/07/22 19:58:44 INFO SparkContext: Created broadcast 21 from broadcast at DAGScheduler.scala:1513 22/07/22 19:58:44 INFO DAGScheduler: Submitting 1 missing tasks from ShuffleMapStage 10 (MapPartitionsRDD[44] at show at Demo2.scala:43) (first 15 tasks are for partitions Vector(0)) 22/07/22 19:58:44 INFO TaskSchedulerImpl: Adding task set 10.0 with 1 tasks resource profile 0 22/07/22 19:58:44 INFO TaskSetManager: Starting task 0.0 in stage 10.0 (TID 10) (192.168.15.19, executor driver, partition 0, PROCESS_LOCAL, 7866 bytes) taskResourceAssignments Map() 22/07/22 19:58:44 INFO Executor: Running task 0.0 in stage 10.0 (TID 10) 22/07/22 19:58:44 INFO CodeGenerator: Code generated in 10.76 ms 22/07/22 19:58:44 INFO CodeGenerator: Code generated in 4.5678 ms 22/07/22 19:58:44 INFO CodeGenerator: Code generated in 6.1798 ms 22/07/22 19:58:44 INFO FileScanRDD: Reading File path: file:///C:/Users/Administrator/IdeaProjects/baidu2/info.json, range: 0-502, partition values: [empty row] 22/07/22 19:58:44 INFO Executor: Finished task 0.0 in stage 10.0 (TID 10). 2817 bytes result sent to driver 22/07/22 19:58:44 INFO TaskSetManager: Finished task 0.0 in stage 10.0 (TID 10) in 140 ms on 192.168.15.19 (executor driver) (1/1) 22/07/22 19:58:44 INFO TaskSchedulerImpl: Removed TaskSet 10.0, whose tasks have all completed, from pool 22/07/22 19:58:44 INFO DAGScheduler: ShuffleMapStage 10 (show at Demo2.scala:43) finished in 0.156 s 22/07/22 19:58:44 INFO DAGScheduler: looking for newly runnable stages 22/07/22 19:58:44 INFO DAGScheduler: running: HashSet() 22/07/22 19:58:44 INFO DAGScheduler: waiting: HashSet() 22/07/22 19:58:44 INFO DAGScheduler: failed: HashSet() 22/07/22 19:58:44 INFO ShufflePartitionsUtil: For shuffle(0), advisory target size: 67108864, actual target size 1048576, minimum partition size: 1048576 22/07/22 19:58:44 INFO HashAggregateExec: spark.sql.codegen.aggregate.map.twolevel.enabled is set to true, but current version of codegened fast hashmap does not support this aggregate. 22/07/22 19:58:44 INFO CodeGenerator: Code generated in 18.8012 ms 22/07/22 19:58:44 INFO SparkContext: Starting job: show at Demo2.scala:43 22/07/22 19:58:44 INFO DAGScheduler: Got job 11 (show at Demo2.scala:43) with 1 output partitions 22/07/22 19:58:44 INFO DAGScheduler: Final stage: ResultStage 12 (show at Demo2.scala:43) 22/07/22 19:58:44 INFO DAGScheduler: Parents of final stage: List(ShuffleMapStage 11) 22/07/22 19:58:44 INFO DAGScheduler: Missing parents: List() 22/07/22 19:58:44 INFO DAGScheduler: Submitting ResultStage 12 (MapPartitionsRDD[47] at show at Demo2.scala:43), which has no missing parents 22/07/22 19:58:44 INFO MemoryStore: Block broadcast_22 stored as values in memory (estimated size 31.2 KiB, free 896.5 MiB) 22/07/22 19:58:44 INFO MemoryStore: Block broadcast_22_piece0 stored as bytes in memory (estimated size 14.4 KiB, free 896.5 MiB) 22/07/22 19:58:44 INFO BlockManagerInfo: Added broadcast_22_piece0 in memory on 192.168.15.19:7216 (size: 14.4 KiB, free: 898.3 MiB) 22/07/22 19:58:44 INFO SparkContext: Created broadcast 22 from broadcast at DAGScheduler.scala:1513 22/07/22 19:58:44 INFO DAGScheduler: Submitting 1 missing tasks from ResultStage 12 (MapPartitionsRDD[47] at show at Demo2.scala:43) (first 15 tasks are for partitions Vector(0)) 22/07/22 19:58:44 INFO TaskSchedulerImpl: Adding task set 12.0 with 1 tasks resource profile 0 22/07/22 19:58:44 INFO TaskSetManager: Starting task 0.0 in stage 12.0 (TID 11) (192.168.15.19, executor driver, partition 0, NODE_LOCAL, 7399 bytes) taskResourceAssignments Map() 22/07/22 19:58:44 INFO Executor: Running task 0.0 in stage 12.0 (TID 11) 22/07/22 19:58:44 INFO ShuffleBlockFetcherIterator: Getting 1 (72.0 B) non-empty blocks including 1 (72.0 B) local and 0 (0.0 B) host-local and 0 (0.0 B) push-merged-local and 0 (0.0 B) remote blocks 22/07/22 19:58:44 INFO ShuffleBlockFetcherIterator: Started 0 remote fetches in 13 ms 22/07/22 19:58:44 INFO Executor: Finished task 0.0 in stage 12.0 (TID 11). 3854 bytes result sent to driver 22/07/22 19:58:44 INFO TaskSetManager: Finished task 0.0 in stage 12.0 (TID 11) in 63 ms on 192.168.15.19 (executor driver) (1/1) 22/07/22 19:58:44 INFO TaskSchedulerImpl: Removed TaskSet 12.0, whose tasks have all completed, from pool 22/07/22 19:58:44 INFO DAGScheduler: ResultStage 12 (show at Demo2.scala:43) finished in 0.078 s 22/07/22 19:58:44 INFO DAGScheduler: Job 11 is finished. Cancelling potential speculative or zombie tasks for this job 22/07/22 19:58:44 INFO TaskSchedulerImpl: Killing all running tasks in stage 12: Stage finished 22/07/22 19:58:44 INFO DAGScheduler: Job 11 finished: show at Demo2.scala:43, took 0.089055 s 22/07/22 19:58:44 INFO CodeGenerator: Code generated in 9.0421 ms +---+--------+ |sex|count(1)| +---+--------+ | 女| 6| +---+--------+ 22/07/22 19:58:44 INFO FileSourceStrategy: Pushed Filters: 22/07/22 19:58:44 INFO FileSourceStrategy: Post-Scan Filters: 22/07/22 19:58:44 INFO FileSourceStrategy: Output Data Schema: struct<age: bigint, birthday: string, name: string, sex: string ... 2 more fields> 22/07/22 19:58:44 INFO CodeGenerator: Code generated in 10.4727 ms 22/07/22 19:58:44 INFO MemoryStore: Block broadcast_23 stored as values in memory (estimated size 348.4 KiB, free 896.1 MiB) 22/07/22 19:58:44 INFO MemoryStore: Block broadcast_23_piece0 stored as bytes in memory (estimated size 33.7 KiB, free 896.1 MiB) 22/07/22 19:58:44 INFO BlockManagerInfo: Added broadcast_23_piece0 in memory on 192.168.15.19:7216 (size: 33.7 KiB, free: 898.2 MiB) 22/07/22 19:58:44 INFO SparkContext: Created broadcast 23 from show at Demo2.scala:47 22/07/22 19:58:44 INFO FileSourceScanExec: Planning scan with bin packing, max size: 4194304 bytes, open cost is considered as scanning 4194304 bytes. 22/07/22 19:58:44 INFO SparkContext: Starting job: show at Demo2.scala:47 22/07/22 19:58:44 INFO DAGScheduler: Got job 12 (show at Demo2.scala:47) with 1 output partitions 22/07/22 19:58:44 INFO DAGScheduler: Final stage: ResultStage 13 (show at Demo2.scala:47) 22/07/22 19:58:44 INFO DAGScheduler: Parents of final stage: List() 22/07/22 19:58:44 INFO DAGScheduler: Missing parents: List() 22/07/22 19:58:44 INFO DAGScheduler: Submitting ResultStage 13 (MapPartitionsRDD[51] at show at Demo2.scala:47), which has no missing parents 22/07/22 19:58:44 INFO MemoryStore: Block broadcast_24 stored as values in memory (estimated size 12.4 KiB, free 896.1 MiB) 22/07/22 19:58:44 INFO MemoryStore: Block broadcast_24_piece0 stored as bytes in memory (estimated size 6.3 KiB, free 896.1 MiB) 22/07/22 19:58:44 INFO BlockManagerInfo: Added broadcast_24_piece0 in memory on 192.168.15.19:7216 (size: 6.3 KiB, free: 898.2 MiB) 22/07/22 19:58:44 INFO SparkContext: Created broadcast 24 from broadcast at DAGScheduler.scala:1513 22/07/22 19:58:44 INFO DAGScheduler: Submitting 1 missing tasks from ResultStage 13 (MapPartitionsRDD[51] at show at Demo2.scala:47) (first 15 tasks are for partitions Vector(0)) 22/07/22 19:58:44 INFO TaskSchedulerImpl: Adding task set 13.0 with 1 tasks resource profile 0 22/07/22 19:58:44 INFO TaskSetManager: Starting task 0.0 in stage 13.0 (TID 12) (192.168.15.19, executor driver, partition 0, PROCESS_LOCAL, 7877 bytes) taskResourceAssignments Map() 22/07/22 19:58:44 INFO Executor: Running task 0.0 in stage 13.0 (TID 12) 22/07/22 19:58:44 INFO FileScanRDD: Reading File path: file:///C:/Users/Administrator/IdeaProjects/baidu2/info.json, range: 0-502, partition values: [empty row] 22/07/22 19:58:44 INFO Executor: Finished task 0.0 in stage 13.0 (TID 12). 4733 bytes result sent to driver 22/07/22 19:58:44 INFO TaskSetManager: Finished task 0.0 in stage 13.0 (TID 12) in 15 ms on 192.168.15.19 (executor driver) (1/1) 22/07/22 19:58:44 INFO TaskSchedulerImpl: Removed TaskSet 13.0, whose tasks have all completed, from pool 22/07/22 19:58:44 INFO DAGScheduler: ResultStage 13 (show at Demo2.scala:47) finished in 0.031 s 22/07/22 19:58:44 INFO DAGScheduler: Job 12 is finished. Cancelling potential speculative or zombie tasks for this job 22/07/22 19:58:44 INFO TaskSchedulerImpl: Killing all running tasks in stage 13: Stage finished 22/07/22 19:58:44 INFO DAGScheduler: Job 12 finished: show at Demo2.scala:47, took 0.026201 s 22/07/22 19:58:44 INFO CodeGenerator: Code generated in 9.2888 ms +---+-------------------+----------+---+ |age| birthday| name|sex| +---+-------------------+----------+---+ | 20|1999-05-02 12:00:00|静怡的雷静| 女| | 22|2000-01-06 12:00:00|潇洒的春梦| 女| | 19|2001-05-06 12:00:00|娉婷的星望| 女| | 21|2001-06-06 12:00:00|优雅的蓉菲| 女| | 19|2002-05-09 12:00:00|玲珑的文静| 女| | 18|2004-05-09 12:00:00|风雅的晓凤| 女| +---+-------------------+----------+---+ 22/07/22 19:58:44 INFO FileSourceStrategy: Pushed Filters: 22/07/22 19:58:44 INFO FileSourceStrategy: Post-Scan Filters: 22/07/22 19:58:44 INFO FileSourceStrategy: Output Data Schema: struct<age: bigint> 22/07/22 19:58:44 INFO BlockManagerInfo: Removed broadcast_16_piece0 on 192.168.15.19:7216 in memory (size: 33.7 KiB, free: 898.3 MiB) 22/07/22 19:58:44 INFO BlockManagerInfo: Removed broadcast_14_piece0 on 192.168.15.19:7216 in memory (size: 33.7 KiB, free: 898.3 MiB) 22/07/22 19:58:44 INFO BlockManagerInfo: Removed broadcast_20_piece0 on 192.168.15.19:7216 in memory (size: 33.7 KiB, free: 898.3 MiB) 22/07/22 19:58:44 INFO BlockManagerInfo: Removed broadcast_22_piece0 on 192.168.15.19:7216 in memory (size: 14.4 KiB, free: 898.4 MiB) 22/07/22 19:58:44 INFO BlockManagerInfo: Removed broadcast_17_piece0 on 192.168.15.19:7216 in memory (size: 7.2 KiB, free: 898.4 MiB) 22/07/22 19:58:44 INFO BlockManagerInfo: Removed broadcast_24_piece0 on 192.168.15.19:7216 in memory (size: 6.3 KiB, free: 898.4 MiB) 22/07/22 19:58:44 INFO BlockManagerInfo: Removed broadcast_19_piece0 on 192.168.15.19:7216 in memory (size: 7.3 KiB, free: 898.4 MiB) 22/07/22 19:58:44 INFO BlockManagerInfo: Removed broadcast_15_piece0 on 192.168.15.19:7216 in memory (size: 7.6 KiB, free: 898.4 MiB) 22/07/22 19:58:44 INFO BlockManagerInfo: Removed broadcast_18_piece0 on 192.168.15.19:7216 in memory (size: 33.7 KiB, free: 898.4 MiB) 22/07/22 19:58:44 INFO BlockManagerInfo: Removed broadcast_21_piece0 on 192.168.15.19:7216 in memory (size: 13.7 KiB, free: 898.4 MiB) 22/07/22 19:58:44 INFO CodeGenerator: Code generated in 18.6777 ms 22/07/22 19:58:44 INFO BlockManagerInfo: Removed broadcast_23_piece0 on 192.168.15.19:7216 in memory (size: 33.7 KiB, free: 898.5 MiB) 22/07/22 19:58:44 INFO MemoryStore: Block broadcast_25 stored as values in memory (estimated size 348.4 KiB, free 897.8 MiB) 22/07/22 19:58:44 INFO MemoryStore: Block broadcast_25_piece0 stored as bytes in memory (estimated size 33.7 KiB, free 897.7 MiB) 22/07/22 19:58:44 INFO BlockManagerInfo: Added broadcast_25_piece0 in memory on 192.168.15.19:7216 (size: 33.7 KiB, free: 898.4 MiB) 22/07/22 19:58:44 INFO SparkContext: Created broadcast 25 from show at Demo2.scala:51 22/07/22 19:58:44 INFO FileSourceScanExec: Planning scan with bin packing, max size: 4194304 bytes, open cost is considered as scanning 4194304 bytes. 22/07/22 19:58:44 INFO DAGScheduler: Registering RDD 55 (show at Demo2.scala:51) as input to shuffle 1 22/07/22 19:58:44 INFO DAGScheduler: Got map stage job 13 (show at Demo2.scala:51) with 1 output partitions 22/07/22 19:58:44 INFO DAGScheduler: Final stage: ShuffleMapStage 14 (show at Demo2.scala:51) 22/07/22 19:58:44 INFO DAGScheduler: Parents of final stage: List() 22/07/22 19:58:44 INFO DAGScheduler: Missing parents: List() 22/07/22 19:58:44 INFO DAGScheduler: Submitting ShuffleMapStage 14 (MapPartitionsRDD[55] at show at Demo2.scala:51), which has no missing parents 22/07/22 19:58:44 INFO MemoryStore: Block broadcast_26 stored as values in memory (estimated size 22.0 KiB, free 897.7 MiB) 22/07/22 19:58:44 INFO MemoryStore: Block broadcast_26_piece0 stored as bytes in memory (estimated size 9.6 KiB, free 897.7 MiB) 22/07/22 19:58:44 INFO BlockManagerInfo: Added broadcast_26_piece0 in memory on 192.168.15.19:7216 (size: 9.6 KiB, free: 898.4 MiB) 22/07/22 19:58:44 INFO SparkContext: Created broadcast 26 from broadcast at DAGScheduler.scala:1513 22/07/22 19:58:44 INFO DAGScheduler: Submitting 1 missing tasks from ShuffleMapStage 14 (MapPartitionsRDD[55] at show at Demo2.scala:51) (first 15 tasks are for partitions Vector(0)) 22/07/22 19:58:44 INFO TaskSchedulerImpl: Adding task set 14.0 with 1 tasks resource profile 0 22/07/22 19:58:44 INFO TaskSetManager: Starting task 0.0 in stage 14.0 (TID 13) (192.168.15.19, executor driver, partition 0, PROCESS_LOCAL, 7866 bytes) taskResourceAssignments Map() 22/07/22 19:58:44 INFO Executor: Running task 0.0 in stage 14.0 (TID 13) 22/07/22 19:58:44 INFO FileScanRDD: Reading File path: file:///C:/Users/Administrator/IdeaProjects/baidu2/info.json, range: 0-502, partition values: [empty row] 22/07/22 19:58:44 INFO Executor: Finished task 0.0 in stage 14.0 (TID 13). 1971 bytes result sent to driver 22/07/22 19:58:44 INFO TaskSetManager: Finished task 0.0 in stage 14.0 (TID 13) in 15 ms on 192.168.15.19 (executor driver) (1/1) 22/07/22 19:58:44 INFO TaskSchedulerImpl: Removed TaskSet 14.0, whose tasks have all completed, from pool 22/07/22 19:58:44 INFO DAGScheduler: ShuffleMapStage 14 (show at Demo2.scala:51) finished in 0.031 s 22/07/22 19:58:44 INFO DAGScheduler: looking for newly runnable stages 22/07/22 19:58:44 INFO DAGScheduler: running: HashSet() 22/07/22 19:58:44 INFO DAGScheduler: waiting: HashSet() 22/07/22 19:58:44 INFO DAGScheduler: failed: HashSet() 22/07/22 19:58:44 INFO CodeGenerator: Code generated in 18.1245 ms 22/07/22 19:58:44 INFO SparkContext: Starting job: show at Demo2.scala:51 22/07/22 19:58:44 INFO DAGScheduler: Got job 14 (show at Demo2.scala:51) with 1 output partitions 22/07/22 19:58:44 INFO DAGScheduler: Final stage: ResultStage 16 (show at Demo2.scala:51) 22/07/22 19:58:44 INFO DAGScheduler: Parents of final stage: List(ShuffleMapStage 15) 22/07/22 19:58:44 INFO DAGScheduler: Missing parents: List() 22/07/22 19:58:44 INFO DAGScheduler: Submitting ResultStage 16 (MapPartitionsRDD[58] at show at Demo2.scala:51), which has no missing parents 22/07/22 19:58:44 INFO MemoryStore: Block broadcast_27 stored as values in memory (estimated size 19.5 KiB, free 897.7 MiB) 22/07/22 19:58:44 INFO MemoryStore: Block broadcast_27_piece0 stored as bytes in memory (estimated size 7.9 KiB, free 897.7 MiB) 22/07/22 19:58:44 INFO BlockManagerInfo: Added broadcast_27_piece0 in memory on 192.168.15.19:7216 (size: 7.9 KiB, free: 898.4 MiB) 22/07/22 19:58:44 INFO SparkContext: Created broadcast 27 from broadcast at DAGScheduler.scala:1513 22/07/22 19:58:44 INFO DAGScheduler: Submitting 1 missing tasks from ResultStage 16 (MapPartitionsRDD[58] at show at Demo2.scala:51) (first 15 tasks are for partitions Vector(0)) 22/07/22 19:58:44 INFO TaskSchedulerImpl: Adding task set 16.0 with 1 tasks resource profile 0 22/07/22 19:58:44 INFO TaskSetManager: Starting task 0.0 in stage 16.0 (TID 14) (192.168.15.19, executor driver, partition 0, NODE_LOCAL, 7399 bytes) taskResourceAssignments Map() 22/07/22 19:58:44 INFO Executor: Running task 0.0 in stage 16.0 (TID 14) 22/07/22 19:58:44 INFO ShuffleBlockFetcherIterator: Getting 1 (88.0 B) non-empty blocks including 1 (88.0 B) local and 0 (0.0 B) host-local and 0 (0.0 B) push-merged-local and 0 (0.0 B) remote blocks 22/07/22 19:58:44 INFO ShuffleBlockFetcherIterator: Started 0 remote fetches in 0 ms 22/07/22 19:58:44 INFO Executor: Finished task 0.0 in stage 16.0 (TID 14). 2766 bytes result sent to driver 22/07/22 19:58:44 INFO TaskSetManager: Finished task 0.0 in stage 16.0 (TID 14) in 15 ms on 192.168.15.19 (executor driver) (1/1) 22/07/22 19:58:44 INFO TaskSchedulerImpl: Removed TaskSet 16.0, whose tasks have all completed, from pool 22/07/22 19:58:44 INFO DAGScheduler: ResultStage 16 (show at Demo2.scala:51) finished in 0.015 s 22/07/22 19:58:44 INFO DAGScheduler: Job 14 is finished. Cancelling potential speculative or zombie tasks for this job 22/07/22 19:58:44 INFO TaskSchedulerImpl: Killing all running tasks in stage 16: Stage finished 22/07/22 19:58:44 INFO DAGScheduler: Job 14 finished: show at Demo2.scala:51, took 0.022406 s 22/07/22 19:58:44 INFO CodeGenerator: Code generated in 6.1502 ms +--------+--------+------------------+--------+--------+ |sum(age)|count(1)|round(avg(age), 2)|max(age)|min(age)| +--------+--------+------------------+--------+--------+ | 119| 6| 19.83| 22| 18| +--------+--------+------------------+--------+--------+ 22/07/22 19:58:44 INFO SparkUI: Stopped Spark web UI at http://192.168.15.19:4040 22/07/22 19:58:44 INFO MapOutputTrackerMasterEndpoint: MapOutputTrackerMasterEndpoint stopped! 22/07/22 19:58:45 INFO MemoryStore: MemoryStore cleared 22/07/22 19:58:45 INFO BlockManager: BlockManager stopped 22/07/22 19:58:45 INFO BlockManagerMaster: BlockManagerMaster stopped 22/07/22 19:58:45 INFO OutputCommitCoordinator$OutputCommitCoordinatorEndpoint: OutputCommitCoordinator stopped! 22/07/22 19:58:45 INFO SparkContext: Successfully stopped SparkContext 22/07/22 19:58:45 INFO ShutdownHookManager: Shutdown hook called 22/07/22 19:58:45 INFO ShutdownHookManager: Deleting directory C:\Users\Administrator\AppData\Local\Temp\spark-6365829b-8e4f-476f-994e-052b1fddd2b2 Process finished with exit code 0
腾讯云开发者
