FAQ-spark开窗函数和distinct

    问题描述/异常栈:

    spark执行SQL报错:Error in query: Distinct window functions are not supported:

    FAQ-spark开窗函数和distinct - 图1

    问题原因:

    spark不支持Distinct

    可实现类似功能的函数:

    collect_set

    可以参考原文档使用方法:https://spark.apache.org/docs/latest/api/sql/#collect_set