Posted by
Akash R Nilugal (Jira) on
Jan 15, 2017; 5:42am
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/jira-Created-CARBONDATA-639-Delete-data-feature-doesn-t-work-tp6209.html
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)