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

[Akash R Nilugal (Jira)]

     [ https://issues.apache.org/jira/browse/CARBONDATA-3842?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Akash R Nilugal resolved CARBONDATA-3842.
-----------------------------------------
    Fix Version/s: 2.1.0
       Resolution: Fixed

> 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
>            Priority: Minor
>             Fix For: 2.1.0
>
>          Time Spent: 3h 20m
>  Remaining Estimate: 0h
>
> *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)