Chenjian Qiu created CARBONDATA-3289:
----------------------------------------
Summary: MV datamap doesn't take effect when having clause use alias
Key: CARBONDATA-3289
URL:
https://issues.apache.org/jira/browse/CARBONDATA-3289 Project: CarbonData
Issue Type: Bug
Reporter: Chenjian Qiu
create table test_main(id int,name string,height int) using carbondata
create datamap test_main_mv using 'mv' as select cast(id + 1 as bigint) as cast_id ,count(name) from test_main group by cast_id
select cast(id + 1 as bigint) as cast_id,count(name) from test_main group by cast_id having cast_id < 3
select cast(id + 1 as bigint) as cast_id,count(name) from test_main where cast(id + 1 as bigint) < 3 group by cast_id
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)