假如有如下建表语句
CREATE TABLE xxx
(
a int,
b varchar,
c varchar,
d int
)
DISTRIBUTED BY HASH(a,b,c)
那么如下语句是否会执行更快些,对a、b和c顺序是否有要求?
select x from xxx group by a,b,c
select x from xxx group by a,b
select x from xxx group by a,c
假如有如下建表语句
CREATE TABLE xxx
(
a int,
b varchar,
c varchar,
d int
)
DISTRIBUTED BY HASH(a,b,c)
那么如下语句是否会执行更快些,对a、b和c顺序是否有要求?
select x from xxx group by a,b,c
select x from xxx group by a,b
select x from xxx group by a,c