Liang Chen created CARBONDATA-639:
------------------------------------- Summary: "Delete data" feature doesn't work Key: CARBONDATA-639 URL: https://issues.apache.org/jira/browse/CARBONDATA-639 Project: CarbonData Issue Type: Bug Components: core Affects Versions: 1.0.0-incubating Reporter: Liang Chen Fix For: 1.0.0-incubating Reproduce steps: 1.Finish load data , query as below : cc.sql("select * from connectdemo1 where age > 40").show() : +------+------+--------+-------+---+ | name|gender|province|singler|age| +------+------+--------+-------+---+ |Abbott|Female| AB| false| 54| |Abbott|Female| AB| false| 51| |Abbott|Female| AB| false| 65| |Abbott|Female| AB| false| 47| |Abbott|Female| AB| false| 56| |Abbott|Female| AB| false| 54| |Abbott|Female| AB| false| 61| |Abbott|Female| AB| false| 58| |Abbott|Female| AB| false| 62| |Abbott|Female| AB| false| 47| |Abbott|Female| AB| false| 49| |Abbott|Female| AB| false| 53| |Abbott|Female| AB| false| 63| |Abbott|Female| AB| false| 48| |Abbott|Female| AB| false| 52| |Abbott|Female| AB| false| 52| |Abbott|Female| AB| false| 62| |Abbott|Female| AB| false| 61| |Abbott|Female| AB| false| 63| |Abbott|Female| AB| false| 49| +------+------+--------+-------+---+ cc.sql("select count(*) from connectdemo1").show() +-------+ | _c0| +-------+ |9000000| +-------+ 2.cc.sql("delete from connectdemo1 where age > 60").show 3.query again with cc.sql("select * from connectdemo1 where age > 40").show() and cc.sql("select count(*) from connectdemo1").show() : same result with before deletion , so the delete operation is failed. +------+------+--------+-------+---+ | name|gender|province|singler|age| +------+------+--------+-------+---+ |Abbott|Female| AB| false| 54| |Abbott|Female| AB| false| 51| |Abbott|Female| AB| false| 65| |Abbott|Female| AB| false| 47| |Abbott|Female| AB| false| 56| |Abbott|Female| AB| false| 54| |Abbott|Female| AB| false| 61| |Abbott|Female| AB| false| 58| |Abbott|Female| AB| false| 62| |Abbott|Female| AB| false| 47| |Abbott|Female| AB| false| 49| |Abbott|Female| AB| false| 53| |Abbott|Female| AB| false| 63| |Abbott|Female| AB| false| 48| |Abbott|Female| AB| false| 52| |Abbott|Female| AB| false| 52| |Abbott|Female| AB| false| 62| |Abbott|Female| AB| false| 61| |Abbott|Female| AB| false| 63| |Abbott|Female| AB| false| 49| +------+------+--------+-------+---+ +-------+ | _c0| +-------+ |9000000| +-------+ -- This message was sent by Atlassian JIRA (v6.3.4#6332) |
Free forum by Nabble | Edit this page |