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)
