Spark SQL入门示例
2023-09-14 09:01:57 时间
pom
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>org.zxl</groupId>
<artifactId>SparkDemo1</artifactId>
<version>1.0-SNAPSHOT</version>
<properties>
<maven.compiler.source>8</maven.compiler.source>
<maven.compiler.target>8</maven.compiler.target>
<spark.version>3.1.1</spark.version>
<spark.scala.version>2.12</spark.scala.version>
</properties>
<dependencies>
<dependency>
<groupId>org.apache.spark</groupId>
<artifactId>spark-core_${spark.scala.version}</artifactId>
<version>${spark.version}</version>
</dependency>
<dependency>
<groupId>org.apache.spark</groupId>
<artifactId>spark-sql_${spark.scala.version}</artifactId>
<version>${spark.version}</version>
</dependency>
<!--看yarn源码-->
<dependency>
<groupId>org.apache.spark</groupId>
<artifactId>spark-yarn_${spark.scala.version}</artifactId>
<version>${spark.version}</version>
</dependency>
<!--<dependency>
<groupId>org.apache.hadoop</groupId>
<artifactId>hadoop-hdfs-client</artifactId>
<version>3.0.0</version>
</dependency>
<dependency>
<groupId>org.apache.spark</groupId>
<artifactId>spark-streaming_${spark.scala.version}</artifactId>
<version>${spark.version}</version>
</dependency>
-->
<!--<dependency>
<groupId>org.apache.spark</groupId>
<artifactId>spark-streaming-kafka-0-10_2.11</artifactId>
<version>2.4.4</version>
</dependency>-->
<!--<dependency>
<groupId>org.apache.spark</groupId>
<artifactId>spark-hive_${spark.scala.version}</artifactId>
<version>${spark.version}</version>
</dependency>-->
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<!--<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.48</version>
</dependency>-->
<!--
和其他框架整合使用时有可能报错compiler
-->
<!--<dependency>
<groupId>org.codehaus.janino</groupId>
<artifactId>commons-compiler</artifactId>
<version>3.1.0</version>
</dependency>-->
</dependencies>
<build>
<plugins>
<!-- 该插件用于将 Scala 代码编译成 class 文件 -->
<plugin>
<groupId>net.alchim31.maven</groupId>
<artifactId>scala-maven-plugin</artifactId>
<version>3.2.2</version>
<executions>
<execution>
<!-- 声明绑定到 maven 的 compile 阶段 -->
<goals>
<goal>testCompile</goal>
</goals>
</execution>
</executions>
</plugin>
<!--maven打包的插件-->
<!--maven-assembly-plugin 和 maven-shade-plugin都是打包插件。遇到同名文件assembly是覆盖，shade是追加。所以此处选择shade插件-->
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-shade-plugin</artifactId>
<version>3.2.1</version>
<executions>
<execution>
<phase>package</phase>
<goals>
<goal>shade</goal>
</goals>
<configuration>
<filters>
<filter>
<artifact>*:*</artifact>
<excludes>
<exclude>META-INF/*.SF</exclude>
<exclude>META-INF/*.DSA</exclude>
<exclude>META-INF/*.RSA</exclude>
</excludes>
</filter>
</filters>
<transformers>
<transformer
implementation="org.apache.maven.plugins.shade.resource.AppendingTransformer">
<resource>reference.conf</resource>
</transformer>
<!--指定main方法-->
<transformer
implementation="org.apache.maven.plugins.shade.resource.ManifestResourceTransformer">
<mainClass>com.zxl.spark.L01_WordCount</mainClass>
</transformer>
</transformers>
</configuration>
</execution>
</executions>
</plugin>
<!--<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-assembly-plugin</artifactId>
<version>3.1.1</version>
<configuration>
<descriptorRefs>
<descriptorRef>jar-with-dependencies</descriptorRef>
</descriptorRefs>
</configuration>
<executions>
<execution>
<id>make-assembly</id>
<phase>package</phase>
<goals>
<goal>single</goal>
</goals>
</execution>
</executions>
</plugin>-->
</plugins>
</build>
</project>
data
{"name":"zhangsan0","age":20}
{"name":"zhangsan1","age":21}
{"name":"zhangsan2","age":22}
{"name":"zhangsan3","age":23}
{"name":"zhangsan4","age":24}
code
package com.zxl.spark.sql
import org.apache.spark.sql.catalog.{Database, Table}
import org.apache.spark.{SparkConf, SparkContext}
import org.apache.spark.sql.{DataFrame, Dataset, SparkSession, catalog}
object lesson01_sql_basic {
def main(args: Array[String]): Unit = {
// sql字符串 ==》 dataset 是对rdd的包装
// 只有rdd才能触发DAGScheduler
val conf: SparkConf = new SparkConf().setMaster("local").setAppName("testsql")
val session: SparkSession = SparkSession.builder()
.config(conf)
//.enableHiveSupport() spark sql on hive需要开启 支持ddl
.getOrCreate()
//可以获取到sc
val sparkContext: SparkContext = session.sparkContext
sparkContext.setLogLevel("ERROR")
val dataFrame: DataFrame = session.read.json("input/json")
//展示数据
println(">" * 50)
dataFrame.show()
//展示schema
println(">" * 50)
dataFrame.printSchema()
//while (true){}
println(">" * 50)
val databases: Dataset[Database] = session.catalog.listDatabases()
databases.show()
println(">" * 50)
val tables: Dataset[Table] = session.catalog.listTables()
tables.show()
println(">" * 50)
val functions: Dataset[catalog.Function] = session.catalog.listFunctions()
functions.show()
println(">" * 50)
dataFrame.createTempView("abc")
val dataFrame1: DataFrame = session.sql("select * from abc")
dataFrame1.show()
println(">" * 50)
session.catalog.listTables().show()
import scala.io.StdIn._
while (true){
val sqlStr: String = readLine("input your sql:")
session.sql(sqlStr).show()
}
}
}
日志输出
D:\Develop\Java\jdk1.8.0_202\bin\java.exe "-javaagent:D:\Programs\IntelliJ IDEA 2021.1.2\lib\idea_rt.jar=64167:D:\Programs\IntelliJ IDEA 2021.1.2\bin" -Dfile.encoding=UTF-8 -classpath D:\Develop\Java\jdk1.8.0_202\jre\lib\charsets.jar;D:\Develop\Java\jdk1.8.0_202\jre\lib\deploy.jar;D:\Develop\Java\jdk1.8.0_202\jre\lib\ext\access-bridge-64.jar;D:\Develop\Java\jdk1.8.0_202\jre\lib\ext\cldrdata.jar;D:\Develop\Java\jdk1.8.0_202\jre\lib\ext\dnsns.jar;D:\Develop\Java\jdk1.8.0_202\jre\lib\ext\jaccess.jar;D:\Develop\Java\jdk1.8.0_202\jre\lib\ext\jfxrt.jar;D:\Develop\Java\jdk1.8.0_202\jre\lib\ext\localedata.jar;D:\Develop\Java\jdk1.8.0_202\jre\lib\ext\nashorn.jar;D:\Develop\Java\jdk1.8.0_202\jre\lib\ext\sunec.jar;D:\Develop\Java\jdk1.8.0_202\jre\lib\ext\sunjce_provider.jar;D:\Develop\Java\jdk1.8.0_202\jre\lib\ext\sunmscapi.jar;D:\Develop\Java\jdk1.8.0_202\jre\lib\ext\sunpkcs11.jar;D:\Develop\Java\jdk1.8.0_202\jre\lib\ext\zipfs.jar;D:\Develop\Java\jdk1.8.0_202\jre\lib\javaws.jar;D:\Develop\Java\jdk1.8.0_202\jre\lib\jce.jar;D:\Develop\Java\jdk1.8.0_202\jre\lib\jfr.jar;D:\Develop\Java\jdk1.8.0_202\jre\lib\jfxswt.jar;D:\Develop\Java\jdk1.8.0_202\jre\lib\jsse.jar;D:\Develop\Java\jdk1.8.0_202\jre\lib\management-agent.jar;D:\Develop\Java\jdk1.8.0_202\jre\lib\plugin.jar;D:\Develop\Java\jdk1.8.0_202\jre\lib\resources.jar;D:\Develop\Java\jdk1.8.0_202\jre\lib\rt.jar;E:\Workspace\Spark\SparkDemo1\target\classes;D:\Develop\scala-2.12.13\lib\scala-library.jar;D:\Develop\scala-2.12.13\lib\scala-parser-combinators_2.12-1.0.7.jar;D:\Develop\scala-2.12.13\lib\scala-reflect.jar;D:\Develop\scala-2.12.13\lib\scala-swing_2.12-2.0.3.jar;D:\Develop\scala-2.12.13\lib\scala-xml_2.12-1.0.6.jar;E:\Repository\org\apache\spark\spark-core_2.12\3.1.1\spark-core_2.12-3.1.1.jar;E:\Repository\com\thoughtworks\paranamer\paranamer\2.8\paranamer-2.8.jar;E:\Repository\org\apache\avro\avro\1.8.2\avro-1.8.2.jar;E:\Repository\org\codehaus\jackson\jackson-core-asl\1.9.13\jackson-core-asl-1.9.13.jar;E:\Repository\org\codehaus\jackson\jackson-mapper-asl\1.9.13\jackson-mapper-asl-1.9.13.jar;E:\Repository\org\apache\commons\commons-compress\1.8.1\commons-compress-1.8.1.jar;E:\Repository\org\tukaani\xz\1.5\xz-1.5.jar;E:\Repository\org\apache\avro\avro-mapred\1.8.2\avro-mapred-1.8.2-hadoop2.jar;E:\Repository\org\apache\avro\avro-ipc\1.8.2\avro-ipc-1.8.2.jar;E:\Repository\commons-codec\commons-codec\1.9\commons-codec-1.9.jar;E:\Repository\com\twitter\chill_2.12\0.9.5\chill_2.12-0.9.5.jar;E:\Repository\com\esotericsoftware\kryo-shaded\4.0.2\kryo-shaded-4.0.2.jar;E:\Repository\com\esotericsoftware\minlog\1.3.0\minlog-1.3.0.jar;E:\Repository\org\objenesis\objenesis\2.5.1\objenesis-2.5.1.jar;E:\Repository\com\twitter\chill-java\0.9.5\chill-java-0.9.5.jar;E:\Repository\org\apache\xbean\xbean-asm7-shaded\4.15\xbean-asm7-shaded-4.15.jar;E:\Repository\org\apache\hadoop\hadoop-client\3.2.0\hadoop-client-3.2.0.jar;E:\Repository\org\apache\hadoop\hadoop-common\3.2.0\hadoop-common-3.2.0.jar;E:\Repository\org\apache\httpcomponents\httpclient\4.5.2\httpclient-4.5.2.jar;E:\Repository\org\apache\httpcomponents\httpcore\4.4.4\httpcore-4.4.4.jar;E:\Repository\commons-collections\commons-collections\3.2.2\commons-collections-3.2.2.jar;E:\Repository\org\eclipse\jetty\jetty-servlet\9.3.24.v20180605\jetty-servlet-9.3.24.v20180605.jar;E:\Repository\org\eclipse\jetty\jetty-security\9.3.24.v20180605\jetty-security-9.3.24.v20180605.jar;E:\Repository\javax\servlet\jsp\jsp-api\2.1\jsp-api-2.1.jar;E:\Repository\commons-beanutils\commons-beanutils\1.9.3\commons-beanutils-1.9.3.jar;E:\Repository\org\apache\commons\commons-configuration2\2.1.1\commons-configuration2-2.1.1.jar;E:\Repository\com\google\re2j\re2j\1.1\re2j-1.1.jar;E:\Repository\com\google\code\gson\gson\2.2.4\gson-2.2.4.jar;E:\Repository\org\apache\curator\curator-client\2.12.0\curator-client-2.12.0.jar;E:\Repository\org\apache\htrace\htrace-core4\4.1.0-incubating\htrace-core4-4.1.0-incubating.jar;E:\Repository\org\apache\kerby\kerb-simplekdc\1.0.1\kerb-simplekdc-1.0.1.jar;E:\Repository\org\apache\kerby\kerb-client\1.0.1\kerb-client-1.0.1.jar;E:\Repository\org\apache\kerby\kerby-config\1.0.1\kerby-config-1.0.1.jar;E:\Repository\org\apache\kerby\kerb-core\1.0.1\kerb-core-1.0.1.jar;E:\Repository\org\apache\kerby\kerby-pkix\1.0.1\kerby-pkix-1.0.1.jar;E:\Repository\org\apache\kerby\kerby-asn1\1.0.1\kerby-asn1-1.0.1.jar;E:\Repository\org\apache\kerby\kerby-util\1.0.1\kerby-util-1.0.1.jar;E:\Repository\org\apache\kerby\kerb-common\1.0.1\kerb-common-1.0.1.jar;E:\Repository\org\apache\kerby\kerb-crypto\1.0.1\kerb-crypto-1.0.1.jar;E:\Repository\org\apache\kerby\kerb-util\1.0.1\kerb-util-1.0.1.jar;E:\Repository\org\apache\kerby\token-provider\1.0.1\token-provider-1.0.1.jar;E:\Repository\org\apache\kerby\kerb-admin\1.0.1\kerb-admin-1.0.1.jar;E:\Repository\org\apache\kerby\kerb-server\1.0.1\kerb-server-1.0.1.jar;E:\Repository\org\apache\kerby\kerb-identity\1.0.1\kerb-identity-1.0.1.jar;E:\Repository\org\apache\kerby\kerby-xdr\1.0.1\kerby-xdr-1.0.1.jar;E:\Repository\org\codehaus\woodstox\stax2-api\3.1.4\stax2-api-3.1.4.jar;E:\Repository\com\fasterxml\woodstox\woodstox-core\5.0.3\woodstox-core-5.0.3.jar;E:\Repository\dnsjava\dnsjava\2.1.7\dnsjava-2.1.7.jar;E:\Repository\org\apache\hadoop\hadoop-hdfs-client\3.2.0\hadoop-hdfs-client-3.2.0.jar;E:\Repository\com\squareup\okhttp\okhttp\2.7.5\okhttp-2.7.5.jar;E:\Repository\com\squareup\okio\okio\1.6.0\okio-1.6.0.jar;E:\Repository\org\apache\hadoop\hadoop-mapreduce-client-core\3.2.0\hadoop-mapreduce-client-core-3.2.0.jar;E:\Repository\org\apache\hadoop\hadoop-mapreduce-client-jobclient\3.2.0\hadoop-mapreduce-client-jobclient-3.2.0.jar;E:\Repository\org\apache\hadoop\hadoop-mapreduce-client-common\3.2.0\hadoop-mapreduce-client-common-3.2.0.jar;E:\Repository\org\apache\hadoop\hadoop-annotations\3.2.0\hadoop-annotations-3.2.0.jar;E:\Repository\org\apache\spark\spark-launcher_2.12\3.1.1\spark-launcher_2.12-3.1.1.jar;E:\Repository\org\apache\spark\spark-kvstore_2.12\3.1.1\spark-kvstore_2.12-3.1.1.jar;E:\Repository\org\fusesource\leveldbjni\leveldbjni-all\1.8\leveldbjni-all-1.8.jar;E:\Repository\com\fasterxml\jackson\core\jackson-core\2.10.0\jackson-core-2.10.0.jar;E:\Repository\com\fasterxml\jackson\core\jackson-annotations\2.10.0\jackson-annotations-2.10.0.jar;E:\Repository\org\apache\spark\spark-network-common_2.12\3.1.1\spark-network-common_2.12-3.1.1.jar;E:\Repository\org\apache\spark\spark-network-shuffle_2.12\3.1.1\spark-network-shuffle_2.12-3.1.1.jar;E:\Repository\org\apache\spark\spark-unsafe_2.12\3.1.1\spark-unsafe_2.12-3.1.1.jar;E:\Repository\javax\activation\activation\1.1.1\activation-1.1.1.jar;E:\Repository\org\apache\curator\curator-recipes\2.13.0\curator-recipes-2.13.0.jar;E:\Repository\org\apache\curator\curator-framework\2.13.0\curator-framework-2.13.0.jar;E:\Repository\org\apache\zookeeper\zookeeper\3.4.14\zookeeper-3.4.14.jar;E:\Repository\org\apache\yetus\audience-annotations\0.5.0\audience-annotations-0.5.0.jar;E:\Repository\jakarta\servlet\jakarta.servlet-api\4.0.3\jakarta.servlet-api-4.0.3.jar;E:\Repository\org\apache\commons\commons-lang3\3.10\commons-lang3-3.10.jar;E:\Repository\org\apache\commons\commons-math3\3.4.1\commons-math3-3.4.1.jar;E:\Repository\org\apache\commons\commons-text\1.6\commons-text-1.6.jar;E:\Repository\com\google\code\findbugs\jsr305\3.0.0\jsr305-3.0.0.jar;E:\Repository\org\slf4j\slf4j-api\1.7.30\slf4j-api-1.7.30.jar;E:\Repository\org\slf4j\jul-to-slf4j\1.7.30\jul-to-slf4j-1.7.30.jar;E:\Repository\org\slf4j\jcl-over-slf4j\1.7.30\jcl-over-slf4j-1.7.30.jar;E:\Repository\log4j\log4j\1.2.17\log4j-1.2.17.jar;E:\Repository\org\slf4j\slf4j-log4j12\1.7.30\slf4j-log4j12-1.7.30.jar;E:\Repository\com\ning\compress-lzf\1.0.3\compress-lzf-1.0.3.jar;E:\Repository\org\xerial\snappy\snappy-java\1.1.8.2\snappy-java-1.1.8.2.jar;E:\Repository\org\lz4\lz4-java\1.7.1\lz4-java-1.7.1.jar;E:\Repository\com\github\luben\zstd-jni\1.4.8-1\zstd-jni-1.4.8-1.jar;E:\Repository\org\roaringbitmap\RoaringBitmap\0.9.0\RoaringBitmap-0.9.0.jar;E:\Repository\org\roaringbitmap\shims\0.9.0\shims-0.9.0.jar;E:\Repository\commons-net\commons-net\3.1\commons-net-3.1.jar;E:\Repository\org\scala-lang\modules\scala-xml_2.12\1.2.0\scala-xml_2.12-1.2.0.jar;E:\Repository\org\scala-lang\scala-library\2.12.10\scala-library-2.12.10.jar;E:\Repository\org\scala-lang\scala-reflect\2.12.10\scala-reflect-2.12.10.jar;E:\Repository\org\json4s\json4s-jackson_2.12\3.7.0-M5\json4s-jackson_2.12-3.7.0-M5.jar;E:\Repository\org\json4s\json4s-core_2.12\3.7.0-M5\json4s-core_2.12-3.7.0-M5.jar;E:\Repository\org\json4s\json4s-ast_2.12\3.7.0-M5\json4s-ast_2.12-3.7.0-M5.jar;E:\Repository\org\json4s\json4s-scalap_2.12\3.7.0-M5\json4s-scalap_2.12-3.7.0-M5.jar;E:\Repository\org\glassfish\jersey\core\jersey-client\2.30\jersey-client-2.30.jar;E:\Repository\jakarta\ws\rs\jakarta.ws.rs-api\2.1.6\jakarta.ws.rs-api-2.1.6.jar;E:\Repository\org\glassfish\hk2\external\jakarta.inject\2.6.1\jakarta.inject-2.6.1.jar;E:\Repository\org\glassfish\jersey\core\jersey-common\2.30\jersey-common-2.30.jar;E:\Repository\jakarta\annotation\jakarta.annotation-api\1.3.5\jakarta.annotation-api-1.3.5.jar;E:\Repository\org\glassfish\hk2\osgi-resource-locator\1.0.3\osgi-resource-locator-1.0.3.jar;E:\Repository\org\glassfish\jersey\core\jersey-server\2.30\jersey-server-2.30.jar;E:\Repository\org\glassfish\jersey\media\jersey-media-jaxb\2.30\jersey-media-jaxb-2.30.jar;E:\Repository\jakarta\validation\jakarta.validation-api\2.0.2\jakarta.validation-api-2.0.2.jar;E:\Repository\org\glassfish\jersey\containers\jersey-container-servlet\2.30\jersey-container-servlet-2.30.jar;E:\Repository\org\glassfish\jersey\containers\jersey-container-servlet-core\2.30\jersey-container-servlet-core-2.30.jar;E:\Repository\org\glassfish\jersey\inject\jersey-hk2\2.30\jersey-hk2-2.30.jar;E:\Repository\org\glassfish\hk2\hk2-locator\2.6.1\hk2-locator-2.6.1.jar;E:\Repository\org\glassfish\hk2\external\aopalliance-repackaged\2.6.1\aopalliance-repackaged-2.6.1.jar;E:\Repository\org\glassfish\hk2\hk2-api\2.6.1\hk2-api-2.6.1.jar;E:\Repository\org\glassfish\hk2\hk2-utils\2.6.1\hk2-utils-2.6.1.jar;E:\Repository\org\javassist\javassist\3.25.0-GA\javassist-3.25.0-GA.jar;E:\Repository\io\netty\netty-all\4.1.51.Final\netty-all-4.1.51.Final.jar;E:\Repository\com\clearspring\analytics\stream\2.9.6\stream-2.9.6.jar;E:\Repository\io\dropwizard\metrics\metrics-core\4.1.1\metrics-core-4.1.1.jar;E:\Repository\io\dropwizard\metrics\metrics-jvm\4.1.1\metrics-jvm-4.1.1.jar;E:\Repository\io\dropwizard\metrics\metrics-json\4.1.1\metrics-json-4.1.1.jar;E:\Repository\io\dropwizard\metrics\metrics-graphite\4.1.1\metrics-graphite-4.1.1.jar;E:\Repository\io\dropwizard\metrics\metrics-jmx\4.1.1\metrics-jmx-4.1.1.jar;E:\Repository\com\fasterxml\jackson\core\jackson-databind\2.10.0\jackson-databind-2.10.0.jar;E:\Repository\com\fasterxml\jackson\module\jackson-module-scala_2.12\2.10.0\jackson-module-scala_2.12-2.10.0.jar;E:\Repository\com\fasterxml\jackson\module\jackson-module-paranamer\2.10.0\jackson-module-paranamer-2.10.0.jar;E:\Repository\org\apache\ivy\ivy\2.4.0\ivy-2.4.0.jar;E:\Repository\oro\oro\2.0.8\oro-2.0.8.jar;E:\Repository\net\razorvine\pyrolite\4.30\pyrolite-4.30.jar;E:\Repository\net\sf\py4j\py4j\0.10.9\py4j-0.10.9.jar;E:\Repository\org\apache\spark\spark-tags_2.12\3.1.1\spark-tags_2.12-3.1.1.jar;E:\Repository\org\apache\commons\commons-crypto\1.1.0\commons-crypto-1.1.0.jar;E:\Repository\org\spark-project\spark\unused\1.0.0\unused-1.0.0.jar;E:\Repository\org\apache\spark\spark-sql_2.12\3.1.1\spark-sql_2.12-3.1.1.jar;E:\Repository\com\univocity\univocity-parsers\2.9.1\univocity-parsers-2.9.1.jar;E:\Repository\org\apache\spark\spark-sketch_2.12\3.1.1\spark-sketch_2.12-3.1.1.jar;E:\Repository\org\apache\spark\spark-catalyst_2.12\3.1.1\spark-catalyst_2.12-3.1.1.jar;E:\Repository\org\scala-lang\modules\scala-parser-combinators_2.12\1.1.2\scala-parser-combinators_2.12-1.1.2.jar;E:\Repository\org\codehaus\janino\janino\3.0.16\janino-3.0.16.jar;E:\Repository\org\codehaus\janino\commons-compiler\3.0.16\commons-compiler-3.0.16.jar;E:\Repository\org\antlr\antlr4-runtime\4.8-1\antlr4-runtime-4.8-1.jar;E:\Repository\org\apache\arrow\arrow-vector\2.0.0\arrow-vector-2.0.0.jar;E:\Repository\org\apache\arrow\arrow-format\2.0.0\arrow-format-2.0.0.jar;E:\Repository\org\apache\arrow\arrow-memory-core\2.0.0\arrow-memory-core-2.0.0.jar;E:\Repository\com\google\flatbuffers\flatbuffers-java\1.9.0\flatbuffers-java-1.9.0.jar;E:\Repository\org\apache\arrow\arrow-memory-netty\2.0.0\arrow-memory-netty-2.0.0.jar;E:\Repository\org\apache\orc\orc-core\1.5.12\orc-core-1.5.12.jar;E:\Repository\org\apache\orc\orc-shims\1.5.12\orc-shims-1.5.12.jar;E:\Repository\com\google\protobuf\protobuf-java\2.5.0\protobuf-java-2.5.0.jar;E:\Repository\commons-lang\commons-lang\2.6\commons-lang-2.6.jar;E:\Repository\io\airlift\aircompressor\0.10\aircompressor-0.10.jar;E:\Repository\org\threeten\threeten-extra\1.5.0\threeten-extra-1.5.0.jar;E:\Repository\org\apache\orc\orc-mapreduce\1.5.12\orc-mapreduce-1.5.12.jar;E:\Repository\org\apache\hive\hive-storage-api\2.7.2\hive-storage-api-2.7.2.jar;E:\Repository\org\apache\parquet\parquet-column\1.10.1\parquet-column-1.10.1.jar;E:\Repository\org\apache\parquet\parquet-common\1.10.1\parquet-common-1.10.1.jar;E:\Repository\org\apache\parquet\parquet-encoding\1.10.1\parquet-encoding-1.10.1.jar;E:\Repository\org\apache\parquet\parquet-hadoop\1.10.1\parquet-hadoop-1.10.1.jar;E:\Repository\org\apache\parquet\parquet-format\2.4.0\parquet-format-2.4.0.jar;E:\Repository\org\apache\parquet\parquet-jackson\1.10.1\parquet-jackson-1.10.1.jar;E:\Repository\org\apache\spark\spark-yarn_2.12\3.1.1\spark-yarn_2.12-3.1.1.jar;E:\Repository\org\apache\hadoop\hadoop-yarn-api\3.2.0\hadoop-yarn-api-3.2.0.jar;E:\Repository\com\google\guava\guava\11.0.2\guava-11.0.2.jar;E:\Repository\javax\xml\bind\jaxb-api\2.2.11\jaxb-api-2.2.11.jar;E:\Repository\org\apache\hadoop\hadoop-yarn-common\3.2.0\hadoop-yarn-common-3.2.0.jar;E:\Repository\org\apache\hadoop\hadoop-auth\3.2.0\hadoop-auth-3.2.0.jar;E:\Repository\com\nimbusds\nimbus-jose-jwt\4.41.1\nimbus-jose-jwt-4.41.1.jar;E:\Repository\com\github\stephenc\jcip\jcip-annotations\1.0-1\jcip-annotations-1.0-1.jar;E:\Repository\net\minidev\json-smart\2.3\json-smart-2.3.jar;E:\Repository\net\minidev\accessors-smart\1.2\accessors-smart-1.2.jar;E:\Repository\org\eclipse\jetty\jetty-util\9.3.24.v20180605\jetty-util-9.3.24.v20180605.jar;E:\Repository\commons-cli\commons-cli\1.2\commons-cli-1.2.jar;E:\Repository\com\google\inject\extensions\guice-servlet\4.0\guice-servlet-4.0.jar;E:\Repository\commons-io\commons-io\2.5\commons-io-2.5.jar;E:\Repository\com\google\inject\guice\4.0\guice-4.0.jar;E:\Repository\javax\inject\javax.inject\1\javax.inject-1.jar;E:\Repository\aopalliance\aopalliance\1.0\aopalliance-1.0.jar;E:\Repository\com\fasterxml\jackson\module\jackson-module-jaxb-annotations\2.9.5\jackson-module-jaxb-annotations-2.9.5.jar;E:\Repository\com\fasterxml\jackson\jaxrs\jackson-jaxrs-json-provider\2.9.5\jackson-jaxrs-json-provider-2.9.5.jar;E:\Repository\com\fasterxml\jackson\jaxrs\jackson-jaxrs-base\2.9.5\jackson-jaxrs-base-2.9.5.jar;E:\Repository\org\apache\hadoop\hadoop-yarn-server-web-proxy\3.2.0\hadoop-yarn-server-web-proxy-3.2.0.jar;E:\Repository\org\apache\hadoop\hadoop-yarn-server-common\3.2.0\hadoop-yarn-server-common-3.2.0.jar;E:\Repository\org\apache\hadoop\hadoop-yarn-registry\3.2.0\hadoop-yarn-registry-3.2.0.jar;E:\Repository\commons-daemon\commons-daemon\1.0.13\commons-daemon-1.0.13.jar;E:\Repository\org\apache\geronimo\specs\geronimo-jcache_1.0_spec\1.0-alpha-1\geronimo-jcache_1.0_spec-1.0-alpha-1.jar;E:\Repository\org\ehcache\ehcache\3.3.1\ehcache-3.3.1.jar;E:\Repository\org\eclipse\jetty\jetty-server\9.3.24.v20180605\jetty-server-9.3.24.v20180605.jar;E:\Repository\org\eclipse\jetty\jetty-http\9.3.24.v20180605\jetty-http-9.3.24.v20180605.jar;E:\Repository\org\eclipse\jetty\jetty-io\9.3.24.v20180605\jetty-io-9.3.24.v20180605.jar;E:\Repository\org\apache\hadoop\hadoop-yarn-client\3.2.0\hadoop-yarn-client-3.2.0.jar com.zxl.spark.sql.lesson01_sql_basic
Using Spark's default log4j profile: org/apache/spark/log4j-defaults.properties
21/08/11 16:43:56 INFO SparkContext: Running Spark version 3.1.1
21/08/11 16:43:56 INFO ResourceUtils: ==============================================================
21/08/11 16:43:56 INFO ResourceUtils: No custom resources configured for spark.driver.
21/08/11 16:43:56 INFO ResourceUtils: ==============================================================
21/08/11 16:43:56 INFO SparkContext: Submitted application: testsql
21/08/11 16:43:56 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)
21/08/11 16:43:56 INFO ResourceProfile: Limiting resource is cpu
21/08/11 16:43:56 INFO ResourceProfileManager: Added ResourceProfile id: 0
21/08/11 16:43:57 INFO SecurityManager: Changing view acls to: 张学亮,ÕÅѧÁÁ
21/08/11 16:43:57 INFO SecurityManager: Changing modify acls to: 张学亮,ÕÅѧÁÁ
21/08/11 16:43:57 INFO SecurityManager: Changing view acls groups to:
21/08/11 16:43:57 INFO SecurityManager: Changing modify acls groups to:
21/08/11 16:43:57 INFO SecurityManager: SecurityManager: authentication disabled; ui acls disabled; users with view permissions: Set(张学亮, ÕÅѧÁÁ); groups with view permissions: Set(); users with modify permissions: Set(张学亮, ÕÅѧÁÁ); groups with modify permissions: Set()
21/08/11 16:43:58 INFO Utils: Successfully started service 'sparkDriver' on port 64180.
21/08/11 16:43:58 INFO SparkEnv: Registering MapOutputTracker
21/08/11 16:43:58 INFO SparkEnv: Registering BlockManagerMaster
21/08/11 16:43:58 INFO BlockManagerMasterEndpoint: Using org.apache.spark.storage.DefaultTopologyMapper for getting topology information
21/08/11 16:43:58 INFO BlockManagerMasterEndpoint: BlockManagerMasterEndpoint up
21/08/11 16:43:58 INFO SparkEnv: Registering BlockManagerMasterHeartbeat
21/08/11 16:43:58 INFO DiskBlockManager: Created local directory at C:\Users\zhang\AppData\Local\Temp\blockmgr-ee5ef4fa-cc86-49c2-b3f0-371b4c491776
21/08/11 16:43:58 INFO MemoryStore: MemoryStore started with capacity 1987.5 MiB
21/08/11 16:43:58 INFO SparkEnv: Registering OutputCommitCoordinator
21/08/11 16:43:58 INFO Utils: Successfully started service 'SparkUI' on port 4040.
21/08/11 16:43:58 INFO SparkUI: Bound SparkUI to 0.0.0.0, and started at http://ZXLT:4040
21/08/11 16:43:58 INFO Executor: Starting executor ID driver on host ZXLT
21/08/11 16:43:58 INFO Utils: Successfully started service 'org.apache.spark.network.netty.NettyBlockTransferService' on port 64203.
21/08/11 16:43:58 INFO NettyBlockTransferService: Server created on ZXLT:64203
21/08/11 16:43:58 INFO BlockManager: Using org.apache.spark.storage.RandomBlockReplicationPolicy for block replication policy
21/08/11 16:43:58 INFO BlockManagerMaster: Registering BlockManager BlockManagerId(driver, ZXLT, 64203, None)
21/08/11 16:43:58 INFO BlockManagerMasterEndpoint: Registering block manager ZXLT:64203 with 1987.5 MiB RAM, BlockManagerId(driver, ZXLT, 64203, None)
21/08/11 16:43:58 INFO BlockManagerMaster: Registered BlockManager BlockManagerId(driver, ZXLT, 64203, None)
21/08/11 16:43:58 INFO BlockManager: Initialized BlockManager: BlockManagerId(driver, ZXLT, 64203, None)
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
+---+---------+
|age| name|
+---+---------+
| 20|zhangsan0|
| 21|zhangsan1|
| 22|zhangsan2|
| 23|zhangsan3|
| 24|zhangsan4|
+---+---------+
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
root
|-- age: long (nullable = true)
|-- name: string (nullable = true)
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
+-------+----------------+--------------------+
| name| description| locationUri|
+-------+----------------+--------------------+
|default|default database|file:/E:/Workspac...|
+-------+----------------+--------------------+
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
+----+--------+-----------+---------+-----------+
|name|database|description|tableType|isTemporary|
+----+--------+-----------+---------+-----------+
+----+--------+-----------+---------+-----------+
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
+----------+--------+-----------+--------------------+-----------+
| name|database|description| className|isTemporary|
+----------+--------+-----------+--------------------+-----------+
| !| null| null|org.apache.spark....| true|
| %| null| null|org.apache.spark....| true|
| &| null| null|org.apache.spark....| true|
| *| null| null|org.apache.spark....| true|
| +| null| null|org.apache.spark....| true|
| -| null| null|org.apache.spark....| true|
| /| null| null|org.apache.spark....| true|
| <| null| null|org.apache.spark....| true|
| <=| null| null|org.apache.spark....| true|
| <=>| null| null|org.apache.spark....| true|
| =| null| null|org.apache.spark....| true|
| ==| null| null|org.apache.spark....| true|
| >| null| null|org.apache.spark....| true|
| >=| null| null|org.apache.spark....| true|
| ^| null| null|org.apache.spark....| true|
| abs| null| null|org.apache.spark....| true|
| acos| null| null|org.apache.spark....| true|
| acosh| null| null|org.apache.spark....| true|
|add_months| null| null|org.apache.spark....| true|
| aggregate| null| null|org.apache.spark....| true|
+----------+--------+-----------+--------------------+-----------+
only showing top 20 rows
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
+---+---------+
|age| name|
+---+---------+
| 20|zhangsan0|
| 21|zhangsan1|
| 22|zhangsan2|
| 23|zhangsan3|
| 24|zhangsan4|
+---+---------+
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
+----+--------+-----------+---------+-----------+
|name|database|description|tableType|isTemporary|
+----+--------+-----------+---------+-----------+
| abc| null| null|TEMPORARY| true|
+----+--------+-----------+---------+-----------+
input your sql:select name from abc
+---------+
| name|
+---------+
|zhangsan0|
|zhangsan1|
|zhangsan2|
|zhangsan3|
|zhangsan4|
+---------+
input your sql:select age from abc
+---+
|age|
+---+
| 20|
| 21|
| 22|
| 23|
| 24|
+---+
input your sql:select * from abc
+---+---------+
|age| name|
+---+---------+
| 20|zhangsan0|
| 21|zhangsan1|
| 22|zhangsan2|
| 23|zhangsan3|
| 24|zhangsan4|
+---+---------+
input your sql:
Process finished with exit code -1
相关文章
- org.apache.spark.sql.AnalysisException: Can not create the managed table
- sql编程
- PySpark SQL 基本操作
- hive Spark SQL分析窗口函数
- sql 链接符 ||
- 大叔经验分享（12）如何程序化kill提交到spark thrift上的sql
- 编写高性能SQL的注意事项
- Spark修炼之道（进阶篇）——Spark入门到精通：第九节 Spark SQL运行流程解析
- 使用Spark SQL构建交互式查询引擎
- 使用Spark SQL 构建流式处理程序
- Apache Spark源码走读（七）Standalone部署方式分析&sql的解析与执行
- SQL加解密注入详解
- Spark SQLTransformer SQL转换
- Atitit mybatis的扩展使用sql udf,js java等语言 目录 1.1. 默认，mybatis使用xml，sql等语言来书写业务流程1 2. 使用java扩展函数1 2.1.
- Spark高效数据分析03、Spark SQL
- SQL 185. 部门工资前三高的所有员工
- SQL Server 查找空值
- SQL SERVER 服务启动失败
- Spark SQL 初步
- 从一个SQL打印全年日历漫谈数据仓库中时间操作场景的重点写法
- 大数据框架对比：Hadoop、Storm、Samza、Spark和Flink——flink支持SQL，待看
- Spark实战(六)spark SQL + hive(Python版)