Deletes rows that satisfy the
WHEREclause from the specified table. If the WHERE clause is absent, all rows in the table are deleted, resulting in a valid but empty table.
DELETE FROM table_name [ * ] [ [ AS ] alias ]
[ WHERE condition ]
In Release 6.4 and higher, you can run DELETE queries across tables in different databases on the same HEAVY.AI cluster without having to first connect to those databases.
To execute queries against another database, you must have ACCESS privilege on that database, as well as DELETE privilege.
Delete rows from a table in the
DELETE FROM my_other_db.customers WHERE id > 100;