
SQL
dlphay
e-mail:740595707@qq.com
展开
-
SQL-DQL
我们在MySQL和Spark-SQL使用过程中,常用的DQL如下。// 查询SELECT xx FROM table;SELECT * FROM table;SELECT DISTINCT xx FROM table;// + - * / 运算SELECT xx*1.5 FROM table;SELECT xx+xx FROM table;// 条件查询SELECT xx...原创 2019-08-09 16:11:13 · 317 阅读 · 0 评论 -
Spark-SQL-Python编程
使用Pycharm来实现Spark-SQL。from pyspark import Rowfrom pyspark.sql import SparkSessionfrom pyspark.sql.types import StructField, StringType, StructTypeif __name__ == "__main__": spark = SparkSes...原创 2019-08-11 16:25:28 · 1087 阅读 · 0 评论