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

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

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

Akash R Nilugal (Jira)
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)