[CARBONDATA-3842] Select with limit displays incorrect resultset after datamap creation

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 2.0.1
• Fix Version/s: 2.1.0
• Component/s: data-query
• Environment: Spark 2.3.2
• Assignee: Unassigned
• Reporter: Chetan Bhat
• Created: 02/Jun/20 15:50
• Updated: 09/Jul/20 08:14
• Resolved: 09/Jul/20 08:14

Description

Steps :-

create table tab1(id int, name string, dept string) STORED as carbondata;
create materialized view datamap31 as select a.id, a.name from tab1 a;
insert into tab1 select 1,'ram','cs';
insert into tab1 select 2,'shyam','it';
select a.id, a.name from tab1 a order by a.id limit 1;

Issue :  

Select with limit displays incorrect resultset (2 records instead of 1) after datamap creation.

0: jdbc:hive2://10.20.251.163:23040/default> select a.id, a.name from tab1 a order by a.id limit 1;
INFO : Execution ID: 558
-----------

id

name

-----------

2	shyam
1	ram

-----------
2 rows selected (0.601 seconds)