Stack Overflow
Stack Overflow

Questions tagged [bulk-delete]

41 questions
15
votes
1 answer

How to bulk delete records using temporary tables in Hibernate?

I have a question. Where did these methods go? Dialect.supportsTemporaryTables(); Dialect.generateTemporaryTableName(); Dialect.dropTemporaryTableAfterUse(); Dialect.getDropTemporaryTableString(); I've tried to browse git history for Dialect.java,…
viliam
  • 503
  • 6
  • 23
10
votes
4 answers

What is the best way to bulk delete rows in JPA while also cascading the delete to child records

I'm trying to do bulk delete in my entities, and the best solution will be to go with CriteriaDelete. But CriteriaDelete does not cascade (at least not for me). So, it seems like the only solution which I have is to do select first and delete each…
user902383
  • 8,420
  • 8
  • 43
  • 63
6
votes
3 answers

C# Efficiently delete 50000 records in batches using SQLBulkCopy or equivalent library

I'm using this library to perform bulk delete in batches like following: while (castedEndedItems.Any()) { var subList = castedEndedItems.Take(4000).ToList(); DBRetry.Do(() => EFBatchOperation.For(ctx, ctx.SearchedUserItems).Where(r =>…
User987
  • 3,663
  • 15
  • 54
  • 115
4
votes
1 answer

Bulk Delete an attribute from a document in ElasticSearch 6+

I need to delete a particular attribute from all documents in ElasticSearch. Is there a way to do it and can it be done via Bulk API. I am unable to find an API to Bulk Delete an attribute from ElasticSearch. Is there any way to achieve the…
jatin mahajan
  • 81
  • 2
  • 7
4
votes
1 answer

Pymongo Bulk Delete

I need to use pymongo to do bulk delete for mongodb. I'm getting the _id field of the documents that I need deleted with a query but I'm not able to figure out how to use the _id's I get to be deleted in chunks of 10,000.
JUAmaned
  • 49
  • 1
  • 5
3
votes
2 answers

ResourceController - BulkDelete

Recently I watched "Cruddy by Design" - Laracon US 2017 and now I'm trying to get rid of any extra methods in my controllers (so I only have index, create, store, show, edit, update and destroy) Adam Wathan talks about creating new controllers to…
Professor
  • 858
  • 1
  • 9
  • 17
1
vote
0 answers

Bulk Deleting Records in SQLAlchemy Using List of Dictionaries

Is there a way to pass something like a list of dictionaries and delete records in bulk using SQLAlchemy? It is possible to use bulk_insert_mappings for inserts and bulk_update_mappings for updates, but what about deletes? Basically, I have a table…
Minura Punchihewa
  • 1,498
  • 1
  • 12
  • 35
1
vote
0 answers

Django bulk delete removes only hundred rows at a time

I have two models with one to many relation between them: class HomeCarrier(models.Model) short_name = models.CharField(max_length=32, unique=True) class CarrierZipCoverage(models.Model): zip_code = models.CharField(max_length=5) …
Danil
  • 4,781
  • 1
  • 35
  • 50
1
vote
1 answer

bulk_delete in mongodb using mongoid ruby

I have 10 million documents in a mongo collection as of current_date and want to destroy 6 million documents which are older than yesterday. Is there any bulk_delete option in mongoid ? I know I can bulk_insert as…
abhishek
  • 301
  • 2
  • 7
  • 18
1
vote
1 answer

Spark program to bulkdelete hbase rows throws AbstractMethodError

Following is my code block in spark application to delete set of rowkeys (rePartitionedRowKeys) from hbase table, hbaseContext.bulkDelete[Array[Byte]](rePartitionedRowKeys, TableName.valueOf(hbaseTableName), putRecord => new…
Sunil
  • 83
  • 5
1
vote
1 answer

A stored procedure required to bulk delete tables that are more than 1 hour old

I have created the following MySQL (v5.7.14) stored procedure. It successfully DROPS all the tables in my database that are prefixed 'members_list_'. However, I would only like to DROP the tables that are prefixed 'members_list_' AND are older than…
Alan N
  • 181
  • 2
  • 8
0
votes
0 answers

AWS Quicksight - How delete users AWS quicksight users in bulk?

Unless I am missing something, I do not see a way to remove users in bulk from AWS Quicksight Console and AWS Quicksight CLI. I have written the below python script to parse usernames in quicksightuser.json (output of AWS CLI list-user command) into…
rakatar
  • 1
  • 1
0
votes
0 answers

Bulk Deletion of Referenced Documents

I have a question. Does this : https://www.sanity.io/guides/bulk-deletion-using-sanity-cli work for documents that are referenced in other parts or only for "orphan" documents? Thank you so much, Andreea
AndreeaPaun
  • 1
0
votes
0 answers

Why I can't able to create outer join in bulk delete job? even for views which is not listing on bulk delete

I tried to create a view in powerapps table to perform bulk delete action on it. The view that defines outer join like, I want to get the table Order values which should not be present in the Invoice table, but it should have a relation with the…
Charles Michel
  • 29
  • 6
0
votes
0 answers

Only One failure msg is displaying for bulk record deletion in dynamics 365 why?

Hi Folks, I have executed bulk record deletion in dynamics 365 and due to behavioral action of those table relationship those records not deleted and shown failure message. my question is there i can see only one msg for one record deletion…
Charles Michel
  • 29
  • 6
1
2 3