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