You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "Chenjian Qiu (JIRA)" <ji...@apache.org> on 2019/02/08 14:40:00 UTC

[jira] [Created] (CARBONDATA-3289) MV datamap doesn't take effect when having clause use alias

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)