Python API to delete selected rows in omnisci table

Hi,

I am connecting to omnisci table using python. Is there any API to remove certain rows based on condition on any column?

Thanks,
Leelakrishna.

Hi @leelakrishna_gairubo,

Thanks for joining our community.

If you are using the heavyai python sqllibrary you have to specify the condition into the sql used to query the table or if you want delete rows from table you should use a sql delete statement.

If you need something similar to pandas you can try to use IBIS library, but I’m not sure if you can delete row from a table, but it should build the sql statements for aggregates, filtering and stuff like that.

Let me know if this replies to you question, because I’m not sure if I interpreted you question

Regards,
Candido

Hi @candido.dessanti ,

I am glad to be part of the community. Thank you for the response and it is helpful.

Regards,
Leelakrishna.