Spark Structured Streaming (SSS) Project -- 2

Use SSS to solve this project. The requirements are as follows:
a. Input source: Fafka or any other related software
b. Operations:
i. Aggregation with grouping
ii. Aggregation with pivoting
iii. Aggregation with rollups and cubes
iv. Ranking functions
v. Analytic functions
c. Output sink: Kafka or any other related software