CREATE TABLE test1
( id VARCHAR(20),
c1 int
)
ENGINE=OLAP
DUPLICATE KEY( id )
COMMENT "OLAP"
DISTRIBUTED BY HASH( id ) BUCKETS auto
PROPERTIES (
"replication_num" = "1"
);
insert into test1 values ('a',1);
SELECT c1 FROM test1 GROUP BY c1 HAVING EXISTS(SELECT 1)
INTERSECT
SELECT c1 FROM test1;