Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Resolved
-
None
-
None
Description
Reproduce steps:
CREATE TABLE reason (
r_reason_sk integer NOT NULL,
r_reason_id character(16) NOT NULL,
r_reason_desc character(100)
)
WITH (appendonly=true, orientation=row, compresstype=quicklz, compresslevel=1) DISTRIBUTED BY (r_reason_sk);
explain select substr(r_reason_desc,1,20) from reason group by r_reason_desc order by substr(r_reason_desc,1,20);