Stack Overflow
Stack Overflow

Questions tagged [batch-query]

9 questions
3
votes
3 answers

insert on duplicate key update batch with separate update columns

I have a situation where I have a table (col1 (pk), col2, col3, col4) and a set of records which I need to insert into a table and on duplicate key update them. I would like to do a batch query to speed things up. However, col4 doesn't have a NOT…
curiousgeorge
  • 593
  • 1
  • 5
  • 14
2
votes
0 answers

Sequential batch queries in Cassandra

I have two queries which I wish to execute as a batch to maintain atomicity. The first query is a delete query and the second query is an insert query, both operating on the same table. While it is important for me to ensure atomicity, it is also…
scottstots
  • 155
  • 2
  • 17
2
votes
1 answer

Ordered batches clear solution

Given the following code in ruby/rails, block code is omitted. Model.order(id: :desc).find_in_batches { |group| ... } If you run this, you will get a warning. Scoped order and limit are ignored, it's forced to be batch order and batch size Of…
zhisme
  • 2,368
  • 2
  • 19
  • 28
2
votes
1 answer

What replaces deprecated batch scene queries in nvidia physx 3.4?

Apparently, "The batched query feature has been deprecated in PhysX version 3.4". Does anyone know what replaces batch queries going forward?
GlassBeaver
  • 196
  • 4
  • 15
1
vote
2 answers

How to get SAP CloudSdk BatchRequest not to ignore filter parameter on Batch Query?

We are currently struggeling with Batch Query, which seems to ignore the filter expressions on S4 side caused by a wrong URL encoding. /sap/opu/odata/sap/ZP2M_A_CONTRACT_SEARCH_HDR_CDS/ZP2M_A_CONTRACT_SEARCH_HDR?$filter=PurchaseContractID eq…
Adam K.
  • 11
  • 2
0
votes
2 answers

Google BigQuery - best way to wait for batch query to finish

I'm using Google BigQuery to run some queries on very large datasets. As I usually exceed some limits (e.g. query took longer than 6 hours) I want to use batch queries as they don't expect results to be done immediatly. After the results are…
smaica
  • 723
  • 2
  • 11
  • 26
0
votes
1 answer

How to pull data from SQL Server database using a stored procedure

I am tasked to create a stored procedure for a publisher application to retrieve employee data from our SQL Server. The aim: We have EmpTable (lets call this the source). We also have EmpData table. It has a column called 'Status' with a default…
BP1109
  • 31
  • 3
0
votes
1 answer

Insert multiple rows in cqlengine

I am stucking on insert/update multiple rows /approximately 800 rows/ to cassandra table by cqlengine. I do not want to use loop in python. I searched and find batch query. But can not use it. Please help me making batch query or give other…
Lkhagvasuren
  • 85
  • 1
  • 7
0
votes
1 answer

DynamoDB: Batch query items with highest range key given a set of hash key

I have a table Book with bookId and lastBorrowed as hash and range keys, respectively. Let's say each time a book is borrowed, a new row is created. (Yes, this is NOT sufficient and I can just add a column to keep track of the count and update…
0x56794E
  • 20,883
  • 13
  • 42
  • 58