[jira] [Created] (CARBONDATA-3842) Select with limit displays incorrect resultset after datamap creation

[Akash R Nilugal (Jira)]

Chetan Bhat created CARBONDATA-3842:
---------------------------------------

             Summary: Select with limit displays incorrect resultset after datamap creation
                 Key: CARBONDATA-3842
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-3842
             Project: CarbonData
          Issue Type: Bug
          Components: data-query
    Affects Versions: 2.0.1
         Environment: Spark 2.3.2
            Reporter: Chetan Bhat


*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)*

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)