You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "Kunal Kapoor (JIRA)" <ji...@apache.org> on 2018/11/27 08:39:00 UTC
[jira] [Created] (CARBONDATA-3134) Wrong result when a column is
dropped and added using alter with blocklet cache.
Kunal Kapoor created CARBONDATA-3134:
----------------------------------------
Summary: 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
*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)