Hi kingofthecity,
>
> But when I change the result-mode from TABLE to CHANGELOG,
> there are 4 rows for each update like:
>
The results are expected when the result-mode is `CHANGELOG`.
> SELECT sector, avg(`value`) as `index` FROM stock INNER JOIN metadata ON
> stock.id=metadata.id GROUP BY sect
Hi,
I'm working on a simple sql that contains aggregation.
The results looks fine in the `SQL Query Result (Table)`
but looks weird when I change the result-mode to CHANGELOG.
```
CREATE TABLE stock (
id VARCHAR(10) NOT NULL PRIMARY KEY,
`value` DOUBLE NOT NULL
) WITH (
'connector' = 'pravega',
