https://community.databricks.com/t5/data-engineering/dlt-aggregation-problem/m-p/71958#M34448 <P>Hello&nbsp;<a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/63883">@Yash_542965</a>&nbsp;, I hope this message finds you well.</P> <P>Could you please share a sample of code you are using so that we can check it further?</P> <P>Best regards,<BR />Lucas Rocha</P> Thu, 06 Jun 2024 22:02:05 GMT lucasrocha 2024-06-06T22:02:05Z https://community.databricks.com/t5/data-engineering/dlt-aggregation-problem/m-p/3961#M828 <P>I'm utilizing SQL to perform aggregation operations within a gold layer of a DLT pipeline. However, I'm encountering an error when running the pipeline while attempting to return a data frame using spark.sql.</P><P></P><P>Could anyone please assist me with the SQL syntax required to apply a watermark within the SQL query? It would be greatly appreciated if someone could provide an example of the syntax for applying a watermark in SQL.</P><P></P><P>ERROR: "<B>org.apache.spark.sql.AnalysisException: Append output mode not supported when there are streaming aggregations on streaming DataFrames/DataSets without watermark;</B>"</P> Fri, 26 May 2023 10:04:56 GMT https://community.databricks.com/t5/data-engineering/dlt-aggregation-problem/m-p/3961#M828 Yash_542965 2023-05-26T10:04:56Z https://community.databricks.com/t5/data-engineering/dlt-aggregation-problem/m-p/71958#M34448 <P>Hello&nbsp;<a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/63883">@Yash_542965</a>&nbsp;, I hope this message finds you well.</P> <P>Could you please share a sample of code you are using so that we can check it further?</P> <P>Best regards,<BR />Lucas Rocha</P> Thu, 06 Jun 2024 22:02:05 GMT https://community.databricks.com/t5/data-engineering/dlt-aggregation-problem/m-p/71958#M34448 lucasrocha 2024-06-06T22:02:05Z