search

scylladb / java-driver

ScyllaDB Java Driver for ScyllaDB and Apache Cassandra, based on the DataStax Java Driver
Apache License 2.0
62 stars 37 forks source link

4.x: Why Scylladb, doesn't support query and deletion of empty fields? #361

Closed VolleyballBIA closed 3 days ago

VolleyballBIA commented 3 days ago

I would like to report an issue on page https://java-driver.docs.scylladb.com/scylla-4.15.0.x/manual/query_builder/condition/index

Problem

4.x: Why Scylladb, doesn't support query and deletion of empty fields? When I find abnormal data in my production environment, such as a non-indexed field that is empty, this creates a series of problems, then if I want to delete it, I have to do a full table scan to do so. I think this greatly affects the service performance. Is there a good way to remove these empty data rows easily?

I have tried to remove them using Querybuilder and Cql and both failed.

Suggest a fix

mykaul commented 3 days ago

Questions are better asked on our forum - https://forum.scylladb.com/