housepower / ClickHouse-Native-JDBC

ClickHouse Native Protocol JDBC implementation
https://housepower.github.io/ClickHouse-Native-JDBC/
Apache License 2.0
527 stars 145 forks source link

Deleting / Updating rows from click house table using python or pyspark #441

Closed shravan741 closed 1 year ago

shravan741 commented 1 year ago

Do we have a way to delete or update click house table rows using pyspark or python

pan3793 commented 1 year ago

Mind trying https://github.com/housepower/spark-clickhouse-connector?

There is a demo in quick start on how to delete data from clickhouse using Spark SQL/Spark Shell.

https://housepower.github.io/spark-clickhouse-connector/quick_start/02_play_with_spark_sql/