Databricks DB Group by Manual Aggregation Error
I’m using Knime v5.1.2 with the latest DatabricksJDBC42-2.6.36.1062 driver. I’m finding that the DB Group by node is throwing an error when trying to use any of the aggregation functions on the Manual Aggregation tab. Possible bug with interacting with Databricks? Work as expected with other DBs. Does not appear to generate the correct SQL when using Databricks looking at the console log.
Creates SELECT FROM (SELECT COUNT() AS COUNT() FROM (SELECT FROM catalog.schema.table)
Count function works as expected when generated via manual SQL.
SELECT count(*) as count_rows FROM catalog.schema.table
Anyone else finding this error?