Sanoj MG created CARBONDATA-837: ----------------------------------- Summary: Unable to delete records from carbondata table Key: CARBONDATA-837 URL: https://issues.apache.org/jira/browse/CARBONDATA-837 Project: CarbonData Issue Type: Bug Components: spark-integration Affects Versions: 1.1.0-incubating Environment: HDP 2.5, Spark 1.6.2 Reporter: Sanoj MG Priority: Minor Fix For: NONE
As per below document I am trying to delete entries from the table : https://github.com/apache/incubator-carbondata/blob/master/docs/dml-operation-on-carbondata.md scala> cc.sql("select * from accountentity").count res10: Long = 391351 scala> cc.sql("delete from accountentity") INFO 30-03 09:03:03,099 - main Query [DELETE FROM ACCOUNTENTITY] INFO 30-03 09:03:03,104 - Parsing command: select tupleId from accountentity INFO 30-03 09:03:03,104 - Parse Completed INFO 30-03 09:03:03,105 - Parsing command: select tupleId from accountentity INFO 30-03 09:03:03,105 - Parse Completed res11: org.apache.spark.sql.DataFrame = [] scala> cc.sql("select * from accountentity").count res12: Long = 391351 The records gets deleted only when an action such as show() is applied. scala> cc.sql("delete from accountentity").show -- This message was sent by Atlassian JIRA (v6.3.15#6346)