Support Questions
Find answers, ask questions, and share your expertise

phoenix delete command deleting more record s from table then it holds

New Contributor

Hi All,

 

we are using phoenix 5 with habse2.0.2 in HDP3.1.5.

 

we have noticed a scenario when we are issuing a delete command for the table it deleted more records than it holds.

 

example:

phoenix sqline

select count(*) from table_name;

391056

 

delete from table_name;

1367799

 

Can anybody please advise on this?

1 REPLY 1

Super Collaborator

Hello @vishal6196 

 

Thanks for using Cloudera Community. Based on the Post, the Phoenix Delete Command is reporting more records being deleted than the Select Count(*) returns. Thank You for sharing the HDP & Phoenix Version as well. 

 

Few Queries for your Team:

  • Whether the Observation is made for all Tables or Selective Table(s),
  • Explain Output of the Select & Delete SQL,
  • Any Index of the Phoenix Table being deleted,
  • If Performing MajorCompaction on the Table before Deleting (Just for Sanity Check) shows any Difference with respect to the Rows Deleted via Delete SQL. 

 

Regards, Smarak