Hi folks, it’s me again 😄 What’s the command for deleting rows from Pinot tables?

DELETE from tableName where predicate1

gives me a:

org.apache.pinot.sql.parsers.SqlCompilationException: Caught exception while parsing query: DELETE FROM from baseballStats where baseOnBalls=0

Delete is not supported through query. You can only delete entire segments using the either the Delete all segments API

DELETE: /segments​/{tableName}

or Delete a segment API

DELETE: /segments/{tableName}/{segmentName}

Let me know if this is helpful.

This was helpful. It forgot that a segment is immutable.