[jira] [Resolved] (CARBONDATA-3134) Wrong result when a column is dropped and added using alter with blocklet cache.

[Akash R Nilugal (Jira)]

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

Manish Gupta resolved CARBONDATA-3134.
--------------------------------------
       Resolution: Fixed
    Fix Version/s: 1.5.1

> Wrong result when a column is dropped and added using alter with blocklet cache.
> --------------------------------------------------------------------------------
>
>                 Key: CARBONDATA-3134
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-3134
>             Project: CarbonData
>          Issue Type: Bug
>            Reporter: Kunal Kapoor
>            Assignee: Kunal Kapoor
>            Priority: Major
>             Fix For: 1.5.1
>
>          Time Spent: 5h 10m
>  Remaining Estimate: 0h
>
> *Steps to reproduce:*
> spark.sql("drop table if exists tile")
> spark.sql("create table tile(b int, s int,bi bigint, t timestamp) partitioned by (i int) stored by 'carbondata' TBLPROPERTIES ('DICTIONARY_EXCLUDE'='b,s,i,bi,t','SORT_COLUMS'='b,s,i,bi,t', 'cache_level'='blocklet')")
> spark.sql("load data inpath 'C:/Users/k00475610/Documents/en_all.csv' into table tile options('fileheader'='b,s,i,bi,t','DELIMITER'=',')")
> spark.sql("select * from tile")
>  spark.sql("alter table tile drop columns(t)")
>  spark.sql("alter table tile add columns(t timestamp)")
>  spark.sql("load data inpath 'C:/Users/k00475610/Documents/en_all.csv' into table tile options('fileheader'='b,s,i,bi,t','DELIMITER'=',')")
> spark.sql("select * from tile").show()
>  
> *Result:*
> *+---+-----+-----------+----+--------+*
> *| b| s| bi| t| i|*
> +---+-----+-----------+----+--------+
> |100|20000|93405673097|null|16455554|
> |100|20000|93405673097|null|16455554|
> +---+-----+-----------+----+--------+

--
This message was sent by Atlassian JIRA
(v7.6.3#76005)