[
https://issues.apache.org/jira/browse/CARBONDATA-2819?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16582007#comment-16582007 ]
Ravindra Pesala commented on CARBONDATA-2819:
---------------------------------------------
Yes, Jacky is right. There must some problem in drop datamap logic, so fixing that can solve that issue. In future, we might deprecate pre-aggregate datamap and use mv datamap for the aggregate tables. MV datamaps are always stored in _system folders, unlike pre-aggregate datamap.
> cannot drop preagg datamap on table if the table has other index datamaps
> -------------------------------------------------------------------------
>
> Key: CARBONDATA-2819
> URL:
https://issues.apache.org/jira/browse/CARBONDATA-2819> Project: CarbonData
> Issue Type: Improvement
> Affects Versions: 1.4.1
> Reporter: lianganping
> Priority: Major
> Time Spent: 7h 10m
> Remaining Estimate: 0h
>
> 1.create table student_test(id int,name string,class_number int,male int,female int) stored by 'carbondata';
> 2.create datamap dm1_preaggr_student_test ON TABLE student_test USING 'preaggregate' as select class_number,sum(male) from student_test group by class_number
> 3.create datamap dm_lucene_student_test on table student_test using 'lucene' dmproperties('index_columns' = 'name');
> 4.drop datamap dm1_preaggr_student_test on table student_test;
> and will get this error:
> Error: org.apache.carbondata.common.exceptions.sql.NoSuchDataMapException: Datamap with name dm1_preaggr_student_test does not exist (state=,code=0)
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
Locked
