sparkSQL、sparkDSL练习

luckyhoney1224

已于 2022-11-28 21:04:09 修改

阅读量141

点赞数

文章标签： sql 大数据 spark

于 2022-11-28 20:49:27 首次发布

本文链接：https://blog.csdn.net/luckyhoney1224/article/details/128086810

版权

本文主要探讨了SparkSQL的使用技巧与Spark Domain Specific Language (DSL)的应用实践，通过实例解析了如何在大数据处理中高效地运用这两种工具进行数据查询和操作。

摘要由CSDN通过智能技术生成

一、公司代码,年度,1月-12月的收入金额
数据：
burk,year,tsl01,tsl02,tsl03,tsl04,tsl05,tsl06,tsl07,tsl08,tsl09,tsl10,tsl11,tsl12

853101,2010,100200,25002,19440,20550,14990,17227,40990,28778,19088,29889,10990,20990
853101,2011,19446,20556,14996,17233,40996,28784,19094,28779,19089,29890,10991,20991
853101,2012,19447,20557,14997,17234,20560,15000,17237,28780,19090,29891,10992,20992
853101,2013,20560,15000,17237,41000,17234,20560,15000,17237,41000,29892,10993,20993
853101,2014,19449,20559,14999,17236,41000,28788,28786,19096,29897,41000,28788,20994
853101,2015,100205,25007,19445,20555,17236,40999,28787,19097,29898,29894,10995,20995
853101,2016,100206,25008,19446,20556,17237,41000,28788,19098,29899,29895,10996,20996
853101,2017,100207,25009,17234,20560,15000,17237,41000,15000,17237,41000,28788,20997
853101,2018,100208,25010,41000,28788,28786,19096,29897,28786,19096,29897,10998,20998
853101,2019,100209,25011,17236,40999,28787,19097,29898,28787,19097,29898,10999,20999
846271,2010,100210,25012,17237,41