BigQuery - Delete rows with a limit

Asked Jun 20 '19 at 07:59

Active Jun 20 '19 at 07:59

Viewed 750 times

I want to remove duplicate rows from BigQuery. The duplicate rows have the same data in all the columns. I know how to find the duplicates but I can't find a way to delete all rows but one. What I want to do is basically

DELETE FROM Table WHERE id = <id> LIMIT 1

But that doesn't work. I am not interested in rewriting the entire table

Is it possible to achieve this?

asked Jun 20 '19 at 07:59

AndersD

1

Use TOP function to get the first one then `DELETE TOP(1) FROM dataset.duplicateTest WHERE ID = 1 ` – Hasta Tamang Jun 20 '19 at 08:16
Already answered here --> https://stackoverflow.com/questions/36675521/delete-duplicate-rows-from-a-bigquery-table – Christopher Jun 20 '19 at 08:21
Thanks, but from my understanding there are only solutions there that includes rewriting entire table. – AndersD Jun 20 '19 at 08:29
TOP did not work for me – AndersD Jun 20 '19 at 08:30

BigQuery - Delete rows with a limit

0 Answers0