search

depyronick / clickhouse-client

ClickHouse Client for NodeJS
https://clickhouse.js.org
MIT License
50 stars 11 forks source link

DELETE statement is not supported. #34

Open YarRainbow opened 10 months ago

YarRainbow commented 10 months ago

There must be something I don't understand. But the only way to delete something from the database through this client is to use query method. In this case ClickHouseClient.query necessarily adds FORMAT statement, which is not compatible with DELETE statement and causes a syntax error.

Is this the way it is intended? What is the reason?

PS So far I had to patch the package. I could think about PR for this issues, but I'm not sure I understand the area enough.

YarRainbow commented 10 months ago

I have been practically realized that deleting from the Clickhouse database in my case is a very bad idea :) Meanwhile, I don't rule out that there may be scenarios where deletion is required, so I'm not sure it's worth closing an issue without waiting for a comment.