Aliases may cause aggregation models to become ineffective.

[smokeriu]

I create a aggregate model:

CREATE TABLE `ads_addr_domain` (
  `addr` varchar(16) NULL,
  `domain` varchar(128) NULL,
  `total` bigint SUM
) ENGINE=OLAP
AGGREGATE KEY(`addr`, `domain`)

And Insert:

INSERT INTO ads_addr_domain VALUES ('1.1.1.1', 'google.com', 1), ('1.1.1.1', 'google.com', 2)

When I query without alias. The result is ok:

SELECT addr, domain, total FROM ads_addr_domain LIMIT 10;

addr	doamin	total
1.1.1.1	google.com	3

However, I found that the results of using DataGrip were abnormal, as they contained detailed data:

addr	doamin	total
1.1.1.1	google.com	1
1.1.1.1	google.com	2

After observing, I found that DataGrip adds an alias to the table name, just like t in the statement below:

SELECT t.addr, t.domain, t.total FROM ads_addr_domain t LIMIT 10;

My Version: 2.1.6 is not the latest.

Has this issue been reported before and fixed in the new version?

[ixzc]

you can use the latest version, it's fixed