本文通过实例介绍了如何使用SparkSQL进行多表关联查询，包括创建JSON格式的数据表，以及在Spark客户端执行SQL查询，展示了从course、student和student_course表中获取关联数据的过程。
1.准备数据以json格式为例
student表
{"sid":"S001","sanme":"zhangsan","age":"12","gender":"female"}
{"sid":"S002","sanme":"lisi","age":"13","gender":"male"}
{"sid":"S003","sanme":"wangwu","age":"14","gender":"male"}{"sid":"S004","sanme":"zhaoliu","age":"15","gender":"female"}
course表
{"cid":"C001","cname":"football"}
{"cid":"C002","cname":"music"}
{"cid":"C003","cname":"art"}
student_course表
{"id":"1","sid":"S001","cid":"C001"}
{"id":"2","sid":"S002","cid":"C001"}<
最低0.47元/天 解锁文章
1021
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
