Is there any way to get around this error?
SQL is as follows:
SELECT COUNT (*) total, tc ol1, tc ol2, tc ol3, tc ol4
CASE WHEN col3='ABC' THEN (SELECT MAX (col2) FROM xxx_log f the WHERE col4='xxx11' AND col1=tc ol1
AND col2=tc ol2) ELSE tc ol2 END newCol2
The FROM xxx_log t


Error message:
Xception thread in "main" org. Apache. Spark. SQL. AnalysisException: Multiple streaming aggregations are not supported with streaming DataFrames/Datasets;;